JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

Workersphones

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062