Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MOIRA LIST OWNER Table


A dimension table used in the Moira List data model. It contains the owners and the type of owners (eg. USER, LIST) of all visiable Moira Lists.


Field Name

Description

Data Type

Length

MOIRA_LIST_OWNER_KEY

Use this field to join together tables MOIRA_LIST_DETAIL and MOIRA_LIST_OWNER.

VARCHAR2

65

OWNER

In table MOIRA_LIST_OWNER, this field contains the owner of the MOIRA list. The owner can be an user (ie. Kerberos Principal) or another MOIRA list.

VARCHAR2

50

OWNER_TYPE

Type of Moira list owner: LIST, USER

VARCHAR2

10

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8