1 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
---|---|---|---|---|---|---|
2 | 1 | Site ID | Integer | Y | Must be unique, key identifier for sites. | Y |
3 | 2 | Site Name | Text | Y | Y | |
4 | 3 | State Site ID | Integer | Y | State assigned school ID | Y |
5 | 4 | Start Grade Level ID | Integer | Y | Y | |
6 | 5 | End Grade Level ID | Integer | Y | Y | |
7 | 6 | Site Type ID | Integer | Y | 1=Middle and K-8 School, 2=High School, 3=Continuation School, 4=Pre-School, 5=Adult Education Facilities, 6=Special Education Facilities, 7=Other Schools and Facilities, 8=District, 9=Elementary School, 10=CLOSED | Y |
8 | 7 | Address 1 | Text | N | N | |
9 | 8 | Address 2 | Text | N | N | |
10 | 9 | City | Text | N | N | |
11 | 10 | State | Text | Y | Y | |
12 | 11 | Zip | Text | N | 5 digits or 5+4 acceptable | N |
13 | 12 | Local Site Code | Text | N | An optional local identifier for each site. Possibly a district school code, which may not be an integer. | N |
14 | 13 | Annual Hours of Instruction | Integer | N | Per site, the annual number of hours. Only a requirement for ISE installations. | N |
15 | 14 | Annual # Weeks of Instruction | Integer | N | Per site, the annual number of weeks of instruction. Only a requirement for ISE installations. | N |
16 | 15 | Parent Site ID | Integer | N | Establishes the site hierarchy. Schools will typically point to the district as the parent. Districts can point to a county as a parent. | N |
1 | Please note: term import is required for initial setup but is not used for ongoing automation or yearly rollovers after a site has gone live. | |||||
---|---|---|---|---|---|---|
2 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
3 | 1 | Site ID | Integer | Y | Must match Site ID from sites.txt | Y |
4 | 2 | Term Name | Text | Y | Must be unique within the Site ID/Term Session | Y |
5 | 3 | Term Number | Integer | Y | Identifies the sequence of the term within the site. Combined with the site ID, this value creates a unique term for a given academic year. | Y |
6 | 4 | Term Start Date | Date/Time | Y | Y | |
7 | 5 | Term End Date | Date/Time | Y | Y | |
8 | 6 | Term Type | Integer | Y | 1=Year, 2=Semester, 3=Trimester, 4=Quarter | Y |
9 | 7 | Session Type ID | Integer | N | 1=Normal, 2=Summer, Defaults to 1 | Y |
10 | 8 | Academic Year | Academic Year | Y | Y | |
11 | 9 | Unique Term ID | Integer | N | A generated unique term identifier | N |
1 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
---|---|---|---|---|---|---|
2 | 1 | Course ID | Text | Y | A unique identifier for each course in the district | Y |
3 | 2 | Full Name | Text | Y | Y | |
4 | 3 | Short Name | Text | Y | Y | |
5 | 4 | Department Name | Text | N | A department or subject area for the course. | Y |
6 | 5 | Low Grade Level ID | Integer | Y | Note: Should match Grade Level ID from Grade Level Lookups. Grade Level ID = Value
1 = Kindergarten 2 = 1st Grade 3 = 2nd Grade 4 = 3rd Grade 5 = 4th Grade 6 = 5th Grade 7 = 6th Grade 8 = 7th Grade 9 = 8th Grade 10 = 9th Grade 11 = 10th Grade 12 = 11th Grade 13 = 12th Grade 14 = Graduated 15 = Pre-K | Y |
7 | 6 | High Grade Level ID | Integer | Y | Note: Should match Grade Level ID from Grade Level Lookups. Grade Level ID = Value
1 = Kindergarten 2 = 1st Grade 3 = 2nd Grade 4 = 3rd Grade 5 = 4th Grade 6 = 5th Grade 7 = 6th Grade 8 = 7th Grade 9 = 8th Grade 10 = 9th Grade 11 = 10th Grade 12 = 11th Grade 13 = 12th Grade 14 = Graduated 15 = Pre-K | Y |
8 | 7 | Site ID List | N | Comma separated list of site_ids where the course is available/offered | N | |
9 | 8 | Active | Integer | N | This is a boolean field. 0 = No, 1 = Yes, default: 1 | N |
10 | 9 | A-G Requirement Category | Text | N | Comma separated list of A-G Requirements based on priority | N |
11 | 10 | Course Weight | N | Acceptable values are: AP, H, CP. Indicates if the course is Advanced Placement, Honors, or College Prep. Within the course_weight_aff table, the weight field will be 'ap' for AP courses, 'honors' for Honors courses, and 'college_prep' for College Prep courses. | N | |
12 | 11 | Course Description | Text | N | N | |
13 | 12 | Credits Possible | N | N | ||
14 | 13 | Variable Credit Class | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N | |
15 | 14 | Maximum Credits | N | The maximum number of credits that are attainable by retaking the course. | N | |
16 | 15 | Special Education Course | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N | |
17 | 16 | Maximum Capacity | N | N | ||
18 | 17 | Intervention Course | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N | |
19 | 18 | NCLB Instructional Level | N | N | ||
20 | 19 | Course Content | N | N | ||
21 | 20 | Education Service | N | N | ||
22 | 21 | Instructional Strategy | N | N | ||
23 | 22 | Program Funding Source | N | N | ||
24 | 23 | CTE Funding Provider | N | N | ||
25 | 24 | Tech Prep | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N | |
26 | 25 | State Course ID | N | N | ||
27 | 26 | Is Non-Academic? | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N | |
28 | 27 | Non-Standard Instructional Level | N | N | ||
29 | 28 | Language of Instruction | N | N | ||
30 | 29 | Variable Credits Low | N | For variable credit courses, the lowest obtainable credits for the course. If Variable Credit Class (field 13) = 1, this is required. | N | |
31 | 30 | Variable Credits High | N | For variable credit courses, the highest obtainable credits for the course. If Variable Credit Class (field 13) = 1, this is required. | N | |
32 | 31 | State Course Name | Text | N | N | |
33 | 32 | Course Designation | Text | N | (LA Only) Acceptable values: AP, DA, DE, DI, GT, HR, IB, RG, SE, TA | N |
34 | 33 | Course Applicable Grades/Marks | Text | N | A comma separated list of the grades that should be made available for this course (A, B, C, D, F, etc.) | N |
1 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
---|---|---|---|---|---|---|
2 | 1 | User ID | Text | Y | A unique staff identifier | Y |
3 | 2 | User Last Name | Text | Y | Y | |
4 | 3 | User First Name | Text | Y | Y | |
5 | 4 | User Middle Name | Text | N | N | |
6 | 5 | Birth Date | Date | N | N | |
7 | 6 | Gender | Text | N | F=Female, M=Male, or blank | N |
8 | 7 | Email Address 1 | Text | N | User’s email address or blank | Y |
9 | 8 | Username | Text | N | User’s preferred username or blank | Y |
10 | 9 | Password | Text | N | User’s preferred password or blank | N |
11 | 10 | State User or Employee ID | Text | N | The educator’s assigned state ID* | Y |
12 | 11 | Name Suffix | Text | N | N | |
13 | 12 | Former First Name | Text | N | N | |
14 | 13 | Former Middle Name | Text | N | N | |
15 | 14 | Former Last Name | Text | N | N | |
16 | 15 | Primary Race Code | Text | N | Code value of user's primary race | N |
17 | 16 | Is Hispanic | Integer | N | This is a boolean field. 0 = not Hispanic, 1 = is Hispanic, Defaults to 0 | N |
18 | 17 | User Address | Text | N | N | |
19 | 18 | User City | Text | N | N | |
20 | 19 | User State | Text | N | All caps, 2 character state code | N |
21 | 20 | User Zip | Integer | N | N | |
22 | 21 | Job Title | Text | N | N | |
23 | 22 | Education Level Code | Text | N | Code value of user's education level | N |
24 | 23 | Hire Date | Date | N | N | |
25 | 24 | Exit Date | Date | N | N | |
26 | 25 | Is Active | Boolean | N | This is a boolean field. 0 = Not Active, 1 = Active, default: 1 | Y |
27 | 26 | Position Status | Text | N | N | |
28 | 27 | Total Years Educational Service | Integer | N | N | |
29 | 28 | Total Years in District | Integer | N | N | |
30 | 29 | Email Address 2 | Text | N | User's secondary email address | N |
31 | 30 | Phone 1 | Text | N | User's primary phone number | N |
32 | 31 | Phone 2 | Text | N | User's second phone number | N |
1 | Field | Data Type | Required | Notes | Strongly Recommended | |
---|---|---|---|---|---|---|
2 | 1 | Import Student ID | Text | Y | A unique student identifier | Y |
3 | 2 | State Student ID | Text | N | State assigned student identifier.* | Y |
4 | 3 | Student Last Name | Text | Y | Y | |
5 | 4 | Student First Name | Text | Y | Y | |
6 | 5 | Student Middle Name | Text | N | Y | |
7 | 6 | Birth Date | Date | Y | Y | |
8 | 7 | Gender | Text | Y | F=Female, M=Male, N=Neutral, or blank | Y |
9 | 8 | Race Code 1 | Text | N | Code value of student race 1 from the Ethnicity code table | Y |
10 | 9 | Race Code 2 | Text | N | Code value of student race 2 from the Ethnicity code table | N |
11 | 10 | Race Code 3 | Text | N | Code value of student race 3 from the Ethnicty code table | N |
12 | 11 | Is Hispanic1 | Boolean | N | This is a boolean field. 0 = not Hispanic, 1 = is Hispanic, default: 0 | N |
13 | 12 | Primary Language Code | Text | N | Code value of student primary language from the Language code table | Y |
14 | 13 | Correspondence Language Code | Text | N | Code value of student correspondence language from the Language code table | N |
15 | 14 | English Proficiency/Language Fluency Code | Text | N | Code value of student english proficiency status from the English Proficiency code table. This is where Illuminate tracks the status of English Learners. Most state reporting will pull from this field | Y |
16 | 15 | Redesignation Date | Date | N | Date an English Learner student was redesignated | Y |
17 | 16 | Primary Disability Code | Text | N | Code value of student primary disability from the Primary Disability code table or Student Programs code table | Y |
18 | 17 | Migrant Ed Student ID | Text | N | The student's Migrant Student Directory (MSD) number | N |
19 | 18 | English Learner/LEP Date | Date | N | Date student first entered EL program | Y |
20 | 19 | US Entry Date | Date | N | Date student entered the United States | Y |
21 | 20 | School Entry Date | Date | N | Date student first enrolled in their current school (school mobility) | Y |
22 | 21 | District Entry Date | Date | N | Date student first enrolled in the district (district mobility) | Y |
23 | 22 | Parent/Guardian Highest Education Level | Text | N | Code value of the student's parent/guardian highest level of education from the Parent Education code table | Y |
24 | 23 | Residential Status | String | N | Code value of student residential status from the Residential Status code table | N |
25 | 24 | Special Needs Status | Integer | N | 1 = Single Parent, 2 = Displaced Homemaker | N |
26 | 25 | SST Date | Date | N | N | |
27 | 26 | 504 Accommodations | Text | N | N | |
28 | 27 | 504 Annual Review Date | Date | N | N | |
29 | 28 | Special Ed Exit Date | Date | N | Date student exited Special Ed. | Y |
30 | 29 | Birth City | Text | N | Y | |
31 | 30 | Birth State | Text | N | Code value of state from the States code table | Y |
32 | 31 | Birth Country | Text | N | Code value of birth country from the Countries code table | Y |
33 | 32 | Lunch ID | Text | N | N | |
34 | 33 | Academic Year | Academic Year | Y | Y | |
35 | 34 | Student Name Suffix | Text | N | N | |
36 | 35 | Student Last Name Alias | Text | N | N | |
37 | 36 | Student First Name Alias | Text | N | N | |
38 | 37 | Student Middle Name Alias | Text | N | N | |
39 | 38 | Student Name Suffix Alias | Text | N | N | |
40 | 39 | Lunch Balance | Decimal (4,2) | N | The amount of money on a student's lunch balance | N |
41 | 40 | ISE Operating District ID | Integer | N | Student operating district - used in ISE only | N |
42 | 41 | ISE Operating Site ID | Integer | N | Student operating school - used in ISE only | N |
43 | 42 | ISE Resident LEA Code | Integer | N | Student resident district - used in ISE only | N |
44 | 43 | Birth Date Verification Method | Text | N | Code value of student birthdate verification method from the Birthdate Verification Method code table | N |
45 | 44 | Homeless Dwelling Type | Text | N | Code value of Dwelling Type from the Dwelling Type code table | N |
46 | 45 | Photo Release | Integer | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N |
47 | 46 | Military Recruitment | Integer | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N |
48 | 47 | Internet Use Release | Integer | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N |
49 | 48 | Graduation Date | Date | N | N | |
50 | 49 | Graduation/Completion Status | Integer | N | Code value of Graduation Status from the Graduation Status code table | N |
51 | 50 | Graduation Service Learning Hours | Integer | N | Number of community service hours a student has completed | N |
52 | 51 | US Citizen Born Abroad | Integer | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N |
53 | 52 | Military Family | Integer | N | This is a boolean field. 0 = No, 1 = Yes, default: 0 | N |
54 | 53 | Home Address Verification Date | Date | N | Date that a student's home address was verified | N |
55 | 54 | Special Ed Enter Date | Date | N | Date student entered Special Ed. | Y |
56 | 55 | Secondary Disability Code ID | Text | N | Code value of Secondary Disability from the Primary Disability code table or Student Programs code table (ISE only) | N |
57 | 56 | State School Entry Date | Date | N | Date student first entered school in state | Y |
58 | 57 | US School Entry Date | Date | N | Date student first entered school in the US | Y |
59 | 58 | District Student ID | Text | N | District student ID, as assigned in the SIS | N |
60 | 59 | School Student ID | Text | N | School student ID, typically assigned at the school level. Not available in many SIS | N |
61 | 60 | Other Student ID | Text | N | N | |
62 | 61 | Graduation Requirement Year | Academic Year | N | The academic year that the student is expected to graduate | N |
63 | 62 | Next School | Integer | N | The next site ID that the student will be attending. Must map to a valid site ID | N |
64 | 63 | Prior District | Text | N | The name of the school district the student attended prior to the current district | N |
65 | 64 | Prior School | Text | N | The name of the school the student last attended. This value should relate to the Prior District. Not to be used for internal sites. | N |
1 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
---|---|---|---|---|---|---|
2 | 1 | Import Student ID | Text | Y | A unique student identifier | Y |
3 | 2 | State Student ID | Text | N | State assigned student identifier.* | Y |
4 | 3 | Student Last Name | Text | Y | Y | |
5 | 4 | Student First Name | Text | Y | Y | |
6 | 5 | Student Middle Name | Text | N | N | |
7 | 6 | Birth Date | Date | Y | Y | |
8 | 7 | Site ID | Integer | Y | Site at which student has enrollment, must match Site ID in sites.txt | Y |
9 | 8 | Enrollment Start | Date/Time | Y | Must fall within term dates | Y |
10 | 9 | Enrollment End | Date/Time | N | Should typically fall within term dates. If enrollment end pre-dates the term start date, the record will be handled as a no-show | Y |
11 | 10 | Student Grade Level ID | Integer | Y | Note: Should match Grade Level ID from Grade Level Lookups. Grade Level ID = Value 1 = Kindergarten 2 = 1st Grade 3 = 2nd Grade 4 = 3rd Grade 5 = 4th Grade 6 = 5th Grade 7 = 6th Grade 8 = 7th Grade 9 = 8th Grade 10 = 9th Grade 11 = 10th Grade 12 = 11th Grade 13 = 12th Grade 14 = Graduated 15 = Pre-K | Y |
12 | 11 | Academic Year | Academic Year | Y | Y | |
13 | 12 | Is Primary ADA | Boolean | N | For concurrently enrolled students, should identify the enrollment record used for ADA reporting. This is a boolean field. 0 = False, 1 = True, default: 1 | N |
14 | 13 | Enrollment Category | Text | N | Defaults to "N" (Regular Attendance Program). Defined in Code Management -> Student Programs (Program Types) | N |
15 | 14 | Enrollment Exit Code | Text | N | Y | |
16 | 15 | Session Type | Integer | N | 1 = Normal, 2 = Summer, Defaults to 1 | Y |
17 | 16 | Enrollment Entry Code | Text | N | Y |
1 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
---|---|---|---|---|---|---|
2 | 1 | Section ID | Text | Y | A unique identifier for the master schedule record. | Y |
3 | 2 | Site ID | Integer | Y | Site ID at which this section is offered. Must match Site ID from sites.txt | Y |
4 | 3 | Term Name | Text | Y | Term during which this section is offered. Must match Term Name from terms.txt | Y |
5 | 4 | Course ID | Text | Y | Course ID that is being offered during this section. Must match Course ID from courses.txt | Y |
6 | 5 | User ID | Text | Y | User ID of the teacher who is teaching this section. Must match User ID from users.txt | Y |
7 | 6 | Period | Text | Y | Period during which this section is offered. | Y |
8 | 7 | Academic Year | Academic Year | Y | Y | |
9 | 8 | Room Number | Text | N | Room number in which this section is offered | N |
10 | 9 | Session Type | Integer | N | 1 = Normal, 2 = Summer, Defaults to 1 | N |
11 | 10 | Unique Term ID | Integer | N | This field is now obsolete. Should match Unique term ID from terms.txt | N |
12 | 11 | Quarter Number | Integer | N | Quarter number is an optional field that will identity quarter sections within traditional semester schedules. | N |
13 | 12 | User Start Date | Date/Time | N | First date that the User ID is in this section | N |
14 | 13 | User End Date | Date/Time | N | Last date that the User ID is in this section | N |
15 | 14 | Primary User | Integer | N | If there are multiple teachers for this section, is the associated user ID the primary? This is a boolean field. 0 = No, 1 = Yes. Defaults to 1 (Yes) . | N |
16 | 15 | Highly Qualified Teacher Competency Code | Text | N | HQT level per section(s), please provide the specific HQT code here that aligns to each section. | N |
17 | 16 | Is Attendance Enabled | Integer | N | This is a boolean field: 0 = No, 1 = Yes, default: 1. This field determines which sections will be considered when attendance numbers are calculated for full day and period absences. If attendance is not taken in a given section, this field should be 0. | N |
1 | Column | Field | Data Type | Required | Notes | Strongly Recommended |
---|---|---|---|---|---|---|
2 | 1 | Import Student ID | Text | Y | A unique student identifier | Y |
3 | 2 | State Student ID | Text | N | State assigned student identifier.* | Y |
4 | 3 | Student Last Name | Text | Y | Y | |
5 | 4 | Student First Name | Text | Y | Y | |
6 | 5 | Student Middle Name | Text | N | N | |
7 | 6 | Birth Date | Date | Y | Y | |
8 | 7 | Section ID | Text | N | Section ID in which this student is registered. Must match Section ID from mastschd.txt. May be blank for students at sites where a master schedule is not used (elementary schools) | Suggested: Required when Section ID is entered.” |
9 | 8 | Site ID | Integer | Y | Site at which student has is in this section/course/grade level. Must match Site ID in sites.txt | Y |
10 | 9 | Course ID | Text | N | Course ID in which this student is registered. Must match Course ID from courses.txt | N |
11 | 10 | User ID | Text | Y | The user ID of the teacher who is teaching this student in the particular section/course/grade level. | Y |
12 | 11 | Entry Date | Date | Y | The date the student first entered this section/course. Should fall within term dates | Y |
13 | 12 | Exit Date | Date | Y | The date this student exited this section/course or blank | Y |
14 | 13 | Student Grade Level ID | Integer | Y | Note: Should match Grade Level ID from Grade Level Lookups. Grade Level ID = Value 1 = Kindergarten 2 = 1st Grade 3 = 2nd Grade 4 = 3rd Grade 5 = 4th Grade 6 = 5th Grade 7 = 6th Grade 8 = 7th Grade 9 = 8th Grade 10 = 9th Grade 11 = 10th Grade 12 = 11th Grade 13 = 12th Grade 14 = Graduated 15 = Pre-K | Y |
15 | 14 | Academic Year | Academic Year | Y | Y | |
16 | 15 | Session Type | Integer | N | 1 = Normal, 2 = Summer, Defaults to 1 | Y |
1 | Note: Files should be saved as tab-delimited files with an extension of .txt (i.e. studemo.txt) | |||
---|---|---|---|---|
2 | ||||
3 | Integer: | Any positive or negative whole number with no decimal notation | ||
4 | ||||
5 | Valid inputs | Invalid inputs | ||
6 | 0 | -0.14 | ||
7 | -1 | 4939.326 | ||
8 | -130121 | 1.5 | ||
9 | 4 | |||
10 | 439343 | |||
11 | ||||
12 | Decimal: | Any positive or negative number with or without decimal notation | ||
13 | ||||
14 | Valid inputs | Invalid inputs | ||
15 | 0.0 | Yes | ||
16 | 17 | No | ||
17 | 1.5 | T | ||
18 | -25.368 | F | ||
19 | 43.89 | |||
20 | 96573.2 | |||
21 | ||||
22 | Date: | Any date value containing a month, day, and year. Dates may be formatted using either: mm/dd/yyyy or yyyy-mm-dd. In the event that the date is provided with a time, the time will be truncated | ||
23 | ||||
24 | Valid inputs | Invalid inputs | ||
25 | 1/3/01 | 20091214 | ||
26 | 3/21/10 | 31/1/2010 | ||
27 | 10/21/2009 | 20-Sep-10 | ||
28 | 1998-09-20 | |||
29 | 2014-05-18 | 00:00.0 | ||
30 | ||||
31 | Timestamp: | A time value containing a year, month, day, hour, minutes, and seconds | ||
32 | ||||
33 | Valid inputs | Invalid inputs | ||
34 | 2014-08-08 04:05:06 | 8/8/14 | ||
35 | August 8 04:05:06 2014 | 12:00 | ||
36 | 9PM | |||
37 | Seven o'clock | |||
38 | ||||
39 | Text: | Any ACSII characater data with or without spaces (" ") is considered valid | ||
40 | ||||
41 | Academic Year: | A representation of one year witin an educational calendar. Must be unambiguous and use the hyphenated format | ||
42 | ||||
43 | Valid inputs | Invalid inputs | ||
44 | 1999-2000 | 2001/02 | ||
45 | 2003-2004 | 2009-10 | ||
46 | 2013-2014 | 2015 | ||
47 | 2014-2015 |