JPM_SRCH_PP_LNG

(SQL Table)
 Index Back

JPM Job Data Preprocessor

Stores all extracted Job Data for the Person Profile preprocessor step for the Schedule Search Index (search definition HC_JPM_PERSON_PROFILE).

  • Related Language Record for JPM_SRCH_PP_DAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 JPM_SRCH_BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business Unit
    6 JPM_SRCH_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    7 JPM_SRCH_REG_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    8 JPM_SRCH_DPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department
    9 JPM_SRCH_JBCD_DSCR Character(30) VARCHAR2(30) NOT NULL Job Title