RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_GRANT_BILLING_DETAIL

Description Source composite view contains research accounting billing transaction details.

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(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 Amount posted for the transaction with the associated accounting distribution. NUMBER(12, 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 Amount of the transaction associated with the federal share. NUMBER(12, 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: 3.1