MOIRA LIST DETAIL Table
Stores Moira list membership details linking lists to owners and members, including member identifiers, member names, update timestamps, and ETL counters. Each row represents a single membership entry for a Moira list.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COUNTER |
Record counter used for ETL control or auditing. |
NUMBER |
|
LAST_UPDATE_DATE |
Date the membership entry was last updated (as provided by the source). |
DATE |
|
MOIRA_LIST_KEY |
Unique key identifying the Moira list. |
VARCHAR2 |
60 |
MOIRA_LIST_MEMBER |
Member identifier for the list entry (e.g., user, list, or external address) as provided by the source. |
VARCHAR2 |
225 |
MOIRA_LIST_MEMBER_FULL_NAME |
Full name of the list member, when available (as provided by the source). |
VARCHAR2 |
90 |
MOIRA_LIST_MEMBER_MIT_ID |
MIT ID number of the list member, when available. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MOIRA_LIST_OWNER_KEY |
Key identifying the Moira list owner record associated with the list (as provided by the source). |
VARCHAR2 |
140 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |