PowerSchool SIS Massachusetts

S_MA_SCH_X (ver 15.11.0)

This table is an extension of the Schools table.

Column Name

Version

Data Type

Description

SectionsDCID

15.11.0

Number(10,0)

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

OverrideSchoolCode

15.11.0

Varchar2(4)

The four digit code assigned to this school by the state that uniquely identifies the school. Migrates from [Schools]MA_school_num.

RegionalDistrictCode

15.11.0

Varchar2(4)

The four digit code assigned by the state to the district that this school belongs to. Migrates from [Schools]MA_regional_district.

SIF_SchoolType

15.11.0

Varchar2(4)

Four digit SIF code that defines the school type to be published in the SIF SchoolInfo Object. Migrates from [Schools]MA_SIF_SchoolType.

Scheduling_School_TF

16.8.0

Number(1)

For SIF: checkbox to indicate this is a scheduling school for some students who actually attend a different school