EmpsassignmentspeopleGroupKeyFlexfield
EmpsassignmentspeopleGroupKeyFlexfield
Columns
| Name | Type | Description |
| EmpsCitizenshipId [KEY] | Long | EmpsCitizenshipId of EmpsassignmentspeopleGroupKeyFlexfield |
| EmpsDriversLicenseId [KEY] | Long | EmpsDriversLicenseId of EmpsassignmentspeopleGroupKeyFlexfield |
| EmpsEffectiveStartDate [KEY] | Date | EmpsEffectiveStartDate of EmpsassignmentspeopleGroupKeyFlexfield |
| EmpsPassportId [KEY] | Long | EmpsPassportId of EmpsassignmentspeopleGroupKeyFlexfield |
| EmpsPersonId [KEY] | Long | EmpsPersonId of EmpsassignmentspeopleGroupKeyFlexfield |
| EmpsReligionId [KEY] | Long | EmpsReligionId of EmpsassignmentspeopleGroupKeyFlexfield |
| AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of EmpsassignmentspeopleGroupKeyFlexfield |
| AssignmentsEffectiveEndDate [KEY] | Date | AssignmentsEffectiveEndDate of EmpsassignmentspeopleGroupKeyFlexfield |
| AssignmentsEffectiveStartDate [KEY] | Date | AssignmentsEffectiveStartDate of EmpsassignmentspeopleGroupKeyFlexfield |
| AssignmentsTermsEffectiveStartDate [KEY] | Date | AssignmentsTermsEffectiveStartDate of EmpsassignmentspeopleGroupKeyFlexfield |
| _FLEX_ValidationDate | Date | _FLEX_ValidationDate of EmpsassignmentspeopleGroupKeyFlexfield |
| _FLEX_StructureInstanceCode | String | _FLEX_StructureInstanceCode of EmpsassignmentspeopleGroupKeyFlexfield |
| _FLEX_ApplicationId | Long | _FLEX_ApplicationId of EmpsassignmentspeopleGroupKeyFlexfield |
| _FLEX_KeyFlexfieldCode | String | _FLEX_KeyFlexfieldCode of EmpsassignmentspeopleGroupKeyFlexfield |
| _FLEX_StructureInstanceId | Long | _FLEX_StructureInstanceId of EmpsassignmentspeopleGroupKeyFlexfield |
| StartDateActive | Date | StartDateActive of EmpsassignmentspeopleGroupKeyFlexfield |
| EndDateActive | Date | EndDateActive of EmpsassignmentspeopleGroupKeyFlexfield |
| EnabledFlag | String | EnabledFlag of EmpsassignmentspeopleGroupKeyFlexfield |
| _PEOPLE_GROUP_ID [KEY] | Long | _PEOPLE_GROUP_ID of EmpsassignmentspeopleGroupKeyFlexfield |
| _ID_FLEX_NUM | Long | _ID_FLEX_NUM of EmpsassignmentspeopleGroupKeyFlexfield |
| FND_ACFF_ConcatenatedStorage | String | FND_ACFF_ConcatenatedStorage of EmpsassignmentspeopleGroupKeyFlexfield |
| FND_ACFF_Delimiter | String | FND_ACFF_Delimiter of EmpsassignmentspeopleGroupKeyFlexfield |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BusinessUnitName | String | BusinessUnitName |
| CitizenshipId | Long | CitizenshipId |
| DepartmentName | String | DepartmentName |
| DriversLicenseId | Long | DriversLicenseId |
| EffectiveStartDate | Date | EffectiveStartDate |
| GradeName | String | GradeName |
| JobName | String | JobName |
| LocationName | String | LocationName |
| ManagerFullName | String | ManagerFullName |
| PassportId | Long | PassportId |
| PersonId | Long | PersonId |
| ReligionId | Long | ReligionId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |