COMMENT Data for Business Object: Worker Version: V1.0 Created on: 25-11-2024 SET CREATE_DEFAULT_WORKING_HOUR_PATTERN Y METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonNumber|StartDate|DateOfBirth|ActionCode MERGE|Worker|EBSHR|GANHDL001|2024/01/01|GAN1001|2024/01/01|1982/05/21|HIRE MERGE|Worker|EBSHR|GANHDL002|2024/01/01|GAN1002|2024/01/01|1996/04/21|HIRE METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonId(SourceSystemId)|NameType|LegislationCode|Title|LastName|FirstName MERGE|PersonName|EBSHR|GANHDL001_NM|2024/01/01|GANHDL001|GLOBAL|US|MR.|Gan_test|HDL MERGE|PersonName|EBSHR|GANHDL002_NM|2024/01/01|GANHDL002|GLOBAL|US|MRS.|New_test|HDL METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonId(SourceSystemId)|LegislationCode|Sex|MaritalStatus MERGE|PersonLegislativeData|EBSHR|GANHDL001_LEG|2024/01/01|GANHDL001|US|M|M MERGE|PersonLegislativeData|EBSHR|GANHDL002_LEG|2024/01/01|GANHDL002|US|F|S METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|PrimaryFlag MERGE|WorkRelationship|EBSHR|GANHDL001_PS|GANHDL001|US1 Legal Entity|2024/01/01|E|Y MERGE|WorkRelationship|EBSHR|GANHDL002_PS|GANHDL002|US1 Legal Entity|2024/01/01|E|Y METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|PrimaryWorkTermsFlag MERGE|WorkTerms|EBSHR|GANHDL001_TR|GANHDL001_PS|HIRE|2024/01/01|1|Y|ET-HDL001|ET-HDL001|Y MERGE|WorkTerms|EBSHR|GANHDL002_TR|GANHDL002_PS|HIRE|2024/01/01|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|EBSHR|GANHDL001_ASG|HIRE|2024/01/01|1|Y|GANHDL001_TR|GANHDL001|GANHDL001|ACTIVE_PROCESS|Employee|US1 Business Unit|Y|GAN_JOB|EBSHR MERGE|Assignment|EBSHR|GANHDL002_ASG|HIRE|2024/01/01|1|Y|GANHDL002_TR|GANHDL002|GANHDL002|ACTIVE_PROCESS|Employee|US1 Business Unit|Y|GAN_JOB|EBSHR