SAA_NOTE_VW_LNG

(SQL View)
 Index Back

Advisor Notes View Rel Lang

Related language record for view SAA_ADVNOTE_VW

SELECT A.EMPLID , A.INSTITUTION , A.SAA_NOTE_ID , B.SAA_ITEM_SEQ , A.LANGUAGE_CD , A.SAA_NOTE_SUBJ FROM PS_SAA_NOTE_LNG A , PS_SAA_ADV_NOTEDTL B WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.SAA_NOTE_ID = B.SAA_NOTE_ID AND B.SAA_ITEM_SEQ = ( SELECT MAX(B1.SAA_ITEM_SEQ) FROM PS_SAA_ADV_NOTEDTL B1 WHERE B1.EMPLID = B.EMPLID AND B1.INSTITUTION = B.INSTITUTION AND B1.SAA_NOTE_ID = B.SAA_NOTE_ID)

  • Related Language Record for SAA_ADVNOTE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 SAA_NOTE_ID Character(5) VARCHAR2(5) NOT NULL This field denotes the note sequence ID for a particular advisee and institution.
    4 SAA_ITEM_SEQ Number(6,0) INTEGER NOT NULL Denotes the sequence of the note items logged.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 SAA_NOTE_SUBJ Character(50) VARCHAR2(50) NOT NULL This field denote the subject / title of an advisor note.