FIELDS Table
Contains a list of fields and their descriptions, as well as the tables where the fields appear.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATA_TYPE |
Format of this piece of data stored in the Data Warehouse (Example: Number, Varchar2, Number, etc.) |
VARCHAR2 |
16 |
DEFINITION |
A description of the data element. |
VARCHAR2 |
2000 |
FIELD_LENGTH |
The length of a data element as stored in the Data Warehouse. |
NUMBER |
22 |
FIELD_NAME |
Name of the data element. |
VARCHAR2 |
30 |
SEQUENCE |
Numerical value identifing the position of this data element within the table. |
NUMBER |
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 |