|
|
|
AAMC DETAIL
This is a fact table containing AAMC Faculty Counts.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AAMC_FACULTY_TYPE_KEY | Use this field to join AAMC_FACULTY_TYPE to AAMC_DETAIL. | VARCHAR2 | 1 |
| AAMC_INSTITUTION_KEY | Use this field to join AAMC_INSTITUTION to AAMC_DETAIL. | VARCHAR2 | 32 |
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| FACULTY_COUNT | Number of faculty members | NUMBER | 5 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home