JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

WorkersexternalIdentifiers

WorkersexternalIdentifiers

Columns

Name Type Description
WorkersPersonId [KEY] Long WorkersPersonId of WorkersexternalIdentifiers
ExternalIdentifierId [KEY] Long ExternalIdentifierId of WorkersexternalIdentifiers
ExternalIdentifierSequence Int Sequence of the external identifier.
ExternalIdentifierNumber String External identifier number.
ExternalIdentifierType String Type of external identifier, such as Third-Party Payroll ID. Valid values are defined in the commonLookupsLOV.
ExternalIdentifierTypeMeaning String ExternalIdentifierTypeMeaning of WorkersexternalIdentifiers
AssignmentId Long Unique identifier of the assignment to which this external identifier relates.
FromDate Datetime Date and time from when the external identifier is valid.
ToDate Datetime Date and time until when the external identifier is valid.
Comments String Comments for the external identifier.
CreatedBy String CreatedBy of WorkersexternalIdentifiers
CreationDate Datetime CreationDate of WorkersexternalIdentifiers
LastUpdatedBy String LastUpdatedBy of WorkersexternalIdentifiers
LastUpdateDate Datetime LastUpdateDate of WorkersexternalIdentifiers
AssignmentNumber String Assignment number to which the external identifier belongs.
AssignmentName String AssignmentName of WorkersexternalIdentifiers
DirectReportsFlag String DirectReportsFlag of WorkersexternalIdentifiers
Finder String Finder of WorkersexternalIdentifiers
LineManagerFlag String LineManagerFlag of WorkersexternalIdentifiers
PersonId Long PersonId of WorkersexternalIdentifiers
PersonNumber String PersonNumber of WorkersexternalIdentifiers
PrimaryAssignmentFlag String PrimaryAssignmentFlag of WorkersexternalIdentifiers
RelationshipType String RelationshipType of WorkersexternalIdentifiers
SysEffectiveDate String SysEffectiveDate of WorkersexternalIdentifiers
WorkerType String WorkerType of WorkersexternalIdentifiers
EffectiveDate Date EffectiveDate of WorkersexternalIdentifiers

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