EPR MIT SERVICE COMMITTEE Table
View exposing MIT service and committee participation records associated with Employee Professional Record data used for professional activity reporting and review.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITTEE_DESCRIPTION |
Description of committee. |
VARCHAR2 |
32767 |
COMMITTEE_GROUP |
Committee group associated with the record. |
VARCHAR2 |
100 |
COMMITTEE_NAME |
Committee name associated with the record. |
VARCHAR2 |
500 |
COMMITTEE_ROLE |
Committee role associated with the record. |
VARCHAR2 |
255 |
COMMITTEE_SERVICE_LEVEL |
Committee service level associated with the record. |
VARCHAR2 |
100 |
COMMITTEE_TYPE |
Committee type associated with the record. |
VARCHAR2 |
200 |
DATA_SOURCE |
Data source associated with the record. |
VARCHAR2 |
18 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
50 |
IS_CURRENT_SERVICE_COMMITTEE |
Indicator identifying whether current service committee (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
50 |
SERVICE_END_DATE |
Date associated with service end. |
DATE |
|
SERVICE_START_DATE |
Date associated with service start. |
DATE |
|
SOURCE_LAST_UPDATE_DATE |
Date associated with source last update. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |