ExpensePerDiemPoliciesexpensePerDiemPolValues
Tracks percentage-based per diem policy values, enabling scaled calculations for partial days or specific travel scenarios.
Columns
| Name | Type | SupportedFinders | 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 | PrimaryKey | 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. |