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 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_CLASS 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 Account class description. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ACCOUNT_DESC Account Description Account description. VARCHAR2(255)  

FTVACCT

FTVACCT_TITLE

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

ACCOUNT_INDEX_DESC Account INDEX Description Account index description. VARCHAR2(255)  

FTVACCI

FTVACCI_TITLE

ACCOUNT_INDEX_STATUS Account INDEX Status Account index status. VARCHAR2(63)  

FTVACCI

FTVACCI_STATUS_IND

ACCOUNT_STATUS Account Status Account status. VARCHAR2(63)  

FTVACCT

FTVACCT_STATUS_IND

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

FRRGRNH

FRRGRNH_ACTV_CODE

ACTIVITY_DESC Activity Description Activity description. VARCHAR2(255)  

FTVACTV

FTVACTV_TITLE

ACTIVITY_STATUS Activity Status Activity status VARCHAR2(63)  

FTVACTV

FTVACTV_STATUS_IND

ADMINISTRATIVE_GROUP 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 Calculated 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 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  

FRRGRNH

FRRGRNH_CS_RATE_PERCENT

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

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

FUND_DESC Fund Description Fund description. VARCHAR2(255)  

FTVFUND

FTVFUND_TITLE

FUND_FINANCIAL_MANAGER_ID 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 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 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 Fund status. VARCHAR2(63)  

FTVFUND

FTVFUND_STATUS_IND

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

GRANT_SHORT_TITLE Grant Short Title Grant short title or description. VARCHAR2(256)  

FRBGRNT

FRBGRNT_TITLE

INDIRECT_COST_RATE Indirect Cost Rate Indicrect cost rate used to calculate indirect cost. NUMBER  

FRRGRNH

FRRGRNH_IC_RATE_PERCENT

INTERNAL_ACCOUNT_TYPE 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 Internal account type description. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

INTERNAL_FUND_TYPE 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 Internal fund type description. VARCHAR2(255)  

FTVFTYP

FTVFTYP_FTYP_TITLE

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

FRRGRNH

FRRGRNH_LOCN_CODE

LOCATION_DESC Location Description Location description. VARCHAR2(255)  

FTVLOCN

FTVLOCN_TITLE

LOCATION_STATUS Location Status Location status. VARCHAR2(63)  

FTVLOCN

FTVLOCN_STATUS_IND

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

NA

NA

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

NA

NA

NORMAL_BALANCE 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 Organization Code Identification accounting code of the department. VARCHAR2(6)  

FRRGRNH

FRRGRNH_ORGN_CODE

ORGANIZATION_DESC Organization Description Organization description. VARCHAR2(255)  

FTVORGN

FTVORGN_TITLE

ORGANIZATION_STATUS Organization Status Organization status VARCHAR2(63)  

FTVORGN

FTVORGN_STATUS_IND

ORGN_FINANCIAL_MANAGER_ID Organization 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 Organization 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 Organization 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 Original document number for which the calculations are being performed. VARCHAR2(8)  

FRRGRNH

FRRGRNH_ORIG_DOC_CODE

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_CLASS 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 Orig Account Class Description Account class description for the specified fiscal year and period. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ORIG_ACCOUNT_DESC Orig Account Description Original account description. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

FTVACCI

FTVACCI_TITLE

ORIG_ACCOUNT_INDEX_STATUS Orig Account INDEX Status Original account index status. VARCHAR2(63)  

FTVACCI

FTVACCI_STATUS_IND

ORIG_ACCOUNT_STATUS Orig Account Status Original account status. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FINANCE_STATUS

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_ACTIVITY_DESC Orig Activity Description Original activity description. VARCHAR2(255)  

FTVACTV

FTVACTV_TITLE

ORIG_ACTIVITY_STATUS Orig Activity Status Original activity status VARCHAR2(63)  

FTVACTV

FTVACTV_STATUS_IND

ORIG_CALC_TRANSACTION_AMOUNT Orig Calculated 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 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_FUND_DESC Orig Fund Description Original fund description. VARCHAR2(255)  

FTVFUND

FTVFUND_TITLE

ORIG_FUND_FMGR_ID Orig Fund Financial Manager 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 Orig 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

ORIG_FUND_FMGR_UID Orig 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

ORIG_FUND_STATUS Orig Fund Status Original fund status. VARCHAR2(63)  

FTVFUND

FTVFUND_STATUS_IND

ORIG_INTERNAL_ACCOUNT_TYPE 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 Orig Internal Account Type Description Description for system account type for the specified fiscal year and period. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ORIG_INTERNAL_FUND_TYPE 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 Orig Internal Fund Type Description Description or title of the system fund grouping code for the specified fiscal year and period. VARCHAR2(255)  

FTVFTYP

FTVFTYP_FTYP_TITLE

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_LOCATION_DESC Orig Location Description Original location description. VARCHAR2(255)  

FTVLOCN

FTVLOCN_TITLE

ORIG_LOCATION_STATUS Orig Location Status Original location status. VARCHAR2(63)  

FTVLOCN

FTVLOCN_STATUS_IND

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

FRRGRNH

FRRGRNH_ORIG_ORGN_CODE

ORIG_ORGANIZATION_DESC Orig Organization Description Original organization description. VARCHAR2(255)  

FTVORGN

FTVORGN_TITLE

ORIG_ORGANIZATION_FMGR_ID Orig Organization Financial Manager 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 Orig Organization Financial Manager 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 Orig Organization Financial Manager 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 Orig Organization Status Original organization status VARCHAR2(63)  

FTVORGN

FTVORGN_STATUS_IND

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

FTVPROG

FTVPROG_TITLE

ORIG_PROGRAM_STATUS Orig Program Status Original program status. VARCHAR2(63)  

FTVPROG

FTVPROG_STATUS_IND

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  

FRRGRNH

FRRGRNH_ORIG_TRANS_AMT

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

FRRGRNH

FRRGRNH_ORIG_TRANS_DATE

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

NA

NA

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

PROGRAM_DESC Program Description Program description. VARCHAR2(255)  

FTVPROG

FTVPROG_TITLE

PROGRAM_STATUS Program Status Program status. VARCHAR2(63)  

FTVPROG

FTVPROG_STATUS_IND

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  

FRRGRNH

FRRGRNH_TRANS_AMT

TRANSACTION_DATE Transaction Date Transaction date of the document. DATE  

FRRGRNH

FRRGRNH_TRANS_DATE



Ver: 9.0