ExpenseAirfarePolicies
ExpenseAirfarePolicies
Columns
| Name | Type | Description |
| AirfarePolicyId [KEY] | Long | The unique identifier of the expense airfare policy record. |
| ObjectVersionNumber | Int | Number used to implement optimistic locking for an expense airfare policy. 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. |
| PolicyName | String | Name of the airfare expense policy. |
| Description | String | Description of the airfare expense policy. |
| EnabledRoleFlag | Bool | Indicates whether airfare rates vary based on the role of an employee. |
| PolicyRoleCode | String | Indicates the role type that determines the policy rate. Values are from the lookup EXM_POLICY_ROLE. |
| EnabledFlightTypeFlag | Bool | Indicates whether airline ticket class varies based on the flight type. |
| EnabledFlightDurationFlag | Bool | Indicates whether airline ticket class varies based on the flight duration. |
| FlightDurationCode | String | Indicates the flight duration type, such as per leg or per whole trip. Value is provided by the expense manager. Values are from the lookup ORA_EXM_AIR_FLIGHT_DURATION. |
| PolicyEnforcementCode | String | Indicates the type of airfare expense policy enforcement applied. Values are from the lookup EXM_POLICY_ENFORCEMENT. |
| DispWarningToUserFlag | Bool | Indicates whether an airfare expense policy warning is displayed to the user. |
| CreationDate | Datetime | Date and time when the row was created. |
| CreatedBy | String | User who created the row. |
| LastUpdateDate | Datetime | Date and time when the row was last updated |
| LastUpdatedBy | String | User who last updated the row. |
| LastUpdateLogin | String | Session login of user who last updated the row. |
| Status | String | Airfare policy status, such as Draft or Active. |
| StatusCode | String | Indicates the airfare policy status. Values are from the lookup EXM_POLICY_STATUS. |
| PolicyEnforcement | String | Type of airfare expense policy enforcement applied. |
| PolicyRole | String | Role type that determines the airfare policy rate, such as Job, Grade, or Position. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |