CRSE_WHIF_VW

(SQL View)
Index Back

Class Table Catlg Number View

This 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'

  • Related Language Record: CRSE_WHIF_LANG
  • # 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