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 were installed by Activate.
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.
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.xlsx
template 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 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
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 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>
<EmployeeNumber>4343</EmployeeNumber>
<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. | 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. | Legal first name of the employee. | 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 within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Example | Why This Is Needed |
---|---|---|---|---|
3 | String1 between 1-64 characters. | Legal last name of the employee. | 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 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 | 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 | String1 between 1-128 characters. | The issuing country for the confidential identification. Select the country that issued the identification. | Example Values:
CAN AUS SGP |
This data is needed for some countries. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Accepted Values | Country Name |
---|---|
ARG | Argentina |
AUT | Austria |
BEL | Belgium |
BRA | Brazil |
BGR | Bulgaria |
CHL | Chile |
CHN | China |
HRV | Croatia |
CYP | Cyprus |
CZE | Czech Republic |
DNK | Denmark |
EST | Estonia |
FIN | Finland |
FRA | France |
DEU | Germany |
GRC |
Greece |
HKG |
Hong Kong |
HUN |
Hungary |
IND |
India |
ITA | Italy |
JPN | Japan |
KOR | Korea |
LVA | Latvia |
LTU | Lithuania |
LUX | Luxembourg |
MYS | Malaysia |
MLT | Malta |
MUS | Mauritius |
MEX | Mexico |
NLD | Netherlands |
NOR | Norway |
PER | Peru |
PHL | Philippines |
POL | Poland |
PRT | Portugal |
ROU | Romania |
SVK | Slovakia |
SVN | Slovenia |
ZAF | South Africa |
ESP | Spain |
SWE | Sweden |
CHE | Switzerland |
TWN | Taiwan |
THA | Thailand |
ARE | UAE |
VNM | Vietnam |
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 dates during which the identification record is active 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 dates during which the identification record is active 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 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 identification 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. |