Table: external_person_note
Description: (needs imrovement, clarification, detail) Notes from any system can be saved in the table for display in SSP. Notes can originate from any system and will be displayed to the user in chronological order.
Any other information that is necessary - put it here.
Tool: Notes
This tool allows for a central location of advising/coaching notes to assist with advising/coaching activities. SSP can display notes, comments, etc.
from other systems that are loaded into SSP. The notes, comments, etc. are loaded into the external database for display purposes only.
New notes and comments are created using the Journal tool.
Attachments:
| Parameter | External Table | Location | Field Name | Description | Example | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| <code> | externaldate_ | person_note | Notes | N/A | Unique identifier for the note | NOT DISPLAYED IN UI | <school_id>_taken | external_person_note | Notes | N/A | Student's id or other identifier used by the institution to identify students, faculty, or other staff. | NOT DISPLAYED IN UIDate | The date the note was created | 09/13/2012 |
| note_type | external_person_note | Notes | Type | The type of note commonly used to define the source system | Legacy | |||||||||
| author | external_person_note | Notes | Author | The creator of the note in the external system | Previous Advisor | |||||||||
| department | external_person_note | Notes | Department | The department of the author who created the note | Advising | date | external_person_note | Notes | Date | The date the note was created | 09/13/2012 | |||
| note | external_person_note | Notes | Note | The note, comment or remark | Elizabeth wishes to change... |