Examples of Loading Work Relationship Changes
The Worker object provides several indicator attributes that simplify maintenance of work relationships. Use these indicators to request actions such as termination or a change of primary assignment. This topic provides examples of work-relationship changes that you request using these indicators.
Changing the Hire Date
The hire date is the start date of a work relationship. To change the hire date, provide the new date on the NewStartDate attribute of the Work Relationship component. You can load just the work relationship record. The employment terms and assignment records are maintained automatically.
This example changes the hire date for an existing worker.
SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|NewStartDate
MERGE|WorkRelationship|VISION|1009_POS|1009|Cox-6-CWB|2002/02/10
Terminating a Work Relationship
To terminate a work relationship, load the Work Relationship component with the TerminateWorkRelationshipFlag attribute set to Y. Specify the termination date on the ActualTerminationDate attribute. All associated assignments are automatically made inactive after the termination date.
This example terminates a work relationship.
SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|TerminateWorkRelationshipFlag|ActualTerminationDate|ActionCode|ReasonCode
MERGE|WorkRelationship|VISION|1009_POS|1009|Cox-6-CWB|Y|2015/10/02|RESIGNATION|RESIGN_PERSONAL
You can update the assignment status while terminating the work relationship by loading the work relationship and assignment rows in the Worker.dat file.
This example updates the assignment status while terminating the work relationship.
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|ActualTerminationDate|ActionCode|ReasonCode
MERGE|WorkRelationship|VISION|1009_POS|1009|Cox-6-CWB|2015/10/02|RESIGNATION|RESIGN_PERSONAL
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentStatusTypeCode|BusinessUnitShortCode
MERGE|WorkTerms|ET955160008178426|955160008178426|Vision Corporation|2009/01/01|E|RESIGNATION|RESIGN_PERSONAL|2015/10/03|4712/12/31|Y|1|INACTIVE_PROCESS|Vision ADB
METADATA|Assignment|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentStatusTypeCode|BusinessUnitShortCode|FLEX:PER_ASG_DF|hdlG(PER_ASG_DF=Global Data Elements)
MERGE|Assignment|E955160008178426|955160008178426|Vision Corporation|2009/01/01|E|RESIGNATION|RESIGN_PERSONAL|ET955160008178426|2015/10/03|4712/12/31|Y|1|INACTIVE_PROCESS|Vision ADB|Global Data Elements|TestValue
Correcting the Termination Date of a Work Relationship
To correct a work relationship termination date, supply a new ActualTerminationDate and set the CorrectTerminationFlag attribute to Y.
This example corrects the termination date for a terminated work relationship.
SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|CorrectTerminationFlag|ActualTerminationDate
MERGE|WorkRelationship|VISION|1009_POS|1009|Cox-6-CWB|Y|2015/10/08
Reversing a Termination
To reverse a termination, load the Work Relationship component with the ReverseTerminationFlag attribute set to Y.
This example reverses the termination of a work relationship.
SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|ReverseTerminationFlag
MERGE|WorkRelationship|VISION|1009_POS|1009|Cox-6-CWB|Y
Canceling a Work Relationship
To cancel a work relationship, use a DELETE instruction for the work relationship and set the CancelWorkRelationshipFlag attribute to Y.
This example deletes the specified work relationship and all its child records.
SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|CancelWorkRelationshipFlag
DELETE|WorkRelationship|VISION|1008_POS|1008|Y
Changing the Primary Assignment or Work Relationship
When you load a primary work relationship, the existing primary work relationship automatically becomes nonprimary on the date that you supply on the DateForPrimaryFlagChange attribute.
To make a nonprimary work relationship primary, you load the work relationship to be made primary with the PrimaryFlag attribute set to Y. Specify the date when the work relationship becomes primary on the DateForPrimaryFlagChange attribute. The corresponding changes to employment terms and assignments occur automatically. The primary indicator for the existing primary work relationship is set to N automatically.