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

SGHE Banner Operational Data Store
Reporting View Target: 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.
Recommended Search Columns CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT_INDEX
CHART_OF_ACCOUNTS, FUND
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_CLASS Class defines major accounting groups used in the system for fixed assets, endowments, sponsored research. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CLASS_CODE

ACCOUNT_CLASS_DESC Account class description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ACCOUNT_DESC Account description. VARCHAR2(255)

FTVACCT

FTVACCT_TITLE

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

ACCOUNT_INDEX_DESC Account index description. VARCHAR2(255)

FTVACCI

FTVACCI_TITLE

ACCOUNT_INDEX_STATUS Account index status. VARCHAR2(63)

FTVACCI

FTVACCI_STATUS_IND

ACCOUNT_STATUS Account status. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

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

FRRGRNH

FRRGRNH_ACTV_CODE

ACTIVITY_DESC Activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

ACTIVITY_STATUS Activity status VARCHAR2(63)

FTVACTV

FTVACTV_STATUS_IND

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

NA

NA

CALC_TRANSACTION_AMOUNT Transaction amount times debit credit indicator times normal balance of the account to represent a true amount for addition and subtraction. NUMBER

FUNCTION

F_GET_NORM_BALANCE

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

FRRGRNH

FRRGRNH_CS_RATE_PERCENT

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

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

FUND_DESC Fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

FUND_FINANCIAL_MANAGER_ID System generated or manually assigned ID that uniquely identifies the financial manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

FUND_FINANCIAL_MANAGER_NAME Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

FUND_FINANCIAL_MANAGER_UID System generated, unique, internal identification number assigned to the financial manager associated with this fund. NUMBER

FTVFUND

FTVFUND_FMGR_CODE_PIDM

FUND_STATUS Fund status. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

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

GRANT_SHORT_TITLE Grant short title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_TITLE

INDIRECT_COST_RATE Indicrect cost rate used to calculate indirect cost. NUMBER

FRRGRNH

FRRGRNH_IC_RATE_PERCENT

INTERNAL_ACCOUNT_TYPE Predefined values that represent account types linked to level one account types. Used to identify transactional data for processing and reporting purposes. VARCHAR2(63)

FTVATYP

FTVATYP_INTERNAL_ATYP_CODE

INTERNAL_ACCOUNT_TYPE_DESC Internal account type description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

INTERNAL_FUND_TYPE Predefined values that represent funds types linked to level one fund types. Used to identify transactional data for processing and reporting purposes. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

INTERNAL_FUND_TYPE_DESC Internal fund type description. VARCHAR2(255)

FTVFTYP

FTVFTYP_FTYP_TITLE

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

FRRGRNH

FRRGRNH_LOCN_CODE

LOCATION_DESC Location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

LOCATION_STATUS Location status. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

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

NA

NA

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

NA

NA

NORMAL_BALANCE Usual balance in the account as established by GAAP. For example, asset-debit, liability-credit, control-zero fund balance credit, revenues-credit, and expenditure-debit. VARCHAR2(63)

FTVACCT

FTVACCT_NORMAL_BAL

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

FRRGRNH

FRRGRNH_ORGN_CODE

ORGANIZATION_DESC Organization description. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

ORGANIZATION_STATUS Organization status VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ORGN_FINANCIAL_MANAGER_ID System generated, unique, internal identification number assigned to the financial manager associated with this organization. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORGN_FINANCIAL_MANAGER_NAME Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORGN_FINANCIAL_MANAGER_UID System generated, unique, internal identification number assigned to the financial manager associated with this organization. NUMBER

FTVORGN

FTVORGN_FMGR_CODE_PIDM

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

FRRGRNH

FRRGRNH_ORIG_DOC_CODE

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_CLASS Class defines major accounting groups used in the system for fixed assets, endowments, sponsored research for the specified fiscal year and period. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CLASS_CODE

