ACAD CHAIR HISTORY Table
View exposing historical academic chair reference records including chair type, origin, effective periods, and cost collector associations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACAD_CHAIR_HISTORY_KEY |
Surrogate key uniquely identifying a historical version of an academic chair record. |
VARCHAR2 |
11 |
CHAIR_EFFECTIVE_DATE |
Date on which this version of the academic chair record became effective. |
DATE |
|
CHAIR_EXPIRATION_DATE |
Date on which this version of the academic chair record expired, if applicable. |
DATE |
|
CHAIR_ORIGIN_CODE |
Code identifying the origin or source classification of the academic chair. |
VARCHAR2 |
3 |
CHAIR_ORIGIN_DESC |
Descriptive name of the academic chair origin classification. |
VARCHAR2 |
20 |
CHAIR_SLOTS |
Number of appointment slots associated with the academic chair. |
NUMBER |
3 |
CHAIR_TYPE_CODE |
Code representing the type of academic chair (e.g., endowed, term, named). |
VARCHAR2 |
3 |
CHAIR_TYPE_DESC |
Descriptive name of the academic chair type. |
VARCHAR2 |
20 |
COST_COLLECTOR_ID |
Identifier of the cost collector associated with the academic chair during this historical period. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
Name or description of the cost collector associated with the academic chair. |
VARCHAR2 |
40 |
IS_CLOSED_COST_COLLECTOR |
Indicator specifying whether the associated cost collector is closed (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |