JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

WorkersworkRelationshipsassignmentsworkMeasures

WorkersworkRelationshipsassignmentsworkMeasures

Columns

Name Type Description
WorkersPersonId [KEY] Long WorkersPersonId of WorkersworkRelationshipsassignmentsworkMeasures
WorkrelationshipsPeriodOfServiceId [KEY] Long WorkrelationshipsPeriodOfServiceId of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentsAssignmentId [KEY] Long AssignmentsAssignmentId of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentsEffectiveEndDate [KEY] Date AssignmentsEffectiveEndDate of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentsEffectiveLatestChange [KEY] String AssignmentsEffectiveLatestChange of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentsEffectiveSequence [KEY] Int AssignmentsEffectiveSequence of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentsEffectiveStartDate [KEY] Date AssignmentsEffectiveStartDate of WorkersworkRelationshipsassignmentsworkMeasures
AssignWorkMeasureId [KEY] Long AssignWorkMeasureId of WorkersworkRelationshipsassignmentsworkMeasures
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.
Value Decimal Value of the work measure.
Unit String Unit of measure. Valid values are defined in the commonLookupsLOV.
UnitMeaning String UnitMeaning of WorkersworkRelationshipsassignmentsworkMeasures
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.
CalculateWorkmeasureFlag Bool Indicates whether the full time equivalency (FTE) should be calculated automatically.
CreatedBy String CreatedBy of WorkersworkRelationshipsassignmentsworkMeasures
CreationDate Datetime CreationDate of WorkersworkRelationshipsassignmentsworkMeasures
LastUpdatedBy String LastUpdatedBy of WorkersworkRelationshipsassignmentsworkMeasures
LastUpdateDate Datetime LastUpdateDate of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentId Long AssignmentId of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentName String AssignmentName of WorkersworkRelationshipsassignmentsworkMeasures
AssignmentNumber String AssignmentNumber of WorkersworkRelationshipsassignmentsworkMeasures
DirectReportsFlag String DirectReportsFlag of WorkersworkRelationshipsassignmentsworkMeasures
Finder String Finder of WorkersworkRelationshipsassignmentsworkMeasures
LineManagerFlag String LineManagerFlag of WorkersworkRelationshipsassignmentsworkMeasures
PersonId Long PersonId of WorkersworkRelationshipsassignmentsworkMeasures
PersonNumber String PersonNumber of WorkersworkRelationshipsassignmentsworkMeasures
PrimaryAssignmentFlag String PrimaryAssignmentFlag of WorkersworkRelationshipsassignmentsworkMeasures
RelationshipType String RelationshipType of WorkersworkRelationshipsassignmentsworkMeasures
SysEffectiveDate String SysEffectiveDate of WorkersworkRelationshipsassignmentsworkMeasures
WorkerType String WorkerType of WorkersworkRelationshipsassignmentsworkMeasures
EffectiveDate Date EffectiveDate of WorkersworkRelationshipsassignmentsworkMeasures

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