Skip to content

Discovery

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type False Text Discovery
1 LEA ID True Integer (Small)
2 LEA False Text
3 Campus ID True Integer (Small)
4 Campus False Text
5 School Year True Text YYYY-YYYY
6 USI True Integer (Big)
7 First Name False Text
8 Last Name False Text
9 Assessment Grade False Text
10 Subject True Mapped ID Accepted Values:
  • LITERACY
  • MATH
11 Start Score False Integer (Small)
12 Start Level False Integer (Small) 1-4
13 End Score False Integer (Small)
14 End Level False Integer (Small) 1-4
15 PMF Numerator False Integer (Small) 1 (Positive Outcome) or 0 (Negative Outcome) The student is considered to have a positive outcome if the intercept for their subject and grade, plus their End Score, minus their Start Score multiplied by the Slope for their subject and grade [Intercept + End Score - (Start Score x Slope)] is greater than the Standard Error for their subject and grade. Literacy: - Kindergarten - Slope: 0.780 - Intercept: 381.258 - Standard Error: -79.815 - Grade 1 - Slope: 0.814 - Intercept: 384.245 - Standard Error: -66.691 - Grade 2 - Slope: 0.863 - Intercept: 255.815 - Standard Error: -64.568 Math: - Kindergarten - Slope: 0.832 - Intercept: 325.555 - Standard Error: -83.459 - Grade 1 - Slope: 1.033 - Intercept: 93.031 - Standard Error: -84.355 - Grade 2 - Slope: 0.977 - Intercept: 151.816 - Standard Error: -74.666
16 PMF Denominator False Integer (Small) 0 (Excluded from Rates) or 1 (Included in Rates)

Shading Key

Primary Key Column Column(s) which uniquely define the row, and is required in all submissions
Expected Column Column which is expected in a complete submission; in case where the data are missing and the column is not required, these columns may be left blank
Calculated Column Column which is calculated based on other data (provided in submission or otherwise); these columns can be left blank
Non-Loaded Column Column which is not loaded; these columns are provided to support use of the table, but can be left blank in submissions

Common Errors

Click on the error type to get more information.

  • No common errors