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. 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	AssignmentId of Workers
AssignmentName	String	AssignmentName of Workers
AssignmentNumber	String	AssignmentNumber of Workers
DirectReportsFlag	String	DirectReportsFlag of Workers
Finder	String	Finder of Workers
LineManagerFlag	String	LineManagerFlag of Workers
PrimaryAssignmentFlag	String	PrimaryAssignmentFlag of Workers
RelationshipType	String	RelationshipType of Workers
SysEffectiveDate	String	SysEffectiveDate of Workers
WorkerType	String	WorkerType of Workers
EffectiveDate	Date	EffectiveDate of Workers

TDV Adapter for Oracle Fusion Cloud HCM

Workers

Columns