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
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 = ''

Parent Topic:

Input File Layout