Workers

Columns


Name	Type	Description
PersonId [KEY]	Long	Surrogate identifier for the person.
PersonNumber	String	Number assigned to a person to identify the person uniquely. Does not depend on the person type such as employee, contingent worker, and so on.
CorrespondenceLanguage	String	Preferred language for communication. Valid values are defined in the commonLookupsLOV.
CorrLanguageMeaning	String	CorrLanguageMeaning of Workers
BloodType	String	Blood type of the person. Valid values are defined in the commonLookupsLOV.
BloodTypeMeaning	String	BloodTypeMeaning of Workers
DateOfBirth	Date	Date of birth of the person.
DateOfDeath	Date	Date of death of the person.
CountryOfBirth	String	Country of birth of the person. Valid values are defined in the hcmCountriesLOV.
CountryOfBirthName	String	CountryOfBirthName of Workers
RegionOfBirth	String	Region of birth of the person.
TownOfBirth	String	Town of birth of the person.
ApplicantNumber	String	Applicant number in the external application.
CreatedBy	String	CreatedBy of Workers
CreationDate	Datetime	CreationDate of Workers
LastUpdatedBy	String	LastUpdatedBy of Workers
LastUpdateDate	Datetime	LastUpdateDate of Workers
DisplayName	String	DisplayName of Workers
FullName	String	FullName of Workers
ListName	String	ListName of Workers

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


Name	Type	Description
AssignmentId	Long	AssignmentId
AssignmentName	String	AssignmentName
AssignmentNumber	String	AssignmentNumber
DirectReportsFlag	String	DirectReportsFlag
LineManagerFlag	String	LineManagerFlag
PrimaryAssignmentFlag	String	PrimaryAssignmentFlag
RelationshipType	String	RelationshipType
SysEffectiveDate	String	SysEffectiveDate
WorkerType	String	WorkerType
Finder	String	finder
EffectiveDate	Date	This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format.