HRS_CRSEML_LVW2

(SQL View)
Index Back

SELECT C.HRS_CRSP_ID , A.HRS_PERSON_ID , C.LANGUAGE_CD , 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

  • 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 HRS_CRSP_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    5 HRS_CRSP_MSG Long Character CLOB Message