Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK PARKING LOT Table


View exposing detailed parking lot reference records including lot identifiers, areas, names, descriptions, types, and operational indicators.


Field Name

Description

Data Type

Length

IS_PARKING_LOT_ACTIVE

Indicator identifying whether parking lot active (Y/N).

VARCHAR2

1

PARKING_AREA_CODE

Code identifying parking area.

VARCHAR2

4

PARKING_LOT_CODE

Code identifying parking lot.

VARCHAR2

4

PARKING_LOT_DESCRIPTION

Description of parking lot.

VARCHAR2

128

PARKING_LOT_NAME

Parking lot name associated with the record.

VARCHAR2

60

PARKING_LOT_URL

Parking lot url associated with the record.

VARCHAR2

132

PARK_LOT_TYPE_KEY

Surrogate key identifying the park lot type.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE