UROP FUNDING TYPE Table
A dimension table used in the UROP Project Star. It contains all the possible values for Funding Type (Credit, Direct Funded, Sponsored Research, Volunteer), Special Fund, and Fund Change.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FUNDING_TYPE |
Type of funding of an UROP project: Credit, Direct Funded, Sponsored Research, or Volunteer. |
VARCHAR2 |
30 |
FUND_CHANGE |
Latest funding type change, if any, for project (or null) |
VARCHAR2 |
30 |
SPECIAL_FUNDING |
Code for special fund used to provide funding for UROP direct funded projects (or certain departmental projects) |
VARCHAR2 |
8 |
UROP_FUNDING_TYPE_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP FUNDING TYPE tables. |
VARCHAR2 |
70 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |