Workers
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 |
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 |
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. |