McKay Prepayment Verification


Database Requirements Index Page
PK-12 Education Information Services Home Page

2018-2019 McKay Prepayment Verification Format

  1. This format is used for the verification of eligibility of students who receive McKay Scholarships - prior to the payment of the scholarship each quarter.
  2. Submit this record for reporting periods A, B, C and D for each student in dataset DPSxx.GQ.F70561.Yyyyys created by the Department of Education prior to the designated survey period. (‘xx’ indicates the district number, ‘yyyy’ indicates the school year and ‘s’ indicates the survey period.)
  3. ENTRY (RE-ENTRY) DATE and WITHDRAWAL DATE: The initial pre-payment eligibility verification file (DPSxx.GQ.F70561.Yyyyys) will contain zeroes in these date fields. School districts must insert either an Entry/ (Re-entry) Date (if the student is currently enrolled in a public school) or a Withdrawal Date (if student is not currently enrolled in a public school) (not both) and submit the file to NWRDC under the appropriate file name. All date fields should be in the MMDDYYYY format. The dates must be valid dates greater than (after) May 1, 2000.
  4. STUDENTS NEVER ENROLLED: For students never enrolled in the school district all nines (99999999) should be entered in both the Entry (Re-entry) Date and Withdrawal Date fields.
  5. UPDATES ONLY: All records submitted to the data base will be processed as updates. No records may be added or deleted from the McKay Prepayment Verification data base table.
  6. Key Fields: The key fields for this format are item numbers 1, 5, 20 and 21.

' * ' indicates key fields. (Click on the link to view or download a pdf version of the document)

Item No.
From-To
Size
Field Description


2
3-14
12
A/N


4
19-61
43
A/N


6
72-88
17
A/N/L

7
89-100
12
A/N/L

8
101-102
2
A/N

9
103-105
3
N

10
106-109
4
N

11
110-113
4
N

12
114-116
3
N

13
117-120
4
N

14
121-124
4
N

15
125-130
6
A/N


17
135-142
8
A/N

18
143-150
8
A/N

19
151-151
1
A

20
152-155
4
N

21
156-156
1
A/N

22
157-157
1
A


24
159-159
1
A



27
162-162
1
A

28
163-165
3
A/N

29
166-169
4
N

30
170-173
4
N


32
184-218
35
A/N
Filler

33
219-232
14
A/N

34
233-240
8
A/N
Error Codes

Last Updated: 7/1/2018