| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Column | Label | Importance | Format | Sample | Description |
2 | 1 | Site ID | Required | INT | 1 | This is a unique key that identifies each site. It can be any integer you would like, as long as it is unique. This value cannot be changed, even via the user interface, after initial load. |
3 | 2 | Site Name | Required | VARCHAR(255) | Jane High School | The name of the school or district, up to 255 characters. |
4 | 3 | State Site ID | Required | INT | 101 | The site’s state assigned ID. If you do not have a state assigned ID, you may use your Site ID listed above. Must be a unique key. |
5 | 4 | Start Grade Level ID | Required | INT(2) | 9 | The starting grade level of this site, denoted by an integer 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 = Preschool, 17 = Special Ed Preschool, 18 = Transitional Kindergarten. Please note that because Kindergarten starts at “1”, the grade level values are all one above their labels. For instance, 11th grade is denoted by 12. These alignments can only be altered via transformation (Core Data Configuration -> Edit). |
6 | 5 | End Grade Level ID | Required | INT(2) | 13 | The ending grade level of this site, denoted by an integer value. By default, those values are shown above, though they may be altered in the user interface (Admin Gear -> Site Management). Please note that because Kindergarten starts at “1”, the grade level values are all one above their labels. For instance, 11th grade is denoted by 12. |
7 | 6 | Site Type ID | Required | INT(2) | 2 | An indicator of the type of site. 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 |
8 | 7 | Address | Required | VARCHAR(255) | 5 Ash Street | Street address of the site. Appears on the Student Profile page (address of the school) and on printed transcripts (if applicable). The value can be changed after initial load via the DnA user interface (Admin Gear -> Site Management). |
9 | 8 | City | Required | VARCHAR(100) | Vista Hills | The city of the site. Appears on the Student Profile page (address of the school) and on printed transcripts (if applicable). The value can be changed after initial load via the DnA user interface (Admin Gear -> Site Management). |
10 | 9 | State | Required | VARCHAR(2) | WI | A valid 2 character United States state code, including territories. Appears on the Student Profile page (address of the school) and on printed transcripts (if applicable). The value can be changed after initial load via the DnA user interface (Admin Gear -> Site Management). |
11 | 10 | Zip | Required | VARCHAR(10) | 90210-4235 | A 5 digit or 5+4 United States zip code. Appears on the Student Profile page (address of the school) and on printed transcripts (if applicable). This field is not validated beyond VARCHAR(10). The value can be changed after initial load via the DnA user interface (Admin Gear -> Site Management). |
12 | 11 | Local Site Code | Optional | VARCHAR(25) | 456789 | An optional local identifier for each site. Possibly a district school code, which may not be an integer, or a place for a local site ID that is alpha-numeric as the main site ID can only be a numeric value. Will show up in State Reports for ISI clients. Can be changed via the UI (Admin Gear -> Site Management). |
13 | 12 | Annual Hours of Instruction | Optional | INT | 180 | The annual number of hours of instruction. Used to determine FTE for in classroom and out of classroom as it relates to special education services. Can be changed via the ISE user interface (Admin Gear -> Site Management). |
14 | 13 | Annual Weeks of Instruction | Optional | INT | 38 | The annual number of weeks of instruction. Required for ISE installations. Used to determine FTE for in classroom and out of classroom as it relates to special education services. Can be changed via the ISE user interface (Admin Gear -> Site Management). |
15 | 14 | Parent Site ID | Optional | INT | 999999999 | Typically not used. Establishes the site hierarchy in more complicated, multi-level implementations. Leave blank or enter 9999999 for the top-level site. |