Submission File Format
To ensure your electronic file submission processes successfully, the file must be a text file (.txt) in the following format:
Note
Effective 09/24/11, gender is no longer used as part of the SSN verification process. You do not need to make any changes to the file format. If a value is included in position '54' of a file, we will remove it and replace it with a blank prior to the verification attempt. All returned files will have a blank in position '48.'
Record delimiters are not to be used (i.e., do not place a comma or any other character after any field).
If a field marked "May not be left blank." does not contain an entry, the item is automatically considered a non-verified record.
In order to sort the return file to your specifications, we recommend using the User Control Data field to create a unique identifier for each record. This unique identifier would be placed in positions 90-103 in your submission file and returned to you in positions 84-97 in the return file.
Field Name | Instructions | Position | Field Size | Field Type |
---|---|---|---|---|
Social Security Number |
|
1-9 | 9 | Numeric |
Entry Code "TPV" |
|
10-12 | 3 | Alpha |
Processing Code 214 |
|
13-15 | 3 | Numeric |
Last Name |
|
16-28 | 13 | Alpha |
First Name |
|
29-38 | 10 | Alpha |
Middle Name/Initial |
|
39-45 | 7 | Alpha |
Date of Birth (MMDDYYYY) |
|
46-53 | 8 | Numeric |
Blank | SSA use only. | 54-89 | 36 | Blanks |
User Control Data | Free form text for employer. | 90-103 | 14 | Alphanumeric |
Blank | SSA use only. | 104-123 | 20 | Blanks |
Requester Identification Code |
|
124-127 | 4 | Alpha |
Multiple Request Indicator |
|
128-130 | 3 | Numeric |