ACAD CHAIR Table
Academic chair information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACAD_CHAIR_KEY |
Use this field to join between the ACAD_CHAIR_DETAIL and ACAD_CHAIR tables for information about the academic chair (eg. chair type, chair origin, chair cost collector dates). |
VARCHAR2 |
7 |
CHAIR_EFFECTIVE_DATE |
XXX |
DATE |
8 |
CHAIR_EXPIRATION_DATE |
XXX |
DATE |
8 |
CHAIR_ORIGIN_CODE |
XXX |
VARCHAR2 |
3 |
CHAIR_ORIGIN_DESC |
XXX |
VARCHAR2 |
20 |
CHAIR_SLOTS |
This field specifies the number of chair appointments the chair cost collector can fund simultaneously. |
NUMBER |
22 |
CHAIR_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
CHAIR_TYPE_DESC |
XXX |
VARCHAR2 |
20 |
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
The name of the Cost Collector. |
VARCHAR2 |
40 |
DONOR_SPECIFIED_CHAIR_TITLE |
XXX |
VARCHAR2 |
72 |
IS_CLOSED_COST_COLLECTOR |
Y= the cost collector is closed. The cost collector has a term code value of 3. N = the cost collector is open. The cost collector has a term code value of null, 1, or 2. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |