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(63)	FGBTRND	FGBTRND_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 code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
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(63)	FGBTRND	FGBTRND_ACCI_CODE
ACCOUNT_INDEX_DESC	Account index description.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX_STATUS	Current status of the associated account index.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ACCOUNT_POOL	Account used for budgeting purposes. If the account pool does not exist, it is replaced with account for available balance checking.	VARCHAR2(63)	CALCULATION	NVL(FTVACCT_ACCT_CODE_POOL,FTVACCT_ACCT_CODE)
ACCOUNT_POOL_DESC	Account pool description. If the account pool is not found, then its description is replaced with account description, for available balance checking.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_STATUS	Current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ACCRUAL_IND	Indicator used during the accrual period to determine if the system automatically generates transactions for both current and prior fiscal years.	VARCHAR2(63)	FGBTRNH	FGBTRNH_ACCRUAL_IND
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(63)	FGBTRND	FGBTRND_ACTV_CODE
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FGBTRND	FGBTRND_ACTIVITY_DATE
ACTIVITY_DESC	Activity code title or description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
ACTIVITY_STATUS	Current status of the associated activity.	VARCHAR2(63)	FTVACTV	FTVACTV_STATUS_IND
ACTUAL_ACCOUNT_DESC_1	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACTUAL_ACCOUNT_DESC_2	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACTUAL_ACCOUNT_DESC_3	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACTUAL_ACCOUNT_DESC_4	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACTUAL_ACCOUNT_LEVEL_1	Primary account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_ACCT_CODE
ACTUAL_ACCOUNT_LEVEL_2	Level 2 account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_ACCT_CODE
ACTUAL_ACCOUNT_LEVEL_3	Level 3 account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_ACCT_CODE
ACTUAL_ACCOUNT_LEVEL_4	Level 4 account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_ACCT_CODE
ACTUAL_ACCOUNT_STATUS_1	Status of the primary account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_STATUS_IND
ACTUAL_ACCOUNT_STATUS_2	Status of the level 2 account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_STATUS_IND
ACTUAL_ACCOUNT_STATUS_3	Status of the level 3 account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_STATUS_IND
ACTUAL_ACCOUNT_STATUS_4	Status of the level 4 account within the account hierarchy.	VARCHAR2(63)	FTVACCT	FTVACCT_STATUS_IND
ACTUAL_ACCOUNT_TYPE_DESC_1	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FTVATYP	FTVATYP_TITLE
ACTUAL_ACCOUNT_TYPE_DESC_2	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FTVATYP	FTVATYP_TITLE
ACTUAL_ACCOUNT_TYPE_LEVEL_1	Primary account type within the account hierarchy.	VARCHAR2(63)	FTVATYP	FTVATYP_ATYP_CODE
ACTUAL_ACCOUNT_TYPE_LEVEL_2	Level 2 account type within the account hierarchy.	VARCHAR2(63)	FTVATYP	FTVATYP_ATYP_CODE
ACTUAL_ACCOUNT_TYPE_STATUS_1	Status of the primary account type within the account hierarchy.	VARCHAR2(63)	FTVATYP	FTVATYP_STATUS_IND
ACTUAL_ACCOUNT_TYPE_STATUS_2	Status of the level 2 account type within the account hierarchy.	VARCHAR2(63)	FTVATYP	FTVATYP_STATUS_IND
ACTUAL_FUND_DESC_1	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ACTUAL_FUND_DESC_2	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ACTUAL_FUND_DESC_3	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ACTUAL_FUND_DESC_4	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ACTUAL_FUND_DESC_5	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ACTUAL_FUND_LEVEL_1	Primary fund within the fund hierarchy.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
ACTUAL_FUND_LEVEL_2	Level 2 fund within the fund hierarchy.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
ACTUAL_FUND_LEVEL_3	Level 3 fund within the fund hierarchy.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
ACTUAL_FUND_LEVEL_4	Level 4 fund within the fund hierarchy.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
ACTUAL_FUND_LEVEL_5	Level 5 fund within the fund hierarchy.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
ACTUAL_FUND_STATUS_1	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
ACTUAL_FUND_STATUS_2	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
ACTUAL_FUND_STATUS_3	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
ACTUAL_FUND_STATUS_4	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
ACTUAL_FUND_STATUS_5	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
ACTUAL_FUND_TYPE_DESC_1	Status of the primary fund type within the fund hierarchy.	VARCHAR2(255)	FTVFTYP	FTVFTYP_TITLE
ACTUAL_FUND_TYPE_DESC_2	Status of the level 2 fund type within the fund hierarchy.	VARCHAR2(255)	FTVFTYP	FTVFTYP_TITLE
ACTUAL_FUND_TYPE_LEVEL_1	Fund type level 1.	VARCHAR2(63)	FTVFTYP	FTVFTYP_FTYP_CODE
ACTUAL_FUND_TYPE_LEVEL_2	Fund type level 2.	VARCHAR2(63)	FTVFTYP	FTVFTYP_FTYP_CODE
ACTUAL_FUND_TYPE_STATUS_1	Status of the fund type.	VARCHAR2(63)	FTVFTYP	FTVFTYP_STATUS_IND
ACTUAL_FUND_TYPE_STATUS_2	Status of the fund type.	VARCHAR2(63)	FTVFTYP	FTVFTYP_STATUS_IND
ACTUAL_LOCATION_DESC_1	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ACTUAL_LOCATION_DESC_2	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ACTUAL_LOCATION_DESC_3	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ACTUAL_LOCATION_DESC_4	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ACTUAL_LOCATION_DESC_5	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ACTUAL_LOCATION_LEVEL_1	Level 1 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_LOCN_CODE
ACTUAL_LOCATION_LEVEL_2	Level 2 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_LOCN_CODE
ACTUAL_LOCATION_LEVEL_3	Level 3 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_LOCN_CODE
ACTUAL_LOCATION_LEVEL_4	Level 4 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_LOCN_CODE
ACTUAL_LOCATION_LEVEL_5	Level 5 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_LOCN_CODE
ACTUAL_LOCATION_STATUS_1	Status of the level 1 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
ACTUAL_LOCATION_STATUS_2	Status of the level 2 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
ACTUAL_LOCATION_STATUS_3	Status of the level 3 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
ACTUAL_LOCATION_STATUS_4	Status of the level 4 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
ACTUAL_LOCATION_STATUS_5	Status of the level 5 location within this location hierarchy.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
ACTUAL_ORGANIZATION_DESC_1	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_2	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_3	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_4	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_5	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_6	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_7	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_DESC_8	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ACTUAL_ORGANIZATION_LEVEL_1	Primary organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_2	Level 2 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_3	Level 3 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_4	Level 4 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_5	Level 5 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_6	Level 6 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_7	Level 7 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_LEVEL_8	Level 8 organization within the organization hierarchy.	VARCHAR2(63)	FTVORGN	FTVORGN_ORGN_CODE
ACTUAL_ORGANIZATION_STATUS_1	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_2	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_3	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_4	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_5	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_6	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_7	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_ORGANIZATION_STATUS_8	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ACTUAL_PROGRAM_DESC_1	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ACTUAL_PROGRAM_DESC_2	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ACTUAL_PROGRAM_DESC_3	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ACTUAL_PROGRAM_DESC_4	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ACTUAL_PROGRAM_DESC_5	Hierarchy description or title appropriate for this level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ACTUAL_PROGRAM_LEVEL_1	Primary program within the program hierarchy.	VARCHAR2(63)	FTVPROG	FTVPROG_PROG_CODE
ACTUAL_PROGRAM_LEVEL_2	Level 2 program within the program hierarchy.	VARCHAR2(63)	FTVPROG	FTVPROG_PROG_CODE
ACTUAL_PROGRAM_LEVEL_3	Level 3 program within the program hierarchy.	VARCHAR2(63)	FTVPROG	FTVPROG_PROG_CODE
ACTUAL_PROGRAM_LEVEL_4	Level 4 program within the program hierarchy.	VARCHAR2(63)	FTVPROG	FTVPROG_PROG_CODE
ACTUAL_PROGRAM_LEVEL_5	Level 5 program within the program hierarchy.	VARCHAR2(63)	FTVPROG	FTVPROG_PROG_CODE
ACTUAL_PROGRAM_STATUS_1	Current status of the associated program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND
ACTUAL_PROGRAM_STATUS_2	Current status of the associated program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND
ACTUAL_PROGRAM_STATUS_3	Current status of the associated program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND
ACTUAL_PROGRAM_STATUS_4	Current status of the associated program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND
ACTUAL_PROGRAM_STATUS_5	Current status of the associated program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AMOUNT_IND	Indicates the amount was posted.	VARCHAR2(63)	FGBTRND	FGBTRND_AMT_IND
AUTO_JOURNAL_ID	User-defined value providing unique identification for a recurring journal voucher.	VARCHAR2(63)	FGBTRNH	FGBTRNH_AUTO_JRNL_ID
AVAILABLE_BUDGET_OVERRIDE	Indicates if available fund checking was overridden when a lack of funds condition existed.	VARCHAR2(63)	FGBTRNH	FGBTRNH_ABAL_OVERRIDE
BANK	Code used to identify the bank account on all cash transactions.	VARCHAR2(63)	FGBTRNH	FGBTRNH_BANK_CODE
BANK_DESC	Name of the bank where the institution has accounts.	VARCHAR2(255)	GXVBANK	GXVBANK_ACCT_NAME
BANK_ID	ID of the bank where the Institution has accounts.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
BANK_NAME	Official banking institution name.	VARCHAR2(255)	FUNCTION FUNCTION	FRKIDEN.F_GET_SPRIDEN_LAST_NAME MGKFUNC.F_GET_PERSON_INFO
BANK_UID	Internal identification number of the bank used at time the transaction occurred.	NUMBER	GXVBANK	GXVBANK_BANK_CODE_PIDM
BUDGET_DISPOSITION	Indicator that determines the year-end processing or budget requested encumbrance amounts.	VARCHAR2(63)	FGBTRNH	FGBTRNH_BUD_DISPN
BUDGET_ID	User-defined unique identification of the budget identifier. Generally Fiscal year for which the budget is being prepared.	VARCHAR2(63)	FGBTRND	FGBTRND_BUD_ID
BUDGET_PERIOD	Numeric value of the budget period being entered if this is a budget journal.	VARCHAR2(63)	FGBTRNH	FGBTRNH_BUDGET_PERIOD
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FGBTRND	FGBTRND_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_POOL	Code that denotes the pool chart of account that the investment fund code is participating.	VARCHAR2(63)	FGBTRNH	FGBTRNH_COAS_CODE_POOL
CHART_OF_ACCOUNTS_POOL_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Current status of the associated chart of accounts.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
COMMIT_PERCENT	Percentage of budget to be rolled into the next fiscal year as committed funds.	NUMBER	FGBTRND	FGBTRND_CMT_PCT
COMMIT_TYPE	Indicates whether a line item represents funds committed from the prior year budget. U=uncommitted or C=committed.	VARCHAR2(63)	FGBTRND	FGBTRND_CMT_TYPE
CONVERT_AMOUNT	Base currency amount calculated for this accounting record.	NUMBER	FGBTRNH	FGBTRNH_CONVERT_AMT
COST_SHARE_RATE	Cost share rate for this grant.	NUMBER	FGBTRND	FGBTRND_CS_RATE_PERCENT
CURRENCY	Type of currency represented in the amount field.	VARCHAR2(63)	FGBTRNH	FGBTRNH_CURR_CODE
CURRENCY_DESC	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE
DEBIT_CREDIT_IND	Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.	VARCHAR2(63)	FGBTRND	FGBTRND_DR_CR_IND
DEPOSIT_NUMBER	Deposit number assigned to this transaction.	VARCHAR2(63)	FGBTRNH	FGBTRNH_DEP_NUM
DETAIL_BUDGET_PERIOD	Numeric value of the budget period used if this is a budget journal.	VARCHAR2(63)	FGBTRND	FGBTRND_BUDGET_PERIOD
DETAIL_POSTING_PROCESS	Code that identifies what accounting actions are to be taken with the ledgers.	VARCHAR2(63)	FGBTRND	FGBTRND_PROC_CODE
DETAIL_POSTING_PROCESS_DESC	Posting process description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
DETAIL_PROJECT	Work order code associated with the transaction.	VARCHAR2(63)	FGBTRND	FGBTRND_PRJD_CODE
DETAIL_REVERSAL_IND	Indicates if a document was canceled or reversed.	VARCHAR2(63)	FGBTRND	FGBTRND_REVERSAL_IND
DETAIL_SERIAL_NUMBER	Unique system assigned number to control unique creation of transaction source history records.	NUMBER	FGBTRND	FGBTRND_SERIAL_NUM
DETAIL_SUM_POST_DOC_CODE	Document number generated in a given posting run to facilitate summary general ledger postings. Format is MMDDHHMM.	VARCHAR2(63)	FGBTRND	FGBTRND_SUM_POST_DOC_CODE
DETAIL_USER_ID	Unique identification code of the user who entered the transaction.	VARCHAR2(63)	FGBTRND	FGBTRND_USER_ID
DIRECT_INDIRECT_IND	Direct/indirect indicator.	VARCHAR2(63)	NA	NA
DISTRIBUTION_PERCENT	Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER	FGBTRNH	FGBTRNH_DIST_PCT
DOCUMENT	User-defined or system generated document number.	VARCHAR2(63)	FGBTRNH	FGBTRNH_DOC_CODE
DOCUMENT_DATE	Document date.	DATE	NA	NA
DOCUMENT_TYPE	Unique identifier that internally defines document types or entities associated to this text.	NUMBER	FGBTRNH	FGBTRNH_DOC_SEQ_CODE
DOCUMENT_TYPE_DESC	Document/entity type description.	VARCHAR2(255)	FTVDTYP	FTVDTYP_DESC
DOC_REFERENCE_NUMBER	User-defined number providing additional identification for the transaction.	VARCHAR2(63)	FGBTRNH	FGBTRNH_DOC_REF_NUM
DOC_REFERENCE_NUMBER2	Second user-defined number providing additional identification for the transaction.	VARCHAR2(63)	NA	NA
ENCUMBRANCE_ACTION_IND	Liquidation action on encumbrances as partial, total, adjustment or original.	VARCHAR2(63)	FGBTRNH	FGBTRNH_ENCD_ACTION_IND
ENCUMBRANCE_ITEM_NUMBER	Number associated with each individual commodity on the encumbering document.	NUMBER	FGBTRND	FGBTRND_ENCD_ITEM_NUM
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(63)	FGBTRND	FGBTRND_ENCD_NUM
ENCUMBRANCE_SEQ_NUMBER	Number associated with each accounting distribution on an encumbering document.	NUMBER	FGBTRND	FGBTRND_ENCD_SEQ_NUM
ENCUMBRANCE_TYPE	Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.	VARCHAR2(63)	FGBTRNH	FGBTRNH_ENCB_TYPE
EXCHANGE_AMOUNT	Exchange amount is the difference between the input transaction amount and the converted amount. Is used to balance the exchange accounts associated to each currency code.	NUMBER	FGBTRNH	FGBTRNH_EXCHANGE_AMT
EXCHANGE_DIFFERENCE	Difference between the exchange amounts from when the invoice is recorded to when the check is written. Is also used to balance the exchange accounts associated to each currency code.	NUMBER	FGBTRNH	FGBTRNH_EXCHANGE_DIFF
FIELD_CODE	Two-digit code that represents the specific ledger bucket being updated.	VARCHAR2(63)	FGBTRND	FGBTRND_FIELD_CODE
FISCAL_PERIOD_HEADER	A unique identifier code for the fiscal period of a fiscal year being defined. This field is from the Transaction History Header table.	VARCHAR2(63)	FGBTRNH	FGBTRNH_POSTING_PERIOD
FISCAL_YEAR	Unique identifier or code for the fiscal year from the posted transaction.	VARCHAR2(63)	CALCULATION	TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'),'YYYY')
FISCAL_YEAR_HEADER	A unique identifier code for the fiscal year being defined. Function fofyncv returns a four-digit year when supplied a two-digit year. This field is from the Transaction History table.	VARCHAR2(63)	CALCULATION	TO_CHAR(TO_DATE(FGBTRNH_FSYR_CODE,'RR'),'YYYY')
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	FGBTRND	FGBTRND_FUND_CODE
FUND_DESC	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
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	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	System generated, unique, internal identification number assigned to the financial manager associated with this fund.	NUMBER	FTVFUND	FTVFUND_FMGR_CODE_PIDM
FUND_POOL	Code that denotes the pool fund that the investment fund code is participating.	VARCHAR2(63)	CALCULATION FGBTRNH	NVL(TRANSACTION_HISTORY.FUND_POOL, FUND_HIERARCHY.FUND_POOL) FGBTRNH_FUND_CODE_POOL
FUND_POOL_DESC	Transaction fund description.	VARCHAR2(255)	CALCULATION FTVFUND	DECODE(TRANSACTION_HISTORY.FUND_POOL,NULL,FUND_HIERARCHY.FUND_POOL_DESC,TRANSACTION_HISTORY.FUND_POOL_DESC) FTVFUND_TITLE
FUND_STATUS	Current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
GRANT_DESC	Shortened name or title for the grant.	VARCHAR2(255)	FUNCTION	FRKIDEN.F_GET_FRBGRNT_TITLE
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FTVFUND	FTVFUND_GRNT_CODE
GRANT_STATUS	Current grant status.	VARCHAR2(63)	FUNCTION	FRKIDEN.F_GET_FRBGRNT_STATUS_CODE
INDIRECT_COST_MEMO_RATE	Indirect cost memo rate percentage.	NUMBER	FGBTRND	FGBTRND_IC_MEMO_RATE_PERCENT
INDIRECT_COST_RATE	Indirect cost rate percentage for the grant fund.	NUMBER	FGBTRND	FGBTRND_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)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
ITEM	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FGBTRNH	FGBTRNH_ITEM_NUM
LEDGER_IND	One-position field that indicates if the ledger updated by this transaction was the encumbrance, general or operating (subsidiary) ledger.	VARCHAR2(63)	FGBTRND	FGBTRND_LEDGER_IND
LIQUIDATION_AMOUNT	Liquidation amount.	NUMBER	NA	NA
LOCATION	Identification accounting code of the physical location of the financial manager.	VARCHAR2(63)	FGBTRND	FGBTRND_LOCN_CODE
LOCATION_DESC	Description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS	Current status of the associated location.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	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 used for the department.	VARCHAR2(63)	FGBTRND	FGBTRND_ORGN_CODE
ORGANIZATION_DESC	Description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_POOL	Organization used for budgeting purposes. If the organization pool does not exist, it is replaced with organization for available balance checking for the specified fiscal year and period.	VARCHAR2(63)	CALCULATION	NVL(FTVORGN_ORGN_CODE_NSF,FTVORGN_ORGN_CODE)
ORGANIZATION_POOL_DESC	Organization pool description. If the organization pool is not found, then its description is replaced with organization description for available balance checking for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_STATUS	Current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ORGN_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	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	System generated, unique, internal identification number assigned to the financial manager associated with this organization.	NUMBER	FTVORGN	FTVORGN_FMGR_CODE_PIDM
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_1	Description or title level 1 within this account hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_DESC_2	Description or title level 2 within this account hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_DESC_3	Description or title level 3 within this account hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_DESC_4	Description or title level 4 within this account hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_LEVEL_1	Level 1 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_LEVEL_2	Level 2 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_LEVEL_3	Level 3 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_LEVEL_4	Level 4 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_POOL	Account used for budgeting purposes. If the account pool does not exist, it is replaced with account for available balance checking, for the specified fiscal year and period.	VARCHAR2(63)	CALCULATION	NVL(FTVACCT_ACCT_CODE_POOL,FTVACCT_ACCT_CODE)
ORIG_ACCOUNT_POOL_DESC	Account pool description. If the account pool is not found, then its description is replaced with account description, for available balance checking, for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORIG_ACCOUNT_STATUS_1	Dtatus of level 1 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_STATUS_2	Status of level 2 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_STATUS_3	Status of level 3 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_STATUS_4	Status of level 4 account within this account hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ORIG_ACCOUNT_TYPE_DESC_1	Description or title level 1 within this account type hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FTVATYP	FTVATYP_TITLE
ORIG_ACCOUNT_TYPE_DESC_2	Description or title level 2 within this account type hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FTVATYP	FTVATYP_TITLE
ORIG_ACCOUNT_TYPE_LEVEL_1	Level 1 account type grouping within this account type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVATYP	FTVATYP_ATYP_CODE
ORIG_ACCOUNT_TYPE_LEVEL_2	Level 2 account type grouping within this account type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVATYP	FTVATYP_ATYP_CODE
ORIG_ACCOUNT_TYPE_STATUS_1	Status of level 1 account type within this account type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVATYP	FTVATYP_STATUS_IND
ORIG_ACCOUNT_TYPE_STATUS_2	Status of level 2 account type within this account type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVATYP	FTVATYP_STATUS_IND
ORIG_FUND_DESC_1	Description or title level 1 within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_DESC_2	Description or title level 2 within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_DESC_3	Description or title level 3 within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_DESC_4	Description or title level 4 within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_DESC_5	Description or title level 5 within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_LEVEL_1	Level 1 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_LEVEL_2	Level 2 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_LEVEL_3	Level 3 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_LEVEL_4	Level 4 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_LEVEL_5	Level 5 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_POOL	Fund used for budgeting purposes. If the fund pool does not exist, it is replaced with fund for available balance checking for the specified fiscal year and period.	VARCHAR2(63)	CALCULATION	NVL(FTVFUND_FUND_CODE_BAVL,FTVFUND_FUND_CODE)
ORIG_FUND_POOL_DESC	Fund pool description. If the fund pool is not found, then its description is replaced with fund description, for available balance checking for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORIG_FUND_STATUS_1	Status of level 1 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_STATUS_2	Status of level 2 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_STATUS_3	Status of level 3 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_STATUS_4	Status of level 4 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_STATUS_5	Status of level 5 fund within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
ORIG_FUND_TYPE_DESC_1	Description or title level 1 within this fund type hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FTVFTYP	FTVFTYP_TITLE
ORIG_FUND_TYPE_DESC_2	Description or title level 2 within this fund type hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FTVFTYP	FTVFTYP_TITLE
ORIG_FUND_TYPE_LEVEL_1	Primary fund type within this fund hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVFTYP	FTVFTYP_FTYP_CODE
ORIG_FUND_TYPE_LEVEL_2	Level 2 fund type grouping within this fund type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVFTYP	FTVFTYP_FTYP_CODE
ORIG_FUND_TYPE_STATUS_1	Status of level 1 fund type within this fund type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVFTYP	FTVFTYP_STATUS_IND
ORIG_FUND_TYPE_STATUS_2	Status of level 2 fund type within this fund type hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FTVFTYP	FTVFTYP_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 fund types linked to level one fund types. Used to identify transactional data for processing and reporting purposes for the specified fiscal year and period.	VARCHAR2(63)	FTVFTYP	FTVFTYP_INTERNAL_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)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
ORIG_LOCATION_DESC_1	Description or title level 1 within this location hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_DESC_2	Description or title level 2 within this location hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_DESC_3	Description or title level 3 within this location hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_DESC_4	Description or title level 4 within this location hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_DESC_5	Description or title level 5 within this location hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_LEVEL_1	Level 1 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_LEVEL_2	Level 2 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_LEVEL_3	Level 3 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_LEVEL_4	Level 4 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_LEVEL_5	Level 5 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_STATUS_1	Status level 1 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_STATUS_2	Status level 2 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_STATUS_3	Status level 3 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_STATUS_4	Status level 4 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_LOCATION_STATUS_5	Status level 5 location within this location hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
ORIG_ORGANIZATION_DESC_1	Description or title level 1 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_2	Description or title level 2 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_3	Description or title level 3 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_4	Description or title level 4 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_5	Description or title level 5 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_6	Description or title level 6 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_7	Description or title level 7 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_DESC_8	Description or title level 8 within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_1	Level 1 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_2	Level 2 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_3	Level 3 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_4	Level 4 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_5	Level 5 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_6	Level 6 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_7	Level 7 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_LEVEL_8	Level 8 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_1	Status of level 1 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_2	Status of level 2 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_3	Status of level 3 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_4	Status of level 4 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_5	Status of level 5 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_6	Status of level 6 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_7	Status of level 7 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_ORGANIZATION_STATUS_8	Status of level 8 organization within this organization hierarchy for the specified fiscal year and period.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIG_PROGRAM_DESC_1	Description or title level 1 within this program hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_DESC_2	Description or title level 2 within this program hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_DESC_3	Description or title level 3 within this program hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_DESC_4	Description or title level 4 within this program hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_DESC_5	Description or title level 5 within this program hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_LEVEL_1	Level 1 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_LEVEL_2	Level 2 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_LEVEL_3	Level 3 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_LEVEL_4	Level 4 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_LEVEL_5	Level 5 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_STATUS_1	Status of level 1 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_STATUS_2	Status of level 2 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_STATUS_3	Status of level 3 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_STATUS_4	Status of level 4 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
ORIG_PROGRAM_STATUS_5	Status of level 5 program within this program hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
OTHER_DATA	User-defined free-form description.	VARCHAR2(63)	FGBTRND	FGBTRND_OTHER_DATA
POSTING_PERIOD	Unique two-digit identifier of a period posted to with amounts within a fiscal year. Generally this contains values between 00 and 14.	VARCHAR2(63)	FGBTRND	FGBTRND_POSTING_PERIOD
POST_CASHIER	Unique identification code of the user who entered the transaction.	VARCHAR2(63)	FGBTRNH	FGBTRNH_USER_ID
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	FGBTRND	FGBTRND_PROG_CODE
PROGRAM_DESC	Description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
PROGRAM_STATUS	Current status of the associated program.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
PROJECT	Work order code used within cost accounting module.	VARCHAR2(63)	FGBTRNH	FGBTRNH_PRJD_CODE
RECONCILIATION_IND	Indicates if a deposit has been reconciled.	VARCHAR2(63)	FGBTRND	FGBTRND_RECON_IND
REVERSAL_IND	Indicates if a document was canceled or reversed.	VARCHAR2(63)	FGBTRNH	FGBTRNH_REVERSAL_IND
RULE_CLASS	Accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	FGBTRND	FGBTRND_RUCL_CODE
RULE_CLASS_DESC	Unique title assigned to a rule class.	VARCHAR2(255)	FTVRUCL	FTVRUCL_CLASS_TITLE
RULE_PROCESS	Four-digit field that is an assigned sequence number to each process within a rule code.	VARCHAR2(63)	FGBTRND	FGBTRND_RULP_CODE
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	NUMBER	FGBTRNH	FGBTRNH_SEQ_NUM
SERIAL_NUMBER	Unique system assigned number to control unique creation of transaction source history records.	NUMBER	FGBTRNH	FGBTRNH_SERIAL_NUM
SUBMISSION_NUMBER	Submission number used for documents that utilized resubmission features.	NUMBER	FGBTRNH	FGBTRNH_SUBMISSION_NUMBER
SUM_POSTING_DOCUMENT_CODE	Document number generated in a given posting run to facilitate summary general ledger postings. Format is MMDDHHMM.	VARCHAR2(63)	FGBTRNH	FGBTRNH_SUM_POST_DOC_CODE
TRANSACTION_AMOUNT	Amount of the transaction associated with this particular account distribution.	NUMBER	FGBTRND	FGBTRND_TRANS_AMT
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FGBTRNH	FGBTRNH_TRANS_DATE
TRANSACTION_DESC	Accounting transaction description.	VARCHAR2(255)	FGBTRNH	FGBTRNH_TRANS_DESC
VENDOR_ID	User-defined or system generated one-up number of the vendor.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
VENDOR_NAME	Vendor name.	VARCHAR2(255)	FUNCTION FUNCTION SPRIDEN	F_FORMAT_NAME MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FGBTRNH	FGBTRNH_VENDOR_PIDM

Ver: 9.1