HRS_NTS_LNG_VW

(SQL View)
Index Back

Contact Notes related language

Contact Notes related language record

SELECT A.HRS_PERSON_ID , A.HRS_NOTES_ID , 0 , A.LANGUAGE_CD , A.HRS_NOTES_SUBJ , A.HRS_APPL_NOTES FROM PS_HRS_APP_NTS_LNG A

  • Related Language Record for HRS_APP_CRSP_VW HRS_NOTE_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 HRS_NOTES_SUBJ Character(254) VARCHAR2(254) NOT NULL Subject
    6 HRS_APPL_NOTES Long Character CLOB Notes