HR PERSON RACE VETERAN DATA Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFIRMATIVE_ACTION_RACE |
XXX |
VARCHAR2 |
100 |
AF_SERVICE_MEDAL_VETERAN_CNT |
XXX |
NUMBER |
|
AMERICAN_INDIAN_OR_ALASKAN_CNT |
XXX |
NUMBER |
|
ASIAN_CNT |
XXX |
NUMBER |
|
BLACK_OR_AFRICAN_AMERICAN_CNT |
XXX |
NUMBER |
|
DISABLED_VETERAN_CNT |
XXX |
NUMBER |
|
ETHNICITY_DESCRIPTION |
XXX |
VARCHAR2 |
100 |
FULL_RACE_DESCRIPTION |
XXX |
VARCHAR2 |
300 |
HISPANIC_OR_LATINO_CNT |
XXX |
NUMBER |
|
IPEDS_ETHNIC_ORIGIN |
XXX |
VARCHAR2 |
100 |
IS_AF_SERVICE_MEDAL_VETERAN |
XXX |
VARCHAR2 |
1 |
IS_AMERICAN_INDIAN_OR_ALASKAN |
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_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_DISABLED_VETERAN |
XXX |
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_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_NATIVE_HAWAIIAN |
XXX |
VARCHAR2 |
1 |
IS_NEWLY_SEPARATED_VETERAN |
An indicator that the person is a newly separated veteran (Y or N). |
VARCHAR2 |
1 |
IS_NOT_A_VETERAN |
If the person has not identified herself as Veteran, this field is set to "Y", otherwise it contains "N" |
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_RACE_ON_RECORD |
If the employee has not specified any race on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
IS_OTHER |
XXX |
VARCHAR2 |
1 |
IS_OTHER_VETERAN |
An indicator that the person is a veteran, not from Vietnam (Y or N). |
VARCHAR2 |
1 |
IS_PROTECTED_VETERAN |
XXX |
VARCHAR2 |
1 |
IS_RECENTLY_SEPARATED_VETERAN |
XXX |
VARCHAR2 |
1 |
IS_SPECIAL_DISABLED_VETERAN |
An indicator tha the person is a special disabled veteran (Y or N). |
VARCHAR2 |
1 |
IS_VIETNAM_VETERAN |
An indicator that the person is a Vietnam veteran (Y or N) |
VARCHAR2 |
1 |
IS_WHITE |
If the employee has identified herself as White, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
1 |
MULTIPLE_RACES_REPORTED_CNT |
XXX |
NUMBER |
|
NATIVE_HAWAIIAN_CNT |
XXX |
NUMBER |
|
NEWLY_SEPARATED_VETERAN_CNT |
XXX |
NUMBER |
|
NOT_A_VETERAN_CNT |
XXX |
NUMBER |
|
NO_ETHNICITY_ON_RECORD_CNT |
XXX |
NUMBER |
|
NO_RACE_ON_RECORD_CNT |
XXX |
NUMBER |
|
OTHER_CNT |
XXX |
NUMBER |
|
OTHER_VETERAN_CNT |
XXX |
NUMBER |
|
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
PROTECTED_VETERAN_CNT |
XXX |
NUMBER |
|
RECENTLY_SEPARATED_VETERAN_CNT |
XXX |
NUMBER |
|
RECORD_SOURCE |
XXX |
VARCHAR2 |
2 |
SPECIAL_DISABLED_VETERAN_CNT |
XXX |
NUMBER |
|
VIETNAM_VETERAN_CNT |
XXX |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WHITE_CNT |
XXX |
NUMBER |