PowerSchool SIS Massachusetts

S_MA_STU_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.

EnrollStatusTimeOfCollection

15.11.0

Varchar2(2)

Code indicating the student's enrollment status on the count date of the SIMS Data Collection report. Migrates from [Students]MA_EnrollStatus.

GradCompleteCoreCurriculum

15.11.0

Varchar2(2)

Indicates whether or not the student has met the graduation requirements of the Massachusetts Core Curriculum. Migrates from [Students]MA_Graduate.

IncludeInSASIDMSRInd

15.11.0

Number(1,0)

Indicates whether or not the student should be explicitly included in the SASID MSR report . Migrates from [Students]MA_MSRRptFlag.

LocalAssignedStudentID

15.11.0

Varchar2(32)

Local ID assigned to the student by the school if the ID cannot be stored in [Students]Student_Number. Migrates from [Students]MA_LASID.

MilitaryStatus

17.5.0

Varchar2(2)

Migrates from [Students]MA_MA_MILITARYSTATUS

OverrideSchoolCode

15.11.0

Varchar2(8)

School code to report for the student if the student's enrolled school code should not be reported. Migrates from [Students]MA_SchoolCode.

PostGradPlans

15.11.0

Varchar2(3)

Code indicating what the student plans to do after completing high school. Migrates from [Students]PostGradPlans.

ReasonForEnrollment

15.11.0

Varchar2(2)

Code Indicating the reason for the student’s enrollment in the receiving school district.. Migrates from [Students]MA_EnrollCode.

ReasonForReporting

15.11.0

Varchar2(2)

Code indicating the district’s financial responsibility for the student. Migrates from [Students]MA_RptReason.

SIF_DistrictResident

15.11.0

Varchar2(10)

Indicates the student's residency status within the district. Published in the SIF StudentAttendanceSummary object. Migrates from [Students]MA_SAS_Resident.

SIF_FT_PT_FTE

15.11.0

Varchar2(10)

Indicates if the student is a full time or part time student. Published in the SIF StudentSchoolEnrollment object. Migrates from [Students]MA_SIF_FTE.

SummerDropOut

15.11.0

Number(1,0)

Indicates whether or not the student is a summer dropout. Migrates from [Students]MA_SumDrop.

SummerGraduate

15.11.0

Number(1,0)

Indicates whether or not the student is a summer graduate. Migrates from [Students]MA_SumGrad.

SummerTransfer

15.11.0

Number(1,0)

Indicates whether or not the student is a summer transfer. Migrates from [Students]MA_SumTransfer.