Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT CARD PICTURE Table


View exposing MIT card image records including image identifiers, MIT identifiers, image type, binary image content, and encoded image content used for card production and identity verification.


Field Name

Description

Data Type

Length

BASE64_IMAGE

Encoded image content associated with the MIT card used for identity verification and card production.

CLOB

IMAGE

Binary image content associated with the MIT card used for identity verification and card production.

BLOB

IMAGE_ID

Unique identifier for the MIT card image.

VARCHAR2

9

IMAGE_TYPE

Code identifying the image type associated with the MIT card record.

CHAR

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