Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: TRANSACTION_HISTORY

Description Contains source transaction accounting distirbution history and ledger posting detail information. This includes the type of document, ledger indicator, which ledger field updated, rule process, rule class, document reference number, bank, vendor, budget period, and accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location. Used to reconcile the various ledgers and provide detail financial activity.
Key & Frequency Multiple rows for each source financial transaction.
Recommended Search Columns CHART_OF_ACCOUNTS, ACCOUNT_INDEX
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
DOCUMENT, DOCUMENT_TYPE, SUBMISSION_NUMBER, ITEM, SEQUENCE_NUMBER, SERIAL_NUMBER, REVERSAL_IND, LEDGER_IND
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION, TRANSACTION_DATE
ENCUMBRANCE_NUMBER, ENCUMBRANCE_ITEM_NUMBER, ENCUMBRANCE_SEQ_NUMBER, LEDGER_IND
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, ACCOUNT_INDEX, TRANSACTION_DATE
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, FIELD_CODE, FUND, ACCOUNT, ORGANIZATION_CODE, ACTUAL_FUND_TYPE_LEVEL_2
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, DETAIL_POSTING_PROCESS, RULE_CLASS, BANK
CHART_OF_ACCOUNTS, FISCAL_YEAR, ACTIVITY_DATE, LEDGER_IND, DETAIL_USER_ID
CHART_OF_ACCOUNTS, FISCAL_YEAR, TRANSACTION_DATE
FISCAL_YEAR_HEADER, TRANSACTION_DATE, CHART_OF_ACCOUNTS

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(63)

FGBTRND

FGBTRND_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 code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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(63)

FGBTRND

FGBTRND_ACCI_CODE

ACCOUNT_INDEX_DESC Account INDEX Description Account index description. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_INDEX_STATUS Account INDEX Status Current status of the associated account index. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

ACCOUNT_POOL 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 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 Account Status Current status of the associated account. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

ACCRUAL_IND Accrual Indicator 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 Activity Code used to identify accounting data by activity. VARCHAR2(63)

FGBTRND

FGBTRND_ACTV_CODE

ACTIVITY_DATE Activity Date Date that information for this record in the table was entered or last updated. DATE

FGBTRND

FGBTRND_ACTIVITY_DATE

ACTIVITY_DESC Activity Description Activity code title or description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

ACTIVITY_STATUS Activity Status Current status of the associated activity. VARCHAR2(63)

FTVACTV

FTVACTV_STATUS_IND

ACTUAL_ACCOUNT_DESC_1 Actual Account Description 1 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACTUAL_ACCOUNT_DESC_2 Actual Account Description 2 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACTUAL_ACCOUNT_DESC_3 Actual Account Description 3 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACTUAL_ACCOUNT_DESC_4 Actual Account Description 4 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACTUAL_ACCOUNT_LEVEL_1 Actual Account Level 1 Primary account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CODE

ACTUAL_ACCOUNT_LEVEL_2 Actual Account Level 2 Level 2 account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CODE

ACTUAL_ACCOUNT_LEVEL_3 Actual Account Level 3 Level 3 account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CODE

ACTUAL_ACCOUNT_LEVEL_4 Actual Account Level 4 Level 4 account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CODE

ACTUAL_ACCOUNT_STATUS_1 Actual Account Status 1 Status of the primary account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

ACTUAL_ACCOUNT_STATUS_2 Actual Account Status 2 Status of the level 2 account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

ACTUAL_ACCOUNT_STATUS_3 Actual Account Status 3 Status of the level 3 account within the account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

ACTUAL_ACCOUNT_STATUS_4 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 Actual Account Type Description 1 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FTVATYP

FTVATYP_TITLE

ACTUAL_ACCOUNT_TYPE_DESC_2 Actual Account Type Description 2 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FTVATYP

FTVATYP_TITLE

ACTUAL_ACCOUNT_TYPE_LEVEL_1 Actual Account Type Level 1 Primary account type within the account hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_ATYP_CODE

