Tool Search: SLDS
The Public PreK Student Link extract enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data.
Example 5A Public PreK Student LinkReport Logic
- Reports all Students in Grades PK, EE, or IT.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report.
|
| Extract Type | 5A Public PreK Student Link |
| Effective Date | The date from which data is pulled for the report. |
| Format | Determines the format for the report. Use State Submission when submitting the final data. Use HTML for data review and testing. |
| Report Legal Identities | When this checkbox is marked, Campus reports the legal name entered on the Census > People > Identities tab. If only one part of the Protected Identity Information is entered, that part reports and the other name fields report blank. For example, if the Legal First Name is entered but the middle and last name fields are empty, then only the first name reports and the middle and last names report blank.
|
| Select Calendars | The calendar(s) from which data is pulled for the report. This option is only available when you select HTML for the File Format and can assist you with verifying data for individual calendars. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. |
Report Layout
| Element | Logic | Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. | Alphanumeric, 6 characters | District.number | School & District Settings > District Information > District Detail > State District Number |
| ENRORGID | The VT AOE assigned unique identifier for the organization providing direct instructional or educational services. | Alphanumeric, 6 characters | School.number | School & District Settings > School > School Detail > State School Number |
| PERMNUMBER | The VT AOE assigned unique student identifier. This number is distinct for each student over time. | Numeric, 10 digits | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
| PKID | The Public PreK Program ID. The option selected in the PKID dropdown list on the Enrollments tool reports. If nothing is selected in the PKID dropdown list, the Organization ID reports. | Alphanumeric, 10 digits | Enrollment.PKID School.number | Student Information > General > Enrollments > State Reporting Fields > PKID OR School & District Settings > School Information > School Detail > Organization ID |
| PK_START_DATE | The student's Public PreK Program Enrollment Start Date. | Date Field MM/DD/YYYY | Enrollment.startDate | Student Information > General > Enrollments Tab > General Enrollment Information > Start Date |
| PK_END_DATE | The student's Public PreK Program Enrollment End Date. | Date Field MM/DD/YYYY | Enrollment.endDate | Student Information > General > Enrollments Tab > General Enrollment Information > End Date |
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | Calendar.endYear | N/A |
