HRS_LISTCMPL_V3

(SQL View)
 Index Back

Applicant Lists

Applicant Lists

SELECT LSTAPP.HRS_LST_ID , APPDTL.SRCH_SCORE , LSTAPP.HRS_PERSON_ID , APPNAME.NAME_DISPLAY , APPDTL.HRS_SUBMITTED_DTTM , APPDTL.HRS_SCORE FROM PS_HRS_LIST LST , PS_HRS_LIST_APPL LSTAPP , PS_HRS_APP_NAME_I 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: HRS_LISTCMPL_L3

    • # 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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    5 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    6 HRS_SCORE Number(8,4) DECIMAL(7,4) NOT NULL Field to display search score in 4.4 format