HR_WF_DIV_LN_VW

(SQL View)
 Index Back

Workforce Diversity

Workforce Diversity View for HR Analytics

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.LANGUAGE_CD , A.HR_STATUS_DESCR , A.NAME , A.JOBCODE_DESCR , A.POSN_DESCR , A.JOB_DESCR , A.LOCATION_DESCR , A.DEPT_DESCR , A.BUSINESS_DESCR , A.COMPANY_DESCR , A.EMPL_TYPE_DESCR , A.REG_REGION_DESCR , A.MANAGER_NAME , %Coalesce((SELECT AGE.DESCR100 FROM PS_HR_PG_WF_DV_LNG AGE WHERE AGE.EMPLID = A.EMPLID AND AGE.EMPL_RCD = A.EMPL_RCD AND AGE.LANGUAGE_CD = A.LANGUAGE_CD AND AGE.HR_DIV_TYPE = 'A' ), ' ') , %Coalesce((SELECT DIS.DESCR100 FROM PS_HR_PG_WF_DV_LNG DIS WHERE DIS.EMPLID = A.EMPLID AND DIS.EMPL_RCD = A.EMPL_RCD AND DIS.LANGUAGE_CD = A.LANGUAGE_CD AND DIS.HR_DIV_TYPE = 'D'), ' ') , %Coalesce((SELECT ETH.DESCR100 FROM PS_HR_PG_WF_DV_LNG ETH WHERE ETH.EMPLID = A.EMPLID AND ETH.EMPL_RCD = A.EMPL_RCD AND ETH.LANGUAGE_CD = A.LANGUAGE_CD AND ETH.HR_DIV_TYPE = 'E'), ' ') , %Coalesce((SELECT SEX.DESCR100 FROM PS_HR_PG_WF_DV_LNG SEX WHERE SEX.EMPLID = A.EMPLID AND SEX.EMPL_RCD = A.EMPL_RCD AND SEX.LANGUAGE_CD = A.LANGUAGE_CD AND SEX.HR_DIV_TYPE = 'G'), ' ') , %Coalesce((SELECT VET.DESCR100 FROM PS_HR_PG_WF_DV_LNG VET WHERE VET.EMPLID = A.EMPLID AND VET.EMPL_RCD = A.EMPL_RCD AND VET.LANGUAGE_CD = A.LANGUAGE_CD AND VET.HR_DIV_TYPE = 'V'), ' ') FROM PS_HR_PG_WF_DV_LNG A

  • Related Language Record for HR_WF_DIVERS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HR_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL HR Status
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    7 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    8 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
    9 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    10 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    11 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    12 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    13 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    14 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    15 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
    16 AGE_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    17 DISABLED_STS_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    18 ETHNIC_GRP_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    19 GENDER_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    20 VETERAN_STS_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).