CRSE_BLOCK_HDR

(SQL Table)
Index Back

Course Enrollment Block Header

The Enrollment Request Detail table is used by the Enrollment Engine to determine what enrollment requests to process. Each request is independent of each other. The Enrollment Engine can accomodate more than one student within an Enrollment Request ID.

  • Related Language Record: CRSE_BLOCK_LANG
  • # 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: INSTITUTN_SCRTY

    2 CRSE_ENRL_BLOCK Character(5) VARCHAR2(5) NOT NULL Class Enrollment Block
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ENRL_REQ_ACTION Character(2) VARCHAR2(2) NOT NULL Enrollment Request Action
    A=Add Grade
    C=Change Grade
    D=Drop
    E=Enroll
    M=Normal Maintenance
    P=Change Wait List Position
    R=Remove Grade
    S=Swap Courses
    W=Drop to Wait List

    Default Value: E

    5 ENRL_ACTION_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Action Reason

    Prompt Table: ENRL_RSN_TBL

    6 ENRL_ACTION_DT Date(10) DATE Enrollment Action Date
    7 OVRD_CLASS_LIMIT Character(1) VARCHAR2(1) NOT NULL Used by SR Enrollments and Class Permissions.

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.OVRD_CLASS_LIMIT

    8 OVRD_GRADING_BASIS Character(1) VARCHAR2(1) NOT NULL Override Grading Basis

    Y/N Table Edit

    Default Value: N

    9 OVRD_CLASS_UNITS Character(1) VARCHAR2(1) NOT NULL Override Class Units

    Y/N Table Edit

    Default Value: N

    10 OVRD_UNIT_LOAD Character(1) VARCHAR2(1) NOT NULL Override Unit Load

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.OVRD_UNIT_LOAD

    11 OVRD_CLASS_LINKS Character(1) VARCHAR2(1) NOT NULL Override Class Links

    Y/N Table Edit

    Default Value: N

    12 OVRD_CLASS_PRMSN Character(1) VARCHAR2(1) NOT NULL Override Class Permission

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.OVRD_CLASS_PRMSN

    13 OVRD_REQUISITES Character(1) VARCHAR2(1) NOT NULL Override Requisites

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.OVRD_REQUISITES

    14 OVRD_TIME_CNFLCT Character(1) VARCHAR2(1) NOT NULL Override Time Conflict

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.OVRD_TIME_CNFLCT

    15 OVRD_CAREER Character(1) VARCHAR2(1) NOT NULL Override Career

    Y/N Table Edit

    Default Value: N

    16 WAIT_LIST_OKAY Character(1) VARCHAR2(1) NOT NULL Wait List Okay

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.WAIT_LIST_OKAY

    17 OVRD_ENRL_ACTN_DT Character(1) VARCHAR2(1) NOT NULL Override Action Date

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.OVRD_ENRL_ACTN_DT

    18 OVRD_RQMNT_DESIG Character(1) VARCHAR2(1) NOT NULL Ovrd Requirement Designation

    Y/N Table Edit

    Default Value: N

    19 OVRD_SRVC_INDIC Character(1) VARCHAR2(1) NOT NULL Override Service Indicator

    Y/N Table Edit

    Default Value: N

    20 OVRD_APPT Character(1) VARCHAR2(1) NOT NULL Override Appointment

    Y/N Table Edit

    Default Value: N

    21 SSR_DYND_LDRP_OVRD Character(1) VARCHAR2(1) NOT NULL Dynamic Dates

    Y/N Table Edit

    Default Value: N