Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT CARD PICTURE Table


This table contains the image file of the picture on the MIT card of students and employees. There is one record per person.


Field Name

Description

Data Type

Length

BASE64_IMAGE

XXX

CLOB

4000

IMAGE

The picture image

BLOB

0

IMAGE_ID

An identifier used by the MIT Card Office to uniquely identified each of the card pictures.

VARCHAR2

9

IMAGE_TYPE

Types of the picture image: JPEG, GIF, etc.

VARCHAR2

5

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

The date the record was loaded into the Data Warehouse from the source system.

DATE

8