ACTUAL_ACCOUNT_TYPE_LEVEL_2 Actual Account Type Level 2 Level 2 account type within the account hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_ATYP_CODE

ACTUAL_ACCOUNT_TYPE_STATUS_1 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 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 Actual Fund Description 1 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

ACTUAL_FUND_DESC_2 Actual Fund Description 2 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

ACTUAL_FUND_DESC_3 Actual Fund Description 3 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

ACTUAL_FUND_DESC_4 Actual Fund Description 4 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

ACTUAL_FUND_DESC_5 Actual Fund Description 5 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

ACTUAL_FUND_LEVEL_1 Actual Fund Level 1 Primary fund within the fund hierarchy. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

ACTUAL_FUND_LEVEL_2 Actual Fund Level 2 Level 2 fund within the fund hierarchy. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

ACTUAL_FUND_LEVEL_3 Actual Fund Level 3 Level 3 fund within the fund hierarchy. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

ACTUAL_FUND_LEVEL_4 Actual Fund Level 4 Level 4 fund within the fund hierarchy. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

ACTUAL_FUND_LEVEL_5 Actual Fund Level 5 Level 5 fund within the fund hierarchy. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

ACTUAL_FUND_STATUS_1 Actual Fund Status 1 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

ACTUAL_FUND_STATUS_2 Actual Fund Status 2 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

ACTUAL_FUND_STATUS_3 Actual Fund Status 3 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

ACTUAL_FUND_STATUS_4 Actual Fund Status 4 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

ACTUAL_FUND_STATUS_5 Actual Fund Status 5 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

ACTUAL_FUND_TYPE_DESC_1 Actual Fund Type Description 1 Status of the primary fund type within the fund hierarchy. VARCHAR2(255)

FTVFTYP

FTVFTYP_TITLE

ACTUAL_FUND_TYPE_DESC_2 Actual Fund Type Description 2 Status of the level 2 fund type within the fund hierarchy. VARCHAR2(255)

FTVFTYP

FTVFTYP_TITLE

ACTUAL_FUND_TYPE_LEVEL_1 Actual Fund Type Level 1 Fund type level 1. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

ACTUAL_FUND_TYPE_LEVEL_2 Actual Fund Type Level 2 Fund type level 2. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

ACTUAL_FUND_TYPE_STATUS_1 Actual Fund Type Status 1 Status of the fund type. VARCHAR2(63)

FTVFTYP

FTVFTYP_STATUS_IND

ACTUAL_FUND_TYPE_STATUS_2 Actual Fund Type Status 2 Status of the fund type. VARCHAR2(63)

FTVFTYP

FTVFTYP_STATUS_IND

ACTUAL_LOCATION_DESC_1 Actual Location Description 1 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ACTUAL_LOCATION_DESC_2 Actual Location Description 2 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ACTUAL_LOCATION_DESC_3 Actual Location Description 3 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ACTUAL_LOCATION_DESC_4 Actual Location Description 4 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ACTUAL_LOCATION_DESC_5 Actual Location Description 5 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ACTUAL_LOCATION_LEVEL_1 Actual Location Level 1 Level 1 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_LOCN_CODE

ACTUAL_LOCATION_LEVEL_2 Actual Location Level 2 Level 2 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_LOCN_CODE

ACTUAL_LOCATION_LEVEL_3 Actual Location Level 3 Level 3 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_LOCN_CODE

ACTUAL_LOCATION_LEVEL_4 Actual Location Level 4 Level 4 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_LOCN_CODE

ACTUAL_LOCATION_LEVEL_5 Actual Location Level 5 Level 5 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_LOCN_CODE

ACTUAL_LOCATION_STATUS_1 Actual Location Status 1 Status of the level 1 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

ACTUAL_LOCATION_STATUS_2 Actual Location Status 2 Status of the level 2 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

ACTUAL_LOCATION_STATUS_3 Actual Location Status 3 Status of the level 3 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

