The listmanager_tables.xml file

AudienceLevel

Each type of information stored in listmanager_tables.xml file contains attributes. While you store the information, provide correct values for these attributes.

AudienceLevel defines the audience levels of your data model. It contains the following attributes:

• Label: A short description of the audience level.
• Name: The code for identifying the audience level. This must match the AudienceLevel attribute of the list element of the listmanager_list.xml file.
• Table: The name of the table that contains the audience level.
• Datasource: The name of the data source used to access the table from the customer database.

For example:

<AudienceLevel Label="Indiv" Name="Individual" Table="v_indiv_contact" 
		Datasource="JNDI_Name_for_customer_DB">

Each AudienceLevel element contains a child element, Column:

<AudienceLevel ...>
  <Column... />
</AudienceLevel>

Column

The Column parameter specifies the ID column in the audience level table. Column contains a single attribute, Name, for the name of the ID columns in the Audience table. For example:

<Column Name="Indiv_ID"/>

DataSource

The Datasource element defines the data source declared to access the tables. It contains the following attributes:

• Name: The JNDI name of the data source in the web application server.
• Type: The database type. The valid values are SQLSERVER, DB2, ORACLE, NETEZZA, or TERADATA.
• DecimalSeparator: The character that denotes the decimal place. The valid values are period (.) or comma (,).

For example:

<Datasource Name="ACC_DEMO" Type="SQLSERVER" DecimalSeparator="."/>

Table

Table defines the tables on which the search screens and list screens are based. This element contains the following attributes:

• Name: The name of the table.
• DataSource: The data source that is used to access the table.
• Owner: The owner or schema of the database (used to prefix the table name).

For example:

<Table Name="v_indiv_contact" Datasource="ACC_DEMO" Owner="dbo">

Each Table element contains a child element, Column, which can optionally include a LinkedTo parameter:

<Table ...>
 <Column...>
  <LinkedTo ... />
 </Column>
</Table>

Column

The Column parameter describes each column in the table that is defined by the parent Table element. It contains the following attributes:

• Name: The name of the column.
• Type: The type of data that is stored in the column. Valid values are A (alphanumeric), N (numerical), D (date that is stored as VARCHAR yyyymmdd), F (date stored as DATE/DATETIME).
• Length: The length of the column.
• DecimalLength: The length of the decimal part for a numeric column.

For example:

<Column Name="Indiv_ID" Type="N" Length="10" />

The LinkedTo parameter specifies the relationship between a column and a table that defines references. For example, a table contains userID and householdID columns. These columns must reference another table that relates userID to the Customer audience and householdID to the Household audience.

This element contains the following attributes:

• Table: The table where the reference is defined.
• Column: The key column of the table on which the reverence is defined.

For example:

<LinkedTo Table="v_indiv_contact" Column="Indiv_ID"/>