HRS_APP_CRSP_VW

(SQL View)
 Index Back

Correspondence Work View

Correspondence Work View for display in Manage Applicant

SELECT A.HRS_PERSON_ID , A.HRS_NOTES_ID , 0 , ' ' , A.HRS_NOTES_SUBJ , A.HRS_CNTCT_MTHD_ID , ' ' , A.HRS_NOTE_AUD , A.HRS_CNTCT_DT , ' ' , A.HRS_OWNER_ID , ' ' , %subrec(HRS_AUDIT_SBR,A) , A.HRS_APPL_NOTES FROM PS_HRS_APP_NOTES_I A

  • Related Language Record: HRS_NTS_LNG_VW

    • # 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_NOTES_ID Number(10,0) DECIMAL(10) NOT NULL Notes Id
    3 HRS_CRSP_ID Number(15,0) DECIMAL(15) NOT NULL Correspondence ID
    4 HRS_CRSP_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    5 HRS_NOTES_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    6 HRS_CNTCT_MTHD_ID Number(15,0) DECIMAL(15) NOT NULL Contact Method

    Prompt Table: HRS_CNTCT_METHD

    7 HRS_CNTCT_TYPE Character(4) VARCHAR2(4) NOT NULL Contact Type
    CRSP=Correspondence
    E=Email
    FRWD=Forward Applicant
    T=Text
    8 HRS_NOTE_AUD Character(1) VARCHAR2(1) NOT NULL Indicates to whom the attachment should be visible.
    1=Private
    2=Public
    3=Candidate
    9 HRS_CNTCT_DT Date(10) DATE Contact Date

    Default Value: %date

    10 HRS_CRSP_CHNL Character(4) VARCHAR2(4) NOT NULL Contact Method
    EML=Email
    LTR=Letter
    11 HRS_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Owner ID

    Prompt Table: HRS_PERSON_NM_I

    12 HRS_CRSP_AUD Character(1) VARCHAR2(1) NOT NULL Access
    1=Public
    2=Private
    13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    17 HRS_APPL_NOTES Long Character CLOB Notes