TABLES Table
Contains a list and description of all tables in the warehouse that are available to users.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUSINESS_CONTACT_EMAIL |
The email address of the business contact for data. |
VARCHAR2 |
30 |
DESCRIPTION |
the description |
VARCHAR2 |
2000 |
LAST_LOAD_DATE |
Calendar date identifying when the data was last loaded into the data Warehouse. |
DATE |
8 |
PROVIDER_NAME |
Name of the department or custodian or the source of the data. |
VARCHAR2 |
2000 |
SENSITIVITY |
Describes the level category of sentitivity of the data (Public, MIT Only, Sensitive, or Extremely Sensitive. |
VARCHAR2 |
2000 |
SENSIVITITY_DESC |
XXX |
VARCHAR2 |
4000 |
SOURCE_SYSTEM |
The name of the system of record which provides this data. |
VARCHAR2 |
12 |
TABLE_KEY |
Key used to join the SUBJECTS, TABLES, and FIELDS tables together, not for reporting. |
NUMBER |
12 |
TABLE_NAME |
Name of the table or view that the data is stored in . |
VARCHAR2 |
30 |