SESSION_TBL

(SQL Table)
 Index Back

Session Definition Table

The Session Definition Table contains information that relates to each scheduling subset of a term that courses can be offered for. Lets say an institution has a liberal arts and an engineering school that are on different calendars. Each schools' courses should be placed in unique sessions for scheduling to work properly. Let say liberal arts some mini-term courses that only span half the term. These course should also be placed in a unique session for the term. The session concept is simply a way to subdivide a term in multiple time periods for offering courses.

  • Parent record: TERM_TBL

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

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

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

    Prompt Table: ACAD_CAR_TBL

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

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_TBL

    4 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Prompt Table: SESSION_TBL

    5 SESS_BEGIN_DT Date(10) DATE NOT NULL Session Beginning Date
    6 SESS_END_DT Date(10) DATE NOT NULL Session End Date
    7 ENROLL_OPEN_DT Date(10) DATE NOT NULL Open Enrollment Date
    8 SESSN_ENRL_CNTL Character(3) VARCHAR2(3) NOT NULL Enrollment Control Session

    Prompt Table: SESSION_CNTL_VW

    9 SESSN_APPT_CNTL Character(3) VARCHAR2(3) NOT NULL Appointment Control Session

    Prompt Table: SSR_SES_APTC_VW

    10 FIRST_ENRL_DT Date(10) DATE First Date to Enroll
    11 LAST_ENRL_DT Date(10) DATE Last Date to Enroll
    12 LAST_WAIT_DT Date(10) DATE Last Date for Wait List
    13 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Default Value: TERM_TBL.HOLIDAY_SCHEDULE

    Prompt Table: HOLIDAY_TBL

    14 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction

    Default Value: TERM_TBL.WEEKS_OF_INSTRUCT

    15 CENSUS_DT Date(10) DATE Census Date

    Default Value: ACAD_CALTRM_TBL.CENSUS_DT

    16 USE_DYN_CLASS_DATE Character(1) VARCHAR2(1) NOT NULL Use Dynamic Class Dates

    Y/N Table Edit

    Default Value: TERM_TBL.USE_DYN_CLASS_DATE

    17 SIXTY_PCT_DT Date(10) DATE Sixty Percent Point in Time
    18 FACILITY_ASSIGNMNT Date(10) DATE Facility Assignment Run Date

    Default Value: SESSION_TBL.SESS_BEGIN_DT

    19 SSR_ENR_APT_APPROV Character(1) VARCHAR2(1) NOT NULL Approved.

    Y/N Table Edit

    Default Value: N

    20 SSR_VAL_APT_APPROV Character(1) VARCHAR2(1) NOT NULL Approved.

    Y/N Table Edit

    Default Value: N

    21 SSR_SSPLNRDISP_BDT Date(10) DATE Show term in Self Service Planner begin date
    22 SSR_SSPLNRDISP_EDT Date(10) DATE Show term in Self Service Planner end date