ExpensePerDiemPoliciesexpensePerDiemPolLines
Provides a breakdown of per diem policy lines, specifying coverage, meal breakdowns, or location-based rates.
Columns
| Name | Type | Description |
| ExpensePerDiemPoliciesPerDiemPolicyId [KEY] | Long | The unique identifier for the per diem policy in the ExpensePerDiemPolicies table, used to associate expenses with a specific policy. |
| AccomNightRate | Decimal | The rate per night for accommodation, as defined in the ExpensePerDiemPolicies table for each policy. |
| AccommodationDeduction | Decimal | The deduction applied to accommodation expenses, as per the policy in the ExpensePerDiemPolicies table. |
| AccommodationTypeCode | String | A code representing the type of accommodation, as defined in the ExpensePerDiemPolicies table. |
| AccommodationType | String | The descriptive name for the type of accommodation, such as 'Hotel' or 'Motel', as defined in the policy. |
| BaseRate | Decimal | The base rate for per diem, used as the standard calculation for accommodation or meal expenses before any adjustments. |
| CreatedBy | String | The user who initially created the record for the expense per diem policy line in the system. |
| CreationDate | Datetime | The date and time when the expense per diem policy line record was created in the system. |
| CurrencyCode | String | The code for the currency in which the expense is reported (for example, USD, EUR). |
| Currency | String | The name of the currency in which the expense is reported, such as USD or EUR. |
| EndDate | Date | The end date for the validity of the expense per diem policy line, indicating when it is no longer applicable. |
| FirstDayRate | Decimal | The rate applied to the first day of travel or stay, as per the expense policy. |
| GeographyId | Long | The identifier for the geographic region associated with the expense policy, used for location-based rules or calculations. |
| GeoLocName | String | The name of the geographic location associated with the expense policy, such as a city or region. |
| HolidayRate | Decimal | The rate for accommodation or meals on holidays, often higher than standard rates, as defined in the policy. |
| InvalidCode | String | A code indicating an invalid or non-compliant entry in the system related to the expense policy. |
| Invalid | String | A flag or status indicating whether an expense record is invalid, used for error checking or correction. |
| LastDayRate | Decimal | The rate applied to the last day of travel or stay, used to adjust the final day’s expenses. |
| LastUpdateDate | Datetime | The date and time when the expense policy record was last updated or modified in the system. |
| LastUpdateLogin | String | The login identifier of the user who last updated the expense policy record. |
| LastUpdatedBy | String | The name of the user who last modified the expense policy record. |
| LineHours | Int | The number of hours associated with the line item, typically used for calculating partial day expenses. |
| LineMinutes | Int | The number of minutes associated with the line item, used to calculate time-based expenses more precisely. |
| LowerLineHours | Int | The number of hours associated with the lower threshold for an expense line, often for partial day adjustments. |
| LowerLineMinutes | Int | The number of minutes associated with the lower threshold for an expense line, providing a finer breakdown for partial days. |
| LowerRoleThreshold | Int | The threshold value below which a lower rate or different rule applies, often used for different roles or job levels. |
| LowerTripExceedDays | Decimal | The number of days exceeding a specified threshold for trip length, which might trigger additional per diem adjustments. |
| MealsBreakfastDeduction | Decimal | The amount deducted for breakfast expenses in the policy, often if the meal is not covered or provided. |
| MealsBreakfastRate | Decimal | The rate assigned for breakfast expenses in the per diem policy, used to reimburse employees accordingly. |
| MealsDailyDeduction | Decimal | The daily deduction applied for meals, often based on specific policy rules or limits. |
| MealsDinnerDeduction | Decimal | The amount deducted for dinner expenses in the policy, typically when the meal is not covered or is self-provided. |
| MealsDinnerRate | Decimal | The rate assigned for dinner expenses as part of the per diem policy. |
| MealsLunchDeduction | Decimal | The amount deducted for lunch expenses in the policy, typically when lunch is not covered or provided. |
| MealsLunchRate | Decimal | The rate assigned for lunch expenses in the per diem policy, used to reimburse employees accordingly. |
| MealsOneMealDeduction | Decimal | The deduction applied for a single meal when less than three meals are covered in the policy. |
| MealsOneMealRate | Decimal | The rate for a single meal expense, used when only one meal is provided or reimbursed under the policy. |
| MealsThreeMealsDeduction | Decimal | The deduction applied when all three meals (breakfast, lunch, and dinner) are covered under the policy. |
| MealsThreeMealsRate | Decimal | The rate assigned for all three meals in the per diem policy, covering breakfast, lunch, and dinner. |
| MealsTwoMealsDeduction | Decimal | The deduction applied when only two meals are covered, usually breakfast and dinner or lunch and dinner. |
| MealsTwoMealsRate | Decimal | The rate for two meals, used when only two meals are reimbursed under the per diem policy. |
| ObjectVersionNumber | Int | The version number of the object or record, used for tracking changes and updates to the policy lines. |
| OthersFirstDayRate | Decimal | The first day rate for expenses other than accommodation or meals, often applied for initial travel or setup costs. |
| OthersLastDayRate | Decimal | The last day rate for expenses other than accommodation or meals, often used for final travel or closing expenses. |
| OthersStandardRate | Decimal | The standard rate for miscellaneous expenses not categorized under accommodation or meals. |
| PerDiemPolicyId | Long | The unique identifier for the per diem policy associated with each line item, used for referencing the overarching policy. |
| PolicyLineId [KEY] | Long | The identifier for the specific policy line within the expense per diem policy, allowing for detailed expense breakdown. |
| RawCity | String | The raw data input for the city name where the expense occurred, as captured in the ExpensePerDiemPolicies table. |
| RawCountry | String | The raw data input for the country name where the expense occurred, as captured in the ExpensePerDiemPolicies table. |
| RawCounty | String | The raw data input for the county name where the expense occurred, as captured in the ExpensePerDiemPolicies table. |
| RawState | String | The raw data input for the state name where the expense occurred, as captured in the ExpensePerDiemPolicies table. |
| RoleThreshold | Int | The threshold for role-based expense adjustments, dictating different rates or policies based on the employee's role. |
| RoleThresholdCode | String | The code used to represent different role thresholds for per diem policy adjustments, indicating varying allowances. |
| SeasonEndDay | Int | The day of the month that marks the end of a specific season for the expense policy, used for season-based adjustments. |
| SeasonEndMonth | Int | The month of the year that marks the end of a specific season for the expense policy, influencing policy duration. |
| SeasonStartDay | Int | The day of the month that marks the start of a specific season for the expense policy, used to trigger season-based allowances. |
| SeasonStartMonth | Int | The month of the year that marks the start of a specific season for the expense policy, determining the seasonality of rates. |
| StartDate | Date | The start date for the expense per diem policy line, indicating when the policy becomes effective. |
| Status | String | The status of the expense policy line, indicating whether the policy is active, inactive, or requires review. |
| StatusMeaning | String | A descriptive meaning of the status, explaining the reason for its current state (for example, 'Active', 'Expired', 'Pending'). |
| TripExceedDays | Decimal | The number of days exceeding the specified threshold for the trip length, often triggering higher rates for extended trips. |
| TypeOfLineCode | String | A code that classifies the type of expense line, used to distinguish between accommodation, meals, or other categories. |
| WeekendDay1Rate | Decimal | The rate for the first weekend day, often applied to weekend stays or activities. |
| WeekendDay2Rate | Decimal | The rate for the second weekend day, usually applied if the trip extends through two weekend days. |
| ZoneCode | String | The code representing the geographical zone, used to apply specific rates or policies based on the location. |
| Finder | String | The identifier or name of the user who located or identified the expense policy line, typically used for audit or tracking purposes. |