Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACCOUNT
|
Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.
|
VARCHAR2(63)
|
FTCRACTG
|
ACCT_CODE
|
NO
|
NO
|
ACCOUNT_DESC
|
Account description.
|
VARCHAR2(255)
|
FTVACCT
|
FTVACCT_TITLE
|
NO
|
NO
|
ACCOUNT_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
NO
|
NO
|
ACCOUNT_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
NO
|
NO
|
ACCOUNT_DESC_3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
NO
|
NO
|
ACCOUNT_DESC_4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ACCT_HIER
|
NO
|
NO
|
ACCOUNT_INDEX
|
Account Index used to default an accounting distribution.
|
VARCHAR2(63)
|
FTCRACTG
|
ACCI_CODE
|
NO
|
NO
|
ACCOUNT_INDEX_DESC
|
Account index description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
ACCOUNT_TYPE_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVATYP
|
FTVATYP_TITLE
|
NO
|
NO
|
ACCOUNT_TYPE_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVATYP
|
FTVATYP_TITLE
|
NO
|
NO
|
ACCOUNT_TYPE_LEVEL_1
|
Classifies an account type i.e., asset, revenue, etc. for reporting purposes.
|
VARCHAR2(63)
|
FTVATYP
|
FTVATYP_ATYP_CODE
|
NO
|
NO
|
ACCOUNT_TYPE_LEVEL_2
|
Classifies an account type i.e., asset, revenue, etc. for reporting purposes.
|
VARCHAR2(63)
|
FTVACCT
|
FTVACCT_ATYP_CODE
|
NO
|
NO
|
ACTIVITY
|
Code used to identify accounting data by activity.
|
VARCHAR2(63)
|
FTCRACTG
|
ACTV_CODE
|
NO
|
NO
|
ACTIVITY_DESC
|
Activity description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
AMOUNT
|
Amount entered on the funding source to be used for the expense.
|
NUMBER
|
FTCRACTG
|
AMOUNT
|
NO
|
NO
|
AUTHORIZATION
|
System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq.
|
VARCHAR2(63)
|
FTRBAUTH
|
DOC_CODE
|
NO
|
NO
|
AUTHORIZATION_DESC
|
Authorization request description.
|
VARCHAR2(255)
|
FTRBAUTH
|
DESCRIPTION
|
NO
|
NO
|
AUTHORIZATION_KEY
|
Unique internal identification number of the authorization record.
|
NUMBER
|
FTPREXPS
|
FTRBAUTH_ID
|
NO
|
NO
|
AUTHORIZATION_STATUS
|
Authorization request status.
|
VARCHAR2(63)
|
FTRBAUTH
|
REQUEST_STATUS
|
NO
|
NO
|
AUTHORIZATION_STATUS_DESC
|
Authorization request status description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS
|
NO
|
NO
|
CALCULATED_AMOUNT_NO_TAX
|
Calculated amount in base currency without taxes. Used when invoice is created in base currency like in bank transfers.
|
NUMBER
|
FTCRACTG
|
APPR_AMOUNT
|
NO
|
NO
|
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
|
NO
|
NO
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
NO
|
NO
|
DISTRIBUTION_PERCENT
|
Percentage of the transaction total amount assigned to this accounting distribution.
|
NUMBER
|
FTCRACTG
|
PERCENT_OF_TOTAL
|
NO
|
NO
|
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
|
NO
|
NO
|
EXPENSE_ITEM_KEY
|
Unique internal identification number of the expense item record.
|
NUMBER
|
FTCRACTG
|
FTPREXPS_ID
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
FTCRACTG
|
FUND_CODE
|
NO
|
NO
|
FUNDING_ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
DATE
|
FTCRACTG
|
ACTIVITY_DATE
|
NO
|
NO
|
FUNDING_CREATE_DATE
|
Date and time when the new expense detail record was created.
|
DATE
|
FTCRACTG
|
CREATE_DATE
|
NO
|
NO
|
FUNDING_CREATE_SOURCE
|
Source system that created the data.
|
VARCHAR2(63)
|
FTCRACTG
|
CREATE_SOURCE
|
NO
|
NO
|
FUNDING_CREATE_USER
|
Banner ID of the person who created this new record.
|
VARCHAR2(63)
|
FTCRACTG
|
CREATE_USER
|
NO
|
NO
|
FUNDING_DATA_ORIGIN
|
Source system that created or updated the data.
|
VARCHAR2(63)
|
FTCRACTG
|
DATA_ORIGIN
|
NO
|
NO
|
FUNDING_USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
FTCRACTG
|
USER_ID
|
NO
|
NO
|
FUND_DESC
|
Fund description.
|
VARCHAR2(255)
|
FTVFUND
|
FTVFUND_TITLE
|
NO
|
NO
|
FUND_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_DESC_3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_DESC_4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_DESC_5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_FINANCIAL_MANAGER_ID
|
System generated or manually assigned ID that uniquely identifies the financial manager.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO
|
NO
|
FUND_FINANCIAL_MANAGER_UID
|
System generated, unique, internal identification number assigned to the financial manager for the fund.
|
NUMBER
|
FTVFUND
|
FTVFUND_FMGR_CODE_PIDM
|
NO
|
NO
|
FUND_FMGR_CITY
|
City associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
NO
|
NO
|
FUND_FMGR_COUNTY
|
County code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
NO
|
NO
|
FUND_FMGR_COUNTY_DESC
|
County address name.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
NO
|
NO
|
FUND_FMGR_FIRST_NAME
|
Financial manager's first or given name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
FUND_FMGR_LAST_NAME
|
Fund manager's last name or surname.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
FUND_FMGR_MIDDLE_NAME
|
Financial manager's middle name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
FUND_FMGR_NATION
|
Nation code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
NO
|
NO
|
FUND_FMGR_NATION_DESC
|
Name of the nation.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
FUND_FMGR_POSTAL_CODE
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
NO
|
NO
|
FUND_FMGR_STATE_PROVINCE
|
State/Province code for the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
NO
|
NO
|
FUND_FMGR_STATE_PROVINCE_DESC
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTST_DESC
|
NO
|
NO
|
FUND_FMGR_STREET_LINE1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
NO
|
NO
|
FUND_FMGR_STREET_LINE2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
NO
|
NO
|
FUND_FMGR_STREET_LINE3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
NO
|
NO
|
FUND_FMGR_STREET_LINE4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
NO
|
NO
|
FUND_LEVEL_1
|
Primary Fund within the fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_LEVEL_2
|
Level 2 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_LEVEL_3
|
Level 3 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_LEVEL_4
|
Level 4 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_LEVEL_5
|
Level 5 fund within this Fund Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_FUND_HIER
|
NO
|
NO
|
FUND_TYPE_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVFTYP
|
FTVFTYP_TITLE
|
NO
|
NO
|
FUND_TYPE_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FTVFTYP
|
FTVFTYP_TITLE
|
NO
|
NO
|
FUND_TYPE_LEVEL_1
|
Level 1 fund type within this Fund Hierarchy.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FTYP_CODE
|
NO
|
NO
|
FUND_TYPE_LEVEL_2
|
Level 2 fund type within this Fund Hierarchy.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_FTYP_CODE
|
NO
|
NO
|
GRANT_DESC
|
Extracted shortened name or title for the grant.
|
VARCHAR2(255)
|
FUNCTION
|
FRKIDEN.F_GET_FRBGRNT_TITLE
|
NO
|
NO
|
GRANT_ID
|
Unique user defined or system generated one-up number for this grant.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_GRNT_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
INTERNAL_ACCOUNT_TYPE_DESC
|
Internal account type description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
NO
|
NO
|
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
|
NO
|
NO
|
INTERNAL_FUND_TYPE_DESC
|
Internal fund type description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
NO
|
NO
|
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
|
NO
|
NO
|
LOCATION_DESC
|
Location description.
|
VARCHAR2(255)
|
FTVLOCN
|
FTVLOCN_TITLE
|
NO
|
NO
|
LOCATION_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_DESC_3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_DESC_4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_DESC_5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_LEVEL_1
|
Level 1 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_LEVEL_2
|
Level 2 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_LEVEL_3
|
Level 3 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_LEVEL_4
|
Level 4 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
LOCATION_LEVEL_5
|
Level 5 location within this location Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_LOCN_HIER
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ORGANIZATION_CODE
|
Identification accounting code designating a department within the institution.
|
VARCHAR2(63)
|
FTCRACTG
|
ORGN_CODE
|
NO
|
NO
|
ORGANIZATION_DESC
|
Organization code description.
|
VARCHAR2(255)
|
FTVORGN
|
FTVORGN_TITLE
|
NO
|
NO
|
ORGANIZATION_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_6
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_7
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_DESC_8
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_1
|
primary organization within the organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_2
|
Level 2 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_3
|
Level 3 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_4
|
Level 4 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_5
|
Level 5 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_6
|
Level 6 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_7
|
Level 7 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGANIZATION_LEVEL_8
|
Level 8 organization within this organization Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
NO
|
NO
|
ORGN_FINANCIAL_MANAGER_ID
|
System generated or manually assigned ID that uniquely identifies the financial manager.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO
|
NO
|
ORGN_FINANCIAL_MANAGER_UID
|
System generated, unique, internal identification number assigned to the financial manager for the organization.
|
NUMBER
|
FTVORGN
|
FTVORGN_FMGR_CODE_PIDM
|
NO
|
NO
|
ORGN_FMGR_CITY
|
City associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
NO
|
NO
|
ORGN_FMGR_COUNTY
|
County code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
NO
|
NO
|
ORGN_FMGR_COUNTY_DESC
|
County address name.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
NO
|
NO
|
ORGN_FMGR_FIRST_NAME
|
Financial manager's first or given name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
ORGN_FMGR_LAST_NAME
|
Fund manager's last name or surname.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
ORGN_FMGR_MIDDLE_NAME
|
Financial manager's middle name.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
ORGN_FMGR_NATION
|
Nation code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
NO
|
NO
|
ORGN_FMGR_NATION_DESC
|
Name of the nation.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
ORGN_FMGR_POSTAL_CODE
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
NO
|
NO
|
ORGN_FMGR_STATE_PROVINCE
|
State/Province code for the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
NO
|
NO
|
ORGN_FMGR_STATE_PROVINCE_DESC
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTST_DESC
|
NO
|
NO
|
ORGN_FMGR_STREET_LINE1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
NO
|
NO
|
ORGN_FMGR_STREET_LINE2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
NO
|
NO
|
ORGN_FMGR_STREET_LINE3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
NO
|
NO
|
ORGN_FMGR_STREET_LINE4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
NO
|
NO
|
PAY_CURRENCY_AMOUNT
|
Amount to be paid to the traveler in pay currency.
|
NUMBER
|
FTCRACTG
|
PAY_AMOUNT
|
NO
|
NO
|
PAY_CURRENCY_AMOUNT_NO_TAX
|
Amount to be paid to the traveler in pay currency without taxes.
|
NUMBER
|
FTCRACTG
|
PAY_APPR_AMOUNT
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
PORTFOLIO_KEY
|
Unique internal identification number of the portfolio record.
|
NUMBER
|
FTRBAUTH
|
FTPBPORT_ID
|
NO
|
NO
|
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
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
PROGRAM_DESC
|
Program description.
|
VARCHAR2(255)
|
FTVPROG
|
FTVPROG_TITLE
|
NO
|
NO
|
PROGRAM_DESC_1
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_DESC_2
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_DESC_3
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_DESC_4
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_DESC_5
|
Hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_LEVEL_1
|
primary program within the program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_LEVEL_2
|
Level 2 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_LEVEL_3
|
Level 3 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_LEVEL_4
|
Level 4 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROGRAM_LEVEL_5
|
Level 5 program within this program Hierarchy.
|
VARCHAR2(63)
|
FUNCTION
|
FOKODSF.F_GET_PROG_HIER
|
NO
|
NO
|
PROJECT
|
Identification code for a project defined in cost accounting.
|
VARCHAR2(63)
|
FTCRACTG
|
PROJ_CODE
|
NO
|
NO
|
PROJECT_DESC
|
Project description.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
NO
|
NO
|
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
|
FTRBAUTH
|
TRANSACTION_DATE
|
NO
|
NO
|