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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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 |