Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TLO 1TIME MIT ID Table


XXX


Field Name

Description

Data Type

Length

IDDB_FIRST_NAME

XXX

VARCHAR2

30

IDDB_LAST_NAME

XXX

VARCHAR2

30

IDDB_MIT_ID

XXX

VARCHAR2

9

MATCH_TYPE

XXX

VARCHAR2

10

TAX_ID_TYPE

XXX

VARCHAR2

5

TLO_COMPANY_NAME

XXX

VARCHAR2

60

TLO_FIRST_NAME

XXX

VARCHAR2

30

TLO_LAST_NAME

XXX

VARCHAR2

30

TLO_MIDDLE_NAME

XXX

VARCHAR2

30

TLO_TAX_ID

XXX

VARCHAR2

11

WAREHOUSE_LOAD_DATE

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

DATE