Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse INSTITUTE COMMITTEE Table


XXX


Field Name

Description

Data Type

Length

COMMITTEE_NAME

XXX

VARCHAR2

200

COMMITTEE_NUMBER

XXX

VARCHAR2

10

COMMITTEE_STATUS

XXX

VARCHAR2

50

COMMITTEE_SUBTYPE

XXX

VARCHAR2

50

COMMITTEE_TYPE

XXX

VARCHAR2

50

FULL_NAME

The full name of the person.

VARCHAR2

100

MEMBERSHIP_END_DATE

XXX

VARCHAR2

20

MEMBERSHIP_ID

XXX

VARCHAR2

100

MEMBERSHIP_START_DATE

XXX

VARCHAR2

20

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

POSITION_ROLE

XXX

VARCHAR2

200

PROSPECT_TYPE

XXX

VARCHAR2

50

RECORD_CREATE_DATE

XXX

DATE

RECORD_MODIFY_DATE

XXX

DATE

WAREHOUSE_LOAD_DATE

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

DATE