ExpensePerDiemPoliciesexpensePerDiemPolValues
ExpensePerDiemPoliciesexpensePerDiemPolValues
Columns
Name | Type | Description |
ExpensePerDiemPoliciesPerDiemPolicyId [KEY] | Long | The unique identifier of the expense per diem policy record. |
CreatedBy | String | User who created the row. |
CreationDate | Datetime | Date and time when the row was last updated. |
DeterminantCode | String | Code that indicates the value used for this determinant. Valid values are DAILY, ACCOM_DEDUCTION, LAST_DAY, FIRST_DAY, and so on. |
DeterminantValue | Int | Value used for this determinant in percentage. |
LastUpdateDate | Datetime | Date and time when the row was last updated. |
LastUpdateLogin | String | Session login associated to the user who last updated the row. |
LastUpdatedBy | String | Indicates the user who last updated the row. |
LineHours | Int | Time threshold hours of a per diem rate. |
LineMinutes | Int | Time threshold minutes of a per diem rate. |
LineValue | Double | Percentage for role-based or time-based allowances. |
LowerDeterminantValue | Int | Low end of the determinant threshold range. |
LowerLineHours | Int | Lower end of the time threshold hours of a per diem rate. |
LowerLineMinutes | Int | Lower end of the time threshold minutes of a per diem rate. |
ObjectVersionNumber | Int | Number used to implement optimistic locking for an expense miscellaneous policy line. The number increments every time the row is updated. The value of the object version number at the start and end of a transaction are compared to detect whether another session has updated the row since it was queried. |
PerDiemPolicyId | Long | Unique identifier of the per diem policy of this line. |
PolicyValueId [KEY] | Long | Unique identifier of a per diem policy value line. |
TypeOfLineCode | String | Code that identifies the type of policy rules or rates such as ROLEBASED, WEEKEND_HOLIDAY, or TIME_MODEL_STANDARD. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Finder | String | finder |