HRS_BIP_DIV_ETH

(SQL View)
 Index Back

Ethnic Diversity


SELECT A.HRS_PERSON_ID , A.HRS_REG_REGION , A.HRS_ETHNIC_GRP_CD , A.ETHNIC_GROUP , A.SETID , A.PRIMARY_INDICATOR , B.DESCR50 FROM PS_HRS_APP_DIV_ETH A , PS_HRS_ETHNC_NNS_I B , PS_INSTALLATION C WHERE B.SETID = A.HRS_REG_REGION AND A.HRS_ETHNIC_GRP_CD = B.ETHNIC_GRP_CD AND C.FED = 'N' UNION SELECT A.HRS_PERSON_ID , ' ' , ' ' , A.ETHNIC_GROUP , ' ' , ' ' , ' ' FROM PS_HRS_APP_DIV A, PS_INSTALLATION C WHERE C.FED = 'Y'

  • Related Language Record: HRS_BIPDIVETH_L

  • Parent record: HRS_APP_DIV_REL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_REG_REGION Character(5) VARCHAR2(5) NOT NULL Reg Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: HRS_REG_REGN_I

    3 HRS_ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: %EDITTABLE

    4 ETHNIC_GROUP Character(1) VARCHAR2(1) NOT NULL Ethnic Group
    1=White
    2=Black/African American
    3=Hispanic/Latino
    4=Asian
    5=American Indian/Alaska Native
    6=Not Applicable
    7=Native Hawaiian/Oth Pac Island
    A=American Indian/Alaskan Native
    B=Asian or Pacific Islander
    C=Black, not of Hispanic origin
    D=Hispanic
    E=White, not of Hispanic origin
    F=Asian Indian
    G=Chinese
    H=Filipino
    J=Guamanian
    K=Hawaiian
    L=Japanese
    M=Korean
    N=Samoan
    P=Vietnamese
    Q=All Other Asian o Pacific Is
    Y=Not Hispanic in Puerto Rico
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator

    Y/N Table Edit

    Default Value: N

    7 HRS_ETHNIC_GRP_TXT Character(100) VARCHAR2(100) NOT NULL Ethnic Group