HRS_APP_JOPSCR2

(SQL View)
 Index Back

Job - App Prescreen

view of jobs that have prescreening screening

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.HRS_JO_SCR_SUMM_ID , A.HRS_JO_SCR_SEQ , A.HRS_JOB_OPENING_ID , A.HRS_SITE_ID , A.HRS_STATUS_DT , A.HRS_SCR_STATUS , A.HRS_SCR_STS_RSN FROM PS_HRS_APP_JOPSCRN A , ps_hrs_jo_scr_lvl l , ps_hrs_screen_tbl t WHERE l.hrs_jo_scr_summ_id = a.hrs_jo_scr_summ_id AND l.hrs_jo_scr_seq = a.hrs_jo_scr_seq AND t.hrs_screening_id = l.hrs_screening_id AND t.status = 'A' AND t.hrs_pre_app_scr = 'Y' AND t.hrs_scr_aft_sub = 'N'

  • Parent record: HRS_RCMNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
    4 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
    5 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    6 HRS_SITE_ID Number(15,0) DECIMAL(15) NOT NULL Site ID
    7 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
    8 HRS_SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Screening Status
    1=Passed
    2=Failed
    9 HRS_SCR_STS_RSN Character(254) VARCHAR2(254) NOT NULL Screening Status Reason