|
|
|
FACULTY PROFILE FTE SOURCE
This is a dimension table for the Faculty Profile by CIP star. It contains infomation about the source of funds or revenue source for FTE headcounts.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| FACULTY_PROFILE_FTE_SOURCE_KEY | Use this field to join the FACULTY_PROFILE_FTE_SOURCE table to the FACULTY_PROFILE_DETAIL table. This field should only be used for joining tables, not for reporting. | VARCHAR2 | 1 |
| SOURCE_OF_FUND | Source of Funds for Faculty Profile by CIP. See also SOURCE_OF_FUND_CODE. | VARCHAR2 | 60 |
| SOURCE_OF_FUND_CODE | Code field for Facult Profile by CIP source of funds: 1=State Appropriations and Tuition; 2=Grants and Contracts; 3=Local Funds; 4=Institutional Gifts and Endowments; 5=Other Operating Funds. See also SOURCE_OF_FUND | VARCHAR2 | 1 |
| 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