|
|
|
IPEDS FINANCE DETAIL
This is a fact table for IPEDS Finance Survey - the USDE National Center for Educational Statistics annual survey of the financial condition of postsecondary education in the nation. The table consists of the following parts of the survey: Part A (Current Funds Revenues by Source), Part B (Current Funds Expenditures by Function), Part D (Utility Expenditures), Part E (Scholarship and Fellowship Expenditures), Part G (Indebtedness of Physical Plant), Part H (Details of Endowment Assets, and part K (Physical Plant Assets). Data in the table range from fiscal year 1989 through 2000.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AMOUNT | Amount of money. | NUMBER | 12 |
| FISCAL_YEAR_KEY | Use this field to join to another table with the same-name field (ie. FISCAL_YEAR_KEY) for fiscal year information. It shouldn't be used for reporting. | VARCHAR2 | 4 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| 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 |
| 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