GM_EC_RACE

(SQL View)
 Index Back

Personal Race

It is for forms mapping of page KK on NIH398

SELECT EMPLID , AMERICAN_INDIAN , ASIAN , BLACK , NATIVE_HAWAIIAN , NOT_APPLICABLE , WHITE FROM PS_GM_PERS_DATA A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_GM_PERS_DATA B WHERE A.EMPLID=B.EMPLID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 AMERICAN_INDIAN Character(1) VARCHAR2(1) NOT NULL American Indian/Alaska Native

Y/N Table Edit

3 ASIAN Character(1) VARCHAR2(1) NOT NULL Asian

Y/N Table Edit

4 BLACK Character(1) VARCHAR2(1) NOT NULL Black/African American

Y/N Table Edit

5 NATIVE_HAWAIIAN Character(1) VARCHAR2(1) NOT NULL Native Hawaiian/Pacific Island

Y/N Table Edit

6 NOT_APPLICABLE Character(1) VARCHAR2(1) NOT NULL Not Applicable

Y/N Table Edit

7 WHITE Character(1) VARCHAR2(1) NOT NULL White

Y/N Table Edit