PowerSchool SIS Massachusetts

CRDC specific to Massachusetts: S_STU_CRDC_X (ver 15.11.0)

This table is an extension of the [Students] table and provides CRDC-specific fields for Massachusetts. To view additional CRDC fields used by all states, refer to S_STU_CRDC_X in the All States Data Dictionary.

Column Name

Version

Data Type

Description

StudentsDCID

15.11.0

Number(10,0)

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

ACT_YN

15.11.0

VarChar2(1)

Indicates whether or not the student took the American College Test (ACT). Migrates from [Students]CRDC_ACT_YN.

APExam

15.11.0

VarChar2(1)

Code indicating if the student took (A)ll AP exams, (S)ome AP exams, or (N)o AP exams. Migrates from [Students]CRDC_APExam.

APExamPassed

15.11.0

VarChar2(1)

Code indicating if the student passed (A)ll AP exams, (S)ome AP exams, or (N)o AP exams. Migrates from [Students]CRDC_APExamPassed

ExcludeFromCRDC_TF

15.11.0

Number(1,0)

Indicates whether or not the student is excluded from the CRDC reporting. Migrates from [Students]CRDC_exclude

GEDPrepProgram_YN

15.11.0

VarChar2(1)

Indicates whether or not the student participates in a General Educational Development (GED) preparation program. Migrates from [Students]CRDC_GEDPrepProgram_YN.

GEDPrepProgramCred_YN

15.11.0

VarChar2(1)

Indicates whether or not the student earned a General Educational Development (GED) program credential. Migrates from [Students]CRDC_GEDPrepProgramCred_YN.

IBDiplomaProgram_YN

15.11.0

VarChar2(1)

Indicates whether or not the student is enrolled in the International Baccalaureate program. Migrates from

[Students]CRDC_IB.

SAT_YN

15.11.0

VarChar2(1)

Indicates whether or not the student took the Scholastic Aptitude Test (SAT). Migrates from [Students]CRDC_SAT_YN.