PowerSchool SIS Illinois

S_IL_STU_Detention_C 22.3.2.0

This table is an extension table of the [STUDENTS] table.

Column Name

Version

Data Type

Description

STUDENTSDCID

22.3.2.0

Number 

Primary Key that relates this extended table back to the students table.

RCDTS_Detention_Center

22.3.2.0

Varchar2(15)

Region-County-District-Type-School code assigned by ISBE that uniquely identifies the Detention Center where a student is receiving services.

Grade

22.3.2.0

Varchar2(2)

The grade level or primary instructional level of the student.

School_Year

22.3.2.0

Varchar2(4)

The school year which is applicable to this enrollment.

Services_Start_Date

22.3.2.0

Date

The month, day, and year on which the Service was started.

Services_End_Date

22.3.2.0

Date

The month, day, and year on which the Service was ended.

Record_Status

22.3.2.0

Varchar2(2)

This column is used to delete the Detention Center record with code '99'.