Dat File Name: Worker.dat
METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|StartDate|DateOfBirth|ActionCode
METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress
METADATA|PersonEthnicity|SourceSystemOwner|SourceSystemId|PersonNumber|LegislationCode|Ethnicity|PrimaryFlag
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|LegislationCode|Sex
METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName| MiddleNames|LastName|KnownAs
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonNumber|DateStart|LegalEmployerName|WorkerType|GlobalTransferFlag|Termin ateWorkRelationshipFlag|ActualTerminationDate|ActionCode
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId(SourceSystemId)|AssignmentStatusTypeCode|AssignmentType|LegalEmployerName|BusinessUnitShortCode|ActionCode|PrimaryWorkTer msFlag
METADATA|Assignment|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId(SourceSystemId)|WorkTermsAssignmentId(SourceSystemId)|AssignmentStatusTypeCode|AssignmentType|LegalEmployerName|BusinessUnitShortCode|LocationId(SourceSystemId)|OrganizationId(SourceSystemId)|JobId(SourceSystemId)|HourlySalariedCode|ManagerFlag|PrimaryAssignmentFlag| ReasonCode|ActionCode|PrimaryFlag
METADATA|AssignmentSupervisor|SourceSystemOwner|SourceSystemId|AssignmentId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|PrimaryFlag|M anagerPersonNumber|ManagerAssignmentId(SourceSystemId)|ManagerType
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.