CLST_MN_ADVT_VW(SQL View) |
Index Back |
|---|---|
Static Course List View/AdvisThis view is a copy of view CLST_MN_ADV_VW in which institution is not a key. It is being used temporarily by the panel RQ_COURSE_LIST because the original view (above) was malfunctioning in a prompt. When the prompt problem is solved, then this view should be deleted. |
| Select Institution ,Acad_Career ,Acad_Prog ,Acad_Plan ,Acad_Sub_Plan ,Course_List ,Descr ,Rqrmnt_Useage ,Acad_Group ,Subject ,Catalog_Nbr from PS_CLST_MAIN_TBL where RQRMNT_USEAGE <> 'STD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 |  ACAD_CAREER_SRCH |
Character(4) | VARCHAR2(4) NOT NULL | Academic Career |
| 3 | ACAD_PROG_SRCH |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 4 | ACAD_PLAN_SRCH |
Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
| 5 | ACAD_SUBPLN_SRCH |
Character(10) | VARCHAR2(10) NOT NULL | Academic Sub-Plan |
| 6 | COURSE_LIST |
Character(9) | VARCHAR2(9) NOT NULL | Course List |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | 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 |
| 9 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Academic Group
Prompt Table: ACAD_GROUP_TBL |
| 10 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
| 11 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL |
Catalog Nbr
Prompt Table: CRSE_CATNO_SRCH |