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 , B.HRS_LOGICAL_DELETE , B.STATUS_CODE ,MAX(A.HRS_ROW_UPD_DTTM) , A.HRS_INT_DT , A.HRS_SEQ_NUM 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 , A.HRS_INT_DT, A.HRS_SEQ_NUM, B.HRS_JOB_OPENING_ID, B.HRS_LOGICAL_DELETE, B.STATUS_CODE

  • 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_LOGICAL_DELETE Character(1) VARCHAR2(1) NOT NULL Indicates row has been logically deleted.
    9 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    11 HRS_INT_DT Date(10) DATE Interview date
    12 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number