CRSE_BLOCK_HDR(SQL Table) |
Index Back |
---|---|
Course Enrollment Block HeaderThe 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. |
# | 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 |