HRS_INT_VEN_VW

(SQL View)
 Index Back

Interview Venue View

Interview Venue

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_RCM_INT_ID , A.HRS_INT_VENUE_ID , A.HRS_INT_VEN_STAT , B.HRS_INT_VENUE ,B.HRS_VENUE_EMAIL ,B.INTVW_LOCATION FROM PS_HRS_INT_VENUE A , PS_HRS_VENUE_TBL B WHERE A.HRS_INT_VENUE_ID = B.HRS_INT_VENUE_ID

  • Parent record: HRS_RCM_INT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

    Prompt Table: HRS_APPLICANT_I

    2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID

    Prompt Table: HRS_RCMNT

    3 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID

    Prompt Table: HRS_RCM_INT

    4 HRS_INT_VENUE_ID Number(15,0) DECIMAL(15) NOT NULL Venue ID

    Prompt Table: HRS_VENUE_TBL

    5 HRS_INT_VEN_STAT Character(1) VARCHAR2(1) NOT NULL Interview Venue Status
    A=Accepted
    D=Declined
    N=None
    T=Tentative
    6 HRS_INT_VENUE Character(50) VARCHAR2(50) NOT NULL Venue for interview

    Prompt Table: HRS_VENUE_TBL

    7 HRS_VENUE_EMAIL Character(70) VARCHAR2(70) NOT NULL Venue Email Address

    Prompt Table: HRS_VENUE_TBL

    8 INTVW_LOCATION Character(254) VARCHAR2(254) NOT NULL Interview Location