ACTUAL_LOCATION_STATUS_4 Actual Location Status 4 Status of the level 4 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

ACTUAL_LOCATION_STATUS_5 Actual Location Status 5 Status of the level 5 location within this location hierarchy. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

ACTUAL_ORGANIZATION_DESC_1 Actual Organization Description 1 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_2 Actual Organization Description 2 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_3 Actual Organization Description 3 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_4 Actual Organization Description 4 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_5 Actual Organization Description 5 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_6 Actual Organization Description 6 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_7 Actual Organization Description 7 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_DESC_8 Actual Organization Description 8 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ACTUAL_ORGANIZATION_LEVEL_1 Actual Organization Level 1 Primary organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_2 Actual Organization Level 2 Level 2 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_3 Actual Organization Level 3 Level 3 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_4 Actual Organization Level 4 Level 4 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_5 Actual Organization Level 5 Level 5 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_6 Actual Organization Level 6 Level 6 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_7 Actual Organization Level 7 Level 7 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_LEVEL_8 Actual Organization Level 8 Level 8 organization within the organization hierarchy. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

ACTUAL_ORGANIZATION_STATUS_1 Actual Organization Status 1 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_2 Actual Organization Status 2 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_3 Actual Organization Status 3 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_4 Actual Organization Status 4 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_5 Actual Organization Status 5 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_6 Actual Organization Status 6 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_7 Actual Organization Status 7 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_ORGANIZATION_STATUS_8 Actual Organization Status 8 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ACTUAL_PROGRAM_DESC_1 Actual Program Description 1 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ACTUAL_PROGRAM_DESC_2 Actual Program Description 2 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ACTUAL_PROGRAM_DESC_3 Actual Program Description 3 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ACTUAL_PROGRAM_DESC_4 Actual Program Description 4 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ACTUAL_PROGRAM_DESC_5 Actual Program Description 5 Hierarchy description or title appropriate for this level. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ACTUAL_PROGRAM_LEVEL_1 Actual Program Level 1 Primary program within the program hierarchy. VARCHAR2(63)

FTVPROG

FTVPROG_PROG_CODE

ACTUAL_PROGRAM_LEVEL_2 Actual Program Level 2 Level 2 program within the program hierarchy. VARCHAR2(63)

FTVPROG

FTVPROG_PROG_CODE

ACTUAL_PROGRAM_LEVEL_3 Actual Program Level 3 Level 3 program within the program hierarchy. VARCHAR2(63)

FTVPROG

FTVPROG_PROG_CODE

ACTUAL_PROGRAM_LEVEL_4 Actual Program Level 4 Level 4 program within the program hierarchy. VARCHAR2(63)

FTVPROG

FTVPROG_PROG_CODE

ACTUAL_PROGRAM_LEVEL_5 Actual Program Level 5 Level 5 program within the program hierarchy. VARCHAR2(63)

FTVPROG

FTVPROG_PROG_CODE

ACTUAL_PROGRAM_STATUS_1 Actual Program Status 1 Current status of the associated program. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

ACTUAL_PROGRAM_STATUS_2 Actual Program Status 2 Current status of the associated program. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

ACTUAL_PROGRAM_STATUS_3 Actual Program Status 3 Current status of the associated program. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

ACTUAL_PROGRAM_STATUS_4 Actual Program Status 4 Current status of the associated program. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

ACTUAL_PROGRAM_STATUS_5 Actual Program Status 5 Current status of the associated program. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AMOUNT_IND Amount Indicator Indicates the amount was posted. VARCHAR2(63)

FGBTRND

FGBTRND_AMT_IND

AUTO_JOURNAL_ID Auto Journal ID User-defined value providing unique identification for a recurring journal voucher. VARCHAR2(63)

FGBTRNH

FGBTRNH_AUTO_JRNL_ID

AVAILABLE_BUDGET_OVERRIDE Available Budget Override Indicates if available fund checking was overridden when a lack of funds condition existed. VARCHAR2(63)

FGBTRNH

FGBTRNH_ABAL_OVERRIDE

BANK Bank Code used to identify the bank account on all cash transactions. VARCHAR2(63)

FGBTRNH

FGBTRNH_BANK_CODE

BANK_DESC Bank Description Name of the bank where the institution has accounts. VARCHAR2(255)

GXVBANK

GXVBANK_ACCT_NAME

BANK_ID Bank ID ID of the bank where the Institution has accounts. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

BANK_NAME Bank Name Official banking institution name. VARCHAR2(255)

FUNCTION

FUNCTION

FRKIDEN.F_GET_SPRIDEN_LAST_NAME

MGKFUNC.F_GET_PERSON_INFO

BANK_UID Bank UID Internal identification number of the bank used at time the transaction occurred. NUMBER

GXVBANK

GXVBANK_BANK_CODE_PIDM

BUDGET_DISPOSITION Budget Disposition Indicator that determines the year-end processing or budget requested encumbrance amounts. VARCHAR2(63)

FGBTRNH

FGBTRNH_BUD_DISPN

BUDGET_ID 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 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 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 Description Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_POOL 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 Chart Of Accounts Pool Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Current status of the associated chart of accounts. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

COMMIT_PERCENT Commit Percent Percentage of budget to be rolled into the next fiscal year as committed funds. NUMBER

FGBTRND

FGBTRND_CMT_PCT

COMMIT_TYPE 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 Convert Amount Base currency amount calculated for this accounting record. NUMBER

FGBTRNH

FGBTRNH_CONVERT_AMT

COST_SHARE_RATE Cost Share Rate Cost share rate for this grant. NUMBER

FGBTRND

FGBTRND_CS_RATE_PERCENT

CURRENCY Currency Type of currency represented in the amount field. VARCHAR2(63)

FGBTRNH

FGBTRNH_CURR_CODE

CURRENCY_DESC Currency Description Currency code description or title. VARCHAR2(255)

GTVCURR

GTVCURR_TITLE

DEBIT_CREDIT_IND Debit Credit Indicator 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 Deposit number assigned to this transaction. VARCHAR2(63)

FGBTRNH

FGBTRNH_DEP_NUM

DETAIL_BUDGET_PERIOD 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 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 Detail Posting Process Description Posting process description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

DETAIL_PROJECT Detail Project Work order code associated with the transaction. VARCHAR2(63)

FGBTRND

FGBTRND_PRJD_CODE

DETAIL_REVERSAL_IND Detail Reversal Indicator Indicates if a document was canceled or reversed. VARCHAR2(63)

FGBTRND

FGBTRND_REVERSAL_IND

DETAIL_SERIAL_NUMBER 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 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 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 Direct/indirect indicator. VARCHAR2(63)

NA

NA

DISTRIBUTION_PERCENT Distribution Percent Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER

FGBTRNH

FGBTRNH_DIST_PCT

DOCUMENT Document User-defined or system generated document number. VARCHAR2(63)

FGBTRNH

FGBTRNH_DOC_CODE

DOCUMENT_DATE Document Date Document date. DATE

NA

NA

DOCUMENT_TYPE 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 Type Description Document/entity type description. VARCHAR2(255)

FTVDTYP

FTVDTYP_DESC

DOC_REFERENCE_NUMBER Doc Reference Number User-defined number providing additional identification for the transaction. VARCHAR2(63)

FGBTRNH

FGBTRNH_DOC_REF_NUM

DOC_REFERENCE_NUMBER2 Doc Reference Number 2 Second user-defined number providing additional identification for the transaction. VARCHAR2(63)

NA

NA

ENCUMBRANCE_ACTION_IND Encumbrance Action Indicator Liquidation action on encumbrances as partial, total, adjustment or original. VARCHAR2(63)

FGBTRNH

FGBTRNH_ENCD_ACTION_IND

