PowerSchool SIS Massachusetts

S_MA_USR_X (ver 15.11.0)

This table is an extension of the [Users] table, which maintains additional user details.

Column Name

Version

Data Type

Description

UsersDCID

15.11.0

Number(10,0)

Primary key that relates the extended table to the [Users] table.

EthnicityRaceCode

15.11.0

Varchar2(20)

The Massachusetts proprietary race code calculated from the checked federal race codes and the Hispanic/Latino indicator. Migrates from [Teachers]MA_ERCode.

LicenseCertificationNum

15.11.0

Varchar2(20)

The number assigned to the teaching license by the state at the time the teacher received their license. Migrates from [Teachers]MA_License_Cert_Num.

LocalEmpNum

15.11.0

Varchar2(20)

The identifying number assigned by the district or school to the employee. Migrates from [Teachers]MA_Local_Employee_Num.

MEPID

15.11.0

Varchar2(8)

The unique identifying number assigned by the state to the employee. Migrates from [Teachers]MA_Mepid.

State_ExcludeFromReporting

15.11.0

Number(1,0)

Indicates whether or not the employee should be excluded from state reporting. Migrates from [Teachers]MA_Exclude_From_EPIMS.

State_Middle_Name

17.4.0

Varchar2(30)

Migrated from: [Teachers]MA_middle_name.