RQ_MAIN_ADV_VW(SQL View) |
Index Back |
|---|---|
Advisement Requirement ViewUse this view to prompt for student override requirements |
| SELECT B.RQRMNT_GROUP ,B.EFFDT ,A.REQUIREMENT ,A.RQRMNT_USEAGE ,A.DESCR ,A.DESCRSHORT ,A.MIN_UNITS_REQD ,A.MIN_CRSES_REQD ,A.DESCR254A FROM PS_RQ_MAIN_TBL A , PS_RQ_GRP_DETL_TBL B WHERE A.RQRMNT_USEAGE = 'ADV' AND A.REQUIREMENT = B.REQUIREMENT AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_RQ_MAIN_TBL A1 WHERE A1.REQUIREMENT = B.REQUIREMENT AND A1.EFFDT <= B.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RQRMNT_GROUP |
Character(6) | VARCHAR2(6) NOT NULL | Requirement Group |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | REQUIREMENT |
Character(9) | VARCHAR2(9) NOT NULL |
Academic Requirement
Default Value: 000000000 Prompt Table: RQ_MAIN_TBL |
| 4 | RQRMNT_USEAGE | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
ADV=Academic Advisement ENR=Requisite/Restriction PLNR=Student Planner Report SHR=Rq Course Share Restrictn SHR1=Entity Course Share Restrictn STD=Student Individualized Plan |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | MIN_UNITS_REQD | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Units |
| 8 | MIN_CRSES_REQD | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Courses |
| 9 | DESCR254A | Character(254) | VARCHAR2(254) NOT NULL | Long Description |