1. Tables and Views for Financials
  2. EXM_ENTERTAINMENT_POL_LINES

EXM_ENTERTAINMENT_POL_LINES

This table contains the details of a given entertainment policy. Each line in the table contains an entertainment policy rate and the applicable rate determinants.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EXM_ENTERTAINMENT_POL_LINES_PK

POLICY_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
POLICY_LINE_ID NUMBER 18 Yes Unique identifier of entertainment policy line for entertainment expense.
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.
ENTERTAINMENT_POLICY_ID NUMBER 18 Yes Unique identifier of entertainment expense policy.
TYPE_OF_ATTENDE_CODE VARCHAR2 30 Type of event attendee for this entertainment policy line. Values are from lookup EXM_ATTENDEE_TYPES.
SINGLE_INSTANCE_LIMIT NUMBER Single instance reimbursement limit for entertainment expenses.
DAILY_LIMIT NUMBER Daily reimbursement limit for entertainment expenses.
YEARLY_LIMIT NUMBER Annual reimbursement limit for entertainment expenses.
CURRENCY_CODE VARCHAR2 15 Currency code for entertainment expense policies with multiple currencies.
START_DATE DATE Yes Start date of entertainment expense policy line.
END_DATE DATE End date of entertainment expense policy line.
TYPE_OF_RATE_CODE VARCHAR2 30 Type of rate line, such as base entertainment rate or catch all.
ROLE_ID NUMBER 18 Role for which this entertainment expense policy rate is applicable.
ROLE_NAME VARCHAR2 80 Role name for which this entertainment expense policy rate is applicable, such as Director or Engineer.
STATUS VARCHAR2 30 Status of the entertainment expense policy line, whether draft, valid or invalid. Values are from lookup EXM_POLICY_STATUS.
INVALID_CODE VARCHAR2 30 Reason that entertainment expense policy line has invalid status.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 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_ENTERT_POL_LINES_N1 Non Unique FUSION_TS_TX_DATA ENTERTAINMENT_POLICY_ID, START_DATE, END_DATE
EXM_ENTERT_POL_LINES_N2 Non Unique FUSION_TS_TX_DATA ENTERTAINMENT_POLICY_ID, CURRENCY_CODE
EXM_ENTERT_POL_LINES_PK Unique FUSION_TS_TX_DATA POLICY_LINE_ID