ExpensePerDiemPoliciesexpensePerDiemPolLines
ExpensePerDiemPoliciesexpensePerDiemPolLines
Columns
| Name | Type | Description |
| ExpensePerDiemPoliciesPerDiemPolicyId [KEY] | Long | The unique identifier of the expense per diem policy record. |
| AccomNightRate | Double | Accommodations allowance rate that's applicable to each night. |
| AccommodationDeduction | Double | Accommodations deduction entered in spreadsheet based on per diem determinants. |
| AccommodationTypeCode | String | Code That indicates the type of accommodation. Values are from the lookup ORA_EXM_PD_ACCOM_TYPE. |
| AccommodationType | String | Type of accommodation, such as Hotel, No Receipts, Private, Private No Cooking, or Private Cooking. |
| BaseRate | Double | Rate entered in the rates spreadsheet based on per diem determinants. |
| CreatedBy | String | User who created the row. |
| CreationDate | Datetime | Date and time when the row was created. |
| CurrencyCode | String | Currency code of a rate. |
| Currency | String | Name of the currency code of a rate. |
| EndDate | Date | Date after which this policy rate is no longer applicable. |
| FirstDayRate | Double | First day rate entered in the rates spreadsheet based on per diem determinants. |
| GeographyId | Long | Unique identifier of the geographical location for which the rate is applicable. |
| GeoLocName | String | Geographical location for which the rate is applicable. |
| HolidayRate | Double | Holidays rate entered in spreadsheet based on per diem determinants. |
| InvalidCode | String | Code that indicates the reason for failed validation of the rate record entered in the rates spreadsheet. Values are from the lookup EXM_POLICY_INVALID_CODE. |
| Invalid | String | Indicates the reason for failed validation of the rate record entered in the rates spreadsheet. |
| LastDayRate | Double | Last day rate entered in the rates spreadsheet based on per diem determinants. |
| LastUpdateDate | Datetime | Date and time when the row was last updated. |
| LastUpdateLogin | String | Session login associated with the user who last updated the row. |
| LastUpdatedBy | String | 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. |
| 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. |
| LowerRoleThreshold | Int | Low end of the salary threshold range. |
| LowerTripExceedDays | Double | Value that indicates the previous lower end of a range for long term travel duration. |
| MealsBreakfastDeduction | Double | Deduction for free breakfast entered in spreadsheet based on per diem determinants. |
| MealsBreakfastRate | Double | Breakfast meal allowance when a breakfast expense is eligible for per diem reimbursement. |
| MealsDailyDeduction | Double | Daily free meals deduction entered in spreadsheet based on per diem determinants. |
| MealsDinnerDeduction | Double | Deduction for free dinner entered in spreadsheet based on per diem determinants. |
| MealsDinnerRate | Double | Dinner meal allowance when a dinner expense is eligible for per diem reimbursement. |
| MealsLunchDeduction | Double | Deduction for free lunch entered in spreadsheet based on per diem determinants. |
| MealsLunchRate | Double | Lunch meal allowance when a lunch expense is eligible for per diem reimbursement. |
| MealsOneMealDeduction | Double | Single free meals deduction entered in spreadsheet based on per diem determinants. |
| MealsOneMealRate | Double | Meal allowance when one meal expense is incurred in a day on a trip. |
| MealsThreeMealsDeduction | Double | Deduction for three free meals entered in spreadsheet based on per diem determinants. |
| MealsThreeMealsRate | Double | Meal allowance when three meals are incurred in a day on a trip. |
| MealsTwoMealsDeduction | Double | Deduction for two free meals entered in spreadsheet based on per diem determinants. |
| MealsTwoMealsRate | Double | Meal allowance when two meals are incurred in a day on a trip. |
| 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. |
| OthersFirstDayRate | Double | First day incidentals rate entered in spreadsheet based on per diem determinants. |
| OthersLastDayRate | Double | Last day incidentals rate entered in spreadsheet based on per diem determinants. |
| OthersStandardRate | Double | Daily incidentals rate entered in spreadsheet based on per diem determinants. |
| PerDiemPolicyId | Long | Unique identifier of the per diem policy of this line. |
| PolicyLineId [KEY] | Long | Unique identifier of a per diem policy line. |
| RawCity | String | City for which the rate is applicable. |
| RawCountry | String | Country for which the rate is applicable. |
| RawCounty | String | County for which the rate is applicable. |
| RawState | String | State for which the rate is applicable. |
| RoleThreshold | Int | Role threshold determinant of a per diem rate, such as Job Management Level or Salary Threshold value. |
| RoleThresholdCode | String | Code that indicates the role threshold determinant of a per diem rate such as job management level or salary threshold value. |
| SeasonEndDay | Int | Ending day for which a seasonal rate is applicable. |
| SeasonEndMonth | Int | Ending month for which a seasonal rate is applicable. |
| SeasonStartDay | Int | Starting day for which a seasonal rate is applicable. |
| SeasonStartMonth | Int | Starting month for which a seasonal rate is applicable. |
| StartDate | Date | Date from which this policy rate is applicable. |
| Status | String | Code for the status of the rate record entered in the rates spreadsheet based on per diem determinant. Values are from the lookup EXM_POLICY_STATUS. |
| StatusMeaning | String | Status of the rate record entered in the rates spreadsheet based on per diem determinants such as Valid, Active, or Invalid. |
| TripExceedDays | Double | Value that indicates the lower end of a range for long term travel duration to receive different rates when a trip exceeds a certain number of days. |
| TypeOfLineCode | String | Code that identifies the type of policy rules or rates such as ROLEBASED, WEEKEND_HOLIDAY, or TIME_MODEL_STANDARD. |
| WeekendDay1Rate | Double | Per diem or meals allowance in the spreadsheet that's applicable to the first weekend day for a specific geographic region based on determinants. For example, the first weekend day for a specific geographic region may not be Saturday because it's in the United States. |
| WeekendDay2Rate | Double | Per diem or meals allowance in the spreadsheet that's applicable to the second weekend day for a specific geographic region based on determinants. For example, the first weekend day for a specific geographic region may not be Sunday because it's in the United States. |
| ZoneCode | String | Zone code for which this rate is applicable such as Geographical Location or Zone. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |