% Delimited Consolidated Deduction Detail File Definition

File Type

% Delimited Consolidated Deduction Reporting File layout

Used For

Reporting Deductions Processed to Vendors

Used By

By Vendors Participating in Consolidated Reporting Process

NAME DESCRIPTION

DEDUCTION DETAIL RECORD

DEDUCTION TOTAL RECORD

DEDUCTION DETAIL RECORD

FIELD LABEL

POSITION

SIZE

COMMENTS / RANGE OF VALUES

FIRST

LAST

PAY CYCLE

1

1

A1

PAY CYCLE OF PAYROLL

PERCENT DELIMITER

2

2

A1

%

DEDUCTION CODE

3

6

N4

THE DEDUCTION CODE BEING REPORTED FOR THIS EMPLOYEE IN THIS FILE

PERCENT DELIMITER

7

7

A1

%

SOCIAL SECURITY NUMBER

8

16

A9

SOCIAL SECURITY NUMBER OF EMPLOYEE

PERCENT DELIMITER

17

17

A1

%

LAST NAME

18

39

A22

EMPLOYEE LAST NAME

PERCENT DELIMITER

40

40

A1

%

FIRST NAME

41

56

A16

EMPLOYEE FIRST NAME

PERCENT DELIMITER

57

57

A1

%

MIDDLE INITIAL

58

58

A1

EMPLOYEE MIDDLE INITIAL

PERCENT DELIMITER

59

59

A1

%

ORGANIZATIONAL CODE

60

70

N11

ORGANIZATIONAL CODE

PERCENT DELIMITER

71

71

A1

%

WARRANT NUMBER

72

78

N7

WARRANT NUMBER ASSIGNED TO THE PAYROLL RECORD FROM WHICH THE EMPLOYEE DEDUCTION WAS TAKEN

PERCENT DELIMITER

79

79

A1

%

WARRANT DATE

80

87

N8

CCYYMMDD - THE NEGOTIABLE DATE OF THE EMPLOYEE'S WARRANT & ANY RELATED DEDUCTION OR CONSOLIDATED DEDUCTION WARRANTS

PERCENT DELIMITER

88

88

A1

%

SIGN AND DEDUCTION AMOUNT

89

103

A15

-99999999999.99 - THE AMOUNT DEDUCTED FROM THE EMPLOYEE'S GROSS SALARY FOR THIS PAYROLL. A SIGN FIELD IS LOCATED IN POSITION 89.
NEGATIVE AMOUNT = -
POSITIVE AMOUNT = BLANK

DEDUCTION TOTAL RECORD

FIELD LABEL

POSITION

SIZE

COMMENTS / RANGE OF VALUES

FIRST

LAST

PAY CYCLE

1

1

A1

"T" FOR THE TOTALS RECORD

PERCENT DELIMITER

2

2

A1

%

DEDUCTION CODE

3

6

N4

THE DEDUCTION CODE BEING REPORTED

PERCENT DELIMITER

7

7

A1

%

SOCIAL SECURITY NUMBER

8

16

A9

FOR THE TRAILER RECORD THIS WILL ALWAYS BE 999999999

PERCENT DELIMITER

17

17

A1

%

DEDUCTION DESCRIPTION

18

39

A22

SHORT DESCRIPTION

PERCENT DELIMITER

40

40

A1

%

FILLER

41

56

A16

SPACE FILLED

PERCENT DELIMITER

57

57

A1

%

FILLER

58

58

A1

SPACE FILLED

PERCENT DELIMITER

59

59

A1

%

FILLER

60

70

A11

SPACE FILLED

PERCENT DELIMITER

71

71

A1

%

DETAIL RECORD COUNT

72

78

N7

THE TOTAL NUMBER OF DETAIL RECORDS FOR THIS DEDUCTION

PERCENT DELIMITER

79

79

A1

%

FILLER

80

87

A8

SPACE FILLED

PERCENT DELIMITER

88

88

A1

%

SIGN AND DEDUCTION TOTAL

89

103

A15

-99999999999.99 - THE TOTAL OF THE AMOUNTS IN THE DETAIL RECORDS FOR THIS DEDUCTION. A SIGN CHARACTER IS LOCATED IN POSITION 89.
NEGATIVE AMOUNT = -
POSITIVE AMOUNT = SPACE