SSR_APT_ENR_CLS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: 1 |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 4 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 5 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 6 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL |
Class Nbr
Prompt Table: SSR_CLASS_TBLV1 |
| 7 | RELATE_CLASS_NBR_1 | Number(5,0) | INTEGER NOT NULL |
Related Class Number 1
Prompt Table: CLASS_TBL_RE_V2 |
| 8 | RELATE_CLASS_NBR_2 | Number(5,0) | INTEGER NOT NULL |
Related Class Number 2
Prompt Table: CLASS_TBL_RE_V2 |
| 9 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL |
Units Taken
Prompt Table: DERIVED_REGFRM1 |
| 10 | GRADING_BASIS_ENRL | Character(3) | VARCHAR2(3) NOT NULL | Grading Basis |
| 11 | INSTRUCTOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table: %EDITTABLE3 |
| 12 | WAIT_LIST_OKAY | Character(1) | VARCHAR2(1) NOT NULL |
Wait List Okay
Y/N Table Edit |
| 13 | START_DT | Date(10) | DATE | Start Date |
| 14 | RQMNT_DESIGNTN | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
Prompt Table: RQMNT_DESIG_TBL |
| 15 | RQMNT_DESIGNTN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Requirement Designation Option
N=No Y=Yes |
| 16 | CRSE_COUNT | Number(5,2) | DECIMAL(4,2) NOT NULL | Course Count |