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)
|
FTCRACTG
|
ACCT_CODE
|
ACCOUNT_DESC
|
Account Description
|
Account description.
|
VARCHAR2(255)
|
FTVACCT
|
FTVACCT_TITLE
|
ACCOUNT_DESC_1
|
Account Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_DESC_2
|
Account Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_DESC_3
|
Account Description 3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_DESC_4
|
Account Description 4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_INDEX
|
Account INDEX
|
Account Index used to default an accounting distribution.
|
VARCHAR2(63)
|
FTCRACTG
|
ACCI_CODE
|
ACCOUNT_INDEX_DESC
|
Account INDEX Description
|
Account index description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
ACCOUNT_LEVEL_1
|
Account Level 1
|
Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_LEVEL_2
|
Account Level 2
|
Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_LEVEL_3
|
Account Level 3
|
Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_LEVEL_4
|
Account Level 4
|
Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
ACCOUNT_TYPE_DESC_1
|
Account Type Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVATYP
|
FTVATYP_TITLE
|
ACCOUNT_TYPE_DESC_2
|
Account Type Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVATYP
|
FTVATYP_TITLE
|
ACCOUNT_TYPE_LEVEL_1
|
Account Type Level 1
|
Classifies an account type i.e., asset, revenue, etc. for reporting purposes.
|
VARCHAR2(63)
|
FTVATYP
|
FTVATYP_ATYP_CODE
|
ACCOUNT_TYPE_LEVEL_2
|
Account Type Level 2
|
Classifies an account type i.e., asset, revenue, etc. for reporting purposes.
|
VARCHAR2(63)
|
FTVACCT
|
FTVACCT_ATYP_CODE
|
ACTIVITY
|
Activity
|
Code used to identify accounting data by activity.
|
VARCHAR2(63)
|
FTCRACTG
|
ACTV_CODE
|
ACTIVITY_DESC
|
Activity Description
|
Activity description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
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
|
Amount
|
Amount entered on the funding source to be used for the expense. The total of amount and percent (if any) must be equal to 100 percent for the expense item at final approval.
|
NUMBER
|
FTCRACTG
|
AMOUNT
|
BANK
|
Bank
|
Code used to identify the bank account on all cash transactions.
|
VARCHAR2(63)
|
FTCRACTG
|
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
|
MGKFUNC.F_GET_PERSON_INFO
|
BANK_NAME
|
Bank Name
|
Official banking institution name.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
BANK_UID
|
Bank UID
|
Internal identification number of the bank used at the time the transaction occurred.
|
NUMBER
|
GXVBANK
|
GXVBANK_BANK_CODE_PIDM
|
CALCULATED_AMOUNT_NO_TAX
|
Calculated Amount Number Tax
|
Calculated amount in base currency without taxes. Used when invoice is created in base currency like in bank transfers.
|
NUMBER
|
FTCRACTG
|
APPR_AMOUNT
|
CHART_OF_ACCOUNTS
|
Chart Of Accounts
|
Represents a systematic classification of accounts. Identifies a separate and distinct entity-accounting relationship within a multi-chart environment.
|
VARCHAR2(63)
|
FTCRACTG
|
COAS_CODE
|
CHART_OF_ACCOUNTS_DESC
|
Chart Of Accounts Description
|
Chart of accounts description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
DISTRIBUTION_PERCENT
|
Distribution Percent
|
Percentage of the transaction total amount assigned to this accounting distribution.
|
NUMBER
|
FTCRACTG
|
PERCENT_OF_TOTAL
|
EXPENSE_ADVANCE_CLEARED_IND
|
Expense Advance Cleared Indicator
|
Indicates whether the expense type is for an advance cleared amount
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC','Y','N')
|
EXPENSE_GROUP_ITEM
|
Expense Group Item
|
Groups expense items into one encumbrance line item or one invoice line item. Enables the liquidation of an encumbrance (travel authorization) by an invoice (travel reimbursement) line item by line item.
|
NUMBER
|
FTTVEXPG
|
EXPENSE_GROUP_ITEM
|
EXPENSE_ITEM_KEY
|
Expense Item KEY
|
Unique internal identification number of the expense item record.
|
NUMBER
|
FTCRACTG
|
FTPREXPS_ID
|
FINANCE_SECURITY_ID
|
Finance Security ID
|
Oracle user ID linked to the expense owner PIDM when it is available. Used for fund organization security checking in the event a finance profile exists for the expense owner.
|
VARCHAR2(63)
|
FTCRACTG
|
ORACLE_ID
|
FISCAL_PERIOD
|
Fiscal Period
|
Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.
|
VARCHAR2(63)
|
FUNCTION
|
SELECT SUBSTR(FISCAL_PERIOD,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE
|
FISCAL_YEAR
|
Fiscal Year
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
FUNCTION
|
SELECT SUBSTR(FISCAL_YEAR,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
FTCRACTG
|
FUND_CODE
|
FUNDING_ACTIVITY_DATE
|
Funding Activity Date
|
Date information for this record in the table was entered or last updated.
|
DATE
|
FTCRACTG
|
ACTIVITY_DATE
|
FUNDING_CREATE_DATE
|
Funding Create Date
|
Date and time when the new expense detail record was created.
|
DATE
|
FTCRACTG
|
CREATE_DATE
|
FUNDING_CREATE_SOURCE
|
Funding Create Source
|
Source system that created the data.
|
VARCHAR2(63)
|
FTCRACTG
|
CREATE_SOURCE
|
FUNDING_CREATE_USER
|
Funding Create User
|
Banner ID of the person who created this new record.
|
VARCHAR2(63)
|
FTCRACTG
|
CREATE_USER
|
FUNDING_DATA_ORIGIN
|
Funding Data Origin
|
Source system that created or updated the data.
|
VARCHAR2(63)
|
FTCRACTG
|
DATA_ORIGIN
|
FUNDING_USER_ID
|
Funding User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
FTCRACTG
|
USER_ID
|
FUND_DESC
|
Fund Description
|
Fund description.
|
VARCHAR2(255)
|
FTVFUND
|
FTVFUND_TITLE
|
FUND_DESC_1
|
Fund Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_DESC_2
|
Fund Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_DESC_3
|
Fund Description 3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_DESC_4
|
Fund Description 4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_DESC_5
|
Fund Description 5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_FINANCIAL_MANAGER_ID
|
Fund Financial Manager ID
|
Person's ID Number used to access the records associated with the person.
|
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 for the fund.
|
NUMBER
|
FTVFUND
|
FTVFUND_FMGR_CODE_PIDM
|
FUND_FMGR_CITY
|
Fund Financial Manager City
|
City associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
FUND_FMGR_COUNTY
|
Fund Financial Manager County
|
County code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
FUND_FMGR_COUNTY_DESC
|
Fund Financial Manager County Description
|
County address name.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
FUND_FMGR_FIRST_NAME
|
Fund Financial Manager First Name
|
Financial manager's first or given name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
FUND_FMGR_LAST_NAME
|
Fund Financial Manager Last Name
|
Fund manager's last name or surname.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
FUND_FMGR_MIDDLE_NAME
|
Fund Financial Manager Middle Name
|
Financial manager's middle name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
FUND_FMGR_NATION
|
Fund Financial Manager Nation
|
Nation code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
FUND_FMGR_NATION_DESC
|
Fund Financial Manager Nation Description
|
Name of the nation.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
FUND_FMGR_POSTAL_CODE
|
Fund Financial Manager Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
FUND_FMGR_STATE_PROVINCE
|
Fund Financial Manager State Province
|
State/Province code for the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
FUND_FMGR_STATE_PROVINCE_DESC
|
Fund Financial Manager State Province Description
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTST_DESC
|
FUND_FMGR_STREET_LINE1
|
Fund Financial Manager Street Line 1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
FUND_FMGR_STREET_LINE2
|
Fund Financial Manager Street Line 2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
FUND_FMGR_STREET_LINE3
|
Fund Financial Manager Street Line 3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
FUND_FMGR_STREET_LINE4
|
Fund Financial Manager Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
FUND_LEVEL_1
|
Fund Level 1
|
Primary Fund within the fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_LEVEL_2
|
Fund Level 2
|
Level 2 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_LEVEL_3
|
Fund Level 3
|
Level 3 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_LEVEL_4
|
Fund Level 4
|
Level 4 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_LEVEL_5
|
Fund Level 5
|
Level 5 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
FUND_TYPE_DESC_1
|
Fund Type Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVFTYP
|
FTVFTYP_TITLE
|
FUND_TYPE_DESC_2
|
Fund Type Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVFTYP
|
FTVFTYP_TITLE
|
FUND_TYPE_LEVEL_1
|
Fund Type Level 1
|
Primary Fund type within this Fund Hierarchy.
|
VARCHAR2(63)
|
FTVFTYP
|
FTVFTYP_FTYP_CODE
|
FUND_TYPE_LEVEL_2
|
Fund Type Level 2
|
Level 2 fund type within this Fund Hierarchy.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FTYP_CODE
|
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
|
INTERNAL_ACCOUNT_TYPE
|
Internal Account Type
|
Predefined values representing account types linked to level one account types. They are used to identify transactional data for processing and reporting purposes.
|
VARCHAR2(63)
|
FTVFTYP
|
FTVFTYP_INTERNAL_FTYP_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 representing fund types linked to level one fund types. Used to identify transactional data for processing and reporting purposes.
|
VARCHAR2(63)
|
FTVFTYP
|
FTVFTYP_INTERNAL_FTYP_CODE
|
INTERNAL_FUND_TYPE_DESC
|
Internal Fund Type Description
|
Internal fund type description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
LOCATION
|
Location
|
Identification accounting code of a physical location, used in fixed assets to define the location a fixed asset has been assigned to.
|
VARCHAR2(63)
|
FTCRACTG
|
LOCN_CODE
|
LOCATION_DESC
|
Location Description
|
Location description.
|
VARCHAR2(255)
|
FTVLOCN
|
FTVLOCN_TITLE
|
LOCATION_DESC_1
|
Location Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_DESC_2
|
Location Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_DESC_3
|
Location Description 3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_DESC_4
|
Location Description 4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_DESC_5
|
Location Description 5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_LEVEL_1
|
Location Level 1
|
Level 1 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_LEVEL_2
|
Location Level 2
|
Level 2 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_LEVEL_3
|
Location Level 3
|
Level 3 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_LEVEL_4
|
Location Level 4
|
Level 4 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
LOCATION_LEVEL_5
|
Location Level 5
|
Level 5 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
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
|
ORGANIZATION_CODE
|
Organization Code
|
Identification accounting code designating a department within the institution.
|
VARCHAR2(63)
|
FTCRACTG
|
ORGN_CODE
|
ORGANIZATION_DESC
|
Organization Description
|
Organization code description.
|
VARCHAR2(255)
|
FTVORGN
|
FTVORGN_TITLE
|
ORGANIZATION_DESC_1
|
Organization Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_2
|
Organization Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_3
|
Organization Description 3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_4
|
Organization Description 4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_5
|
Organization Description 5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_6
|
Organization Description 6
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_7
|
Organization Description 7
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_DESC_8
|
Organization Description 8
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_1
|
Organization Level 1
|
Primary organization within the organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_2
|
Organization Level 2
|
Level 2 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_3
|
Organization Level 3
|
Level 3 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_4
|
Organization Level 4
|
Level 4 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_5
|
Organization Level 5
|
Level 5 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_6
|
Organization Level 6
|
Level 6 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_7
|
Organization Level 7
|
Level 7 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGANIZATION_LEVEL_8
|
Organization Level 8
|
Level 8 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
ORGN_FINANCIAL_MANAGER_ID
|
Organization Financial Manager ID
|
System generated or manually assigned ID that uniquely identifies the financial manager.
|
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 for the organization.
|
NUMBER
|
FTVORGN
|
FTVORGN_FMGR_CODE_PIDM
|
ORGN_FMGR_CITY
|
Organization Financial Manager City
|
City associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
ORGN_FMGR_COUNTY
|
Organization Financial Manager County
|
County code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
ORGN_FMGR_COUNTY_DESC
|
Organization Financial Manager County Description
|
County address name.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
ORGN_FMGR_FIRST_NAME
|
Organization Financial Manager First Name
|
Financial manager's first or given name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
ORGN_FMGR_LAST_NAME
|
Organization Financial Manager Last Name
|
Fund manager's last name or surname.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
ORGN_FMGR_MIDDLE_NAME
|
Organization Financial Manager Middle Name
|
Financial manager's middle name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
ORGN_FMGR_NATION
|
Organization Financial Manager Nation
|
Nation code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
ORGN_FMGR_NATION_DESC
|
Organization Financial Manager Nation Description
|
Name of the nation.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
ORGN_FMGR_POSTAL_CODE
|
Organization Financial Manager Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
ORGN_FMGR_STATE_PROVINCE
|
Organization Financial Manager State Province
|
State/Province code for the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
ORGN_FMGR_STATE_PROVINCE_DESC
|
Organization Financial Manager State Province Description
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTST_DESC
|
ORGN_FMGR_STREET_LINE1
|
Organization Financial Manager Street Line 1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
ORGN_FMGR_STREET_LINE2
|
Organization Financial Manager Street Line 2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
ORGN_FMGR_STREET_LINE3
|
Organization Financial Manager Street Line 3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
ORGN_FMGR_STREET_LINE4
|
Organization Financial Manager Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
NULL
|
NULL
|
PAY_CURRENCY_AMOUNT
|
Pay Currency Amount
|
Amount to be paid to the traveler in pay currency.
|
NUMBER
|
FTCRACTG
|
PAY_AMOUNT
|
PAY_CURRENCY_AMOUNT_NO_TAX
|
Pay Currency Amount Number Tax
|
Amount to be paid to the traveler in pay currency without taxes.
|
NUMBER
|
FTCRACTG
|
PAY_APPR_AMOUNT
|
PAY_CURRENCY_TAX_AMOUNT
|
Pay Currency Tax Amount
|
Tax amount to be paid to the traveler in pay currency.
|
NUMBER
|
CALCULATION
|
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX
|
PORTFOLIO
|
Portfolio
|
System generated code identifying the portfolio. The prefix is defined by the client for system ID TRAVPORT in the table fobfseq.
|
VARCHAR2(63)
|
FTPBPORT
|
PORTFOLIO_NUMBER
|
PORTFOLIO_KEY
|
Portfolio KEY
|
Unique internal identification number of the portfolio record.
|
NUMBER
|
FTRBREMB
|
FTPBPORT_ID
|
PORTFOLIO_NAME
|
Portfolio Name
|
Name assigned to the Portfolio. As an example, Office expenses for year 2008 or Recruiting Trip in Southern California.
|
VARCHAR2(63)
|
FTPBPORT
|
NAME
|
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)
|
FTCRACTG
|
PROG_CODE
|
PROGRAM_DESC
|
Program Description
|
Program description.
|
VARCHAR2(255)
|
FTVPROG
|
FTVPROG_TITLE
|
PROGRAM_DESC_1
|
Program Description 1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_DESC_2
|
Program Description 2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_DESC_3
|
Program Description 3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_DESC_4
|
Program Description 4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_DESC_5
|
Program Description 5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_LEVEL_1
|
Program Level 1
|
primary program within the program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_LEVEL_2
|
Program Level 2
|
Level 2 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_LEVEL_3
|
Program Level 3
|
Level 3 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_LEVEL_4
|
Program Level 4
|
Level 4 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROGRAM_LEVEL_5
|
Program Level 5
|
Level 5 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
PROJECT
|
Project
|
Identification code for a project defined in cost accounting.
|
VARCHAR2(63)
|
FTCRACTG
|
PROJ_CODE
|
PROJECT_DESC
|
Project Description
|
Project description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
REIMBURSEMENT
|
Reimbursement
|
System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.
|
VARCHAR2(63)
|
FTRBREMB
|
DOC_CODE
|
REIMBURSEMENT_DESC
|
Reimbursement Description
|
Reimbursement request description.
|
VARCHAR2(255)
|
FTRBREMB
|
DESCRIPTION
|
REIMBURSEMENT_KEY
|
Reimbursement KEY
|
Unique internal identification number of the reimbursement record.
|
NUMBER
|
FTPREXPS
|
FTRBREMB_ID
|
REIMBURSEMENT_STATUS
|
Reimbursement Status
|
Reimbursement request status.
|
VARCHAR2(63)
|
FTRBREMB
|
REQUEST_STATUS
|
REIMBURSEMENT_STATUS_DESC
|
Reimbursement Status Description
|
Reimbursement request status description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS
|
TRANSACTION_DATE
|
Transaction Date
|
Date used to post the invoice into the ledgers for payment, determining the fiscal year and posting period. Represents the create date of the reimbursement.
|
DATE
|
FTRBREMB
|
TRANSACTION_DATE
|