SSS_STDNCTR_OPT(SQL Table) |
Index Back |
---|---|
Student Center 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_ACADEMIC | Character(1) | VARCHAR2(1) NOT NULL |
Show Academic Section
Y/N Table Edit Default Value: Y |
5 | SSS_SC_FINANCES | Character(1) | VARCHAR2(1) NOT NULL |
Show Finances Section
Y/N Table Edit Default Value: Y |
6 | SSS_SC_PERSNL_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Show Personal Info Section
Y/N Table Edit Default Value: Y |
7 | SSS_SC_ADMISSIONS | Character(1) | VARCHAR2(1) NOT NULL |
Show Admissions Section
Y/N Table Edit Default Value: Y |
8 | SSS_SC_HOLDS | Character(1) | VARCHAR2(1) NOT NULL |
Show Holds Section
Y/N Table Edit Default Value: Y |
9 | SSS_SC_TO_DO_LIST | Character(1) | VARCHAR2(1) NOT NULL |
Show To Do List Section
Y/N Table Edit Default Value: Y |
10 | SSS_SC_MLSTN_LIST | Character(1) | VARCHAR2(1) NOT NULL |
This field controls if the milestones will be shown on the student center.
Y/N Table Edit Default Value: N |
11 | SSS_SC_ADVISOR | Character(1) | VARCHAR2(1) NOT NULL |
Show Advisor Section
Y/N Table Edit Default Value: Y |
12 | SSS_SC_ENRL_APPT | Character(1) | VARCHAR2(1) NOT NULL |
Show Enrollment Dates Section
Y/N Table Edit |
13 | SSS_SC_LINKS | Character(1) | VARCHAR2(1) NOT NULL |
Show Links Section
Y/N Table Edit Default Value: Y |
14 | SSS_SC_ADDR_BOX1 | Character(4) | VARCHAR2(4) NOT NULL |
Address Box 1 (left)
Prompt Table: ADDRESS_TYP_TBL |
15 | SSS_SC_ADDR1_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address Box 1 Link Label |
16 | SSS_SC_ADDR_BOX2 | Character(4) | VARCHAR2(4) NOT NULL |
Address Box 2 (right)
Prompt Table: ADDRESS_TYP_TBL |
17 | SSS_SC_ADDR2_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address Box 2 Link Label |
18 | SSS_SC_PRSNL_PHNE | Character(1) | VARCHAR2(1) NOT NULL |
Display Phone
Y/N Table Edit Default Value: Y |
19 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
20 | SSS_SC_PHONE_LBL | Character(30) | VARCHAR2(30) NOT NULL | Phone Link Label |
21 | SSS_SC_PRSNL_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Display E-mail
Y/N Table Edit Default Value: Y |
22 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
23 | SSS_SC_EMAIL_LBL | Character(30) | VARCHAR2(30) NOT NULL | Email Link Label |
24 | SSS_SC_PRIVACY_LNK | Character(254) | VARCHAR2(254) NOT NULL | Privacy settings link |
25 | SSS_SC_ADM_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Display Action Column
Y/N Table Edit Default Value: Y |
26 | SSS_SC_AD_MISS_LNK | Character(1) | VARCHAR2(1) NOT NULL |
Display what's missing link
Y/N Table Edit Default Value: Y |
27 | SSS_SC_AD_ACCP_LNK | Character(1) | VARCHAR2(1) NOT NULL |
Display Accept or Decline link
Y/N Table Edit Default Value: Y |
28 | SSS_SC_HOLDS_CTRL | Character(3) | VARCHAR2(3) NOT NULL |
Show
1=One 10=Ten 2=Two 3=Three 4=Four 5=Five 6=Six 7=Seven 8=Eight 9=Nine A=All Default Value: A |
29 | SSS_SC_MONETRY_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Display monetary value
Y/N Table Edit Default Value: Y |
30 | SSS_SC_TODO_CTRL | Character(3) | VARCHAR2(3) NOT NULL |
Show
1=One 10=Ten 2=Two 3=Three 4=Four 5=Five 6=Six 7=Seven 8=Eight 9=Nine A=All N=None Default Value: A |
31 | SSS_SC_MLSTN_CTRL | Character(3) | VARCHAR2(3) NOT NULL |
This field is used to limit the number of details displayed in the student center.
1=One 10=Ten 2=Two 3=Three 4=Four 5=Five 6=Six 7=Seven 8=Eight 9=Nine A=All Default Value: A |
32 | SSS_SC_APPT_DTL | Character(1) | VARCHAR2(1) NOT NULL |
Show Appointment Detail link
Y/N Table Edit Default Value: Y |
33 | SSS_SC_ADVSR_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Display program advisor name
Y/N Table Edit Default Value: Y |
34 | SSS_SC_ADVSR_PHONE | Character(1) | VARCHAR2(1) NOT NULL |
Show advisor phone number
Y/N Table Edit Default Value: Y |
35 | SSS_PHONETYPE_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Phone type to use:
10=Use Advisor's Preferred Phone 20=Use This Phone Type: |
36 | SSS_ADVR_PHONETYPE | Character(4) | VARCHAR2(4) NOT NULL | Phone Type |
37 | SSS_SC_LNK1_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section name |
38 | SSS_SC_LNK1_TITL1 | Character(30) | VARCHAR2(30) NOT NULL | Title |
39 | SSS_SC_LNK1_URL1 | Character(254) | VARCHAR2(254) NOT NULL | URL |
40 | SSS_SC_LNK1_TITL2 | Character(30) | VARCHAR2(30) NOT NULL | Title |
41 | SSS_SC_LNK1_URL2 | Character(254) | VARCHAR2(254) NOT NULL | URL |
42 | SSS_SC_LNK1_TITL3 | Character(30) | VARCHAR2(30) NOT NULL | Title |
43 | SSS_SC_LNK1_URL3 | Character(254) | VARCHAR2(254) NOT NULL | URL |
44 | SSS_SC_LNK2_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section name |
45 | SSS_SC_LNK2_TITL1 | Character(30) | VARCHAR2(30) NOT NULL | Title |
46 | SSS_SC_LNK2_URL1 | Character(254) | VARCHAR2(254) NOT NULL | URL |
47 | SSS_SC_LNK2_TITL2 | Character(30) | VARCHAR2(30) NOT NULL | Title |
48 | SSS_SC_LNK2_URL2 | Character(254) | VARCHAR2(254) NOT NULL | URL |
49 | SSS_SC_LNK2_TITL3 | Character(30) | VARCHAR2(30) NOT NULL | Title |
50 | SSS_SC_LNK2_URL3 | Character(254) | VARCHAR2(254) NOT NULL | URL |
51 | SSS_SC_LNK3_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section name |
52 | SSS_SC_LNK3_TITL1 | Character(30) | VARCHAR2(30) NOT NULL | Title |
53 | SSS_SC_LNK3_URL1 | Character(254) | VARCHAR2(254) NOT NULL | URL |
54 | SSS_SC_LNK3_TITL2 | Character(30) | VARCHAR2(30) NOT NULL | Title |
55 | SSS_SC_LNK3_URL2 | Character(254) | VARCHAR2(254) NOT NULL | URL |
56 | SSS_SC_LNK3_TITL3 | Character(30) | VARCHAR2(30) NOT NULL | Title |
57 | SSS_SC_LNK3_URL3 | Character(254) | VARCHAR2(254) NOT NULL | URL |
58 | SSS_SC_TASK_CTRL | Character(3) | VARCHAR2(3) NOT NULL |
Show
1=One 10=Ten 2=Two 3=Three 4=Four 5=Five 6=Six 7=Seven 8=Eight 9=Nine A=All N=None Default Value: A |