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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。