SAA_ADV_NOTE(SQL Table) |
Index Back |
|---|---|
Advisor Note main recordThis record contains main advisor notes data |
| # | 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_NOTE_DST_NBR | Character(11) | VARCHAR2(11) NOT NULL | Advising Notes Destination Number |
| 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 | SAA_NOTE_SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL |
This field denotes an advising note's subcategory code.
Prompt Table: SAA_NOTE_STYPE |
| 7 | ADVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
This field is used to identify advisors assigned to a student.
Prompt Table: PEOPLE_SRCH |
| 8 | SAA_NOTE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
This field denoes the status of an advising note.
CL=Closed OP=Open Default Value: OP |
| 9 | SAA_NOTE_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Denotes the advisor note access
N=No Y=Yes Default Value: N |
| 10 | SAA_NOTE_CONTACT | Character(10) | VARCHAR2(10) NOT NULL |
Advising Note Contact Type
Prompt Table: SAA_NOTE_CNTACT |
| 11 | SAA_NOTE_SUBJ | Character(50) | VARCHAR2(50) NOT NULL | This field denote the subject / title of an advisor note. |
| 12 | SAA_NOTE_ADD_DT | Date(10) | DATE |
Denotes when the advisor note was created
Default Value: %date |
| 13 | SAA_NOTE_UPD_DT | Date(10) | DATE |
This field denotes when an advising note was last updated.
Default Value: %date |
| 14 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 15 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 16 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 17 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |