SSR_CRSTOPIC_V4(SQL View) |
Index Back |
|---|---|
Course Topic View |
| SELECT a.crse_id , a.effdt , a.descr , a.course_title_long , b.crse_offer_nbr , b.institution , b.subject , b.catalog_nbr , b.course_approved , b.acad_career , b.acad_group , b.acad_org , b.campus , c.crs_topic_id , c.descr FROM ps_crse_catalog a , PS_CRSE_OFFER b , ps_crse_topics c WHERE a.crse_id = b.crse_id AND a.effdt = b.effdt AND a.crse_id = c.crse_id AND a.effdt = c.effdt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | COURSE_TITLE_LONG | Character(100) | VARCHAR2(100) NOT NULL | Long Course Title |
| 5 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 6 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 7 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 8 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 9 | COURSE_APPROVED | Character(1) | VARCHAR2(1) NOT NULL |
Course Approved
A=Approved D=Denied P=Pending |
| 10 | 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 |
| 11 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Academic Group |
| 12 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
| 13 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
| 14 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
| 15 | SSR_TOPIC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Course Topic |