MIT PATENT CONTACT Table
View exposing MIT patent contact detail including MIT identifier, names, title, company, citizenship attributes, deceased indicator, and warehouse load date used for inventor and patent contact tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPANY_NAME |
Company name associated with the record. |
VARCHAR2 |
130 |
COUNTRY_CITIZENSHIP |
Country citizenship associated with the record. |
VARCHAR2 |
3 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
30 |
IS_DECEASED |
Indicator identifying whether deceased (Y/N). |
VARCHAR2 |
1 |
IS_US_CITIZEN |
Indicator identifying whether us citizen (Y/N). |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
30 |
MIDDLE_NAME |
Middle name associated with the person. |
VARCHAR2 |
20 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MIT_PATENT_CONTACT_KEY |
Surrogate key identifying the mit patent contact. |
NUMBER |
12 |
TITLE |
Title associated with the record. |
VARCHAR2 |
65 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |