To add a contact status code

Before adding a contact status, see Default contact status codes to determine which existing status codes meet your needs and which ones you must create.

You define contact status codes in the UA_ContactStatus table in the Campaign system database.

1.	Log in to the database management system that contains the Campaign system table database.

2.	Open the UA_ContactStatus table.

3.	Add rows for contact statuses you need to add. For each new status:

a.	Enter a unique ContactStatusID.

The ContactStatusID can be any unique positive integer within the internalIdLowerLimit and internalIdUpperLimit configuration parameter values. You set these values on the Configuration page in Marketing Platform. For more information, see the IBM Unica Marketing Administrator’s Guide.

b.	Enter a Name.

c.	Optionally, enter a Description.

d.	Enter a unique ContactStatusCode, using the values A-Z and 0-9.

e.	In the CountsAsContact column, enter 1 if the status represents a successful contact, or 0 if it does not.

This column is used by Optimize for managing contact fatigue. It also may be useful for queries against the contact history table to suppress individuals who have received a specific number of contacts within some time period.

f.	In the Defaults column, enter 0 if that status is not to be the default, or 1 if it is. Enter 2 for the default status for control cells. Ensure that only one row was the value 1 and one row has the value of 2 in this column.

4.	Save the table changes.

If necessary, see the documentation for your database management system for detailed instructions on modifying data in tables.