# Batch Processing Data For Auto Steward

The most common means for a client to utilize Auto-Steward is through our pair match web service. A batch version of Auto-Steward is also available to some clients upon request. In those cases, a client works with the Verato Customer Delivery team and provides a pipe-delimited file containing all possible duplicate identities. Verato’s Customer Delivery team runs these requests through the Auto-Steward process and collates the responses into a return file (also pipe-delimited) which the client can use to process the data stewardship tasks.

The input data file the client provides must be a pipe-delimited ASCII file, with the fields specified in the table below (the Data Elements):

- **File format:** Text file
- **Delimiter:** | – pipe
- **Columns:** fixed number of columns—if a given value is not present in your database, just leave it blank


table
thead
tr
th
#
th
Data Element
th
Description
th
Format
th
Max Char
th
Required
tbody
tr
td
1
td
ID1 Source
td
The code that identifies the source system/application from which the record originated.
td
Data only, no null characters
td
10
td
Yes
tr
td
2
td
ID1 Record ID
td
The id which uniquely identifies the record within the Source. e.g. Customer id, Patient id, MRN
td
Data only, no null characters
td
60
td
Yes
tr
td
3
td
ID1 First Name
td
First name
td
Data only, no null characters
td
40
td
tr
td
4
td
ID1 Middle Name
td
Middle name
td
Data only, no null characters
td
40
td
tr
td
5
td
ID1 Last Name
td
Last name
td
Data only, no null characters
td
80
td
tr
td
6
td
ID1 Name Suffix
td
Name suffix
td
Data only, no null characters
td
10
td
tr
td
7
td
ID1 SSN
td
Social security number
td
9 digits, no hyphens or other punctuation
td
9
td
tr
td
8
td
ID1 DOB
td
Date of birth
td
YYYYMMDD (no hyphens or other punctuation)
td
10
td
tr
td
9
td
ID1 Gender
td
Gender
td
Gender-M,F,U
td
10
td
tr
td
10
td
ID1 Address Line 1
td
Street address line 1
td
Data only, no null characters
td
255
td
tr
td
11
td
ID1 Address Line 2
td
Street address line 2
td
Data only, no null characters
td
255
td
tr
td
12
td
ID1 City
td
City name
td
Data only, no null characters
td
40
td
tr
td
13
td
ID1 State
td
State code
td
2 character state code
td
2
td
tr
td
14
td
ID1 Zip Code
td
Zip Code-first 5 only
td
Data only, no null characters
td
5
td
tr
td
15
td
ID1 Zip+4
td
Zip+4
td
Data only, no null characters
td
4
td
tr
td
16
td
ID2 Source
td
The code that identifies the source system/application from which the record originated.
td
Data only, no null characters
td
10
td
Yes
tr
td
17
td
ID2 Record ID
td
The id which uniquely identifies the record within the Source. e.g. Customer id, Patient id, MRN
td
Data only, no null characters
td
60
td
Yes
tr
td
18
td
ID2 First Name
td
First name
td
Data only, no null characters
td
40
td
tr
td
19
td
ID2 Middle Name
td
Middle name
td
Data only, no null characters
td
40
td
tr
td
20
td
ID2 Last Name
td
Last name
td
Data only, no null characters
td
80
td
tr
td
21
td
ID2 Name Suffix
td
Name suffix
td
Data only, no null characters
td
10
td
tr
td
22
td
ID2 SSN
td
Social security number
td
9 digits, no hyphens or other punctuation
td
9
td
tr
td
23
td
ID2 DOB
td
Date of birth
td
YYYYMMDD (no hyphens or other punctuation)
td
10
td
tr
td
24
td
ID2 Gender
td
Gender
td
Gender-M,F,U
td
10
td
tr
td
25
td
ID2 Address Line 1
td
Street address line 1
td
Data only, no null characters
td
255
td
tr
td
26
td
ID2 Address Line 2
td
Street address line 2
td
Data only, no null characters
td
255
td
tr
td
27
td
ID2 City
td
City name
td
Data only, no null characters
td
40
td
tr
td
28
td
ID2 State
td
State code
td
2 character state code
td
2
td
tr
td
29
td
ID2 Zip Code
td
Zip Code-first 5 only
td
Data only, no null characters
td
5
td
tr
td
30
td
ID2 Zip+4
td
Zip+4
td
Data only, no null characters
td
4
td