| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Column | Label | Importance | Format | Sample | Description |
2 | 1 | Import Student ID | Required | VARCHAR(30) | MSHS-105310 | The unique student identifier matching the Import Student ID in studemo.txt. |
3 | 2 | State Student ID | Highly Recommended | VARCHAR(30) | MD-MSHS-105310 | A unique student identifier for state data reporting. In this import, this ID is used solely for visual troubleshooting. |
4 | 3 | Student Last Name | Required | VARCHAR(200) | Miller | The student's last name. In this import, this field is used solely for visual troubleshooting. |
5 | 4 | Student First Name | Required | VARCHAR(200) | Isabella | The student's first name. In this import, this field is used solely for visual troubleshooting. |
6 | 5 | Student Middle Name | Highly Recommended | VARCHAR(200) | James | The student's middle name. In this import, this field is used solely for visual troubleshooting. |
7 | 6 | Birth Date | Required | MM/DD/YYYY | 01/07/2010 | The student's date of birth. In this import, this field is used solely for visual troubleshooting. |
8 | 7 | Program ID | Required | VARCHAR(30) | 1 | The code key value of the Program, as found in Student Programs code table. These values are various and may change per state or district. Visit code management (Admin Gear -> Code Management, and choose "Student Programs") to view and manage your current codes. |
9 | 8 | Eligibility Start Date | Conditionally Required | MM/DD/YYYY | 01/05/2019 | Used to identify when a student was eligible for a program. It does not necessarily need to match the dates of when a student actually began participation in the program. Either this field or the program start date must be entered to create a unique record; program start date is preferred. |
10 | 9 | Eligibility End Date | Optional | MM/DD/YYYY | 05/05/2019 | Used to identify when a student was no longer eligible for a program. |
11 | 10 | Program Start Date | Conditionally Required | MM/DD/YYYY | 01/05/2019 | Identifies the date that the student first entered the program. The Program Start Date must align to other key dates in Illuminate such as term dates and student enrollment dates. Either this field or the eligibility start date must be entered to create a unique record; this field is preferred. |
12 | 11 | Program End Date | Highly Recommended | MM/DD/YYYY | 05/05/2019 | Used to identify when a student has exited a program. This is not a required field, however, without it students will never exit a program. It is a very important field to help to establish students time in programs. The Program End Date should represent the date a student's participation in the program ended. |
13 | 12 | Academic Year | Required | YYYY|YYYY-YYYY | 2019-2020 | Required to identify the academic year to which the student data belongs. Generally, after historic data loads and for regular automation, the Academic Year field simply identifies the current academic year. This is a sanity check field that may be removed in the future. |
14 | 13 | Program Eligibility Code | Optional | VARCHAR(30) | 1 | Identifies how a student was identified to be eligible for participation in a program. Code Key value, as found in Program Eligibility Codes code table. These values are various and may change per state or district. Visit code management (Admin Gear -> Code Management, and choose "Program Eligibility Codes" to view and manage your current codes. |
15 | 14 | Program Exit Code | Optional | VARCHAR(30) | E410 | Identifies why a student exited a program. Code Key value, as found in Program Exit Codes code table. These values are various and may change per state or district. Visit code management (Admin Gear -> Code Management, and choose "Program Exit Codes" to view and manage your current codes. |
16 | 15 | Site ID | Optional | INT(1) | 1 | Identifies which site a student is at when they are receiving program services. This site/program association has been identified as a requirement in the state of California for state reporting. When the Site ID is provided, it is also part of the unique key on a program record.contacts.txt |
17 | ||||||
18 | ||||||
19 | ||||||
20 | ||||||
21 | ||||||
22 | ||||||
23 | ||||||
24 | ||||||
25 | ||||||
26 | ||||||
27 | ||||||
28 | ||||||
29 | ||||||
30 | ||||||
31 | ||||||
32 | ||||||
33 | ||||||
34 | ||||||
35 | ||||||
36 | ||||||
37 | ||||||
38 | ||||||
39 | ||||||
40 | ||||||
41 | ||||||
42 | ||||||
43 | ||||||
44 | ||||||
45 | ||||||
46 | ||||||
47 | ||||||
48 | ||||||
49 | ||||||
50 | ||||||
51 | ||||||
52 | ||||||
53 | ||||||
54 | ||||||
55 | ||||||
56 | ||||||
57 | ||||||
58 | ||||||
59 | ||||||
60 | ||||||
61 | ||||||
62 | ||||||
63 | ||||||
64 | ||||||
65 | ||||||
66 | ||||||
67 | ||||||
68 | ||||||
69 | ||||||
70 | ||||||
71 | ||||||
72 | ||||||
73 | ||||||
74 | ||||||
75 | ||||||
76 | ||||||
77 | ||||||
78 | ||||||
79 | ||||||
80 | ||||||
81 | ||||||
82 | ||||||
83 | ||||||
84 | ||||||
85 | ||||||
86 | ||||||
87 | ||||||
88 | ||||||
89 | ||||||
90 | ||||||
91 | ||||||
92 | ||||||
93 | ||||||
94 | ||||||
95 | ||||||
96 | ||||||
97 | ||||||
98 | ||||||
99 | ||||||
100 |