ENRL_LIMITS_TBL

(SQL Table)
 Index Back

Enrollment Limits Table

Home Location Table maintains basic location info re Academic Programs within Institutions. A row in this table represents a location where an Academic Program could be offered.

  • Parent record: ACAD_PROG_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
    5 FT_MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Total Units
    6 FT_MIN_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Min Total Units
    7 FT_MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max No GPA Units
    8 FT_MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Audit Units
    9 FT_MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Wait List Units
    10 FT_PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Full Time Projected Bill Units
    11 PT_MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Total Units
    12 PT_MIN_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Min Total Units
    13 PT_MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max No GPA Units
    14 PT_MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Audit Units
    15 PT_MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Wait List Units
    16 PT_PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Part Time Projected Bill Units
    17 BILL_WAIT_UNITS Character(1) VARCHAR2(1) NOT NULL Bill for Wait List Units

    Y/N Table Edit

    Default Value: Y

    18 INCL_WAIT_IN_TOT Character(1) VARCHAR2(1) NOT NULL Include Wait List in Total

    Y/N Table Edit

    Default Value: Y

    19 FT_MAX_CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Full Time Max Courses
    20 PT_MAX_CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Part Time Max Courses
    21 MIN_TOTAL_CHECK Character(1) VARCHAR2(1) NOT NULL Check Min Before Open Enroll

    Y/N Table Edit

    Default Value: N