OSP AWARD CUSTOM DATA DETAIL Table
View exposing custom data fields associated with sponsored awards including user-defined attributes, extended award metadata, and institution-specific tracking fields used for specialized reporting and customized data analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CUSTOM_COLUMN_VALUE_CODE |
Code identifying custom column value. |
VARCHAR2 |
200 |
CUSTOM_COLUMN_VALUE_DESC |
Description of custom column value. |
VARCHAR2 |
200 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
OSP_AWARD_CUSTOM_COLUMN_KEY |
Surrogate key identifying the osp award custom column. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |