JPM_SRCH_JOB_VW

(SQL View)
 Index Back

JPM Search Job view

Used by the JPM Person Profile search definition for facets

SELECT J.JPM_PROFILE_ID , J.EMPLID ,J.EMPL_RCD ,J.REG_TEMP ,J.FULL_PART_TIME ,J.JPM_SRCH_BU_DESCR ,J.JPM_SRCH_DPT_DESCR ,J.JPM_SRCH_JBCD_DSCR ,J.JPM_SRCH_LOC_DESCR ,J.JPM_SRCH_REG_DESCR FROM PS_JPM_SRCH_PP_DAT J

  • Related Language Record: JPM_SRCH_JOB_LV

    • # 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 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    5 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    6 JPM_SRCH_BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business Unit
    7 JPM_SRCH_DPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department
    8 JPM_SRCH_JBCD_DSCR Character(30) VARCHAR2(30) NOT NULL Job Title
    9 JPM_SRCH_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    10 JPM_SRCH_REG_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region