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

Ver: