Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT CARD KRB PERSON FEED Table


XXX


Field Name

Description

Data Type

Length

EMAIL_ADDRESS

A person's complete electronic mail address including user name and node name, for example, username@school.edu.

VARCHAR2

50

FIRST_NAME

The person's first name.

VARCHAR2

30

KRB_NAME

Kerberos Name

VARCHAR2

8

LAST_NAME

The person's last name.

VARCHAR2

30

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

50

MIT_ID

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

VARCHAR2

9

PERSON_TYPE

In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member.

VARCHAR2

30

UNIT_NAME

The name of the department, school, center, or lab.

VARCHAR2

50