SSS_CRSETERM_VW(SQL View) |
Index Back |
|---|---|
Class Table ViewLists the terms when a course is offered. |
| SELECT DISTINCT a.crse_id , a.crse_offer_nbr , a.institution , a.strm , a.subject , a.catalog_nbr , a.acad_career , a.acad_group , b.descr , b.term_begin_dt , b.term_end_dt , c.ssr_sscls_std_bdt , c.ssr_sscls_std_edt , c.ssr_sscls_insr_bdt , c.ssr_sscls_insr_edt FROM PS_CLASS_TBL a , ps_term_tbl b , ps_term_val_tbl c WHERE a.institution = b.institution AND a.acad_career = b.acad_career AND a.strm = b.strm AND a.schedule_print = 'Y' AND a.class_stat = 'A' AND b.strm=c.strm |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 2 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 3 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 4 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
| 5 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 6 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 7 | 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 |
| 8 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Academic Group |
| 9 | TERM_DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Term |
| 10 | TERM_BEGIN_DT | Date(10) | DATE | Term Begin Date |
| 11 | TERM_END_DT | Date(10) | DATE | Term Ending Date |
| 12 | SSR_SSCLS_STD_BDT | Date(10) | DATE NOT NULL | Show term in Self Service Planner begin date |
| 13 | SSR_SSCLS_STD_EDT | Date(10) | DATE NOT NULL | Show term in Self Service Planner begin date |
| 14 | SSR_SSCLS_INSR_BDT | Date(10) | DATE NOT NULL | Show term in Self Service Planner begin date |
| 15 | SSR_SSCLS_INSR_EDT | Date(10) | DATE NOT NULL | Show term in Self Service Planner begin date |