CRSE_WHIF_VW(SQL View) |
Index Back |
---|---|
Class Table Catlg Number ViewThis Class Table view retrieves all scheduled classes by Institution, Subject, Catalog Number & CrseID. Used in Course What-If functionality. The field AT_STDNT_OPTION will not return any value if run as a view. This field is used for passing values around between secondary pages and would create problems unless this is programmed as an outer join, which is not going to be done at this time. |
SELECT A.INSTITUTION , A.SUBJECT , A.CATALOG_NBR , A.CRSE_ID , A.CRSE_OFFER_NBR , A.ACAD_GROUP , B.UNITS_ACAD_PROG , B.DESCR , B.RQMNT_DESIGNTN , A.ACAD_CAREER FROM PS_CRSE_OFFER A , PS_CRSE_CATALOG B WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_CRSE_CATALOG B1 WHERE B1.CRSE_ID = B.CRSE_ID AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
2 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
3 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
4 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
5 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
6 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Academic Group |
7 | UNITS_ACAD_PROG | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Progress Units |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | RQMNT_DESIGNTN | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
Prompt Table: RQMNT_DESIG_TBL |
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 |