Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT CARD SPONSORED ACCT FEED Table


View exposing sponsored account feed records used for MIT card provisioning including MIT identifiers, sponsor identifiers, sponsor department, sponsor access end date, and sponsor email attributes.


Field Name

Description

Data Type

Length

MIT_ID

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

VARCHAR2

27

SPONSOR_ACCESS_END_DATE

Date the sponsor-authorized card access ends.

DATE

SPONSOR_DEPT

Sponsoring department associated with the sponsored account.

VARCHAR2

75

SPONSOR_EMAIL

Email address associated with the sponsor.

VARCHAR2

100

SPONSOR_MIT_ID

MIT ID number of the sponsor associated with the sponsored account.

VARCHAR2

27