HRS_CRSPNOTF_VW

(SQL View)
 Index Back

Correspondence View

Correspondence View

SELECT A.HRS_CRSP_ID , B.HRS_PERSON_ID , A.HRS_TMPL_ID , A.HRS_CRSP_CHNL , A.HRS_CNTCT_TYPE , A.HRS_CNTCT_DT , B.HRS_CRSP_SUBJ , A.HRS_OWNER_ID , A.HRS_CRSP_AUD , %subrec(HRS_AUDIT_SBR,A) , A.HRS_CRSP_MSG FROM PS_HRS_SEND_CRSP A , PS_HRS_APP_CRSP B WHERE A.HRS_CRSP_ID=B.HRS_CRSP_ID AND B.HRS_CRSPAPP_DEL_HM='N' UNION ALL SELECT A.HRS_CRSP_ID , B.HRS_PERSON_ID , A.HRS_TMPL_ID , A.HRS_CRSP_CHNL , A.HRS_CNTCT_TYPE , A.HRS_CNTCT_DT , A.HRS_CRSP_SUBJ , A.HRS_OWNER_ID , A.HRS_CRSP_AUD , %subrec(HRS_AUDIT_SBR,A) , A.HRS_CRSP_MSG FROM PS_HRS_SEND_CRSP A , PS_HRS_APP_FRWD B WHERE A.HRS_CRSP_ID=B.HRS_CRSP_ID

  • Related Language Record: HRS_CRSPNOTF_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_CRSP_ID Number(15,0) DECIMAL(15) NOT NULL Correspondence ID
    2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    3 HRS_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template ID

    Prompt Table: HRS_CRSPTMPL_VW
    Set Control Field: HRS_TMPL_ID

    4 HRS_CRSP_CHNL Character(4) VARCHAR2(4) NOT NULL Contact Method
    EML=Email
    LTR=Letter

    Default Value: EML

    5 HRS_CNTCT_TYPE Character(4) VARCHAR2(4) NOT NULL Contact Type
    CRSP=Correspondence
    E=Email
    FRWD=Forward Applicant
    T=Text
    6 HRS_CNTCT_DT Date(10) DATE Contact Date
    7 HRS_CRSP_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    8 HRS_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Owner ID
    9 HRS_CRSP_AUD Character(1) VARCHAR2(1) NOT NULL Access
    1=Public
    2=Private
    10 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    14 HRS_APPL_NOTES Long Character CLOB Notes