Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FIELDS Table


View exposing fields data including field definitions and configurations used for warehouse metadata administration.


Field Name

Description

Data Type

Length

DATA_TYPE

Data type associated with the record.

VARCHAR2

16

DEFINITION

Definition associated with the record.

VARCHAR2

2000

FIELD_LENGTH

Field length associated with the record.

NUMBER

FIELD_NAME

Field name associated with the record.

VARCHAR2

30

SEQUENCE

Sequence associated with the record.

NUMBER

12

TABLE_KEY

Surrogate key identifying the table.

NUMBER

12

TABLE_NAME

Table name associated with the record.

VARCHAR2

30