ALEX_PD_EUR_RATE (Staging table)

Column name Data type Required Default update able Data target Comments
PERDIEM_DEFINITION_EKEY** VARCHAR (255) Yes* No ALPD_EUR_RATE.PD_DEFINITION_ID External key of the per diem definition for the applied rate
LOCATION_EKEY** VARCHAR (255) No No ALPD_EUR_RATE.LOCATION_ID External key of the location for the applied rate
MIN_TIME_AT_LOCATION** SMALLINT No No ALPD_EUR_RATE.MIN_TIME_AT_LOCATION Minimum time in minutes. This per diem rate may apply only if the traveler stayed at this location for the specified duration.
PERDIEM_PER_HOUR** SMALLINT No No ALPD_EUR_RATE.PER_HOUR
  • 1 = true
  • 0 or null = false
If true, the per diem is calculated by dividing min_time_at_location by 60 (to retrieve hours) then multiplying by rate_value.
OVERNIGHT_STAY** SMALLINT Yes* No ALPD_EUR_RATE.PER_HOUR
  • 1 = true
  • 0 or null = false
If true, the trip is interpreted as a continuation of an overnight stay i.e., first day or subsequent day. It's used to determine which rate/duration to apply. It is not a deduction.
FIRST_DAY_OF_TRIP** SMALLINT Yes* No ALPD_EUR_RATE.FIRST_DAY_OF_TRIP
  • 1 = true
  • 0 or null = false
If true, this is the first day of the trip and the first day deduction is applied.
LAST_DAY_OF_TRIP** SMALLINT Yes* No ALPD_EUR_RATE.LAST_DAY_OF_TRIP
  • 1 = true
  • 0 or null = false
If true, this is the last day of the trip and the last day deduction is applied.
EFFECTIVE_DATE** DATETIME No No ALPD_EUR_RATE.EFFECTIVE_DATE Effective date is the date when this rate is valid. It is valid on or after this date.
RATE_VALUE NUMERIC (20, 10) Yes* Yes ALPD_EUR_RATE.RATE_VALUE The per diem rate.
RATE_CURRENCY_EKEY VARCHAR (255) Yes* Yes ALPD_EUR_RATE.RATE_VALUE_ID Per diem rate currency external key.
ACTIVE_STATUS SMALLINT Yes* Yes ALPD_EUR_RATE.ACTIVE_STATUS Determines whether the rate is active.
  • 1 = Active
  • 0 = Inactive
UNTIL_DATE DATETIME No Yes ALPD_EUR_RATE.UNTIL_DATE The date when the per diem rate expires.

** Combination of (perdiem_definition_ekey, location_ekey, min_time_at_location, perdiem_per_hour, overnight_stay, first_day_of_trip, last_day_of_trip, effective_date) must be unique

* System required field