Workersphones

Columns


Name	Type	Description
WorkersPersonId [KEY]	Long	WorkersPersonId of Workersphones
PhoneId [KEY]	Long	PhoneId of Workersphones
PhoneType	String	Type of phone such as Work, Home, and so on. Valid values are defined in the commonLookupsLOV.
PhoneTypeMeaning	String	PhoneTypeMeaning of Workersphones
LegislationCode	String	Phone legislation code.
LegislationName	String	LegislationName of Workersphones
CountryCodeNumber	String	Country code of the phone number. Valid values are defined in the hcmCountriesLov.
AreaCode	String	Area code of the phone number.
PhoneNumber	String	Phone number of various phone types such as Work, Home, and so on.
Extension	String	Extension number for the phone.
FromDate	Date	Date from when the phone number is valid.
ToDate	Date	Date until when the phone number is valid.
Validity	String	Validity of Workersphones
ValidityMeaning	String	ValidityMeaning of Workersphones
CreatedBy	String	CreatedBy of Workersphones
CreationDate	Datetime	CreationDate of Workersphones
LastUpdatedBy	String	LastUpdatedBy of Workersphones
LastUpdateDate	Datetime	LastUpdateDate of Workersphones
PrimaryFlag	Bool	Indicates whether the phone number is the primary phone of the worker.
AssignmentId	Long	AssignmentId of Workersphones
AssignmentName	String	AssignmentName of Workersphones
AssignmentNumber	String	AssignmentNumber of Workersphones
DirectReportsFlag	String	DirectReportsFlag of Workersphones
Finder	String	Finder of Workersphones
LineManagerFlag	String	LineManagerFlag of Workersphones
PersonId	Long	PersonId of Workersphones
PersonNumber	String	PersonNumber of Workersphones
PrimaryAssignmentFlag	String	PrimaryAssignmentFlag of Workersphones
RelationshipType	String	RelationshipType of Workersphones
SysEffectiveDate	String	SysEffectiveDate of Workersphones
WorkerType	String	WorkerType of Workersphones
EffectiveDate	Date	EffectiveDate of Workersphones

SSIS Components for Oracle Fusion Cloud HCM

Workersphones

Columns