ACAD_CALTRM_VW3

(SQL View)
 Index Back

Academic Calendar Term View

This view of the Academic Calendar Term Table is used in the Transcript Request panel for prompting. It is was added for the Future Request feature for Chrono detail organization.

SELECT A.INSTITUTION ,A.ACAD_CAREER ,A.ACAD_CALENDAR_ID ,A.STRM ,B.DESCRSHORT ,B.DESCR ,A.DEGR_CONFER_DT ,A.FULLY_GRADED_DT FROM PS_ACAD_CALTRM_TBL A , PS_TERM_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM AND B.TERM_END_DT >= %CurrentDateIn

  • Related Language Record: ACADCALTRMVW3LN

  • Parent record: ACAD_CAL_TABLE

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

    Default Value: SA_REQUEST_HDR.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

    Prompt Table: ACAD_CAL_TS_VW2

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL_SRCHVW

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DEGR_CONFER_DT Date(10) DATE Confer Date
    8 FULLY_GRADED_DT Date(10) DATE NOT NULL Fully Graded Date