UROP PROJECT DETAIL Table
View exposing UROP project detail records including research project attributes, participants, and funding context.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATE_DATE |
Date associated with create. |
DATE |
|
CREDIT_SUBJECT |
Credit subject associated with the record. |
VARCHAR2 |
8 |
CREDIT_UNITS |
Credit units associated with the record. |
NUMBER |
2 |
FAC_COUNT_BY_TERM |
Fac count by term associated with the record. |
NUMBER |
|
FAC_COUNT_BY_TERM_DEPT |
Fac count by term dept associated with the record. |
NUMBER |
|
FAC_COUNT_BY_TERM_FUND |
Fac count by term fund associated with the record. |
NUMBER |
|
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
LAST_UPDATED_USER_ID |
Business identifier for the last updated user. |
VARCHAR2 |
8 |
LOCATION_OF_UROP |
Location of urop associated with the record. |
VARCHAR2 |
120 |
PROJECT_COUNT |
Project count associated with the record. |
NUMBER |
|
PROJECT_ID |
Business identifier for the project. |
NUMBER |
|
PROJECT_TITLE |
Project title associated with the record. |
VARCHAR2 |
400 |
SPON_RES_ACCOUNT1 |
Spon res account1 associated with the record. |
VARCHAR2 |
7 |
SPON_RES_ACCOUNT2 |
Spon res account2 associated with the record. |
VARCHAR2 |
7 |
SPON_RES_AMOUNT |
Spon res amount associated with the record. |
NUMBER |
7,2 |
SPON_RES_HOURLY_RATE |
Spon res hourly rate associated with the record. |
NUMBER |
5,2 |
SPON_RES_PCT1 |
Spon res pct1 associated with the record. |
NUMBER |
3 |
SPON_RES_PCT2 |
Spon res pct2 associated with the record. |
NUMBER |
3 |
STATUS_DATE |
Date associated with status. |
DATE |
|
STU_COUNT_BY_TERM |
Stu count by term associated with the record. |
NUMBER |
|
STU_COUNT_BY_TERM_DEPT |
Stu count by term dept associated with the record. |
NUMBER |
|
STU_COUNT_BY_TERM_FUND |
Stu count by term fund associated with the record. |
NUMBER |
|
UROP_ACCOUNT |
Urop account associated with the record. |
VARCHAR2 |
7 |
UROP_AMOUNT |
Urop amount associated with the record. |
NUMBER |
7,2 |
UROP_CONTINUING_BY_YEAR_KEY |
Surrogate key identifying the urop continuing by year. |
VARCHAR2 |
24 |
UROP_DEPARTMENT_KEY |
Surrogate key identifying the urop department. |
VARCHAR2 |
9 |
UROP_FUNDING_TYPE_KEY |
Surrogate key identifying the urop funding type. |
VARCHAR2 |
70 |
UROP_INSTRUCTOR_KEY |
Surrogate key identifying the urop instructor. |
VARCHAR2 |
9 |
UROP_MAT_AMOUNT |
Urop mat amount associated with the record. |
NUMBER |
7,2 |
UROP_STATUS_KEY |
Surrogate key identifying the urop status. |
VARCHAR2 |
40 |
UROP_STUDENT_KEY |
Surrogate key identifying the urop student. |
VARCHAR2 |
15 |
UROP_TERM_KEY |
Surrogate key identifying the urop term. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |