S_NC_RPT_CRDC_STU_AGGR (ver 13.6.0)
This table is a stand alone table that stores information about the student demographics for CRDC for the aggregations of the details.
Column Name | Version | Data Type | Description |
---|---|---|---|
AGGR_LEVEL | 13.6.0 | VARCHAR2(10) | Indicates if the aggreagation is for the LEA or School level collection. |
ALL_RACES | 13.6.0 | NUMBER(6,0) | Indicates the total of all of the races. |
AMER_IND_ALASKAN | 13.6.0 | NUMBER(6,0) | Indicates the total number of the American Indian/Alaskan population. |
ASIAN | 13.6.0 | NUMBER(6,0) | Indicates the total number of the Asian population. |
BLACK | 13.6.0 | NUMBER(6,0) | Indicates the total number of the Black population. |
CAT_1_NAME | 13.6.0 | VARCHAR2(500) | For the collection view this is the name of the first category or question. |
CAT_1_NUM | 13.6.0 | NUMBER(6,0) | This indicates the question number as corresponds to the CRDC LEA or School Form. |
CAT_2_NAME | 13.6.0 | VARCHAR2(500) | Indicates the second category name when a question has multiple parts. |
CAT_2_NUM | 13.6.0 | NUMBER(6,0) | Indicates the question number or part when a question has multiple parts. |
GENDER | 13.6.0 | VARCHAR2(5) | Indicates the total number of the gender. |
HAWAIIAN_PAC_ISLANDER | 13.6.0 | NUMBER(6,0) | Indicates the total number of the Hawaiian/Pacific Islander population. |
HISPANIC_LATINO | 13.6.0 | NUMBER(6,0) | Indicates the total number of the Hispanic/Latino population. |
IDEA | 13.6.0 | NUMBER(6,0) | Indicates the total number of the IDEA population. |
LEP | 13.6.0 | NUMBER(6,0) | Indicates the total number of the Limited English Proficiency population. |
MULTI_RACIAL | 13.6.0 | NUMBER(6,0) | Indicates the total number of the population that indicated multiple races. |
RPT_RUN_ID | 13.6.0 | NUMBER(10,0) | 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) | The school id number. |
SCHOOL_NAME | 13.6.0 | VARCHAR2(300) | The name of the school. |
SEC_504_ONLY | 13.6.0 | NUMBER(6,0) | Indicates the total number of the population that are provided 504 services. |
WHITE | 13.6.0 | NUMBER(6,0) | Indicates the total number of the White population. |