Use the Employee Addresses wizard to upload employee addresses for employees who don’t have any address information and to load additional employee address information.
Note: You can run this data load more than one time.
Note: Activate uses HR Version 2.0 (NextGen) when loading data during configuration.
Before you begin
You’ve completed the Getting Started wizard or the Employees wizard.
Using this wizard
The previously loaded employee address information shows in an editable grid with the address-related fields that need to be populated. You can enter information directly in the grid or you can download the Additional Employee Address Data 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 show, you must review and update the data in the grid or upload a corrected template to correct them.
Tasks
- In Activate Central, click Load Your Data. The Load Your Data wizards show.
- Click Employee Addresses.
- On the Employee Address Load page, click Download.
- Select the location where you want to save the template document.
- Open the
AdditionalEmployeeAddressDataTemplate.xlsx
template on your computer.Note: You can also download an empty Employee Addresses template from the Download Template Files page.
- On the AdditionalEmployeeAddressData tab, complete all columns with the data for all employees in the organization.
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 on how to populate the fields are in the Additional Employee Address 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 Address Load page, click Upload.
- Go to your completed Additional Employee Address Data template in the location where you saved it.
- Click Open. The Employee Addresses wizard validates the data.
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.
- Click Next.
- 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 address information is complete in Activate, you must install the policies in Dayforce.
- After making any necessary corrections, on the Employee Address 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 receive an email when the installation process ends, instead of waiting for it to finish.
- Next w hen the installation is complete.
Activate Central opens with the name of the Wizard now shown in green text and a green checkmark to the left of the wizard’s name. The current day, date, and time of completion are included, 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 data uploaded from the Employee Address template populates the fields on the following pages in Dayforce.
Note: You must select an employee if you haven’t already done so.
Field in Template | Field in Dayforce | Page in Dayforce |
---|---|---|
Employee Identifier | Employee Reference / Number |
Employee (People icon)
|
First Name | First Name | |
Last Name |
Last Name | |
Address 1 | Address Line 1 |
Contact Information, Addresses section
(People icon > Personal >
|
Address 2 | Address Line 2 | |
Address 3 | Address Line 3 | |
Address 4 | Address Line 4 | |
Address 5 | Address Line 5 | |
Address 6 | Address Line 6 | |
City | City | |
County | County | |
State/Prov | State / Province | |
Zip/Postal Code | Zip / Postal Code | |
Country | Country | |
Effective Start Date | Effective Start | |
Type | Address Type |
After completing the Employee Address 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>
<LastName>Mullis</LastName>
<AddressInformation>
<ContactInformationTypeXrefCode>Secondary</ContactInformationTypeXrefCode>
<EffectiveStart>2018-01-21</EffectiveStart>
<Address1>190 Lees Ave</Address1>
<Address2>1215</Address2>
<Address3 />
<Address4 />
<Address5 />
<Address6 />
<County>Essex</County>
<City>Witham</City>
<StateCode />
<CountryCode>GBR</CountryCode>
<PostalCode>CM8 1HJ</PostalCode>
</AddressInformation>
</Employee>
<Employee>
<XRefCode>1231</XRefCode>
<EmployeeNumber>1231</EmployeeNumber>
<FirstName>Morris</FirstName>
<LastName>Bojkewich</LastName>
<AddressInformation>
<ContactInformationTypeXrefCode>PrimaryResidence</ContactInformationTypeXrefCode>
<EffectiveStart>2018-01-16</EffectiveStart>
<Address1>1217 4th Street</Address1>
<Address2>a</Address2>
<Address3 />
<Address4 />
<Address5 />
<Address6 />
<County />
<City>Chico</City>
<StateCode>CA</StateCode>
<CountryCode>USA</CountryCode>
<PostalCode>23345</PostalCode>
</AddressInformation>
</Employee>
<Employee>
<XRefCode>1811</XRefCode>
<EmployeeNumber>1811</EmployeeNumber>
<FirstName>Dean</FirstName>
<LastName>Linzel</LastName>
<AddressInformation>
<ContactInformationTypeXrefCode>PrimaryResidence</ContactInformationTypeXrefCode>
<EffectiveStart>2009-11-07</EffectiveStart>
<Address1>192 Lees Ave</Address1>
<Address2>a</Address2>
<Address3 />
<Address4 />
<Address5 />
<Address6 />
<County />
<City>Ottawa</City>
<StateCode>ON</StateCode>
<CountryCode>CAN</CountryCode>
<PostalCode>K1S5L7</PostalCode>
</AddressInformation>
</Employee>
<Employee>
<XRefCode>AAAAA</XRefCode>
<EmployeeNumber>AAAAA</EmployeeNumber>
<FirstName>Minghao</FirstName>
<LastName>Chen</LastName>
<AddressInformation>
<ContactInformationTypeXrefCode>Secondary</ContactInformationTypeXrefCode>
<EffectiveStart>2018-01-16</EffectiveStart>
<Address1>135 Merberly Ave</Address1>
<Address2>12</Address2>
<Address3 />
<Address4 />
<Address5 />
<Address6 />
<County />
<City>Kanata</City>
<StateCode>ON</StateCode>
<CountryCode>CAN</CountryCode>
<PostalCode>K1N8L5</PostalCode>
</AddressInformation>
</Employee>
</EmployeeImport>
Next steps
Complete the next wizard, as appropriate.
Additional Employee Address 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. This required field is 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 | Examples | Why This Is Needed |
---|---|---|---|---|
2 | 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. This required field is 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 | Examples | Why This Is Needed |
---|---|---|---|---|
3 | 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. This required field is 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 | Examples | Why This Is Needed |
---|---|---|---|---|
4 | String1 between 1-70 characters. | The Street Name/PO Box of the employee's primary residence. Using PO Box for the primary residence address is not compatible with DF Wallet banking requirements. | 1234 Vermont Ave
12-566 Simcoe St |
Acts as a default mailing address for the employee in the event that any printed advices/tax forms need to be sent. For employees working in the US this is also needed to determine which state/local taxes should be applied. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
5 | String1 between 1-70 characters. | The Street Number of the employee's primary residence. | 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 | Examples | Why This Is Needed |
---|---|---|---|---|
6 | String1 between 1-70 characters. | The Apartment Floor of the employee's primary residence. | 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 | Examples | Why This Is Needed |
---|---|---|---|---|
7 | String1 between 1-256 characters. | The Apartment Number, Door Number, Building, and Room Number of the employee's primary residence. | 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 | Examples | Why This Is Needed |
---|---|---|---|---|
8 | String1 between 1-256 characters. | The Name of Building/Post Office/Settlement, Barrio, Residential Area of the employee's primary residence. | 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 | Examples | Why This Is Needed |
---|---|---|---|---|
9 | String1 between 1-256 characters. | The Street Type of the employee's primary residence. | 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 | Examples | Why This Is Needed |
---|---|---|---|---|
10 | String1 between 1-70 characters. | The city of the employee's primary residence. | New York
Santa Monica Toronto |
Acts as a default mailing address for the employee in the event that any printed advices/tax forms need to be sent. For employees working in the US, this is also needed to determine which state/local taxes should be applied. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
11 | String1 between 1-256 characters. | The county of the employee's primary residence. | Sussex
Erie |
(US Only) Needed to determine which state/local taxes should be applied to the employee and acts as a default mailing address for the employee in the event that any printed advices/tax forms need to be sent. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
12 |
Accepted Values: 2-letter state/province State/Prov Accepted Value3. |
The two letter state/province code of the employee's primary residence. If the Country is the UK, this field should be left blank. See below for Valid State/Prov accepted value. |
FL
IL MA SG-01 |
Needed to determine which state/local taxes should be applied to the employee and acts as a default mailing address for the employee in the event that any printed advices/tax forms need to be sent. |
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-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-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 |
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-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 |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
13 | Alphanumeric between 1-30 characters. | The zip/postal code of the employee's primary residence. | M2H2L5 (CAN)
52953 (US) 88310-7241 (US) AA9A 9AA (UK) 3051 (AUS/NZL) |
Acts as a default mailing address for the employee in the event that any printed advices/tax forms need to be sent. For employees working in the US this is also needed to determine which state/local taxes should be applied. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
14 |
Accepted Values: AUS
|
The country of the employee's primary residence. | CAN
USA UK NZ IRL SGP Any Non-Native Countries |
Acts as a default mailing address for the employee in the event that any printed advices/tax forms need to be sent. For employees working in the US this is also needed to determine which state/local taxes should be applied. |
Accepted Values | Country Name |
---|---|
ARG | Argentina |
AFG | Afghanistan |
ALA | Åland 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 |