Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK ELIGIBLE ASSIGN Table


View exposing manually assigned parking eligibility records including identifiers, effective dates, permit types, eligibility reasons, and audit attributes.


Field Name

Description

Data Type

Length

ADDED_BY

Added by associated with the record.

VARCHAR2

12

ADDED_ON

Date associated with added.

DATE

BEGIN_DATE

Date associated with begin.

DATE

ELIGIBLE_REASON

Eligible reason associated with the record.

VARCHAR2

128

ELIGIBLE_REASON_CODE

Code identifying eligible reason.

VARCHAR2

9

END_DATE

Date associated with end.

DATE

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PARKING_PERMIT_TYPE_ID

Business identifier for the parking permit type.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE