Skip to main content
Skip table of contents


This table is a stand alone table that stores information about the student discipline summary view.

Column Name


Data Type


CORPORAL_PUNISHMENT13.6.0 NUMBER(5,0)Indicates the number of instances that involved corporal punishment.
EXPULSION13.6.0 NUMBER(5,0)Indicates the number of instances that involved expulsion.
INSTANCE_ID13.6.0 NUMBER(10,0)The instance id that ties this table to the other discipline collection tables.
ISS13.6.0 NUMBER(5,0)Indicates the number of in school suspensions.
LEA_ID13.6.0 VARCHAR2(20)Indicates the LEA number for the collection.
LONG_OSS13.6.0 NUMBER(5,0)Indicates the number of Long Term Out of School suspensions.
RPT_RUN_ID13.6.0 NUMBER(,)Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID.
SCHOOL_ID13.6.0 NUMBER(10,0)The school number for the collection.
SHORT_OSS13.6.0 NUMBER(5,0)Indicates the number of Short Term Out of School suspensions.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.