METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|StartDateLabel|ActionCode|DateOfBirth
MERGE|Worker|VISION|52-273-3708|52-273-3708|2018/12/14|4712/12/31|2018/12/14|HIRE|1973/11/20
MERGE|Worker|VISION|55-166-6604|55-166-6604|2018/06/13|4712/12/31|2018/06/13|HIRE|1970/11/17
MERGE|Worker|VISION|19-094-4744|19-094-4744|2019/02/27|4712/12/31|2019/02/27|HIRE|1988/01/17
MERGE|Worker|VISION|76-973-0130|76-973-0130|2018/10/21|4712/12/31|2018/10/21|HIRE|1987/02/01
MERGE|Worker|VISION|94-932-6368|94-932-6368|2018/11/05|4712/12/31|2018/11/05|HIRE|1987/10/22
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|Sex
MERGE|PersonLegislativeData|VISION|LD52-273-3708|52-273-3708|2018/12/14|4712/12/31|US|F
MERGE|PersonLegislativeData|VISION|LD55-166-6604|55-166-6604|2018/06/13|4712/12/31|US|M
MERGE|PersonLegislativeData|VISION|LD19-094-4744|19-094-4744|2019/02/27|4712/12/31|US|M
MERGE|PersonLegislativeData|VISION|LD76-973-0130|76-973-0130|2018/10/21|4712/12/31|US|F
MERGE|PersonLegislativeData|VISION|LD94-932-6368|94-932-6368|2018/11/05|4712/12/31|US|F
METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title
MERGE|PersonName|VISION|PN52-273-3708|52-273-3708|2018/12/14|4712/12/31|US|GLOBAL|Viviyan||Penhall|Mrs.
MERGE|PersonName|VISION|PN55-166-6604|55-166-6604|2018/06/13|4712/12/31|US|GLOBAL|Launce||Osler|Mr.
MERGE|PersonName|VISION|PN19-094-4744|19-094-4744|2019/02/27|4712/12/31|US|GLOBAL|Brendin||Kissell|Mr.
MERGE|PersonName|VISION|PN76-973-0130|76-973-0130|2018/10/21|4712/12/31|US|GLOBAL|Dredi||Cawsby|Dr.
MERGE|PersonName|VISION|PN94-932-6368|94-932-6368|2018/11/05|4712/12/31|US|GLOBAL|Petra||Dagwell|Ms.
METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|EmailType|EmailAddress
MERGE|PersonEmail|VISION|EM52-273-3708|52-273-3708|2018/12/14|W1|vpenhallb@vision.oracle.com
MERGE|PersonEmail|VISION|EM55-166-6604|55-166-6604|2018/06/13|W1|loslerc@vision.oracle.com
MERGE|PersonEmail|VISION|EM19-094-4744|19-094-4744|2019/02/27|W1|bkisselld@vision.oracle.com
MERGE|PersonEmail|VISION|EM76-973-0130|76-973-0130|2018/10/21|W1|dcawsbye@vision.oracle.com
MERGE|PersonEmail|VISION|EM94-932-6368|94-932-6368|2018/11/05|W1|pdagwellf@vision.oracle.com
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateStart|WorkerType|LegalEmployerName|ActionCode|PrimaryFlag
MERGE|WorkRelationship|VISION|WR52-273-3708|52-273-3708|2018/12/14|E|Vision Corporation|HIRE|Y
MERGE|WorkRelationship|VISION|WR55-166-6604|55-166-6604|2018/06/13|E|Vision Corporation|HIRE|Y
MERGE|WorkRelationship|VISION|WR19-094-4744|19-094-4744|2019/02/27|E|Vision Corporation|HIRE|Y
MERGE|WorkRelationship|VISION|WR76-973-0130|76-973-0130|2018/10/21|E|Vision Corporation|HIRE|Y
MERGE|WorkRelationship|VISION|WR94-932-6368|94-932-6368|2018/11/05|E|Vision Corporation|HIRE|Y
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentName|AssignmentNumber|PrimaryWorkTermsFlag
MERGE|WorkTerms|VISION|ET52-273-3708|WR52-273-3708|2018/12/14|4712/12/31|1|Y|HIRE|ET52-273-3708|ET52-273-3708|Y
MERGE|WorkTerms|VISION|ET55-166-6604|WR55-166-6604|2018/06/13|4712/12/31|1|Y|HIRE|ET55-166-6604|ET55-166-6604|Y
MERGE|WorkTerms|VISION|ET19-094-4744|WR19-094-4744|2019/02/27|4712/12/31|1|Y|HIRE|ET19-094-4744|ET19-094-4744|Y
MERGE|WorkTerms|VISION|ET76-973-0130|WR76-973-0130|2018/10/21|4712/12/31|1|Y|HIRE|ET76-973-0130|ET76-973-0130|Y
MERGE|WorkTerms|VISION|ET94-932-6368|WR94-932-6368|2018/11/05|4712/12/31|1|Y|HIRE|ET94-932-6368|ET94-932-6368|Y
METADATA|Assignment|SourceSystemOwner|SourceSystemId|WorkTermsAssignmentId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentName|AssignmentNumber|PrimaryAssignmentFlag|BusinessUnitShortCode|AssignmentStatusTypeCode|PersonTypeCode|ProjectedStartDate
MERGE|Assignment|VISION|E52-273-3708|ET52-273-3708|2018/12/14|4712/12/31|1|Y|HIRE|E52-273-3708|E52-273-3708|Y|Vision Corporation Enterprise|ACTIVE_PROCESS|Employee|2018/12/14
MERGE|Assignment|VISION|E55-166-6604|ET55-166-6604|2018/06/13|4712/12/31|1|Y|HIRE|E55-166-6604|E55-166-6604|Y|Vision Corporation Enterprise|ACTIVE_PROCESS|Employee|2018/06/13
MERGE|Assignment|VISION|E19-094-4744|ET19-094-4744|2019/02/27|4712/12/31|1|Y|HIRE|E19-094-4744|E19-094-4744|Y|Vision Corporation Enterprise|ACTIVE_PROCESS|Employee|2019/02/27
MERGE|Assignment|VISION|E76-973-0130|ET76-973-0130|2018/10/21|4712/12/31|1|Y|HIRE|E76-973-0130|E76-973-0130|Y|Vision Corporation Enterprise|ACTIVE_PROCESS|Employee|2018/10/21
MERGE|Assignment|VISION|E94-932-6368|ET94-932-6368|2018/11/05|4712/12/31|1|Y|HIRE|E94-932-6368|E94-932-6368|Y|Vision Corporation Enterprise|ACTIVE_PROCESS|Employee|2018/11/05