LTR_M2_ELISTS

Description:

This table is responsible for holding information about all of an organization's visible lists within Tessitura. In a consortium environment, all organizations' lists are stored in this table. This table should be exposed through System Tables for editing, if possible. In order for this to happen, ensure that all proper permissions (select,insert,update,delete) have been granted to [impusers]. 

Schema:

    [id] [int] IDENTITY(1,1) NOT NULL,
    [mail2_list_id] [int] NOT NULL,
    [mail2_list_name] [varchar](100) NOT NULL,
    [list_type] [char](10) NOT NULL,
    [active] [char](10) NOT NULL,
    [organization_name] [varchar](50) NULL,
    [control_group] [int] NULL,
    [default_ind] [char](1) NULL,
    [created_by] [char](8) NULL,
    [create_dt] [datetime] NULL,
    [create_loc] [varchar](16) NULL,
    [last_update_dt] [datetime] NULL,
    [last_updated_by] [char](8) NULL
    

Whenever a user creates, updates, or deletes a public or private list in their mail2 dashboard, this table is affected. Creating a list enters a new row, updating alters existing list information, and deleting change the [active] field to 'N'. The [control_group] column is populated with the value of the T_Default m2defaultControlGroup for the organization that created the list. The web user from the organization's parent table used by mail2 must have access to this control group in order for the custom screen to properly display. Organization name is used to identify the organization within a consortium environment that has ownership of a list. 

The [id] column maps to the [m2_list_id] field in LTX_M2_ELISTS_EADDRESS.
The [id] field is a foreign key to the [m2_list_id] column of LTX_M2_ELISTS_EADDRESS.
The table is indexed by [id] and that field is the identity column for this table. 

This table is updated by procedure:

LWP_M2_HANDLE_LISTS

Still need help? Contact Us Contact Us