SSS_PRSNSUM_OPT(SQL Table) |
Index Back |
|---|---|
Personal Data Summary 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_ADDR_BOX1 | Character(4) | VARCHAR2(4) NOT NULL |
Address Box 1 (left)
Prompt Table: ADDRESS_TYP_TBL |
| 5 | SSS_SC_ADDR1_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address Box 1 Link Label |
| 6 | SSS_SC_ADDR2_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address Box 2 Link Label |
| 7 | SSS_SC_ADDR_BOX2 | Character(4) | VARCHAR2(4) NOT NULL |
Address Box 2 (right)
Prompt Table: ADDRESS_TYP_TBL |
| 8 | 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 |
| 9 | SSS_SC_PHONE_LBL | Character(30) | VARCHAR2(30) NOT NULL | Phone Link Label |
| 10 | SSS_SC_PRSNL_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Display E-mail
Y/N Table Edit |
| 11 | 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 |
| 12 | SSS_SC_EMAIL_LBL | Character(30) | VARCHAR2(30) NOT NULL | Email Link Label |
| 13 | SSS_SC_HOLDS | Character(1) | VARCHAR2(1) NOT NULL |
Show Holds Section
Y/N Table Edit |
| 14 | SSS_SC_PRSNL_PHNE | Character(1) | VARCHAR2(1) NOT NULL |
Display Phone
Y/N Table Edit |
| 15 | 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 |
| 16 | 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 |
| 17 | SSS_SC_MONETRY_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Display monetary value
Y/N Table Edit |
| 18 | SSS_SC_TO_DO_LIST | Character(1) | VARCHAR2(1) NOT NULL |
Show To Do List Section
Y/N Table Edit |
| 19 | SSS_SC_PRIVACY_LNK | Character(254) | VARCHAR2(254) NOT NULL | Privacy settings link |
| 20 | 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 |
| 21 | SCC_GROUP_BOX | Character(1) | VARCHAR2(1) NOT NULL | Holds Section |
| 22 | SCC_GROUP_BOX_1 | Character(1) | VARCHAR2(1) NOT NULL | This field is used as a group box in camnpus community. |