HRS_CRSEML_LVW2

(SQL View)
 Index Back

SELECT C.HRS_CRSP_ID , A.HRS_PERSON_ID , C.LANGUAGE_CD , A.LAST_NAME , A.FIRST_NAME , A.NAME_DISPLAY , C.HRS_CRSP_SUBJ , C.HRS_CRSP_MSG FROM PS_HRS_APP_NAME_LN A , PS_HRS_APP_EMAIL_I B , PS_HRS_APPCRSP_LNG C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.LANGUAGE_CD = C.LANGUAGE_CD UNION ALL SELECT C.HRS_CRSP_ID , A.HRS_PERSON_ID , C.LANGUAGE_CD , A.LAST_NAME , A.FIRST_NAME , A.NAME_DISPLAY , C.HRS_CRSP_SUBJ , C.HRS_CRSP_MSG FROM PS_HRS_APP_NAME_I A , PS_HRS_APP_EMAIL_I B , PS_HRS_APPCRSP_LNG C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NAME_LN AL WHERE AL.HRS_PERSON_ID = A.HRS_PERSON_ID AND AL.LANGUAGE_CD = C.LANGUAGE_CD) UNION ALL SELECT C.HRS_CRSP_ID , A.HRS_PERSON_ID , A.LANGUAGE_CD , A.LAST_NAME , A.FIRST_NAME , A.NAME_DISPLAY , C.HRS_CRSP_SUBJ , C.HRS_CRSP_MSG FROM PS_HRS_APP_NAME_LN A , PS_HRS_APP_EMAIL_I B , PS_HRS_APP_CRSP C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APPCRSP_LNG CL WHERE CL.HRS_PERSON_ID = C.HRS_PERSON_ID AND CL.LANGUAGE_CD = A.LANGUAGE_CD)

  • Related Language Record for HRS_CRSPEML_VW2 HRS_CRSPEML_VW3

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    7 HRS_CRSP_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    8 HRS_CRSP_MSG Long Character CLOB Message