Example of Loading PeopleGroup for a Worker

If you want to assign workers to groups, like certain pension plans, you can use the People Group key flexfield to do that. Here's an example on how to load the People Group flexfield.

Load a People Group Flexfield

Let's say you want to assign people to pension plans. First, you add the 'PeopleGroup' attribute to a METADATA Assignment record in your Worker.dat file. Then add a MERGE Assignment record with the value for the people group that you want. In this example, 'PeopleGroup' and its value appear at the end of the metadata and merge entries, respectively.

METADATA|Worker|PersonId|EffectiveStartDate|EffectiveEndDate|PersonNumber|BloodType|CorrespondenceLanguage|StartDate|DateOfBirth|DateOfDeath|CountryOfBirth|RegionOfBirth|TownOfBirth|ApplicantNumber|WaiveDataProtectFlag|CategoryCode|SourceSystemOwner|SourceSystemId|GUID|ActionCode|ReasonCode|SourceRefTableName=PER_ALL_PEOPLE_F|SourceRef001=PERSON_ID|SourceRef002=PERSON_NUMBER|SourceRefName003=START_DATE
MERGE|Worker||2000/01/01|4712/12/31|Worker_DL_101|||2000/01/01|1970/01/01||||||Y||HRC_SQLLOADER|SSIW_DL_101_1234_1||HIRE||||Worker_DL_101|2000/01/01
METADATA|PersonName|PersonNameId|EffectiveStartDate|EffectiveEndDate|PersonId|PersonNumber|LegislationCode|NameType|FirstName|MiddleNames|LastName|Honors|KnownAs|PreNameAdjunct|MilitaryRank|PreviousLastName|Suffix|Title|CharSetContext|SourceSystemOwner|SourceSystemId|GUID|NameInformation1|NameInformation2|NameInformation3|NameInformation4|NameInformation5|NameInformation6|NameInformation7|NameInformation8|NameInformation9|NameInformation10|NameInformation11|NameInformation12|NameInformation13|NameInformation14|NameInformation15|NameInformation16|NameInformation17|NameInformation18|NameInformation19|NameInformation20|NameInformation21|NameInformation22|NameInformation23|NameInformation24|NameInformation25|NameInformation26|NameInformation27|NameInformation28|NameInformation29|NameInformation30|SourceRefTableName=PER_PERSON_NAMES_F|SourceRef001=PERSON_ID|SourceRef002=PERSON_NUMBER|SourceRef003=NAME_TYPE|SourceRef004=LAST_NAME
MERGE|PersonName||2000/01/01|4712/12/31||Worker_DL_101|US|GLOBAL|Worker_DL_101 FName|MN|Worker_DL_101 LName|Doctor|Worker_DL_101||12|Prev LName|Suffix|Mr.|US|HRC_SQLLOADER|SSIW_DL_101_NAME_1234_1||Worker_DL_101|NI2|NI3|NI4|NI5|NI6|NI7|NI8|NI9|NI10|NI11|NI12|NI13|NI14|NI15|NI16|NI17|NI18|NI19|NI20|NI21|NI22|NI23|NI24|NI25|NI26|NI27|NI28|NI29|NI30|||Worker_DL_101|GLOBAL|Worker_DL_101 LName
METADATA|PersonLegislativeData|PersonLegislativeId|EffectiveStartDate|EffectiveEndDate|PersonId|PersonNumber|LegislationCode|HighestEducationLevel|MaritalStatus|MaritalStatusDate|Sex|SourceSystemOwner|SourceSystemId|GUID|SourceRefTableName=PER_PEOPLE_LEGISLATIVE_F|SourceRef001=PERSON_ID|SourceRef002=LEGISLATION_CODE
MERGE|PersonLegislativeData||2000/01/01|4712/12/31||Worker_DL_101|US||Married|2002/01/01|Male|HRC_SQLLOADER|SSIW_DL_101_LEG_1234_1||||US
METADATA|WorkRelationship|LegalEmployerSeniorityDate|ActualTerminationDate|LegalEntityId|Comments|EnterpriseSeniorityDate|LastWorkingDate|DateStart|NotifiedTerminationDate|OnMilitaryServiceFlag|PeriodOfServiceId|PersonId|PrimaryFlag|ProjectedTerminationDate|RehireAuthorizerPersonId|RehireAuthorizor|RehireReason|RevokeUserAccess|WorkerNumber|PersonNumber|LegalEmployerName|RehireRecommendationFlag|WorkerType|GUID|SourceSystemId|SourceSystemOwner|NewStartDate|SourceRefTableName=PER_PERIODS_OF_SERVICE|SourceRef001=LEGAL_ENTITY_ID|SourceRef002=LEGISLATION_CODE|SourceRef003=DATE_START
MERGE|WorkRelationship|||||||2000/01/01|||||Y||||||55857|Worker_DL_101|Vision Corporation||E||SSIW_DL_101_WREL_1234_2|HRC_SQLLOADER||||US|2000/01/01
METADATA|WorkTerms|ActionCode|AssignmentId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentStatusTypeId|AssignmentType|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|ContractId|DateProbationEnd|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkerCategory|AssignmentCategory|EstablishmentId|ReportingEstablishment|ExpenseCheckSendToAddress|GradeId|GradeCode|GradeLadderPgmId|GradeLadderPgmName|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobId|JobCode|LocationId|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|OrganizationId|DepartmentName|PeriodOfServiceId(SourceSystemId)|PersonId|PersonNumber|DateStart|WorkerType|LegalEmployerName|PersonTypeId|PersonTypeCode|PositionCode|PositionOverrideFlag|PrimaryWorkTermsFlag|ProbationPeriod|ProbationUnit|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStepId|SpecialCeilingStep|StepEntryDate|SystemPersonType|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsAssignmentId|VendorId|FreezeStartDate|FreezeUntilDate|GUID|SourceSystemOwner|SourceSystemId|CategoryCode|TaxReportingUnitId|TaxReportingUnit|SourceRefTableName=PER_ALL_ASSIGNMENTS_M|SourceRef001=ASSIGNMENT_NAME|SourceRef002=ASSIGNMENT_NUMBER|SourceRef003=ASSIGNMENT_TYPE|DefaultExpenseAccount
MERGE|WorkTerms|HIRE||TestWT_Worker_DL_101|TestWTNum_Worker_DL_101|ACTIVE_PROCESS||ET|||202||||4712/12/31|Y|1|2000/01/01|WC|FR|||||||||||||||||||||||||SSIW_DL_101_WREL_1234_2|||||Vision Corporation||Employee|||Y|||||||||||||||||||||||HRC_SQLLOADER|SSIW_DL_101_WTERM_1234_1|||||TestWT_Worker_DL_101|TestWTNum_Worker_DL_101|ET|01-300-1150-00
METADATA|Assignment|ActionCode|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentStatusTypeId|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|DateProbationEnd|WorkerCategory|AssignmentCategory|EstablishmentId|ReportingEstablishment|ExpenseCheckSendToAddress|GradeId|GradeCode|GradeLadderPgmId|GradeLadderPgmName|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobId|JobCode|LabourUnionMemberFlag|LocationCode|LocationId|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|OrganizationId|PeriodOfServiceId(SourceSystemId)|PersonNumber|PersonId|DateStart|WorkerType|LegalEmployerName|PersonTypeCode|PersonTypeId|PositionCode|PositionId|PositionOverrideFlag|PrimaryAssignmentFlag|ProbationPeriod|ProbationUnit|ProjectTitle|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStep|SpecialCeilingStepId|SystemPersonType|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsNumber|WorkTermsAssignmentId(SourceSystemId)|DepartmentName|VendorId|FreezeStartDate|FreezeUntilDate|GUID|SourceSystemId|SourceSystemOwner|CategoryCode|SourceRefTableName=PER_ALL_ASSIGNMENTS_M|SourceRef001=ASSIGNMENT_NAME|SourceRef002=ASSIGNMENT_NUMBER|SourceRef003=ASSIGNMENT_TYPE|DefaultExpenseAccount|PeopleGroup
MERGE|Assignment|HIRE||2000/01/01|4712/12/31|1|Y|E|TestWANM_Worker_DL_101|TestWANum_Worker_DL_101|ACTIVE_PROCESS||||202|||WC|FR|||||||||||||||||||||||||SSIW_DL_101_WREL_1234_2|||2000/01/01||Vision Corporation|Employee|||||Y||||||||||||||||||TestWTNum_Worker_DL_101|SSIW_DL_101_WTERM_1234_1||||||SSIW_DL_101_WASGN_1234_1|HRC_SQLLOADER|||TestWANM_Worker_DL_101|TestWANum_Worker_DL_101|E|01-300-1150-00|A

Delete a People Group Flexfield

Let's say, for GDPR or other compliance purposes, you must remove values from a 'PeopleGroup' flexfield segment and disable it. First, enable the segment if it's currently disabled. Next, change the values for the segment in your HCM Data Loader file to empty. Don't use spaces, and make sure the values are empty. Upload your HCM Data Loader file and confirm that the segments appear empty. Finally, disable the segment, if applicable.