HR_RW_SRCH_LNG

(SQL Table)
 Index Back

Job Data Temp Record

This temp record has been created to extract all the Job Data and to bypass the query security record.

  • Related Language Record for HR_RMWRK_DAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: PER_ORG_ASGN.EMPLID

    Prompt Table: PERS_SRCH_GBL

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HR_SRCH_POS_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    5 HR_SRCH_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    6 HR_SRCH_DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department
    7 HR_SRCH_JBCD_DESCR Character(30) VARCHAR2(30) NOT NULL Job Title
    8 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    9 NAME Character(50) VARCHAR2(50) NOT NULL Name
    10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    11 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    12 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    13 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    14 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    15 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    16 HR_SRCH_PYGP_DESCR Character(30) VARCHAR2(30) NOT NULL Paygroup Description
    17 HR_SRCH_GPPY_DESCR Character(30) VARCHAR2(30) NOT NULL GP paygroup Description
    18 HR_SRCH_CMP_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    19 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    20 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    21 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    22 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    23 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
    24 REPORTS_TO_DESCR Character(50) VARCHAR2(50) NOT NULL Reports To
    25 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    26 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    27 HR_RW_REASON Character(60) VARCHAR2(60) NOT NULL Remote Worker Reason
    28 RW_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Worker Type
    29 RW_PERCENT_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Work Percent
    30 GENDER_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    31 HR_VET_DESCR Character(50) VARCHAR2(50) NOT NULL Veteran Description
    32 HR_RW_LTYP_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Location Type
    33 HR_RW_LOCATION Character(30) VARCHAR2(30) NOT NULL Remote Work Location