JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

WorkersworkRelationshipsassignmentsmanagers

WorkersworkRelationshipsassignmentsmanagers

Columns

Name Type Description
WorkersPersonId [KEY] Long WorkersPersonId of WorkersworkRelationshipsassignmentsmanagers
WorkrelationshipsPeriodOfServiceId [KEY] Long WorkrelationshipsPeriodOfServiceId of WorkersworkRelationshipsassignmentsmanagers
AssignmentsAssignmentId [KEY] Long AssignmentsAssignmentId of WorkersworkRelationshipsassignmentsmanagers
AssignmentsEffectiveEndDate [KEY] Date AssignmentsEffectiveEndDate of WorkersworkRelationshipsassignmentsmanagers
AssignmentsEffectiveLatestChange [KEY] String AssignmentsEffectiveLatestChange of WorkersworkRelationshipsassignmentsmanagers
AssignmentsEffectiveSequence [KEY] Int AssignmentsEffectiveSequence of WorkersworkRelationshipsassignmentsmanagers
AssignmentsEffectiveStartDate [KEY] Date AssignmentsEffectiveStartDate of WorkersworkRelationshipsassignmentsmanagers
AssignmentSupervisorId [KEY] Long AssignmentSupervisorId of WorkersworkRelationshipsassignmentsmanagers
EffectiveStartDate [KEY] Date Start date of the date-effective changes to the record.
EffectiveEndDate [KEY] Date End date of the date-effective changes to the record.
ManagerAssignmentId Long Surrogate identifier for the assignment supervisor.
ManagerAssignmentNumber String Assignment number of the supervisor.
ManagerType String Role the supervisor has with regards to the overall organization structure such as functional, project leader, and so on. Valid values are defined in the commonLookupsLOV.
ManagerTypeMeaning String ManagerTypeMeaning of WorkersworkRelationshipsassignmentsmanagers
ActionCode String Action being performed on the assignment such as Hire, Add Pending Worker, Manager Change and so on. Valid values are defined in the actionsLOV.
ReasonCode String Reason for the change. Valid values are defined in the actionReasonsLOV.
CreatedBy String CreatedBy of WorkersworkRelationshipsassignmentsmanagers
CreationDate Datetime CreationDate of WorkersworkRelationshipsassignmentsmanagers
LastUpdatedBy String LastUpdatedBy of WorkersworkRelationshipsassignmentsmanagers
LastUpdateDate Datetime LastUpdateDate of WorkersworkRelationshipsassignmentsmanagers
AssignmentId Long AssignmentId of WorkersworkRelationshipsassignmentsmanagers
AssignmentName String AssignmentName of WorkersworkRelationshipsassignmentsmanagers
AssignmentNumber String AssignmentNumber of WorkersworkRelationshipsassignmentsmanagers
DirectReportsFlag String DirectReportsFlag of WorkersworkRelationshipsassignmentsmanagers
Finder String Finder of WorkersworkRelationshipsassignmentsmanagers
LineManagerFlag String LineManagerFlag of WorkersworkRelationshipsassignmentsmanagers
PersonId Long PersonId of WorkersworkRelationshipsassignmentsmanagers
PersonNumber String PersonNumber of WorkersworkRelationshipsassignmentsmanagers
PrimaryAssignmentFlag String PrimaryAssignmentFlag of WorkersworkRelationshipsassignmentsmanagers
RelationshipType String RelationshipType of WorkersworkRelationshipsassignmentsmanagers
SysEffectiveDate String SysEffectiveDate of WorkersworkRelationshipsassignmentsmanagers
WorkerType String WorkerType of WorkersworkRelationshipsassignmentsmanagers
EffectiveDate Date EffectiveDate of WorkersworkRelationshipsassignmentsmanagers

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