SSR_APPT_LIMIT

(SQL Table)
 Index Back

Appointment Limit Table

The Enrollment Appointment Table contains information about Appointment Numbers and their starting and ending dates and times with maximum number of units allowed for the appointment.

  • Parent record: SESSION_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 APPT_LIMIT_ID Character(4) VARCHAR2(4) NOT NULL Appointment Limit ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 FT_MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Total Units
    6 FT_MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max No GPA Units
    7 FT_MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Audit Units
    8 FT_MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Full Time Max Wait List Units
    9 PT_MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Total Units
    10 PT_MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max No GPA Units
    11 PT_MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Audit Units
    12 PT_MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Part Time Max Wait List Units
    13 INCL_WAIT_IN_TOT Character(1) VARCHAR2(1) NOT NULL Include Wait List in Total

    Y/N Table Edit

    Default Value: N