Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EM ENROLLMENT CAPS SNAPSHOT Table


View exposing snapshot records of enrollment capacity limits used in student registration and enrollment management processing.


Field Name

Description

Data Type

Length

CAP

Cap associated with the record.

NUMBER

5

CI_ATTRIBUTE

Ci attribute associated with the record.

VARCHAR2

10

ENROLLMENT_CAP_KEY

Surrogate key identifying the enrollment cap.

VARCHAR2

100

PRIMARY_INSTRUCTOR_ID

Business identifier for the primary instructor.

VARCHAR2

64

PRIMARY_INSTRUCTOR_NAME

Primary instructor name associated with the record.

VARCHAR2

64

SECONDARY_INSTRUCTOR_ID

Business identifier for the secondary instructor.

VARCHAR2

128

SECONDARY_INSTRUCTOR_NAME

Secondary instructor name associated with the record.

VARCHAR2

128

SECTION

Section associated with the record.

VARCHAR2

3

SECTION_REGISTRATION

Section registration associated with the record.

VARCHAR2

10

SNAPSHOT_NAME

Snapshot name associated with the record.

VARCHAR2

25

SUBJECT_ID

Business identifier for the subject.

VARCHAR2

10

SUBJECT_TITLE

Subject title associated with the record.

VARCHAR2

150

TERM_CODE

Code identifying term.

VARCHAR2

6

WAREHOUSE_CREATE_DATE

Date associated with warehouse create.

DATE

WAREHOUSE_CREATE_USER

Warehouse create user associated with the record.

VARCHAR2

1