Tool Search: SLDS
The Position Role Table extract enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data.
11a POS Role Table Example Extract Editor
Report Logic
- This extract reports all staff with active employment anytime during the calendar year that is on or prior to the Effective Date selected on the extract editor.
- To report, employees must have an EDUCATORID assigned to them.
- Staff are not included if their District Assignment is marked as Exclude.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report. |
| Extract Type | 11a POS Role Table |
| 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. |
| 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 | Campus Location |
|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. Alphanumeric, 6 characters | School & District Settings > District Information > District Detail > State District Number District.number |
| EmpOrgid | The VT AOE assigned unique identifier for the district employing the employee. The Organization ID reports unless the staff member has the Title "109: SPED Ungraded Teachers" or "112: SPED Paraprofessionals." These staff members report the ADMINID (State District Number). Alphanumeric, 6 characters | School & District Settings > School > School Detail > Organization ID School & District Settings > District Information > District Detail > State District Number School.employerID |
| POSID | The VT AOE assigned unique identifier for the organization representing the "Place of Service" where the employee is performing a role. Alphanumeric, 6 characters | District Assignment > Employment Assignments > School School.number |
| EDUCATORID | The VT AOE assigned unique employee identifier. This number is distinct for each employee over time. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State Staff ID Person.staffStateID |
| ROLEID | A code that represents the role the employee is performing at the place of service. Alphanumeric, 63 characters | Census > People > District Assignments > Employment Assignment Information > Title EmploymentAssignment.title |
| RolePercent | The percentage of the place of service assignment that the employee allocates to a particular role they are performing at the place of service. The sum of these values, across all roles the employee is performing at the place of service, should always total 100% for a given place of service assignment. 100% reports as 1. Numeric, 3 digits (N.NN) | District Assignments > Employment Assignment Information > FTE of Assignment EmploymentAssignment.fte |
| SY | The school year for which data is being submitted. Numeric, 4 digits (YYYY) | N/A |
