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_CLASS	Class defines major accounting groups used in the system for fixed assets, endowments, sponsored research.	VARCHAR2(63)	FTVACCT	FTVACCT_ACCT_CLASS_CODE	NO	NO
ACCOUNT_CLASS_DESC	Account class description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
ACCOUNT_DESC	Account description.	VARCHAR2(255)	FTVACCT	FTVACCT_TITLE	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
ACCOUNT_INDEX_DESC	Account index description.	VARCHAR2(255)	FTVACCI	FTVACCI_TITLE	NO	NO
ACCOUNT_INDEX_STATUS	Account index status.	VARCHAR2(63)	FTVACCI	FTVACCI_STATUS_IND	NO	NO
ACCOUNT_STATUS	Account status.	VARCHAR2(63)	FTVACCT	FTVACCT_STATUS_IND	NO	NO
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ACTV_CODE	NO	NO
ACTIVITY_DESC	Activity description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE	NO	NO
ACTIVITY_STATUS	Activity status	VARCHAR2(63)	FTVACTV	FTVACTV_STATUS_IND	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
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	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	FRRGRNH	FRRGRNH_CS_RATE_PERCENT	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
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
FUND_DESC	Fund description.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE	NO	NO
FUND_FINANCIAL_MANAGER_ID	System generated or manually assigned ID that uniquely identifies the financial manager.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
FUND_FINANCIAL_MANAGER_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI	NO NO	NO
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	NO	NO
FUND_STATUS	Fund status.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND	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
GRANT_SHORT_TITLE	Grant short title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_TITLE	NO	NO
INDIRECT_COST_RATE	Indicrect cost rate used to calculate indirect cost.	NUMBER	FRRGRNH	FRRGRNH_IC_RATE_PERCENT	NO	NO
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	NO	NO
INTERNAL_ACCOUNT_TYPE_DESC	Internal account type description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
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	NO	NO
INTERNAL_FUND_TYPE_DESC	Internal fund type description.	VARCHAR2(255)	FTVFTYP	FTVFTYP_FTYP_TITLE	NO	NO
LOCATION	Code used to identify accounting data by physical location.	VARCHAR2(6)	FRRGRNH	FRRGRNH_LOCN_CODE	NO	NO
LOCATION_DESC	Location description.	VARCHAR2(255)	FTVLOCN	FTVLOCN_TITLE	NO	NO
LOCATION_STATUS	Location status.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
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	NO	NO
ORGANIZATION_CODE	Identification accounting code of the department.	VARCHAR2(6)	FRRGRNH	FRRGRNH_ORGN_CODE	NO	NO
ORGANIZATION_DESC	Organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE	NO	NO
ORGANIZATION_STATUS	Organization status	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND	NO	NO
ORGN_FINANCIAL_MANAGER_ID	System generated, unique, internal identification number assigned to the financial manager associated with this organization.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
ORGN_FINANCIAL_MANAGER_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI	NO NO	NO
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	NO	NO
ORIGINAL_DOCUMENT	Original document number for which the calculations are being performed.	VARCHAR2(8)	FRRGRNH	FRRGRNH_ORIG_DOC_CODE	NO	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_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	NO	NO
ORIG_ACCOUNT_CLASS_DESC	Account class description for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
ORIG_ACCOUNT_DESC	Original account description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	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_ACCOUNT_INDEX_DESC	Original account index description.	VARCHAR2(255)	FTVACCI	FTVACCI_TITLE	NO	NO
ORIG_ACCOUNT_INDEX_STATUS	Original account index status.	VARCHAR2(63)	FTVACCI	FTVACCI_STATUS_IND	NO	NO
ORIG_ACCOUNT_STATUS	Original account status.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FINANCE_STATUS	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_ACTIVITY_DESC	Original activity description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE	NO	NO
ORIG_ACTIVITY_STATUS	Original activity status	VARCHAR2(63)	FTVACTV	FTVACTV_STATUS_IND	NO	NO
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	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_FUND_DESC	Original fund description.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE	NO	NO
ORIG_FUND_FMGR_ID	System generated or manually assigned ID that uniquely identifies the financial manager.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
ORIG_FUND_FMGR_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI	NO NO	NO
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	NO	NO
ORIG_FUND_STATUS	Original fund status.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	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_LOCATION_DESC	Original location description.	VARCHAR2(255)	FTVLOCN	FTVLOCN_TITLE	NO	NO
ORIG_LOCATION_STATUS	Original location status.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND	NO	NO
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	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_ORGANIZATION_DESC	Original organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE	NO	NO
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	NO NO	NO
ORIG_ORGANIZATION_FMGR_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI	NO NO	NO
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	NO	NO
ORIG_ORGANIZATION_STATUS	Original organization status	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND	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_PROGRAM_DESC	Original program description.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE	NO	NO
ORIG_PROGRAM_STATUS	Original program status.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND	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	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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	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
PROGRAM_DESC	Program description.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE	NO	NO
PROGRAM_STATUS	Program status.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND	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	FRRGRNH	FRRGRNH_TRANS_AMT	NO	NO
TRANSACTION_DATE	Transaction date of the document.	DATE	FRRGRNH	FRRGRNH_TRANS_DATE	NO	NO

Ver: 9.2