ACAD_CAL_TS_VW2

(SQL View)
Index Back

Academic Calendar Table

The Academic Calendar Table stores dates and other information that vary by term and session. This view will select academic calendar for the view ACAD_CALTRM_VW3.

select INSTITUTION , ACAD_CAREER , ACAD_CALENDAR_ID , DESCR from PS_ACAD_CAL_TABLE

  • Related Language Record: ACADCALTSVW2LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 ACAD_CAREER_TS_HDR Character(4) VARCHAR2(4) NOT NULL Academic Career
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL

    3 ACAD_CAL_ID_TS_HDR Character(4) VARCHAR2(4) NOT NULL Academic Calendar
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description