Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK REASON CODES Table


View exposing reason code reference values used to classify parking events, overrides, and transactions.


Field Name

Description

Data Type

Length

ACTIVE

Active associated with the record.

VARCHAR2

1

PARK_REASON

Park reason associated with the record.

VARCHAR2

128

PARK_REASON_CODE

Code identifying park reason.

VARCHAR2

4

PARK_REASON_TYPE_KEY

Surrogate key identifying the park reason type.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE