S_NC_RPT_GRS_SUMMARY (ver 13.6.0)
This table is a stand alone table that stores information used in the Grade/Race/Sec (GRS) Summary View.
Column Name | Version | Data Type | Description |
---|---|---|---|
COUNT_A | 13.6.0 | NUMBER(10,0) | The total number of Asians for the particular school, PMR interval, grade and gender. |
COUNT_B | 13.6.0 | NUMBER(10,0) | The total number of Blacks for the particular school, PMR interval, grade and gender. |
COUNT_C | 13.6.0 | NUMBER(10,0) | The total number of Caucasians for the particular school, PMR interval, grade and gender. |
COUNT_H | 13.6.0 | NUMBER(10,0) | The total number of Hispanics for the particular school, PMR interval, grade and gender. |
COUNT_I | 13.6.0 | NUMBER(10,0) | The total number of American Indians for the particular school, PMR interval, grade and gender. |
COUNT_M | 13.6.0 | NUMBER(10,0) | The total number of Two or More ethnic codes for the particular school, PMR interval, grade and gender. |
COUNT_NP | 13.6.0 | NUMBER(10,0) | The total number of students that do not have an ethnic code populated. |
COUNT_P | 13.6.0 | NUMBER(10,0) | The total number of Hawaiian/Pacific Islanders for the particular school, PMR interval, grade and gender. |
GENDER | 13.6.0 | VARCHAR2(2) | The gender for the students on this record. |
PMR_COLLECTION | 13.6.0 | NUMBER(,) | The number for the PMR collection for this record - value is 1 to 9. |
PMR_INTERVAL | 13.6.0 | NUMBER(,) | The PMR interval code for this record. For PMR collection 2, the interval is either 1 or 2. For PMR collection 9, the interval can be 1-9. |
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_MONTH_BEGIN_DATE | 13.6.0 | DATE | The first day of the PMR interval. |
SCHOOL_MONTH_END_DATE | 13.6.0 | DATE | The last day of the PMR interval. |
STATE_GRADE_CODE | 13.6.0 | VARCHAR2(4) | The state grade level for the students on this record. Used to determine the description on the summary report. |
STATE_SCHOOL_NUMBER | 13.6.0 | VARCHAR2(10) | The school number for the students on this record. |