ADP File Layout
Use this file layout if you are importing an ADP (MFOUT.xxx) file format input file on the Import Employee Data screen.
ADP File Format
The input file layouts for the fixed-length file format follow:
Heading
| Field | Field Name | Columns | Size | Contents | Notes |
|---|---|---|---|---|---|
| 1 | Blanks | 1-21 | 21 | Blanks | |
| 2 | ADP Version | 22-23 |
Record 1
| Field | Field Name | Columns | Size | Contents | Notes |
|---|---|---|---|---|---|
| 1 | ADP Record Number | 1-2 | 2 | '01' | |
| 2 | Not Used | 3-5 | 3 | Blanks | |
| 3 | ADP File Number
(Basic Employee Info) |
6-11 | 6 | Used as Employee ID (unless using SSN for empl ID) and PR Service Empl ID | |
| 4 | Name
(Basic Employee Info) |
12-43 | 32 | Format LAST, FIRST MI | |
| 5 | Address Line 1
(Basic Employee Info) |
44-63 | 20 | ||
| 6 | Address Line 2
(Basic Employee Info) |
64-83 | 20 | ||
| 7 | City Name
(Basic Employee Info) |
84-101 | 18 | ||
| 8 | State
(Basic Employee Info) |
102-103 | 2 | ||
| 9 | Postal Code
(Basic Employee Info) |
104-113 | 10 | ||
| 10 | Social Security Number
(Basic Employee Info) |
114-124 | 11 | Format: 999-99-9999 (with dashes) | |
| 11 | Not Used | 125-142 | 18 | ||
| 12 | Employee Status
(Basic Employee Info) |
143 | 1 |
A, R, S, or "\" = Active. D or T = Inactive. Anything else = FMLA |
Default value can be specified on screen. |
| 13 | Gender Code
(Basic Employee Info) |
144 | 1 | 'M' or 'F' | |
| 14 | Home Phone
(Basic Employee Info) |
145-155 | 11 | ||
| 15 | Not Used | 156-160 | 5 | Blanks | |
| 16 | Date 1
(Basic Employee Info) |
161-168 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 17 | Date 2
(Basic Employee Info) |
169-176 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 18 | Date 3
(Basic Employee Info) |
177-184 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 19 | Date 4
(Basic Employee Info) |
185-192 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 20 | Date 5
(Basic Employee Info) |
193-200 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 21 | Not Used | 201-218 | Blanks |
Record 2
| Field | Field Name | Columns | Size | Contents | Notes |
|---|---|---|---|---|---|
| 1 | ADP Record Number | 1-2 | 2 | '02' | |
| 2 | Not Used | 3-5 | 3 | Blanks | |
| 3 | ADP File Number
(Basic Employee Info) |
6-11 | 6 | Used as Employee ID (unless using SSN for empl ID) and PR Service Empl ID | |
| 4 | Not Used | 12-31 | 20 | Blanks | |
| 5 | Misc Employee Data
(Salary Info and History) |
32 | 1 |
1 or 6 = Non exempt, Hourly Employee, Rate included is hourly 4 or 7 = Exempt, Salary Employee, Rate included is salary Anything else = Exempt, Salary Employee, Rate included is annual |
|
| 6 | Rate
(Salary Info and History) |
33-41 | 9 | Decimal included. Based on value above, could be hourly, salary or annual rate | |
| 7 | Effective Date
(Salary Info and History) |
42-49 | 8 | Format: MM/DD/YY | Defaults to Hire date if not supplied. |
| 8 | Not Used | 104-111 | 8 | Format: MM/DD/YY | |
| 9 | Date 6
(Basic Employee Info) |
104-111 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 10 | Date 7
(Basic Employee Info) |
112-119 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 11 | Date 8
(Basic Employee Info) |
120-127 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 12 | Date 9
(Basic Employee Info) |
128-135 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 13 | Date 10
(Basic Employee Info) |
136-143 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 14 | Date 11
(Basic Employee Info) |
144-151 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 15 | Date 12
(Basic Employee Info) |
152-159 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 16 | Date 13
(Basic Employee Info) |
160-167 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 17 | Date 14
(Basic Employee Info) |
168-175 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
| 18 | Date 15
(Basic Employee Info) |
176-183 | 8 | Format: MM/DD/YY | The ADP date locations screen parameters can used to refer to this date as the Hire Date, Birth Date or neither. |
Record 3
| Field | Field Name | Columns | Size | Contents | Notes |
|---|---|---|---|---|---|
| 1 | ADP Record Number | 1-2 | 2 | '03' | |
| 2 | Not Used | 3-5 | 3 | Blanks | |
| 3 | ADP File Number
(Basic Employee Info) |
6-11 | 6 | Used as Employee ID (unless using SSN for empl ID) and PR Service Empl ID | |
| 4 | Not Used | 12-18 | 7 | Blanks | |
| 5 | Work State Code (Salary Info and History) | 19-20 | 2 | Based on table below | |
| 6 | Not Used | 21-41 | 21 | Blanks | |
| 7 | Marital Status
(Basic Employee Info) |
42 | 1 |
R, S, T = Single M, N, X, Y = Married |
|
| 8 | Not Used | 43-70 | 28 | Blanks |
Work State Codes
|
00 = '' 01 = 'NJ' 02 = 'MA' 03 = 'AL' 04 = '' 05 = 'MD' 06 = 'VI' 07 = 'DC' 08 = 'DE' 09 = 'NY' 10 = 'AK' 11 = 'NJ' 12 = 'NC' 13 = 'VT' 14 = 'AL' 15 = 'CO' 16 = 'GU' 17 = 'VA' 18 = 'AR' 19 = 'NY' 20 = 'MN' 21 = 'NJ' 22 = '' 23 = 'GA' 24 = 'LA' 25 = 'CA' 26 = 'WV' 27 = 'CT' 28 = 'UT' 29 = 'PR' 30 = 'OH' 31 = 'KY' 32 = 'RI' |
34 = 'PR' 35 = 'SC' 36 = 'OK' 37 = 'AZ' 38 = '' 39 = 'HI' 40 = 'PA' 41 = 'MT' 42 = 'FL' 43 = 'IL' 44 = 'KS' 45 = 'ME' 46 = 'MS' 47 = 'NE' 48 = 'NV' 49 = '' 50 = 'RI' 51 = 'SD' 52 = 'TN' 53 = 'TX' 54 = 'WA' 55 = '' 56 = 'NY' 57 = '' 58 = 'NH' 59 = 'PA' 60 = 'MI' 61 = 'NY' 62 = 'MT' 63 = 'AK' 64 = '' 65 = '' 66 = '' |
67 = '' 68 = '' 69 = '' 70 = '' 71 = '' 72 = '' 73 = '' 74 = '' 75 = 'CA' 76 = '' 77 = '' 78 = 'NY' 79 = '' 80 = '' 81 = '' 82 = '' 83 = '' 84 = '' 85 = 'NJ' 86 = 'IA' 87 = 'WI' 88 = 'HI' 89 = 'IN' 90 = 'MO' 91 = '' 92 = 'ND' 93 = 'OR' 94 = 'ID' 95 = 'WY' 96 = '' 97 = '' 98 = '' 99 = '' |