EmpspersonExtraInformation
EmpspersonExtraInformation
Columns
| Name | Type | Description |
| EmpsCitizenshipId [KEY] | Long | EmpsCitizenshipId of EmpspersonExtraInformation |
| EmpsDriversLicenseId [KEY] | Long | EmpsDriversLicenseId of EmpspersonExtraInformation |
| EmpsEffectiveStartDate [KEY] | Date | EmpsEffectiveStartDate of EmpspersonExtraInformation |
| EmpsPassportId [KEY] | Long | EmpsPassportId of EmpspersonExtraInformation |
| EmpsPersonId [KEY] | Long | EmpsPersonId of EmpspersonExtraInformation |
| EmpsReligionId [KEY] | Long | EmpsReligionId of EmpspersonExtraInformation |
| PersonId [KEY] | Long | PersonId of EmpspersonExtraInformation |
| CategoryCode | String | CategoryCode of EmpspersonExtraInformation |
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 |
| ReligionId | Long | ReligionId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |