HR PERSON RACE VETERAN DATA Table
View exposing employee race, ethnicity, and veteran-status attributes used for compliance, diversity, and workforce demographic reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFIRMATIVE_ACTION_RACE |
Column AFFIRMATIVE_ACTION_RACE. |
VARCHAR2 |
100 |
AF_SERVICE_MEDAL_VETERAN_CNT |
Column AF_SERVICE_MEDAL_VETERAN_CNT. |
NUMBER |
|
AMERICAN_INDIAN_OR_ALASKAN_CNT |
Column AMERICAN_INDIAN_OR_ALASKAN_CNT. |
NUMBER |
|
ASIAN_CNT |
Column ASIAN_CNT. |
NUMBER |
|
BLACK_OR_AFRICAN_AMERICAN_CNT |
Column BLACK_OR_AFRICAN_AMERICAN_CNT. |
NUMBER |
|
DISABLED_VETERAN_CNT |
Column DISABLED_VETERAN_CNT. |
NUMBER |
|
ETHNICITY_DESCRIPTION |
Column ETHNICITY_DESCRIPTION. |
VARCHAR2 |
100 |
FULL_RACE_DESCRIPTION |
Column FULL_RACE_DESCRIPTION. |
VARCHAR2 |
300 |
HISPANIC_OR_LATINO_CNT |
Column HISPANIC_OR_LATINO_CNT. |
NUMBER |
|
IPEDS_ETHNIC_ORIGIN |
Column IPEDS_ETHNIC_ORIGIN. |
VARCHAR2 |
100 |
IS_AF_SERVICE_MEDAL_VETERAN |
Column IS_AF_SERVICE_MEDAL_VETERAN. |
VARCHAR2 |
1 |
IS_AMERICAN_INDIAN_OR_ALASKAN |
Column IS_AMERICAN_INDIAN_OR_ALASKAN. |
VARCHAR2 |
1 |
IS_ASIAN |
Column IS_ASIAN. |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMERICAN |
Column IS_BLACK_OR_AFRICAN_AMERICAN. |
VARCHAR2 |
1 |
IS_DISABLED_VETERAN |
Column IS_DISABLED_VETERAN. |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO |
Column IS_HISPANIC_OR_LATINO. |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REPORTED |
Column IS_MORE_THAN_ONE_RACE_REPORTED. |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN |
Column IS_NATIVE_HAWAIIAN. |
VARCHAR2 |
1 |
IS_NEWLY_SEPARATED_VETERAN |
Column IS_NEWLY_SEPARATED_VETERAN. |
VARCHAR2 |
1 |
IS_NOT_A_VETERAN |
Column IS_NOT_A_VETERAN. |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD |
Column IS_NO_ETHNICITY_ON_RECORD. |
VARCHAR2 |
1 |
IS_NO_RACE_ON_RECORD |
Column IS_NO_RACE_ON_RECORD. |
VARCHAR2 |
1 |
IS_OTHER |
Column IS_OTHER. |
VARCHAR2 |
1 |
IS_OTHER_VETERAN |
Column IS_OTHER_VETERAN. |
VARCHAR2 |
1 |
IS_PROTECTED_VETERAN |
Column IS_PROTECTED_VETERAN. |
VARCHAR2 |
1 |
IS_RECENTLY_SEPARATED_VETERAN |
Column IS_RECENTLY_SEPARATED_VETERAN. |
VARCHAR2 |
1 |
IS_SPECIAL_DISABLED_VETERAN |
Column IS_SPECIAL_DISABLED_VETERAN. |
VARCHAR2 |
1 |
IS_VIETNAM_VETERAN |
Column IS_VIETNAM_VETERAN. |
VARCHAR2 |
1 |
IS_WHITE |
Column IS_WHITE. |
VARCHAR2 |
1 |
MULTIPLE_RACES_REPORTED_CNT |
Column MULTIPLE_RACES_REPORTED_CNT. |
NUMBER |
|
NATIVE_HAWAIIAN_CNT |
Column NATIVE_HAWAIIAN_CNT. |
NUMBER |
|
NEWLY_SEPARATED_VETERAN_CNT |
Column NEWLY_SEPARATED_VETERAN_CNT. |
NUMBER |
|
NOT_A_VETERAN_CNT |
Column NOT_A_VETERAN_CNT. |
NUMBER |
|
NO_ETHNICITY_ON_RECORD_CNT |
Column NO_ETHNICITY_ON_RECORD_CNT. |
NUMBER |
|
NO_RACE_ON_RECORD_CNT |
Column NO_RACE_ON_RECORD_CNT. |
NUMBER |
|
OTHER_CNT |
Column OTHER_CNT. |
NUMBER |
|
OTHER_VETERAN_CNT |
Column OTHER_VETERAN_CNT. |
NUMBER |
|
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
PROTECTED_VETERAN_CNT |
Column PROTECTED_VETERAN_CNT. |
NUMBER |
|
RECENTLY_SEPARATED_VETERAN_CNT |
Column RECENTLY_SEPARATED_VETERAN_CNT. |
NUMBER |
|
RECORD_SOURCE |
Column RECORD_SOURCE. |
VARCHAR2 |
2 |
SPECIAL_DISABLED_VETERAN_CNT |
Column SPECIAL_DISABLED_VETERAN_CNT. |
NUMBER |
|
VIETNAM_VETERAN_CNT |
Column VIETNAM_VETERAN_CNT. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |
|
WHITE_CNT |
Column WHITE_CNT. |
NUMBER |