EmpsassignmentsassignmentExtraInformation
EmpsassignmentsassignmentExtraInformation
Columns
| Name | Type | Description |
| EmpsCitizenshipId [KEY] | Long | EmpsCitizenshipId of EmpsassignmentsassignmentExtraInformation |
| EmpsDriversLicenseId [KEY] | Long | EmpsDriversLicenseId of EmpsassignmentsassignmentExtraInformation |
| EmpsEffectiveStartDate [KEY] | Date | EmpsEffectiveStartDate of EmpsassignmentsassignmentExtraInformation |
| EmpsPassportId [KEY] | Long | EmpsPassportId of EmpsassignmentsassignmentExtraInformation |
| EmpsPersonId [KEY] | Long | EmpsPersonId of EmpsassignmentsassignmentExtraInformation |
| EmpsReligionId [KEY] | Long | EmpsReligionId of EmpsassignmentsassignmentExtraInformation |
| AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of EmpsassignmentsassignmentExtraInformation |
| AssignmentsEffectiveEndDate [KEY] | Date | AssignmentsEffectiveEndDate of EmpsassignmentsassignmentExtraInformation |
| AssignmentsEffectiveStartDate [KEY] | Date | AssignmentsEffectiveStartDate of EmpsassignmentsassignmentExtraInformation |
| AssignmentsTermsEffectiveStartDate [KEY] | Date | AssignmentsTermsEffectiveStartDate of EmpsassignmentsassignmentExtraInformation |
| EffectiveEndDate [KEY] | Date | EffectiveEndDate of EmpsassignmentsassignmentExtraInformation |
| EffectiveLatestChange [KEY] | String | EffectiveLatestChange of EmpsassignmentsassignmentExtraInformation |
| EffectiveStartDate [KEY] | Date | EffectiveStartDate of EmpsassignmentsassignmentExtraInformation |
| EffectiveSequence [KEY] | Int | EffectiveSequence of EmpsassignmentsassignmentExtraInformation |
| AssignmentId [KEY] | Long | AssignmentId of EmpsassignmentsassignmentExtraInformation |
| AssignmentType | String | AssignmentType of EmpsassignmentsassignmentExtraInformation |
| CategoryCode | String | CategoryCode of EmpsassignmentsassignmentExtraInformation |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BusinessUnitName | String | BusinessUnitName |
| CitizenshipId | Long | CitizenshipId |
| DepartmentName | String | DepartmentName |
| DriversLicenseId | Long | DriversLicenseId |
| 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 |