INSTITUTE COMMITTEE Table
View exposing institute committee membership detail including member identifiers, committee names and types, position role, membership dates, and prospect-related attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITTEE_NAME |
Committee name associated with the record. |
VARCHAR2 |
200 |
COMMITTEE_NUMBER |
Committee number associated with the record. |
VARCHAR2 |
10 |
COMMITTEE_STATUS |
Committee status associated with the record. |
VARCHAR2 |
50 |
COMMITTEE_SUBTYPE |
Committee subtype associated with the record. |
VARCHAR2 |
50 |
COMMITTEE_TYPE |
Committee type associated with the record. |
VARCHAR2 |
50 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
100 |
MEMBERSHIP_END_DATE |
Date associated with membership end. |
VARCHAR2 |
20 |
MEMBERSHIP_ID |
Business identifier for the membership. |
VARCHAR2 |
100 |
MEMBERSHIP_START_DATE |
Date associated with membership start. |
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 |
Position role associated with the record. |
VARCHAR2 |
200 |
PROSPECT_TYPE |
Prospect type associated with the record. |
VARCHAR2 |
50 |
RECORD_CREATE_DATE |
Date associated with record create. |
DATE |
|
RECORD_MODIFY_DATE |
Date associated with record modify. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |