ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines
Stores line-level policy details for accommodations expense rules, including thresholds and specific lodging policy items.
Columns
| Name | Type | Description |
| ExpenseAccommodationsPoliciesAccommodationsPolicyId [KEY] | Long | The unique identifier for the accommodations policy in the ExpenseAccommodationsPolicies table, used to link to individual expense accommodation policy lines. |
| PolicyLineId [KEY] | Long | The unique identifier for a policy line within the accommodations policy, referencing the specific expense accommodation line associated with this policy. |
| AccommodationsPolicyId | Long | The identifier for the accommodation policy, used to associate a particular policy with its related expense accommodation details. |
| TypeOfRateCode | String | A code indicating the type of rate applied to the accommodation, such as a standard rate, discounted rate, or negotiated rate. |
| DailyLimit | Decimal | The maximum allowable daily expense amount for accommodations, set as part of the policy guidelines for expense management. |
| CurrencyCode | String | The ISO code for the currency used in the accommodations policy, indicating the currency in which the limits and expenses are calculated. |
| Currency | String | The name of the currency used in the accommodation policy (for example, USD, EUR). |
| StartDate | Date | The date when the accommodation policy becomes effective, marking the beginning of its validity period. |
| EndDate | Date | The date when the accommodation policy expires, indicating the end of the policy's validity period. |
| RoleId | Long | The unique identifier for the role associated with the accommodation policy, specifying which user or role is linked to the policy. |
| RoleName | String | The name of the role linked to the accommodation policy, typically representing a user role such as 'Manager' or 'Employee'. |
| GeographyId | Long | The unique identifier for the geographic location associated with the accommodation policy, which can link to a specific region or area. |
| ZoneCode | String | A code representing the geographical zone where the accommodation policy applies, typically used to group locations by regions or zones. |
| Zone | String | The name of the geographical zone to which the accommodation policy applies, often used to specify areas like North America or Europe. |
| GeolocName | String | The name of the geographical location (for example, city or region) where the accommodation policy is applicable, used for location-specific policies. |
| RawCountry | String | The raw country name as provided in the accommodation policy, which may need further processing or standardization. |
| RawState | String | The raw state or province name associated with the accommodation policy, potentially subject to formatting or normalization. |
| RawCounty | String | The raw county or district name where the accommodation policy applies, typically subject to further refinement for consistency. |
| RawCity | String | The raw city name associated with the accommodation policy, which may require additional processing for uniformity. |
| SeasonStartMonth | Int | The month when the accommodation policy's season starts, defining the period during which specific rates or limits apply. |
| SeasonStartDay | Int | The day of the month when the accommodation policy's season begins, providing the exact start date for seasonal rate changes. |
| SeasonEndMonth | Int | The month when the accommodation policy's season ends, marking the conclusion of the applicable seasonal rates or limits. |
| SeasonEndDay | Int | The day of the month when the accommodation policy's season concludes, specifying the end date for seasonal accommodations. |
| StatusCode | String | A code that represents the current status of the accommodation policy, such as 'Active', 'Inactive', or 'Suspended'. |
| Status | String | A textual description of the current status of the accommodation policy, providing context such as 'Policy Active' or 'Policy Expired'. |
| CreationDate | Datetime | The date and time when the accommodation policy was first created in the system, used for tracking its lifecycle. |
| CreatedBy | String | The name or ID of the user who created the accommodation policy, allowing for tracking of user actions in policy creation. |
| LastUpdateDate | Datetime | The date and time when the accommodation policy was last updated, providing information on the most recent modification. |
| LastUpdatedBy | String | The name or ID of the user who last updated the accommodation policy, used for auditing purposes and tracking changes. |
| LastUpdateLogin | String | The login identifier of the user who made the last update to the accommodation policy, assisting in security and access auditing. |
| Finder | String | The identifier or description used to locate or filter accommodation policies, providing a means for quick searching and referencing. |