Empsroles
Empsroles
Columns
| Name | Type | Description |
| EmpsCitizenshipId [KEY] | Long | EmpsCitizenshipId of Empsroles |
| EmpsDriversLicenseId [KEY] | Long | EmpsDriversLicenseId of Empsroles |
| EmpsEffectiveStartDate [KEY] | Date | EmpsEffectiveStartDate of Empsroles |
| EmpsPassportId [KEY] | Long | EmpsPassportId of Empsroles |
| EmpsPersonId [KEY] | Long | EmpsPersonId of Empsroles |
| EmpsReligionId [KEY] | Long | EmpsReligionId of Empsroles |
| RoleName | String | Name of the role. |
| RoleCommonName | String | Short name of the role. |
| RoleGUID [KEY] | String | Globally unique identifer for the role record in Oracle Cloud. Valid values are defined in the list RoleGUIDLOV. |
| StartDate | Date | Start date of the role. |
| EndDate | Date | End date of the role. |
| CreationDate | Datetime | CreationDate of Empsroles |
| LastUpdateDate | Datetime | Date and time of update of the employee role record. |
| BusinessUnitName | String | BusinessUnitName of Empsroles |
| CitizenshipId | Long | CitizenshipId of Empsroles |
| DepartmentName | String | DepartmentName of Empsroles |
| DriversLicenseId | Long | DriversLicenseId of Empsroles |
| EffectiveStartDate | Date | EffectiveStartDate of Empsroles |
| Finder | String | Finder of Empsroles |
| GradeName | String | GradeName of Empsroles |
| JobName | String | JobName of Empsroles |
| LocationName | String | LocationName of Empsroles |
| ManagerFullName | String | ManagerFullName of Empsroles |
| PassportId | Long | PassportId of Empsroles |
| PersonId | Long | PersonId of Empsroles |
| ReligionId | Long | ReligionId of Empsroles |
| SysEffectiveDate | String | SysEffectiveDate of Empsroles |