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

Ver: 8.3