PositionsLovV2
PositionsLovV2
Columns
| Name | Type | Description |
| PositionId [KEY] | Long | PositionId of PositionsLovV2 |
| EffectiveStartDate [KEY] | Date | EffectiveStartDate of PositionsLovV2 |
| EffectiveEndDate [KEY] | Date | EffectiveEndDate of PositionsLovV2 |
| PositionCode | String | PositionCode of PositionsLovV2 |
| PositionName | String | PositionName of PositionsLovV2 |
| HiringStatus | String | HiringStatus of PositionsLovV2 |
| JobCode | String | JobCode of PositionsLovV2 |
| JobName | String | JobName of PositionsLovV2 |
| DepartmentName | String | DepartmentName of PositionsLovV2 |
| LocationCode | String | LocationCode of PositionsLovV2 |
| LocationName | String | LocationName of PositionsLovV2 |
| BusinessUnitName | String | BusinessUnitName of PositionsLovV2 |
| PersonNumber | String | PersonNumber of PositionsLovV2 |
| DisplayName | String | DisplayName of PositionsLovV2 |
| FullName | String | FullName of PositionsLovV2 |
| ParentPositionCode | String | ParentPositionCode of PositionsLovV2 |
| ParentPositionName | String | ParentPositionName of PositionsLovV2 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ActiveStatus | String | ActiveStatus |
| BusinessGroupId | Long | BusinessGroupId |
| BusinessUnitId | Long | BusinessUnitId |
| EffectiveDate | Date | EffectiveDate |
| FilterAttributes | String | FilterAttributes |
| SearchTerms | String | SearchTerms |
| TypeCode | String | TypeCode |
| Finder | String | finder |