| Target Column |
Business Name |
Business Definition |
Database Data Type |
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
|
|
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
|
|
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
|
|
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 SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
|
|
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
|