Empsphoto
Empsphoto
Columns
Name | Type | Description |
EmpsCitizenshipId [KEY] | Long | EmpsCitizenshipId of Empsphoto |
EmpsDriversLicenseId [KEY] | Long | EmpsDriversLicenseId of Empsphoto |
EmpsEffectiveStartDate [KEY] | Date | EmpsEffectiveStartDate of Empsphoto |
EmpsPassportId [KEY] | Long | EmpsPassportId of Empsphoto |
EmpsPersonId [KEY] | Long | EmpsPersonId of Empsphoto |
EmpsReligionId [KEY] | Long | EmpsReligionId of Empsphoto |
Image | String | Unique location of the image. Encrypted version of the file. |
ImageName | String | Name of the image. |
PrimaryFlag | Bool | Indicates whether the image is primary. |
ImageId [KEY] | Long | Photo ID |
PersonId | Long | PersonId of Empsphoto |
ObjectVersionNumber | Int | Used to implement optimistic locking. This number is incremented every time a row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
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 |