Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT	Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ACCT_CODE	NO	NO
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	NO	NO
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ACTV_CODE	NO	NO
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	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_STATUS	Chart of accounts status.	VARCHAR2(1)	FUNCTION	FOKODSF.F_GET_FINANCE_STATUS	NO	NO
COST_SHARE_RATE	Cost share rate used to calculate cost share.	NUMBER(7,4)	FRRGRNH	FRRGRNH_CS_RATE_PERCENT	NO	NO
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE	NO	NO
DEBIT_CREDIT_IND	Debit credit indicator of the transaction.	VARCHAR2(1)	FRRGRNH	FRRGRNH_DR_CR_IND	NO	NO
DOCUMENT	Journal voucher document number created for the deferred grant calculations.	VARCHAR2(8)	FRRGRNH	FRRGRNH_DOC_CODE	NO	NO
DOCUMENT_JOB_NUMBER	Job number assigned by job submission for this execution of the Deferred Grant Process.	NUMBER	FRRGRNH	FRRGRNH_JOB_NUMBER	NO	NO
DOCUMENT_POSTING_DATE	Date that the transactions, produced by the Deferred Grant Process, is used to update the ledgers.	DATE	FRRGRNH	FRRGRNH_POSTING_DATE	NO	NO
DOCUMENT_RUN_DATE	Date the Deferred Grant Process was run to generate this document.	DATE	FRRGRNH	FRRGRNH_RUN_DATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
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'	NO	NO
FUND	Unique fiscal entity code used to post grant calculations.	VARCHAR2(6)	FRRGRNH	FRRGRNH_FUND_CODE	NO	NO
GRANT_DEFERRED_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FRRGRNH	FRRGRNH_ACTIVITY_DATE	NO	NO
GRANT_DEFERRED_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FRRGRNH	FRRGRNH_USER_ID	NO	NO
GRANT_ID	This is the user-defined or system assigned Grant identification code.	VARCHAR2(9)	FRRGRNH	FRRGRNH_GRNT_CODE	NO	NO
INDIRECT_COST_RATE	Indicrect cost rate used to calculate indirect cost.	NUMBER(7,4)	FRRGRNH	FRRGRNH_IC_RATE_PERCENT	NO	NO
LOCATION	Code used to identify accounting data by physical location.	VARCHAR2(6)	FRRGRNH	FRRGRNH_LOCN_CODE	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
ORGANIZATION_CODE	Identification accounting code of the department.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORGN_CODE	NO	NO
ORIGINAL_DOCUMENT	Original document number for which the calculations are being performed.	VARCHAR2(8)	FRRGRNH	FRRGRNH_ORIG_DOC_CODE	NO	NO
ORIGINAL_RULE_CLASS		VARCHAR2(4)				NO
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	NO	NO
ORIG_ACCOUNT_INDEX	Original account index used to identify the accounting distribution used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_ACCI_CODE	NO	NO
ORIG_ACTIVITY	Code used to identify accounting data by activity used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_ACTV_CODE	NO	NO
ORIG_DEBIT_CREDIT_IND	Debit credit indicator of the transaction used in the originating document.	VARCHAR2(1)	FRRGRNH	FRRGRNH_ORIG_DR_CR_IND	NO	NO
ORIG_FUND	Unique fiscal entity code used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_FUND_CODE	NO	NO
ORIG_LOCATION	Code used to identify accounting data by physical location used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_LOCN_CODE	NO	NO
ORIG_ORGANIZATION	Identification accounting code of the department used in the originating transaction.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORIG_ORGN_CODE	NO	NO
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	NO	NO
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	NO	NO
ORIG_RULE_CLASS_DESC	Original rule class description.	VARCHAR2(35)	FTVRUCL	FTVRUCL_TITLE	NO	NO
ORIG_TRANSACTION_AMOUNT	transaction amount used in the originating document.	NUMBER(17,2)	FRRGRNH	FRRGRNH_ORIG_TRANS_AMT	NO	NO
ORIG_TRANSACTION_DATE	Transaction date used in the originating document.	DATE	FRRGRNH	FRRGRNH_ORIG_TRANS_DATE	NO	NO
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	NO	NO
REVENUE_EXISTS_IND	Indicates whether revenue and accrual were calculated for this transaction.	VARCHAR2(1)	FRRGRNH	FRRGRNH_REVENUE_EXISTS_IND	NO	NO
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	NO	NO
RULE_CLASS_DESC	Rule class description.	VARCHAR2(35)	FTVRUCL	FTVRUCL_TITLE	NO	NO
TRANSACTION_AMOUNT	Amount of indirect cost, cost share, or revenue posted for grant calculations.	NUMBER(17,2)	FRRGRNH	FRRGRNH_TRANS_AMT	NO	NO
TRANSACTION_DATE	Transaction date of the document.	DATE	FRRGRNH	FRRGRNH_TRANS_DATE	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: