HRS_BIPCG_SRC_V

(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 , B.HRS_SOURCE_DESCR , A.HRS_SUBSOURCE_DESC , SUB.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_ALSRC_L

    • # 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 DESCR100B Character(100) VARCHAR2(100) NOT NULL Description
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    10 EMPL_NAME Character(50) VARCHAR2(50) NOT NULL Employee Name
    11 YESNO_LBL Character(25) VARCHAR2(25) NOT NULL Used on work records to be the label for page fields.
    12 REFERRER_NAME Character(50) VARCHAR2(50) NOT NULL Referral Name
    13 EMAIL_ADDR2 Character(70) VARCHAR2(70) NOT NULL Email Address