|
|
|
DELW EXPENDITURE DETAIL
This is the fact table for the University of Delaware Survey for Expenditures. The records in this table are grouped by academic year, institution, and Four-Digit CIP code. Fields in each record include salary expenditure, benefits expenditure, non-personnel item expenditure, research expenditure, public service expenditure, as well as the number of different type of degrees offered by the CIP and the undergraduate and graduate student credit hours within the program.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| BENEFITS_EXPENDITURE | Benefits Expenditure - expenditures for benefits associated with the personnel for whom salaries were reported. | NUMBER | 12 |
| DEGREES_AWARDED | Types of degrees awarded by this program (CIP 4-digit): B=Bachelor, M=Masters, D=Doctoral,P=Professional. | VARCHAR2 | 4 |
| DELW_CIP_4_DIGIT_KEY | This field should be used to join to another table with the same-name field. E.g. joining between the DELW_CIP_4_DIGIT table and the DELW_EXPENDITURE_DETAIL table or the DELW_TEACHING_LOAD_DETAIL table. | VARCHAR2 | 4 |
| GRAD_CREDITS_ANNUAL | Number of Graduate Student Credit Hours generated during the academic year | NUMBER | 6 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| NUM_BACHELOR_AWARDED | Number of Bachelor Degrees Awarded | NUMBER | 6 |
| NUM_DOCTORATE_AWARDED | Number of Doctoral Degrees Awarded | NUMBER | 6 |
| NUM_MASTER_AWARDED | Number of Masters Degrees Awarded | NUMBER | 6 |
| NUM_PROF_AWARDED | Number of Professional Degrees Awarded | NUMBER | 6 |
| OTHER_EXPENDITURE | Other Than Personnel Expenditure -- non-personnel items such as travel, supplies and expense, non-capital equipment purchases. | NUMBER | 12 |
| PUBLIC_SVC_EXPENDITURE | Public Service Expenditure (all funds separately budgeted specifically for public service and expended for activities established primarily go provide non-instructional services to benefit groups external to the institution). | NUMBER | 12 |
| RESEARCH_EXPENDITURE | Research Expenditure (all funds expended for activities specifically organized to produce research outcomes; includes funds from external agencies or separately budgeted funds from a unit within the institution). | NUMBER | 12 |
| SALARY_EXPENDITURE | Salary Expenditure -- all wages paid to support the instructional function; includes faculty, clerical support, professional, and graduate student stipends. | NUMBER | 12 |
| UG_CREDITS_ANNUAL | Number of Undergraduate Student Credit Hours generated during the academic year | NUMBER | 6 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home