PowerSchool SIS Massachusetts

S_MA_YearTermMapper_S (ver 17.6.0)

This table is a standalone table and stores year term mapping information.

Column Name

Version

Data Type

Description

unique_ID

17.6.0

Number(11,0)

Migrated From [MA_YearTermMapper]unique_ID

schoolID

17.6.0

Number(11,0)

Migrated From [MA_YearTermMapper]schoolID

foreignKey

17.6.0

Number(11,0)

Migrated From [MA_YearTermMapper]foreignKey

foreignKey_alpha

17.6.0

Varchar2(31)

Migrated From [MA_YearTermMapper]foreignKey_alpha

school

17.6.0

Varchar2(10)

Migrated From [MA_YearTermMapper]school

sch_yr

17.6.0

Varchar2(15)

Migrated From [MA_YearTermMapper]sch_yr

termname

17.6.0

Varchar2(50)

Migrated From [MA_YearTermMapper]termname

termid

17.6.0

Number(11,0)

Migrated From [MA_YearTermMapper]term

termcode

17.6.0

Varchar2(2)

Migrated From [MA_YearTermMapper]ma_termid

yearid

17.6.0

Number(11,0)

Migrated From [MA_YearTermMapper]yearid

sch_id

17.6.0

Number(11,0)

Migrated From [MA_YearTermMapper]sch_id