SSIS Components for Oracle Fusion Cloud HCM

Build 24.0.9060

WorkersworkRelationshipscontracts

WorkersworkRelationshipscontracts

Columns

Name Type Description
WorkersPersonId [KEY] Long WorkersPersonId of WorkersworkRelationshipscontracts
WorkrelationshipsPeriodOfServiceId [KEY] Long WorkrelationshipsPeriodOfServiceId of WorkersworkRelationshipscontracts
ContractId [KEY] Long Surrogate identifier for the contract.
ContractNumber String Number of the contract.
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.
ContractEndDate Date Date when the contract ends.
ContractType String Type of the contract.
ContractTypeMeaning String ContractTypeMeaning of WorkersworkRelationshipscontracts
Description String Description of the contract.
InitialDuration Decimal Initial duration of the contract.
InitialDurationUnits String Unit for the initial duration of the contract.
InitialDurationUnitsMeaning String InitialDurationUnitsMeaning of WorkersworkRelationshipscontracts
ExtensionNumber Int ExtensionNumber of WorkersworkRelationshipscontracts
ExtensionPeriod Decimal Extension period of the contract.
ExtensionPeriodUnits String Unit for the extension period of the contract.
ExtensionPeriodUnitsMeaning String ExtensionPeriodUnitsMeaning of WorkersworkRelationshipscontracts
ActionCode String Action code for the employment contract.
CreatedBy String CreatedBy of WorkersworkRelationshipscontracts
CreationDate Datetime CreationDate of WorkersworkRelationshipscontracts
LastUpdatedBy String LastUpdatedBy of WorkersworkRelationshipscontracts
LastUpdateDate Datetime LastUpdateDate of WorkersworkRelationshipscontracts
ActionName String ActionName of WorkersworkRelationshipscontracts
ContractExtensionFlag Bool Indicates whether the contract should be extended. Valid values are Yes and No. The default value is null.
AssignmentId Long AssignmentId of WorkersworkRelationshipscontracts
AssignmentName String AssignmentName of WorkersworkRelationshipscontracts
AssignmentNumber String AssignmentNumber of WorkersworkRelationshipscontracts
DirectReportsFlag String DirectReportsFlag of WorkersworkRelationshipscontracts
Finder String Finder of WorkersworkRelationshipscontracts
LineManagerFlag String LineManagerFlag of WorkersworkRelationshipscontracts
PersonId Long PersonId of WorkersworkRelationshipscontracts
PersonNumber String PersonNumber of WorkersworkRelationshipscontracts
PrimaryAssignmentFlag String PrimaryAssignmentFlag of WorkersworkRelationshipscontracts
RelationshipType String RelationshipType of WorkersworkRelationshipscontracts
SysEffectiveDate String SysEffectiveDate of WorkersworkRelationshipscontracts
WorkerType String WorkerType of WorkersworkRelationshipscontracts
EffectiveDate Date EffectiveDate of WorkersworkRelationshipscontracts

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