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].
[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
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: