Reporting View Target: GRANT_BILLING

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

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
CHART_OF_ACCOUNTS
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT

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

DECODE(FRRBDET_ACCT_CLASS_CODE)

NO
NO

ACCOUNT_CLASS_DESC Account class description. VARCHAR2(255)
FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO
NO

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

NA

NO
NO

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

FRRBDET_ACCT_CODE

NO
NO

BILL_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(255)
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(63)
FRRBDET

FRRBDET_ACCI_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

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

F_GET_FINANCE_STATUS

NO
NO

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

F_GET_FINANCE_STATUS

NO
NO

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

FRRBDET_ACTV_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

BILL_ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(63)
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(63)
FRRBDET

FRRBDET_ALTERNATE_FUND

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

BILL_ALTERNATE_FUND_STATUS Obtains current status of the associated fund. VARCHAR2(63)
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(63)
FRRBDET

FRRBDET_COAS_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

BILL_CHART_OF_ACCOUNTS_STATUS Status of the bill chart of accounts status. VARCHAR2(63)
FTVCOAS

FTVCOAS_STATUS_IND

NO
NO

BILL_DOCUMENT User defined or system assigned document number used in originating transaction. VARCHAR2(63)
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(63)
FRRBDET

FRRBDET_FUND_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

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

F_GET_FINANCE_STATUS

NO
NO

BILL_GRANT_ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)
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(63)
FRRBDET

FRRBDET_LOCN_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

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

F_GET_FINANCE_STATUS

NO
NO

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

FRRBDET_ORGN_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

BILL_ORGANIZATION_STATUS Extracted current status of the associated organization. VARCHAR2(63)
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(63)
FRRBDET

FRRBDET_PROG_CODE

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

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

F_GET_FINANCE_STATUS

NO
NO

BILL_REVERSAL_IND Indicates if a document was canceled or reversed. VARCHAR2(63)
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(63)
FRRBDET

FRRBDET_BILL_STATUS

NO
NO

BILL_STATUS_DESC Deciphers billing status as billed, unbilled, hold, withholding. VARCHAR2(255)
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(255)
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

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

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

FRVPMSC_LOC_NO

NO
NO

LONG_TITLE Grant long title or description. VARCHAR2(256)
FRBGRNT

FRBGRNT_LONG_TITLE

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NO
NO

PAYMENT_MANAGEMENT_SYS_DESC Payment management system description. VARCHAR2(255)
FRVPMSC

FRVPMSC_DESC

NO
NO

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

NA

NO
NO

SHORT_TITLE Grant short title or description. VARCHAR2(255)
FRBGRNT

FRBGRNT_TITLE

NO
NO

Ver: 9.2

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 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT

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(63)	CALCULATION	DECODE(FRRBDET_ACCT_CLASS_CODE)	NO	NO
ACCOUNT_CLASS_DESC	Account class description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BILL_ACCOUNT	Identifies the account appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_ACCT_CODE	NO	NO
BILL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(255)	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(63)	FRRBDET	FRRBDET_ACCI_CODE	NO	NO
BILL_ACCOUNT_INDEX_DESC	Retrieved description or title of the associated account index.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ACCOUNT_INDEX_STATUS	Extracted current status of the associated account index.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ACCOUNT_STATUS	Extracted current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ACTIVITY	Identifies the activity appearing on the accounting transaction primarily associated with the department.	VARCHAR2(63)	FRRBDET	FRRBDET_ACTV_CODE	NO	NO
BILL_ACTIVITY_DESC	Retrieved description or title of the associated activity.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ACTIVITY_STATUS	Extracted current status of the associated activity.	VARCHAR2(63)	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(63)	FRRBDET	FRRBDET_ALTERNATE_FUND	NO	NO
BILL_ALTERNATE_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ALTERNATE_FUND_STATUS	Obtains current status of the associated fund.	VARCHAR2(63)	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(63)	FRRBDET	FRRBDET_COAS_CODE	NO	NO
BILL_CHART_OF_ACCOUNTS_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_CHART_OF_ACCOUNTS_STATUS	Status of the bill chart of accounts status.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
BILL_DOCUMENT	User defined or system assigned document number used in originating transaction.	VARCHAR2(63)	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(63)	FRRBDET	FRRBDET_FUND_CODE	NO	NO
BILL_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_FUND_STATUS	Extracted current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	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(63)	FRRBDET	FRRBDET_LOCN_CODE	NO	NO
BILL_LOCATION_DESC	Retrieved description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_LOCATION_STATUS	Extracted current status of the associated location.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_ORGANIZATION	Identifies the department appearing on the accounting transaction.	VARCHAR2(63)	FRRBDET	FRRBDET_ORGN_CODE	NO	NO
BILL_ORGANIZATION_DESC	Retrieved description or title of the associated organization.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_ORGANIZATION_STATUS	Extracted current status of the associated organization.	VARCHAR2(63)	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(63)	FRRBDET	FRRBDET_PROG_CODE	NO	NO
BILL_PROGRAM_DESC	Retrieved description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BILL_PROGRAM_STATUS	Extracted current status of the associated program.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
BILL_REVERSAL_IND	Indicates if a document was canceled or reversed.	VARCHAR2(63)	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(63)	FRRBDET	FRRBDET_BILL_STATUS	NO	NO
BILL_STATUS_DESC	Deciphers billing status as billed, unbilled, hold, withholding.	VARCHAR2(255)	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(255)	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
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
LETTER_OF_CREDIT_NUMBER	Actual letter of credit number associated to the payment management system code.	VARCHAR2(63)	FRVPMSC	FRVPMSC_LOC_NO	NO	NO
LONG_TITLE	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
PAYMENT_MANAGEMENT_SYS_DESC	Payment management system description.	VARCHAR2(255)	FRVPMSC	FRVPMSC_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SHORT_TITLE	Grant short title or description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE	NO	NO