ENCUMBRANCE_ITEM_NUMBER Encumbrance Item Number Number associated with each individual commodity on the encumbering document. NUMBER

FGBTRND

FGBTRND_ENCD_ITEM_NUM

ENCUMBRANCE_NUMBER Encumbrance Number Unique encumbrance code of a document. VARCHAR2(63)

FGBTRND

FGBTRND_ENCD_NUM

ENCUMBRANCE_SEQ_NUMBER Encumbrance Sequence Number Number associated with each accounting distribution on an encumbering document. NUMBER

FGBTRND

FGBTRND_ENCD_SEQ_NUM

ENCUMBRANCE_TYPE 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 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 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 Field Code Two-digit code that represents the specific ledger bucket being updated. VARCHAR2(63)

FGBTRND

FGBTRND_FIELD_CODE

FISCAL_PERIOD_HEADER 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 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 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 Fund Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

FGBTRND

FGBTRND_FUND_CODE

FUND_DESC Fund Description Description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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_POOL 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 Fund Pool Description 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 Fund Status Current status of the associated fund. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

GRANT_DESC Grant Description Shortened name or title for the grant. VARCHAR2(255)

FUNCTION

FRKIDEN.F_GET_FRBGRNT_TITLE

GRANT_ID Grant ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)

FTVFUND

FTVFUND_GRNT_CODE

GRANT_STATUS Grant Status Current grant status. VARCHAR2(63)

FUNCTION

FRKIDEN.F_GET_FRBGRNT_STATUS_CODE

INDIRECT_COST_MEMO_RATE Indirect Cost Memo Rate Indirect cost memo rate percentage. NUMBER

FGBTRND

FGBTRND_IC_MEMO_RATE_PERCENT

INDIRECT_COST_RATE Indirect Cost Rate Indirect cost rate percentage for the grant fund. NUMBER

FGBTRND

FGBTRND_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)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ITEM Item System-generated line item number that identifies each commodity line item for procurement documents. NUMBER

FGBTRNH

FGBTRNH_ITEM_NUM

LEDGER_IND Ledger Indicator 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 Liquidation amount. NUMBER

NA

NA

LOCATION Location Identification accounting code of the physical location of the financial manager. VARCHAR2(63)

FGBTRND

FGBTRND_LOCN_CODE

LOCATION_DESC Location Description Description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

LOCATION_STATUS Location Status Current status of the associated location. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NORMAL_BALANCE Normal Balance Indicator 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 used for the department. VARCHAR2(63)

FGBTRND

FGBTRND_ORGN_CODE

ORGANIZATION_DESC Organization Description Description or title associated with the organization code. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_POOL 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 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 Organization Status Current status of the associated organization. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

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_1 Orig Account Description 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 Orig Account Description 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 Orig Account Description 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 Orig Account Description 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 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 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 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 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 Original 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 Orig Account Pool Description 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 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 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 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 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 Orig Account Type Description 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 Orig Account Type Description 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 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 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 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 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 Orig Fund Description 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 Orig Fund Description 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 Orig Fund Description 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 Orig Fund Description 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 Orig Fund Description 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 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 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 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 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 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 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 Orig Fund Pool Description 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 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 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 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 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 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 Orig Fund Type Description 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 Orig Fund Type Description 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 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 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 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 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 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 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 Orig Internal Fund Type Description 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 Orig Location Description 1 Description or title level 1 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_DESC_2 Orig Location Description 2 Description or title level 2 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_DESC_3 Orig Location Description 3 Description or title level 3 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_DESC_4 Orig Location Description 4 Description or title level 4 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_DESC_5 Orig Location Description 5 Description or title level 5 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_LEVEL_1 Orig Location Level 1 Level 1 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_LEVEL_2 Orig Location Level 2 Level 2 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_LEVEL_3 Orig Location Level 3 Level 3 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_LEVEL_4 Orig Location Level 4 Level 4 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_LEVEL_5 Orig Location Level 5 Level 5 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_STATUS_1 Orig Location Status 1 Status level 1 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_STATUS_2 Orig Location Status 2 Status level 2 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_STATUS_3 Orig Location Status 3 Status level 3 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_STATUS_4 Orig Location Status 4 Status level 4 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_LOCATION_STATUS_5 Orig Location Status 5 Status level 5 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

