HRS_LISTCMPL_V1

(SQL View)
 Index Back

Profile Match JO results

Profile Match JO results

SELECT LST.HRS_LST_ID , JOB.SRCH_SCORE , JOB.HRS_JOB_OPENING_ID , %Substring(POST.POSTING_TITLE, 1, 30) FROM PS_HRS_LIST LST , PS_HRS_JO_POSTING POST , PS_HRS_LIST_JOB JOB , PS_HRS_SRCH_SAVED SAVED WHERE JOB.HRS_LST_ID = LST.HRS_LST_ID AND JOB.HRS_JOB_OPENING_ID <> 0 AND POST.HRS_JOB_OPENING_ID = JOB.HRS_JOB_OPENING_ID AND LST.HRS_LST_TYPE = 'SSJO' 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_L1

    • # 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 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description