SSR_ENRL_OPT_VW(SQL View) |
Index Back |
|---|---|
Self Service Enrl Options |
| SELECT DISTINCT A.USERID ,A.DTTM_STAMP_SEC ,A.SSR_DESCRIPTION ,A.SSR_SS_VALIDATE ,A.SSR_TIME_CONFLICT ,A.SSR_CHECK_REPEATS ,A.SSR_REQUISITES ,A.SSR_UNIT_LIMITS ,A.SSR_SS_VAL_ON_APPT ,A.SSR_SS_ENBL_WHATIF ,A.WAIT_LIST_OKAY ,A.SSR_SS_DROP_IF_ENR ,A.SSR_SS_PREF_REQSTE ,A.SSR_SS_PREF_CLSNOT ,A.SSR_SS_PREF_CONSNT ,A.SSR_SS_PREF_CLSMTG ,A.SSR_USE_STDNT_PLNR ,A.SSR_SHOW_TYP_OFFR ,A.SSS_SHOW_PHOTOS ,A.SSR_VAR_UNIT_INCR ,A.SSR_FERPA_SHOW_OPT FROM PS_SSR_SS_ENRL_OPT A WHERE A.DTTM_STAMP_SEC = ( SELECT MAX(B.DTTM_STAMP_SEC) FROM PS_SSR_SS_ENRL_OPT B) |
| # | 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 |