Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse DAPER ATHLETE CREW Table


This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to capture the data DAPER sends to Data Warehouse for Athletic Eligibility information for athletes and crew members.


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

9

STUDENT_ELIGIBILITY_TYPE

Athletic Eligibility: "Athlete" or "Crew"

VARCHAR2

8

WAREHOUSE_LOAD_DATE

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

DATE

8