Unica Campaign system table reference

The system table reference provides details on each of the Unica Campaign system tables. The data types that are indicated in the following tables are generic types that may be different in your Unica Campaign installation, depending on the database that is used for the system tables. The Unica Campaign system tables are stored in a database that was created prior to the Unica Campaign installation. The database can have any name. The ODBC or native connection provides a connection to the database. The Unica Campaign configuration settings under Campaign | partitions | partition1 | dataSources | UA_SYSTEM_TABLES determine how Unica Campaign interacts with databases, including its own system tables, for the default partition.

UA_History

UA_ActionCustomer

The UA_ActionCustomer table is a sample action table that is provided for the Customer audience level. The fields in this table are examples of fields that may be useful for generating response history. Administrators can customize the table as needed. Typically, each audience level has its own action table, which is used for response tracking.

Table 1. UA_ActionCustomer field descriptions
Field Name Type Null? Description Length Additional Attributes
CustomerID BIGINT NOT NULL This field represents the audience level, which may comprise one or more fields. 19 Is Primary Key? No
ActionDateTime TIMESTAMP NOT NULL Example of a field that can be used when generating response history. 23,3 Is Primary Key? No
ResponseChannel VARCHAR NULL Example of a field that can be used when generating response history. 16 Is Primary Key? No
Unica CampaignCode VARCHAR NOT NULL Example of a field that can be used when generating response history. 32 Is Primary Key? No
OfferCode VARCHAR NOT NULL Example of a field that can be used when generating response history. 64 Is Primary Key? No
CellCode VARCHAR NOT NULL Example of a field that can be used when generating response history. 64 Is Primary Key? No
TreatmentCode VARCHAR NOT NULL Example of a field that can be used when generating response history. 64 Is Primary Key? No
ProductID BIGINT NOT NULL Example of a field that can be used when generating response history. 19 Is Primary Key? No
ResponseTypeCode VARCHAR NULL Example of a field that can be used when generating response history. 64 Is Primary Key? No

UA_AttributeDef

The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (Unica Campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

Table 2. UA_AttributeDef field descriptions
Field Name Type Null? Description Length Additional Attributes
AttributeID BIGINT NOT NULL Globally unique identifier of the attribute. This ID is assigned by the system when an attribute is created. Custom attribute IDs start at either 100 or the value of internalIDLowerLimit config parameter, whichever is higher. 19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NULL Internal name of the attribute; must be globally unique. The name is user-provided for custom attributes and is the name used in any Unica query expression when the field is used as an UCGF. The internal name is automatically provided for system-defined attributes and cannot be modified. Changing this value after it is used will break any query expressions referencing the prior name.

Valid Values: Any text characters, minus standard disallowed special Unica query language name characters.

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DisplayName VARCHAR NULL Display name of attribute, should not necessarily be unique within offer attributes, cell attribute and campaign attribute names but it is recommended to be unique within the same type (offer, cell and campaign) to avoid confusion. The name is user-provided for custom attributes and is the label displayed to the user in forms and reports (e.g., the Custom attributes definition page).

Valid Values: Any text characters, minus standard disallowed special name characters.

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional, user-entered, free-form description of the attribute.

Valid Values: Any text characters minus standard disallowed special characters in text

512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ObjectType INTEGER NULL System-generated value specifying the type of object for which this attribute is defined.

Valid Values: 2=Unica Campaign, 4=Offer, 11=TargetCell

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

EnumType INTEGER NULL User specified behavior on whether an attribute is a free-form text box (user enters value), a drop-down list with fixed entries, or whether the user can choose from a drop-down list OR add an additional value. Additional values are checked for uniqueness (case-insensitive compare) and will be available in the drop-down list for all users. Type can be only be changed from 1 to 2 and vice versa after initial creation. This option is currently available only for enumerated text strings (not for date, numeric, or currency data types).

Valid Values: 0=Edit Only, 1=Enumeration Only, 2=Enum with Dynamic Add

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

AttributeType INTEGER NULL User-specified data type for a custom attribute (not editable for a system-defined attribute). Types 5 and 6 can only be created from Unica Plan. This value cannot be changed after initial creation of a custom attribute.

Valid Values: 1=String, 2=Number, 3=DateTime, 4=Currency, 5=Boolean, 6=Integer

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Length INTEGER NULL User-specified value for length of text string data type and precision (# of decimal places to the right of the decimal point) displayed for numbers and currency data types. Not used for datetime data type. Length of a text-string custom attribute can very well be decreased. You may lose any value lost that is beyond the decreased length though. Hence, not recommended. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Retired INTEGER NULL Reserved for future use.

Valid Values: 0 = active; 1 = retired

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

SystemDefined INTEGER NULL Specifies whether an attribute is a predefined attribute shipped with Unica Campaign. All custom attributes have a value of 0 except the ones already created by the system during installation, that have value of 1. System defined or user defined attributes cannot be deleted from the system.

Valid Values: 0 = user defined, 1 = system-defined

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Unica Platform user ID for the user who created the object.

Valid Values: Valid Unica Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved).

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Unica Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Unica Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreatorFlag INTEGER NULL Specifies the application that created the custom attribute

Valid Values: NULL/0 = Unica Campaign 1 = HCL Plan (UMO)

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

isMandatory INTEGER NULL This flag indicates if attribute is mandatory. If value is one, user must provide value to this attribute when user creates Campaign/offer/cell.

Valid Values: 0,1

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

sortOrder INTEGER NULL This flag indicates by which order values in Single Select attribute should be sorted.

Valid Values: 0,1,2,3

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

LKUP_TABLE VARCHAR NULL Name of the database table that supplies values from which users can select for this attribute. 256 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LKUP_ID_COLUMN VARCHAR NULL Name of the key column in the lookup table for this attribute. 256 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LKUP_DISP_COLUMN VARCHAR NULL Name of the column in the lookup table that stores the values to display to the users. 256 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LKUP_SORT_COLUMN VARCHAR NULL Name of the column in the lookup table to use to sort the entries that display to the users. 256 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LKUP_ID_COL_DBTYPE VARCHAR NULL Datatype of the id column in the lookup table. 50 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LKUP_SORT_COL_DBTYPE VARCHAR NULL Datatype of the sort column in the lookup table. 50 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LKUP_SORT_ASCENDING VARCHAR NULL

Sort order for the lookup table. The following values are valid.

• 0 = Descending

• 1 = Ascending

5 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

Table 3. UA_AttributeDef child tables
Table name Description
UA_CampAttribute This table stores the values of the campaign custom attributes for each campaign.
UA_CampToCellAttr This table is a mapping of cell custom attributes to Unica Campaign. The AttributeIDs in that table are all of the cell attributes. This table is populated only in Unica Campaigns created in HCL Plan.
UA_CellAttribute This table stores the custom cell attribute values for a particular cell. These values are data-entered by the user in the Target Cell Spreadsheet (TCS). Only one of the fields (StringValue, NumberValue, DatetimeValue) is populated for any given row, depending on the data type of the custom attribute (as specified in UA_AttributeDef). Attributes are displayed in the target cell spreadsheet in AttributeID order.
UA_EnumAttrValues This table holds all the drop-down list (enumerated) data values for custom attributes where UA_AttributeDef.EnumType = 1 or 2.
UA_OfferAttribute This table stores the values of offer attributes associated with an offer (system-generated and custom).
UA_OfferHistAttrib This table stores the actual values used for parameterized (only) offer attributes when an offer is used (given out in a flowchart production run with logging to CH enabled). It is populated at flowchart run time.
UA_OfferTemplAttr This table stores the offer attribute values associated with a particular offer template and specifies whether each attribute is hidden, parameterized, its default value, and display order. Note that only one of the fields StringValue, NumberValue and DatetimeValue contain the value for the attribute based on the attributeType defined in the UA_AttributeDef table.

UA_Calendar

This table holds calendar information identifying information about calendar quarters, days of the week, first and last days of the week, etc. It is used to facilitate reporting over time. It is expected that this table will be customized by customers during implementation. It is the responsibility of the implementation to ensure that dates referenced in Contact history are contained in the time span covered by this table.

Table 4. UA_Calendar field descriptions
Field Name Type Null? Description Length Additional Attributes
DateID BIGINT NOT NULL Unique identifier for a row of this table.

Valid Values: Date represented as YYYYMMDD

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Year INTEGER NOT NULL Four-digit year for the date.

Valid Values: Positive 4-digit integer

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

FiscalYear INTEGER NOT NULL Four-digit fiscal year for the date.

Valid Values: Positive 4-digit integer

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Quarter INTEGER NOT NULL Calendar quarter in which the date falls (Q1 being Jan. 1st through March 31st).

Valid Values: Integer value between 1-4

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

FiscalQuarter INTEGER NULL Calendar quarter in which the date falls

Valid Values: Integer value between 1-4

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Month INTEGER NOT NULL Month in which the date falls.

Valid Values: Integer value between 1-12

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

WeekOfYear INTEGER NOT NULL Week in which the date falls.

Valid Values: Integer value between 1-52

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

WeekOfMonth INTEGER NOT NULL Which week within a month a date falls.

Valid Values: Integer value between 1-5

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

DayOfYear INTEGER NOT NULL Which day of the year a date falls.

Valid Values: Integer value between 1-366

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

DayOfMonth INTEGER NOT NULL Which day of the month a date falls.

Valid Values: Integer value between 1-31

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

DayOfWeek INTEGER NOT NULL Which day of the week a date falls.

Valid Values: Integer value between 1-7

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

ActualDate TIMESTAMP NOT NULL The date represented in this row.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

FirstDayOfWeek TIMESTAMP NOT NULL The first day of the week in which this date falls.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

LastDayOfWeek TIMESTAMP NOT NULL The last day of the week in which this date falls.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Table 5. UA_Calendar child tables
Table name Description
UA_ContactHistory User-created table that stores the required contact fields (AudienceID, CellID, PackageID, ContactDateTime, ContactStatusID, and so forth) plus any user-defined additionally tracked fields. There is a separate table for each audience level. Rows in this table are written if the CSP logging table has "Log to contact history tables" enabled. This table captures cell membership information and identifies cells treated in the same CSP by packageID (all contacts made to the same audience entity in the same CSP is part of the same "package", which represents an interruption). Both target cells and hold-out controls are written to contact history (CH). Existing entries in this table can be updated (ContactStatus, UpdateDateTime, and user-defined fields) using the Track process. The Track process cannot create new rows in this table. This table is required for tracking contacts. This is also used by Unica Optimize (ACO) for applying optimization to contacts. This "base" contact history table is populated simultaneously with the UA_Treatment, UA_OfferHistory, and UA_OfferHistAttrib tables (together all of these tables make up "contact history"). None of these tables are written if log to contact history is not enabled in a CSP.
UA_DtlContactHist The concept of offer version is no longer supported/present since 7.x. Hence, please remove offer versions. This table has rows written to it only when UA_Treatment.HasDetailHistory = 1.
UA_ResponseHistory User-created table that stores the required response tracking fields (AudienceID, TreatmentInstID, response date, response type, and so forth) plus any user-defined additionally tracked fields. There is a separate response history table for each audience level. Rows in this table are written by the Response process.
UA_STO_METRICS User-created table that stores the required send time optimization fields (CustomerID, ContactEmail, CustomerStatus, PreferredSendTime ,STOOpenCount, STOGenDate, TimeZone. There is a separate table for each audience level. Rows in this table are written by STO ETL if Send Time Optimization is enabled.

UA_Campaign

This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.

Table 6. UA_Campaign field descriptions
Field Name Type Null? Description Length Additional Attributes
CampaignID BIGINT NOT NULL Globally unique, system-generated identifier of a campaign, assigned by the system when a campaign is created. Campaign uses the next available value (assumed unique) from the UA_IDSByType table for campaigns.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NOT NULL Name of campaign; not required to be unique (but is a best practice to be unique).

Valid Values: Any text characters, minus standard disallowed special name characters

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional, user-entered, free-form description of the campaign.

Valid Values: Any text characters minus standard disallowed special characters in text

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

FolderID BIGINT NULL Folder ID for the folder where the campaign is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CampaignCode VARCHAR NOT NULL Globally unique code for the campaign. By default, a campaign code is generated by the system using the configured campaign code generator (campCodeGenProgFile) when creating a new campaign. The length and format of the campaign code is specified at implementation time (campCodeFormat). (Both of these configuration parameters can be found in the server > systemCodes config section). The campaign code can be changed by the user to any unique value satisfying the code format (enforced by Campaign). Changing this value after a campaign runs may cause response tracking problems if campaign code is used.

Valid Values: Depends on campaign code format specified: n=0-9 a=A-Z c=A-Z, 0-9 x=any character

32 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Initiative VARCHAR NULL Optional initiative associated with this campaign.

Valid Values: Any value from the UA_Initiatives table If values are subsequently deleted from UA_Initiatives, it is possible to have values here that do not appear in that table.

255 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Objectives VARCHAR NULL Optional, free-form text description of the campaign objective(s).

Valid Values: Any text characters minus standard disallowed special characters in text

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Date and time the Campaign is created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Unica Platform user ID of the user who created the campaign.

Valid Values: Valid Unica Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved).

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Unica Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Unica Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

StartDate TIMESTAMP NULL Date the campaign is effective. In the UI, this is the campaign Effective Date. Default value is today.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

EndDate TIMESTAMP NULL Date the campaign expires. In the UI, this is the campaign Expiration Date. Default value is one month from start date.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

LastRunDate TIMESTAMP NULL Date and time the campaign was last run (any flowchart, branch, process run of any flowchart within the campaign). This value is NULL if never run. Test runs do NOT update this value.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

RunBy INTEGER NULL Unica Platform user ID for the user who last ran the campaign; updated whenever LastRunDate is updated. This value is NULL if never run. Test runs do NOT update this value.

Valid Values: Valid UserID in Unica Platform Value may be invalid if user is subsequently deleted.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

ProjectID INTEGER NULL Unica Marketing Operations project ID. This field is populated when a campaign is created from Unica Marketing Operations. By default, this value is NULL. When a project in Unica Marketing Operations is disassociated with this campaign, the system writes a NULL to this field (based on UnlinkProjectNotification campaign service call).

Valid Values: NULL, 0, or valid ProjectID from HCL Unica Marketing Operations.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Unica Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Marketing Platform's usm_role table

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

CreatorFlag INTEGER NULL Specifies the application that created the custom campaign
Valid Values:
  • NULL/0 = Campaign.
  • 1 = Unica Plan (UMO).
10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

globalPreferenceId bigint NULL Stores the regional preference Id coming from Contact Central selected while creating campaign. Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Table 7. UA_Campaign parent tables
Table name Description
UA_Folder This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).
Table 8. UA_Campaign child tables
Table name Description
UA_CampAttribute This table stores the values of the campaign custom attributes for each campaign.
UA_CampToCellAttr This table is a mapping of cell custom attributes to Campaign. The AttributeIDs in that table are all of the cell attributes. This table is populated only in campaigns created in HCL Plan.
UA_CampToOffer This table stores top-down defined relationships between a campaign and its related offers (specified by the user from the Campaign summary page by clicking on "Add/Remove Offers" link). This can be a many-to-many mapping. Bottom-up offers (offers used in a flowchart of the campaign) are not stored in this table.
UA_CampToSegment This table stores top-down defined relationships between a campaign and its related segments (specified by the user from the Campaign summary page by clicking on "Add/Remove Segments" link). This can be a many-to-many mapping. Bottom-up segments (strategic segments used in a flowchart of the campaign) are not stored in this table.
UA_Flowchart This table stores information for all flowcharts. It has one row for each flowchart in the system and is also used for reporting on the running flowcharts (status) in the system.
UA_TargetCells This table stores information on target cells created in all flowcharts. Target cells are defined as cells that are attached to an output process (Mail List, Call List, Deliver, Snapshot, or Optimize). It stores meta data information (name, code), source info (campaign, flowchart and cell IDs), treatment data (list of assigned offers/offer lists and whether it is a control cell), and whether the cell was created top-down in the Target Cell Spreadsheet (TCS) or bottom-up from within a flowchart.
UA_Treatment Stores all treatments (intersection of offer versions to target cells at a point in time (run instance) and related data. If multiple offers are assigned to a cell, there are multiple rows in the treatment table (one treatment for each offer version given to the cell). If offer personalization is used, a treatment is created for each unique permutation of offer attributes (offer version) used (and HasDetailHistory=1 and contact information is stored in a separate table, UA_DtlContactHistory). This data is populated during a production run of a CSP only when logging is enabled.
UA_OptimizeProcess An entry in this table represents a single Optimize process box as seen in Campaign flowcharts.

UA_AnnotationInfo

This table contains data for annotations that are created and edited by users. One row is written this table each time a new annotation is created or updated and the flowchart is saved. A maximum of one annotation is allowed for each process box.

Table 9. UA_AnnotationInfo field descriptions
Field Name Type Null? Description Length Additional Attributes
FlowchartID BIGINT NOT NULL Represents a globally unique, system-generated identifier of the flowchart in which the annotation is created. FlowchartID forms part of the composite primary key for this table.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

AnchorID BIGINT NOT NULL Represents unique in Flowchart scope, system-generated identifier of an anchor (an object within flowchart which owns annotation). AnchorID forms part of the composite primary key for this table. Only processes are supported as anchors.

Valid Values: Flowchart level unique positive integer.

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

AnchorType INTEGER NOT NULL Represents type of anchor (an object within flowchart which owns annotation). AnchorType forms part of the composite primary key for this table. Only processes are supported as anchors.

Valid Values: 1

10 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

CreationDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

CreatedBy INTEGER NULL Platform UserId of the user who created the object.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

LastUpdated TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreationDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

X INTEGER NULL X coordinate of the annotation location in flowchart. Note: Even though it is saved it is not used currently. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Y INTEGER NULL Y coordinate of the annotation location in flowchart. Note: Even though it is saved it is not used currently. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

IsVisible INTEGER NULL Visibility flag for the annotation.

Valid Values: 0 and 1

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Content VARCHAR NULL User entered annotation content (text)

Valid Values: Any text characters minus standard disallowed special characters in text.

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

UA_CampAttribute

This table stores the values of the campaign custom attributes for each campaign.

Table 10. UA_CampAttribute field descriptions
Field Name Type Null? Description Length Additional Attributes
CampaignID BIGINT NOT NULL The CampaignID of the campaign for whom this attribute value is associated.

Valid Values: Any valid CampaignID in UA_Campaign table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

AttributeID BIGINT NOT NULL The AttributeID of the campaign attribute whose value is being stored

Valid Values: Any valid AttributeID in UA_AttributeDef table where ObjectType = campaign

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

StringValue VARCHAR NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberValue DOUBLE NULL

Valid Values: Valid numeric value

53 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DatetimeValue TIMESTAMP NULL

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

Table 11. UA_CampAttribute parent tables
Table name Description
UA_Campaign This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_CampToCellAttr

This table is a mapping of cell custom attributes to Campaign. The AttributeIDs in that table are all of the cell attributes. This table is populated only in campaigns created in HCL Plan.

Table 12. UA_CampToCellAttr field descriptions
Field Name Type Null? Description Length Additional Attributes
CampaignID BIGINT NOT NULL CampaignID for the campaign that is associated with the AttributeID.

Valid Values: Any valid CampaignID in UA_Campaign table where CreatorFlag = 1

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

AttributeID BIGINT NOT NULL AttributeID for the cell attribute that is associated with the campaignID. (These relationships are defined by the campaign project template created in HCL Plan.)

Valid Values: Any valid AttributeID in UA_AttributeDef table where ObjectType = cell

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Table 13. UA_CampToCellAttr parent tables
Table name Description
UA_Campaign This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_CampToOffer

This table stores top-down defined relationships between a campaign and its related offers (specified by the user from the Campaign summary page by clicking on "Add/Remove Offers" link). This can be a many-to-many mapping. Bottom-up offers (offers used in a flowchart of the campaign) are not stored in this table.

Table 14. UA_CampToOffer field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferID BIGINT NOT NULL OfferID for the offer that is associated with the campaignID. User selects offers or offer lists from the offer tree hierarchy. Campaign resolves any offer lists or offer names to OfferIDs and stores these automatically. Retired offers cannot be selected, but if an offer is subsequently retired after association with a campaign, it will be displayed with a "(retired)" indicator.

Valid Values: Any valid OfferID value in UA_Offer

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CampaignID BIGINT NOT NULL CampaignID for the campaign that is associated with the OfferID. This is always the ID of the current campaign (the one who's campaign summary page is used to access "Add/Remove Offers" link).

Valid Values: Any valid CampaignID from the UA_Campaign table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 15. UA_CampToOffer parent tables
Table name Description
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.
UA_Campaign This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.

UA_CampToSegment

This table stores top-down defined relationships between a campaign and its related segments (specified by the user from the Campaign summary page by clicking on "Add/Remove Segments" link). This can be a many-to-many mapping. Bottom-up segments (strategic segments used in a flowchart of the campaign) are not stored in this table.

Table 16. UA_CampToSegment field descriptions
Field Name Type Null? Description Length Additional Attributes
CampaignID BIGINT NOT NULL CampaignID for the campaign that is associated with the SegmentID. This is always the ID of the current campaign (the one who's campaign summary page is used to access "Add/Remove Segments" link).

Valid Values: Any valid CampaignID from the UA_Campaign table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

SegmentID BIGINT NOT NULL SegmentID for the strategic segment that is associated with the CampaignID. User selects segments from the segment tree hierarchy. AC stores the SegmentIDs for these automatically. **Inactive segments (ActiveFlag = 0) cannot be selected. Any inactive segment no longer appears on the campaign summary page of any campaign to which it was associated.

Valid Values: Any valid SegmentID from the UA_Segment table

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 17. UA_CampToSegment parent tables
Table name Description
UA_Campaign This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.

UA_CCRunLog

This table logs each time a flowchart is run in production (not populated by test runs), providing a flowchart run history. A unique RunID is generated on each new flowchart run (but not for run branch/process). It records the start/end datetime and who ran the flowchart.

Table 18. UA_CCRunLog field descriptions
Field Name Type Null? Description Length Additional Attributes
RunID BIGINT NOT NULL Globally unique identifier generated every time a flowchart is run (generated from IDsbyType) for batch flowcharts. Incremented for saved change for interactive flowcharts.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

FlowchartID BIGINT NOT NULL The flowchart ID that is or has been run.

Valid Values: A valid value from UA_Flowchart table.

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

RemoteUserName VARCHAR NULL

Valid Values: Any valid user name from Unica Platform **If user name is subsequently changed in Platform, this value may not exist in Unica Platform or may reference an incorrect user.

32 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

LocalUserName VARCHAR NULL Username of the OS user (configured static user) that was used to run the flowchart 32 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

RunStartTime TIMESTAMP NULL System date that the flowchart run was started.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

RunEndTime TIMESTAMP NULL System date that the flowchart run stopped.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

RunStatus VARCHAR NULL Status of the flowchart run. "Run Succeeded" means the flowchart completed without any errors, "Run Failed" means that the flowchart completed with one or more errors, "Running" indicates the flowchart is currently running, and "Inactive" means the flowchart has never been run.

Valid Values: "Run Succeeded", "Run Failed", "Running", "Inactive"

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

RunBy BIGINT NULL Unica Platform user ID for the user who ran the flowchart.

Valid Values: Valid UserID in Platform **Value may be invalid if Platform user is subsequently deleted.

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

RunType INTEGER NOT NULL Foreign key ID for a Campaign session run type

Valid Values: A valid value from the UA_SesnRunType table.

10 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Table 19. UA_CCRunLog parent tables
Table name Description
UA_SesnRunType This enumerates the Campaign session run types.
Table 20. UA_CCRunLog child tables
Table name Description
UA_Treatment Stores all treatments (intersection of offer versions to target cells at a point in time (run instance) and related data. If multiple offers are assigned to a cell, there are multiple rows in the treatment table (one treatment for each offer version given to the cell). If offer personalization is used, a treatment is created for each unique permutation of offer attributes (offer version) used (and HasDetailHistory=1 and contact information is stored in a separate table, UA_DtlContactHistory). This data is populated during a production run of a CSP only when logging is enabled.
UA_RunResult

UA_CellAttribute

This table stores the custom cell attribute values for a particular cell. These values are data-entered by the user in the Target Cell Spreadsheet (TCS). Only one of the fields (StringValue, NumberValue, DatetimeValue) is populated for any given row, depending on the data type of the custom attribute (as specified in UA_AttributeDef). Attributes are displayed in the target cell spreadsheet in AttributeID order.

Table 21. UA_CellAttribute field descriptions
Field Name Type Null? Description Length Additional Attributes
AttributeID BIGINT NOT NULL The AttributeID for the custom cell attribute for which a value is entered for a particular cell (specified by CellID). UA_AttributeDef.ObjectType must = 11 (TargetCell) for all AttributeIDs in this table.

Valid Values: Valid AttributeID in UA_AttributeDef

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CellID BIGINT NOT NULL The cell ID for which the attribute ID is being stored.

Valid Values: Valid CellID value from UA_TargetCells

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

StringValue VARCHAR NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberValue DOUBLE NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid numeric value

53 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DatetimeValue TIMESTAMP NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

Table 22. UA_CellAttribute parent tables
Table name Description
UA_TargetCells This table stores information on target cells created in all flowcharts. Target cells are defined as cells that are attached to an output process (Mail List, Call List, Recommend, Deliver, Snapshot, or Optimize). It stores meta data information (name, code), source info (campaign, flowchart and cell IDs), treatment data (list of assigned offers/offer lists and whether it is a control cell), and whether the cell was created top-down in the Target Cell Spreadsheet (TCS) or bottom-up from within a flowchart.
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_ContactHistory

User-created table that stores the required contact fields (AudienceID, CellID, PackageID, ContactDateTime, ContactStatusID, and so forth) plus any user-defined additionally tracked fields. There is a separate table for each audience level. Rows in this table are written if the CSP logging table has "Log to contact history tables" enabled. This table captures cell membership information and identifies cells treated in the same CSP by packageID (all contacts made to the same audience entity in the same CSP is part of the same "package", which represents an interruption). Both target cells and hold-out controls are written to contact history (CH). Existing entries in this table can be updated (ContactStatus, UpdateDateTime, and user-defined fields) using the Track process. The Track process cannot create new rows in this table. This table is required for tracking contacts. This is also used by Unica Optimize (ACO) for applying optimization to contacts. This "base" contact history table is populated simultaneously with the UA_Treatment, UA_OfferHistory, and UA_OfferHistAttrib tables (together all of these tables make up "contact history"). None of these tables are written if log to contact history is not enabled in a CSP.

Table 23. UA_ContactHistory field descriptions
Field Name Type Null? Description Length Additional Attributes
CustomerID BIGINT NOT NULL This field represents the audience level (which may comprise one or more fields). These fields are automatically output based on the current incoming audience level of the input cell(s).

Valid Values: Any valid audience ID

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

CellID BIGINT NOT NULL UC automatically populates the CellID of the incoming cell in which the audienceID belongs. If the same audienceID is a member of multiple cells, that audienceID has one row in this table for each cell in which they are a member.

Valid Values: Any valid CellID in UA_TargetCells

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

PackageID BIGINT NOT NULL This is a globally unique ID that ties together multiple cells treated in the same CSP and represents the concept of a package (or interruption). It is up to the user to ensure all offers used in a single CSP are on the same channel (no enforcement); otherwise PackageID doesn't correctly represent "interruptions" to the audience ID. PackageID is based on ProcessID and RunID. A new package ID is generated for each flowchart run, branch run or process run. The package ID does not change for a test flowchart run, test branch run or test process run.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

ContactDateTime TIMESTAMP NULL The datetime when the communication is expected to reach the audience ID (e.g., the in-home date for direct mail). The default value is the CSP run datetime, but this value can be set by the user in the CSP (Contact Date field under "More Options" on Logging tab). It is a constant value for all offers given in a single CSP (as it must represent a single interruption).

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

UpdateDateTime TIMESTAMP NULL This field contains the most recent datetime that this row was updated by the Track process (typically to update the ContactStatusID); same as CreateDateTime for initial row creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? Yes

Configuration? Yes

ContactStatusID BIGINT NULL The ContactStatusID value indicates the status of the contact for the audience ID. Contact statuses are customizable by the implementation, and default values are shipped in the UA_ContactStatus table. The default contact status (one value for all CSP types) is specified by UA_ContactStatus.IsDefault =1.

Valid Values: Valid ContactStatusID in UA_ContactStatus table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? No

Stored Save? Yes

Stored Execute? Yes

Configuration? Yes

DateID BIGINT NULL Date ID representing the date information from the UA_Calender table.

Valid Values: Valid DateID from UA_Date table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

TimeID BIGINT NULL Time ID information from the UA_Time table

Valid Values: Valid TimeID from the UA_Time table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

UserDefinedFields CHAR NULL This is a placeholder for one or more user-defined columns in this table (additionally tracked fields). These fields can be populated from a CSP or Track process using "More Options" on the logging tab.

Valid Values: Any value accepted by the DB based on data type

18 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? No

Stored Save? Yes

Stored Execute? Yes

Configuration? No

ValueBefore BIGINT NULL Additional field used for CH-RH tracking and reports

Valid Values: According to the datataype

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

UsageBefore BIGINT NULL Additional field used for CH-RH tracking and reports

Valid Values: According to the data type

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

Table 24. UA_ContactHistory parent tables
Table name Description
UA_Time This table holds time information identifying information about the hours and minutes for a particular time. It is used to faciliate reporting. This table must be populated as part of the implementation setup.
UA_ContactStatus This table contains the valid contact statuses (defined at implementation time) that can be used to log to contact history. There must be one row designated as the default contact status (Defaults = 1). There is no GUI for creating, viewing, or updating contact statuses. These must be maintained directly in the system table.
UA_Calendar This table holds calendar information identifying information about calendar quarters, days of the week, first and last days of the week, etc. It is used to facilitate reporting over time. It is expected that this table will be customized by customers during implementation. It is the responsibility of the implementation to ensure that dates referenced in Contact history are contained in the time span covered by this table.

UA_ContactStatus

This table contains the valid contact statuses (defined at implementation time) that can be used to log to contact history. There must be one row designated as the default contact status (IsDefault = 1). There is no GUI for creating, viewing, or updating contact statuses. These must be maintained directly in the system table.

Table 25. UA_ContactStatus field descriptions
Field Name Type Null? Description Length Additional Attributes
ContactStatusID BIGINT NOT NULL System-generated unique ID representing the contact status.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Name VARCHAR NULL User-provided unique name identifying the contact status.

Valid Values: Any text characters, minus standard disallowed special name characters. The following values are pre-defined (additional values can be added): Campaign Send, Delivered, Undelivered, Control.

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Description VARCHAR NULL Optional descriptive text describing the contact status. **Not currently used/displayed anywhere to the end-user

Valid Values: Any text characters minus standard disallowed special characters in text

512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

ContactStatusCode VARCHAR NULL Code that can be used for entering a contact status value in a CSP or Track process. The best practice would be to have all unique status codes.

Valid Values: Any valid string (best practice is to use only A-Z and 0-9). The following values are pre-defined (additional values can be added): CSD, DLV, UNDLV, CTRL. These values correspond to the pre-defined response types in the Name field (CSD=Campaign Send, DLV=Delivered, UNDLV=Undelivered, CTRL=Control).

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

CountsAsContact INTEGER NULL Specifies whether this contact status counts as a contact to the recipient; used for reporting and by Unica Optimize to manage contact fatigue.

Valid Values: 0=Does NOT count as a successful contact. 1=Counts as a successful contact.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Defaults INTEGER NULL Exactly one row in the UA_ContactStatus table must have a value of 1 and exactly one row must have a value of 2 (for controls). The rest must have values of 0. The row with value 1 is used as the default contact status written by CSPs and the Track process (can be user overridden). The row with value 2 is used as the default contact status for controls.

Valid Values: 0 = not default, 1 = default, 2 = default contact status for controls

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

Table 26. UA_ContactStatus child tables
Table name Description
UA_ContactHistory User-created table that stores the required contact fields (AudienceID, CellID, PackageID, ContactDateTime, ContactStatusID, and so forth) plus any user-defined additionally tracked fields. There is a separate table for each audience level. Rows in this table are written if the CSP logging table has "Log to contact history tables" enabled. This table captures cell membership information and identifies cells treated in the same CSP by packageID (all contacts made to the same audience entity in the same CSP is part of the same "package", which represents an interruption). Both target cells and hold-out controls are written to contact history (CH). Existing entries in this table can be updated (ContactStatus, UpdateDateTime, and user-defined fields) using the Track process. The Track process cannot create new rows in this table. This table is required for tracking contacts. This is also used by Unica Optimize (ACO) for applying optimization to contacts. This "base" contact history table is populated simultaneously with the UA_Treatment, UA_OfferHistory, and UA_OfferHistAttrib tables (together all of these tables make up "contact history"). None of these tables are written if log to contact history is not enabled in a CSP.
UA_DtlContactHist This table stores exactly which audience IDs received which offer versions in the offer personalization (sub-cell) case where not all individuals in the same cell receive exactly the same offers. They may receive a different # of offers and/or different offer versions. This table has rows written to it only when UA_Treatment.HasDetailHistory = 1.

UA_CustomMacros

This table stores custom macros for reuse across users and flowcharts. It stores the query name, query (which can be raw SQL or Campaign macro language) and description. The custom macro can take input parameters and return a data value with each audience ID.

Table 27. UA_CustomMacros field descriptions
Field Name Type Null? Description Length Additional Attributes
FolderID BIGINT NOT NULL Folder ID for the folder where the custom macro is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Name VARCHAR NOT NULL Name of the macro; must be globally unique. If the custom macro requires input parameters, they must be comma-separated and listed inside parentheses. E.g., "MySumGroupBy(id, table, field)"

Valid Values: Any text characters, minus standard disallowed special name characters for Campaign expression names

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional description of custom macro in the first row of a specific derived field; contains an index number (2-n) only when the predicateexpr exceeds the field length and is stored across multiple rows.

Valid Values: Any text characters minus standard disallowed special characters in text OR number 2 through N

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Expression VARCHAR NULL Text representing the macro expression. Variable names must be enclosed in angle brackets. E.g., "Select <id>, sum(<field>) from table <table> group by <id>"

Valid Values: Any valid SQL or Unica language expression

2000 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ExpressionType INTEGER NULL Type of expression (specified by the user when creating the custom macro). The expression can be an Unica language expression that returns a list of audience IDs to be match-merged, a raw SQL expression returning an ID list, a raw SQL expression that returns paired IDs and a value (text or numeric), or a raw SQL fragment (just pasted in as text substitution).

Valid Values: 0=Affinium, 1=SQL List, 2=SQL Value

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DataSrcName VARCHAR NULL Name of datasource. This field is not populated if you are using an "Affinium" (Campaign) expression type. Configured data source names are displayed to the user for selection.

Valid Values: dbconfig.lis was used in AC 5.x, AC 6.x. Please remove the word dbconfig.lis and say "Valid data source name."

255 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DataVarType INTEGER NULL Whether a returned data value in a raw SQL expression is a numeric or string data type. Required if ExpressionType = 2.

Valid Values: 7=Numeric, 8=Text

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DataVarNBytes INTEGER NULL The length of the returned data value in bytes. Required if ExpressionType = 2.

Valid Values: Positive integer

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Date and time when the custom macro is created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Unica Platform UserId of the user who created the macro.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Unica Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Unica Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Marketing Platform's usm_role table

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

Table 28. UA_CustomMacros parent tables
Table name Description
UA_Folder This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).

UA_DerivedField

This table stores derived fields for reuse across users and flowcharts. It stores the name, definition, and description. New derived fields created within the campaign are stored in this table by using the Create Derived Field window. Long predicate expressions may span multiple rows using the Description field as a numeric index to stitch together the multiple rows.

Table 29. UA_DerivedField field descriptions
Field Name Type Null? Description Length Additional Attributes
FolderID BIGINT NOT NULL Folder ID for the folder where the object is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Name VARCHAR NOT NULL Name of the derived field; must be unique within the folder in which it is stored.

Valid Values: Any text characters, minus standard disallowed special name characters for Campaign expression names.

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional description of derived field in the first row of a specific derived field; contains an index number (2-n) only when the predicateexpr exceeds the field length and is stored across multiple rows.

Valid Values: Any text characters minus standard disallowed special characters in text OR number 2 through N

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

predicateexpr VARCHAR NULL The Campaign language expression definition of the derived field.

Valid Values: Allowed characters in Campaign macro expressions.

2000 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Date and time when the derived field is created

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Unica Platform UserID of the user who created the derived field.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Marketing Platform's usm_role table.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

Table 30. UA_DerivedField parent tables
Table name Description
UA_Folder This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).

UA_DtlContactHist

This table stores exactly which audience IDs received which offer versions in the offer personalization (sub-cell) case where not all individuals in the same cell receive exactly the same offers. They may receive a different # of offers and/or different offer versions. This table has rows written to it only when UA_Treatment.HasDetailHistory = 1.

Table 31. UA_DtlContactHist field descriptions
Field Name Type Null? Description Length Additional Attributes
CustomerID BIGINT NOT NULL This field represents the audience level (which may comprise one or more fields). These fields are automatically output based on the current incoming audience level of the input cell(s).

Valid Values: Any valid audience ID

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

TreatmentInstID BIGINT NOT NULL Treatment instance ID identifying the specific offer and run instance use for offer personalization. (Offer versions are no longer supported since 7.x)

Valid Values: Any valid TreatmentInstID in UA_Treatment table

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

ContactStatusID BIGINT NULL The ContactStatusID value indicates the status of the contact for the audience ID. Contact statuses are customizable by the implementation, though default values are shipped in the UA_ContactStatus table. **The default contact status (one value for all CSP types) is specified by UA_ContactStatus.Defaults=1.

Valid Values: Valid ContactStatusID in UA_ContactStatus table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? No

Stored Save? Yes

Stored Execute? Yes

Configuration? Yes

ContactDateTime TIMESTAMP NULL This field represents the datetime when the communication is expected to reach the audience ID (e.g., the in-home date for direct mail). The default value is the CSP run datetime, but this value can be set by the user in the CSP (Contact Date field under "More Options" button on Logging tab). It is a constant value for all offers given in a single CSP (as it must represent a single interruption).

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

UpdateDateTime TIMESTAMP NULL This field contains the most recent datetime that this row was updated by the Track process (typically to update the ContactStatusID); same as CreateDateTime for initial row creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? Yes

Configuration? Yes

UserDefinedFields CHAR NULL This is a placeholder for one or more user-defined columns in this table (additionally tracked fields). These fields can be populated from a CSP or Track process using the "More Options" button on the logging tab.

Valid Values: Any value accepted by the DB based on data type

18 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? No

Stored Save? Yes

Stored Execute? Yes

Configuration? No

DateID BIGINT NOT NULL Date ID representing the date information from the UA_Calendar table

Valid Values: Valid DateID from UA_Calendar table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

TimeID BIGINT NOT NULL Time ID information from the UA_Time table

Valid Values: Valid TimeID from the UA_Time table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

ValueBefore BIGINT NULL Additional field used for CH-RH tracking and reports

Valid Values: According to the data type

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

UsageBefore BIGINT NULL Additional field used for CH-RH tracking and reports

Valid Values: Accoring to the data type

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

OfferListID Bigint NULL

For unica Interact only, unique identifier for the offer list if the offer being contacted originated from an offer list.

Valid Values: valid offer list IDs

Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

ABTestBranchID Bigint NULL

For Unica Interact only, unique identifier for an A/B Testing branch

If the offer being contacted originated from an A/B Testing, this is the ID of the A/B testing branch.

Valid Values: valid BranchID values in UACI_ABTestBranch table

Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

Table 32. UA_DtlContactHist parent tables
Table name Description
UA_Time This table holds time information identifying information about the hours and minutes for a particular time. It is used to faciliate reporting. This table must be populated as part of the implementation setup.
UA_ContactStatus This table contains the valid contact statuses (defined at implementation time) that can be used to log to contact history. There must be one row designated as the default contact status (IsDefault = 1). There is no GUI for creating, viewing, or updating contact statuses. These must be maintained directly in the system table.
UA_Calendar This table holds calendar information identifying information about calendar quarters, days of the week, first and last days of the week, etc. It is used to facilitate reporting over time. It is expected that this table will be customized by customers during implementation. It is the responsibility of the implementation to ensure that dates referenced in Contact history are contained in the time span covered by this table.

UA_EnumAttrValues

This table holds all the drop-down list (enumerated) data values for custom attributes where UA_AttributeDef.EnumType = 1 or 2.

Table 33. UA_EnumAttrValues field descriptions
Field Name Type Null? Description Length Additional Attributes
AttributeID BIGINT NOT NULL The AttributeID to which the value belongs.

Valid Values: Any valid AttributeID in UA_AttributeDef

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Description VARCHAR NULL It is not updated from any UI action and does not have any valid values. 512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? NO

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

StringValue VARCHAR NULL Only one of these 3 fields, StringValue, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue. 1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberValue DOUBLE NULL Only one of these 3 fields, StringValue, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid numeric value

53 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DatetimeValue TIMESTAMP NULL Only one of these 3 fields, StringValue, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

isDefault INTEGER NULL Flag indicates if the value is a default value for attribue of type Single Select

Valid Values: 0,1

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 34. UA_EnumAttrValues parent tables
Table name Description
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_Flowchart

This table stores information for all flowcharts. It has one row for each flowchart in the system and is also used for reporting on the running flowcharts (status) in the system.

Table 35. UA_Flowchart field descriptions
Field Name Type Null? Description Length Additional Attributes
FlowchartID BIGINT NOT NULL Unique identifier of the flowchart. This ID is assigned by the system when a flowchart is created.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil)

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

TempFlag INTEGER NOT NULL

A temporary row with TempFlag=1 is added in this table when the flowchart is in the edit mode.

Valid Values: 0 = permanent row, 1 = temporary row created during flowchart edit
10 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

Name VARCHAR NULL Name of flowchart; must be unique within the campaign

Valid Values: Any text characters, minus standard disallowed special name characters

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional description of the flowchart.

Valid Values: Any text characters minus standard disallowed special characters in text

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

SessionID BIGINT NULL Session ID for the session that this flowchart is associated with; this is only populated if the flowchart is part of a session (only SessionID or CampaignID will be populated for a single row, not both).

Valid Values: Valid SessionID from UA_Session table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

FlowchartType VARCHAR NULL The type of flowchart (batch or real-time). "Event Processing" is an Interactive flowchart and is available only as an option when creating a flowchart only if Unica Campaign Interact is installed.

Valid Values: "Batch", "Event Processing"

32 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Status VARCHAR NULL Status of the flowchart. This specifies the current state of the flowchart, if it is running (Running), ran and succeeded without any errors (Run Succeeded), ran and completed with error(s) (Run Failed), is waiting to run (Schedule process waiting) (Run Pending), was paused during a run (Run Paused), or is not running (Inactive).

Valid Values: "Run Succeeded", "Run Failed", "Running", "Run Pending", "Run Paused", "Inactive"

16 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Platform UserId of the user who created the flowchart.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

LastRunStartDate TIMESTAMP NULL Server date and time of the last time a run for this flowchart was started.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

LastRunEndDate TIMESTAMP NULL Server date and time of the last time a run for this flowchart ended. This value is NULL if never run.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

RunBy INTEGER NULL Platform user ID for the user who last run this flowchart. This value is NULL if never run.

Valid Values: Valid UserID in Platform **Value may be invalid if Platform user is subsequently deleted.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? Yes

FileName VARCHAR NULL Name of the server binary file containing flowchart configuration.

Valid Values: Valid filename for operating system

255 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DataSources VARCHAR NULL List of all datasources used in the flowchart. Each datasource is separated by a comma (e.g., "datasource1, datasource2, datasource3"). This list is used to obtain valid logins to each data source when opening or running a flowchart. For example, when a user runs a campaign (all flowcharts), the list for each flowchart can be merged, de-duped and logins prompted for if not available from the user's Platform profile.

Valid Values: Valid data sources (dbconfig.lis is obsolete since 6.x).

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CampaignID BIGINT NULL Campaign ID for the campaign that this flowchart is associated with; this is only populated if the flowchart is part of a campaign (only SessionID or CampaignID will be populated for a single row, not both).

Valid Values: Valid Campaign ID from UA_Campaign table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Marketing Platform's usm_roletable.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

Table 36. UA_Flowchart parent tables
Table name Description
UA_Session Stores information about sessions created in Campaign.
UA_Campaign This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.

UA_FlowchartSeg

This table contains all of the relationships between segments and flowcharts. It will define when a segment is created by a flowchart and/or when a segment is simply reference by the flowchart. By having this table we can ensure that FK relationships are enforced at the DB level.

Table 37. UA_FlowchartSeg field descriptions
Field Name Type Null? Description Length Additional Attributes
SegmentID BIGINT NOT NULL Unique identifier of segment. This ID is assigned by the system when a segment is created.

Valid Values: Any valid SegmentID from UA_Segment

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

FlowchartID BIGINT NOT NULL The flowchart ID that references a particular segment.

Valid Values: Any valid FlowchartID in UA_Flowchart table

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

RefType INTEGER NOT NULL RefType ties the UA_FlowchartSeg table to the UA_SegRefType table. This column defines how the flowchart references the segment. As an example, some flowcharts are the creators of segments, while others use existing segments. Batch flowcharts always have the value 1 (creator). Unless you have Interact incorporated in your environment, the value will never be 2 (referencer) for batch flowcharts. A value of 2 is used only for Interactive flowcharts. A value of 3 used only when segment used in flowchart.

Valid Values: Any valid RefType from UA_SegRefType (for consistency).

10 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

ProcessID BIGINT NOT NULL ProcessID stores the Process Box ID in which respective segment used.

Valid Values:0 with RefType 1 or 2 And any valid Process box id with RefType 3.

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Table 38. UA_FlowchartSeg parent tables
Table name Description
UA_SegRefType A lookup table that is prepoluated with the valid references types.
UA_Segment This table stores information on the strategic/smart segments created by the CreateSeg/PopulateSeg process. It is populated when a CreateSeg process is created and saved in a flowchart and subsequently updated when the CreateSeg process is run.

UA_FlowchartTmpl

This table stores meta data for flowchart templates. It is populated when a user chooses Tools->Stored Templates from the flowchart menu.

Table 39. UA_FlowchartTmpl field descriptions
Field Name Type Null? Description Length Additional Attributes
FolderID BIGINT NOT NULL Folder ID for the folder where the object is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NOT NULL Name of the flowchart template; must be unique within the folder in which it is stored.

Valid Values: Any text characters, minus standard disallowed special name characters

64 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional, free-form description of the flowchart template.

Valid Values: Any text characters minus standard disallowed special characters in text

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

FileName VARCHAR NULL Name of the server binary file containing the flowchart template (e.g., MyTemplate.tpl)

Valid Values: Valid filename for operating system

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Platform user ID for the user who created the object.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Marketing Platform's usm_role table

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL Reserved for future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

Table 40. UA_FlowchartTmpl parent tables
Table name Description
UA_Folder This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).

UA_Folder

This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).

Table 41. UA_Folder field descriptions
Field Name Type Null? Description Length Additional Attributes
FolderID BIGINT NOT NULL Unique identifier of the folder. This ID is assigned by the system when a new folder is created. Folder IDs start at either 100 or the value of internalIDLowerLimit config parameter, whichever is higher.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil)

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NULL Name of the folder; must be unique within the parent folder.

Valid Values: Any text characters, minus standard disallowed special name characters

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional description of the folder.

Valid Values: Any text characters minus standard disallowed special characters in text

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ParentFolderID BIGINT NULL FolderID of the parent folder. This field is used to trace backwards to get the absolute path name of the current folder. Only the top-level folder should have a NULL in this field. User chooses the parent folder when creating a folder.

Valid Values: Any valid FolderID from UA_Folder table

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ObjectType INTEGER NULL Type of system object stored in this folder.

Valid Values: 1=Session, 2=Campaign, 3=Segment, 4=Offer, 7=ACOSession, 8=CustomMacro, 9=DerivedField, 10=Trigger, 17=Table Catalog, 18=Flowchart Template

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Platform UserID of the user who created the folder

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Unica Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Marketing PLatform's usm_role table.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

creatorFlag INTEGER NULL Used when Unica Campaign-Unica Plan offer integration is enabled. Flag indicates whether Offer is created by Unica Campaign or Unica Plan.

