HRS_BIP_SRCELVW

(SQL View)
 Index Back

Resume Extraction Log

Log of all resumes recieved, where they were recieved from and their current state

SELECT A.HRS_AL_LOG_ID , A.HRS_AL_LOG_SRC_SEQ , B.LANGUAGE_CD , B.HRS_SOURCE_NAME , C.HRS_SUBSOURCE_DESC , ' ' FROM PS_HRS_AL_LOG_SRCE A , PS_HRS_SRC_SUPT_LI B , PS_HRS_SUBSRC_LN_I C WHERE B.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND C.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND C.HRS_SUBSOURCE_ID = A.HRS_SUBSOURCE_ID AND C.LANGUAGE_CD = B.LANGUAGE_CD UNION SELECT A.HRS_AL_LOG_ID , A.HRS_AL_LOG_SRC_SEQ , B.LANGUAGE_CD , B.HRS_SOURCE_NAME , ' ' , ' ' FROM PS_HRS_AL_LOG_SRCE A , PS_HRS_SRC_SUPT_LI B WHERE B.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_SUBSRC_LN_I C WHERE C.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND C.HRS_SUBSOURCE_ID = A.HRS_SUBSOURCE_ID AND C.LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for HRS_BIP_SRCE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
    2 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HRS_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name
    5 HRS_SOURCE_DESCR Character(254) VARCHAR2(254) NOT NULL Description of the Source
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description