ORIG_ORGANIZATION_DESC_1 Orig Organization Description 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 Orig Organization Description 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 Orig Organization Description 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 Orig Organization Description 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 Orig Organization Description 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 Orig Organization Description 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 Orig Organization Description 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 Orig Organization Description 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Orig Program Description 1 Description or title level 1 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_DESC_2 Orig Program Description 2 Description or title level 2 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_DESC_3 Orig Program Description 3 Description or title level 3 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_DESC_4 Orig Program Description 4 Description or title level 4 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_DESC_5 Orig Program Description 5 Description or title level 5 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_LEVEL_1 Orig Program Level 1 Level 1 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_LEVEL_2 Orig Program Level 2 Level 2 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_LEVEL_3 Orig Program Level 3 Level 3 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_LEVEL_4 Orig Program Level 4 Level 4 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_LEVEL_5 Orig Program Level 5 Level 5 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

ORIG_PROGRAM_STATUS_1 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 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 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 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 Orig Program Status 5 Status of level 5 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

OTHER_DATA Other Data User-defined free-form description. VARCHAR2(63)

FGBTRND

FGBTRND_OTHER_DATA

POSTING_PERIOD 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 Post Cashier Unique identification code of the user who entered the transaction. VARCHAR2(63)

FGBTRNH

FGBTRNH_USER_ID

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROGRAM 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 Program Description Description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

PROGRAM_STATUS Program Status Current status of the associated program. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

PROJECT Project Work order code used within cost accounting module. VARCHAR2(63)

FGBTRNH

FGBTRNH_PRJD_CODE

RECONCILIATION_IND Reconciliation Indicator Indicates if a deposit has been reconciled. VARCHAR2(63)

FGBTRND

FGBTRND_RECON_IND

REVERSAL_IND Reversal Indicator Indicates if a document was canceled or reversed. VARCHAR2(63)

FGBTRNH

FGBTRNH_REVERSAL_IND

RULE_CLASS Rule Class Accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

FGBTRND

FGBTRND_RUCL_CODE

RULE_CLASS_DESC Rule Class Description Unique title assigned to a rule class. VARCHAR2(255)

FTVRUCL

FTVRUCL_CLASS_TITLE

RULE_PROCESS 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 Sequence Number System-generated one-up number to support split accounting within a document. NUMBER

FGBTRNH

FGBTRNH_SEQ_NUM

SERIAL_NUMBER Serial Number Unique system assigned number to control unique creation of transaction source history records. NUMBER

FGBTRNH

FGBTRNH_SERIAL_NUM

SUBMISSION_NUMBER Submission Number Submission number used for documents that utilized resubmission features. NUMBER

FGBTRNH

FGBTRNH_SUBMISSION_NUMBER

SUM_POSTING_DOCUMENT_CODE 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 Transaction Amount Amount of the transaction associated with this particular account distribution. NUMBER

FGBTRND

FGBTRND_TRANS_AMT

TRANSACTION_DATE Transaction Date Date used by the finance system to control posting to the ledgers. DATE

FGBTRNH

FGBTRNH_TRANS_DATE

TRANSACTION_DESC Transaction Description Accounting transaction description. VARCHAR2(255)

FGBTRNH

FGBTRNH_TRANS_DESC

VENDOR_ID 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 Vendor name. VARCHAR2(255)

FUNCTION

FUNCTION

SPRIDEN

F_FORMAT_NAME

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

VENDOR_UID Vendor UID System generated unique internal identification number used to access the vendor. NUMBER

FGBTRNH

FGBTRNH_VENDOR_PIDM



Ver: 9.2