SAA_NOTEDTL_LNG (SQL Table)	Index Back
Advisor Notes Detail Lng This record is the related language table for advisor notes detail record (SAA_ADV_NOTEDTL)

SAA_NOTEDTL_LNG

(SQL Table)

Advisor Notes Detail Lng

This record is the related language table for advisor notes detail record (SAA_ADV_NOTEDTL)

Related Language Record for SAA_ADV_NOTEDTL

# 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.

#	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.