HR_PG_WF_DV_LNG

(SQL Table)
 Index Back

Workforce Diversity

Workforce Diversity related language record for HR Analytics

  • Related Language Record for HR_PG_WF_DIVERS

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 HR_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL HR Status
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    10 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    13 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    14 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    15 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    16 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    17 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    18 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    19 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    20 JOBTITLE_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    21 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    22 DEPTNAME_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    23 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    24 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    25 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
    26 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    27 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    28 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    29 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    30 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    31 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    32 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name