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 |