OSP AWARD SPEC REVIEW DETAIL Table
View exposing special review determinations for sponsored awards including conflict of interest, human subjects review, animal care review, and related compliance review determinations used for research governance reporting and approval tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLICATION_DATE |
Date associated with application. |
DATE |
|
APPROVAL_DATE |
Date associated with approval. |
DATE |
|
APPROVAL_TYPE |
Approval type associated with the record. |
VARCHAR2 |
200 |
APPROVAL_TYPE_CODE |
Code identifying approval type. |
NUMBER |
|
COMMENTS |
Comments associated with the record. |
CLOB |
|
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
PROTOCOL_NUMBER |
Protocol number associated with the record. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
28 |
SPECIAL_REVIEW |
Special review associated with the record. |
VARCHAR2 |
200 |
SPECIAL_REVIEW_CODE |
Code identifying special review. |
NUMBER |
|
SPECIAL_REVIEW_NUMBER |
Special review number associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |