ExpensePerDiemPolicies
ExpensePerDiemPolicies
Columns
| Name | Type | Description |
| AccomDeductCalcMethCode | String | Code that indicates the calculation method for accommodation deductions. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| AccomDeductCalcMeth | String | Calculation method for accommodation deductions such as Rate, Percentage, or Spreadsheet. |
| AccomDeductionFlag | Bool | Indicates whether this per diem policy deducts free accommodations from the calculated accommodation allowance. Valid values are Yes and No. |
| AccomEligibEndHour | Int | End hour for accommodations eligibility. |
| AccomEligibEndMinute | Int | End minute for accommodations eligibility. |
| AccomEligibStartHour | Int | Start hour for accommodations eligibility. |
| AccomEligibStartMinute | Int | Start minute for accommodations eligibility. |
| AccomFreeOnlyFlag | Bool | Indicates whether the per diem policy permits free accommodations only allowance. Valid values are Yes and No. |
| AccomMinDurationHours | Int | Minimum hours duration for accommodations. |
| AccomMinDurationMinutes | Int | Minimum minutes duration for accommodations. |
| AccomMinNightHoursStay | Int | Minimum number of hours of stay required to qualify for accommodations allowance. |
| AccomMinTripDuratFlag | Bool | Indicates whether there is a minimum trip duration requirement for an employee to become eligible for an accommodations allowance. Valid values are Yes and No. |
| AccomRateCalcMethodCode | String | Code that indicates the calculation method for the accommodations rate. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| AccomRateCalcMethod | String | Calculation method for accommodation rates such as Rate, Percentage, or Spreadsheet. |
| AccomReqMealsEligibFlag | Bool | Indicates whether a per diem policy requires an employee to meet the meals allowance criteria before they're eligible for an accommodations allowance. Valid values are Yes and No. |
| AllowActualExpenseFlag | Bool | Indicates if actual expenses are allowed instead of per diem.Valid values are Yes and No. |
| AllowRateConversionFlag | Bool | Indicates whether a per diem policy allows the single currency rates defined in a policy to be converted to a different reimbursement currency. Valid values are Yes and No. |
| BreakfastEligEndHour | Int | Ending time hour for breakfast to qualify for a breakfast allowance. |
| BreakfastEligEndMinute | Int | Ending time minute for breakfast to qualify for a breakfast allowance. |
| BreakfastEligStartHour | Int | Starting time hour for breakfast to qualify for a breakfast allowance. |
| BreakfastEligStartMinute | Int | Starting time minutes for breakfast to qualify for a breakfast allowance. |
| CreatedBy | String | User who created the row. |
| CreationDate | Datetime | Date and time when the row was last updated. |
| CurrencyCode | String | Three-letter ISO currency code for the single currency in which rates for the policy are defined. |
| Currency | String | Currency name for per diem expense policies. |
| CurrencyOptionCode | String | Code that indicates whether per diem policy rates in a policy are defined in a single currency or in a currency specific to locations. Values are from the lookup ORA_EXM_PD_CURRENCY_OPTION. |
| CurrencyOption | String | Rate currency option such as Single or Location. |
| DayTravelEligibHours | Int | Indicates the minimum hours of travel required to be eligible for same day travel. |
| Description | String | Description of a per diem policy. |
| DinnerEligEndHour | Int | Ending time hour for dinner to qualify for a dinner allowance. |
| DinnerEligEndMinute | Int | Ending time minute for dinner to qualify for a dinner allowance. |
| DinnerEligStartHour | Int | Starting time hour for dinner to qualify for a dinner allowance. |
| DinnerEligStartMinute | Int | Starting time minutes for dinner to qualify for a dinner allowance. |
| EnabledAccomTypeFlag | Bool | Indicates whether per diem policy rates vary by type of accommodation. Valid values are Yes and No. |
| EnabledLocationFlag | Bool | Indicates whether per diem policy rates vary by location type such as geographical location or zone. Valid values are Yes and No. |
| EnabledLongTermFlag | Bool | Indicates whether per diem policy has rules or rates defined for long-term travel. Valid values are Yes and No. |
| EnabledRoleFlag | Bool | Indicates whether per diem allowances vary based on role types such as job management level or salary threshold. Valid values are Yes and No. |
| EnabledSeasonRateFlag | Bool | Indicates whether accommodation rates vary by season when accommodations are included in per diem. Valid values are Yes and No. |
| EnabledWeekendHolidFlag | Bool | Indicates whether per diem policy has rules or rates defined for weekend and holiday travel. Valid values are Yes and No. |
| FreeMealDeductionCode | String | Code indicating the type of deduction, by meal type and amount or by meal type and amount with percentage deductions over a specified limit. Values are from the lookup ORA_EXM_CONUS_MEAL_DEDUCTION. |
| FreeMealDeduction | String | Type of deduction, by meal type and amount or by meal type and amount with percentage deductions over a specified limit. |
| HolidayCalcMethodCode | String | Code indicating the calculation method for weekend and holiday allowances such as Rate or Percentage. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| HolidayCalcMethod | String | Calculation method for weekend and holiday allowances such as Rate or Percentage. |
| 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. |
| LocationTypeCode | String | Lookup type that indicates policy rates vary by geographical locations. Values are from the lookup EXM_LOCATION_TYPE. |
| LocationType | String | Indicates how policy rates vary by geographical locations. |
| LongTermCalcMethod | String | Code indicating the calculation method for long-term travel allowances. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| LongTermCalcMeth | String | Calculation method for long-term travel allowances. |
| LunchEligEndHour | Int | Ending time hours for lunch to qualify for a lunch allowance. |
| LunchEligEndMinute | Int | Ending time minutes for lunch to qualify for a lunch allowance. |
| LunchEligStartHour | Int | Starting time hours for lunch to qualify for a lunch allowance. |
| LunchEligStartMinute | Int | Starting time minutes for lunch to qualify for a lunch allowance. |
| MealDeductionFlag | Bool | Indicates whether the per diem policy deducts free meals from the calculated meals allowance. Valid values are Yes and No. |
| MealInclIncidentalFlag | Bool | Indicates whether the meals allowance also includes incidental expense charges. Valid values are Yes and No. |
| MealRateTypeCode | String | Code that indicates meal allowance type for a policy. Values are from the lookup ORA_EXM_PERDIEM_MEAL_RATE. |
| MealRateType | String | Indicates the meal allowance type for a policy such as Daily Rate, Rates By Meal Type, or Rates by Number of Meals. |
| MealsAmountLimit | Double | Amount limit to determine deduction for free meal. |
| MealsCalcMethodCode | String | Code that indicates the calculation method for per diem or meals allowances. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| MealsCalcMethod | String | Calculation method for per diem meals allowances, such as Rate, Percentage, or Spreadsheet. |
| MealsDeductCalcMethCode | String | Code that indicates the calculation method for meals deductions such as Rate, Percentage, or Spreadsheet. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| MealsDeductCalcMeth | String | Calculation method for meals deductions such as Rate, Percentage, or Spreadsheet. |
| MealsDeductionCode | String | Code that indicates meals deduction type for a per diem policy. Values are from the lookup ORA_EXM_PERDIEM_MEAL_DEDUCTION. |
| MealsDeduction | String | Indicates the meals deduction type for a per diem policy such as Daily Meals Deduction, Deduction by Meal Type, or Deductions by Number of Meals. |
| MealsRateSourceCode | String | Code that indicates whether the meal rates are based on local rates or proportional rates. Values are from the lookup ORA_EXM_MEAL_SOURCE_CODE. |
| MealsRateSource | String | Indicates whether the meal rates are based on local rates or proportional rates. |
| MinDistanceFromHome | Double | Minimum travel distance from home to qualify for per diem rate. |
| MinDistanceFromOffice | Double | Minimum travel distance from office to qualify for per diem rate. |
| MinDurationHours | Int | Minimum travel time hours to qualify for per diem or meals rate. |
| MinDurationMinutes | Int | Minimum travel time minutes to qualify for per diem or meals rate. |
| MinTripDuratFlag | Bool | Indicates whether this policy has a minimum trip duration for per diem eligibility. |
| MinimumReimbursement | Double | Minimum reimbursement amount. |
| 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. |
| OthersCalcMethodCode | String | Code that indicates the calculation method for an incidental allowance. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| OthersCalcMethod | String | Calculation method for an incidental allowance such as Rate, Percentage, or Spreadsheet. |
| OthersEligibCriteriaCode | String | Code that indicates the eligibility criteria for receiving an incidental allowance. Values are from the lookup ORA_EXM_PERDIEM_ELIG_CRITERIA. |
| OthersEligibCriteria | String | Eligibility criteria for receiving an incidental allowance such as None, Meets Meals Eligibility, or Meets Meals and Accommodations Eligibility. |
| PerDiemPolicyId [KEY] | Long | Unique identifier of per diem policy. |
| PerdiemPolicyType | String | Type of travel for which a per diem policy is applicable such as Generic, Domestic, or Foreign. Values are from the lookup ORA_EXM_PERDIEM_POLICY_TYPE. |
| PolicyName | String | Name of a per diem policy. |
| PolicyRoleCode | String | Code that indicates the role type by which per diem allowances vary, such as job management level or salary. |
| PolicyRole | String | Role type by which per diem allowances vary, such as job management level or salary. |
| RateFormulaMethodCode | String | Code indicating the formula calculation method for per diem allowance. Values are from the lookup ORA_EXM_RATE_FORMULA_METHOD. |
| RateFormulaMethod | String | Formula calculation method for per diem allowance such as Daily Rate, Sum Up Separate Rate Allowances, Daily Time Based Rate, or Sum Up Separate Rates -Time Based. |
| RateIncludeAccomFlag | Bool | Indicates whether the per diem reimbursement defined for the policy includes accommodations. Valid values are Yes and No. |
| RateIncludeMealsFlag | Bool | Indicates whether the per diem allowance defined for the policy includes meals. Valid values are Yes and No. |
| RateIncludeOtherFlag | Bool | Indicates whether the per diem reimbursement defined for the policy includes other expenses. Valid values are Yes and No. |
| RateMultiplierCode | String | Code that indicates whether the rate multiplier is number of days or number of nights. Values are from the lookup ORA_EXM_PERDIEM_MULTIPLIER. |
| RateMultiplier | String | Code that indicates whether the rate multiplier is number of days or number of nights when the per diem policy calculation method is Daily Rate. Values are from the lookup ORA_EXM_PERDIEM_MULTIPLIER. |
| RatesSourceCode | String | Code indicating if the policy is created based on rates entered by the user or from rates uploaded by the user. |
| RatesSource | String | Indicates if the policy is created based on rates entered by the user or from rates uploaded by the user. |
| RoleCalcMethod | String | Calculation method for role based allowances for a per diem policy such as Rate, Percentage, or Spreadsheet. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| SpecificFirstLastDayFlag | Bool | Indicates whether a per diem policy has specific rates for first day and last day. Valid values are Yes and No. |
| Status | String | Code that indicates the status of a per diem policy. Values are from the lookup EXM_POLICY_STATUS. |
| StatusMeaning | String | Status of a per diem policy such as Draft, Valid, Invalid, Partially Active, or Active. |
| TimeAllowSameDayFlag | Bool | Indicates whether this per diem policy will allow same day trip. Valid values are Yes and No. |
| TimeBasedRateModelFlag | Bool | This attribute is reserved for future use. Indicates whether per diem policy rates vary based on travel time for each rate time period. |
| TimeCalcMethodCode | String | Calculation method for time threshold allowances. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| TimeCalcMethod | String | Calculation method for time threshold allowances such as Rate, Percentage, or Spreadsheet. |
| TimePeriodCode | String | Code that indicates time period boundaries for per diem. Values are from the lookup ORA_EXM_PERDIEM_TIME_PERIOD. |
| TimePeriod | String | Code that indicates time period boundaries per diem such as Midnight to Midnight or Start Time Plus 24 Hours. |
| TimeSameDayCalcMethod | String | Calculation method for same day travel time threshold allowances. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| TimeSameDayCalcMeth | String | Calculation method for same day travel time threshold allowances such as Rate, Percentage, or Spreadsheet. Values are from the lookup ORA_EXM_PERDIEM_CALCMETH. |
| TimeSameDayRuleCode | String | Code that indicates when specific same day travel rates are applicable. Values are from the lookup ORA_EXM_PERDIEM_SAME_DAY_RULE. |
| TimeSameDayRule | String | Indicates whether specific same day travel rates are applicable to trips less than 24 hours or to trips without an overnight stay. |
| WeekendDay1Code | String | Code that indicates the first weekend day for a specific geographic region. For example, the first weekend day for a specific geographic region may not be Saturday as it's in the United States. |
| WeekendDay2Code | String | Code that indicates the second weekend day for a specific geographic region. For example, the second weekend day for a specific geographic region may not be Sunday as it's in the United States. |
| WithinEmployeeCityFlag | Bool | Indicates whether a policy allows travel within the employee's home city to qualify for per diem or meals allowance. Valid values are Yes and No. |
| ZoneTypeCode | String | Code that indicates whether policy rates vary by zone. |
| ZoneType | String | Indicates that the policy rates vary by zones. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |