MITID DB PERSON Table
All people with a MIT ID in the MITID database
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNED_SOURCE |
This field describes the source of the record. Current sources are: Registrar's Office, Personnel Department, Lincoln Lab, MITID Database, and Registrar's Office--Archive. |
VARCHAR2 |
30 |
CREATION_DATE |
The date a record was created. |
DATE |
8 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HAS_DUPLICATE_SSN |
Y=this person (this MIT ID) has a duplicate social security number in file. |
VARCHAR2 |
1 |
HAS_SSN |
Y=this person has a social security number in file, N otherwise. |
VARCHAR2 |
1 |
IS_OBSOLETE |
In the MITID_DB_PERSON table, this is a flag indicates whether the MIT ID record is obolete; Y=Yes, it is obsolete, N=No. |
VARCHAR2 |
1 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MODIFICATION_DATE |
Record change date. |
DATE |
8 |
OBSOLETE_DATE |
In the MITID_DB_PERSON and MITID_OBSOLETE tables, this field shows the date when the MIT ID became obsolete. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |