Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT_CLASS	Class extracted defines major accounting groups used in sponsored research as indirect costs, direct expense or cost share.	VARCHAR2(1)	CALCULATION	DECODE(FRRBDET_ACCT_CLASS_CODE)	NO	NO
ACCOUNT_CLASS_DESC	Account class description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
BILL_ACCOUNT	Identifies the account appearing on the accounting transaction.	VARCHAR2(6)	FRRBDET	FRRBDET_ACCT_CODE	NO	NO
BILL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
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(6)	FRRBDET	FRRBDET_ACCI_CODE	NO	NO
BILL_ACCOUNT_INDEX_DESC	Retrieved description or title of the associated account index.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ACCOUNT_INDEX_STATUS	Extracted current status of the associated account index.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ACCOUNT_STATUS	Extracted current status of the associated account.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ACTIVITY	Identifies the activity appearing on the accounting transaction primarily associated with the department.	VARCHAR2(6)	FRRBDET	FRRBDET_ACTV_CODE	NO	NO
BILL_ACTIVITY_DESC	Retrieved description or title of the associated activity.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ACTIVITY_STATUS	Extracted current status of the associated activity.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ADJUSTED_DATE	Date this accounting transaction was adjusted due to.	DATE	FRRBDET	FRRBDET_BILLING_ADJUSTED_DATE	NO	NO
BILL_ADJUSTED_INVOICE_NUMBER	Unique invoice number assigned to the grant that was adjusted.	NUMBER	FRRBDET	FRRBDET_BILL_INV_ADJ_NO	NO	NO
BILL_ALTERNATE_FUND	Fund code to be used as a non-award fund for posting the cost share credit distribution.	VARCHAR2(6)	FRRBDET	FRRBDET_ALTERNATE_FUND	NO	NO
BILL_ALTERNATE_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ALTERNATE_FUND_STATUS	Obtains current status of the associated fund.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
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(1)	FRRBDET	FRRBDET_COAS_CODE	NO	NO
BILL_CHART_OF_ACCOUNTS_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_DOCUMENT	User defined or system assigned document number used in originating transaction.	VARCHAR2(8)	FRRBDET	FRRBDET_DOC_CODE	NO	NO
BILL_DOCUMENT_TYPE	System assigned number that identifies the type of document used in the original transaction.	NUMBER	FRRBDET	FRRBDET_DOC_SEQ_CODE	NO	NO
BILL_FUND	Identifies the funding source appearing on the accounting transaction.	VARCHAR2(6)	FRRBDET	FRRBDET_FUND_CODE	NO	NO
BILL_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_FUND_STATUS	Extracted current status of the associated fund.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)	FRRBDET	FRRBDET_GRNT_CODE	NO	NO
BILL_HOLD_DATE	Date this accounting transaction was temporarily put on hold.	DATE	FRRBDET	FRRBDET_HOLD_DATE	NO	NO
BILL_INVOICE_NUMBER	Unique invoice number assigned to the grant when it was billed.	NUMBER	FRRBDET	FRRBDET_BILL_INV_SEQ_NO	NO	NO
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	NO	NO
BILL_LOCATION	Identifies the location appearing on the accounting transaction.	VARCHAR2(6)	FRRBDET	FRRBDET_LOCN_CODE	NO	NO
BILL_LOCATION_DESC	Retrieved description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_LOCATION_STATUS	Extracted current status of the associated location.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ORGANIZATION	Identifies the department appearing on the accounting transaction.	VARCHAR2(6)	FRRBDET	FRRBDET_ORGN_CODE	NO	NO
BILL_ORGANIZATION_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ORGANIZATION_STATUS	Extracted current status of the associated organization.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
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	NO	NO
BILL_PROGRAM	Identifies the program appearing on the accounting transaction.	VARCHAR2(6)	FRRBDET	FRRBDET_PROG_CODE	NO	NO
BILL_PROGRAM_DESC	Retrieved description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_PROGRAM_STATUS	Extracted current status of the associated program.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_REVERSAL_IND	Indicates if a document was canceled or reversed.	VARCHAR2(1)	FRRBDET	FRRBDET_REVERSAL_IND	NO	NO
BILL_RUN_DATE	Date this accounting transaction was actually billed to the agency.	DATE	FRRBDET	FRRBDET_BILL_RUN_DATE	NO	NO
BILL_SEQUENCE_NUMBER	System assigned one-up number for each accounting line assigned in the document.	NUMBER	FRRBDET	FRRBDET_SEQ_NUM	NO	NO
BILL_STATUS	Status of the transaction billed. Various values might be billed, unbilled, hold, withholding.	VARCHAR2(1)	FRRBDET	FRRBDET_BILL_STATUS	NO	NO
BILL_STATUS_DESC	The description of the billing status.	VARCHAR2(30)	CALCULATION	DECODE(FRRBDET_BILL_STATUS)	NO	NO
BILL_SUBMISSION_NUMBER	Submission number used for documents that utilized resubmission features.	NUMBER	FRRBDET	FRRBDET_SUBMISSION_NUMBER	NO	NO
BILL_TRANSACTION_AMOUNT	Amount posted for the transaction with the associated accounting distribution.	NUMBER	FRRBDET	FRRBDET_TRANS_AMT	NO	NO
BILL_TRANSACTION_DATE	Date the transaction was posted into the ledgers.	DATE	FRRBDET	FRRBDET_TRANS_DATE	NO	NO
BILL_TRANSACTION_DESC	Transaction accounting line short description.	VARCHAR2(35)	FRRBDET	FRRBDET_TRANS_DESC	NO	NO
BILL_TRAN_NUMBER	One up system assigned number within the grant account. This number represents the billed transaction.	NUMBER	FRRBDET	FRRBDET_BILL_TRAN_NUMBER	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FEDERAL_SHARE_AMOUNT	Amount of the transaction associated with the federal share.	NUMBER	FRRBDET	FRRBDET_FED_SHARE_AMT	NO	NO
HOLD_RELEASE_DATE	Date represents the day this accounting transaction was released from the temporary hold to unbilled status.	DATE	FRRBDET	FRRBDET_RELEASE_DATE	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: