SSR_CLSRCH_OPT(SQL Table) |
Index Back |
|---|
| # | 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_SSSTDNT_CAREER | Character(1) | VARCHAR2(1) NOT NULL |
Career
Y/N Table Edit Default Value: Y |
| 5 | SSR_SSINSTR_CAREER | Character(1) | VARCHAR2(1) NOT NULL |
Career
Y/N Table Edit Default Value: Y |
| 6 | SSR_SSSTDNT_CRSTTL | Character(1) | VARCHAR2(1) NOT NULL |
Course Title Key Word
Y/N Table Edit Default Value: Y |
| 7 | SSR_SSINSTR_CRSTTL | Character(1) | VARCHAR2(1) NOT NULL |
Course Title Key Word
Y/N Table Edit Default Value: Y |
| 8 | SSR_SSSTDNT_OPENTR | Character(1) | VARCHAR2(1) NOT NULL |
Open Entry/Exit Classes Only
Y/N Table Edit Default Value: Y |
| 9 | SSR_SSINSTR_OPENTR | Character(1) | VARCHAR2(1) NOT NULL |
Open Entry/Exit Classes Only
Y/N Table Edit Default Value: Y |
| 10 | SSR_SSSTDNT_LASTNM | Character(1) | VARCHAR2(1) NOT NULL |
Instructor Last Name
Y/N Table Edit Default Value: Y |
| 11 | SSR_SSINSTR_LASTNM | Character(1) | VARCHAR2(1) NOT NULL |
Instructor Last Name
Y/N Table Edit Default Value: Y |
| 12 | SSR_SSSTDNT_CLSNBR | Character(1) | VARCHAR2(1) NOT NULL |
Class Number
Y/N Table Edit Default Value: Y |
| 13 | SSR_SSINSTR_CLSNBR | Character(1) | VARCHAR2(1) NOT NULL |
Class Number
Y/N Table Edit Default Value: Y |
| 14 | SSR_SSSTDNT_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Course Component
Y/N Table Edit Default Value: Y |
| 15 | SSR_SSINSTR_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Course Component
Y/N Table Edit Default Value: Y |
| 16 | SSR_SSSTDNT_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Course Units
Y/N Table Edit Default Value: Y |
| 17 | SSR_SSINSTR_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Course Units
Y/N Table Edit Default Value: Y |
| 18 | SSR_SSSTDNT_SESSN | Character(1) | VARCHAR2(1) NOT NULL |
Session
Y/N Table Edit Default Value: Y |
| 19 | SSR_SSINSTR_SESSN | Character(1) | VARCHAR2(1) NOT NULL |
Session
Y/N Table Edit Default Value: Y |
| 20 | SSR_SSSTDNT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Mode of Instruction
Y/N Table Edit Default Value: Y |
| 21 | SSR_SSINSTR_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Mode of Instruction
Y/N Table Edit Default Value: Y |
| 22 | SSR_SSSTDNT_MTG | Character(1) | VARCHAR2(1) NOT NULL |
Meeting Time
Y/N Table Edit Default Value: Y |
| 23 | SSR_SSINSTR_MTG | Character(1) | VARCHAR2(1) NOT NULL |
Meeting Time
Y/N Table Edit Default Value: Y |
| 24 | SSR_SSSTDNT_DAYWK | Character(1) | VARCHAR2(1) NOT NULL |
Day of Week
Y/N Table Edit Default Value: Y |
| 25 | SSR_SSINSTR_DAYWK | Character(1) | VARCHAR2(1) NOT NULL |
Day of Week
Y/N Table Edit Default Value: Y |
| 26 | SSR_SSSTDNT_CAMPUS | Character(1) | VARCHAR2(1) NOT NULL |
Campus
Y/N Table Edit Default Value: Y |
| 27 | SSR_SSINSTR_CAMPUS | Character(1) | VARCHAR2(1) NOT NULL |
Campus
Y/N Table Edit Default Value: Y |
| 28 | SSR_SSSTDNT_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Location
Y/N Table Edit Default Value: Y |
| 29 | SSR_SSINSTR_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Location
Y/N Table Edit Default Value: Y |
| 30 | SSR_DTLSTDNT_CAMP | Character(1) | VARCHAR2(1) NOT NULL |
Campus
Y/N Table Edit Default Value: Y |
| 31 | SSR_DTLINSTR_CAMP | Character(1) | VARCHAR2(1) NOT NULL |
Campus
Y/N Table Edit Default Value: Y |
| 32 | SSR_DTLSTDNT_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Location
Y/N Table Edit Default Value: Y |
| 33 | SSR_DTLINSTR_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Location
Y/N Table Edit Default Value: Y |
| 34 | SSR_DTLSTDNT_CONST | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Info: Consent to add
Y/N Table Edit Default Value: Y |
| 35 | SSR_DTLINSTR_CONST | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Consent to add
Y/N Table Edit Default Value: Y |
| 36 | SSR_DTLSTDNT_CONSD | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Info: Consent to drop
Y/N Table Edit Default Value: Y |
| 37 | SSR_DTLINSTR_CONSD | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Consent to drop
Y/N Table Edit Default Value: Y |
| 38 | SSR_DTLSTDNT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Requisite
Y/N Table Edit Default Value: Y |
| 39 | SSR_DTLINSTR_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Requisite
Y/N Table Edit Default Value: Y |
| 40 | SSR_DTLSTDNT_RQDSG | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Rqmt Designation
Y/N Table Edit Default Value: Y |
| 41 | SSR_DTLINSTR_RQDSG | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Rqmt Designation
Y/N Table Edit Default Value: Y |
| 42 | SSR_DTLSTDNT_ATTR | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Class Attributes
Y/N Table Edit Default Value: Y |
| 43 | SSR_DTLINSTR_ATTR | Character(1) | VARCHAR2(1) NOT NULL |
Enroll Rqmt: Class Attributes
Y/N Table Edit Default Value: Y |
| 44 | SSR_DTLSTDNT_AVAIL | Character(1) | VARCHAR2(1) NOT NULL |
Class Availability
Y/N Table Edit Default Value: Y |
| 45 | SSR_DTLINSTR_AVAIL | Character(1) | VARCHAR2(1) NOT NULL |
Class Availability
Y/N Table Edit Default Value: Y |
| 46 | SSR_DTLSTDNT_COMB | Character(1) | VARCHAR2(1) NOT NULL |
Combined Section - Listing
Y/N Table Edit Default Value: Y |
| 47 | SSR_DTLINSTR_COMB | Character(1) | VARCHAR2(1) NOT NULL |
Combined Section - Listing
Y/N Table Edit Default Value: Y |
| 48 | SSR_DTLSTDNT_NOTES | Character(1) | VARCHAR2(1) NOT NULL |
Class Notes
Y/N Table Edit Default Value: Y |
| 49 | SSR_DTLINSTR_NOTES | Character(1) | VARCHAR2(1) NOT NULL |
Class Notes
Y/N Table Edit Default Value: Y |
| 50 | SSR_DTLSTDNT_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Catalog Description
Y/N Table Edit Default Value: Y |
| 51 | SSR_DTLINSTR_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Catalog Description
Y/N Table Edit Default Value: Y |
| 52 | SSR_DTLSTDNT_TXB | Character(1) | VARCHAR2(1) NOT NULL |
Textbook Information
Y/N Table Edit Default Value: N |
| 53 | SSR_DTLINSTR_TXB | Character(1) | VARCHAR2(1) NOT NULL |
Textbook Information
Y/N Table Edit Default Value: N |