ACAD CHAIR Table
Stores academic chair reference information, including chair type, origin, effective dates, associated cost collectors, and donor-specified attributes. Each row represents an academic chair.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACAD_CHAIR_KEY |
Surrogate key identifying the academic chair. |
VARCHAR2 |
7 |
CHAIR_EFFECTIVE_DATE |
Date the academic chair became effective. |
DATE |
|
CHAIR_EXPIRATION_DATE |
Date the academic chair expired or became inactive. |
DATE |
|
CHAIR_ORIGIN_CODE |
Code identifying the origin of the academic chair. |
VARCHAR2 |
3 |
CHAIR_ORIGIN_DESC |
Description of the academic chair origin. |
VARCHAR2 |
20 |
CHAIR_SLOTS |
Number of available slots associated with the academic chair. |
NUMBER |
3 |
CHAIR_TYPE_CODE |
Code identifying the type of academic chair. |
VARCHAR2 |
3 |
CHAIR_TYPE_DESC |
Description of the academic chair type. |
VARCHAR2 |
20 |
COST_COLLECTOR_ID |
Identifier of the cost collector associated with the academic chair. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
Name of the cost collector associated with the academic chair. |
VARCHAR2 |
40 |
DONOR_SPECIFIED_CHAIR_TITLE |
Donor-specified title of the academic chair. |
VARCHAR2 |
72 |
IS_CLOSED_COST_COLLECTOR |
Indicator identifying whether the cost collector is closed (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |