Appendix > Appendix > Format Requirements for the Import/Export Feature > Payroll Format Requirements for Importing Data
Payroll Format Requirements for Importing Data
Before you begin to import data, you need to make sure the text file is in the proper format and that all required fields have entries. If the external file is properly formatted, it will help eliminate the possibility of errors.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Length
Character Position (Fixed-Length Format)
Data Type
1
* Employee Number
25
1
Char-Caps
2
* First Name
20
26
Character
3
Middle Initial
1
46
Char-Caps
4
* Last Name
20
47
Character
5
* Department or Program Code
 
10
67
Char-Caps
6
* Status Code
10
77
Char-Caps
7
* Social Security Number
13
87
Numeric
8
* Pay Type
1
100
0 - Hourly
1 - Salary
3- Combined
5 - Piece Work
9
* Marital Status
1
101
0- Single
1- Married filing separately
2- Head of household
3- Married filing jointly
10
* Pay Frequency
3
102
365 - Daily
52 - Weekly
26 - Bi-weekly
24 - Semi-monthly
12 - Monthly
4 - Quarterly
2 - Semi-annually
1 - Annually
11
Position
50
105
Character
12
Address Line 1
50
155
Character
13
Address Line 2
50
205
Character
14
City
20
255
Character
15
State
2
275
Char-Caps
16
ZIP Code
15
277
Numeric
17
Phone Number
15
292
Numeric (xxx) xxx-xxxx
18
Cell Phone Number
15
307
Numeric (xxx) xxx-xxxx
19
Birth Date
10
322
Numeric (mm/dd/yyyy)
20
Hire Date
10
332
Numeric (mm/dd/yyyy)
21
Seniority Date
10
342
Numeric (mm/dd/yyyy)
22
Termination Date
10
352
Numeric (mm/dd/yyyy)
23
Last Raise Date
10
362
Numeric (mm/dd/yyyy)
24
Emergency Contact
50
372
Character
25
Emergency Contact Phone
15
422
Numeric (xxx) xxx-xxxx
26
Check Location
15
437
Character
27
Site Location
15
452
Character
28
Email Address
255
467
Character
1 This number is for reference purposes only and will not appear in the actual text file.

 
 
 
Published date: 12/03/2021