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 | Version | Data Type | Description |
---|---|---|---|
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 | CHAR | Indicates 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 | CHAR | Indicates 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. |