REPORT_REQUEST_NBRREQUEST_SEQ_NBRRQ_AA_OVRD_CRS_NBRPrompt Table: CRSE_CATALOG
Prompt Table: SUBJECT_VW
Prompt Table: CRSE_CATNO_SRCH
Prompt Table: %EDITTABLE7
STDNT_CRSE_WHIF(SQL Table) |
Index Back |
|---|---|
Course What-if recordThis record contains any courses entered for a course-whatif advisement report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_REQUEST_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr |
| 2 | REQUEST_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL | Request Seq Nbr |
| 3 | RQ_AA_OVRD_CRS_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Directive course number |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Academic Group |
| 6 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CATALOG |
| 7 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_VW |
| 8 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL |
Catalog Nbr
Prompt Table: CRSE_CATNO_SRCH |
| 9 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | CLASS_ENRL_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Class enroll type |
| 12 | 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: %EDITTABLE7 |
| 13 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |