HRS_LISTCMPL_L3

(SQL View)
 Index Back

Applicant Lists

Applicant Lists

SELECT LSTAPP.HRS_LST_ID , APPDTL.SRCH_SCORE , LSTAPP.HRS_PERSON_ID , APPNAME.LANGUAGE_CD , APPNAME.NAME_DISPLAY FROM PS_HRS_LIST LST , PS_HRS_LIST_APPL LSTAPP , PS_HRS_APP_NAME_LN APPNAME , PS_HRS_LIST_APPDTL APPDTL , PS_HRS_SRCH_SAVED SCHSAV WHERE LST.HRS_LST_ID = LSTAPP.HRS_LST_ID AND LST.HRS_LST_ID = APPDTL.HRS_LST_ID AND LSTAPP.HRS_PERSON_ID = APPNAME.HRS_PERSON_ID AND LSTAPP.HRS_PERSON_ID = APPDTL.HRS_PERSON_ID AND LST.HRS_LST_TYPE = 'SSRL' AND (LST.HRS_SAVE_UNTIL IS NULL OR LST.HRS_SAVE_UNTIL >=%CurrentDateIn) AND SCHSAV.SEARCH_NAME = %Substring(LST.HRS_SEARCH_NAME,1,20) AND ((SCHSAV.HRS_OWNER_ID = LST.HRS_OWNER_ID AND SCHSAV.HRS_SCH_ACCESS = 'V') OR SCHSAV.HRS_SCH_ACCESS = 'P') AND (SCHSAV.HRS_SCH_TYPE = 'P')

  • Related Language Record for HRS_LISTCMPL_V3

    • # 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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country