SESSN_ENRLIMTBL

(SQL Table)
 Index Back

Session Enrollment Limits Tbl

The Session Enrollment Limits table describes what the unit limits are for class enrollment purposes for each session defined to the system.

  • Parent record: ENRL_LIMITS_TBL

    • # 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_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
    0=Full Year
    1=1st Semester
    2=2nd Semester
    3=Summer Session AUS
    4=Winter Session AUS
    C=Medical Clinical
    I=Intersession Term
    M=Medical Level 1
    R=Regular Term
    S=Summer Term
    W=Winter Term

    Prompt Table: ENRL_LIMITS_TBL

    5 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
    6 USE_TERM_UNT_LIM Character(1) VARCHAR2(1) NOT NULL Only Use Term Limits

    Y/N Table Edit

    Default Value: N

    7 FT_MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Total Units
    8 FT_MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max No GPA Units
    9 FT_MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Audit Units
    10 FT_MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Wait List Units
    11 PT_MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Total Units
    12 PT_MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max No GPA Units
    13 PT_MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Audit Units
    14 PT_MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Wait List Units
    15 FT_MAX_CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Full Time Max Courses
    16 PT_MAX_CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Part Time Max Courses
    17 FT_PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Full Time Projected Bill Units
    18 PT_PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Part Time Projected Bill Units