SSS_STDNCTR_OPT

(SQL Table)
Index Back

Student Center Options

  • Related Language Record: SSS_STDNCTR_LNG
  • # 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