Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT PATENT STATUS Table


View exposing patent-status reference data including active indicator and CPI status and description used for patent lifecycle classification and status reporting.


Field Name

Description

Data Type

Length

ACTIVE

Active associated with the record.

VARCHAR2

1

CPI_DESCRIPTION

Description of cpi.

VARCHAR2

255

CPI_STATUS

Cpi status associated with the record.

VARCHAR2

11

PATENT_STATUS_CODE

Code identifying patent status.

VARCHAR2

6

PATENT_STATUS_DESCRIPTION

Description of patent status.

VARCHAR2

120

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE