PowerSchool SIS Massachusetts

S_MA_STU_CTE_X (ver 15.11.0)

This table is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID

15.11.0

Number(10,0)

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

CTEChapter74Participation

15.11.0

Varchar2(6)

The program code for the Chapter 74 CTE program the student is enrolled in. Migrates from [Students]MA_DOE043.

NonCTEChapter74Participation

15.11.0

Varchar2(3)

The program code for the Non-Chapter 74 CTE program the student is enrolled in. Migrates from [Students]MA_DOE044.

CTESpecialPopulations

15.11.0

Varchar2(4)

Indicates if the CTE student is a single parent or not. Migrates from [Students]MA_SpecialPop.

ProgramType

15.11.0

Varchar2(2)

The type of Chapter 74 or Non-Chapter 74 CTE program the student is enrolled in. Migrates from [Students]MA_OEPType.

TechnicalCompetencyAttain

15.11.0

Varchar2(3)

Indicates the student's achievement level or credential attained in the CTE program . Migrates from [Students]MA_TechCompAttain.