Target Column |
Business Definition |
Database Data Type |
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
|
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
|
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
|
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
|
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
|
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
|
FRRBDET
|
FRRBDET_SUBMISSION_NUMBER
|
BILL_TRANSACTION_AMOUNT
|
Amount posted for the transaction with the associated accounting distribution.
|
NUMBER
|
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
|
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
|
Amount of the transaction associated with the federal share.
|
NUMBER
|
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
|