HRS_APP_INT_NTF

(SQL View)
 Index Back

Intvw Schedule Notifications

Candidate Experience for the Applicant Homepage

SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_RCM_INT_ID , A.HRS_DISPL_HMPG , A.HRS_SCHD_APP_VWD , A.HRS_SCHDAPP_DEL_HM , B.HRS_JOB_OPENING_ID ,MAX(A.HRS_ROW_UPD_DTTM) FROM PS_HRS_SCHD_NOTF_I A , PS_HRS_RCMNT_I B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RCMNT_ID = B.HRS_RCMNT_ID GROUP BY A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_RCM_INT_ID , A.HRS_DISPL_HMPG , A.HRS_SCHD_APP_VWD , A.HRS_SCHDAPP_DEL_HM , B.HRS_JOB_OPENING_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_DISPL_HMPG Character(1) VARCHAR2(1) NOT NULL Display Schedule to Applicant

    Y/N Table Edit

    Default Value: N

    5 HRS_SCHD_APP_VWD Character(1) VARCHAR2(1) NOT NULL Viewed on Applicant Homepage

    Y/N Table Edit

    Default Value: N

    6 HRS_SCHDAPP_DEL_HM Character(1) VARCHAR2(1) NOT NULL Delete from HomePage

    Y/N Table Edit

    Default Value: N

    7 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime