Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARKING RESERVATION STATUS Table


View exposing parking reservation status reference values used to classify reservation lifecycle states.


Field Name

Description

Data Type

Length

IS_CLOSED

Indicator identifying whether closed (Y/N).

VARCHAR2

1

IS_CONFIRMED

Indicator identifying whether confirmed (Y/N).

VARCHAR2

1

IS_CREATED

Indicator identifying whether created (Y/N).

VARCHAR2

1

IS_DELETION_FLAG_SET

Indicator identifying whether deletion flag set (Y/N).

VARCHAR2

1

IS_TECHNICALLY_COMPLETED

Indicator identifying whether technically completed (Y/N).

VARCHAR2

1

PARKING_RESERVATION_STATUS_KEY

Surrogate key identifying the parking reservation status.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE