Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK PERMIT STATUS Table


View exposing permit status reference values used to classify permit lifecycle states.


Field Name

Description

Data Type

Length

PARK_PERMIT_STATUS

Park permit status associated with the record.

VARCHAR2

60

PARK_PERMIT_STATUS_CODE

Code identifying park permit status.

VARCHAR2

10

PARK_PERMIT_STATUS_KEY

Surrogate key identifying the park permit status.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE