STUDENT ETHNICITY Table
Student ethnicity summary data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITIZENSHIP_INDICATOR |
Contains one of the following values: C Citizen, I International Student, or P Permanent Resident (this person holds a Green Card). |
VARCHAR2 |
1 |
CITIZENSHIP_INDICATOR_DESC |
XXX |
VARCHAR2 |
40 |
COUNTRY_ORIGIN_CODE |
XXX |
VARCHAR2 |
2 |
COUNTRY_ORIGIN_DESC |
XXX |
VARCHAR2 |
40 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
IPEDS_ETHNIC_CODE |
XXX |
VARCHAR2 |
2 |
IPEDS_ETHNIC_DESC |
XXX |
VARCHAR2 |
50 |
IS_AMERICAN_INDIAN_ALASKA_NATV |
If the employee has identified herself as American Indian or Alaska Native, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_AMER_INDIAN_ALASKA_NATV_IR |
XXX |
VARCHAR2 |
1 |
IS_ASIAN |
If the employee has identified herself as Asian, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_ASIAN_IR |
XXX |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMERICAN |
If the employee has identified herself as Black or African American, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMER_IR |
XXX |
VARCHAR2 |
1 |
IS_CURRENT_STUDENT |
A flag indicating whether this person in the STUDENT table is considered a current student for the current academic term. |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO |
If the employee has identified herself as Hispanic or Latino on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO_IR |
XXX |
VARCHAR2 |
1 |
IS_INTERNATIONAL_NOT_CITZ_PR |
XXX |
VARCHAR2 |
1 |
IS_INTERNTL_NOT_CITZ_PR_IR |
XXX |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REPORTED |
If the employee has identified herself as having more than one Race, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REP_IR |
XXX |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PACIFIC_ISL |
If the employee has identified herself as a Native Hawaiian or Other Pacific Islander, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PAC_ISL_IR |
XXX |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD |
If the employee has not specified any ethnicity on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD_IR |
XXX |
VARCHAR2 |
1 |
IS_RACE_ETHNICITY_UNKNOWN |
XXX |
VARCHAR2 |
1 |
IS_RACE_ETHNICITY_UNKN_IR |
XXX |
VARCHAR2 |
1 |
IS_WHITE |
If the employee has identified herself as White, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_WHITE_IR |
XXX |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MIT_PRIME_ETHNIC_CODE |
XXX |
VARCHAR2 |
2 |
MIT_PRIME_ETHNIC_DESC |
XXX |
VARCHAR2 |
50 |
STUDENT_SOURCE |
XXX |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |