OSP AWARD SPONSOR CONTACT Table
View exposing sponsor contact information associated with awards including contact names, contact titles, phone numbers, email addresses, and organizational affiliation used for award administration and sponsor communication.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CONTACT_NAME |
Contact name associated with the record. |
VARCHAR2 |
90 |
CONTACT_TYPE_CODE |
Code identifying contact type. |
VARCHAR2 |
12 |
CONTACT_TYPE_DESC |
Description of contact type. |
VARCHAR2 |
200 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
12 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
200 |
ROLODEX_ID |
Business identifier for the rolodex. |
NUMBER |
|
SEQUENCE_NUMBER |
Sequence number associated with the record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |