Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_GRANT_DEFERRED_COST

Description Contains details behind the postings for grant deferred costs of indirect cost, cost share and revenue. The source document information and posting document information that supports the calculations of the costs.
Key & Frequency Multiple rows per grant ID.

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

FRRGRNH

FRRGRNH_ACCT_CODE

ACCOUNT_INDEX Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(6)

FRRGRNH

FRRGRNH_ACCI_CODE

ACTIVITY Code used to identify accounting data by activity. VARCHAR2(6)

FRRGRNH

FRRGRNH_ACTV_CODE

CHART_OF_ACCOUNTS Primary identification code for any chart of accounts that is used to uniquely identify that chart from any other in a multi-chart environment. VARCHAR2(1)

FRRGRNH

FRRGRNH_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts description. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart of accounts status. VARCHAR2(1)

FUNCTION

FOKODSF.F_GET_FINANCE_STATUS

COST_SHARE_RATE Cost share rate used to calculate cost share. NUMBER(7,4)

FRRGRNH

FRRGRNH_CS_RATE_PERCENT

CURRENT_DATE This is a the system current date (sysdate). DATE

NA

SYSDATE

DEBIT_CREDIT_IND Debit credit indicator of the transaction. VARCHAR2(1)

FRRGRNH

FRRGRNH_DR_CR_IND

DOCUMENT Journal voucher document number created for the deferred grant calculations. VARCHAR2(8)

FRRGRNH

FRRGRNH_DOC_CODE

DOCUMENT_JOB_NUMBER Job number assigned by job submission for this execution of the Deferred Grant Process. NUMBER

FRRGRNH

FRRGRNH_JOB_NUMBER

DOCUMENT_POSTING_DATE Date that the transactions, produced by the Deferred Grant Process, is used to update the ledgers. DATE

FRRGRNH

FRRGRNH_POSTING_DATE

DOCUMENT_RUN_DATE Date the Deferred Grant Process was run to generate this document. DATE

FRRGRNH

FRRGRNH_RUN_DATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

FISCAL_YEAR Unique identifier or code for the fiscal year in which the calculations are posted. VARCHAR2(4)

CALCULATION

TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY'

FUND Unique fiscal entity code used to post grant calculations. VARCHAR2(6)

FRRGRNH

FRRGRNH_FUND_CODE

GRANT_DEFERRED_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FRRGRNH

FRRGRNH_ACTIVITY_DATE

GRANT_DEFERRED_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

FRRGRNH

FRRGRNH_USER_ID

GRANT_ID This is the user-defined or system assigned Grant identification code. VARCHAR2(9)

FRRGRNH

FRRGRNH_GRNT_CODE

INDIRECT_COST_RATE Indicrect cost rate used to calculate indirect cost. NUMBER(7,4)

FRRGRNH

FRRGRNH_IC_RATE_PERCENT

LOCATION Code used to identify accounting data by physical location. VARCHAR2(6)

FRRGRNH

FRRGRNH_LOCN_CODE

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

ORGANIZATION_CODE Identification accounting code of the department. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORGN_CODE

ORIGINAL_DOCUMENT Original document number for which the calculations are being performed. VARCHAR2(8)

FRRGRNH

FRRGRNH_ORIG_DOC_CODE

ORIGINAL_RULE_CLASS   VARCHAR2(4)    
ORIG_ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_ACCT_CODE

ORIG_ACCOUNT_INDEX Original account index used to identify the accounting distribution used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_ACCI_CODE

ORIG_ACTIVITY Code used to identify accounting data by activity used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_ACTV_CODE

ORIG_DEBIT_CREDIT_IND Debit credit indicator of the transaction used in the originating document. VARCHAR2(1)

FRRGRNH

FRRGRNH_ORIG_DR_CR_IND

ORIG_FUND Unique fiscal entity code used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_FUND_CODE

ORIG_LOCATION Code used to identify accounting data by physical location used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_LOCN_CODE

ORIG_ORGANIZATION Identification accounting code of the department used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_ORGN_CODE

ORIG_PROGRAM User-defined value to the program classification structure as defined by the National Council of Higher Education Management Systems used in the originating transaction. VARCHAR2(6)

FRRGRNH

FRRGRNH_ORIG_PROG_CODE

ORIG_RULE_CLASS Original accounting transaction code defining rules used to control transaction updates to the ledgers for the grant calculations. VARCHAR2(4)

FRRGRNH

FRRGRNH_ORIG_RUCL_CODE

ORIG_RULE_CLASS_DESC Original rule class description. VARCHAR2(35)

FTVRUCL

FTVRUCL_TITLE

ORIG_TRANSACTION_AMOUNT transaction amount used in the originating document. NUMBER(17,2)

FRRGRNH

FRRGRNH_ORIG_TRANS_AMT

ORIG_TRANSACTION_DATE Transaction date used in the originating document. DATE

FRRGRNH

FRRGRNH_ORIG_TRANS_DATE

PROGRAM User-defined value to the program classification structure as defined by the National Council of Higher Education Management Systems. VARCHAR2(6)

FRRGRNH

FRRGRNH_PROG_CODE

REVENUE_EXISTS_IND Indicates whether revenue and accrual were calculated for this transaction. VARCHAR2(1)

FRRGRNH

FRRGRNH_REVENUE_EXISTS_IND

RULE_CLASS Accounting transaction code defining rules used to control transaction updates to the ledgers for the grant calculations. VARCHAR2(4)

FTVRUCL

FRRGRNH_RUCL_CODE

RULE_CLASS_DESC Rule class description. VARCHAR2(35)

FTVRUCL

FTVRUCL_TITLE

TRANSACTION_AMOUNT Amount of indirect cost, cost share, or revenue posted for grant calculations. NUMBER(17,2)

FRRGRNH

FRRGRNH_TRANS_AMT

TRANSACTION_DATE Transaction date of the document. DATE

FRRGRNH

FRRGRNH_TRANS_DATE

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: