SSR_SS_ENRL_OPT(SQL Table) |
Index Back |
---|---|
Self Service Enrl 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 | SSR_SS_VALIDATE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Validation on an Enrollment Appointment.
Y/N Table Edit Default Value: Y |
5 | SSR_TIME_CONFLICT | Character(1) | VARCHAR2(1) NOT NULL |
Check for Time Conflict on Validation Appointments.
Y/N Table Edit Default Value: Y |
6 | SSR_CHECK_REPEATS | Character(1) | VARCHAR2(1) NOT NULL |
Repeats
Y/N Table Edit Default Value: Y |
7 | SSR_REQUISITES | Character(1) | VARCHAR2(1) NOT NULL |
Check for Requisites on Validation Appointments.
Y/N Table Edit Default Value: Y |
8 | SSR_UNIT_LIMITS | Character(1) | VARCHAR2(1) NOT NULL |
Check for Unit Limits on Validation Appointments.
Y/N Table Edit Default Value: Y |
9 | SSR_SS_VAL_ON_APPT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Validation on an Enrollment Appointment.
Y/N Table Edit Default Value: Y |
10 | SSR_SS_ENBL_WHATIF | Character(1) | VARCHAR2(1) NOT NULL |
Allow Validation on an Enrollment Appointment.
Y/N Table Edit Default Value: Y |
11 | WAIT_LIST_OKAY | Character(1) | VARCHAR2(1) NOT NULL |
Wait List Okay
Y/N Table Edit Default Value: Y |
12 | SSR_SS_DROP_IF_ENR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Drop If Enroll
N=Swap Y=Enroll with Drop if Enroll Default Value: Y |
13 | SSR_SS_PREF_REQSTE | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Requirements
Y/N Table Edit Default Value: Y |
14 | SSR_SS_PREF_CLSNOT | Character(1) | VARCHAR2(1) NOT NULL |
Class Notes
Y/N Table Edit Default Value: Y |
15 | SSR_SS_PREF_CONSNT | Character(1) | VARCHAR2(1) NOT NULL |
Consent
Y/N Table Edit Default Value: Y |
16 | SSR_SS_PREF_CLSMTG | Character(1) | VARCHAR2(1) NOT NULL |
Class Meeting Information
Y/N Table Edit Default Value: Y |
17 | SSR_USE_STDNT_PLNR | Character(1) | VARCHAR2(1) NOT NULL |
This field is a Y/N flag that controls if the student planner is to be used in student records self-service.
Y/N Table Edit Default Value: Y |
18 | SSR_SHOW_TYP_OFFR | Character(1) | VARCHAR2(1) NOT NULL |
This field is a Y/N flag that controls if the typically offered field is displayed throughout student records.
Y/N Table Edit Default Value: Y |
19 | SSS_SHOW_PHOTOS | Character(1) | VARCHAR2(1) NOT NULL |
Show Student Photos on Rosters
Y/N Table Edit Default Value: Y |
20 | SSR_VAR_UNIT_INCR | Number(5,2) | DECIMAL(4,2) NOT NULL |
Variable Unit Increments
Default Value: 1 |
21 | SSR_FERPA_SHOW_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Display Ferpa
Y/N Table Edit Default Value: N |
22 | SSR_SS_PREF_SRVIND | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Holds
E=Potential Error S=Success Default Value: E |