Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EPR MIT SERVICE COMMITTEE Table


XXX


Field Name

Description

Data Type

Length

COMMITTEE_DESCRIPTION

XXX

VARCHAR2

32767

COMMITTEE_GROUP

XXX

VARCHAR2

100

COMMITTEE_NAME

XXX

VARCHAR2

500

COMMITTEE_ROLE

XXX

VARCHAR2

255

COMMITTEE_SERVICE_LEVEL

XXX

VARCHAR2

100

COMMITTEE_TYPE

XXX

VARCHAR2

200

DATA_SOURCE

Source of the data in this record.

VARCHAR2

18

DEPARTMENT_NAME

The name of the department, school, center, or lab.

VARCHAR2

50

IS_CURRENT_SERVICE_COMMITTEE

XXX

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

The descriptive text for SCHOOL_CODE.

VARCHAR2

50

SERVICE_END_DATE

XXX

DATE

SERVICE_START_DATE

XXX

DATE

SOURCE_LAST_UPDATE_DATE

XXX

DATE

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE