R_SRROLL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Number(6,0) | INTEGER NOT NULL | Sequence | |
| 3 | Number(5,0) | INTEGER NOT NULL | Class Nbr | |
| 4 | USE_CATLG_CMPNT | Character(1) | VARCHAR2(1) NOT NULL |
Use Catalog Component
Y/N Table Edit Default Value: Y |
| 5 | ROLL_CMBND_SCTN | Character(1) | VARCHAR2(1) NOT NULL |
Roll Combined Sections
Y/N Table Edit Default Value: Y |
| 6 | ROLL_MTG_PAT | Character(1) | VARCHAR2(1) NOT NULL |
Roll Meeting Patterns
Y/N Table Edit Default Value: Y |
| 7 | ROLL_INSTRUCTORS | Character(1) | VARCHAR2(1) NOT NULL |
Roll Instructors
Y/N Table Edit Default Value: Y |
| 8 | ROLL_CLASS_NOTES | Character(1) | VARCHAR2(1) NOT NULL |
Roll Class Notes
Y/N Table Edit Default Value: Y |
| 9 | ROLL_ROOM_CHRSTC | Character(1) | VARCHAR2(1) NOT NULL |
Roll Room Characteristics
Y/N Table Edit Default Value: Y |
| 10 | ROLL_RESERVE_CAP | Character(1) | VARCHAR2(1) NOT NULL |
Roll Reserve Capacities
Y/N Table Edit Default Value: Y |
| 11 | ROLL_REQUISITES | Character(1) | VARCHAR2(1) NOT NULL |
Roll Class Requisites
Y/N Table Edit Default Value: Y |
| 12 | ROLL_ATTRIBUTES | Character(1) | VARCHAR2(1) NOT NULL |
Roll Class Attributes
Y/N Table Edit Default Value: Y |
| 13 | SSR_ROLL_TEXTBOOKS | Character(1) | VARCHAR2(1) NOT NULL |
Roll Textbook Assignments
Y/N Table Edit Default Value: N |
| 14 | ROLL_CAF_ATTR | Character(1) | VARCHAR2(1) NOT NULL |
Roll Class Assoc Attributes
Y/N Table Edit Default Value: N |
| 15 | COMMIT_FREQUENCY | Number(3,0) | SMALLINT NOT NULL | Commit Frequency |