Skip to main content
Skip table of contents

EPIMS

The following table contains the EPIMS fields provided by the Massachusetts Department of Education, the associated title, and the location in the PowerSchool database where the field is found. EPIMS records are based on static and dynamic records. Dynamic records are auto-generated based on a staff's assignment to a class. Dynamic records are required for job codes 2305, 2306, 2307, 2308, 2310, and 2325.

MA Field

Title

PS DB Location

WA01

Massachusetts Education Personnel Identifier (MEPID)

[Users] SIF_StatePrId

WA02

Local Employee Number

[S_MA_USR_X] LocalEmpNum OR [Users] TeacherNumber

WA03

First Name

[S_MA_USR_Demographic_X] StateOverride_FirstName OR [Users] First_Name

WA04

Middle Name / Middle Initial

[S_MA_USR_Demographic_X] StateOverride_MiddleName OR [S_MA_USR_X] State_Middle_Name OR [Users] First_Name

WA05

Last Name

[S_MA_USR_Demographic_X] StateOverride_LastName OR [Users] Last_Name

WA06

Assignment Location Code

[Schools] StatePrId based on [Sections] SchoolIdOR [S_MA_USR_WARStatic_C] AssignmentLocationSchoolIdOR [S_MA_USR_WARStatic_C] DistrictAssignment_DistrictID

WA07

Job Classification

[S_MA_STC_WarDynamicOverride_X] JobClassificationCodeOR Auto Calculated for Teachers based on section roleOR [S_MA_USR_WARStatic_C] JobClassificationCode

WA08

Teacher / Paraprofessional Assignment

[S_MA_STC_WarDynamicOverride_X] OverrideAssignmentCodeOR Auto Calculated for Teachers based on Course NCES IDOR 000 for Static records

WA09

Grade

Auto calculated at the state based on the students enrolled in a class.

WA10

Subject Area-Course Code

[S_MA_CRS_X] NCESCode

WA11

Class Section

[Courses] Course_Number – [Sections] Section_Number

WA12

Full Time Equivalent (FTE)

Auto calculated based on the number of sections a teacher is teaching. This can be overridden with a Static WAR record, however this is not recommended.

WA13

NCLB Instructional Paraprofessional Requirements

Discontinued

WA14

Highly Qualified Teacher Status

Discontinued

WA15

Subject Matter Competency

Discontinued

WA16

Course Term

[Sections] TermID

WA17

Term Status at Time of Collection

Auto calculated at the state.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.