SAA_CLST_WCC_VW(SQL View) |
Index Back |
---|---|
Static Course ListUse this table to specify Course and Wild Card data for single courses included in a Course List. |
SELECT a.COURSE_LIST , a.EFFDT , b.R_COURSE_SEQUENCE , a.EFF_STATUS , b.CRSE_ID , 0 , b.DESCR , 0 , 0 , b.INSTITUTION , ' ' , b.SUBJECT , b.CATALOG_NBR , b.WILDCARD_IND , b.SAA_WHERE_CLAUSE FROM PS_CLST_MAIN_TBL a , PS_CLST_DETL_TBL b WHERE a.COURSE_LIST = b.COURSE_LIST AND a.EFFDT = b.EFFDT AND b.WILDCARD_IND='Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COURSE_LIST | Character(9) | VARCHAR2(9) NOT NULL | Course List |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | R_COURSE_SEQUENCE | Number(7,0) | INTEGER NOT NULL | Course Sequence |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CAT_R3_VW |
6 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
9 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |
10 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
11 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
12 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
13 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL |
Catalog Nbr
Prompt Table: CRSE_CATNO_SRCH |
14 | WILDCARD_IND | Character(1) | VARCHAR2(1) NOT NULL |
WildCard Indicator
Y/N Table Edit |
15 | SAA_WHERE_CLAUSE | Long Character | CLOB | This field contains the where clause used in different processes in academic advisement. |