Data Warehouse

ACAD_CHAIR_CATEGORY_KEY

Surrogate key identifying the academic chair category.

VARCHAR2

4

ACAD_CHAIR_COST_COLLECTOR_KEY

Surrogate key identifying the chair?cost collector association.

VARCHAR2

24

ACAD_CHAIR_KEY

Surrogate key identifying the academic chair.

VARCHAR2

7

CHAIR_APPT_BEGIN_DATE

Start date of the academic chair appointment.

DATE

CHAIR_APPT_END_DATE

End date of the academic chair appointment.

DATE

CHAIR_APPT_TITLE

Title associated with the chair appointment.

VARCHAR2

72

CHAIR_COMMENT

Comment or note associated with the chair appointment.

VARCHAR2

72

CHAIR_COST_COLLECTOR_ID

Identifier of the primary cost collector for the chair.

VARCHAR2

7

CHAIR_COST_COLLECTOR_NAME

Name of the primary cost collector for the chair.

VARCHAR2

40

CHAIR_HOLDER_NAME

Full name of the academic chair holder.

VARCHAR2

100

IS_CURRENT_CHAIR

Indicator identifying whether the appointment is current (Y/N).

VARCHAR2

1

IS_VACANT_CHAIR

Indicator identifying whether the chair is vacant (Y/N).

VARCHAR2

1

LAST_UPDATE_DATE

Date the chair detail record was last updated.

DATE

LAST_UPDATE_USER

User identifier of the last updater of the record.

VARCHAR2

12

MIT_ID

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

VARCHAR2

9

RECORD_COUNTER

Record counter used for ETL control or auditing.

NUMBER

SA_COST_COLLECTOR_ID

Identifier of the secondary (SA) cost collector associated with the chair.

VARCHAR2

12

SA_COST_COLLECTOR_NAME

Name of the secondary (SA) cost collector associated with the chair.

VARCHAR2

50

SWEB_COST_COLLECTOR_ID

Identifier of the SWEB cost collector associated with the chair.

VARCHAR2

12

SWEB_COST_COLLECTOR_NAME

Name of the SWEB cost collector associated with the chair.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE