ACAD_CALTRM_VW

(SQL View)
 Index Back

Academic Calendar Term Table

The Academic Calendar Term Table stores term based deadlines and other pertinent information.

select a.INSTITUTION , a.ACAD_CAREER , a.ACAD_CALENDAR_ID , a.STRM , a.DEGR_CONFER_DT , a.CENSUS_DT , a.LST_CANCEL_DT , a.CANCEL_REASON , a.LST_WD_WO_PEN_DT , a.WD_WO_PEN_REASON , a.LST_WD_W_PEN_DT , a.WD_W_PEN_GRD_BAS , a.WD_W_PEN_GRADE , a.FULLY_ENRL_DT , a.ENRL_ON_TRANS_DT , a.STATS_ON_TRANS_DT , a.FULLY_GRADED_DT from PS_ACAD_CALTRM_TBL a

  • 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

    Prompt Table: INSTITUTION_TBL

    2 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

    Prompt Table: ACAD_CAL_TABLE

    3 ACAD_CALENDAR_ID Character(4) VARCHAR2(4) NOT NULL Academic Calendar

    Prompt Table: ACAD_CAL_TABLE

    4 COMPLETION_TERM Character(4) VARCHAR2(4) NOT NULL Completion Term
    5 DEGR_CONFER_DT Date(10) DATE Confer Date
    6 CENSUS_DT Date(10) DATE Census Date
    7 LST_CANCEL_DT Date(10) DATE NOT NULL Cancel Deadline
    8 CANCEL_REASON Character(4) VARCHAR2(4) NOT NULL Cancel Drop Reason

    Prompt Table: ENRL_RSN_TBL

    9 LST_WD_WO_PEN_DT Date(10) DATE Withdraw Deadline No Penalty
    10 WD_WO_PEN_REASON Character(4) VARCHAR2(4) NOT NULL Withdraw Drop Rsn No Penalty

    Prompt Table: ENRL_RSN_TBL

    11 LST_WD_W_PEN_DT Date(10) DATE Withdraw Deadline w/ Penalty
    12 WD_W_PEN_GRD_BAS Character(3) VARCHAR2(3) NOT NULL Withdraw w/ Pen Grading Basis

    Prompt Table: GRADE_BASE_E_VW

    13 WD_W_PEN_GRADE Character(3) VARCHAR2(3) NOT NULL Withdraw with Penalty Grade

    Prompt Table: WD_W_PEN_GRD_VW

    14 FULLY_ENRL_DT Date(10) DATE NOT NULL Fully Enrolled Date

    Default Value: TERM_TBL.TERM_BEGIN_DT

    15 ENRL_ON_TRANS_DT Date(10) DATE NOT NULL Show Enrollment on Transcript
    16 STATS_ON_TRANS_DT Date(10) DATE NOT NULL Show Statistics on Transcript
    17 FULLY_GRADED_DT Date(10) DATE NOT NULL Fully Graded Date