MIT PATENT DETAIL Table
View exposing patent detail by patent contact and patent serial number including patent numbers, title, country, status, dates, type, category, royalty percentage, association type, and inventor list used for patent portfolio management and licensing tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSOCIATION_TYPE |
Association type associated with the record. |
VARCHAR2 |
15 |
INVENTOR_LIST |
Inventor list associated with the record. |
VARCHAR2 |
4000 |
MIT_PATENT_CONTACT_KEY |
Surrogate key identifying the mit patent contact. |
NUMBER |
12 |
PATENT_CATEGORY |
Patent category associated with the record. |
VARCHAR2 |
20 |
PATENT_COUNTRY_CODE |
Code identifying patent country. |
VARCHAR2 |
3 |
PATENT_EXPIRE_DATE |
Date associated with patent expire. |
DATE |
|
PATENT_FILE_DATE |
Date associated with patent file. |
DATE |
|
PATENT_ISSUED_DATE |
Date associated with patent issued. |
DATE |
|
PATENT_NUMBER |
Patent number associated with the record. |
VARCHAR2 |
18 |
PATENT_RECORD_ADD_DATE |
Date associated with patent record add. |
DATE |
|
PATENT_RECORD_MOD_DATE |
Date associated with patent record mod. |
DATE |
|
PATENT_SERIAL_NUMBER |
Patent serial number associated with the record. |
VARCHAR2 |
18 |
PATENT_STATUS_CODE |
Code identifying patent status. |
VARCHAR2 |
6 |
PATENT_STATUS_DATE |
Date associated with patent status. |
DATE |
|
PATENT_STATUS_DESCRIPTION |
Description of patent status. |
VARCHAR2 |
120 |
PATENT_TITLE |
Patent title associated with the record. |
VARCHAR2 |
165 |
PATENT_TYPE_CODE |
Code identifying patent type. |
VARCHAR2 |
3 |
PATENT_TYPE_DESCRIPTION |
Description of patent type. |
VARCHAR2 |
120 |
ROYALTY_PERCENT |
Royalty percent associated with the record. |
NUMBER |
11,8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |