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