Workersphones

Columns


Name	Type	SupportedFinders	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	FindReports	AssignmentId of Workersphones
AssignmentName	String	FindReports	AssignmentName of Workersphones
AssignmentNumber	String	FindReports	AssignmentNumber of Workersphones
DirectReportsFlag	String	FindReports	DirectReportsFlag of Workersphones
Finder	String		Finder of Workersphones
LineManagerFlag	String	FindReports	LineManagerFlag of Workersphones
PersonId	Long	PrimaryKey, findReports, findByPersonId	PersonId of Workersphones
PersonNumber	String	FindReports	PersonNumber of Workersphones
PrimaryAssignmentFlag	String	FindReports	PrimaryAssignmentFlag of Workersphones
RelationshipType	String	FindReports	RelationshipType of Workersphones
SysEffectiveDate	String	FindReports, findByPersonId	SysEffectiveDate of Workersphones
WorkerType	String	FindReports	WorkerType of Workersphones
EffectiveDate	Date		EffectiveDate of Workersphones

Power BI Connector for Oracle Fusion Cloud HCM

Workersphones

Columns