SSR_SS_OTHR_OPT(SQL Table) |
Index Back |
|---|---|
Other SR Self Service Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Default Value: OPR_DEF_TBL_CS.OPRID |
| 2 | DTTM_STAMP_SEC | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %date |
| 3 | SSR_DESCRIPTION | Character(240) | VARCHAR2(240) NOT NULL | Description |
| 4 | SSS_SC_ADVSR_PHONE | Character(1) | VARCHAR2(1) NOT NULL |
Show advisor phone number
Y/N Table Edit Default Value: N |
| 5 | SSS_PHONETYPE_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Phone type to use:
10=Use Advisor's Preferred Phone 20=Use This Phone Type: |
| 6 | SSS_ADVR_PHONETYPE | Character(4) | VARCHAR2(4) NOT NULL | Phone Type |
| 7 | SSR_VIEW_NONADVEE | Character(1) | VARCHAR2(1) NOT NULL |
Allow access to non-advisees
Y/N Table Edit Default Value: Y |
| 8 | SSR_SS_FAC_SEARCH | Character(1) | VARCHAR2(1) NOT NULL |
Faculty Search
I=Instructor/Advisor Table P=Personal Data Default Value: P |
| 9 | SSR_SSTXBDIS_STDNT | Character(1) | VARCHAR2(1) NOT NULL |
Self Service Student Show Textbook Summary button
Y/N Table Edit Default Value: N |
| 10 | SSR_SSTXBDIS_INSTR | Character(1) | VARCHAR2(1) NOT NULL |
Self Service Instructor Show Textbook Summary button
Y/N Table Edit Default Value: N |
| 11 | SSR_DISPLAY_GPA_FL | Character(1) | VARCHAR2(1) NOT NULL |
Display GPA on View Grades fluid page
Y/N Table Edit Default Value: N |
| 12 | SSR_REQ_ADVISEE | Character(1) | VARCHAR2(1) NOT NULL |
Require Advisee Selection
N=No Y=Yes Default Value: N |
| 13 | SSR_NOINSTR_LBL | Character(1) | VARCHAR2(1) NOT NULL |
Field to identify what label to use when Instructor not specified in class meeting pattern.
A=TBA S=Staff T=To Be Announced Default Value: T |