HRS_BIPDIVETH_L

(SQL View)
 Index Back

Ethnic Diversity


SELECT A.HRS_PERSON_ID , A.HRS_REG_REGION , A.HRS_ETHNIC_GRP_CD , B.LANGUAGE_CD , B.DESCR50 FROM PS_HRS_APP_DIV_ETH A , PS_HRS_ETH_GRP_LNI 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'

  • Related Language Record for HRS_BIP_DIV_ETH

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 HRS_ETHNIC_GRP_TXT Character(100) VARCHAR2(100) NOT NULL Ethnic Group