|
|
|
IPEDS FINANCE TYPE
This is a dimension table for IPEDS Survey. It contains information about the parts (part code and description) of the survey, the line numbers and their descriptions, and the various types of amount (e.g. Restricted Amount, Unrestricted Amount, Beginning Balance, Sum Amount, etc.).
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AMOUNT_TYPE | Type of amount in the IPEDS Finance Survey. Eg. Restricted Amount, Unrestricted Amount, Book Value, Market Value, Sum Amount, etc. | VARCHAR2 | 40 |
| IPEDS_FINANCE_TYPE_KEY | Use this field to join the IPEDS FINANCE DETAIL fact table with the IPEDS FINANCE TYPE table to get information about the different types of financial amount reported in the IPEDS Finance Survey. | VARCHAR2 | 7 |
| LINE_NUMBER | Line number in each part of the IPEDS Finance Survey. | VARCHAR2 | 2 |
| LINE_NUMBER_DESCRIPTION | Description of line number in the IPEDS Finance Survey. | VARCHAR2 | 40 |
| PART_CODE | The codes (A, B, D, E, F, G, H, K) of the different parts in the IPEDS Finance Survey | VARCHAR2 | 1 |
| PART_DESCRIPTION | Description of the different parts in the IPEDS Finance Survey. | VARCHAR2 | 80 |
| 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