| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AGENCY_ADDRESS
|
Agency Address
|
Address type associated with this agency.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_AGENCY_ADDR_CODE
|
|
AGENCY_ADDRESS_SEQUENCE_NUMBER
|
Agency Address Sequence Number
|
Sequence number associated with this address type to uniquely identify the address.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_AGENCY_ADDR_SEQ_NUM
|
|
AGENCY_COMMITMENT_AMOUNT
|
Agency Commitment Amount
|
Maximum amount of money the agency commits to the grant. Informational only.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_MAX_FUNDING_AMT
|
|
AGENCY_CONTACT
|
Agency Contact
|
Name of the person to contact at the agency.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_AGENCY_CONTACT
|
|
AGENCY_EMAIL
|
Agency Email
|
Email address for the agency contact.
|
VARCHAR2(255)
|
FRBGRNT
|
FRBGRNT_AGENCY_EMAIL
|
|
AGENCY_ID
|
Agency ID
|
System generated or manually assigned id to uniquely identify an agency.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
|
AGENCY_NAME
|
Agency Name
|
Name of the agency.
|
VARCHAR2(255)
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
AGENCY_PHONE_TYPE
|
Agency Phone Type
|
Phone type associated with this agency.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_AGENCY_PHONE_TYPE
|
|
AGENCY_TELEPHONE_SEQ_NUMBER
|
Agency Telephone Sequence Number
|
Sequence number associated with this phone type to uniquely identify the phone number.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_AGENCY_TELE_SEQNO
|
|
AGENCY_UID
|
Agency UID
|
System generated unique internal identification number assigned to this organization entity.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_AGENCY_PIDM
|
|
ALTERNATE_STATUS_DESC
|
Alternate Status Description
|
Alternate status description.
|
VARCHAR2(255)
|
FRBGRNT
|
FRBGRNT_ALTERNATE_STATUS_DESC
|
|
BILLED_AR_ACCOUNT
|
Billed Ar Account
|
User defined account code to hold billing receivables once the granting agency is billed.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_BILLED_AR_ACCT_CODE
|
|
BILLED_AR_ACCOUNT_DESC
|
Billed Ar Account Description
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
BUDGET_PERIOD_END_DATE
|
Budget Period End Date
|
End date of the budget for this fund and grant.
|
DATE
|
FRVFUND
|
FRVFUND_BUDG_PRD_END_DATE
|
|
BUDGET_PERIOD_START_DATE
|
Budget Period Start Date
|
Start date of the budget for this fund and grant.
|
DATE
|
FRVFUND
|
FRVFUND_BUDG_PRD_START_DATE
|
|
CASH_RECEIPT_BANK
|
Cash Receipt Bank
|
User defined bank code used on all cash transactions in grant billing.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_CASH_RECEIPT_BANK_CODE
|
|
CASH_RECEIPT_BANK_DESC
|
Cash Receipt Bank Description
|
Name of the cash receipt bank code used for grant billing.
|
VARCHAR2(255)
|
GXVBANK
|
GXVBANK_ACCT_NAME
|
|
CASH_RECEIPT_BANK_ID
|
Cash Receipt Bank ID
|
ID of the bank where the installment has accounts.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
|
CASH_RECEIPT_BANK_NAME
|
Cash Receipt Bank Name
|
Name of the banking institution where the installment has accounts.
|
VARCHAR2(255)
|
GXVBANK SPRIDEN
|
GXVBANK_ACCT_NAME SPRIDEN_LAST_NAME
|
|
CASH_RECEIPT_BANK_UID
|
Cash Receipt Bank UID
|
The internal identification number of the bank where the installment has accounts.
|
NUMBER
|
GXVBANK
|
GXVBANK_BANK_CODE_PIDM
|
|
CATEGORY
|
Category
|
Identifies sponsored programs category. Examples, federal, non-federal.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_CATEGORY
|
|
CATEGORY_DESC
|
Category Description
|
Grant category description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
CHART_OF_ACCOUNTS
|
Chart Of Accounts
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_COAS_CODE
|
|
CHART_OF_ACCOUNTS_COST
|
Chart Of Accounts Cost
|
Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment specifically pertaining to Indirect cost and cost share codes.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_COAS_CODE_IC_CS
|
|
CHART_OF_ACCOUNTS_COST_DESC
|
Chart Of Accounts Cost Description
|
Chart of accounts extracted description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CHART_OF_ACCOUNTS_COST_STATUS
|
Chart Of Accounts Cost Status
|
Status of the chart of accounts cost.
|
VARCHAR2(63)
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
|
CHART_OF_ACCOUNTS_DESC
|
Chart Of Accounts Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CHART_OF_ACCOUNTS_STATUS
|
Chart Of Accounts Status
|
Status of the chart of account.
|
VARCHAR2(63)
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
|
CONSTRUCTION_PLANT_FUND
|
Construction Plant Fund
|
User identified fund where the asset resulting from the construction project is capitalized. Information only.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FUND_CODE_PLANT_CONP
|
|
CONSTRUCTION_PLANT_FUND_DESC
|
Construction Plant Fund Description
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CONSTR_IN_PROGR_ACCOUNT
|
Constr IN Progr Account
|
User defined account where the construction in progress is capitalized. Informational only.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_ACCT_CODE_CIP
|
|
CONSTR_IN_PROGR_ACCOUNT_DESC
|
Constr IN Progr Account Description
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CONSTR_PROJECT_COMPLETE_DATE
|
Constr Project Complete Date
|
Construction project completion date. Informational only.
|
DATE
|
FTVFUND
|
FTVFUND_PROJ_COMPLETE_DATE
|
|
CONSTR_PROJECT_DESC
|
Constr Project Description
|
Construction project description.
|
VARCHAR2(255)
|
FTVFUND
|
FTVFUND_PROJ_DESC
|
|
CONSTR_PROJECT_END_DATE
|
Constr Project End Date
|
Construction project end date. Informational only.
|
DATE
|
FTVFUND
|
FTVFUND_PROJ_END_DATE_CONP
|
|
CONSTR_PROJECT_FMGR_FIRST_NAME
|
Construction Project Financial Manager First Name
|
Extracted first name of the construction project manager.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
CONSTR_PROJECT_FMGR_ID
|
Construction Project Financial Manager ID
|
Extracted identification of the construction project manager.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
CONSTR_PROJECT_FMGR_LAST_NAME
|
Construction Project Financial Manager Last Name
|
Extracted last name of the construction project manager.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
CONSTR_PROJECT_FMGR_MID_NAME
|
Construction Project Financial Manager Mid Name
|
Extracted middle name of the construction project manager.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
CONSTR_PROJECT_FMGR_UID
|
Constr Project Fmgr UID
|
Internally generated by the system to uniquely identify the person or entity.
|
NUMBER
|
FTVFUND
|
FTVFUND_FMGR_CODE_PIDM_CONP
|
|
CONSTR_PROJECT_NUMBER
|
Constr Project Number
|
User defined number assigned to a construction project.
|
VARCHAR2(255)
|
FTVFUND
|
FTVFUND_CONP_PROJ_NUM
|
|
CONSTR_PROJECT_START_DATE
|
Constr Project Start Date
|
Construction project start date. Informational only.
|
DATE
|
FTVFUND
|
FTVFUND_PROJ_START_DATE_CONP
|
|
COST_SHARE_BASE
|
Cost Share Base
|
Code defines the base information for cost share calculations.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_BASI_CODE_CS
|
|
COST_SHARE_BASE_DESC
|
Cost Share Base Description
|
Cost share base description.
|
VARCHAR2(255)
|
FRVBASI
|
FRVBASI_DESC
|
|
COST_SHARE_CHARGE
|
Cost Share Charge
|
Code defines account's and percentage of the charge.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_CSTA_CODE_CHARGE
|
|
COST_SHARE_CHARGE_DESC
|
Cost Share Charge Description
|
Cost share charge description.
|
VARCHAR2(255)
|
FRVCSTA
|
FRVCSTA_DESC
|
|
COST_SHARE_DISTRIBUTION
|
Cost Share Distribution
|
Code defines the account distribution for indirect cost.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_CSTD_CODE_DISTR
|
|
COST_SHARE_DISTRIBUTION_DESC
|
Cost Share Distribution Description
|
Cost share distribution description.
|
VARCHAR2(255)
|
FRVCSTD
|
FRVCSTD_DESC
|
|
COST_SHARE_RATE
|
Cost Share Rate
|
Cost share rate for this grant.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_CSTR_CODE_RATE
|
|
COST_SHARE_RATE_DESC
|
Cost Share Rate Description
|
Cost share rate description.
|
VARCHAR2(255)
|
FRVCSTR
|
FRVCSTR_DESC
|
|
CUMULATIVE_AMOUNT
|
Cumulative Amount
|
Cumulative funding amount of the grant, received from the agency to date. Informational only.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_CUM_FUNDING_AMT
|
|
CURRENT_YEAR_AMOUNT
|
Current Year Amount
|
Current year funding amount of the grant, committed by the agency. Informational only.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_CURRENT_FUNDING_AMT
|
|
ESTIMATED_CUM_COST_AMOUNT
|
Estimated Cum Cost Amount
|
Value of the estimated total cost of the construction project.
|
NUMBER
|
FTVFUND
|
FTVFUND_CUM_COST_AMT
|
|
EXPENDITURE_END_DATE
|
Expenditure End Date
|
Ending period date for expenditure activity.
|
DATE
|
FRBGRNT
|
FRBGRNT_EXPEND_END_DATE
|
|
FEDERAL_IDENTIFICATION
|
Federal ID
|
Identifies the Catalog of Federal Domestic Assistance code.
|
VARCHAR2(63)
|
FRVCFDA
|
FRVCFDA_CFDA_CODE
|
|
FEDERAL_IDENTIFICATION_DESC
|
Federal ID Description
|
Description of the Catalog of Federal Domestic Assistance.
|
VARCHAR2(255)
|
FRVCFDA
|
FRVCFDA_TITLE
|
|
FEDERAL_IDENTIFICATION_UID
|
Federal ID UID
|
System generated unique internal identification number assigned to the Catalog of Federal Domestic Assistance code.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_CFDA_INTERNAL_ID_NO
|
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FUND_CODE
|
|
FUND_BANK
|
Fund Bank
|
User-defined value which is used for identification purposes on all cash transactions.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_BANK_CODE
|
|
FUND_BANK_DESC
|
Fund Bank Description
|
The name of the banking institution where the installment has accounts.
|
VARCHAR2(255)
|
GXVBANK
|
GXVBANK_ACCT_NAME
|
|
FUND_BANK_ID
|
Fund Bank ID
|
ID of the bank where the installment has accounts.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
|
FUND_BANK_NAME
|
Fund Bank Name
|
Name of the banking institution where the installment has accounts.
|
VARCHAR2(255)
|
GXVBANK SPRIDEN
|
GXVBANK_ACCT_NAME SPRIDEN_LAST_NAME
|
|
FUND_BANK_UID
|
Fund Bank UID
|
The internal identification number of the bank where the installment has accounts.
|
NUMBER
|
GXVBANK
|
GXVBANK_BANK_CODE_PIDM
|
|
FUND_COST_SHARE_BASE
|
Fund Cost Share Base
|
Code defines the base information for cost share calculations.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_BASI_CODE_CS
|
|
FUND_COST_SHARE_BASE_DESC
|
Fund Cost Share Base Description
|
Cost share code extracted description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_COST_SHARE_CHARGE
|
Fund Cost Share Charge
|
Code defines account's and percentage of the charge.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_CSTA_CODE_CHARGE
|
|
FUND_COST_SHARE_CHARGE_DESC
|
Fund Cost Share Charge Description
|
Cost share credit code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_COST_SHARE_DISTRIB
|
Fund Cost Share Distribution
|
Code defines the account distribution for indirect cost.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_CSTD_CODE_DISTR
|
|
FUND_COST_SHARE_DISTRIB_DESC
|
Fund Cost Share Distribution Description
|
Cost share distribution code extracted description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_COST_SHARE_RATE
|
Fund Cost Share Rate
|
Cost chart rate for this grant fund.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_CSTR_CODE_RATE
|
|
FUND_COST_SHARE_RATE_DESC
|
Fund Cost Share Rate Description
|
Cost share rate code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_DESC
|
Fund Description
|
Fund code description or title.
|
VARCHAR2(255)
|
FTVFUND
|
FTVFUND_TITLE
|
|
FUND_EXPENDITURE_END_DATE
|
Fund Expenditure End Date
|
Ending period date for expenditure activity.
|
DATE
|
FTVFUND
|
FTVFUND_EXPEND_END_DATE
|
|
FUND_FINANCIAL_MANAGER_ID
|
Fund Financial Manager ID
|
System generated or manually assigned ID that uniquely identifies the financial manager.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
FUND_FINANCIAL_MANAGER_NAME
|
Fund Financial Manager Name
|
Combination of the person's last name, first name, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
FUND_FINANCIAL_MANAGER_UID
|
Fund Financial Manager UID
|
System generated, unique, internal identification number assigned to the financial manager associated with this fund.
|
NUMBER
|
FTVFUND
|
FTVFUND_FMGR_CODE_PIDM
|
|
FUND_FMGR_CITY
|
Fund Fmgr City
|
City associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
|
FUND_FMGR_COUNTY
|
Fund Fmgr County
|
County code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
|
FUND_FMGR_COUNTY_DESC
|
Fund Fmgr County Description
|
County address name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_FMGR_FIRST_NAME
|
Fund Fmgr First Name
|
Financial manager's first or given name.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME
|
|
FUND_FMGR_LAST_NAME
|
Fund Fmgr Last Name
|
Fund manager's last name or surname.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME
|
|
FUND_FMGR_MIDDLE_NAME
|
Fund Fmgr Middle Name
|
Financial manager's middle name.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI
|
|
FUND_FMGR_NATION
|
Fund Fmgr Nation
|
Nation code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
|
FUND_FMGR_NATION_DESC
|
Fund Fmgr Nation Description
|
Name of the nation.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
|
FUND_FMGR_POSTAL_CODE
|
Fund Fmgr Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
|
FUND_FMGR_STATE_PROVINCE
|
Fund Fmgr State Province
|
State/Province code for the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
|
FUND_FMGR_STATE_PROVINCE_DESC
|
Fund Fmgr State Province Description
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
FUND_FMGR_STREET_LINE1
|
Fund Fmgr Street Line 1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
|
FUND_FMGR_STREET_LINE2
|
Fund Fmgr Street Line 2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
|
FUND_FMGR_STREET_LINE3
|
Fund Fmgr Street Line 3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
|
FUND_FMGR_STREET_LINE4
|
Fund Fmgr Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
|
FUND_INDIRECT_COST_BASE
|
Fund Indirect Cost Base
|
Code used to define indirect cost calculations.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_BASI_CODE_IC
|
|
FUND_INDIRECT_COST_BASE_DESC
|
Fund Indirect Cost Base Description
|
Indirect cost base code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_INDIRECT_COST_CHARGE
|
Fund Indirect Cost Charge
|
Code identifies the account's and the percentage of the charge.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_INDA_CODE_CHARGE
|
|
FUND_INDIRECT_COST_CHARGE_DESC
|
Fund Indirect Cost Charge Description
|
Indirect cost charge code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_INDIRECT_COST_DISTRI
|
Fund Indirect Cost Distribution
|
Code identifies the accounting distribution for indirect cost.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_INDD_CODE_DISTR
|
|
FUND_INDIRECT_COST_DISTRI_DESC
|
Fund Indirect Cost Distribution Description
|
Indirect cost distribution description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_INDIRECT_COST_RATE
|
Fund Indirect Cost Rate
|
Indirect cost rate percentage for the grant fund.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_INDR_CODE_RATE
|
|
FUND_INDIRECT_COST_RATE_DESC
|
Fund Indirect Cost Rate Description
|
Indirect cost rate code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
FUND_PREDECESSOR
|
Fund Predecessor
|
Next prior level fund associated with the fund code used to build a hierarchy.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FUND_CODE_PRED
|
|
FUND_PREDECESSOR_DESC
|
Fund Predecessor Description
|
Associated fund description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
FUND_STATUS
|
Fund Status
|
Current status of the associated fund.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_STATUS_IND
|
|
FUND_TERMINATION_DATE
|
Fund Termination Date
|
Date when the fund is no longer in effect.
|
DATE
|
FTVFUND
|
FTVFUND_TERM_DATE
|
|
FUND_TYPE
|
Fund Type
|
Fund type code to be associated with the fund as defined by the institution.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FTYP_CODE
|
|
FUND_TYPE_DESC
|
Fund Type Description
|
Fund type code description or title.
|
VARCHAR2(255)
|
FTVFTYP
|
FTVFTYP_TITLE
|
|
GRANT_FUND_ACTIVITY_DATE
|
Grant Fund Activity Date
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
FRVFUND
|
FRVFUND_ACTIVITY_DATE
|
|
GRANT_FUND_USER_ID
|
Grant Fund User ID
|
Unique identification code of the user who entered or last updated the grant fund.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_USER_ID
|
|
GRANT_ID
|
Grant ID
|
Unique user defined or system generated one-up number for this grant.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_CODE
|
|
GRANT_LONG_TITLE
|
Grant Long Title
|
Grant long title or description.
|
VARCHAR2(256)
|
FRBGRNT
|
FRBGRNT_LONG_TITLE
|
|
GRANT_SHORT_TITLE
|
Grant Short Title
|
Shortened name or title for the grant.
|
VARCHAR2(255)
|
FRBGRNT
|
FRBGRNT_TITLE
|
|
GRANT_TERMINATION_DATE
|
Grant Termination Date
|
Date when this grant is no longer in effect. The time between the project end date and termination date defines the trail out period.
|
DATE
|
FRBGRNT
|
FRBGRNT_TERM_DATE
|
|
GRANT_TYPE
|
Grant Type
|
Grant type code to reflect if this is a grant, contract, cooperative agreement, etc.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_GRANT_TYPE
|
|
GRANT_TYPE_DESC
|
Grant Type Description
|
Retrieved description for grant type.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
INDIRECT_COST_BASE
|
Indirect Cost Base
|
Code used to define indirect cost calculations.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_BASI_CODE_IC
|
|
INDIRECT_COST_BASE_DESC
|
Indirect Cost Base Description
|
Indirect cost base code description.
|
VARCHAR2(255)
|
FRVBASI
|
FRVBASI_DESC
|
|
INDIRECT_COST_CHARGE
|
Indirect Cost Charge
|
Code identifies the account's and the percentage of the charge.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_INDA_CODE_CHARGE
|
|
INDIRECT_COST_CHARGE_DESC
|
Indirect Cost Charge Description
|
Indirect cost charge code description.
|
VARCHAR2(255)
|
FRVINDA
|
FRVINDA_DESC
|
|
INDIRECT_COST_DISTRIBUTION
|
Indirect Cost Distribution
|
Code identifies the accounting distribution for indirect cost.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_INDD_CODE_DISTR
|
|
INDIRECT_COST_DISTRIB_DESC
|
Indirect Cost Distribution Description
|
Indirect cost distribution description.
|
VARCHAR2(255)
|
FRVINDD
|
FRVINDD_DESC
|
|
INDIRECT_COST_RATE
|
Indirect Cost Rate
|
Indirect cost rate percentage for this grant.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_INDR_CODE_RATE
|
|
INDIRECT_COST_RATE_DESC
|
Indirect Cost Rate Description
|
Indirect cost rate code description.
|
VARCHAR2(255)
|
FRVINDR
|
FRVINDR_DESC
|
|
MAXIMUM_CONSTR_PROJECT_AMOUNT
|
Maximum Constr Project Amount
|
Value of estimated funding for this construction project.
|
NUMBER
|
FTVFUND
|
FTVFUND_MAX_CONSTR_AMT
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
MULTI_YEAR_ENCUMBRANCE_IND
|
Multi Year Encumbrance Indicator
|
Indicates whether multi-year labor encumbering is utilized with a fund/grant combination.
|
VARCHAR2(1)
|
FRVFUND
|
FRVFUND_ENC_MULT_YEAR_IND
|
|
PRINCIPAL_INVESTIGATOR_FNAME
|
Principal Investigator First Name
|
Current first name of the principal investigator.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME
|
|
PRINCIPAL_INVESTIGATOR_ID
|
Principal Investigator ID
|
Current identification number of the principal investigator.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
PRINCIPAL_INVESTIGATOR_LNAME
|
Principal Investigator Last Name
|
Current last name of the principal investigator.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME
|
|
PRINCIPAL_INVESTIGATOR_MNAME
|
Principal Investigator Middle Name
|
Current middle name of the principal investigator.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI
|
|
PRINCIPAL_INVESTIGATOR_NAME
|
Principal Investigator Name
|
Combination of the person's last name, first name, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PRINCIPAL_INVESTIGATOR_TITLE
|
Principal Investigator Title
|
Official position/title that belongs to the principal investigator.
|
VARCHAR2(255)
|
FRRGRPI
|
FRRGRPI_TITLE
|
|
PRINCIPAL_INVESTIGATOR_UID
|
Principal Investigator UID
|
System internally generated id to uniquely identify the principal investigator for this grant.
|
NUMBER
|
FRBGRNT
|
FRBGRNT_PI_PIDM
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PROJECT_CLOSE_IND
|
Project Close Indicator
|
Determines if the construction project is closed or not. Informational only.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_CLOSE_PROJ_IND
|
|
PROJECT_END_DATE
|
Project End Date
|
End date is the last day of the grant period.
|
DATE
|
FRBGRNT
|
FRBGRNT_PROJECT_END_DATE
|
|
PROJECT_START_DATE
|
Project Start Date
|
Date the agency awarded the grant.
|
DATE
|
FRBGRNT
|
FRBGRNT_PROJECT_START_DATE
|
|
PROPOSAL
|
Proposal
|
Proposal submitted to the agency that has now been awarded this grant.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_PROP_CODE
|
|
PROPOSAL_LONG_TITLE
|
Proposal Long Title
|
Long description or title of the grant proposal.
|
VARCHAR2(256)
|
FRBPROP
|
FRBPROP_LONG_TITLE
|
|
PROPOSAL_SHORT_TITLE
|
Proposal Short Title
|
Short description or title of the grant proposal.
|
VARCHAR2(255)
|
FRBPROP
|
FRBPROP_TITLE
|
|
RELATED_GRANT
|
Related Grant
|
Grant code of a prior defined grant used to copy data from into this grant.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_GRNT_CODE_RELATED
|
|
RESPONSIBLE_ORGANIZATION_CODE
|
Responsible Organization Code
|
Organization code of the responsible administrative office for this grant.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_ORGN_CODE_RESP_OFFICE
|
|
RESPONSIBLE_ORGANIZATION_DESC
|
Responsible Organization Description
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
RESPONSIBLE_ORGN_STATUS
|
Responsible Organization Status
|
Current status of the associated organization.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
|
REVENUE_ACCRUAL_ACCOUNT
|
Revenue Accrual Account
|
Revenue account code for this fund used for revenue recognition.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_ACCT_CODE_REV
|
|
REVENUE_ACCRUAL_ACCOUNT_DESC
|
Revenue Accrual Account Description
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
SOURCE_FUND
|
Source Fund
|
Identification of the source of funds for the construction project. Informational only.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FUND_CODE_SOURCE
|
|
SOURCE_FUND_DESC
|
Source Fund Description
|
Retrieve description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
SPONSOR_NUMBER
|
Sponsor Number
|
Sponsor agency's reference number.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_SPONSOR_ID
|
|
STATUS
|
Status
|
Status of the grant, with most common values as Inactive or Active.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_STATUS_CODE
|
|
STATUS_DATE
|
Status Date
|
Last date a status change occurred for this grant.
|
DATE
|
FRBGRNT
|
FRBGRNT_STATUS_DATE
|
|
STATUS_DESC
|
Status Description
|
Retrieved description for grant status.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
STATUS_FISCAL_PERIOD
|
Status Fiscal Period
|
Extracted fiscal period in which the last status date occurred.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FISCAL_PERIOD
|
|
STATUS_FISCAL_YEAR
|
Status Fiscal Year
|
Extracted fiscal year in which the last status date occurred.
|
VARCHAR2(63)
|
FUNCTION
|
FOFYCNV
|
|
SUBCATEGORY
|
Subcategory
|
Sub category code for grant and proposal classification such as corporation, foundation, state, etc.
|
VARCHAR2(63)
|
FRBGRNT
|
FRBGRNT_SUB_CATEGORY
|
|
SUBCATEGORY_DESC
|
Subcategory Description
|
Retrieved description for grant or proposal sub category.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
UNBILLED_ACCRUAL_ACCOUNT
|
Unbilled Accrual Account
|
Unbilled accrual account for this fund used for revenue recognition.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_ACCT_CODE_ACCR
|
|
UNBILLED_ACCRUAL_ACCOUNT_DESC
|
Unbilled Accrual Account Description
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
WITHHOLDING_AMOUNT
|
Withholding Amount
|
Amount to withhold from the billed agency.
|
NUMBER
|
FRVFUND
|
FRVFUND_WITHHOLDING_AMT
|
|
WITHHOLDING_AR_ACCOUNT
|
Withholding Ar Account
|
User defined account code to hold withholding billing receivables once the granting agency is billed.
|
VARCHAR2(63)
|
FRVFUND
|
FRVFUND_WHOLDING_AR_ACCT_CODE
|
|
WITHHOLDING_AR_ACCOUNT_DESC
|
Withholding Ar Account Description
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
WITHHOLDING_PERCENT
|
Withholding Percent
|
Percent of the amount to be debited to the withholding receivable account for each bill generated.
|
NUMBER
|
FRVFUND
|
FRVFUND_WITHHOLDING_PERCENT
|