EXM_PERDIEM_POL_LINES

This table contains per diem policy lines which are per diem policy rules or rates that are not fixed.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EXM_PERDIEM_POL_LINES_PK

POLICY_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
POLICY_LINE_ID NUMBER 18 Yes Unique identifier of a per diem policy line.
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.
PERDIEM_POLICY_ID NUMBER 18 Yes Per diem policy to which this line belongs.
TYPE_OF_LINE_CODE VARCHAR2 30 Code that identifies the type of policy rules or rates, such as ROLEBASED, WEEKEND_HOLIDAY, or TIME_MODEL_STANDARD.
BASE_RATE NUMBER Rate entered in the rates spreadsheet based on per diem determinants.
ACCOM_NIGHT_RATE NUMBER Accommodations allowance rate that is applicable to each night.
FIRST_DAY_RATE NUMBER First day rate entered in the rates spreadsheet based on per diem determinants.
LAST_DAY_RATE NUMBER Last day rate entered in the rates spreadsheet based on per diem determinants.
TIME_MODEL_RATE NUMBER Rate entered in the rates spreadsheet based on per diem time determinants.
LINE_HOURS NUMBER 4 Time threshold hours of a per diem rate.
LINE_MINUTES NUMBER 4 Time threshold minutes of a per diem rate.
LOWER_LINE_HOURS NUMBER 4 Lower end of the time threshold hours of a per diem rate.
LOWER_LINE_MINUTES NUMBER 4 Lower end of the time threshold minutes of a per diem rate.
START_DATE DATE Date from which this policy rate is applicable.
END_DATE DATE Date after which this policy rate is no longer applicable.
CURRENCY_CODE VARCHAR2 15 Currency code of a rate.
GEOGRAPHY_ID NUMBER 18 Geographical location for which the rate is applicable.
ZONE_CODE VARCHAR2 30 Zone code for which this rate is applicable, such as Geographical Location or Zone.
GEOLOC_NAME VARCHAR2 240 Geographical location for which this rate is applicable.
RAW_COUNTRY VARCHAR2 80 Country for which the rate is applicable.
RAW_STATE VARCHAR2 80 State for which the rate is applicable.
RAW_COUNTY VARCHAR2 80 County for which the rate is applicable.
RAW_CITY VARCHAR2 80 City for which the rate is applicable.
RAW_LEVEL_5 VARCHAR2 80 Fifth level location attribute after country, state, county, and city for which a rate is applicable, such as a township, hamlet, or village.
ROLE_THRESHOLD NUMBER 9 Role threshold determinant of a per diem rate, such as job management level or salary threshold value.
ROLE_THRESHOLD_CODE VARCHAR2 30 Role threshold code determinant of a per diem rate, such as job management level or salary threshold value.
LOWER_ROLE_THRESHOLD NUMBER 9 Low end of the salary threshold range.
SEASON_START_MONTH NUMBER 2 Starting month for which a seasonal rate is applicable.
SEASON_START_DAY NUMBER 2 Starting day for which a seasonal rate is applicable.
SEASON_END_MONTH NUMBER 2 Ending month for which a seasonal rate is applicable.
SEASON_END_DAY NUMBER 2 Ending day for which a seasonal rate is applicable.
ACCOMMODATION_DEDUCTION NUMBER Accommodations deduction entered in spreadsheet based on per diem determinants.
ACCOMMODATION_TYPE_CODE VARCHAR2 30 Code for the type of accommodation, such as Hotel, No Receipts, Private, Private, No Cooking, or Private, Cooking. Values are from the lookup ORA_EXM_PD_ACCOM_TYPE.
MEALS_BREAKFAST_RATE NUMBER Breakfast meal allowance when a breakfast expense is eligible for per diem reimbursement.
MEALS_LUNCH_RATE NUMBER Lunch meal allowance when a lunch expense is eligible for per diem reimbursement.
MEALS_DINNER_RATE NUMBER Dinner meal allowance when a dinner expense is eligible for per diem reimbursement.
MEALS_ONE_MEAL_RATE NUMBER Meal allowance when one meal expense is incurred in a day on a trip.
MEALS_TWO_MEALS_RATE NUMBER Meal allowance when two meals are incurred in a day on a trip.
MEALS_THREE_MEALS_RATE NUMBER Meal allowance when three meals are incurred in a day on a trip.
MEALS_DAILY_DEDUCTION NUMBER Daily free meals deduction entered in spreadsheet based on per diem determinants.
MEALS_ONE_MEAL_DEDUCTION NUMBER Single free meals deduction entered in spreadsheet based on per diem determinants.
MEALS_TWO_MEALS_DEDUCTION NUMBER Deduction for two free meals entered in spreadsheet based on per diem determinants.
MEALS_THREE_MEALS_DEDUCTION NUMBER Deduction for three free meals entered in spreadsheet based on per diem determinants.
MEALS_BREAKFAST_DEDUCTION NUMBER Deduction for free breakfast entered in spreadsheet based on per diem determinants.
MEALS_LUNCH_DEDUCTION NUMBER Deduction for free lunch entered in spreadsheet based on per diem determinants.
MEALS_DINNER_DEDUCTION NUMBER Deduction for free dinner entered in spreadsheet based on per diem determinants.
TRIP_EXCEED_DAYS NUMBER Value that indicates the lower end of a range for long term travel duration to receive different rates when a trip exceeds some number of days.
LOWER_TRIP_EXCEED_DAYS NUMBER Value that indicates the previous lower end of a range for long term travel duration.
WEEKEND_DAY1_RATE NUMBER Per diem or meals allowance in the spreadsheet that is applicable to the first weekend day for a specific geographic region based on determinants. For example, the first weekend day for a specific geographic region may not be Saturday as it is in the United States.
WEEKEND_DAY2_RATE NUMBER Per diem or meals allowance in the spreadsheet that is applicable to the second weekend day for a specific geographic region based on determinants. For example, the first weekend day for a specific geographic region may not be Sunday as it is in the United States.
HOLIDAY_RATE NUMBER Holidays rate entered in spreadsheet based on per diem determinants.
OTHERS_STANDARD_RATE NUMBER Daily incidentals rate entered in spreadsheet based on per diem determinants.
OTHERS_FIRST_DAY_RATE NUMBER First day incidentals rate entered in spreadsheet based on per diem determinants.
OTHERS_LAST_DAY_RATE NUMBER Last day incidentals rate entered in spreadsheet based on per diem determinants.
LONGTERM_TRAVEL_RATE NUMBER Rate value that applies to a long term travel rule.
STATUS VARCHAR2 30 Status of the rate record entered in the rates spreadsheet based on per diem determinants, such as Valid, Active, or Invalid. Values are from the lookup EXM_POLICY_STATUS.
INVALID_CODE VARCHAR2 30 Code that indicates the reason the rate record entered in the rates spreadsheet failed validation. Values are from the lookup EXM_POLICY_INVALID_CODE.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
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_PERDIEM_POL_LINES_N1 Non Unique FUSION_TS_TX_DATA PERDIEM_POLICY_ID, START_DATE, END_DATE
EXM_PERDIEM_POL_LINES_N2 Non Unique FUSION_TS_TX_DATA PERDIEM_POLICY_ID, TYPE_OF_LINE_CODE
EXM_PERDIEM_POL_LINES_N3 Non Unique FUSION_TS_TX_DATA PERDIEM_POLICY_ID, ROLE_THRESHOLD
EXM_PERDIEM_POL_LINES_N4 Non Unique FUSION_TS_TX_DATA PERDIEM_POLICY_ID, GEOGRAPHY_ID
EXM_PERDIEM_POL_LINES_N5 Non Unique FUSION_TS_TX_DATA PERDIEM_POLICY_ID, CURRENCY_CODE
EXM_PERDIEM_POL_LINES_N6 Non Unique FUSION_TS_TX_DATA TYPE_OF_LINE_CODE
EXM_PERDIEM_POL_LINES_PK Unique FUSION_TS_TX_DATA POLICY_LINE_ID