HR_PG_WF_DIV_VW

(SQL View)
 Index Back

Workforce Diversity

Workforce Diversity View for HR Analytics

SELECT EMPLID , EMPL_RCD , HR_DIV_TYPE , DESCR100 , HR_STATUS_DESCR , NAME , SEX , MAR_STATUS , HIGHEST_EDUC_LVL , MILITARY_STATUS , ETHNIC_GROUP , EFFDT , REG_TEMP , FULL_PART_TIME , EEO1CODE , EEO4CODE , JOBCODE_DESCR , POSN_DESCR , JOB_DESCR , LOCATION_DESCR , DEPT_DESCR , BUSINESS_DESCR , COMPANY_DESCR , EMPL_TYPE_DESCR , REG_REGION_DESCR , MANAGER_NAME , DISABILITY_STS_USA , AGE , HR_AGE_RANGE , VETERAN_STATUS , FROMDATE , THRUDATE FROM PS_HR_PG_WF_DIVERS

  • Related Language Record: HR_PG_WF_DV_LVW

    • # 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 HR_DIV_TYPE Character(1) VARCHAR2(1) NOT NULL Field used to list Diversity Types.
    A=Age
    D=Disability
    E=Ethnicity
    G=Gender
    V=Veteran Status
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 HR_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL HR Status
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    8 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    9 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level
    10 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
    11 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
    12 EFFDT Date(10) DATE Effective Date
    13 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    14 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    15 EEO1CODE Character(1) VARCHAR2(1) NOT NULL EEO-1 Job Category
    1=Officials and Managers
    2=Professionals
    3=Technicians
    4=Sales Workers
    5=Administrative Support Workers
    6=Craft Workers
    7=Operatives
    8=Laborers and Helpers
    9=Service Workers
    A=Executive/Sr Level Officials
    B=First/Mid Level Officials
    N=No EEO-1 Reporting
    16 EEO4CODE Character(1) VARCHAR2(1) NOT NULL EEO-4 Job Category
    1=Officials and Administrators
    2=Professionals
    3=Technicians
    4=Protective Service
    5=Paraprofessionals
    6=Administrative Support
    7=Skilled Craft
    8=Service Maintenance
    N=No EEO-4 Reporting
    17 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    18 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    19 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
    20 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    21 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    22 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    23 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    24 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    25 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    26 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
    27 DISABILITY_STS_USA Character(1) VARCHAR2(1) NOT NULL Disability (Section 503) Status USA
    N=Not Disabled
    X=Not Indicated
    Y=Disabled
    28 AGE Number(3,0) SMALLINT NOT NULL Age
    29 HR_AGE_RANGE Character(1) VARCHAR2(1) NOT NULL Age Range
    1=<18
    2=18-24
    3=25-34
    4=35-44
    5=45-54
    6=55-64
    7=65+
    N=Not Available
    30 VETERAN_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status
    N=Not a Veteran
    X=Not Indicated
    Y=Veteran
    31 FROMDATE Date(10) DATE From Date
    32 THRUDATE Date(10) DATE End Date