Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_CLASS	Account Class	Class extracted defines major accounting groups used in sponsored research as indirect costs, direct expense or cost share.	VARCHAR2(63)	CALCULATION	DECODE(FRRBDET_ACCT_CLASS_CODE)
ACCOUNT_CLASS_DESC	Account Class Description	Account class description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BILL_ACCOUNT	Bill Account	Identifies the account appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_ACCT_CODE
BILL_ACCOUNT_DESC	Bill Account Description	Retrieved description or title of the associated account.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_ACCOUNT_INDEX	Bill Account INDEX	Shorthand key used to default accounting elements. The accounting elements were changed, this index is no longer a true representation of the accounting elements utilized.	VARCHAR2(63)	FRRBDET	FRRBDET_ACCI_CODE
BILL_ACCOUNT_INDEX_DESC	Bill Account INDEX Description	Retrieved description or title of the associated account index.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_ACCOUNT_INDEX_STATUS	Bill Account INDEX Status	Extracted current status of the associated account index.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_ACCOUNT_STATUS	Bill Account Status	Extracted current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_ACTIVITY	Bill Activity	Identifies the activity appearing on the accounting transaction primarily associated with the department.	VARCHAR2(63)	FRRBDET	FRRBDET_ACTV_CODE
BILL_ACTIVITY_DESC	Bill Activity Description	Retrieved description or title of the associated activity.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_ACTIVITY_STATUS	Bill Activity Status	Extracted current status of the associated activity.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_ADJUSTED_DATE	Bill Adjusted Date	Date this accounting transaction was adjusted due to.	DATE	FRRBDET	FRRBDET_BILLING_ADJUSTED_DATE
BILL_ADJUSTED_INVOICE_NUMBER	Bill Adjusted Invoice Number	Unique invoice number assigned to the grant that was adjusted.	NUMBER	FRRBDET	FRRBDET_BILL_INV_ADJ_NO
BILL_ALTERNATE_FUND	Bill Alternate Fund	Fund code to be used as a non-award fund for posting the cost share credit distribution.	VARCHAR2(63)	FRRBDET	FRRBDET_ALTERNATE_FUND
BILL_ALTERNATE_FUND_DESC	Bill Alternate Fund Description	Retrieved description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_ALTERNATE_FUND_STATUS	Bill Alternate Fund Status	Obtains current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_CHART_OF_ACCOUNTS	Bill Chart Of Accounts	Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment. Used to post accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_COAS_CODE
BILL_CHART_OF_ACCOUNTS_DESC	Bill Chart Of Accounts Description	Retrieved description or title of the associated chart of accounts.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_CHART_OF_ACCOUNTS_STATUS	Bill Chart Of Accounts Status	Status of the bill chart of accounts status.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
BILL_DOCUMENT	Bill Document	User defined or system assigned document number used in originating transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_DOC_CODE
BILL_DOCUMENT_TYPE	Bill Document Type	System assigned number that identifies the type of document used in the original transaction.	NUMBER	FRRBDET	FRRBDET_DOC_SEQ_CODE
BILL_FUND	Bill Fund	Identifies the funding source appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_FUND_CODE
BILL_FUND_DESC	Bill Fund Description	Retrieved description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_FUND_STATUS	Bill Fund Status	Extracted current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_GRANT_ID	Bill Grant ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FRRBDET	FRRBDET_GRNT_CODE
BILL_HOLD_DATE	Bill Hold Date	Date this accounting transaction was temporarily put on hold.	DATE	FRRBDET	FRRBDET_HOLD_DATE
BILL_INVOICE_NUMBER	Bill Invoice Number	Unique invoice number assigned to the grant when it was billed.	NUMBER	FRRBDET	FRRBDET_BILL_INV_SEQ_NO
BILL_ITEM	Bill Item	System assigned one-up number for each item on the original document from purchasing payables. This is zero for general accounting type documents and any document using document level accounting.	NUMBER	FRRBDET	FRRBDET_ITEM_NUM
BILL_LOCATION	Bill Location	Identifies the location appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_LOCN_CODE
BILL_LOCATION_DESC	Bill Location Description	Retrieved description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_LOCATION_STATUS	Bill Location Status	Extracted current status of the associated location.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_ORGANIZATION	Bill Organization	Identifies the department appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_ORGN_CODE
BILL_ORGANIZATION_DESC	Bill Organization Description	Retrieved description or title of the associated organization.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_ORGANIZATION_STATUS	Bill Organization Status	Extracted current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_PERIOD_DATE	Bill Period Date	Original date this accounting transaction was processed into the billing detail table or the date the billing transaction was processed for billing.	DATE	FRRBDET	FRRBDET_BILLING_PERIOD_DATE
BILL_PROGRAM	Bill Program	Identifies the program appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_PROG_CODE
BILL_PROGRAM_DESC	Bill Program Description	Retrieved description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
BILL_PROGRAM_STATUS	Bill Program Status	Extracted current status of the associated program.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
BILL_REVERSAL_IND	Bill Reversal Indicator	Indicates if a document was canceled or reversed.	VARCHAR2(63)	FRRBDET	FRRBDET_REVERSAL_IND
BILL_RUN_DATE	Bill Run Date	Date this accounting transaction was actually billed to the agency.	DATE	FRRBDET	FRRBDET_BILL_RUN_DATE
BILL_SEQUENCE_NUMBER	Bill Sequence Number	System assigned one-up number for each accounting line assigned in the document.	NUMBER	FRRBDET	FRRBDET_SEQ_NUM
BILL_STATUS	Bill Status	Status of the transaction billed. Various values might be billed, unbilled, hold, withholding.	VARCHAR2(63)	FRRBDET	FRRBDET_BILL_STATUS
BILL_STATUS_DESC	Bill Status Description	Deciphers billing status as billed, unbilled, hold, withholding.	VARCHAR2(255)	CALCULATION	DECODE(FRRBDET_BILL_STATUS)
BILL_SUBMISSION_NUMBER	Bill Submission Number	Submission number used for documents that utilized resubmission features.	NUMBER	FRRBDET	FRRBDET_SUBMISSION_NUMBER
BILL_TRANSACTION_AMOUNT	Bill Transaction Amount	Amount posted for the transaction with the associated accounting distribution.	NUMBER	FRRBDET	FRRBDET_TRANS_AMT
BILL_TRANSACTION_DATE	Bill Transaction Date	Date the transaction was posted into the ledgers.	DATE	FRRBDET	FRRBDET_TRANS_DATE
BILL_TRANSACTION_DESC	Bill Transaction Description	Transaction accounting line short description.	VARCHAR2(255)	FRRBDET	FRRBDET_TRANS_DESC
BILL_TRAN_NUMBER	Bill Tran Number	One up system assigned number within the grant account. This number represents the billed transaction.	NUMBER	FRRBDET	FRRBDET_BILL_TRAN_NUMBER
FEDERAL_SHARE_AMOUNT	Federal Share Amount	Amount of the transaction associated with the federal share.	NUMBER	FRRBDET	FRRBDET_FED_SHARE_AMT
HOLD_RELEASE_DATE	Hold Release Date	Date represents the day this accounting transaction was released from the temporary hold to unbilled status.	DATE	FRRBDET	FRRBDET_RELEASE_DATE
LETTER_OF_CREDIT_NUMBER	Letter Of Credit Number	Actual letter of credit number associated to the payment management system code.	VARCHAR2(63)	FRVPMSC	FRVPMSC_LOC_NO
LONG_TITLE	Long Title	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE
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
PAYMENT_MANAGEMENT_SYS_CODE	Payment Management Sys Code	Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit.	VARCHAR2(63)	FRBGBIL	FRBGBIL_PMSC_CODE
PAYMENT_MANAGEMENT_SYS_DESC	Payment Management Sys Description	Payment management system description.	VARCHAR2(255)	FRVPMSC	FRVPMSC_DESC
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SHORT_TITLE	Short Title	Grant short title or description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE

Ver: 9.2