SAA_MYADVNOTE_V

(SQL View)
 Index Back

My Advising Notes

This view retrieves Advising Notes data used by CS_QRY_SAA_MY_ADVNOTES PS Query.

SELECT A.EMPLID , A.INSTITUTION , A.SAA_NOTE_ID , A.SAA_ITEM_SEQ , A.SAA_NOTE_TYPE , B.DESCR , A.SAA_NOTE_SUBTYPE , C.DESCR , A.ADVISOR_ID , A.SAA_NOTE_STATUS , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , A.SAA_NOTE_ADD_DT , A.SAA_NOTE_UPD_DT , A.SAA_NOTE_ACCESS , A.SAA_NOTE_CONTACT , A.SAA_NOTE_SUBJ , A.SAA_REM_OVR_STAT FROM PS_SAA_ADVNOTE_VW A , PS_SAA_NOTE_TYPE B , PS_SAA_NOTE_STYPE C WHERE B.INSTITUTION = A.INSTITUTION AND B.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND %EffdtCheck(SAA_NOTE_TYPE B1, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' AND C.INSTITUTION = A.INSTITUTION AND C.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND C.SAA_NOTE_SUBTYPE = A.SAA_NOTE_SUBTYPE AND %EffdtCheck(SAA_NOTE_STYPE C1, C, %CurrentDateIn) AND C.EFF_STATUS = 'A'

# 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 SAA_NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL This field denotes an advising note's category code.

Prompt Table: SAA_NOTE_TYPE

6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
7 SAA_NOTE_SUBTYPE Character(10) VARCHAR2(10) NOT NULL This field denotes an advising note's subcategory code.

Prompt Table: SAA_NOTE_STYPE

8 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
9 ADVISOR_ID Character(11) VARCHAR2(11) NOT NULL This field is used to identify advisors assigned to a student.
10 SAA_NOTE_STATUS Character(2) VARCHAR2(2) NOT NULL This field denoes the status of an advising note.
CL=Closed
OP=Open
11 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
12 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
13 SAA_NOTE_ADD_DT Date(10) DATE Denotes when the advisor note was created
14 SAA_NOTE_UPD_DT Date(10) DATE This field denotes when an advising note was last updated.
15 SAA_NOTE_ACCESS Character(1) VARCHAR2(1) NOT NULL Denotes the advisor note access
N=No
Y=Yes
16 SAA_NOTE_CONTACT Character(10) VARCHAR2(10) NOT NULL Advising Note Contact Type
17 SAA_NOTE_SUBJ Character(50) VARCHAR2(50) NOT NULL This field denote the subject / title of an advisor note.
18 SAA_REM_OVR_STAT Character(1) VARCHAR2(1) NOT NULL Denotes the advisor note overall reminder / action items status
N=None
O=Overdue
P=Pending