STUDENT ETHNIC SUBGROUP Table
This table contains all the ethnic groups (White, Asian, Black or African American, Hispanic or Latino, International, etc.) and the ethnic subgroups (Hispanic or Latino, Mexico, Puerto Rico, Japan, Chinese, Korea, Vietnam, Philippines, Pakistan, India, Spain, Samoa, Guam, Europe, Carribbean, Alaska Native, etc.) as defined in the Student Information System. This table is used as a master table with STUDENT_ETHNICITY_DETAIL.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ETHNIC_CODE |
XXX |
VARCHAR2 |
2 |
ETHNIC_GROUP_NAME |
XXX |
VARCHAR2 |
60 |
ETHNIC_SUBGROUP_CODE |
XXX |
VARCHAR2 |
5 |
ETHNIC_SUBGROUP_NAME |
XXX |
VARCHAR2 |
60 |
MIT_PRIORITY |
XXX |
NUMBER |
22 |
STUDENT_ETHNIC_SUBGROUP_KEY |
Use this key to join together the STUDENT_ETHNICITY_DETAIL and STUDENT_ETHNIC_SUBGROUP tables. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |