ACAD CHAIR DETAIL Table
Stores appointment-level details for academic chairs, including chair holder, appointment dates, vacancy indicators, titles, and associated cost collectors. Each row represents a chair appointment.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 holding the academic chair. |
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 |