ExpensePerDiemPoliciesexpensePerDiemPolValues
Tracks percentage-based per diem policy values, enabling scaled calculations for partial days or specific travel scenarios.
Columns
| Name | Type | Description |
| ExpensePerDiemPoliciesPerDiemPolicyId [KEY] | Long | Unique identifier for the per diem policy in the ExpensePerDiemPolicies table, used to reference individual policy records. |
| CreatedBy | String | Indicates the user or system that created the record in the ExpensePerDiemPolicies table. |
| CreationDate | Datetime | Timestamp indicating when the record was first created in the ExpensePerDiemPolicies table. |
| DeterminantCode | String | Code representing the determinant used in per diem policy calculation, such as 'destination' or 'employee category'. |
| DeterminantValue | Int | Numerical value associated with the determinant code, used to determine specific per diem amounts. |
| LastUpdateDate | Datetime | Timestamp indicating the most recent modification made to the record in the ExpensePerDiemPolicies table. |
| LastUpdateLogin | String | Login information for the user or system that made the most recent update to the record. |
| LastUpdatedBy | String | Name or identifier of the person or system responsible for the last update to the record. |
| LineHours | Int | The number of hours associated with a specific line item in the expense policy, typically used for time-based calculations. |
| LineMinutes | Int | The number of minutes associated with a specific line item in the expense policy, for precise time-based expense calculation. |
| LineValue | Decimal | The monetary value of the line item, calculated based on the policy, time, and other determinants. |
| LowerDeterminantValue | Int | Lower bound value for the determinant, representing a threshold or range for policy application. |
| LowerLineHours | Int | The minimum number of hours that can be applied to a per diem line item in the expense policy. |
| LowerLineMinutes | Int | The minimum number of minutes that can be applied to a per diem line item in the expense policy. |
| ObjectVersionNumber | Int | Version number of the record, used for concurrency control and tracking changes over time in the ExpensePerDiemPolicies table. |
| PerDiemPolicyId | Long | Identifier for the per diem policy, linking this record to the overall policy structure in the database. |
| PolicyValueId [KEY] | Long | Unique identifier for the specific value or set of values assigned to a per diem policy, used for referencing expense data. |
| TypeOfLineCode | String | Code representing the type of line item (for example, 'lodging', 'meals'), used to categorize expenses under the per diem policy. |
| Finder | String | An identifier used to locate or reference the per diem policy within the system, often used in search or filter operations. |