Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT CARD COMMUTER RAIL FEED Table


View exposing commuter rail feed records used for MIT card transit programs including MIT identifiers, transit zone, distribution period, billing period, and location type attributes.


Field Name

Description

Data Type

Length

BILLING_PERIOD

Billing period associated with the commuter rail record.

VARCHAR2

24

DISTRIBUTION_END_DATE

End date of the commuter rail distribution period.

VARCHAR2

8

DISTRIBUTION_START_DATE

Start date of the commuter rail distribution period.

VARCHAR2

8

LOCATION_TYPE

Location type associated with the commuter rail record.

VARCHAR2

216

MIT_ID

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

VARCHAR2

108

TPASS_ZONE_NAME

Transit pass zone associated with the commuter rail record.

VARCHAR2

360