HRS_BIP_SRCE_VW

(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 , A.HRS_SOURCE_ID , B.HRS_SOURCE_NAME , A.HRS_SUBSOURCE_ID , SUB.HRS_SUBSOURCE_DESC , A.HRS_SUBSOURCE_DESC , ' ' , ' ' , ' ' , ' ' FROM PS_HRS_AL_LOG_SRCE A LEFT OUTER JOIN PS_HRS_SUBSRC_VW_I SUB ON SUB.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND SUB.HRS_SUBSOURCE_ID = A.HRS_SUBSOURCE_ID , PS_HRS_SRC_SU_PT_I B WHERE B.HRS_SOURCE_ID = A.HRS_SOURCE_ID

  • Related Language Record: HRS_BIP_SRCELVW

    • # 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 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID

    Prompt Table: HRS_SRC_SU_PT_I

    4 HRS_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name
    5 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Subsource Id

    Prompt Table: HRS_SUBSRC_VW_I

    6 HRS_SOURCE_DESCR Character(254) VARCHAR2(254) NOT NULL Description of the Source
    7 HRS_SUBSOURCE_DESC Character(50) VARCHAR2(50) NOT NULL Subsource Description
    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    9 EMPL_NAME Character(50) VARCHAR2(50) NOT NULL Employee Name
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 REFERRER_NAME Character(50) VARCHAR2(50) NOT NULL Referral Name