SAA_NOTESRCH_VW (SQL View)	Index Back
Advisor Notes search record Search record for the advising notes admin pages.

SAA_NOTESRCH_VW

(SQL View)

Advisor Notes search record

Search record for the advising notes admin pages.

SELECT A.INSTITUTION , A.EMPLID , A.SAA_NOTE_ID , B.LAST_NAME , B.FIRST_NAME , A.ADVISOR_ID , A.SCC_ROW_ADD_OPRID , B.NAME , A.SAA_NOTE_TYPE , A.SAA_NOTE_SUBTYPE , C.NAME_DISPLAY , D.SAA_OPRID_NAME , A.SAA_NOTE_ADD_DT , C.OPRCLASS , D.EMPLID FROM PS_SAA_ADV_NOTE A , PS_HCR_PERSON_NM_I B , PS_PEOPLE_SRCH C , PS_SAA_NAME_OPRID D WHERE B.EMPLID = A.EMPLID AND C.EMPLID = A.ADVISOR_ID AND D.SCC_ROW_ADD_OPRID = A.SCC_ROW_ADD_OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

3 SAA_NOTE_ID Character(5) VARCHAR2(5) NOT NULL This field denotes the note sequence ID for a particular advisee and institution.

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

6 ADVISOR_ID Character(11) VARCHAR2(11) NOT NULL This field is used to identify advisors assigned to a student.
Prompt Table: PEOPLE_SRCH

7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

8 NAME Character(50) VARCHAR2(50) NOT NULL Name

9 SAA_NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL This field denotes an advising note's category code.
Prompt Table: SAA_NOTE_TYPE

10 SAA_NOTE_SUBTYPE Character(10) VARCHAR2(10) NOT NULL This field denotes an advising note's subcategory code.
Prompt Table: SAA_NOTE_STYPE

11 SAA_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the name of the oprid when requesting advising reports.

12 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

13 SAA_NOTE_ADD_DT Date(10) DATE Denotes when the advisor note was created

14 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

15 EMPLID_CREATOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the person who originally created a note.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
3	SAA_NOTE_ID	Character(5)	VARCHAR2(5) NOT NULL	This field denotes the note sequence ID for a particular advisee and institution.
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	ADVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	This field is used to identify advisors assigned to a student. Prompt Table: PEOPLE_SRCH
7	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	SAA_NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This field denotes an advising note's category code. Prompt Table: SAA_NOTE_TYPE
10	SAA_NOTE_SUBTYPE	Character(10)	VARCHAR2(10) NOT NULL	This field denotes an advising note's subcategory code. Prompt Table: SAA_NOTE_STYPE
11	SAA_OPRID_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to display the name of the oprid when requesting advising reports.
12	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
13	SAA_NOTE_ADD_DT	Date(10)	DATE	Denotes when the advisor note was created
14	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
15	EMPLID_CREATOR	Character(11)	VARCHAR2(11) NOT NULL	HR Notepad: Employee ID of the person who originally created a note.