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. |