HRS_LISTCMPL_L1

(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 , POSTLNG.LANGUAGE_CD , %Substring(POSTLNG.POSTING_TITLE, 1, 30) FROM PS_HRS_LIST LST , PS_HRS_JO_POSTING POST , PS_HRS_LIST_JOB JOB , PS_HRS_SRCH_SAVED SAVED , PS_HRS_JO_PST_LNG POSTLNG 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' AND POSTLNG.HRS_JOB_OPENING_ID = POST.HRS_JOB_OPENING_ID AND POSTLNG.HRS_JO_PST_SEQ = POST.HRS_JO_PST_SEQ

  • Related Language Record for HRS_LISTCMPL_V1

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description