EPR PATENT Table
View exposing patent records associated with Employee Professional Record data used for professional activity reporting and review.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATA_SOURCE |
Data source associated with the record. |
VARCHAR2 |
50 |
INVENTOR_LIST |
Inventor list associated with the record. |
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 |
Description of patent. |
VARCHAR2 |
32767 |
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_SERIAL_NUMBER |
Patent serial number associated with the record. |
VARCHAR2 |
18 |
PATENT_STATUS |
Patent status associated with the record. |
VARCHAR2 |
120 |
PATENT_TITLE |
Patent title associated with the record. |
VARCHAR2 |
165 |
SOURCE_LAST_UPDATE_DATE |
Date associated with source last update. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |