METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonNumber|StartDate|DateOfBirth|ActionCode
MERGE|Worker|EMP|HDL001|2001/09/08|HDL-1001|2001/09/08|1952/05/21|HIRE
MERGE|Worker|EMP|HDL002|2005/02/08|HDL-1002|2005/02/08|1966/04/21|HIRE

METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonId(SourceSystemId)|NameType|LegislationCode|Title|LastName|FirstName
MERGE|PersonName|EMP|HDL001_NME|2001/09/08|HDL001|GLOBAL|US|MR.|Wells|Christopher
MERGE|PersonName|EMP|HDL002_NME|2005/02/08|HDL002|GLOBAL|US|MRS.|Hugh|Lorraine

METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonId(SourceSystemId)|LegislationCode|Sex|MaritalStatus
MERGE|PersonLegislativeData|EMP|HDL001_LEG|2001/09/08|HDL001|US|M|M
MERGE|PersonLegislativeData|EMP|HDL002_LEG|2005/02/08|HDL002|US|F|S

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|PrimaryFlag
MERGE|WorkRelationship|EMP|HDL001_POS|HDL001|Vision Corporation|2001/09/08|E|Y
MERGE|WorkRelationship|EMP|HDL002_POS|HDL002|Vision Corporation|2005/02/08|E|Y

METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|PrimaryWorkTermsFlag
MERGE|WorkTerms|EMP|HDL001_TRM|HDL001_POS|HIRE|2001/09/08|1|Y|ET-HDL001|ET-HDL001|Y
MERGE|WorkTerms|EMP|HDL002_TRM|HDL002_POS|HIRE|2005/02/08|1|Y|ET-HDL002|ET-HDL002|Y

METADATA|Assignment|SourceSystemOwner|SourceSystemId|ActionCode|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|WorkTermsAssignmentId(SourceSystemId)|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|PersonTypeCode|BusinessUnitShortCode|PrimaryAssignmentFlag|JobId(SourceSystemId)|JobId(SourceSystemOwner)
MERGE|Assignment|EMP|HDL001_ASG|HIRE|2001/09/08|1|Y|HDL001_TRM|HDL001|HDL001|ACTIVE_PROCESS|Employee|Vision Operations|Y|SCN|VISION
MERGE|Assignment|EMP|HDL002_ASG|HIRE|2005/02/08|1|Y|HDL002_TRM|HDL002|HDL002|ACTIVE_PROCESS|Employee|Vision Operations|Y|MGR|VISION