Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK REQUEST LONG TEXT DETAIL Table


View exposing long-text detail associated with facilities work requests, including descriptive maintenance and service notes.


Field Name

Description

Data Type

Length

LINE_SEQUENCE

Line sequence associated with the record.

VARCHAR2

5

LINE_TEXT

Line text associated with the record.

VARCHAR2

200

LONG_TEXT_TYPE

Long text type associated with the record.

VARCHAR2

13

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_REQUEST_KEY

Surrogate key identifying the work request.

VARCHAR2

7