State of Vermont
Agency of Education
Data Collection and Reporting Knowledge Base
Data Collection and Reporting Knowledge Base
These are the columns used in this submission file:
Name | Description | Data Type | Length | is_PK | Codeset | Definition |
---|---|---|---|---|---|---|
ADMINID | SU/SD ID | STRING | 6 | Issued by AOE | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. | |
ENRORGID | Enrolling Org ID | STRING | 6 | X | Issued by AOE | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. |
PERMNUMBER | State Assigned Student ID | NUMBER | 10 | X | The VT AOE assigned unique student identifier. This number is distinct for each student over time. | |
GRADE | Grade | STRING | 2 | X | Issued by AOE | A codeset value indicating the grade level or primary instructional level at which a student received services in a school or educational institution. |
GRADEBEGIN | Grade Begin Date | DATE(MM/DD/YYYY) | X | The month, day, and year on which an individual enters a grade level. | ||
GRADEEND | Grade End Date | DATE(MM/DD/YYYY) | The last month, day, and year after which an individual exits a grade level. | |||
SY | School Year | NUMBER | 4 | X | The school year for which data is being submitted. |
ADMINID,ENRORGID,PERMNUMBER,GRADE,GRADEBEGIN,GRADEEND,SY
In the past for all promoted student(s) in your school(s) that are expected to remain in your school in the fall, the 04_5_PS_GradeProg table can contain two rows of data for each promoted student(s). For example(you don't need to do this anymore):
ADMINID | ENRORGID | PERMNUMBER | GRADE | GRADEBEGIN | GRADEEND | SY |
---|---|---|---|---|---|---|
SU0XX | PS0XX | 1987654 | 07 | 6/16/2019 | 6/30/2020 | 2020 |
SU0XX | PS0XX | 1987654 | 08 | 07/01/2020 | 2020 |
The above is no longer required.
Going forward, please do the following to report students regardless of their promotion status for next year:
ADMINID | ENRORGID | PERMNUMBER | GRADE | GRADEBEGIN | GRADEEND | SY |
---|---|---|---|---|---|---|
SU0XX | PS0XX | 1987654 | 07 | 6/16/2019 | 2020 |
We will get their promotion status by checking what you submit for the student next year.