EPR PATENT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATA_SOURCE |
Source of the data in this record. |
VARCHAR2 |
50 |
INVENTOR_LIST |
Lists of inventors. Each inventor is listed with last name and first name. |
VARCHAR2 |
4000 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PATENT_DESCRIPTION |
XXX |
VARCHAR2 |
32767 |
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_SERIAL_NUMBER |
XXX |
VARCHAR2 |
18 |
PATENT_STATUS |
XXX |
VARCHAR2 |
120 |
PATENT_TITLE |
XXX |
VARCHAR2 |
165 |
SOURCE_LAST_UPDATE_DATE |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |