SUBJECT ENROLLMENT EHS Table
View exposing subject enrollment records associated with EHS-related subject participation and enrollment reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
REG_STATUS |
Reg status associated with the record. |
VARCHAR2 |
40 |
REG_STATUS_DATE |
Date associated with reg status. |
DATE |
|
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
TERM_DESC |
Term desc associated with the record. |
VARCHAR2 |
30 |
TERM_END_DATE |
Term end date associated with the record. |
DATE |
|
TERM_START_DATE |
Term start date associated with the record. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |