HR_JOB_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_JOB_SRCH_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 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
    15 PREF_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Last Name
    16 PREF_MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Middle Name
    17 PREF_SEC_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Second Last Name
    18 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    19 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    20 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    21 NAME_FORMAL_PSF Character(60) VARCHAR2(60) NOT NULL Preferred Name (PS FORMAT)
    22 HR_SRCH_PYGP_DESCR Character(30) VARCHAR2(30) NOT NULL Paygroup Description
    23 HR_SRCH_GPPY_DESCR Character(30) VARCHAR2(30) NOT NULL GP paygroup Description
    24 HR_SRCH_CMP_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    25 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    26 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    27 MIDDLE_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Middle Name uppercase search field
    28 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    29 PARTN_LAST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of partner last name to improve performance on searches.
    30 PREF_LAST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred last name to improve performance on searches.
    31 PREF_FIRST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    32 PREF_MIDL_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred middle name to improve performance on searches.
    33 PREF_LAST_SEC_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred second last name to improve performance on searches.
    34 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    35 NAME_FORMAL_SRCH Character(60) VARCHAR2(60) NOT NULL Uppercase version of formal name to improve performance on searches.
    36 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    37 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
    38 REPORTS_TO_DESCR Character(50) VARCHAR2(50) NOT NULL Reports To
    39 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    40 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description