Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MOIRA LIST DETAIL Table


Fact table contains information about all the visible Moira Lists, including the last updated date, members on the list, and owner of the list.


Field Name

Description

Data Type

Length

COUNTER

Numeric field used to count entries in a table. Can be summed on a report. Example - if this field appeared on a table of Person information, it could be used on reports to show headcounts.

NUMBER

1

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

MOIRA_LIST_KEY

Use this field to join together the tables MOIRA_LIST_DETAIL and MOIRA_LIST.

VARCHAR2

50

MOIRA_LIST_MEMBER

Member of the Moira list. Usually this is either the Kerberos Principal or the email address of the member.

VARCHAR2

100

MOIRA_LIST_MEMBER_FULL_NAME

The full name (Last Name, First Name) of the member of the Moira list, if known.

VARCHAR2

90

MOIRA_LIST_MEMBER_MIT_ID

MIT ID of the member of the Moira list, if known.

VARCHAR2

9

MOIRA_LIST_OWNER_KEY

Use this field to join together tables MOIRA_LIST_DETAIL and MOIRA_LIST_OWNER.

VARCHAR2

65

WAREHOUSE_LOAD_DATE

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

DATE

8