OSP AWARD TERMS TYPE Table
Dimension table contains the different types of OSP award terms and conditions.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
OSP_AWARD_TERMS_CODE |
Award terms code for the different award terms and conditions. |
VARCHAR2 |
3 |
OSP_AWARD_TERMS_DESC |
Description for the award terms code of the different award terms and conditions. |
VARCHAR2 |
200 |
OSP_AWARD_TERMS_TYPE |
This field identifies the types of award terms and conditions (eg. equipment approval, invention, prior approval, property, publication, referenced document, rights in data, subcontract approval, and travel restriction). |
VARCHAR2 |
30 |
OSP_AWARD_TERMS_TYPE_KEY |
Use this field to join the OSP_AWARD_TERMS_DETAIL and the OSP_AWARD_TERMS_TYPE tables for the information of OSP award terms and conditions. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |