Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK ELIGIBLE EMERITUS Table


View exposing emeritus parking eligibility records including identifiers, job attributes, activation dates, and status indicators.


Field Name

Description

Data Type

Length

ADDED_ON

Date associated with added.

DATE

DEACTIVATED_ON

Date associated with deactivated.

DATE

IS_ACTIVE

Indicator identifying whether active (Y/N).

VARCHAR2

1

JOB_TITLE

Job title associated with the record.

VARCHAR2

25

KRB_NAME

Krb name associated with the record.

VARCHAR2

8

MIT_ID

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

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE