MIT PATENT DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSOCIATION_TYPE |
XXX |
VARCHAR2 |
15 |
INVENTOR_LIST |
Lists of inventors. Each inventor is listed with last name and first name. |
VARCHAR2 |
4000 |
MIT_PATENT_CONTACT_KEY |
XXX |
NUMBER |
12 |
PATENT_CATEGORY |
XXX |
VARCHAR2 |
20 |
PATENT_COUNTRY_CODE |
XXX |
VARCHAR2 |
3 |
PATENT_EXPIRE_DATE |
Expiration data of the patent. |
DATE |
|
PATENT_FILE_DATE |
XXX |
DATE |
|
PATENT_ISSUED_DATE |
XXX |
DATE |
|
PATENT_NUMBER |
XXX |
VARCHAR2 |
18 |
PATENT_RECORD_ADD_DATE |
XXX |
DATE |
|
PATENT_RECORD_MOD_DATE |
XXX |
DATE |
|
PATENT_SERIAL_NUMBER |
XXX |
VARCHAR2 |
18 |
PATENT_STATUS_CODE |
XXX |
VARCHAR2 |
6 |
PATENT_STATUS_DATE |
XXX |
DATE |
|
PATENT_STATUS_DESCRIPTION |
XXX |
VARCHAR2 |
120 |
PATENT_TITLE |
XXX |
VARCHAR2 |
165 |
PATENT_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
PATENT_TYPE_DESCRIPTION |
XXX |
VARCHAR2 |
120 |
ROYALTY_PERCENT |
XXX |
NUMBER |
11,8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |