Composite View Target: AF_GRANT_DEFERRED

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 Name Business Definition Database Data Type Domain Value Source Name Source Column

ACCOUNT 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 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 Activity Code used to identify accounting data by activity. VARCHAR2(6)
FRRGRNH

FRRGRNH_ACTV_CODE

CHART_OF_ACCOUNTS 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 Chart of accounts description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Chart of accounts status. VARCHAR2(1)
FUNCTION

FOKODSF.F_GET_FINANCE_STATUS

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

FRRGRNH_CS_RATE_PERCENT

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

SYSDATE

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

FRRGRNH_DR_CR_IND

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

FRRGRNH_DOC_CODE

DOCUMENT_JOB_NUMBER 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 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 Document Run Date Date the Deferred Grant Process was run to generate this document. DATE
FRRGRNH

FRRGRNH_RUN_DATE

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

NA

FISCAL_YEAR 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 Fund Unique fiscal entity code used to post grant calculations. VARCHAR2(6)
FRRGRNH

FRRGRNH_FUND_CODE

GRANT_DEFERRED_ACTIVITY_DATE 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 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 Grant ID This is the user-defined or system assigned Grant identification code. VARCHAR2(9)
FRRGRNH

FRRGRNH_GRNT_CODE

INDIRECT_COST_RATE Indirect Cost Rate Indicrect cost rate used to calculate indirect cost. NUMBER(7,4)
FRRGRNH

FRRGRNH_IC_RATE_PERCENT

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

FRRGRNH_LOCN_CODE

MIF_DESC MIF Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)
NA

NA

MIF_VALUE MIF Value Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)
NA

NA

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

FRRGRNH_ORGN_CODE

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

FRRGRNH_ORIG_DOC_CODE

ORIGINAL_RULE_CLASS Original Rule Class VARCHAR2(4)

ORIG_ACCOUNT 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 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 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 Orig Debit Credit Indicator Debit credit indicator of the transaction used in the originating document. VARCHAR2(1)
FRRGRNH

FRRGRNH_ORIG_DR_CR_IND

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

FRRGRNH_ORIG_FUND_CODE

ORIG_LOCATION 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 Orig Organization Identification accounting code of the department used in the originating transaction. VARCHAR2(6)
FRRGRNH

FRRGRNH_ORIG_ORGN_CODE

ORIG_PROGRAM 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 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 Orig Rule Class Description Original rule class description. VARCHAR2(35)
FTVRUCL

FTVRUCL_TITLE

ORIG_TRANSACTION_AMOUNT Orig Transaction Amount transaction amount used in the originating document. NUMBER(17,2)
FRRGRNH

FRRGRNH_ORIG_TRANS_AMT

ORIG_TRANSACTION_DATE Orig Transaction Date Transaction date used in the originating document. DATE
FRRGRNH

FRRGRNH_ORIG_TRANS_DATE

PROGRAM 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 Revenue Exists Indicator Indicates whether revenue and accrual were calculated for this transaction. VARCHAR2(1)
FRRGRNH

FRRGRNH_REVENUE_EXISTS_IND

RULE_CLASS 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 Rule class description. VARCHAR2(35)
FTVRUCL

FTVRUCL_TITLE

TRANSACTION_AMOUNT 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 Transaction date of the document. DATE
FRRGRNH

FRRGRNH_TRANS_DATE

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

NA

Ver:

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	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	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	Activity	Code used to identify accounting data by activity.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ACTV_CODE
CHART_OF_ACCOUNTS	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	Chart of accounts description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Chart of accounts status.	VARCHAR2(1)	FUNCTION	FOKODSF.F_GET_FINANCE_STATUS
COST_SHARE_RATE	Cost Share Rate	Cost share rate used to calculate cost share.	NUMBER(7,4)	FRRGRNH	FRRGRNH_CS_RATE_PERCENT
CURRENT_DATE	Current Date	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DEBIT_CREDIT_IND	Debit Credit Indicator	Debit credit indicator of the transaction.	VARCHAR2(1)	FRRGRNH	FRRGRNH_DR_CR_IND
DOCUMENT	Document	Journal voucher document number created for the deferred grant calculations.	VARCHAR2(8)	FRRGRNH	FRRGRNH_DOC_CODE
DOCUMENT_JOB_NUMBER	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	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	Document Run Date	Date the Deferred Grant Process was run to generate this document.	DATE	FRRGRNH	FRRGRNH_RUN_DATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
FISCAL_YEAR	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	Fund	Unique fiscal entity code used to post grant calculations.	VARCHAR2(6)	FRRGRNH	FRRGRNH_FUND_CODE
GRANT_DEFERRED_ACTIVITY_DATE	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	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	Grant ID	This is the user-defined or system assigned Grant identification code.	VARCHAR2(9)	FRRGRNH	FRRGRNH_GRNT_CODE
INDIRECT_COST_RATE	Indirect Cost Rate	Indicrect cost rate used to calculate indirect cost.	NUMBER(7,4)	FRRGRNH	FRRGRNH_IC_RATE_PERCENT
LOCATION	Location	Code used to identify accounting data by physical location.	VARCHAR2(6)	FRRGRNH	FRRGRNH_LOCN_CODE
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
ORGANIZATION_CODE	Organization Code	Identification accounting code of the department.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORGN_CODE
ORIGINAL_DOCUMENT	Original Document	Original document number for which the calculations are being performed.	VARCHAR2(8)	FRRGRNH	FRRGRNH_ORIG_DOC_CODE
ORIGINAL_RULE_CLASS	Original Rule Class		VARCHAR2(4)
ORIG_ACCOUNT	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	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	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	Orig Debit Credit Indicator	Debit credit indicator of the transaction used in the originating document.	VARCHAR2(1)	FRRGRNH	FRRGRNH_ORIG_DR_CR_IND
ORIG_FUND	Orig Fund	Unique fiscal entity code used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_FUND_CODE
ORIG_LOCATION	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	Orig Organization	Identification accounting code of the department used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_ORGN_CODE
ORIG_PROGRAM	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	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	Orig Rule Class Description	Original rule class description.	VARCHAR2(35)	FTVRUCL	FTVRUCL_TITLE
ORIG_TRANSACTION_AMOUNT	Orig Transaction Amount	transaction amount used in the originating document.	NUMBER(17,2)	FRRGRNH	FRRGRNH_ORIG_TRANS_AMT
ORIG_TRANSACTION_DATE	Orig Transaction Date	Transaction date used in the originating document.	DATE	FRRGRNH	FRRGRNH_ORIG_TRANS_DATE
PROGRAM	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	Revenue Exists Indicator	Indicates whether revenue and accrual were calculated for this transaction.	VARCHAR2(1)	FRRGRNH	FRRGRNH_REVENUE_EXISTS_IND
RULE_CLASS	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	Rule class description.	VARCHAR2(35)	FTVRUCL	FTVRUCL_TITLE
TRANSACTION_AMOUNT	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	Transaction date of the document.	DATE	FRRGRNH	FRRGRNH_TRANS_DATE
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA