SAA_SS_RPT_OPT(SQL Table) |
Index Back |
|---|---|
Advisement Self-Service OptionThis record contains the academic advisement self-service options. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAA_USE_CRS_WHATIF | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate if a course what-if is allowed to be run.
Y/N Table Edit Default Value: N |
| 2 | SAA_CARRQTRM_WHSTD | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate the option to use either the What-If term table display option or the student career requirement term only for a matriculated student
1=Use Career Reqmnt Term Only 2=Use Term Table Setup Default Value: 1 |
| 3 | SAA_SS_RPT_ON_DMND | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to decide if advising reports are allowed to be run on demand in self service.
Y/N Table Edit Default Value: N |
| 4 | SAA_SS_OBEY_SYNCFL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to decide if advising reports are refreshed all the time, or only when the synchronization options set.
2=Refresh using synch options 4=Always refresh 6=Display Refresh link in fluid |
| 5 | SAA_MAX_WILD_CRSES | Number(3,0) | SMALLINT NOT NULL |
This field contains the maximum number of courses that can be displayed based on a wildcard defined in a course list.
Default Value: 10 |
| 6 | SAA_ADVSR_SCRTY | Character(1) | VARCHAR2(1) NOT NULL |
Advisor access obeys security
Y/N Table Edit Default Value: N |
| 7 | SAA_ENABLE_ACXCTRL | Character(1) | VARCHAR2(1) NOT NULL |
Enable Category Access Control
Y/N Table Edit Default Value: N |
| 8 | SAA_ADVSR_REMINDER | Character(1) | VARCHAR2(1) NOT NULL |
This field denotes whether advisors can add reminders to advisor notes.
Y/N Table Edit Default Value: Y |
| 9 | SAA_ADVSR_NOTIF | Character(1) | VARCHAR2(1) NOT NULL |
This field denotes whether advisors can send notifications to their advisees.
Y/N Table Edit Default Value: Y |
| 10 | SAA_NOTIFY_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Advising Notes Notification Method
F=Notification Framework P=Push Notification Default Value: F |
| 11 | SAA_NOTIFY_CREATE | Character(1) | VARCHAR2(1) NOT NULL |
Notify stakeholders upon creation of advising note
Y/N Table Edit Default Value: N |
| 12 | SAA_ADVSEE_NOTEUPD | Character(1) | VARCHAR2(1) NOT NULL |
This field denotes whether advisees can update advisor notes.
Y/N Table Edit |
| 13 | SAA_ADVSEE_ADDITEM | Character(1) | VARCHAR2(1) NOT NULL |
This field denotes whether advisees can add note items.
Y/N Table Edit |
| 14 | SAA_ADVSEE_ADDATCH | Character(1) | VARCHAR2(1) NOT NULL |
This field denotes whether advisees can add note attachments.
Y/N Table Edit |
| 15 | SAA_ADVSEE_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
This field denotes whether advisees will be notified when advisor notes are added/updated.
Y/N Table Edit |
| 16 | SAA_RPT_RFRSH_RATE | Number(5,1) | DECIMAL(4,1) NOT NULL |
Wait before next refresh NNN.N Hours
Default Value: 0 |
| 17 | SAA_CREATE_RPT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to create Academic Advisement Report
Y/N Table Edit Default Value: N |
| 18 | SAA_DISPLAY_CRSHIS | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate if Course History will be displayed in Advisement Report
Default Value: N |