Use the Employee Personal Data wizard to upload personal employee data. Examples of employee personal data include: Birth State, Birth Country, SIN Expiry date, Seniority Date, First Day worked Gender Identity, Ethnicity, Marital Status, Disabled, Veteran Status, and Language. The wizard runs validations to make sure that the data is correct.
Important notes
- You can run this data load more than one time.
- See your Implementation Consultant for the accepted values for your configuration.
- Activate uses HR Version 2.0 (NextGen) when loading data during configuration.
Before you begin
Employees being provided in the Employee Personal template must exist in Dayforce.
Using this wizard
The previously loaded employee personal information shows in an editable grid with the compensation-related fields that need to be populated. You can enter information directly in the grid or you can download the Employee Personal template, populate it, and then upload the data. When you edit the data in the grid, Activate shows any applicable validation warnings or errors. If warnings or errors are shown, you must review and correct them by updating the data in the grid or uploading a corrected template.
Tasks
- In Activate Central, click Load Your Data. The Load Your Data wizards are shown.
- Click Employee Personal Data.
- On the Employee Personal Data page, click Download.
Note: You can also download an empty Employee Personal Data template from the Download Template Files page.
- Select the location where you want to save the template document.
- Open the
PersonalDataTemplate.xlsxtemplate on your computer. - On the Employee Personal tab, complete all columns with the data for all employees in the organization.
Important: The Birth Date and National ID/Social Security Number are required
Note: The Activate release version shows in cell B3 on the Instructions tab of the template. This information helps you later determine the version of Activate you were using when you downloaded the template.
Note: Instructions for populating the fields are in the Personal Data Template Fields section (below) and on the Instructions tab of the template.
- Click Save and close the template.
You can use any file name for the template you upload. The file must be an Excel or CSV (Comma-Separated Value) document and contain the data in the required format.
Important: Don’t change the name of the tab because Activate uses it to validate that the correct template is being uploaded.
- On the Employee Personal Data page, click Upload.
- Go to your completed Employee Personal Data template in the location where you saved it.
- Click Open. The Employee Personal Data wizard validates the uploaded file.
Note: If you load a Personal Data record for an employee with no address, Activate determines which field to import the National ID value based on the employee's pay group country. It then shows a warning that states that the Employee {identifier} has no address in Dayforce. Country-specific values such as National ID might not be loaded correctly.
Note: If the uploaded file has errors, a Validation Failed message shows in red at the bottom of the page. You must correct the errors in the file on your computer and upload the file again.
Note: When you upload an Excel file, Activate includes the name of the uploaded file into the name of the XML file it generates and loads to the Dayforce File Server. The format of the generated XML file name is <NamespaceName>_<Import Type>_<file name provided>_YYY-MM-DD_HHMM. This information makes it easier to audit files later.
- If the uploaded file has errors, a Validation Failed message shows in red on the page. You must correct the errors in the file on your computer and upload the file again.
- Click Next.
- On the Options page, select one of the following to indicate whether you want to reset passwords for employees through this data load:
- Yes, reset the passwords- Each employee's password is reset. Passwords are reset using the employee's current password policy and the personal data loaded.
Note: Resetting the passwords with this wizard confirms that the fields required by each password policy are: already available in Dayforce or included in the data provided in this wizard. Upon completion of the wizard, Activate applies the most up-to-date password policy to all employees.
Important: This consideration is important for Go Live. Reset the password if the password policy has changed OR you’re using this wizard to finalize the employee's personal data. Previously generated passwords might not conform to the current password policy until a password reset is run.
- No, do not reset the passwords- No passwords are changed.
- Yes, reset the passwords- Each employee's password is reset. Passwords are reset using the employee's current password policy and the personal data loaded.
- Click Done. The Employee Personal Review page opens.
- Review the information shown in the grid.
- To make updates to data on the page:
To insert a new row in the grid, click the row where you want to insert it and click New.
To delete a row, click the row and click Delete.
- To download the error message list and save it to your computer, click Download Errors File.
- To correct errors in the grid, click in the field containing the error. Click Tab to move to the right and Shift+Tab to move to the left in the row. Use the scrollbars on the right side and bottom of the grid to go to other areas of the grid.
To save information in the grid to your computer, click Download File and save it to the location you want.
To upload the file from your computer, locate the file and click Upload File. The data in the file shows in the grid.
To remove changes that you don’t want to save, click Refresh.
- When the data is complete, click Done & Install. When you leave the page, the selected values stay in the grid.
When the personal information is complete in Activate, you must install the data in Dayforce.
- After making any necessary corrections, on the Employee Personal Review page, click Load.
The Load page opens with a list of the steps to complete and an estimate of how long the installation usually takes. During the installation, the current step in the process is bolded so you can monitor the progress.
-
Click one of the following:
- Add Email and enter your email address to be notified when the installation process ends instead of waiting for it to finish.
- Next when the installation is complete.
Activate Central opens with the wizard name now in green text and a green checkmark next to it. The day, date, and time of completion show, along with your name as the user who completed the wizard. The environment in which the installation was applied (Stage, Config, or Train) is also shown.
Note: If you want to add more information, click I want to add more. See Executing a Rollback When Using the “Add More“ Feature in the Payroll Wizards.
Results
The employee personal data has been uploaded to Dayforce. To see the information in Dayforce, go to People > Personal > Confidential Information.
The data uploaded from the Employee Personal Data template populates the fields on the following pages in Dayforce.
Note: You must select an employee if you haven’t already done so.
Note: Items shaded in gray are used for configuration.
| Field in Template | Field in Dayforce | Page in Dayforce |
|---|---|---|
| Employee Identifier | Employee Reference / Number |
|
|
Title |
Title |
Contact Information (People icon > Personal > Contact Information)
|
| First Name | First Name | |
| Middle Name (Not required) | Middle Name | |
| Last Name | Last Name | |
| Suffix | Suffix | |
| Common Name | Common Name | |
| Second Last Name | Second Last Name (non-US/CAN EEs) |
|
| Maiden Name | Maiden Name | |
| National ID | SSN | Confidential Information (People icon > Personal > Confidential Information)
|
| Nationality | Nationality (non-US/CAN EEs) |
|
| Citizenship | Citizenship Status | |
| Birth City |
Birth City (non-US/CAN EEs) |
|
| Birth State |
Birth State (non-US/CAN EEs) |
|
| Birth Country |
Birth Country (non-US/CAN EEs) |
|
| SIN Expiry Date |
SIN Expiry Date, SSN Expiry Date (depending on employee's country) |
|
| Seniority Date | Seniority Date |
Compensation and Policy Settings, Key Information tab (People icon > Employment > Employment, Compensation and Policy Settings, Key Information tab)
|
| First Date Worked | First Date Worked | |
| Assigned Sex |
Confidential Information (People icon > Personal > Confidential Information)
|
|
| Gender Identity | Gender Identity | |
| Ethnicity |
Ethnicity section (US employees) |
|
| Religion | ||
| Marital Status | Marital Status | |
| Disabled | Disabled | |
| Veteran Status |
Veteran Status section (US EEs) |
|
| Veteran Status Start Date | Effective From | |
| Veteran Status End Date | Effective To | |
| Visible Minority | Visible Minority (Canadian EEs) | |
| Aboriginal |
Aboriginal (Canadian EEs) |
|
| Federation ID | Single Sign On Login | |
| Language (Culture Code) | Dayforce Language for User |
After completing the Employee Personal Data wizard, a single import file is automatically generated and placed on the customer's FTP site.
HR Import
- FTP Subdirectory: Import/HRImport
- Filename: <Namespace> HRImport <DateTime>.xml
<?xml version="1.0" encoding="utf-8"?>
<EmployeeImport>
<Employee>
<XRefCode>001000</XRefCode>
<EmployeeNumber>001000</EmployeeNumber>
<FirstName>Lucie</FirstName>
<MiddleName>M</MiddleName>
<LastName>Mullis</LastName>
<CommonName>CN2</CommonName>
<MaidenName>MN2</MaidenName>
<SecondLastName>SLN2</SecondLastName>
<BirthCountry>USA</BirthCountry>
<BirthState>US-AK</BirthState>
<BirthCity>SF</BirthCity>
<Nationality>USA</Nationality>
<Suffix>Suffix2</Suffix>
<Gender>M</Gender>
<GenderIdentityXrefCode>MALE</GenderIdentityXrefCode>
<SocialSecurityNumber>AA444444A</SocialSecurityNumber>
<StartDate>2020-01-01</StartDate>
<SeniorityDate>1953-01-01</SeniorityDate>
<CultureCode>en-US</CultureCode>
<FederationId>a11112</FederationId>
<EmployeeMaritalStatus>
<MaritalStatusXrefCode>SAMESEXPARTNERSHIP</MaritalStatusXrefCode>
<EffectiveStart>2010-07-12</EffectiveStart>
</EmployeeMaritalStatus>
<CANConfidentialInformation>
<RegisteredDisabled>DECLINE</RegisteredDisabled>
<IsVisibleMinority>YES</IsVisibleMinority>
<IsAboriginal>YES</IsAboriginal>
</CANConfidentialInformation>
<USConfidentialInformation>
<Ethnicity>
<EthnicityXrefCode>Hispanic or Latino</EthnicityXrefCode>
<StartDate>2010-07-12</StartDate>
</Ethnicity>
<VeteranStatus>
<VeteranStatusXrefCode>ArmedForcesServiceMedalVeteran</VeteranStatusXrefCode>
<StartDate>2011-01-05</StartDate>
<EndDate>2020-01-05</EndDate>
</VeteranStatus>
<RegisteredDisabled>DECLINE</RegisteredDisabled>
</USConfidentialInformation>
</Employee>
<Employee>
<XRefCode>4617</XRefCode>
<EmployeeNumber>4617</EmployeeNumber>
<FirstName>Adam</FirstName>
<LastName>Harrold</LastName>
<CommonName>Test 2</CommonName>
<MaidenName>Test 2</MaidenName>
<SecondLastName>Test 2</SecondLastName>
<BirthCountry>GBR</BirthCountry>
<BirthCity>London</BirthCity>
<Nationality>GBR</Nationality>
<Suffix>Test 2</Suffix>
<Gender>M</Gender>
<GenderIdentityXrefCode>MALE</GenderIdentityXrefCode>
<SocialSecurityNumber>123123166</SocialSecurityNumber>
<StartDate>2004-01-01</StartDate>
<SeniorityDate>2004-01-01</SeniorityDate>
<CultureCode>en-GB</CultureCode>
<FederationId>c1000</FederationId>
<EmployeeMaritalStatus>
<MaritalStatusXrefCode>DOMESTICPARTNERSHIP</MaritalStatusXrefCode>
<EffectiveStart>2007-07-09</EffectiveStart>
</EmployeeMaritalStatus>
<CANConfidentialInformation>
<RegisteredDisabled>NO</RegisteredDisabled>
<IsVisibleMinority>YES</IsVisibleMinority>
<IsAboriginal>NO</IsAboriginal>
</CANConfidentialInformation>
<USConfidentialInformation>
<Ethnicity>
<EthnicityXrefCode>White (not Hispanic or Latino)</EthnicityXrefCode>
<StartDate>2007-07-09</StartDate>
</Ethnicity>
<VeteranStatus>
<VeteranStatusXrefCode>ArmedForcesServiceMedalVeteran</VeteranStatusXrefCode>
<StartDate>1999-01-01</StartDate>
<EndDate>2020-01-01</EndDate>
</VeteranStatus>
<RegisteredDisabled>NO</RegisteredDisabled>
</USConfidentialInformation>
</Employee>
</EmployeeImport>Next steps
Complete the next wizard, as appropriate.
Personal Data template fields
All templates have the same basic structure:
- Instructions tab: Helps you understand the purpose of the data and complete the fields in the template.
- Data tab: Contains headers for the data to be included in the template. The headers remain the same, but you can change the column order. If you add more columns, Activate ignores them.
All number ranges in the templates include the numbers at both ends of the range.
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 1 | Alphanumeric. Unique value between 1-9 characters. | It allows our system to identify employees uniquely. Use the same number assigned to the employee in the Getting Started HR data loads. | 3241245
000000006 abc123499 |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Title is used for retirement plans (pensions) in the UK and is required for third party processing of pension plans. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 2 | String1 between 1-10 characters. | Title of the employee. | Mr. Mrs. |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Title is used for retirement plans (pensions) in UK and is required for third party processing of pension plans. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 3 | String1 between 1-64 characters. |
Legal first name of the employee. The value provided must match exactly to an existing employee record in Dayforce. |
Joe |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Title is used for retirement plans (pensions) in the UK and is required for third party processing of pension plans. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 4 | String1 between 1-64 characters. | Legal middle name or initial of the employee. | Michael M. |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Title is used for retirement plans (pensions) in UK and is required for third party processing of pension plans. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 5 | String1 between 1-64 characters. |
Legal last name of the employee. The value provided must match exactly to an existing employee record in Dayforce. |
Smith |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Title is used for retirement plans (pensions) in the UK and is required for third party processing of pension plans. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 6 | String1 between 1-10 characters same as employee data screen. | The suffix is an explanation of the first name, not the last name. For instance, “John Doe Jr” that means his first name is “John” and he’s the son of “John.” | Jr Sr II III |
This data is needed to complete the employee’s Legal Name and will be used for reporting on Earning Statements and other Tax Forms. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 7 | String1 between 1-64 characters. | Preferred name of the employee. | Jr Joe |
This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 8 | String1 between 1-64 characters. | Maternal Last Name of the employee if any. | LaForce | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 9 | String1 between 1-64 characters. | Previous Last Name of the employee if any. | Biagini | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 10 | String1. 9 characters |
Social Security number / Social Insurance Number / NINO / PPSN / TFN / IRD / NRIC / FIN or Country Specific Id of the employee. This information is required to generate accurate payroll reporting. It can be left blank if the employee doesn’t have it yet, but this could result in payroll issues. Any leading zeros must be included. Hyphens should be excluded. |
SSN/SIN: NINO: TFN: PPSN: IRD: NRIC: |
This data is needed for accurate reporting of payroll and tax information. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 11 | String1. 3 characters. | Nationality of the employee. | BRA | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 12 |
Accepted Values: See your consultant. |
Citizenship of the employee. |
Example Values: Canadian Citizen
|
This data is needed for some countries. Note: Some values are restricted by country. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 13 | String1 between 1-64 characters. | The employee's birth city. | Toronto | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 14 |
String1 between 1-6 characters. Birth State Accepted Value3 |
The employee's birth state. See below for Valid Birth State accepted value. | CA-ON | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Accepted Values | State Name | Country Name |
|---|---|---|
| AU-ACT | Australian Capital Territory | Australia |
| AU-NSW | New South Wales | Australia |
| AU-NT | Northern Territory | Australia |
| AU-QLD | Queensland | Australia |
| AU-SA | South Australia | Australia |
| AU-TAS | Tasmania | Australia |
| AU-VIC | Victoria | Australia |
| AU-WA | Western Australia | Australia |
| AB | Alberta | Canada |
| BC | British Columbia | Canada |
| MB | Manitoba | Canada |
| NB | New Brunswick | Canada |
| NL | Newfoundland and Labrador | Canada |
| NS | Nova Scotia | Canada |
| NT | Northwest Territories | Canada |
| NU | Nunavut | Canada |
| ON | Ontario | Canada |
| PE | Prince Edward Island | Canada |
| QC | Quebec | Canada |
| SK | Saskatchewan | Canada |
| YT | Yukon | Canada |
| CN-AH | Anhui Sheng | China |
| CN-BJ | Beijing Shi | China |
| CN-CQ | Chongqing Shi | China |
| CN-FJ | Fujian Sheng | China |
| CN-GD | Guangdong Sheng | China |
| CN-GS | Gansu Sheng | China |
| CN-GX | Guangxi Zhuangzu Zizhiqu | China |
| CN-GZ | Guizhou Sheng | China |
| CN-HA | Henan Sheng | China |
| CN-HB | Hubei Sheng | China |
| CN-HE | Hebei Sheng | China |
| CN-HI | Hainan Sheng | China |
| CN-HK | Hong Kong SAR | China |
| CN-HL | Heilongjiang Sheng | China |
| CN-HN | Hunan Sheng | China |
| CN-JL | Jilin Sheng | China |
| CN-JS | Jiangsu Sheng | China |
| CN-JX | Jiangxi Sheng | China |
| CN-LN | Liaoning Sheng | China |
| CN-MO | Macao SAR | China |
| CN-NM | Nei Mongol Zizhiqu | China |
| CN-NX | Ningxia Huizi Zizhiqu | China |
| CN-QH | Qinghai Sheng | China |
| CN-SC | Sichuan Sheng | China |
| CN-SD | Shandong Sheng | China |
| CN-SH | Shanghai Shi | China |
| CN-SN | Shaanxi Sheng | China |
| CN-SX | Shanxi Sheng | China |
| CN-TJ | Tianjin Shi | China |
| CN-TW | Taiwan Sheng | China |
| CN-XJ | Xinjiang Uygur Zizhiqu | China |
| CN-XZ | Xizang Zizhiqu | China |
| CN-YN | Yunnan Sheng | China |
| CN-ZJ | Zhejiang Sheng | China |
| CZ-10 | Praha, Hlavní město | Czech Republic |
| CZ-20 | Středočeský kraj | Czech Republic |
| CZ-201 | Benešov | Czech Republic |
| CZ-202 | Beroun | Czech Republic |
| CZ-203 | Kladno | Czech Republic |
| CZ-204 | Kolín | Czech Republic |
| CZ-205 | Kutná Hora | Czech Republic |
| CZ-206 | Mělník | Czech Republic |
| CZ-207 | Mladá Boleslav | Czech Republic |
| CZ-208 | Nymburk | Czech Republic |
| CZ-209 | Praha-východ | Czech Republic |
| CZ-20A | Praha-západ | Czech Republic |
| CZ-20B | Příbram | Czech Republic |
| CZ-20C | Rakovník | Czech Republic |
| CZ-31 | Jihočeský kraj | Czech Republic |
| CZ-311 | České Budějovice | Czech Republic |
| CZ-312 | Český Krumlov | Czech Republic |
| CZ-313 | Jindřichův Hradec | Czech Republic |
| CZ-314 | Písek | Czech Republic |
| CZ-315 | Prachatice | Czech Republic |
| CZ-316 | Strakonice | Czech Republic |
| CZ-317 | Tábor | Czech Republic |
| CZ-32 | Plzeňský kraj | Czech Republic |
| CZ-321 | Domažlice | Czech Republic |
| CZ-322 | Klatovy | Czech Republic |
| CZ-323 | Plzeň-město | Czech Republic |
| CZ-324 | Plzeň-jih | Czech Republic |
| CZ-325 | Plzeň-sever | Czech Republic |
| CZ-326 | Rokycany | Czech Republic |
| CZ-327 | Tachov | Czech Republic |
| CZ-41 | Karlovarský kraj | Czech Republic |
| CZ-411 | Cheb | Czech Republic |
| CZ-412 | Karlovy Vary | Czech Republic |
| CZ-413 | Sokolov | Czech Republic |
| CZ-42 | Ústecký kraj | Czech Republic |
| CZ-421 | Děčín | Czech Republic |
| CZ-422 | Chomutov | Czech Republic |
| CZ-423 | Litoměřice | Czech Republic |
| CZ-424 | Louny | Czech Republic |
| CZ-425 | Most | Czech Republic |
| CZ-426 | Teplice | Czech Republic |
| CZ-427 | Ústí nad Labem | Czech Republic |
| CZ-51 | Liberecký kraj | Czech Republic |
| CZ-511 | Česká Lípa | Czech Republic |
| CZ-512 | Jablonec nad Nisou | Czech Republic |
| CZ-513 | Liberec | Czech Republic |
| CZ-514 | Semily | Czech Republic |
| CZ-52 | Královéhradecký kraj | Czech Republic |
| CZ-521 | Hradec Králové | Czech Republic |
| CZ-522 | Jičín | Czech Republic |
| CZ-523 | Náchod | Czech Republic |
| CZ-524 | Rychnov nad Kněžnou | Czech Republic |
| CZ-525 | Trutnov | Czech Republic |
| CZ-53 | Pardubický kraj | Czech Republic |
| CZ-531 | Chrudim | Czech Republic |
| CZ-532 | Pardubice | Czech Republic |
| CZ-533 | Svitavy | Czech Republic |
| CZ-534 | Ústí nad Orlicí | Czech Republic |
| CZ-63 | Kraj Vysočina | Czech Republic |
| CZ-631 | Havlíčkův Brod | Czech Republic |
| CZ-632 | Jihlava | Czech Republic |
| CZ-633 | Pelhřimov | Czech Republic |
| CZ-634 | Třebíč | Czech Republic |
| CZ-635 | Žďár nad Sázavou | Czech Republic |
| CZ-64 | Jihomoravský kraj | Czech Republic |
| CZ-641 | Blansko | Czech Republic |
| CZ-642 | Brno-město | Czech Republic |
| CZ-643 | Brno-venkov | Czech Republic |
| CZ-644 | Břeclav | Czech Republic |
| CZ-645 | Hodonín | Czech Republic |
| CZ-646 | Vyškov | Czech Republic |
| CZ-647 | Znojmo | Czech Republic |
| CZ-71 | Olomoucký kraj | Czech Republic |
| CZ-711 | Jeseník | Czech Republic |
| CZ-712 | Olomouc | Czech Republic |
| CZ-713 | Prostějov | Czech Republic |
| CZ-714 | Přerov | Czech Republic |
| CZ-715 | Šumperk | Czech Republic |
| CZ-72 | Zlínský kraj | Czech Republic |
| CZ-721 | Kroměříž | Czech Republic |
| CZ-722 | Uherské Hradiště | Czech Republic |
| CZ-723 | Vsetín | Czech Republic |
| CZ-724 | Zlín | Czech Republic |
| CZ-80 | Moravskoslezský kraj | Czech Republic |
| CZ-801 | Bruntál | Czech Republic |
| CZ-802 | Frýdek-Místek | Czech Republic |
| CZ-803 | Karviná | Czech Republic |
| CZ-804 | Nový Jičín | Czech Republic |
| CZ-805 | Opava | Czech Republic |
| CZ-806 | Ostrava-město | Czech Republic |
| DE-BB | Brandenburg | Germany |
| DE-BE | Berlin | Germany |
| DE-BW | Baden-Württemberg | Germany |
| DE-BY | Bayern | Germany |
| DE-HB | Bremen | Germany |
| DE-HE | Hessen | Germany |
| DE-HH | Hamburg | Germany |
| DE-MV | Mecklenburg-Vorpommern | Germany |
| DE-NI | Niedersachsen | Germany |
| DE-NW | Nordrhein-Westfalen | Germany |
| DE-RP | Rheinland-Pfalz | Germany |
| DE-SH | Schleswig-Holstein | German |
| DE-SL | Saarland | Germany |
| DE-SN | Sachsen | Germany |
| DE-ST | Sachsen-Anhalt | Germany |
| DE-TH | Thüringen | Germany |
| IN-AN | Andaman and Nicobar Islands | India |
| IN-AP | Andhra Pradesh | India |
| IN-AR | Arunachal Pradesh | India |
| IN-AS | Assam | India |
| IN-BR | Bihar | India |
| IN-CH | Chandigarh | India |
| IN-CT | Chhattisgarh | India |
| IN-DD | Daman and Diu | India |
| IN-DL | Delhi | India |
| IN-DN | Dadra and Nagar Haveli | India |
| IN-GA | Goa | India |
| IN-GJ | Gujarat | India |
| IN-HP | Himachal Pradesh | India |
| IN-HR | Haryana | India |
| IN-JH | Jharkhand | India |
| IN-JK | Jammu and Kashmir | India |
| IN-KA | Karnataka | India |
| IN-KL | Kerala | India |
| IN-LA | Ladakh | India |
| IN-LD | Lakshadweep | India |
| IN-MH | Maharashtra | India |
| IN-ML | Meghalaya | India |
| IN-MN | Manipur | India |
| IN-MP | Madhya Pradesh | India |
| IN-MZ | Mizoram | India |
| IN-NL | Nagaland | India |
| IN-OR | Orissa | India |
| IN-PB | Punjab | India |
| IN-PY | Pondicherry | India |
| IN-RJ | Rajasthan | India |
| IN-SK | Sikkim | India |
| IN-TG | Telangana | India |
| IN-TN | Tamil Nadu | India |
| IN-TR | Tripura | India |
| IN-UP | Uttar Pradesh | India |
| IN-UT | Uttarakhand | India |
| IN-WB | West Bengal | India |
| N/A | State is not required | Ireland |
| IT-21 | Piemonte | Italy |
| IT-23 | Valle d'Aosta | Italy |
| IT-25 | Lombardia | Italy |
| IT-32 | Trentino-Alte Adige | Italy |
| IT-34 | Veneto | Italy |
| IT-36 | Friuli-Venezia Giulia | Italy |
| IT-42 | Liguria | Italy |
| IT-45 | Emilia-Romagna | Italy |
| IT-52 | Toscana | Italy |
| IT-55 | Umbria | Italy |
| IT-57 | Marche | Italy |
| IT-62 | Lazio | Italy |
| IT-65 | Abruzzo | Italy |
| IT-67 | Molise | Italy |
| IT-72 | Campania | Italy |
| IT-75 | Puglia | Italy |
| IT-77 | Basilicata | Italy |
| IT-78 | Calabria | Italy |
| IT-82 | Sicilia | Italy |
| IT-88 | Sardegna | Italy |
| IT-AG | Agrigento | Italy |
| IT-AL | Alessandria | Italy |
| IT-AN | Ancona | Italy |
| IT-AP | Ascoli Piceno | Italy |
| IT-AQ | LAquila | Italy |
| IT-AR | Arezzo | Italy |
| IT-AT | Asti | Italy |
| IT-AV | Avellino | Italy |
| IT-BA | Bari | Italy |
| IT-BG | Bergamo | Italy |
| IT-BI | Biella | Italy |
| IT-BL | Belluno | Italy |
| IT-BN | Benevento | Italy |
| IT-BO | Bologna | Italy |
| IT-BR | Brindisi | Italy |
| IT-BS | Brescia | Italy |
| IT-BT | Barletta-Andria-Trani | Italy |
| IT-BZ | Bolzano | Italy |
| IT-CA | Cagliari | Italy |
| IT-CB | Campobasso | Italy |
| IT-CE | Caserta | Italy |
| IT-CH | Chieti | Italy |
| IT-CL | Caltanissetta | Italy |
| IT-CN | Cuneo | Italy |
| IT-CO | Como | Italy |
| IT-CR | Cremona | Italy |
| IT-CS | Cosenza | Italy |
| IT-CT | Catania | Italy |
| IT-CZ | Catanzaro | Italy |
| IT-EN | Enna | Italy |
| IT-FC | Forlì-Cesena | Italy |
| IT-FE | Ferrara | Italy |
| IT-FG | Foggia | Italy |
| IT-FI | Firenze | Italy |
| IT-FM | Fermo | Italy |
| IT-FR | Frosinone | Italy |
| IT-GE | Genova | Italy |
| IT-GO | Gorizia | Italy |
| IT-GR | Grosseto | Italy |
| IT-IM | Imperia | Italy |
| IT-IS | Isernia | Italy |
| IT-KR | Crotone | Italy |
| IT-LC | Lecco | Italy |
| IT-LE | Lecce | Italy |
| IT-LI | Livorno | Italy |
| IT-LO | Lodi | Italy |
| IT-LT | Latina | Italy |
| IT-LU | Lucca | Italy |
| IT-MB | Monza e Brianza | Italy |
| IT-MC | Macerata | Italy |
| IT-ME | Mesaina | Italy |
| IT-MI | Milano | Italy |
| IT-MN | Mantova | Italy |
| IT-MO | Modena | Italy |
| IT-MS | Massa | Italy |
| IT-MT | Matera | Italy |
| IT-NA | Napoli | Italy |
| IT-NO | Novara | Italy |
| IT-NU | Nuoro | Italy |
| IT-OR | Oristano | Italy |
| IT-PA | Palermo | Italy |
| IT-PC | Piacenza | Italy |
| IT-PD | Padova | Italy |
| IT-PE | Pescara | Italy |
| IT-PG | Perugia | Italy |
| IT-PI | Pisa | Italy |
| IT-PN | Pordenone | Italy |
| IT-PO | Prato | Italy |
| IT-PR | Parma | Italy |
| IT-PT | Pistoia | Italy |
| IT-PU | Pesaro e Urbino | Italy |
| IT-PV | Pavia | Italy |
| IT-PZ | Potenza | Italy |
| IT-RA | Ravenna | Italy |
| IT-RC | Reggio Calabria | Italy |
| IT-RE | Reggio Emilia | Italy |
| IT-RG | Ragusa | Italy |
| IT-RI | Rieti | Italy |
| IT-RM | Roma | Italy |
| IT-RN | Rimini | Italy |
| IT-RO | Rovigo | Italy |
| IT-SA | Salerno | Italy |
| IT-SD | Sud Sardegna | Italy |
| IT-SI | Siena | Italy |
| IT-SO | Sondrio | Italy |
| IT-SP | LaSpezia | Italy |
| IT-SR | Siracusa | Italy |
| IT-SS | Sassari | Italy |
| IT-SV | Savona | Italy |
| IT-TA | Taranto | Italy |
| IT-TE | Teramo | Italy |
| IT-TN | Trento | Italy |
| IT-TO | Torino | Italy |
| IT-TP | Trapani | Italy |
| IT-TR | Terni | Italy |
| IT-TS | Trieste | Italy |
| IT-TV | Treviso | Italy |
| IT-UD | Udine | Italy |
| IT-VA | Varese | Italy |
| IT-VB | Verbano-Cusio-Ossola | Italy |
| IT-VC | Vercelli | Italy |
| IT-VE | Venezia | Italy |
| IT-VI | Vicenza | Italy |
| IT-VR | Verona | Italy |
| IT-VT | Viterbo | Italy |
| IT-VV | Viterbo | Italy |
| IT-W | Vibo Valentia | Italy |
| JP-01 | Hokkaidô | Japan |
| JP-02 | Aomori | Japan |
| JP-03 | Iwate | Japan |
| JP-04 | Miyagi | Japan |
| JP-05 | Akita | Japan |
| JP-06 | Yamagata | Japan |
| JP-07 | Hukusima | Japan |
| JP-08 | Ibaraki | Japan |
| JP-09 | Totigi | Japan |
| JP-10 | Gunma | Japan |
| JP-11 | Saitama | Japan |
| JP-12 | Tiba | Japan |
| JP-13 | Tôkyô | Japan |
| JP-14 | Kanagawa | Japan |
| JP-15 | Niigata | Japan |
| JP-16 | Toyama | Japan |
| JP-17 | Isikawa | Japan |
| JP-18 | Hukui | Japan |
| JP-19 | Yamanasi | Japan |
| JP-20 | Nagano | Japan |
| JP-21 | Gihu | Japan |
| JP-22 | Sizuoka | Japan |
| JP-23 | Aiti | Japan |
| JP-24 | Mie | Japan |
| JP-25 | Siga | Japan |
| JP-26 | Kyôto | Japan |
| JP-27 | Ôsaka | Japan |
| JP-28 | Hyôgo | Japan |
| JP-29 | Nara | Japan |
| JP-30 | Wakayama | Japan |
| JP-31 | Tottori | Japan |
| JP-33 | Okayama | Japan |
| JP-34 | Hirosima | Japan |
| JP-35 | Yamaguti | Japan |
| JP-36 | Tokusima | Japan |
| JP-37 | Kagawa | Japan |
| JP-38 | Ehime | Japan |
| JP-39 | Kôti | Japan |
| JP-40 | Hukuoka | Japan |
| JP-41 | Saga | Japan |
| JP-42 | Nagasaki | Japan |
| JP-43 | Kumamoto | Japan |
| JP-44 | Ôita | Japan |
| JP-45 | Miyazaki | Japan |
| JP-46 | Kagosima | Japan |
| JP-47 | Okinawa | Japan |
| KR-11 | Seoul Teugbyeolsi | Korea |
| KR-26 | Busan Gwang'yeogsi | Korea |
| KR-27 | Daegu Gwang'yeogsi | Korea |
| KR-28 | Incheon Gwang'yeogsi | Korea |
| KR-29 | Gwangju Gwang'yeogsi | Korea |
| KR-30 | Daejeon Gwang'yeogsi | Korea |
| KR-31 | Ulsan Gwang'yeogsi | Korea |
| KR-41 | Gyeonggido | Korea |
| KR-42 | Gang'weondo | Korea |
| KR-43 | Chungcheongbugdo | Korea |
| KR-44 | Chungcheongnamdo | Korea |
| KR-45 | Jeonrabugdo | Korea |
| KR-46 | Jeonranamdo | Korea |
| KR-47 | Gyeongsangbugdo | Korea |
| KR-48 | Gyeongsangnamdo | Korea |
| KR-49 | Jejudo | Korea |
| KR-50 | Sejong | Korea |
| MX-AGU | Aguascalientes | Mexico |
| MX-BCN | Baja California | Mexico |
| MX-BCS | Baja California Sur | Mexico |
| MX-CAM | Campeche | Mexico |
| MX-CHH | Chihuahua | Mexico |
| MX-CHP | Chiapas | Mexico |
| MX-CMX | Ciudad de México | Mexico |
| MX-COA | Coahuila | Mexico |
| MX-COL | Colima | Mexico |
| MX-DUR | Durango | Mexico |
| MX-GRO | Guerrero | Mexico |
| MX-GUA | Guanajuato | Mexico |
| MX-HID | Hidalgo | Mexico |
| MX-JAL | Jalisco | Mexico |
| MX-MEX | México | Mexico |
| MX-MIC | Michoacán | Mexico |
| MX-MOR | Morelos | Mexico |
| MX-NAY | Nayarit | Mexico |
| MX-NLE | Nuevo León | Mexico |
| MX-OAX | Oaxaca | Mexico |
| MX-PUE | Puebla | Mexico |
| MX-QUE | Queretaro | Mexico |
| MX-ROO | Quintana Roo | Mexico |
| MX-SIN | Sinaloa | Mexico |
| MX-SLP | San Luis Potosí | Mexico |
| MX-SON | Sonora | Mexico |
| MX-TAB | Tabasco | Mexico |
| MX-TAM | Tamaulipas | Mexico |
| MX-TLA | Tlaxcala | Mexico |
| MX-VER | Veracruz | Mexico |
| MX-YUC | Yucatán | Mexico |
| MX-ZAC | Zacatecas | Mexico |
| NL-AW | Aruba | Netherlands |
| NL-BQ1 | Bonaire | Netherlands |
| NL-BQ2 | Sabaragamuwa Province | Netherlands |
| NL-BQ3 | Sint Eustatius | Netherlands |
| NL-CW | Curaçao | Netherlands |
| NL-DR | Drenthe | Netherlands |
| NL-FL | Flevoland | Netherlands |
| NL-FR | Friesland | Netherlands |
| NL-GE | Gelderland | Netherlands |
| NL-GR | Groningen | Netherlands |
| NL-LI | Limburg | Netherlands |
| NL-NB | Noord-Brabant | Netherlands |
| NL-NH | Noord-Holland | Netherlands |
| NL-OV | Overijssel | Netherlands |
| NL-SX | Sint Maarten | Netherlands |
| NL-UT | Utrecht | Netherlands |
| NL-ZE | Zeeland | Netherlands |
| NL-ZH | Zuid-Holland | Netherlands |
| NZ-AUK | Auckland | New Zealand |
| NZ-BOP | Bay of Plenty | New Zealand |
| NZ-CAN | Canterbury | New Zealand |
| NZ-CIT | Chatham Islands Territory | New Zealand |
| NZ-GIS | Gisborne | New Zealand |
| NZ-HKB | Hawke's Bay | New Zealand |
| NZ-MBH | Marlborough | New Zealand |
| NZ-MWT | Manawatu-Wanganui | New Zealand |
| NZ-NSN | Nelson | New Zealand |
| NZ-NTL | Northland | New Zealand |
| NZ-OTA | Otago | New Zealand |
| NZ-STL | Southland | New Zealand |
| NZ-TAS | Tasman | New Zealand |
| NZ-TKI | Taranaki | New Zealand |
| NZ-WGN | Wellington | New Zealand |
| NZ-WKO | Waikato | New Zealand |
| NZ-WTC | West Coast | New Zealand |
| PL-02 | Dolnośląskie | Poland |
| PL-04 | Kujawsko-pomorskie | Poland |
| PL-06 | Lubelskie | Poland |
| PL-08 | Lubuskie | Poland |
| PL-10 | Łódzkie | Poland |
| PL-12 | Małopolskie | Poland |
| PL-14 | Mazowieckie | Poland |
| PL-16 | Opolskie | Poland |
| PL-18 | Podkarpackie | Poland |
| PL-20 | Podlaskie | Poland |
| PL-22 | Pomorskie | Poland |
| PL-24 | Śląskie | Poland |
| PL-26 | Świętokrzyskie | Poland |
| PL-28 | Warmińsko-mazurskie | Poland |
| PL-30 | Wielkopolskie | Poland |
| PL-32 | Zachodniopomorskie | Poland |
| N/A | State is not required. | United Kingdom |
| AA | Armed Forces America | United States of America |
| AE | Armed Forces | United States of America |
| AK | Alaska | United States of America |
|
AL |
Alabama |
United States of America |
| AP | Armed Forces Pacific | United States of America |
| AR | Arkansas | United States of America |
| AS | American Samoa | United States of America |
| AZ | Arizona | United States of America |
| CA | California | United States of America |
| CO | Colorado | United States of America |
| CT | Connecticut | United States of America |
| DC | District Of Columbia | United States of America |
| DE | Delaware | United States of America |
| FL | Florida | United States of America |
| FM | Federated States of Micronesia | United States of America |
| GA | Georgia | United States of America |
| GU | Guam | United States of America |
| HI | Hawaii | United States of America |
| IA | Iowa | United States of America |
| ID | Idaho | United States of America |
| IL | Illinois | United States of America |
| IN | Indiana | United States of America |
| KS | Kansas | United States of America |
| KY | Kentucky | United States of America |
| LA | Louisiana | United States of America |
| MA | Massachusetts | United States of America |
| MD | Maryland | United States of America |
| ME | Maine | United States of America |
| MH | Marshall Islands | United States of America |
| MI | Michigan | United States of America |
| MN | Minnesota | United States of America |
| MO | Missouri | United States of America |
| MP | Northern Mariana Islands | United States of America |
| MS | Mississippi | United States of America |
| MT | Montana | United States of America |
| NC | North Carolina | United States of America |
| ND | North Dakota | United States of America |
| NE | Nebraska | United States of America |
| NH | New Hampshire | United States of America |
| NJ | New Jersey | United States of America |
| NM | New Mexico | United States of America |
| NV | Nevada | United States of America |
| NY | New York | United States of America |
| OH | Ohio | United States of America |
| OK | Oklahoma | United States of America |
| OR | Oregon | United States of America |
| PA | Pennsylvania | United States of America |
| PR | Puerto Rico | United States of America |
| PW | Palau | United States of America |
| RI | Rhode Island | United States of America |
| SC | South Carolina | United States of America |
| SD | South Dakota | United States of America |
| TN | Tennessee | United States of America |
| TX | Texas | United States of America |
| UT | Utah | United States of America |
| VA | Virginia | United States of America |
| VI | Virgin Islands | United States of America |
| VT | Vermont | United States of America |
| WA | Washington | United States of America |
| WI | Wisconsin | United States of America |
| WV | West Virginia | United States of America |
| WY | Wyoming | United States of America |
| SG-01 | Central Singapore | Singapore |
| SG-02 | North East | Singapore |
| SG-03 | North West | Singapore |
| SG-04 | South East | Singapore |
| SG-05 | South West | Singapore |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 15 |
String1 between 1-3 characters. Accepted Values: AUS
|
The employee’s birth country. |
CAN | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
2 Accepted values for non-native countries (for example, countries not supported in Payroll) must match the following list:
| Accepted Values | Country Name |
|---|---|
| ARG | Argentina |
| AFG | Afghanistan |
| ALA | Aland Islands |
| ALB | Albania |
| DZA | Algeria |
| ASM | American Samoa |
| AND | Andorra |
| AGO | Angola |
| AIA | Anguilla |
| ATA | Antarctica |
| ATG | Antigua and Barbuda |
| ARM | Armenia |
| ABW | Aruba |
| AUS | Australia |
| AUT | Austria |
| AZE | Azerbaijan |
| BHS | Bahamas (The) |
| BHR | Bahrain |
| BGD | Bangladesh |
| BRB | Barbados |
| BLR | Belarus |
| BEL | Belgium |
| BLZ | Belize |
| BEN | Benin |
| BMU | Bermuda |
| BTN | Bhutan |
| BOL | Bolivia (Plurinational State of) |
| BES | Bonaire, Sint Eustatius and Saba |
| BIH | Bosnia and Herzegovina |
| BWA | Botswana |
| BVT | Bouvet Island |
| BRA | Brazil |
| IOT | British Indian Ocean Territory (The) |
| BRN | Brunei Darussalam |
| BGR | Bulgaria |
| BFA | Burkina Faso |
| BDI | Burundi |
| CPV | Cabo Verde |
| KHM | Cambodia |
| CMR | Cameroon |
| CAN | Canada |
| CYM | Cayman Islands (The) |
| CAF | Central African Republic (The) |
| TCD | Chad |
| CHL | Chile |
| CHN | China |
| CXR | Christmas Island |
| CCK | Cocos (Keeling) Islands (The) |
| COL | Colombia |
| COM | Comoros (The) |
| COD | Congo (the Democratic Republic of the) |
| COG | Congo (The) |
| COK | Cook Islands (The) |
| CRI | Costa Rica |
| CIV | Côte d'Ivoire |
| HRV | Croatia |
| CUB | Cuba |
| CUW | Curaçao |
| CYP | Cyprus |
| CZE | Czech Republic |
| DNK | Denmark |
| DJI | Djibouti |
| DMA | Dominica |
| DOM | Dominican Republic (The) |
| ECU | Ecuador |
| EGY | Egypt |
| SLV | El Salvador |
| GNQ | Equatorial Guinea |
| ERI | Eritrea |
| EST | Estonia |
| SWZ | Eswatini |
| ETH | Ethiopia |
| FLK | Falkland Islands (The) [Malvinas] |
| FRO | Faroe Islands (The) |
| FJI | Fiji |
| FIN | Finland |
| FRA | France |
| GUF | French Guiana |
| PYF | French Polynesia |
| ATF | French Southern Territories (The) |
| GAB | Gabon |
| GMB | Gambia (The) |
| GEO | Georgia |
| DEU | Germany |
| GHA | Ghana |
| GIB | Gibraltar |
| GRC | Greece |
| GRL | Greenland |
| GRD | Grenada |
| GLP | Guadeloupe |
| GUM | Guam |
| GTM | Guatemala |
| GGY | Guernsey |
| GIN | Guinea |
| GNB | Guinea-Bissau |
| GUY | Guyana |
| HTI | Haiti |
| HMD | Heard Island and McDonald Islands |
| VAT | Holy See (The) |
| HND | Honduras |
| HKG | Hong Kong |
| HUN | Hungary |
| ISL | Iceland |
| IND | India |
| IDN | Indonesia |
| IRN | Iran (Islamic Republic of) |
| IRQ | Iraq |
| IRL | Ireland |
| IMN | Isle of Man |
| ISR | Israel |
| ITA | Italy |
| JAM | Jamaica |
| JPN | Japan |
| JEY | Jersey |
| JOR | Jordan |
| KAZ | Kazakhstan |
| KEN | Kenya |
| KIR | Kiribati |
| KOR | Korea |
| PRK | Korea (the Democratic People's Republic of) |
| KWT | Kuwait |
| KGZ | Kyrgyzstan |
| LAO | Lao People's Democratic Republic (The) |
| LVA | Latvia |
| LBN | Lebanon |
| LSO | Lesotho |
| LBR | Liberia |
| LBY | Libya |
| LIE | Liechtenstein |
| LTU | Lithuania |
| LUX | Luxembourg |
| MAC | Macao |
| MDG | Madagascar |
| MWI | Malawi |
| MYS | Malaysia |
| MDV | Maldives |
| MLI | Mali |
| MLT | Malta |
| MHL | Marshall Islands (The) |
| MTQ | Martinique |
| MRT | Mauritania |
| MUS | Mauritius |
| MYT | Mayotte |
| MEX | Mexico |
| FSM | Micronesia (Federated States of) |
| MDA | Moldova (the Republic of) |
| MCO | Monaco |
| MNG | Mongolia |
| MNE | Montenegro |
| MSR | Montserrat |
| MAR | Morocco |
| MOZ | Mozambique |
| MMR | Myanmar |
| NAM | Namibia |
| NRU | Nauru |
| NPL | Nepal |
| NLD | Netherlands |
| NCL | New Caledonia |
| NZL | New Zealand |
| NIC | Nicaragua |
| NER | Niger (The) |
| NGA | Nigeria |
| NIU | Niue |
| NFK | Norfolk Island |
| MKD | North Macedonia |
| MNP | Northern Mariana Islands (The) |
| NOR | Norway |
| OMN | Oman |
| PAK | Pakistan |
| PLW | Palau |
| PSE | Palestine, State of |
| PAN | Panama |
| PNG | Papua New Guinea |
| PRY | Paraguay |
| PER | Peru |
| PHL | Philippines |
| PCN | Pitcairn |
| POL | Poland |
| PRT | Portugal |
| PRI | Puerto Rico |
| QAT | Qatar |
| REU | Réunion |
| ROU | Romania |
| RUS | Russian Federation (The) |
| RWA | Rwanda |
| BLM | Saint Barthélemy |
| SHN | Saint Helena, Ascension and Tristan da Cunha |
| KNA | Saint Kitts and Nevis |
| LCA | Saint Lucia |
| MAF | Saint Martin (French part) |
| SPM | Saint Pierre and Miquelon |
| VCT | Saint Vincent and the Grenadines |
| WSM | Samoa |
| SMR | San Marino |
| STP | Sao Tome and Principe |
| SAU | Saudi Arabia |
| SEN | Senegal |
| SRB | Serbia |
| SYC | Seychelles |
| SLE | Sierra Leone |
| SXM | Sint Maarten (Dutch part) |
| SVK | Slovakia |
| SVN | Slovenia |
| SLB | Solomon Islands |
| SOM | Somalia |
| ZAF | South Africa |
| SGS | South Georgia and the South Sandwich Islands |
| SSD | South Sudan |
| ESP | Spain |
| LKA | Sri Lanka |
| SDN | Sudan (The) |
| SUR | Suriname |
| SJM | Svalbard and Jan Mayen |
| SWE | Sweden |
| CHE | Switzerland |
| SYR | Syrian Arab Republic (The) |
| TWN | Taiwan |
| TJK | Tajikistan |
| TZA | Tanzania, the United Republic of |
| THA | Thailand |
| TLS | Timor-Leste |
| TGO | Togo |
| TKL | Tokelau |
| TON | Tonga |
| TTO | Trinidad and Tobago |
| TUN | Tunisia |
| TUR | Turkey |
| TKM | Turkmenistan |
| TCA | Turks and Caicos Islands (The) |
| TUV | Tuvalu |
| ARE | UAE |
| UGA | Uganda |
| UKR | Ukraine |
| GBR | United Kingdom |
| UMI | United States Minor Outlying Islands (The) |
| USA | United States of America |
| URY | Uruguay |
| UZB | Uzbekistan |
| VUT | Vanuatu |
| VEN | Venezuela (Bolivarian Republic of) |
| VNM | Vietnam |
| VGB | Virgin Islands (British) |
| VIR | Virgin Islands (U.S.) |
| WLF | Wallis and Futuna |
| ESH | Western Sahara* |
| YEM | Yemen |
| ZMB | Zambia |
| ZWE | Zimbabwe |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 16 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. |
Indicate the date when a temporary Social Insurance Number expires. Only temporary SINs (starting with a 9) require this field to be populated. This field can’t be populated for permanent SINs. Applies to Canadian employees only. |
Date formatted cells: 09/24/2015
Text formatted cells: 2015-09-24 |
This date is used when a Social Insurance Number begins with a "9" and has been issued to a temporary worker who isn’t a Canadian citizen nor is a permanent resident of Canada. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 17 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Indicate the employee's seniority date |
Date formatted cells: 09/24/2015
Text formatted cells: 2015-09-24 |
This date allows the assignment of a policy or benefit based on the earliest date the employee was eligible to participate. It assumes that this date is earlier than the Hire or Rehire date. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 18 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Indicates an employee's start date or return to work |
Date formatted cells:
09/24/2015
Text formatted cells: 2015-09-24 |
First Day Worked is used to populate a field of the same name as part of the Canadian Record of Employment details when an employee has had a break-in earnings requiring reporting. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 19 |
Accepted Values: See your consultant. |
Assigned Sex is the legal sex of an employee. |
Example Values: M
|
This value is used by Dayforce for any external legal or governmental purposes, such as Equal Opportunity reporting, Payroll, Benefits and other areas. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 20 |
Accepted Values: See your consultant. |
Identify the employee's gender based on the Gender Identities defined in Dayforce. |
Example Values: M
|
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 21 |
Accepted Values: Hispanic or Latino
|
Identify the employee's ethnicity. |
Accepted Values: Hispanic or Latino
|
This data is used for EEOC-1 Reporting. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 22 |
Accepted Values:
See your consultant. |
Identify the employee's religion. |
Example Values: Christianity
|
This data is mandatory for Singapore Native Payroll |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 23 |
Accepted Values:
LegallySeparated
DomesticPartnership
SameSexPartnership
CivilUnion
|
Identify the employee's marital status. |
Accepted Values: LegallySeparated
|
This data is used for human resource and benefit reporting. It can be used to determine eligibility for various benefit plans. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 24 |
Accepted Values:
PreferNotToSay
|
Identify the employee's disability status. |
Accepted Values: PreferNotToSay
|
This data is used for human resource and benefit reporting. It can be used to determine eligibility for various benefit plans. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 25 |
Accepted Values: SpecialVeteransDisabled ArmedForcesServiceMedalVeteran RecentlySeparatedVeteran ActiveWartimeCampaignBadgeVeteran ProtectedVeteranChooseToNotSelfID NotAProtectedVeteran |
Identify the employee's veteran status. |
Accepted Values: SpecialVeteransDisabled ArmedForcesServiceMedalVeteran RecentlySeparatedVeteran ActiveWartimeCampaignBadgeVeteran ProtectedVeteranChooseToNotSelfID NotAProtectedVeteran |
This data is required if you’re an employer required to file the Federal Contractor Veterans' Employment Report VETS-4212. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 26 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Identify the effective start date of the employee's veteran status. |
Date formatted cells:
09/24/2015
Text formatted cells: 2015-09-24 |
This date identifies when the current Veteran Status was effective. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 27 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Identify the end date of the employee's veteran status. |
Date formatted cells: 09/24/2015
Text formatted cells: 2015-09-24 |
This date identifies when the current Veteran Status is no longer effective and the employee changes to a different Veteran Status. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 28 |
Accepted Values:
PreferNotToSay
|
Identify an employee who has a visible minority status. |
Accepted Values: PreferNotToSay
|
This data is defined in Canadian law by the Employment Equity Act. It requires employers to engage in proactive employment practices to increase the representation of four designated groups: women, people with disabilities, Aboriginal peoples, and visible minorities. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 29 |
Accepted Values: PreferNotToSay
|
Identify an employee who is a member of the Aboriginal Peoples of Canada. |
Accepted Values:
PreferNotToSay
|
This data is defined in Canadian law by the Employment Equity Act and requires employers to engage in proactive employment practices to increase the representation of four designated groups: women, people with disabilities, Aboriginal peoples, and visible minorities. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 30 | String between 1-128 characters. | Maps to the employee’s credentials as the cross-reference to the Claims Identity. | Used to identify a user within a customer’s Single Sign on configuration. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 31 | String1 between 1-12 characters. | Preferred language of the employee if any. | en-US | This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &