NetPay
File Format
The following is the file format created by the the NetPay extract:
|
Field |
Field Name |
Required |
Start |
Length |
Data Type |
Justify |
Padding |
|
Header Record (HR) |
|||||||
|
1 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
2 |
Sender-ID-Number |
M |
3 |
9 |
PIC X(09) |
- |
N/A |
|
3 |
Recipient-ID-Number |
M |
12 |
9 |
PIC X(09) |
- |
N/A |
|
4 |
School-ID |
M |
21 |
9 |
PIC X(09) |
- |
N/A |
|
5 |
File-Creation-Date |
M |
30 |
8 |
PIC 9(08) |
- |
N/A |
|
6 |
File-Creation-Time |
M |
38 |
6 |
PIC 9(06) |
- |
N/A |
|
7 |
File-Identifier-Code |
M |
44 |
1 |
PIC X(01) |
- |
N/A |
|
8 |
Data-Type-Code |
M |
45 |
2 |
PIC X(02) |
- |
N/A |
|
9 |
Number-Inserts |
C |
47 |
1 |
PIC 9(01) |
- |
N/A |
|
10 |
Print-Service |
C |
48 |
2 |
PIC X(02) |
- |
N/A |
|
11 |
Filler1 |
M |
50 |
28 |
PIC X(28) |
- |
N/A |
|
12 |
School-Name |
O |
78 |
30 |
PIC X(30) |
- |
N/A |
|
13 |
School-Inquiry-Contact |
O |
108 |
30 |
PIC X(30) |
- |
N/A |
|
14 |
Filler1 |
M |
138 |
183 |
PIC X(183) |
- |
- |
|
Student Record (01) |
|||||||
|
15 |
Record-Type Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
16 |
Payment-Type |
M |
3 |
2 |
PIC X(02) |
- |
N/A |
|
17 |
Notice-Type |
M |
5 |
40 |
PIC X(40) |
Left |
Spaces |
|
18 |
Student-Account-Number |
M |
45 |
16 |
PIC X(16) |
Left |
Spaces |
|
19 |
Student-Last-Name |
M |
61 |
35 |
PIC X(35) |
Left |
Spaces |
|
20 |
Student-First-Name |
M |
96 |
25 |
PIC X(25) |
Left |
Spaces |
|
21 |
Student-Middle-Initial |
O |
121 |
01 |
PIC X(01) |
Left |
Spaces |
|
22 |
Student-Address1 |
M |
122 |
40 |
PIC X(40) |
Left |
Spaces |
|
23 |
Student-Address2 |
O |
162 |
40 |
PIC X(40) |
Left |
Spaces |
|
24 |
Student-City |
M |
202 |
25 |
PIC X(25) |
Left |
Spaces |
|
25 |
Student-State |
M |
227 |
2 |
PIC X(02) |
- |
N/A |
|
26 |
Student-Zip |
M |
229 |
5 |
PIC X(04) |
- |
N/A |
|
27 |
Student-Zip+4 |
O |
234 |
4 |
PIC X(05) |
Left |
Left |
|
28 |
Student-Country |
C |
238 |
25 |
PIC X(25) |
Left |
Left |
|
29 |
Student-Care-Of |
O |
263 |
50 |
PIC X(50) |
Left |
Left |
|
30 |
Student-DOB |
C1 |
313 |
8 |
PIC X(08) |
Left |
Left |
|
Billing Record (02) |
|||||||
|
31 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
32 |
Billing-Date |
M |
3 |
15 |
PIC X(15) |
Left |
Spaces |
|
33 |
Billing-Amount-Due |
M |
18 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
34 |
Billing-Due-Date |
M |
26 |
15 |
PIC X(15) |
Left |
Spaces |
|
|
Billing-Due-Buckets |
|
|
|
|
|
|
|
35 |
Billing-Due-Buckets-Current |
O |
41 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
36 |
Billing-Due-Buckets-Pastdue- 31-60 |
O |
49 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
37 |
Billing-Due-Buckets-Pastdue-61-90 |
O |
57 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
38 |
Billing-Due-Buckets- Pastdue-91-150 |
O |
65 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
39 |
Billing-Due-Buckets-Pastdue- over-150 |
O |
73 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
40 |
Billing-Previous-Balance |
O |
81 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
41 |
Billing-Current-Balance |
O |
89 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
42 |
Billing-School-Specific-Amt1 |
O |
97 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
43 |
Billing-School-Specific-Amt2 |
O |
105 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
44 |
Billing-School-Specific-Amt3 |
O |
113 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
45 |
Billing-School-Specific-data1 |
O |
121 |
10 |
PIC X(10) |
Left |
Spaces |
|
46 |
Billing-School-Specific-data2 |
O |
131 |
10 |
PIC X(10) |
Left |
Spaces |
|
47 |
Billing-School-Specific-data3 |
O |
141 |
10 |
PIC X(10) |
Left |
Spaces |
|
48 |
Eligilibity-Indicator |
O |
151 |
01 |
PIC X(01) |
Left |
Spaces |
|
49 |
Student-Phone1 |
O |
152 |
10 |
PIC X(10) |
Left |
Spaces |
|
50 |
Student-Phone2 |
O |
162 |
10 |
PIC X(10) |
Left |
Spaces |
|
51 |
Student-Email |
O |
172 |
50 |
PIC X(50) |
Left |
Spaces |
|
52 |
Filler1 |
M |
222 |
99 |
PIC X(99) |
- |
- |
|
Detail Record (03) |
|||||||
|
53 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
54 |
Semester-Term |
O |
3 |
15 |
PIC X(15) |
Left |
Spaces |
|
55 |
Detail-Date |
O |
18 |
10 |
PIC X(10) |
Left |
Spaces |
|
56 |
Detail-Description |
O |
28 |
35 |
PIC X(35) |
Left |
Spaces |
|
57 |
Detail-Charges |
O |
63 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
58 |
Detail-Credit |
O |
71 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
59 |
Detail-Notes |
O |
79 |
15 |
PIC X(15) |
Left |
Spaces |
|
60 |
Detail-Type |
O |
94 |
2 |
PIC X(02) |
- |
N/A |
|
61 |
Detail Balance |
O |
96 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
62 |
Detail-Min-Due |
O |
104 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
63 |
Detail-Additional-Description |
O |
112 |
45 |
PIC X(45) |
Left |
Spaces |
|
64 |
Filler1 |
M |
157 |
164 |
PIC X(164) |
- |
- |
|
Notice-Record (04) |
|||||||
|
65 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
66 |
Notice-Text |
O |
3 |
90 |
PIC X(90) |
Left |
Spaces |
|
67 |
Filler1 |
M |
93 |
228 |
PIC X(228) |
- |
- |
|
Comment Record (05) |
|||||||
|
68 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
69 |
Comment-Text |
O |
3 |
90 |
PIC X(90) |
Left |
Spaces |
|
70 |
Comment-Type |
M |
93 |
2 |
PIC X(02) |
? |
? |
|
71 |
Filler1 |
|
95 |
226 |
PIC X(226) |
- |
- |
|
Alternate-Address-Record (06) |
|||||||
|
72 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
73 |
Student-Account-Number |
C |
3 |
16 |
PIC X(16) |
Left |
Spaces |
|
74 |
Alt-Last-Name |
C |
19 |
35 |
PIC X(35) |
Left |
Spaces |
|
75 |
Alt-First-Name |
C |
54 |
25 |
PIC X(25) |
Left |
Spaces |
|
76 |
Alt-Middle-Name |
O |
79 |
1 |
PIC X(01) |
Left |
Spaces |
|
77 |
Alt-Address1 |
C |
80 |
40 |
PIC X(40) |
Left |
Spaces |
|
78 |
Alt-Address2 |
O |
120 |
40 |
PIC X(40) |
Left |
Spaces |
|
79 |
Alt-City |
C |
160 |
25 |
PIC X(25) |
Left |
Spaces |
|
80 |
Alt-State |
C |
185 |
2 |
PIC X(02) |
- |
N/A |
|
81 |
Alt-Zip |
C |
187 |
5 |
PIC 9(05) |
- |
N/A |
|
82 |
Alt-Zip+4 |
O |
192 |
4 |
PIC 9(04) |
Right |
Zeros |
|
83 |
Country |
C |
196 |
25 |
PIC X(25) |
Left |
Spaces |
|
84 |
Alt-Care-Of |
O |
221 |
50 |
PIC X(25) |
Left |
Spaces |
|
85 |
Alt-Name-Prefix |
O |
271 |
15 |
PIC X(15) |
Left |
Spaces |
|
86 |
Alt-Name-Suffix |
O |
286 |
05 |
PIC X(05) |
Left |
Spaces |
|
87 |
Filler1 |
M |
291 |
30 |
PIC X(30) |
- |
- |
|
Trailer Record (TR) |
|||||||
|
88 |
Record-Type-Code |
M |
1 |
2 |
PIC X(02) |
- |
N/A |
|
89 |
Student-Record-Count |
M |
3 |
5 |
PIC 9(05) |
Right |
Zeros |
|
90 |
Bill-Record-Count |
M |
8 |
5 |
PIC 9(05)8 |
Right |
Zeros |
|
91 |
05 File-Creation-Date |
M |
13 |
8 |
PIC 9(08) |
- |
- |
|
92 |
05 File-Creation-Time |
M |
21 |
6 |
PIC 9(06) |
- |
- |
|
93 |
05 Filler1 |
M |
27 |
294 |
PIC X(294) |
- |
- |
|
Note: M = The field is mandatory with all file submissions. C = The field may be required if certain business conditions exist, as outlined in the field descriptions, at the time of file submission. O = The fields is optional for all file submissions |
|||||||
|
A single carriage return must be placed at the end of each record contained in the file. 1 This field is reserved for future use |
|||||||