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.
If you have an existing pay group for Australia and employees located in Australia who don’t have a record for their Tax File Number (TFN), you can use this wizard to load Tax File Numbers for those employees. Activate verifies that the TFNs are exactly 9 characters in length and meet the requirements of the Australian Taxation Office.
The following TFN codes are for employees in specific circumstances.
| Use this TFN... | When... |
|---|---|
| 000000000 | The payee hasn't provided a TFN or fails to provide one within 14 days. |
| 111111111 | A payee doesn't provide a valid TFN or you receive a declaration from the payee that says that they have applied for a TFN. This code should be updated with the payee’s TFN, or, with the no TFN quoted code when the payee fails to provide the TFN to the payer within the 28-day period allowed. |
| 333333333 | A payee is under 18 years old and claims the general exemption because they don't earn enough for tax to be deducted. If circumstances change and the payee subsequently earns a level of income that attracts tax, a TFN will be required to be provided at that time. |
| 444444444 | The payee is a recipient of a social security or service pension or benefit (other than Newstart, sickness allowance, special benefits or partner allowance) and an exemption from quoting a TFN may be claimed. |
You can find employee TFN information on the Dayforce People > Personal > Confidential Information page, in the Identification section.
Note: The special TFN codes in the table above can apply to multiple employees. When the National ID field is populated in the Employee Personal Data template with one of these special codes for an Australian employee, Activate bypasses the validation to check if the National ID matches that of another employee in Dayforce. The validation to check if the National ID value exists against multiple employees in the current Personal Data template does remain in place because the HR Import doesn’t currently support this scenario.
Before you begin
Employees being provided in the Employee Personal Data 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.
Messages: Error, Warning, and Information
Activate sorts each generated message by severity:
Actively incompatible with the data in Dayforce. If you have a data error, you must resolve the error before you can complete the installation.
Indicate nonstandard setup that could potentially cause an error in Dayforce. For example, if an earning code is defined as Hours x Rate and the data is amount only, the system creates a warning. However, you can still import the data into the system.
A notable occurrence of data in the system. For example, an informational note shows if codes are dropped from the YTD import.
Tasks
- In Activate Central, click Load Your Data and the Load Your Data wizards are shown.
- Click one of the following:
- Employee HR Data Hub and then click Employee Personal Data.
- 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.
The file names of templates that you download from Activate begin with a prefix that is the Namespace that you’re logged in to. The same is true for the file names of ZIP files when you download multiple templates at the same time.
- 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 Employee 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. Them. it shows a warning 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) also shows.
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 inDayforce, go to People > Personal > Confidential Information.
For Canada and the United States, when the Personal Data template includes values in the Assigned Sex and/or the Gender Identity fields, Activate creates a federal employee gender record. If the fields contain non-binary values, a warning shows and no federal employee gender record is created.
Note: To comply with regional tax regulations, the TaxPayerID is generated only for employees with an Employment Type of Contractor who are based in the United States.
The data uploaded from the Employee Personal Data template populates the fields on the following pages inDayforce.
Note: You must select an employee if you haven’t already done so.
Note: Fields 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 | 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>
<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>
<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>
<EmployeeGender>
<CountryCode>USA</CountryCode>
<StateCode>NY</StateCode>
<AssignedSexXrefCode>M</AssignedSexXrefCode>
<GenderIdentityXrefCode>MALE</GenderIdentityXrefCode>
</EmployeeGender>
</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>
<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>
<EmployeeGender>
<CountryCode>GBR</CountryCode>
<AssignedSexXrefCode>M</AssignedSexXrefCode>
<GenderIdentityXrefCode>MALE</GenderIdentityXrefCode>
</EmployeeGender>
</Employee>
</EmployeeImport>Note: When Activate generates the EmployeeGender element, the EffecitveStart date is set to the current date (the date of generation).
Next steps
Complete the next wizard, as appropriate.
Employee 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. |
This identifier enables the system to identify employees uniquely. Use the same number assigned to the employee in the Getting Started HR data loads. Note: Upon upload of the template data, Activate converts any lowercase alpha characters found in the Employee Identifier field to uppercase. |
3241245
000000006 abc123499 |
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 inDayforce. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 2 | String1 between 1–10 characters. | The title of the employee. | Mr. Mrs. |
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 inDayforce. |
1 Special characters accepted in 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. |
The legal first name of the employee. The value provided must match exactly to an existing employee record inDayforce. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data. |
Joe |
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 inDayforce. |
1 Special characters accepted in 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. | The legal middle name or initial of the employee. | Michael M. |
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 inDayforce. |
1 Special characters accepted in 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. |
The legal last name of the employee. The value provided must match exactly to an existing employee record inDayforce. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data. |
Smith |
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 in 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. The same as the Employee Data page. | The suffix is an explanation of the first name, not the last name. For instance, “John Doe Jr” means that 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 is used for reporting on Earning Statements and other Tax Forms. |
1 Special characters accepted in 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. | The preferred name of the employee. | Jr Joe |
This data is needed for some countries. |
1 Special characters accepted in 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. | The maternal last name of the employee if any. | LaForce | This data is needed for some countries. |
1 Special characters accepted in 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. | The previous Last Name of the employee if any. | Biagini | This data is needed for some countries. |
1 Special characters accepted in 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. |
The 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. If the employee doesn’t have the information yet, this field. can be left blank. However, leaving the field blank could result in payroll issues. Any leading zeros must be included. Hyphens should be excluded. Value requirements vary by country.4 Note: If the Enable SSN Validation client property is disabled in Dayforce, Activate treats the following validations as warnings: |
SSN/SIN:
NINO:
TFN:
PPSN:
IRD:
NRIC:
|
This data is needed for accurate reporting of payroll and tax information. |
1 Special characters accepted in the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Country | National ID | Length | Country Specific Validations |
|---|---|---|---|
| United States of America | Social Security Number (SSN) | 9 | The value must contain only numeric characters and be a valid SSN. |
| Canada | Social Insurance Number (SIN) | 9 | The value must contain only numeric characters and be a valid SIN. |
| United Kingdom | National Insurance Number (NINO) | 9 |
The value must contain alpha and numeric characters and be a valid NINO. |
| Ireland | Personal Public Service Number (PPSN) | 8 to 9 | The value must contain alpha and numeric characters and be a valid PPSN. |
| Australia | Tax File Number (TFN) | 9 |
The value must contain only numeric characters and be a valid TFN value. The following special TFN Codes are also supported: 000000000, 111111111, 333333333, and 444444444. |
| New Zealand | Inland Revenue Department Number (IRD) | 8 to 9 | The value must contain only numeric characters and must be a valid IRD. The value must be in the range of 10000000 to 150000000. |
| Singapore | National Registration Identity Card (NRIC) | 9 |
The value must contain alpha and numeric characters and be a valid NRIC.
|
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 11 | String1.
3 characters. |
The nationality of the employee. | BRA | This data is needed for some countries. |
1 Special characters accepted in 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:
|
The citizenship of the employee. |
Example Values:
|
This data is needed for some countries. Note: Country restricts some values. |
| 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 in 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 values3. |
The employee's birth state. See below for valid Birth State accepted values. |
CA-ON | This data is needed for some countries. |
1 Special characters accepted in 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:
|
The employee’s birth country. |
CAN | This data is needed for some countries. |
1 Special characters accepted in the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| 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. |
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:
Text formatted cells:
|
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. | The employee's seniority date |
Date formatted cells:
Text formatted cells:
|
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. | The employee's start date or return to work |
Date formatted cells:
Text formatted cells:
|
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:
|
The legal sex of the employee. When the Assigned Sex field and the Gender Identity field are both left blank, Activate doesn't validate either field. When the Assigned Sex field is populated but the Gender Identity field is blank, Activate validates both fields for the records they are in. When Assigned Sex is provided for an employee and that employee’s country is CAN or USA, Activate validates that the employee’s primary work assignment record has an address State Code value. This field isn’t case sensitive. Note: Activate validates the Assigned Sex field only when the uploaded data includes values other than the Dayforce system default values. For Canada and the United States: When the template includes an Assigned Sex value, a federal employee gender record is created. Note: If the Assigned Sex value is provided and the employee’s pay group doesn’t match their primary work assignment (location) country, Activate won’t create a valid enhanced gender record. |
Example Values:
|
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:
|
The employee's gender based on the Gender Identities defined in Dayforce. When the Gender Identity field and the Assigned Sex field are both left blank, Activate doesn’t validate either field. When the Gender Identify field is populated but the Assigned Sex field is blank, Activate validates both fields for the records they are in. When Gender Identity is provided for an employee and that employee’s country is CAN or USA, Activate validates that the employee’s primary work assignment record has an address State Code value. Note: Activate validates the Gender Identify field only when the uploaded data includes values other than the Dayforce system default values. Activate derives the employee’s Birth State and the Country Code from the employee's primary work assignment for Employee Gender. This field isn’t case sensitive. Note: Gender Identity is not supported for German employees. If Gender Identify information was included for German employees, it will fail to load. Note: If the Gender Identity value is provided and the employee’s pay group doesn’t match their primary work assignment (location) country, Activate won’t create a valid enhanced gender record. |
Example Values:
|
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 21 |
Accepted Values:
|
The employee's ethnicity. |
Accepted Values:
|
This data is used for EEOC-1 Reporting. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 22 |
Accepted Values:
|
The employee's religion. |
Example Values:
|
This data is mandatory for Singapore Native Payroll |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 23 |
Accepted Values:
|
The employee's marital status. |
Accepted Values:
|
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:
|
The employee's disability status. |
Accepted Values:
|
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:
|
The employee's veteran status. |
Accepted Values:
|
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. |
The effective start date of the employee's veteran status.
|
Date formatted cells:
Text formatted cells:
|
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. | The end date of the employee's veteran status. |
Date formatted cells:
Text formatted cells:
|
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:
|
An employee who has a visible minority status. |
Accepted Values:
|
The Employment Equity Act defines this data in Canadian law. 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:
|
An employee who is a member of the Aboriginal Peoples of Canada. |
Accepted Values:PreferNotToSay
|
The Employment Equity Act defines this data in Canadian law 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. | The preferred language of the employee if any. | en-US | This data is needed for some countries. |
1 Special characters accepted in the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &