Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK AREA Table


View exposing parking area reference records including area codes, names, descriptions, location attributes, and operational indicators.


Field Name

Description

Data Type

Length

IS_CARPOOL_AREA

Indicator identifying whether carpool area (Y/N).

VARCHAR2

1

IS_OFF_CAMPUS_AREA

Indicator identifying whether off campus area (Y/N).

VARCHAR2

1

IS_PARKING_ACTIVE

Indicator identifying whether parking active (Y/N).

VARCHAR2

1

MOIRA_GROUP_AREA

Moira group area associated with the record.

VARCHAR2

32

PARKING_AREA_CODE

Code identifying parking area.

VARCHAR2

4

PARKING_AREA_DESCRIPTION

Description of parking area.

VARCHAR2

255

PARKING_AREA_NAME

Parking area name associated with the record.

VARCHAR2

60

PARKING_LOCATION_URL

Parking location url associated with the record.

VARCHAR2

132

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE