SAA_NTDTL_VW_LN

(SQL View)
Index Back

Advisor Note Detail View Rel

Related language record for the note detail view record (SAA_NOTEDTL_VW)

SELECT EMPLID , INSTITUTION , SAA_NOTE_ID , SAA_ITEM_SEQ , LANGUAGE_CD , SAA_NOTE_ITM_LONG FROM PS_SAA_NOTEDTL_LNG

  • Related Language Record for SAA_NOTEDTL_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_ITM_LONG Long Character CLOB This field is used for the advising notes comments / items.