|
|
|
File Number |
F0023 Consolidated Deduction Reporting File layout |
|
Used For |
Reporting Deductions Processed to Vendors |
|
Used By |
By Vendors Participating in Consolidated Reporting Process |
FILE ORGANIZATION
The file can contain up to the following
three record formats:
|
FORMAT NUMBER |
NAME DESCRIPTION |
|
F0023.0001 |
BEGINNING CONTROL RECORD |
|
F0023.0002 |
DEDUCTION DETAIL RECORD |
|
F0023.0008 |
DEDUCTION TOTAL RECORD |
IMPORTANT INFORMATION: AN EMPTY FILE WILL
CONTAIN A BEGINNING CONTROL RECORD (0001) AND DEDUCTION TOTAL RECORD (0008),
THIS IS FOR INTERNAL SYSTEMS
|
F0023.0001 BEGINNING CONTROL RECORD |
||||
|
POSITION |
SIZE |
COMMENTS / RANGE OF VALUES |
||
|
FIRST |
LAST |
|||
|
RECORD TYPE CODE |
1 |
4 |
N4 |
RECORD IDENTIFIER-VALUE 0001 |
|
PAY CYCLE |
5 |
5 |
A1 |
B=BIWEEKLY M=MONTHLY S=SUPPLEMENTAL C=CANX AND ADJ FILE |
|
DEDUCTION CODE RANGE |
6 |
13 |
A8 |
RANGE OF CODES APPEARING ON FILE, LOWEST AND HIGHEST |
|
TAPE SEQUENCE CODE |
14 |
15 |
A2 |
INTERNAL SYSTEMS USE |
|
FILLER |
16 |
188 |
A173 |
SPACE FILLED |
|
PAY PERIOD BEGINNING DATE |
189 |
194 |
N6 |
PAY PERIOD BEGINNING DATE FORMAT: MMDDYY |
|
PAY PERIOD ENDING DATE |
195 |
200 |
N6 |
PAY PERIOD ENDING DATE FORMAT: MMDDYY |
|
F0023.0002 DEDUCTION DETAIL RECORD |
||||
|
FIELD LABEL |
POSITION |
SIZE |
COMMENTS / RANGE OF VALUES |
|
|
FIRST |
LAST |
|||
|
RECORD TYPE CODE |
1 |
4 |
N4 |
RECORD IDENTIFIER-VALUE 0002 |
|
PAY CYCLE |
5 |
5 |
A1 |
PREVIOUSLY DEFINED. SEE F0023.0001 |
|
DEDUCTION CODE |
6 |
9 |
N4 |
THE DEDUCTION CODE BEING REPORTED FOR THIS EMPLOYEE IN THIS FILE |
|
SOCIAL SECURITY NUMBER |
10 |
18 |
N9 |
SOCIAL SECURITY NUMBER OF THE EMPLOYEE |
|
LAST NAME |
19 |
34 |
A16 |
EMPLOYEE LAST NAME |
|
FIRST NAME |
35 |
50 |
A16 |
EMPLOYEE FIRST NAME |
|
MIDDLE INITIAL |
51 |
51 |
A1 |
EMPLOYEE MIDDLE INITIAL |
|
COUNTY CODE |
52 |
53 |
N2 |
CODE OF EMPLOYEES HEADQUARTERS COUNTY |
|
CLASS CODE |
54 |
57 |
N4 |
CLASSIFICATION OF POSITION ACCORDING TO PERSONNEL RULES OF THE APPROPRIATE PAY PLAN |
|
FLAIR ACCOUNT CODE |
58 |
86 |
N29 |
FLAIR ACCOUNT CODE FROM WHICH THIS DISBURSEMENT IS MADE |
|
FLAIR ORGANIZATIONAL CODE |
87 |
97 |
N11 |
LEVELS 1 THROUGH 5 OF PAYROLL
ORGANIZATIONAL CODE |
|
FILLER |
98 |
99 |
A2 |
ZERO FILLED BY ALL AGENCIES EXCEPT THE STATE UNIVERSITY SYSTEM |
|
INTRA DEPARTMENT NUMBER |
100 |
109 |
N10 |
INTRA-AGENCY CODE FOR LOCATION OF POSITION OF EMPLOYEE OR AGENCY ACCOUNTING AND DISTRIBUTION PURPOSES |
|
VOUCHER NUMBER |
110 |
116 |
N7 |
VOUCHER NUMBER ASSIGNED BY THE COMPTROLLER=S OFFICE |
|
VOUCHER DATE |
117 |
122 |
N6 |
THE ACCOUNTING VOUCHER DATE ASSIGNED BY
THE COMPTROLLER=S OFFICE FOR THIS PAYROLL.. FORMAT: MMDDYY |
|
WARRANT NUMBER |
123 |
129 |
N7 |
WARRANT NUMBER ASSIGNED TO THE PAYROLL RECORD FROM WHICH THE EMPLOYEE DEDUCTION WAS TAKEN AND, IF APPLICABLE, AGAINST WHICH THE EMPLOYER=S CONTRIBUTION WAS CHARGED |
|
WARRANT DATE |
130 |
135 |
N6 |
THE NEGOTIABLE DATE OF THE EMPLOYEE=S WARRANT & ANY RELATED DEDUCTION OR CONSOLIDATED DEDUCTION WARRANTS. MMDDYY |
|
EMPLOYEE DEDUCTION AMOUNT |
136 |
144 |
N9 |
THE AMOUNT DEDUCTED FROM THE EMPLOYEE=S GROSS SALARY FOR THIS PAYROLL. FORMAT: 7.2 |
|
STATE CONTRIBUTION |
145 |
153 |
N9 |
ZERO FILLED (USED FOR RETIREMENT) |
|
STACK INDICATOR |
154 |
156 |
N3 |
COMPTROLLER' S INTERNAL REPORTING MECHANISM |
|
PAY PLAN |
157 |
158 |
N2 |
EMPLOYEE PAY PLAN |
|
POSITION NUMBER |
159 |
164 |
N6 |
ZERO FILLED (USED FOR RETIREMENT) |
|
RETIREMENT GROSS |
165 |
173 |
N9 |
ZERO FILLED (USED FOR RETIREMENT) |
|
FILLER |
174 |
200 |
A27 |
SPACE FILLED |
|
F0023.0008 DEDUCTION TOTAL RECORD |
||||
|
FIELD LABEL |
POSITION |
SIZE |
COMMENTS / RANGE OF VALUES |
|
|
FIRST |
LAST |
|||
|
RECORD TYPE CODE |
1 |
4 |
N4 |
RECORD IDENTIFIER-VALUE 0008 |
|
FILLER |
5 |
5 |
A1 |
SPACE FILLED |
|
DEDUCTION CODE |
6 |
9 |
N4 |
PREVIOUSLY DEFINED. SEE F0023.0002 |
|
FILLER |
10 |
18 |
A9 |
SPACE FILLED |
|
DEDUCTION DESCRIPTION |
19 |
51 |
A33 |
DEDUCTION DESCRIPTION. THIS FIELD CONTAINS THE PAYEE NAME AS IT APPEARS ON CONSOLIDATED DEDUCTION REPORTING WARRANTS |
|
FILLER |
52 |
116 |
A65 |
SPACE FILLED |
|
VOUCHER DATE |
117 |
122 |
N6 |
PREVIOUSLY DEFINED. SEE F0023.0002 |
|
CONSOLIDATED DEDUCTION WARRANT NUMBER |
123 |
129 |
N7 |
WARRANT NUMBER ASSIGNED TO THE CONSOLIDATED DEDUCTION WARRANT FOR THIS DEDUCTION CODE FOR EMPLOYEE AMOUNTS PRESENTED TO THE VENDOR WITH THIS FIELD |
|
WARRANT DATE |
130 |
135 |
N6 |
PREVIOUSLY DEFINED. SEE F0023.0002 |
|
EMPLOYEE DEDUCTION TOTAL |
136 |
144 |
N9 |
TOTAL OF ALL EMPLOYEE DEDUCTIONS FOR THIS CODE FORMAT: 7.2 |
|
STATE CONTRIBUTION WARRANT DATE |
145 |
160 |
N16 |
APPLICABLE ONLY TO RETIREMENT, NOT FOR
THIS FILE. ZERO FILLED |
|
DETAIL RECORD COUNT |
161 |
167 |
N7 |
THE NUMBER OF DETAIL RECORDS REPORTED FOR THIS DEDUCTION CODE |
|
FILLER |
168 |
200 |
A33 |
SPACE FILLED |
FORMAT A: ALPHANUMERIC N: NUMERIC