Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GRANT_BILLING_DETAIL

Description Contains details for billed and unbilled grant transactions. Reporting can be by grant, letter of credit, payment management system code, billing account distribution or document key, billing period date, and billing run and hold or release dates.
Key & Frequency One row per document per document type per sequence number per item per submission number per fund per account class per account per reversal indicator.
Recommended Search Columns BILL_DOCUMENT, BILL_DOCUMENT_TYPE, BILL_SEQUENCE_NUMBER, BILL_ITEM, BILL_SUBMISSION_NUMBER, BILL_REVERSAL_IND, ACCOUNT_CLASS, BILL_FUND, BILL_ACCOUNT
BILL_GRANT_ID
BILL_STATUS, BILL_GRANT_ID
GRANT_ID

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(63)

CALCULATION

DECODE(FRRBDET_ACCT_CLASS_CODE)

ACCOUNT_CLASS_DESC Account class description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BILL_ACCOUNT Identifies the account appearing on the accounting transaction. VARCHAR2(63)

FRRBDET

FRRBDET_ACCT_CODE

BILL_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(255)

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(63)

FRRBDET

FRRBDET_ACCI_CODE

BILL_ACCOUNT_INDEX_DESC Retrieved description or title of the associated account index. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_ACCOUNT_INDEX_STATUS Extracted current status of the associated account index. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

BILL_ACCOUNT_STATUS Extracted current status of the associated account. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

BILL_ACTIVITY Identifies the activity appearing on the accounting transaction primarily associated with the department. VARCHAR2(63)

FRRBDET

FRRBDET_ACTV_CODE

BILL_ACTIVITY_DESC Retrieved description or title of the associated activity. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(63)

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(63)

FRRBDET

FRRBDET_ALTERNATE_FUND

BILL_ALTERNATE_FUND_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_ALTERNATE_FUND_STATUS Obtains current status of the associated fund. VARCHAR2(63)

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(63)

FRRBDET

FRRBDET_COAS_CODE

BILL_CHART_OF_ACCOUNTS_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_DOCUMENT User defined or system assigned document number used in originating transaction. VARCHAR2(63)

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(63)

FRRBDET

FRRBDET_FUND_CODE

BILL_FUND_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_FUND_STATUS Extracted current status of the associated fund. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

BILL_GRANT_ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)

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(63)

FRRBDET

FRRBDET_LOCN_CODE

BILL_LOCATION_DESC Retrieved description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_LOCATION_STATUS Extracted current status of the associated location. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

BILL_ORGANIZATION Identifies the department appearing on the accounting transaction. VARCHAR2(63)

FRRBDET

FRRBDET_ORGN_CODE

BILL_ORGANIZATION_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_ORGANIZATION_STATUS Extracted current status of the associated organization. VARCHAR2(63)

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(63)

FRRBDET

FRRBDET_PROG_CODE

BILL_PROGRAM_DESC Retrieved description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BILL_PROGRAM_STATUS Extracted current status of the associated program. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

BILL_REVERSAL_IND Indicates if a document was canceled or reversed. VARCHAR2(63)

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(63)

FRRBDET

FRRBDET_BILL_STATUS

BILL_STATUS_DESC Deciphers billing status as billed, unbilled, hold, withholding. VARCHAR2(255)

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(255)

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

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

LETTER_OF_CREDIT_NUMBER Actual letter of credit number associated to the payment management system code. VARCHAR2(63)

FRVPMSC

FRVPMSC_LOC_NO

LONG_TITLE Grant long title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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 system description. VARCHAR2(255)

FRVPMSC

FRVPMSC_DESC

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

SHORT_TITLE Grant short title or description. VARCHAR2(255)

FRBGRNT

FRBGRNT_TITLE



Ver: 8.0