HRS_LISTCMPL_V2

(SQL View)
 Index Back

Profile Match JO results

Profile Match JO results

SELECT LST.HRS_LST_ID , PRFDTL.SRCH_SCORE , PRFDTL.JPM_PROFILE_ID , PROF.DESCR FROM PS_HRS_LIST LST , PS_JPM_PROFILE PROF , PS_HRS_LIST_PRFDTL PRFDTL , PS_HRS_SRCH_SAVED SAVED WHERE PRFDTL.HRS_LST_ID = LST.HRS_LST_ID AND PRFDTL.JPM_PROFILE_ID <> ' ' AND PROF.JPM_PROFILE_ID = PRFDTL.JPM_PROFILE_ID AND LST.HRS_LST_TYPE = 'SSPF' AND (LST.HRS_SAVE_UNTIL IS NULL OR LST.HRS_SAVE_UNTIL >=%CurrentDateIn) AND SAVED.SEARCH_NAME = %Substring(LST.HRS_SEARCH_NAME,1,20) AND ((SAVED.HRS_OWNER_ID = LST.HRS_OWNER_ID AND SAVED.HRS_SCH_ACCESS = 'V') OR SAVED.HRS_SCH_ACCESS = 'P') AND SAVED.HRS_SCH_TYPE = 'P'

  • Related Language Record: HRS_LISTCMPL_L2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_LST_ID Number(15,0) DECIMAL(15) NOT NULL List ID
    2 SRCH_SCORE Number(4,0) SMALLINT NOT NULL Search Score
    3 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.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description