TLO CONTACT Table
View exposing TECHNOLOGY LICENSING OFFICE (TLO) contact reference data including MIT identifier, company name, names, title, MIT employee indicator, add and modify dates, withholding flag, and warehouse load date used for TLO contact and licensing relationship tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADD_DATE |
Date associated with add. |
DATE |
|
COMPANY_NAME |
Company name associated with the person or organization. |
VARCHAR2 |
130 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
30 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
30 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
20 |
MIT_EMPLOYEE_FLAG |
Indicator identifying whether mit employee (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MOD_DATE |
Date associated with mod. |
DATE |
|
TITLE |
Title associated with the record. |
VARCHAR2 |
65 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WITHHOLDING_FLAG |
Indicator identifying whether withholding (Y/N). |
VARCHAR2 |
1 |