Skip to main content
Skip table of contents

S_NC_RPT_SAR_STUDDEMO (ver 13.6.0)

This table is a stand alone table that stores information used in the School Activity Report Detail view.

Column Name


Data Type


ADMISSION_STATUS_CODE 13.6.0 VARCHAR2(4)Indicates the admission status code for this student at the time the report is run.
AIG_EXCEP 13.6.0 CHARIndicates the Academically and Intellectually Gifted code for this student is applicable.
ETHNICITY 13.6.0 VARCHAR2(20)Indicates the state ethnicity code for this student.
FIRST_NAME 13.6.0 VARCHAR2(50)Indicates the student's first name.
GENDER 13.6.0 VARCHAR2(2)Indicates the student's gender.
GRADE_LEVEL 13.6.0 VARCHAR2(2)Indicates the student's PowerSchool grade level.
HAS_FATALS 13.6.0 CHARIndicates that there is data on this record that causes a fatal and would prevent the student from being included in the report to the state.
LAST_NAME 13.6.0 VARCHAR2(50)Indicates the student's last name.
PRIMARY_EXCP 13.6.0 VARCHAR2(50)Indicates the Primary Exceptionality if a student is in the Exceptional Childhood program.
RPT_RUN_ID 13.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_ID 13.6.0 NUMBER(10,0)Indicates the school number where this student is enrolled.
SECOND_EXCP 13.6.0 VARCHAR2(50)Indicates the Secondary Exceptionality if a student is in the Exceptional Childhood program.
STATE_GRADE_CODE 13.6.0 VARCHAR2(2)Indicates the student's grade using the state codes.
STATE_STUDENTID 13.6.0 VARCHAR2(20)Indicates the state student number.
STUDENTID 13.6.0 NUMBER(10,0)Foreign key that links to the students table.

JavaScript errors detected

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

If this problem persists, please contact our support.