SAA_CLST_LKP_VW(SQL View) |
Index Back |
|---|---|
Course List Planner ViewThis view is used to search for Course Lists for the student planner. |
| SELECT DISTINCT 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 = 'PLNR' |
| # | 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 |