OSP PROP SPEC REVIEW DETAIL Table
View exposing special review requirements for proposals including human subjects, animal care, environmental, and conflict of interest determinations used for research governance and compliance 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 |
20 |
APPROVAL_TYPE_CODE |
Code identifying approval type. |
VARCHAR2 |
3 |
COMMENTS |
Comments associated with the record. |
VARCHAR2 |
4000 |
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
VARCHAR2 |
8 |
OSP_SPECIAL_REVIEW_KEY |
Surrogate key identifying the osp special review. |
VARCHAR2 |
3 |
PROTOCOL_NUMBER |
Protocol number associated with the record. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
28 |
SPECIAL_REVIEW_NUMBER |
Special review number associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |