Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK REQUEST LOCATION Table


View exposing location reference data associated with facilities work requests.


Field Name

Description

Data Type

Length

PARENT_LOCATION_KEY

Surrogate key identifying the parent location.

VARCHAR2

30

PARENT_LOCATION_NAME

Parent location name associated with the record.

VARCHAR2

64

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_REQUEST_LOCATION_KEY

Surrogate key identifying the work request location.

VARCHAR2

30

WORK_REQUEST_LOCATION_NAME

Work request location name associated with the record.

VARCHAR2

64