Valid Values: 0,1,2,3

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

creatorObjectId BIGINT NULL Used in Unica Campaign-Unica Plan offer integration. Field is used by Plan to associate the Campaign folder and the Plan folder object.

Valid Values: Long

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 42. UA_Folder child tables
Table name Description
UA_Campaign This table contains campaign metadata provided by the user and basic run information. One row is written this table each time a new campaign is created and saved. Related tables (UA_CampToSegment, UA_CampToOffer, and UA_Flowchart) are not updated until those relationships/links or objects are created. That is, a UA_Flowchart record is created only when a new flowchart is added to the campaign. The UA_CampaignExtAttr is populated at the same time with any campaign custom attribute values.
UA_CustomMacros This table stores custom macros for reuse across users and flowcharts. It stores the query name, query (which can be raw SQL or HCL Campaign macro language) and description. The custom macro can take input parameters and return a data value with each audience ID.
UA_DerivedField This table stores derived fields for reuse across users and flowcharts. It stores the name, definition, and description. New derived fields created within the campaign are stored in this table by using the Create Derived Field window. Long predicate expressions may span multiple rows using the Description field as a numeric index to stitch together the multiple rows.
UA_FlowchartTmpl This table stores meta data for flowchart templates. It is populated when a user chooses all or some process boxes of a flowchart, right clicks and selects 'Copy to template library'. In doing this, the flowchart logic gets saved which can be reused in some other flowchart.
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.
UA_OfferList This table stores both internal and user-created offer lists. User-created offer lists can be static (fixed list of offers) or smart (dynamic; based on a query). Internally generated offer lists are used to group together the actual list of offers assigned to a specific cell in a CSP when multiple offers are assigned. Internal offer lists may reference user-created offer lists (only one level of nesting supported).
UA_Segment This table stores information on the strategic segments created by the Create Seg process. It is populated when a CreateSeg process is created and saved in a flowchart and subsequently updated when the CreateSeg process is run. A temporary copy of the row is created (with TempFlag=1) when the flowchart containing the CreateSeg process box is being edited or run.
UA_Session Stores information on sessions created in Unica Campaign.
UA_TableCatalog This table stores information on all table catalogs available in Unica Campaign.
UA_Triggerlist This table stores a name, definition, and note for each outbound trigger sent through the Schedule and Contact processes. A trigger executes a command line, which can be a batch file or a script.
UACO_OptSession An entry in this table represents a single Optimize session with all of its metadata.

UA_IDSByType

This table contains the next valid ID for various object types (for the Primary key to be used for a new row to be inserted in each table in the Unica Campaign system). These are used by the system to generate globally unique IDs in the system and prevent the need for uniqueness checking. This table maintains a counter for each type of the object (table). Every time a new row is created, the current value of the counter is used for the primary key, and the counter is incremented.

Table 43. UA_IDSByType field descriptions
Field Name Type Null? Description Length Additional Attributes
TypeID BIGINT NOT NULL Unique identifier for the specific type of object.

Valid Values: 0-49 as defined here: ID_Unica CampaignID=0, ID_ChannelID=1, ID_CreativeID=2, ID_CubeID=3, ID_FlowchartID=4, ID_FolderID=5, ID_OfferID=6, ID_OfferTrackID=7, ID_ResponseID=8, ID_SegmentID=9, ID_SessionID=10, ID_ACOSessionID=11, ID_OptimizeID=12, ID_ContactTrackID=13, ID_ResponseTrackID=14, ID_OfferGroupID=15, ID_OfferHistoryID=16, ID_RunID=17, ID_TreatmentID=18, ID_TargetCellID=19, ID_OfferTemplateID=20, ID_RuleID=21, ID_OfferListId=22, ID_AttributeDef=23, ID_ResponseTypeID=24, ID_ContactStatusID=25, ID_PackageID=26, ID_ResponsePackID=27, ID_CriteriaID=28, ID_OfferListResolveID=29, ID_EmsgOutputList=30, ID_ACI_RuleGroupID=31, ID_ACI_RuleID=32, ID_ACI_DeploymentID=33, ID_ACI_CategoryID=34, ID_ACI_MessageID=35, ID_ACI_InteractionPointID =36, ID_ACI_ZoneID=37, ID_ACI_ InteractiveChannelID =38, ID_ACI_StrategyID=39, ID_ACI_PredicateID=40, ID_EmsgPFMappingID=41, ID_EmsgPFUseID=42, ID_TmpTableID=43, ID_ExRuleID=44, ID_ACI_ConstraintID=45, ID_ACI_LearningModelID =46, ID_ACI_ LearningModelAttrID =47, ID_ACI_DepVersionID=48, ID_ACI_EventActionID=49

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

NextID BIGINT NULL Next available ID for the object.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? Yes

UA_Initiatives

Holds names of marketing initiatives (populates Initiative field in the Campaign Summary page). The table is empty by default, if needed, user must manually insert value in this table.

Table 44. UA_Initiatives field descriptions
Field Name Type Null? Description Length Additional Attributes
InitiativeName VARCHAR NOT NULL Name of the initiative; must be unique. **There is currently no GUI to enter these values.

Valid Values: Any text characters minus standard disallowed special characters in text

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? Yes

UA_Offer

This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.

Table 45. UA_Offer field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferID BIGINT NOT NULL Unique identifier of the offer. This ID is assigned by the system when a new offer is created.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NOT NULL Name of the offer; does not have to be unique.

Valid Values: Any text characters, minus standard disallowed special name characters

130 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional description of offer.

Valid Values: Any text characters minus standard disallowed special characters in text

512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Platform UserID of the user who created the Offer.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberOfOfferCodes INTEGER NULL This field specifies the number of parts in the offer code (up to a maximum of 5). The OfferCodeX fields are populated where X <= this value (e.g., if the NumberOfOfferCodes = 2, then OfferCode1 and OfferCode2 fields will be populated; the remaining offer codes 3-5 will be NULL). The offer code (all N parts) should be globally unique, though any individual part is not guaranteed to be unique. **There is no enforcement of global uniqueness on save (it is possible to have duplicate offer codes if users override these values).

Valid Values: A whole number between 1-5

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

OfferCode1 VARCHAR NOT NULL This is the first part of the offer code and is always populated. A value is initially generated by the system matching the specified offer code format defined in UA_OfferTemplate.OfferCode 1CodeFrmt. Users may override this value only if they have the "Regenerate Offer Codes" permission for this offer.

Valid Values: Valid string according to UA_OfferTemplate.OfferCode 1CodeFrmt

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode2 VARCHAR NULL This is the second part of the offer code and is populated if NumberOfOfferCodes >=2. A value is initially generated by the system matching the specified offer code format defined in UA_OfferTemplate.OfferCode 2CodeFrmt. The user may override this value only if they have the "Regenerate Offer Codes" permission for this offer.

Valid Values: Valid string according to UA_OfferTemplate.OfferCode 2CodeFrmt

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode3 VARCHAR NULL This is the third part of the offer code and is populated if NumberOfOfferCodes >=3. A value is initially generated by the system matching the specified offer code format defined in UA_OfferTemplate.OfferCode 3CodeFrmt. The user may override this value only if they have the "Regenerate Offer Codes" permission for this offer.

Valid Values: Valid string according to UA_OfferTemplate.OfferCode 3CodeFrmt

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode4 VARCHAR NULL This is the fourth part of the offer code and is populated if NumberOfOfferCodes >=4. A value is initially generated by the system matching the specified offer code format defined in UA_OfferTemplate.OfferCode 4CodeFrmt. The user may override this value only if they have the "Regenerate Offer Codes" permission for this offer.

Valid Values: Valid string according to UA_OfferTemplate.OfferCode 4CodeFrmt

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode5 VARCHAR NULL This is the fifth part of the offer code and is populated if NumberOfOfferCodes =5. A value is initially generated by the system matching the specified offer code format defined in UA_OfferTemplate.OfferCode 5CodeFrmt. The user may override this value only if they have the "Regenerate Offer Codes" permission for this offer.

Valid Values: Valid string according to UA_OfferTemplate.OfferCode 5CodeFrmt

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferTemplID BIGINT NULL The OfferTemplID of the offer template used to generate this offer (chosen by the user when creating the offer). This value cannot be changed once the offer has been created.

Valid Values: Valid OfferTemplID value from UA_OfferTemplate table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Retired INTEGER NULL Specifies whether an offer has been "retired," which means it can no longer be given out in any campaigns/flowcharts. Newly created offers are not retired by default. Retired offers do not appear for selection when assigning offers. The user can choose to retire an offer at any time. Offers that cannot be deleted are automatically retired instead. **There is no way in the GUI to "unretire" an offer.

Valid Values: 0=active; 1=retired

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

FolderID BIGINT NULL Folder ID for the folder where the object is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

EffectiveDateFlag INTEGER NULL Specifies whether the first date when this offer will be valid is based on an absolute date or whether it will be the flowchart run date.

Valid Values: 0=Absolute date, 1=Flowchart run date

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

