1. Tables and Views for Financials
  2. EXM_AIRFARE_POL_LINES

EXM_AIRFARE_POL_LINES

This table contains details of a given airfare policy.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EXM_AIRFARE_POL_LINES_PK

POLICY_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
POLICY_LINE_ID NUMBER 18 Yes Airfare policy rate line identifier.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
AIRFARE_POLICY_ID NUMBER 18 Yes Policy identifier for which rates are defined.
TYPE_OF_RATE_CODE VARCHAR2 30 Indicates if this line is a base airline line or a catch all line.
FLIGHT_CLASS_CODE VARCHAR2 30 Airline ticket class such as economy class or business class.
FLIGHT_CLASS_CODE_DOMESTIC VARCHAR2 30 Airline ticket class such as economy class or business class, for domestic flights.
FLIGHT_CLASS_CODE_INTERNAT VARCHAR2 30 Airline ticket class such as economy class or business class, for international flights.
START_DATE DATE Yes Date at the beginning of the date range within which the rate is valid.
END_DATE DATE Date at the end of the date range within which the rate is valid.
ROLE_ID NUMBER 18 Role for which this rate is applicable.
ROLE_NAME VARCHAR2 80 Role name for which this rate is applicable, such as Director or Engineer.
FLIGHT_DURATION_THRESHOLD NUMBER Expense manager can specify a flight duration threshold such that above the threshold or below the threshold, a different flight class can be used. For example, policy can be defined such that if flight duration is more than seven hours, employee can fly business class.
STATUS VARCHAR2 30 Status of the rate line, such as Valid, Active, and Invalid. Values are from the lookup EXM_POLICY_STATUS.
INVALID_CODE VARCHAR2 30 Code indicating the reason that the rate line failed validation. Values are from the lookup EXM_POLICY_INVALID_CODE.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATETIME1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATETIME2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
EXM_AIRFARE_POL_LINES_N1 Non Unique FUSION_TS_TX_DATA AIRFARE_POLICY_ID, START_DATE, END_DATE
EXM_AIRFARE_POL_LINES_N2 Non Unique FUSION_TS_TX_DATA AIRFARE_POLICY_ID, ROLE_ID
EXM_AIRFARE_POL_LINES_N3 Non Unique Default AIRFARE_POLICY_ID, TYPE_OF_RATE_CODE
EXM_AIRFARE_POL_LINES_PK Unique FUSION_TS_TX_DATA POLICY_LINE_ID