Use the Employee Confidential Identification wizard to mass load organization-specific confidential information to employee HR records in Dayforce. Examples of organization-specific information include: passports, birth certificates, visas, tax IDs, and other custom identification types,
The countries selected during Getting Started determined which sets of predefined country-specific Confidential Information fields that Activate installed.
The HR Import uses this wizard to capture the following additional data:
- Emp XRefCode
- Effective Start
- Effective End
- Type XRefCode
- Country Code
- Place Of Issue
- Issue Date
- Expiry Date
- ID Number
Note: The data import file can contain more than one record per employee, with different identification types.
Using this wizard
You’ll do the following in the Employee Confidential Information wizard:
Read information about the wizard and what you need to do.
Use the Employee Confidential Information Data template to upload the confidential information.
Note: You can also download an empty Employee Confidential Information Data template from the Download Template Files page.
After loading the data, the employee confidential information shows in an editable grid. You can enter information directly in the grid or you can download the Confidential Information Data template, update the information, 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, review them and update the data in the grid or uploading a corrected template to correct them.
Enter required changes in the template to assure accuracy for future uploads. If you make edits directly in the grid, click Save and download the updated file for record keeping purposes.
When the employee confidential information is complete in Activate, you must install it in Dayforce.
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. The Load Your Data wizards are shown.
- Click Employee Confidential Information.
- On the Intro page, review the information.
-
Confirm that all Identification Types exist in Dayforce by selecting the checkbox.
You must confirm the Identification Types to continue.
If the Identification Types don’t exist in Dayforce, click Back to exit the wizard.
- Click Next.
- In Activate Central, click Load Your Data. The Load Your Data wizards show.
- Click Employee Confidential Information.
- On the Confidential Identification Data page, click Download.
- Select the location where you want to save the template document.
- Open the
EmployeeConfidentialInformationDataTemplate.xlsxtemplate on your computer.Note: You can also download an empty Employee Confidential Information Data template from the Download Template Files page.
- On the ConfidentialInformationData 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 for populating the fields are in the Employee Confidential Information 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 in the template. Activate uses the tab name to validate that the correct template is being uploaded. In addition, don’t change the column headings.
- On the Confidential Identification Data page, click Upload.
- Go to your completed Confidential Identification Data template in the location where you saved it.
- Click Open. Activate validates the uploaded file.
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.
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.
- Click Next.
-
On the Confidential Identification Review page, review the summary of information to be installed in Dayforce.
The information might include:
- Employee Identifier
- First Name
- Last Name
- Identification Type
- Issuing Country
- Place of Issue
- Effective Start Date
- Effective End Date
- Issue Date
- Expiry Date
- Identification Number
If any information is incorrect, click Back to return to the Confidential Identification Data page and make the corrections.
- 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 confidential information is complete in Activate, you must load the data into Dayforce.
- After making any necessary corrections, on the Confidential Identification 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 when 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) 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
You can view the uploaded data in the Identification section of the Dayforce > People > Personal > Confidential Information page in Dayforce.
The data uploaded from the Employee Confidential Information template populates the fields on the following pages in Dayforce.
| Field Name | Field in Dayforce | Page in Dayforce |
|---|---|---|
| Employee Identifier |
Employee Reference / Number |
Employee (People icon)
|
|
First Name |
First Name |
|
|
Last Name |
Last Name |
|
|
Identification Type |
Identification Type |
Dayforce> People > Personal > Confidential Information
|
|
Issuing Country |
Issuing Country |
|
|
Place of Issue |
Place of Issue |
|
| Effective From |
Effective From |
|
| Effective To |
Effective To |
|
| Issue Date |
Issue Date |
|
| Expiry Date |
Expiry Date |
|
|
Identification Number |
Identification Number |
After completing the Employee Confidential Information 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>4343</XRefCode>
<FirstName>Kevin</FirstName>
<LastName>Ash</LastName>
-<EmployeeConfidentialIdentification>
<TypeXrefCode>WP</TypeXrefCode>
<CountryCode/>
<PlaceOfIssue/>
<EffectiveStart>2000-01-01</EffectiveStart>
<EffectiveEnd>2001-01-01</EffectiveEnd>
<IssueDate>2000-01-01</IssueDate>
<ExpiryDate>2001-01-01</ExpiryDate>
<IDNumber>12345</IDNumber>
</EmployeeConfidentialIdentification>
</Employee>
</EmployeeImport>
Next steps
Complete the next wizard, as appropriate.
Employee Confidential Information 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. |
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 |
In the context of this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values given must match an existing employee record in Dayforce exactly. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
| 2 | String1 between 1–64 characters. |
The legal first name of the employee. 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 | In the context of this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values given must match an existing employee record in Dayforce exactly. |
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 last name of the employee. 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 | In the context of this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template. These required fields are used to validate that the data being loaded is assigned to the correct employee record. The values given must match an existing employee record in Dayforce exactly. |
1 Special characters accepted in 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 | Accepted Values:
See your consultant. |
Confidential identification types describe the types of identification records that can be saved in an employee's HR records. | Example Values:
Driver's License Passport Tax ID VISA |
This data is needed for some countries. |
| Data Type | Description | Examples | Why This Is Needed | |
|---|---|---|---|---|
| 5 | 3-character country code.
See Accepted values for Issuing country.2 |
The issuing country for the confidential identification. Select the country that issued the identification. | Example Values:
USA CAN GBR IRL AUS NZL |
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 |
|---|---|
| ABW | Aruba |
| AFG | Afghanistan |
| AGO | Angola |
| AIA | Anguilla |
| ALA | Aland Islands |
| ALB | Albania |
| AND | Andorra |
| ARE | UAE |
| ARG | Argentina |
| ARM | Armenia |
| ASM | American Samoa |
| ATA | Antarctica |
| ATF | French Southern Territories (The) |
| ATG | Antigua and Barbuda |
| AUS | Australia |
| AUT | Austria |
| AZE | Azerbaijan |
| BDI | Burundi |
| BEL | Belgium |
| BEN | Benin |
| BES | Bonaire, Sint Eustatius and Saba |
| BFA | Burkina Faso |
| BGD | Bangladesh |
| BGR | Bulgaria |
| BHR | Bahrain |
| BHS | Bahamas (The) |
| BIH | Bosnia and Herzegovina |
| BLM | Saint Barthélemy |
| BLR | Belarus |
| BLZ | Belize |
| BMU | Bermuda |
| BOL | Bolivia (Plurinational State of) |
| BRA | Brazil |
| BRB | Barbados |
| BRN | Brunei Darussalam |
| BTN | Bhutan |
| BVT | Bouvet Island |
| BWA | Botswana |
| CAF | Central African Republic (The) |
| CAN | Canada |
| CCK | Cocos (Keeling) Islands (The) |
| CHE | Switzerland |
| CHL | Chile |
| CHN | China |
| CIV | Côte d'Ivoire |
| CMR | Cameroon |
| COD | Congo (the Democratic Republic of the) |
| COG | Congo (The) |
| COK | Cook Islands (The) |
| COL | Colombia |
| COM | Comoros (The) |
| CPV | Cabo Verde |
| CRI | Costa Rica |
| CUB | Cuba |
| CUW | Curaçao |
| CXR | Christmas Island |
| CYM | Cayman Islands (The) |
| CYP | Cyprus |
| CZE | Czechia |
| DEU | Germany |
| DJI | Djibouti |
| DMA | Dominica |
| DNK | Denmark |
| DOM | Dominican Republic (The) |
| DZA | Algeria |
| ECU | Ecuador |
| EGY | Egypt |
| ERI | Eritrea |
| ESH | Western Sahara |
| ESP | Spain |
| EST | Estonia |
| ETH | Ethiopia |
| FIN | Finland |
| FJI | Fiji |
| FLK | Falkland Islands (The) [Malvinas] |
| FRA | France |
| FRO | Faroe Islands (The) |
| FSM | Micronesia (Federated States of) |
| GAB | Gabon |
| GBR | United Kingdom |
| GEO | Georgia |
| GGY | Guernsey |
| GHA | Ghana |
| GIB | Gibraltar |
| GIN | Guinea |
| GLP | Guadeloupe |
| GMB | Gambia (The) |
| GNB | Guinea-Bissau |
| GNQ | Equatorial Guinea |
| GRC | Greece |
| GRD | Grenada |
| GRL | Greenland |
| GTM | Guatemala |
| GUF | French Guiana |
| GUM | Guam |
| GUY | Guyana |
| HKG | Hong Kong |
| HMD | Heard Island and McDonald Islands |
| HND | Honduras |
| HRV | Croatia |
| HTI | Haiti |
| HUN | Hungary |
| IDN | Indonesia |
| IMN | Isle of Man |
| IND | India |
| IOT | British Indian Ocean Territory (The) |
| IRL | Ireland |
| IRN | Iran (Islamic Republic of) |
| IRQ | Iraq |
| ISL | Iceland |
| ISR | Israel |
| ITA | Italy |
| JAM | Jamaica |
| JEY | Jersey |
| JOR | Jordan |
| JPN | Japan |
| KAZ | Kazakhstan |
| KEN | Kenya |
| KGZ | Kyrgyzstan |
| KHM | Cambodia |
| KIR | Kiribati |
| KNA | Saint Kitts and Nevis |
| KOR | Korea |
| KWT | Kuwait |
| LAO | Lao People's Democratic Republic (The) |
| LBN | Lebanon |
| LBR | Liberia |
| LBY | Libya |
| LCA | Saint Lucia Liechtenstein |
| LIE | Liechtenstein |
| LKA | Sri Lanka |
| LSO | Lesotho |
| LTU | Lithuania |
| LUX | Luxembourg |
| LVA | Latvia |
| MAC | Macao |
| MAF | Saint Martin (French part) |
| MAR | Morocco |
| MCO | Monaco |
| MDA | Moldova (the Republic of) |
| MDG | Madagascar |
| MDV | Maldives |
| MEX | Mexico |
| MHL | Marshall Islands (The) |
| MKD | North Macedonia |
| MLI | Mali |
| MLT | Malta |
| MMR | Myanmar |
| MNE | Montenegro |
| MNG | Retrieving data. Wait a few seconds and try to cut or copy again. |
| MNP | Northern Mariana Islands (The) |
| MOZ | Mozambique |
| MRT | Mauritania |
| MSR | Montserrat |
| MTQ | Martinique |
| MUS | Mauritius |
| MWI | Malawi |
| MYS | Malaysia |
| MYT | Mayotte |
| NAM | Namibia |
| NCL | New Caledonia |
| NER | Niger (The) |
| NFK | Norfolk Island |
| NGA | Nigeria |
| NIC | Nicaragua |
| NIU | Niue |
| NLD | Netherlands |
| NOR | Norway |
| NPL | Nepal |
| NRU | Nauru |
| NZL | New Zealand |
| OMN | Oman |
| PAK | Pakistan |
| PAN | Panama |
| PCN | Pitcairn |
| PER | Peru |
| PHL | Philippines |
| PLW | Palau |
| PNG | Papua New Guinea |
| POL | Poland |
| PRI | Puerto Rico |
| PRK | Korea (the Democratic People's Republic of) |
| PRT | Portugal |
| PRY | Paraguay |
| PSE | Palestine, State of |
| PYF | French Polynesia |
| QAT | Qatar |
| REU | Réunion |
| ROU | Romania |
| RUS | Russian Federation (The) |
| RWA | Rwanda |
| SAU | Saudi Arabia |
| SDN | Sudan (The) |
| SEN | Senegal |
| SGP | Singapore |
| SGS | South Georgia and the South Sandwich Islands |
| SHN | Saint Helena, Ascension and Tristan da Cunha |
| SJM | Svalbard and Jan Mayen |
| SLB | Solomon Islands |
| SLE | Sierra Leone |
| SLV | El Salvador |
| SMR | San Marino |
| SOM | Somalia |
| SPM | Saint Pierre and Miquelon |
| SRB | Serbia |
| SSD | South Sudan |
| STP | Sao Tome and Principe |
| SUR | Suriname |
| SVK | Slovakia |
| SVN | Slovenia |
| SWE | Sweden |
| SWZ | Eswatini |
| SXM | Sint Maarten (Dutch part) |
| SYC | Seychelles |
| SYR | Syrian Arab Republic (The) |
| TCA | Turks and Caicos Islands (The) |
| TCD | Chad |
| TGO | Togo |
| THA | Thailand |
| TJK | Tajikistan |
| TKL | Tokelau |
| TKM | Turkmenistan |
| TLS | Timor-Leste |
| TON | Tonga |
| TTO | Trinidad and Tobago |
| TUN | Tunisia |
| TUR | Turkey |
| TUV | Tuvalu |
| TWN | Taiwan |
| TZA | Tanzania, the United Republic of |
| UGA | Uganda |
| UKR | Ukraine |
| UMI | United States Minor Outlying Islands (The) |
| URY | Uruguay |
| USA | United States of America |
| UZB | Uzbekistan |
| VAT | Holy See (The) |
| VCT | Saint Vincent and the Grenadines |
| VEN | Venezuela (Bolivarian Republic of) |
| VGB | Virgin Islands (British) |
| VIR | Virgin Islands (U.S.) |
| VNM | Vietnam |
| VUT | Vanuatu |
| WLF | Wallis and Futuna |
| WSM | Samoa |
| YEM | Yemen |
| ZAF | South Africa |
| ZMB | Zambia |
| ZWE | Zimbabwe |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 6 | String.1 Between 1– 128 characters. | Enter where the identification was issued, such as a city. |
Example Values:
|
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 | Examples | Why This Is Needed |
|---|---|---|---|---|
| 7 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Enter the date the Confidential Identification record should be active from in Dayforce. | Date formatted cells: 09/24/2015 24/09/2015 Text formatted cells: |
This data is needed for some countries. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 8 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Enter the date the identification record should be active up to in Dayforce. | Date formatted cells: 09/24/2015 24/09/2015 Text formatted cells: |
This data is needed for some countries. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 9 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | Enter the date that the Confidential Identification was issued. | Date formatted cells: 09/24/2015 24/09/2015 Text formatted cells: |
This data is needed for some countries. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 10 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. |
Enter the date that the Confidential Information expires. | Date formatted cells: 09/24/2015 24/09/2015 Text formatted cells: |
This data is needed for some countries. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 11 | String between 1–128 characters. | Maps to the employee’s identification type confidential identification id. | This data is needed for some countries. |