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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
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
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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
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
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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
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
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 SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
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: 9.1