ORIG_ACCOUNT_CLASS_DESC Account class description for the specified fiscal year and period. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ORIG_ACCOUNT_DESC Original account description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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_ACCOUNT_INDEX_DESC Original account index description. VARCHAR2(255)

FTVACCI

FTVACCI_TITLE

ORIG_ACCOUNT_INDEX_STATUS Original account index status. VARCHAR2(63)

FTVACCI

FTVACCI_STATUS_IND

ORIG_ACCOUNT_STATUS Original account status. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FINANCE_STATUS

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

FRRGRNH

FRRGRNH_ORIG_ACTV_CODE

ORIG_ACTIVITY_DESC Original activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

ORIG_ACTIVITY_STATUS Original activity status VARCHAR2(63)

FTVACTV

FTVACTV_STATUS_IND

ORIG_CALC_TRANSACTION_AMOUNT Original transaction amount times debit credit indicator times normal balance of the account to represent a true amount for addition and subtraction. NUMBER

CALCULATION

F_GET_NORM_BALANCE

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_FUND_DESC Original fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

ORIG_FUND_FMGR_ID System generated or manually assigned ID that uniquely identifies the financial manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORIG_FUND_FMGR_NAME Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORIG_FUND_FMGR_UID System generated, unique, internal identification number assigned to the financial manager associated with this fund. NUMBER

FTVFUND

FTVFUND_FMGR_CODE_PIDM

ORIG_FUND_STATUS Original fund status. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

ORIG_INTERNAL_ACCOUNT_TYPE Predefined values that represent account types linked to level one account types. Used to identify transactional data for processing and reporting purposes for the specified fiscal year and period. VARCHAR2(63)

FTVATYP

FTVATYP_INTERNAL_ATYP_CODE

ORIG_INTERNAL_ACCT_TYPE_DESC Description for system account type for the specified fiscal year and period. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ORIG_INTERNAL_FUND_TYPE Predefined values representing account types linked to level one account types. Used to identify transactional data for processing and reporting purposes for the specified fiscal year and period. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

ORIG_INTERNAL_FUND_TYPE_DESC Description or title of the system fund grouping code for the specified fiscal year and period. VARCHAR2(255)

FTVFTYP

FTVFTYP_FTYP_TITLE

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

FRRGRNH

FRRGRNH_ORIG_LOCN_CODE

ORIG_LOCATION_DESC Original location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

ORIG_LOCATION_STATUS Original location status. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

ORIG_NORMAL_BALANCE Usual balance in the account as established by GAAP. For example, asset-debit, liability-credit, control-zero fund balance credit, revenues-credit, and expenditure-debit. VARCHAR2(63)

FTVACCT

FTVACCT_NORMAL_BAL

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

FRRGRNH

FRRGRNH_ORIG_ORGN_CODE

ORIG_ORGANIZATION_DESC Original organization description. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

ORIG_ORGANIZATION_FMGR_ID System generated, unique, internal identification number assigned to the financial manager associated with this organization. VARCHAR2(63)

FTVORGN

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

ORIG_ORGANIZATION_FMGR_NAME Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORIG_ORGANIZATION_FMGR_UID System generated, unique, internal identification number assigned to the financial manager associated with this organization. NUMBER

FUNCTION

FTVORGN_FMGR_CODE_PIDM

ORIG_ORGANIZATION_STATUS Original organization status VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

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_PROGRAM_DESC Original program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

ORIG_PROGRAM_STATUS Original program status. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

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

FRRGRNH

FRRGRNH_ORIG_TRANS_AMT

ORIG_TRANSACTION_DATE Transaction date used in the originating document. DATE

FRRGRNH

FRRGRNH_ORIG_TRANS_DATE

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

NA

NA

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

PROGRAM_DESC Program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

PROGRAM_STATUS Program status. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

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

FRRGRNH

FRRGRNH_TRANS_AMT

TRANSACTION_DATE Transaction date of the document. DATE

FRRGRNH

FRRGRNH_TRANS_DATE



Ver: 8.5