Workers

Columns


Name	Type	SupportedFinders	Description
PersonId [KEY]	Long	PrimaryKey, findReports, findByPersonId	Surrogate identifier for the person.
PersonNumber	String	FindReports	Number assigned to a person to identify the person uniquely. Doesn't 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
AssignmentId	Long	FindReports	AssignmentId of Workers
AssignmentName	String	FindReports	AssignmentName of Workers
AssignmentNumber	String	FindReports	AssignmentNumber of Workers
DirectReportsFlag	String	FindReports	DirectReportsFlag of Workers
Finder	String		Finder of Workers
LineManagerFlag	String	FindReports	LineManagerFlag of Workers
PrimaryAssignmentFlag	String	FindReports	PrimaryAssignmentFlag of Workers
RelationshipType	String	FindReports	RelationshipType of Workers
SysEffectiveDate	String	FindReports, findByPersonId	SysEffectiveDate of Workers
WorkerType	String	FindReports	WorkerType of Workers
EffectiveDate	Date		EffectiveDate of Workers

ODBC Driver for Oracle Fusion Cloud HCM

Workers

Columns