Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MASTER DEPT HIERARCHY LINKS Table


View exposing linked object relationships within the master department hierarchy including hierarchy type, link type, DLC, and linked object identifiers.


Field Name

Description

Data Type

Length

DLC_CODE

Code identifying dlc.

VARCHAR2

180

DLC_KEY

Surrogate key identifying the dlc.

VARCHAR2

180

HIERARCHY_TYPE

Hierarchy type associated with the record.

VARCHAR2

600

LINKED_OBJECT_CODE

Code identifying linked object.

VARCHAR2

240

LINKED_OBJECT_KEY

Surrogate key identifying the linked object.

VARCHAR2

360

LINK_TYPE

Link type associated with the record.

VARCHAR2

600

LINK_TYPE_CODE

Code identifying link type.

VARCHAR2

96