HRS_INT_NOTE_VW

(SQL View)
 Index Back

Interview Notes view

Interview Notes and Comments

SELECT NOTE.HRS_PERSON_ID , NOTE.HRS_RCMNT_ID , NOTE.HRS_RCM_INT_ID , NOTE.HRS_NOTE_SEQ , NOTE.HRS_NOTE_DT , NOTE.HRS_NOTES_SUBJ , NOTE.HRS_NOTE , NOTE.HRS_ROW_ADD_OPRID FROM PS_HRS_INT_NOTE NOTE

  • 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_NOTE_SEQ Number(15,0) DECIMAL(15) NOT NULL Note Sequence

    Default Value: 0

    5 HRS_NOTE_DT Date(10) DATE Note Date

    Default Value: %Date

    6 HRS_NOTES_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    7 HRS_NOTE Long Character CLOB Note
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id