ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines
Stores line-level policy details for accommodations expense rules, including thresholds and specific lodging policy items.
Columns
| Name | Type | SupportedFinders | 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 | PrimaryKey | 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. |