TLO 1TIME MIT ID Table
View exposing one-time TECHNOLOGY LICENSING OFFICE (TLO) identity matching results between TECHNOLOGY LICENSING OFFICE (TLO) tax-id records and MIT ID database records including matched names, tax identifiers, MIT ID, match type, and load date used for TLO constituent reconciliation and identity verification.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IDDB_FIRST_NAME |
Iddb first name associated with the record. |
VARCHAR2 |
30 |
IDDB_LAST_NAME |
Iddb last name associated with the record. |
VARCHAR2 |
30 |
IDDB_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MATCH_TYPE |
Match type associated with the record. |
VARCHAR2 |
10 |
TAX_ID_TYPE |
Tax id type associated with the record. |
VARCHAR2 |
5 |
TLO_COMPANY_NAME |
Tlo company name associated with the record. |
VARCHAR2 |
60 |
TLO_FIRST_NAME |
Tlo first name associated with the record. |
VARCHAR2 |
30 |
TLO_LAST_NAME |
Tlo last name associated with the record. |
VARCHAR2 |
30 |
TLO_MIDDLE_NAME |
Tlo middle name associated with the record. |
VARCHAR2 |
30 |
TLO_TAX_ID |
Tlo tax id associated with the person. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |