Data File Specification

File Requirements

• The file that you upload must be uploaded as a .csv and contain the following headers below

• File cannot contain a footer row.

• Single line per employee record.

• All data must be passed within the "Maximum Length" noted by field type, otherwise truncated prior to submission.

• File Name: [Company Name] - User List [MM-DD-YYYY].csv

Create Custom Report

1. Search for the Create Custom Report task.

2. In the Name field, enter the Report Name.
1. We recommend the following: “CR Verbate Demographic”
2. If there is a known client naming convention, please use that naming convention instead.

3. Select Advanced as the Report Type

4. Check the box to Enable as Web Service

5. Select All Workers as the Data Source

6. Click OK to proceed

Columns

Create Integration

1. Search for the Create EIB task.

2. In the Name field, enter the EIB Name.
1. We recommend the following: “INT_Verbate_Demographic”.
2. If there is a known client naming convention, please use that naming convention instead.

3. Select Outbound as the direction

4. Click OK to proceed

General Settings

1. Click Next to proceed past “General Settings”

Get Data

1. In the Data Source Type, select Custom Report from the drop-down menu.

2. Next, for Custom Report field, select the report created in the previous step

3. Expand Details, and change Alternate Output Format to CSV.

4. Click Next

Transform

1. Verify the Transformation Type is None

2. Click Next.

Deliver

1. For the Delivery Method, select SFTP from the drop-down menu.

2. Select “User Name / Password” for the Authentication Method.

3. Use the email/Appendix to fill out SFTP Address, Directory, User Id, Password fields

4. Click Next

Review and Submit

1. Review all of the options and then click OK to save.

2. Configure ISU/ISSG according to Company policy. See Appendix for minimum domain requirements.

3. Once saved, launch the integration.

Appendix

SFTP Information

ISSG/ISU Set Up