ExpirationDateFlag INTEGER NULL Specifies whether the last date when this offer will be valid is based on an absolute date or whether it will be some duration (# of days) after the effective date.

Valid Values: 0=Absolute date, 1=Duration after contact, 2=End of month after contact (not used)

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from the usm_policy table in Unica Platform.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

DeleteLock INTEGER NOT NULL

Valid Values: 0=not in use, 1=locked/offer in use

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? Yes

Configuration? No

creatorFlag INTEGER NULL Number indicating which Application created the Offer

Valid Values: 0,1,2,3

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

creatorObjectId BIGINT NULL ID of the corresponding Object in the creator Application

Valid Values: Long

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 46. UA_Offer parent tables
Table name Description
UA_OfferTemplate This table contains one row for each offer template defined in the system (these are used to create offers). For each offer template, it defines the number of offer codes, their formats, and the offer code generator; the treatment code format and generator; and general offer template meta data.
UA_Folder This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).
Table 47. UA_Offer child tables
Table name Description
UA_CampToOffer This table stores top-down defined relationships between a campaign and its related offers (specified by the user from the Campaign summary page by clicking on "Add/Remove Offers" link). This can be a many-to-many mapping. Bottom-up offers (offers used in a flowchart of the campaign) are not stored in this table.
UA_OfferAttribute This table stores the values of the static attributes and default values of the parameterized attributes associated with an offer (system-generated and custom).
UA_OfferHistory This table stores all offer versions that have been given out to customers. It determines if a particular combination of parameterized offer attributes (offer version identified by OfferHistoryID) for a given offer (offerID) has already been created (using the CRC value). The UA_OfferHistory table is populated only once for each unique offer version. If the UA_OfferHistory table is already populated for an offer, it will not be populated again if contact history is updated for the same offer.
UA_OfferToProduct This table stores the information about the relationship between offers and products, specified by the "Relevant Product(s)" field. It is only populated if the user specifies a value for the Relevant Product(s) field of an offer.
UA_ProductIndex This table stores the many-to-many relationship between products and offers based on the ProductIDs that match the "product query" associated with an offer (from the Related Product(s) field).It is used to quickly resolve the set of products associated with a particular offer for response tracking without having to re-run the UA_OfferToProduct. ProductCondition query. This above line should appear for UA_ProductIndex table but is somehow appearing for UA_ResponseHistory table.
UA_Treatment Stores all treatments (intersection of offer to target cells at a point in time (run instance) and related data. If multiple offers are assigned to a cell, there will be multiple rows in the treatment table (one treatment for each offer given to the cell). If a personalized offer is used, a treatment will be created for each unique permutation of offer attributes used (here, HasDetailHistory=1 and contact information is stored in a separate table, UA_DtlContactHistory). This data is populated during a production run of a CSP only when 'Log to contact history' is enabled.
UACO_ROffer This table contains the set of offers that constrains the given rule for the given subsection.
UACO_PCT0000000000 This is an example table, built per Optimize session, based on the UACO_PCTBase table.
UACO_SesnOffer This table contributes to the definition of two items: the score matrix and the "displayed offers" used in the session.

UA_OfferAttribute

This table stores the values of the static attributes and default values of the parameterized attributes associated with an offer (system-generated and custom).

Table 48. UA_OfferAttribute field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferID BIGINT NOT NULL The OfferID of the offer for whom this attribute value is associated.

Valid Values: Any valid OfferID in UA_Offer table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

AttributeID BIGINT NOT NULL The AttributeID of the offer attribute whose value is being stored

Valid Values: Any valid AttributeID in UA_AttributeDef table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

StringValue VARCHAR NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ClobValue NVARCHAR NULL Only one of these 4 fields, String Value, NumberValue, DatetimeValue, or Clob Value is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

MAX Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberValue DOUBLE NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid numeric value

53 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DatetimeValue TIMESTAMP NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

Table 49. UA_OfferAttribute parent tables
Table name Description
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_OfferHistAttrib

This table stores the actual values used for parameterized (only) offer attributes when an offer is used (given out in a flowchart production run with logging to CH enabled). It is populated at flowchart run time.

Table 50. UA_OfferHistAttrib field descriptions
Field Name Type Null? Description Length Additional Attributes
AttributeID BIGINT NOT NULL The AttributeID of the offer attribute whose value is being stored

Valid Values: Any valid AttributeID in UA_AttributeDef table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

CRC value BIGINT NOT NULL The Offer history ID for which this attribute value is being stored (represents the offer version or unique permutation of parameterized offer attributes).

Valid Values: Any valid OfferHistoryID in UA_OfferHistory table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

StringValue VARCHAR NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

NumberValue DOUBLE NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid numeric value

53 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

DatetimeValue TIMESTAMP NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? Yes

Table 51. UA_OfferHistAttrib parent tables
Table name Description
UA_OfferHistory This table stores all offer versions that have been given out to customers. It determines if a particular combination of parameterized offer attributes (offer version identified by OfferHistoryID) for a given offer (offerID) has already been created (using the CRC value). The UA_OfferHistory table is populated only once for each unique offer version. If the UA_OfferHistory table is already populated for an offer, it will not be populated again if contact history is updated for the same offer.
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_OfferHistory

This table stores all offer versions that have been given out to customers. It determines if a particular combination of parameterized offer attributes (offer version identified by OfferHistoryID) for a given offer (offerID) has already been created (using the CRC value). The UA_OfferHistory table is populated only once for each unique offer version. If the UA_OfferHistory table is already populated for an offer, it will not be populated again if contact history is updated for the same offer.

Table 52. UA_OfferHistory field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferHistoryID BIGINT NOT NULL Offer versions are no longer supported since 7.x.

Valid Values: Any valid OfferHistoryID value in UA_OfferHistAttrib table

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

CRC BIGINT NULL Offer versions are no longer supported since 7.x. Please remove the word 'version' wherever applicable.

Valid Values: Any bigint

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

OfferID BIGINT NULL Offer versions are no longer supported since 7.x.

Valid Values: Any valid OfferID in UA_Offer table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? Yes

Configuration? No

Table 53. UA_OfferHistory parent tables
Table name Description
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.
Table 54. UA_OfferHistory child tables
Table name Description
UA_OfferHistAttrib This table stores the actual values used for parameterized (only) offer attributes when an offer is used (given out in a flowchart production run with logging to CH enabled). It is populated at flowchart run time.
UA_Treatment Stores all treatments (intersection of offer versions to target cells at a point in time (run instance) and related data. If multiple offers are assigned to a cell, there are multiple rows in the treatment table (one treatment for each offer version given to the cell). If offer personalization is used, a treatment is created for each unique permutation of offer attributes (offer version) used (and HasDetailHistory=1 and contact information is stored in a separate table, UA_DtlContactHistory). This data is populated during a production run of a CSP only when logging is enabled.

UA_OfferList

This table stores both internal and user-created offer lists. User-created offer lists can be static (fixed list of offers) or smart (dynamic; based on a query). Internally generated offer lists are used to group together the actual list of offers assigned to a specific cell in a CSP when multiple offers are assigned. Internal offer lists may reference user-created offer lists (only one level of nesting supported).

Table 55. UA_OfferList field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferListID BIGINT NOT NULL Unique identifier for the offer list generated by the system when an offer list is created.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NULL For user-created offer lists, this is the user-specified offer list name, which must be unique within the offer folder. For internally generated offer lists, this value is "Internal offer list".

Valid Values: Any text characters, minus standard disallowed special name characters

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL For user-created offer lists, this is the optional user-specified offer list description. For internally generated offer lists, this value is "Internal offer list".

Valid Values: Any text characters minus standard disallowed special characters in text

512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferQuery VARCHAR NULL If OfferListType = 2 (dynamic), this field contains the offer query used to generate the smart offer list.

Valid Values: Valid query expression

2048 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferListType INTEGER NULL Specifies the type of user-defined offer list: static (fixed list of offers) or smart/dynamic (matching offers generated by resolving a query based on offer attributes) or whether the offer list is an internally generated list used to group together multiple offers/offer lists assigned to the same cell in a CSP.

Valid Values: 1=Static, 2=Dynamic, 3=Internal

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

FolderID BIGINT NULL Folder ID for the folder where the object is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

MaxSize INTEGER NULL If OfferListType = 2 (dynamic), this field specifies the maximum number of offers that can be returned as a result of running the offer query. A value of 0 means an unlimited number of offers can be returned.

Valid Values: Non-negative integer

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

IncludeSubFolders INTEGER NULL If OfferListType = 2 (dynamic), this field specifies whether any scoping of returned offers based on folder location(s) will include subfolders or not. It is not possible to include subfolders for some folders and not for others.

Valid Values: 0=does not include subfolders; 1=includes subfolders

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Retired INTEGER NULL Specifies whether an offer list has been "retired," which means it can no longer be given out in any campaigns/flowcharts. Newly created offer lists are not retired by default. Retired offers lists do not appear for selection when assigning offers. The user can choose to retire an offer list at any time. **There is no way in the GUI to "unretire" an offer list.

Valid Values: 0=active; 1=retired

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Platform UserId of the user who created the list.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from Unica Platform usm_role table

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

creatorFlag INTEGER NULL Used when Unica Campaign and Unica Plan offer integration is enabled. Flag indicates whether Offer is created by Unica Campaign or Unica Plan.

Valid Values: 0,1,2,3

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

creatorObjectId BIGINT NULL Used in Unica Campaign and Unica Plan offer integration. Field is used by Plan to associate Unica Campaign offerlist and Unica Plan Offerlist objects.

Valid Values: Long

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 56. UA_OfferList parent tables
Table name Description
UA_Folder This table contains the basic data for all internal folders for object storage in the system. A new row is created each time a new folder is created for storing any of system object (e.g., campaign, session, offer, segment, custom macro, derived field, etc.).
Table 57. UA_OfferList child tables
Table name Description
UA_OfferListMember This table stores the members of an offer list. For a user-defined static offer list, this contains the list of OfferIDs and their display order and is populated when the offer list is saved. For a user-defined smart offer list, this table contains the list of folders to which the smart query has been scoped (if any). For an internal offer list, this tables stores any referenced (nested) offer lists. The members can be any of these: o an individual offer o an offerList o a folder Each offer list member must be exactly one of the above.
UA_TargetCells This table stores information on target cells created in all flowcharts. Target cells are defined as cells that are attached to an output process (Mail List, Call List, Recommend, Deliver, Snapshot, or Optimize). It stores meta data information (name, code), source info (campaign, flowchart and cell IDs), treatment data (list of assigned offers/offer lists and whether it is a control cell), and whether the cell was created top-down in the Target Cell Spreadsheet (TCS) or bottom-up from within a flowchart.
UACO_ROfferList This table contains the set of offer lists that constrain the given rule for the given subsection.

UA_OfferListMember

This table stores the members of an offer list. For a user-defined static offer list, this contains the list of OfferIDs and their display order and is populated when the offer list is saved. For a user-defined smart offer list, this table contains the list of folders to which the smart query has been scoped (if any). For an internal offer list, this tables stores any referenced (nested) offer lists. The members can be any of these: o an individual offer o an offerList o a folder Each offer list member must be exactly one of the above.

Table 58. UA_OfferListMember field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferListID BIGINT NOT NULL Unique ID for the offer list to which this row is associated

Valid Values: Any valid OfferListID in UA_OfferList

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NestedOfferListID BIGINT NULL This field can be populated only if the UA_OfferList.OfferListType = 3 (internal list); it contains an OfferListID assigned to a cell within a flowchart CSP. It is populated on save of the flowchart.

Valid Values: Any valid OfferListID in UA_OfferList

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferID BIGINT NULL When UA_OfferList.OfferListType = 1 (static), this field is populated with the OfferIDs that are members of the static offer list. When UA_OfferList.OfferListType = 3 (internal), this field contains any directly assigned offers to the cell (not those appearing as part of a user-created offer list). This field is NULL for UA_OfferList.OfferListType = 2.

Valid Values: Any valid OfferID in UA_Offer table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

FolderID BIGINT NULL Folder ID for the folder where the object is stored. Value is automatically populated based on the folder where the object is stored. User can change this value by "moving" the object to a different folder.

Valid Values: Any valid FolderID value existing in UA_Folder table

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DisplayOrder INTEGER NULL This field specifies the order in which offers in a static offer list are displayed to the user; it is populated only when UA_OfferList.OfferListType = 1 (otherwise it is NULL).

Valid Values: NULL or positive integer starting with one and incrementing by one for each OfferID member of the same OfferListID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 59. UA_OfferList parent tables
Table name Description
UA_OfferList This table stores both internal and user-created offer lists. User-created offer lists can be static (fixed list of offers) or smart (dynamic; based on a query). Internally generated offer lists are used to group together the actual list of offers assigned to a specific cell in a CSP when multiple offers are assigned. Internal offer lists may reference user-created offer lists (only one level of nesting supported).
UA_OfferList This table stores both internal and user-created offer lists. User-created offer lists can be static (fixed list of offers) or smart (dynamic; based on a query). Internally generated offer lists are used to group together the actual list of offers assigned to a specific cell in a CSP when multiple offers are assigned. Internal offer lists may reference user-created offer lists (only one level of nesting supported).
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.

UA_OfferListRes

This table stores the offerIDs that a dynamic offer list resolves to at run-time.

Table 60. UA_OfferListRes field descriptions
Field Name Type Null? Description Length Additional Attributes
OLResolveID BIGINT NOT NULL Unique ID for the this row.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

OfferListID BIGINT NOT NULL Specifies the OfferListID that is being resolved.

Valid Values: Any valid OfferListID in the UA_OfferList table

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

OfferID BIGINT NOT NULL Lists an offer ID that is in the specified OfferListID.

Valid Values: Any valid OfferID in the UA_Offer table

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? Yes

Configuration? No

UA_OfferSuppression

The UA_OfferSuppression table contains rules for suppressing offers that are presented to visitors during interactive sessions. Rules for suppressing offers are triggered by acceptance or rejection events, by frequency of presentation, or by a rule's similarity to a related rule that is also suppressed. This table also maintains the criteria for when Interact should no longer suppress a rule, such as after a specified period of time has elapsed.

Table 61. UA_OfferSuppression field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferID BIGINT NOT NULL The ID of the offer this suppression rule is targeted to. 19 Is Primary Key? Yes
SuppressionType INTEGER NOT NULL The type of this suppression rule, i.e., which type of events will trigger this suppression rule: 1=accept event, 2=reject event, 3=contact event. 10 Is Primary Key? Yes
ResponseTypeCode VARCHAR NULL In addition to the event type, the response type code that must be included in the event in order for this rule to be triggered. 64 Is Primary Key? No
EventCount INTEGER NULL The number of occurrences this event has to be posted for this rule to be triggered. 10 Is Primary Key? No
AttributeID BIGINT NULL Once this suppression rule is triggered, in addition to the same offer, it may also apply to other offers that have the same attribute and same value for this attribute. If this column is null, no other offers will be affected. Otherwise, if another offer has the same attribute which has the same value as the one defined in StringValue, NumberValue, or DatetimeValue, then that offer is suppressed. 19 Is Primary Key? No
StringValue VARCHAR NULL The value of the string-typed attribute for matching other associated offers. 1024 Is Primary Key? No
NumberValue DOUBLE NULL The value of the number-typed attribute for matching other associated offers. 53 Is Primary Key? No
DatetimeValue TIMESTAMP NULL The value of the datetime-typed attribute for matching other associated offers. 23,3 Is Primary Key? No
SuppressionDuration INTEGER NULL The length in days this suppression rule will remain effective from the time it is triggered. 10 Is Primary Key? No

UA_OfferTemplate

This table contains one row for each offer template defined in the system (these are used to create offers). For each offer template, it defines the number of offer codes, their formats, and the offer code generator; the treatment code format and generator; and general offer template meta data.

Table 62. UA_OfferTemplate field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferTemplID BIGINT NOT NULL Unique identifier for the offer template generated by the system when an offer template is created.

Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values (may be outside this range for Unica Campaigns imported from another system using sesutil).

19 Is Primary Key? Yes

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

Name VARCHAR NULL This is the unique name of the offer template.

Valid Values: Any text characters, minus standard disallowed special name characters

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Description VARCHAR NULL Optional description of offer template.

Valid Values: Any text characters minus standard disallowed special characters in text

512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? Yes

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberOfOfferCodes INTEGER NULL The number of offer code parts/components for offers to be created from this template (default = 1).

Valid Values: A whole number between 1-5

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode1CodeFrmt VARCHAR NULL This is the first part of the offer code and must always populated with a valid offer code format, one character for each byte of the offer code. This field cannot be edited after an offer template has been used (i.e., an offer has been created using this offer template).
Valid Values:
  • <Capital letter> = constant
  • <Symbol> = constant
  • a = character A-Z
  • c = character A-Z or 0-9
  • n = number 0-9
  • x = any character
64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode2CodeFrmt VARCHAR NULL This is the second part of the offer code and is populated if NumberOfOfferCodes >=2, else it is NULL. **This field cannot be edited once an offer template has been used (i.e., an offer has been created using this offer template).
Valid Values:
  • <Capital letter> = constant
  • <Symbol> = constant
  • a = character A-Z
  • c = character A-Z or 0-9
  • n = number 0-9
  • x = any character
64 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode3CodeFrmt VARCHAR NULL This is the third part of the offer code and is populated if NumberOfOfferCodes >=3, else it is NULL. **This field cannot be edited once an offer template has been used (i.e., an offer has been created using this offer template).
Valid Values:
  • <Capital letter> = constant
  • <Symbol> = constant
  • a = character A-Z
  • c = character A-Z or 0-9
  • n = number 0-9
  • x = any character
64 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode4CodeFrmt VARCHAR NULL This is the fourth part of the offer code and is populated if NumberOfOfferCodes >=4, else it is NULL. This field cannot be edited once an offer template has been used (i.e., an offer has been created using this offer template).
Valid Values:
  • <Capital letter> = constant
  • <Symbol> = constant
  • a = character A-Z
  • c = character A-Z or 0-9
  • n = number 0-9
  • x = any character
64 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCode5CodeFrmt VARCHAR NULL This is the fifth part of the offer code and is populated if NumberOfOfferCodes =5, else it is NULL. **This field cannot be edited once an offer template has been used (i.e., an offer has been created using this offer template).
Valid Values:
  • <Capital letter> = constant
  • <Symbol> = constant
  • a = character A-Z
  • c = character A-Z or 0-9
  • n = number 0-9
  • x = any character
64 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

OfferCodeGenerator VARCHAR NULL The name of the offer code generator that will automatically generate a unique offer code based on the offer code format(s) specified. This defaults to the offer code generator shipped with Unica Campaign. **This field cannot be edited once an offer template has been used (i.e., an offer has been created using this offer template).

Valid Values: Any valid executable name accessible to the Unica Campaign server

250 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

TreatmentCodeFrmt VARCHAR NULL This is the format of the globally unique treatment code and must always populated with a valid treatment code format, one character for each byte of the treatment code. This field cannot be edited after an offer template has been used (i.e., an offer has been created using this offer template).

Valid Values: Capital letter = constant; Symbol = constant; a = character A-Z; c = character A-Z or 0-9; n = number 0-9;x = any character

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

TrmtCodeGenerator CHAR NULL The name of the treatment code generator that will automatically generate a unique treatment code based on the treatment code format specified. This defaults to the treatment code generator shipped with Unica Campaign (same as Unica Campaign code generator). **This field cannot be edited once an offer template has been used (i.e., an offer has been created using this offer template).

Valid Values: Any valid executable name accessible to the Unica Campaign server

250 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Retired INTEGER NULL Specifies whether an offer template has been "retired," which means it can no longer be used to create new offers. Newly created offer templates are not retired by default. Retired offers templates do not appear for selection when creating new offers. The user can choose to retire an offer template at any time. **There is no way in the GUI to "unretire" (or delete) an offer template.

Valid Values: 0=active; 1=retired

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

SuggestedUsageDesc VARCHAR NULL Optional text displayed to the user describing what kind of offers this template may be good for creating; displayed to the user in the "Select an offer template" offer creation wizard when he is creating an offer.

Valid Values: Any text characters minus standard disallowed special characters in text

512 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DisplayIcon VARCHAR NULL Name of the icon to be displayed representing the template (.gif file) for easy user identification (used in the Offer Template Definitions page and in the "Select an offer template" offer creation wizard when a user is creating an offer.

Valid Values: Valid .gif file name

255 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DisplayOrder INTEGER NULL An internal sequence number that specifies the order in which the template is displayed both on the Administration > Offer Template Definitions page and in the "Select an offer template" offer creation wizard when a user is creating an offer. The user can change this value by using the "Reorder" button on the Offer Template Definitions page.

Valid Values: Positive integer starting with one and incrementing by one for each Offer template in the system

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

CreateDate TIMESTAMP NULL Server date and time the object was created.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? Yes

CreateBy INTEGER NULL Platform UserId of the user who created the Template

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

UpdateDate TIMESTAMP NULL Last server date and time the object was updated (edited and saved); same as CreateDate for initial object creation.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? Yes

UpdateBy INTEGER NULL Platform user ID for the user who last updated the object; same as CreateBy for initial object creation.

Valid Values: Valid Platform UserID

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

PolicyID INTEGER NULL Security policy ID for the object, which determines which Platform users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices).

Valid Values: Any valid PolicyID from the usm_policy table in Unica Platform.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? Yes

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ACLID INTEGER NULL For future use. 10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? No

Stored Execute? No

Configuration? No

creatorFlag INTEGER NULL Number indicating which Application created the Offer Template

Valid Values: Positive Integer

10 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? No

Configuration? No

Hashcode INT NULL Hashcode to recognize the uniqueness of Offer template when Offers are created without template.

Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered No

Stored Create No

Stored Save No

Stored Execute No

Stored Execute No

Configuration No

creatorObjectId BIGINT NULL ID of the corresponding Object in the creator Application

Valid Values: Positive Long

19 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? No

Stored Create? No

Stored Save? Yes

Stored Execute? No

Configuration? No

Rules CLOB NULL This column stores visibility rules for attributes within a template
offerThumbAttrid BIGINT NULL Attribute id used for offer thumbnail 19
Table 63. UA_OfferTemplate child tables
Table name Description
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.
UA_OfferTemplAttr This table stores the offer attribute values associated with a particular offer template and specifies whether each attribute is hidden, parameterized, its default value, and display order. Note that only one of the fields StringValue, NumberValue and DatetimeValue contain the value for the attribute based on the attributeType defined in the UA_AttributeDef table.

UA_OfferTemplAttr

This table stores the offer attribute values associated with a particular offer template and specifies whether each attribute is hidden, parameterized, its default value, and display order. Note that only one of the fields StringValue, NumberValue and DatetimeValue contain the value for the attribute based on the attributeType defined in the UA_AttributeDef table.

Table 64. UA_OfferTemplAttr field descriptions
Field Name Type Null? Description Length Additional Attributes
AttributeID BIGINT NOT NULL The attribute ID for which values are being stored. **Once an offer template has been used (i.e., an offer has been created using this offer template), the offer attributes associated with the offer template cannot be changed.

Valid Values: Any valid AttributeID in UA_AttributeDef table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? No

Stored Execute? No

Configuration? No

OfferTemplID BIGINT NOT NULL The offer template ID to which the attributes are associated.

Valid Values: Any valid OfferTemplID in the UA_OfferTemplate table

19 Is Primary Key? Yes

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

StringValue VARCHAR NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

1024 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ClobValue NVARCHAR NULL Only one of these 4 fields, String Value, NumberValue, DatetimeValue, or Clob is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: For free-form text (UA_AttributeDef.EnumType = 0) or modifiable drop-down list (UA_AttributeDef.EnumType = 2), any text characters minus standard disallowed special characters in text. For fixed drop-down list (UA_AttributeDef.EnumType = 1), this value must be one of the values stored in UA_EnumAttrValues for the AttributeID.

MAX Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

NumberValue DOUBLE NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid numeric value

53 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DatetimeValue TIMESTAMP NULL Only one of these 3 fields, String Value, NumberValue, or DatetimeValue, is populated for any row. The populated field is based on the UA_AttributeDef. AttributeType field for this AttributeID. Currency is populated in NumberValue.

Valid Values: Valid datetime

23,3 Is Primary Key? No

Is Foreign Key? No

Required Field? No

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

IsParameter INTEGER NULL Specifies whether the offer attribute is parameterized (i.e., whether the user can change the value at the time the offer is assigned to a cell in a CSP). Offer versions are automatically created based on unique permutations of parameterized offer attributes. **Once an offer template has been used (i.e., an offer has been created using this offer template), the parameterization of offer attributes associated with the offer template cannot be changed.

Valid Values: 0=static; 1=parameterized

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

IsHidden INTEGER NULL Specifies whether the offer attribute is hidden (i.e., whether the offer attribute is displayed to the user when creating or viewing an offer). Hidden attributes must have a default value when the offer template is created. **Once an offer template has been used (i.e., an offer has been created using this offer template), the hidden state of offer attributes associated with the offer template cannot be changed.

Valid Values: 0=displayed; 1=hidden

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

DisplayOrder INTEGER NULL An internal sequence number that specifies the order in which the offer attributes are when a user is creating, editing, or viewing an offer. The user controls the display order of offer attributes by moving them up and down in the Offer Attribute page of the Offer Template Definition wizard. **Once an offer template has been used (i.e., an offer has been created using this offer template), the order of offer attributes associated with the offer template cannot be changed.

Valid Values: Positive integer starting with one and incrementing by one for each offer attribute in the offer template.

10 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 65. UA_OfferTemplAttr parent tables
Table name Description
UA_OfferTemplate This table contains one row for each offer template defined in the system (these are used to create offers). For each offer template, it defines the number of offer codes, their formats, and the offer code generator; the treatment code format and generator; and general offer template meta data.
UA_AttributeDef The UA_AttributeDef table contains the definitions of both system and custom attributes for offers and cells (campaign custom attributes are stored in the UA_CampAttribute table). System-defined attributes have the field SystemDefined=1. Offers (OfferTemplates, Offers, OfferHistory) and Cells use these attribute definitions. This table is written to when the Save button is invoked from the Custom attribute definition page. Each attribute creates one row in this table, identified by the unique ID AttributeID. After an attribute is initially created, some fields like the AttributeType and Length fields cannot be modified (see individual fields for further info).

UA_OfferToProduct

This table stores the information about the relationship between offers and products, specified by the "Relevant offers" field (required for an offer). It is only populated if the user specifies a value for the Relevant Offers field of an offer.

Table 66. UA_OfferToProduct field descriptions
Field Name Type Null? Description Length Additional Attributes
OfferID BIGINT NULL The OfferID for which the product query is being defined (criteria entered in the Related products offer attribute field.

Valid Values: Any valid OfferID in the UA_Offer table

19 Is Primary Key? No

Is Foreign Key? Yes

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

ProductCondition VARCHAR NOT NULL The query based on one or more offer attributes that defines the set of Product IDs associated with this offer.

Valid Values: Text string representing a valid query built on offer attributes

2048 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? No

System Generated Override? No

User Entered? Yes

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Table 67. UA_OfferToProduct parent tables
Table name Description
UA_Offer This table stores basic information about offers. All offer attributes are now stored in UA_OfferAttribute table. Each offer is associated with the Offer Template that was used to create the offer. During offer creation, the creator can change the values for the static attributes and default values for the parameterized attributes. Actual values of the parameterized attributes are assigned at the flowchart design time or at the flowchart run time.

UA_Personalization

Stores the personalization settings on the homepage. Personalization items includes recently viewed items for campaigns and sessions.

Table 68. UA_Personalization field descriptions
Field Name Type Null? Description Length Additional Attributes
UserID BIGINT NULL Platform user ID that the personalization item is associated with.

Valid Values: Valid UserID in Platform **Value may be invalid if Platform user is subsequently deleted.

19 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Keyword VARCHAR NULL Internal unique ID used to update and delete information. It is generated is using system current time in milliseconds at the moment of creation.

Valid Values: Valid integer

64 Is Primary Key? No

Is Foreign Key? No

Required Field? Yes

System Generated? Yes

System Generated Override? No

User Entered? No

Stored Create? Yes

Stored Save? Yes

Stored Execute? No

Configuration? No

Name VARCHAR