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
|