Position Role Table (SLDS) (Vermont)

Tool Search: SLDS

The Position Role Table extract enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data.

Screenshot of SLDS tool with extract type highlighted.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

FieldDescription
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 DateThe date from which data is pulled for the report. 
FormatDetermines 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

ElementLogicCampus Location
ADMINIDThe 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

POSIDThe 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
EDUCATORIDThe 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
ROLEIDA 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