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. |
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 |
PersonId | Long | PersonId |
ReligionId | Long | ReligionId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |