HCL Contact Optimization system tables reference
The system table reference provides details on each of the HCL® Contact Optimization system tables. The data types that are indicated in the following tables are generic types that may be different in your HCL Contact Optimization installation, depending on the database that is used for the system tables. The HCL Contact Optimization system tables are stored in a database that was created before the HCL Contact Optimization installation. The database can have any name. The ODBC or native connection provides a connection to the database.
UA_OptimizeProcess
An entry in this table represents a single Optimize process box as seen in HCL Campaign flowcharts.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
OptimizeID | BIGINT | NOT NULL | This is an internal identifier for the Optimize process box that uniquely identifies it
within a campaign. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? No Configuration? No |
TempFlag | INTEGER | NOT NULL | The temporary state of this box. Valid Values: 0 = not temporary 1 = temporary |
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 Run? No Configuration? No |
FlowchartID | INTEGER | NOT NULL | Unique identifier of the flowchart that contains the Optimize
process box. 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. |
10 | 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 Run? No Configuration? No |
CampaignID | BIGINT | NOT NULL | Unique identifier of the campaign containing the flowchart containing the Optimize process
box. This ID is assigned by HCL
Campaign when a campaign is created. It 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. |
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 Run? No Configuration? No |
ACOSessionID | BIGINT | NOT NULL | The unique identifier for each Contact Optimization session. 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? Yes Required Field? Yes System Generated? Yes System Generated Override? No User Entered? No Stored Create? Yes Stored Save? No Stored Run? No Configuration? No |
ProcessName | VARCHAR | NOT NULL | The name that is given by the user for this process box (in the
General tab of the process box, inside the flowchart). 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 Run? No Configuration? No |
Status | VARCHAR | NULL | The status of this Optimize process box. Valid Values: 'Free' or 'Busy' |
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 Run? Yes Configuration? No |
RunBy | INTEGER | NULL | The ID of the user that last ran this process box. Valid Values: Valid ASM User ID |
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 Run? Yes Configuration? No |
LastRunDate | TIMESTAMP | NULL | Date and time the Optimize process box was last run (any flowchart,
branch, process run). 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? Yes System Generated? Yes System Generated Override? No User Entered? No Stored Create? Yes Stored Save? Yes Stored Run? Yes Configuration? Yes |
RunResult | VARCHAR | NULL | The results of the last run. This is an XML field that contains
metadata about the results of the run. Valid Values: Well-formatted XML string containing Optimize process run results. |
2048 | 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 Run? Yes Configuration? No |
CreateDate | TIMESTAMP | NULL | The date this process box 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 Run? No Configuration? Yes |
CreateBy | INTEGER | NULL | The ID of the user that created this box. Valid Values: Valid ASM User ID |
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 Run? No Configuration? No |
UpdateDate | TIMESTAMP | NULL | The last date or time this process box was changed. 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 Run? No Configuration? Yes |
UpdateBy | INTEGER | NULL | The user that last updated this process box. Valid Values: Valid ASM User ID |
10 | 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 Run? No Configuration? No |
Table name | Description |
---|---|
UACO_OptSession | An entry in this table represents a single Contact Optimization session with all of its metadata. |
UA_Campaign |
UACO_OCTBase
This table contains all of the columns that are used to create an optimized contacts table (OCT) for a session.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
ContactID | BIGINT | NOT NULL | A unique identifier of a potential contact that is originated from a particular flowchart.
This number is unique across a flowchart. An entry in this table means that the contact was
optimized and accepted by HCL
Contact Optimization. This field appears in the OCT. Valid Values: Any numeric value. |
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 Run? Yes Configuration? No |
OptimizeID | BIGINT | NOT NULL | The unique identifier for the Optimize process box that generated this particular
transaction. This field appears in the OCT. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? Yes Configuration? Yes |
OutputScore | DOUBLE | NOT NULL | The score that was used by Contact Optimization
during optimization. Because the score that was passed in from HCL
Campaign can be overridden by the score
matrix, this score must be recorded here. This field appears in the OCT. Valid Values: Any numeric value. |
53 | 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 Run? Yes Configuration? Yes |
UACO_OfferSeg
This table contains the scores that are used at the intersection of an offer and segment in the score matrix.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
ACOSessionID | BIGINT | NOT NULL | A unique identifier for the Contact Optimization session. Valid Values: Any valid ACOSessionID from the UACO_OptSession 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 Run? No Configuration? No |
SegmentID | BIGINT | NOT NULL | The unique ID for a strategic segment in the score matrix. Valid Values: Any SegmentID from the UA_Segment 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 Run? No Configuration? No |
OfferID | BIGINT | NOT NULL | The unique identifier of an offer in the score matrix. Valid Values: Any valid OfferID in the 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? Yes Stored Run? No Configuration? No |
Score | DOUBLE | NOT NULL | This is the score that is used when the Offer ID and the Segment
ID in this particular row matches the transaction's offer or segment. Valid Values: Any positive numeric value. |
53 | 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 Run? No Configuration? No |
Table name | Description |
---|---|
UACO_SesnSegment | This table contributes to the definition of two items: the score matrix and the "displayed segments" used in the session. |
UACO_SesnOffer | This table contributes to the definition of two items: the score matrix and the "displayed offers" used in the session. |
UACO_OptSession
An entry in this table represents a single Contact Optimization session with all of its metadata.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
ACOSessionID | BIGINT | NOT NULL | The unique identifier for each Contact Optimization
session. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? No Configuration? No |
FolderID | BIGINT | NOT NULL | The 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 configuration
parameter, whichever is higher. 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? Yes Required Field? Yes System Generated? Yes System Generated Override? No User Entered? No Stored Create? Yes Stored Save? Yes Stored Run? No Configuration? No |
Name | VARCHAR | NOT NULL | Name of the Contact Optimization session. 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 Run? No Configuration? No |
Objective | VARCHAR | NULL | Optional, user-entered, free-form objective of the session. Valid Values: Any text characters |
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 Run? No Configuration? No |
Description | VARCHAR | NULL | Optional, user-entered, free-form description of the session. Valid Values: Any text characters |
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 Run? No Configuration? No |
AudienceName | VARCHAR | NOT NULL | The audience level of the session. After the session is created,
the value of this should not be changed. It is with this audience
level that the OCT/PCT/POA are generated. Valid values for this are
stored in the configuration system. Valid Values: Any audience level. |
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? No Stored Run? No Configuration? No |
TemplateTable Name | VARCHAR | NULL | This is the name of a table that is used as a template for
any user-defined fields. Each of the fields in this table is added
to the PCT during generation so the user can customize the PCT to
include fields to be used in rules. After the session is created,
the value of this column should not change. 1) This table must be
part of the system tables. 2) This value can be NULL, which means
that no user-defined columns are used in the session. Valid Values: Any table that is listed in the configuration for template table names. |
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? No Stored Run? No Configuration? Valid values from configuration. |
AgentChannel Name | VARCHAR | NULL | 64 | Is Primary Key? No | |
AgentInfoTemplate Table | VARCHAR | NULL | Each table contains the unique identification values (IDs) of agents and their capacity. These tables should be present in the Campaign system database. | 64 | Is Primary Key? No |
AgentCustomerRel TemplateTable | VARCHAR | NULL | The Agent Customer Relationship table contains the unique identification values (IDs) of agents and the audience ID of associated customers. This table should be present in the HCL Campaign system database. The audience level of the audience ID must be the same as the audience level of your Contact Optimization session. | 64 | Is Primary Key? No |
PCTName | VARCHAR | NOT NULL | This is the name of the PCT table that is associated with this session. This table should
live in the same schema as the system tables. This table contains all of the proposed contacts from
participating campaigns. Valid Values: The format of this table name is defined in the software by using the format: UACO_PCTXXXXXXXXXX, where XXXXXXXXXX is the 10 digit 0 padded ACOSessionID. |
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? No Stored Run? No Configuration? Yes |
OCTName | VARCHAR | NOT NULL | This is the name of the OCT table for this session. The OCT contains all of the transactions
that Contact Optimization accepted out of the PCT. This
field cannot be NULL. Valid Values: The format of this table name is defined in the software by using the format: UACO_OCTXXXXXXXXXX, where XXXXXXXXXX is the 10 digit 0 padded ACOSessionID. |
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? No Stored Run? No Configuration? Yes |
POAName | VARCHAR | NOT NULL | This is the proposed offer attribute table for this session. It contains the value of the
attributes for the offers being proposed in the PCT. Valid Values: The format of this table name is defined in the software by using the format: UACO_POAXXXXXXXXXX, where XXXXXXXXXX is the 10 digit 0 padded ACOSessionID. |
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? No Stored Run? No Configuration? Yes |
TrxnScoreField | VARCHAR | NOT NULL | This field stores the name of the score field in the PCT associated
to this session (see PCTName) that is used as the score field for
the transactions in the PCT. By default, the value of this column
is the "ScorePerOffer" column from the PCT. Valid Values: Any numeric column from the User Template Table or ScorePerOffer Column or a special internal value to indicate score matrix. |
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 Run? No Configuration? No |
ScoreAllOfferSeg | DOUBLE | NOT NULL | This is the score from the score matrix that is used by default
for any offer or segment combination that does not have a value that
is assigned for it. Valid Values: Any positive numeric score. |
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 Run? No Configuration? No |
SessionStatusID | BIGINT | NOT NULL | The status of the session. See the UACO_SesnStatus table for valid
values for this column. Valid Values: See the UACO_SesnStatus table for valid values for this column. |
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 Run? Yes Configuration? Assigned during DDL execution. |
CustomSettings Flag | INTEGER | NULL | 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 Run? No Configuration? No |
|
CustomSettings XML | VARCHAR | NULL | 4000 | 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 Run? No Configuration? No |
|
CreateDate | TIMESTAMP | NOT NULL | The date and time this session 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 Run? No Configuration? Yes |
CreateBy | INTEGER | NOT NULL | The ASM user ID of the user who created the session. Valid Values: Valid ASM User ID |
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 Run? No Configuration? No |
UpdateDate | TIMESTAMP | NOT NULL | The 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 Run? No Configuration? Yes |
UpdateBy | INTEGER | NOT NULL | The ASM user ID for the user who last updated the object; same
as CreateBy for initial object creation. Valid Values: Valid ASM 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 Run? No Configuration? No |
PolicyID | INTEGER | NOT NULL | The identifier of the security policy that this current session belongs to. Valid Values: Any valid PolicyID from the usm_policy table in HCL Marketing Platform. |
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 Run? No Configuration? No |
ACLID | INTEGER | NOT 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 Run? No Configuration? No |
LastRunType | VARCHAR | NOT NULL | These values indicate the run type of the last Contact Optimization session that was run. Valid Values: Test Run, Production Run, Never Run. |
64 | 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 Run? Yes Configuration? No |
Table name | Description |
---|---|
UACO_SesnStatus | This table contains a look up of valid values for the status of a Contact Optimization session. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UA_Folder |
Table name | Description |
---|---|
UA_OptimizeProcess | An entry in this table represents a single Optimize process box as seen in HCL Campaign flowcharts. |
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UACO_SesnOffer | This table contributes to the definition of two items: the score matrix and the "displayed offers" used in the session. |
UACO_SesnRunHist | This table contains the history of session runs that were run. It references the report files that were generated by the specific runs. |
UACO_SesnSegment | This table contributes to the definition of two items: the score matrix and the "displayed segments" used in the session. |
UACO_PCTBase
This is the base table that is used to generate the PCT. All columns in this table automatically appear in the PCT.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
ContactID | BIGINT | NOT NULL | A unique identifier of a potential contact (assigned by Contact Optimization) that is originated from a particular flow
chart. This number is unique across a flowchart. This field appears in the PCT. Valid Values: Incrementing positive number unique to the Optimize 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? Yes Stored Save? No Stored Run? Yes Configuration? No |
OptimizeID | BIGINT | NOT NULL | The process box ID for the Optimize process that generated this transaction. This field
appears in the PCT. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? Yes Configuration? No |
ScorePerOffer | DOUBLE | NOT NULL | This field contains the score for a particular transaction as provided by HCL
Campaign. This field appears in the PCT. Valid Values: Any non-negative number. |
53 | 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 Run? Yes Configuration? No |
CostPerOffer | DOUBLE | NOT NULL | This field contains the cost for a particular transaction as provided by HCL
Campaign. This field appears in the PCT. Valid Values: Any non-negative number. |
53 | 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 Run? Yes Configuration? No |
OfferID | BIGINT | NOT NULL | The ID of the offer proposed. This field appears in the PCT. 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? No System Generated Override? No User Entered? Yes Stored Create? Yes Stored Save? No Stored Run? Yes Configuration? No |
ContactDateTime | TIMESTAMP | NOT NULL | The date and time that this transaction is scheduled to reach
the recipient. This field appears in the PCT. 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? No Stored Run? Yes Configuration? Yes |
Channel | VARCHAR | NOT NULL | The channel that this offer is delivered by. (Even though channel is an offer attribute, it
is denormalized into this table as it is required by Contact Optimization to optimize transactions because rules can be
built based on the channel.) This field appears in the PCT. Valid Values: Any text 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? No Stored Run? Yes Configuration? No |
OfferCRC | BIGINT | NOT NULL | This is a CRC that is generated on the offer and all of its
attributes. It is a quick way to identify the difference between one
offer version and another. This is only used for reporting. Valid Values: Any numeric value. |
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 Run? Yes Configuration? No |
CellCode | VARCHAR | NOT NULL | The cell code that is assigned in HCL
Campaign for this recipient. Valid Values: Any string satisfying the cell code format that is specified by the server system codes CellCodeFormat configuration parameter. |
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? No Stored Run? Yes Configuration? Yes |
TempOfferHistID | BIGINT | NOT NULL | This ID is used to correlate a unique set of offer attributes
as many offers may end up having the same offer history ID. Valid Values: Any numeric value. |
19 | 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? No Stored Run? Yes Configuration? No |
UACO_POABase
This table contains all of the columns that are used to create the Parameterized Offer Attributes (POA) table for a session.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
TempOfferHistID | BIGINT | NOT NULL | A unique identifier of a potential contact that is originated
from a particular flowchart. This number is unique across a flowchart.
This field appears in the POA for a particular session. Valid Values: Any numerical value. |
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 Run? Yes Configuration? No |
OptimizeID | BIGINT | NOT NULL | This is the same as the OptimizeID in the PCTBase, but it is denormalized into this table for faster delete operations. | 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? Yes Stored Run? Yes Configuration? No |
AttributeID | BIGINT | NOT NULL | The ID of the offer attribute. Every offer in the PCT has 0 or more attributes in this table. Every attribute of every offer that is in the PCT has a unique value in this table. This field appears in the POA for a particular session. | 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? Yes Stored Run? Yes Configuration? No |
StringValue | VARCHAR | NULL | Only one of these three 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. This field appears in the POA for
a particular session. Valid Values: Any text characters. |
512 | 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 Run? Yes Configuration? No |
NumberValue | DOUBLE | NULL | Only one of these three 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. This field appears in the POA for
a particular session. Valid Values: Any numeric value. |
53 | 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 Run? Yes Configuration? No |
DatetimeValue | TIMESTAMP | NULL | Only one of these three 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. This field appears in the POA for
a particular session. 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? Yes Stored Save? No Stored Run? Yes Configuration? Yes |
UACO_RConstraint
This table contains the set of generic rule constraints types with their values for each rule as associated to their specific subsections.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleID | BIGINT | NOT NULL | The system-generated unique ID used to identify an instance of a rule. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? No Configuration? No |
RCTypeID | BIGINT | NOT NULL | The type of the rule constraint. Valid Values: 1 = MinCost (float >=0) 2 = MaxCost (float >=0) 3 = MinCount (number >= 0) 4= MaxCount (number >=0) 5=Number of days (0 = this optimization period) 6 = Filter subquery (XML) 7 = Channel filter subquery (XML) 8 = sensitivity enabled? (1 = enable, 0 = disable) |
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 Run? No Configuration? Created during DDL execution time. |
RuleSubsectionID | BIGINT | NOT NULL | An ID that identifies which part of a rule the particular constraint
is part of. For instance, a rule constraint that has only one part
always has its constraints part of the Section A, whereas a rule that
has multiple parts (A/B rules) has constraints on both A and B. Valid Values: 1= Section A 2 = Section B |
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 Run? No Configuration? Created during DDL execution time. |
StringValue | VARCHAR | NOT NULL | Every constraint type has its own valid set of values. Some constraints store XML in this
field, while others store numbers in this field. For example, a MinCost constraint may have a value
of 10.12, so the column will contain a string that says
10.12. Valid Values: Varies based on the rule constraint type (for details, see the RCTypeID valid values). |
2048 | 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 Run? No Configuration? No |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UACO_RCType | This table contains a look up of valid values for the rule constraints. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_RSubsection | This table contains a look up of valid subsection values. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_RCType
This table contains a look up of valid values for the rule constraints. The contents of this table are fixed with the expected values for any particular release of Contact Optimization.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RCTypeID | BIGINT | NOT NULL | The type of rule constraint. Valid Values: 1 = MinCost (float >=0) 2 = MaxCost (float >=0) 3 = MinCount (number >= 0) 4= MaxCount (number >=0) 5=Number of days (0 = this optimization period) 6 = Filter subquery (XML) 7 = Channel filter subquery (XML) 8 = sensitivity enabled? (1 = enable, 0 = disable) |
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 Run? No Configuration? Created during DDL execution time. |
Description | VARCHAR | NULL | The description of the rule constraint type. Valid Values: Any text characters. |
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 Run? No Configuration? Created during DDL execution time. |
Table name | Description |
---|---|
UACO_RConstraint | This table contains the set of generic rule constraints types with their values for each rule as associated to their specific subsections. |
UACO_RException
This table is used to store list of exceptions rules added by the user.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleExID | BIGINT | NOT NULL | Exception Rule ID. Valid Values: Positive Integer |
19 | Is Primary Key? Yes Is Foreign Key? No Required Field? Yes System Generated? No System Generated Override? Yes User Entered? Yes Stored Create? No Stored Save? Yes Stored Run? No Configuration? No |
RuleID | BIGINT | NOT NULL | 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? Yes Required Field? Yes System Generated? No System Generated Override? Yes User Entered? Yes Stored Create? No Stored Save? Yes Stored Run? No Configuration? No |
RuleExName | VARCHAR | NULL | Name of the exception rule. Valid Values: Text |
64 | Is Primary Key? No Is Foreign Key? No Required Field? Yes System Generated? No System Generated Override? Yes User Entered? Yes Stored Create? No Stored Save? Yes Stored Run? No Configuration? No |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
Table name | Description |
---|---|
UACO_RExConstraint | This table is used to store list of exception constraints and its values. |
UACO_RExConstraint
This table is used to store list of exception constraints and its values.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleExID | BIGINT | NULL | The exception rule ID. Valid Values: Positive Integer |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? Yes User Entered? Yes Stored Create? No Stored Save? Yes Stored Run? No Configuration? No |
RExTypeID | BIGINT | NULL | The exception constraint type ID. Valid Values: Positive Integer |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? Yes User Entered? Yes Stored Create? No Stored Save? Yes Stored Run? No Configuration? No |
StringValue | VARCHAR | NOT NULL | The value of the exception constraint. Valid Values: Text |
1024 | Is Primary Key? No Is Foreign Key? No Required Field? No System Generated? No System Generated Override? Yes User Entered? Yes Stored Create? No Stored Save? Yes Stored Run? No Configuration? No |
Table name | Description |
---|---|
UACO_RExType | This table is used to store list of supported exception constraint types. |
UACO_RException | This table is used to store list of exceptions rules added by the user. |
UACO_RExType
This table is used to store list of supported exception constraint types.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RExTypeID | BIGINT | NOT NULL | The exception constraint type ID. Valid Values: Positive Integer |
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 Run? No Configuration? No |
Description | VARCHAR | NULL | The description of the exception constraint type. Valid Values: Text |
64 | 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 Run? No Configuration? No |
Table name | Description |
---|---|
UACO_RExConstraint | This table is used to store list of exception constraints and its values. |
UACO_ROffer
This table contains the set of offers that constraint the rule for the subsection.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleID | BIGINT | NOT NULL | The system-generated unique ID used to identify an instance of a rule. Valid Values: Any valid RuleID from the UACO_RConstraint 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 Run? No Configuration? No |
OfferID | BIGINT | NOT NULL | The unique identifier of the offer to which this rule applies. Valid Values: Any valid OfferID in the UA_Offer table. |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? No User Entered? Yes Stored Create? Yes Stored Save? Yes Stored Run? No Configuration? No |
RuleSubsectionID | BIGINT | NOT NULL | An ID that identifies which part of a rule the particular constraint
is part of. For instance, a rule constraint that has only one part
always has its constraints part of the Section A, whereas a rule that
has multiple parts (A/B rules) has constraints on both A and B. Valid Values: 1= Section A 2 = Section B |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? Yes System Generated Override? No User Entered? No Stored Create? No Stored Save? No Stored Run? No Configuration? No |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UACO_RSubsection | This table contains a look up of valid subsection values. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UA_Offer |
UACO_ROfferList
This table contains the set of offer lists that constraint the rule for the subsection.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
OfferListID | BIGINT | NOT NULL | The identifier for the offer list that is used in the scope of this rule. Valid Values: Any valid OfferListID from the UA_OfferList table. |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? No User Entered? Yes Stored Create? Yes Stored Save? Yes Stored Run? No Configuration? No |
RuleID | BIGINT | NOT NULL | The system-generated unique ID used to identify an instance of a rule. Valid Values: Any valid RuleID from the UACO_RConstraint 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 Run? No Configuration? No |
RuleSubsectionID | BIGINT | NOT NULL | An ID that identifies which part of a rule the particular constraint
is part of. For instance, a rule constraint that has only one part
always has its constraints part of the Section A, whereas a rule that
has multiple parts (A/B rules) has constraints on both A and B. Valid Values: 1= Section A 2 = Section B |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? No User Entered? No Stored Create? No Stored Save? No Stored Run? No Configuration? Created during DDL execution time. |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UA_OfferList | |
UACO_RSubsection | This table contains a look up of valid subsection values. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_RSegment
This table contains the set of segments that constraint the given rule for the given subsection.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
SegmentID | BIGINT | NOT NULL | The identifier of a strategic segment that scopes the rule. Valid Values: Any valid SegmentID from the UA_Segment table. |
19 | 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 Run? No Configuration? No |
RuleID | BIGINT | NOT NULL | The system-generated unique ID used to identify an instance of a rule. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? No Configuration? No |
RuleSubsectionID | BIGINT | NOT NULL | An ID that identifies which part of a rule the particular constraint
is part of. For instance, a rule constraint that has only one part
always has its constraints part of the Section A, whereas a rule that
has multiple parts (A/B rules) has constraints on both A and B. Valid Values: 1= Section A 2 = Section B |
19 | Is Primary Key? Yes Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? No User Entered? No Stored Create? Yes Stored Save? No Stored Run? No Configuration? No |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UACO_RSubsection | This table contains a look up of valid subsection values. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_RSubsection
This table contains a look up of valid subsection values. The contents of this table are fixed with the expected values for any particular release of Contact Optimization.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleSubsectionID | BIGINT | NOT NULL | An ID that identifies which part of a rule the particular constraint
is part of. For instance, a rule constraint that has only one part
always has its constraints part of the Section A, whereas a rule that
has multiple parts (A/B rules) has constraints on both A and B. Valid Values: 1= Section A 2 = Section B |
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 Run? No Configuration? Created during DDL execution time. |
Description | VARCHAR | NULL | The description of the rule subsections. Valid Values: Any text characters. |
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 Run? No Configuration? Created during DDL execution time. |
Table name | Description |
---|---|
UACO_RConstraint | This table contains the set of generic rule constraints types with their values for each rule as associated to their specific subsections. |
UACO_ROffer | This table contains the set of offers that constraint the rule for the subsection. |
UACO_ROfferList | This table contains the set of offer lists that constraint the rule for the subsection. |
UACO_RSegment | This table contains the set of segments that constraint the given rule for the given subsection. |
UACO_Rule
This table contains the basic description of the rule that is used in a Contact Optimization session.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleID | BIGINT | NOT NULL | The system-generated unique ID used to identify an instance of a rule. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? No Configuration? No |
Name | VARCHAR | NOT NULL | The name of the rule. Rule names must be unique within the same session. Valid Values: Any text characters, minus standard disallowed special name characters, must be a unique name in the session. |
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 Run? No Configuration? No |
Description | VARCHAR | NULL | The optional description of the rule. Valid Values: Any text characters |
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 Run? No Configuration? No |
RuleTypeID | BIGINT | NOT NULL | The type of the rule. Valid Values: 1 = Customers In, Include/Exclude only 2 = Interactions Where, Include/Exclude only 3 = Min/max offers 4 = Max packages 5 = Min/max total cost 6 = Min/max offers 7 = Not used 8 = Min # unique offers 9 = Max # duplicates 10 = Never A with B 11 = Never A followed by B 12 = B only with A |
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 Run? No Configuration? No |
RuleSubtypeID | BIGINT | NOT NULL | An identifier to further qualify the rule type. Valid Values: 1 = None 2 = Include 3 - Exclude |
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 Run? No Configuration? No |
ACOSessionID | BIGINT | NOT NULL | The identifier that uniquely identifies the session in which the rule belongs. Valid Values: Any valid ACOSessionID in UACO_OptSession 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 Run? No Configuration? No |
CreateDate | TIMESTAMP | NOT NULL | The server date and time the rule 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 Run? No Configuration? Yes |
CreateBy | INTEGER | NOT NULL | The ASM user ID of the user that created this rule. Valid Values: Valid ASM User ID |
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 Run? No Configuration? No |
UpdateDate | TIMESTAMP | NOT NULL | The last server date and time the rule was updated (edited
and saved); same as CreateDate for initial rule 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 Run? No Configuration? Yes |
UpdateBy | INTEGER | NOT NULL | The ASM user ID for the user who last updated the rule; same
as CreateBy for initial rule creation. Valid Values: Valid ASM User ID |
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 Run? No Configuration? No |
Table name | Description |
---|---|
UACO_RuleType | This table contains a look up of rule types that are used to enforce data-integrity for the rule that is created within a session. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_RuleSubtype | This table contains a look up of rule subtypes that are used to describe the rule. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_OptSession | An entry in this table represents a single Contact Optimization session with all of its metadata. |
Table name | Description |
---|---|
UACO_RConstraint | This table contains the set of generic rule constraints types with their values for each rule as associated to their specific subsections. |
UACO_RException | This table is used to store list of exceptions rules added by the user. |
UACO_ROffer | This table contains the set of offers that constraint the rule for the subsection. |
UACO_ROfferList | This table contains the set of offer lists that constraint the rule for the subsection. |
UACO_RSegment | This table contains the set of segments that constraint the given rule for the given subsection. |
UACO_RuleSubtype
This table contains a look up of rule subtypes that are used to describe the rule. The contents of this table are fixed with the expected values for any particular release of Contact Optimization.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleSubtypeID | BIGINT | NOT NULL | An identifier to further qualify the rule type. Valid Values: 1 = None 2 = Include 3 = Exclude |
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 Run? No Configuration? Created during DDL execution time. |
Description | VARCHAR | NOT NULL | The description of this rule subtype. Valid Values: Any text characters. |
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 Run? No Configuration? Created during DDL execution time. |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UACO_RuleType
This table contains a look up of rule types that are used to enforce data-integrity for the rule that is created within a session. The contents of this table are fixed with the expected values for any particular release of Contact Optimization.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RuleTypeID | BIGINT | NOT NULL | The ID of the rule type. Valid Values: 1 = Customers In, Include/Exclude only 2 = Interactions Where, Include/Exclude only 3 = Min/max offers 4 = Max packages 5 = Min/max total cost 6 = Min/max offers 7 = Not used 8 = Min # unique offers 9 = Max # duplicates 10 = Never A with B 11 = Never A followed by B 12 = B only with A |
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 Run? No Configuration? Created during DDL execution Time. |
Description | VARCHAR | NULL | The description of the rule type. Valid Values: Any character string. |
64 | 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 Run? No Configuration? Created during DDL execution time. |
Table name | Description |
---|---|
UACO_Rule | This table contains the basic description of the rule that is used in a Contact Optimization session. |
UACO_SesnOffer
This table contributes to the definition of two items: the score matrix and the "displayed offers" used in the session.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
OfferID | BIGINT | NOT NULL | The unique identifier of an offer included in the optimization session. Valid Values: Any valid OfferID from the 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? Yes Stored Run? No Configuration? No |
ACOSessionID | BIGINT | NOT NULL | The identifier that uniquely identifies the Contact Optimization session. Valid Values: Any valid ACOSessionID from the UACO_OptSession 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 Run? No Configuration? No |
OfferOrder | INTEGER | NOT NULL | This value is used to specify the display order of offers in
the reports. Valid Values: Unique number across all entries for this ACOSessionID. Must be a nonzero positive increasing number. |
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 Run? No Configuration? No |
ScoreAllSegments | DOUBLE | NOT NULL | This is the score for all segments that do not have a score value in
UACO_OfferSeg for the specified OfferID in the current row. When evaluating
the score matrix, this score is used when the offer and segment combination does not yield an
explicit value in the UACO_OfferSeg table. Valid Values: Any positive numeric value. |
53 | 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 Run? No Configuration? No |
Enable | INTEGER | NOT NULL | This value is used as an indicator that the value stored in
the ScoreAllSegments is valid. If this value is set to 1, then the
value in ScoreAllSegments is used. Otherwise, it is ignored when determining
the score of the Offer and Segment intersection. Valid Values: 0 or 1 |
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 Run? No Configuration? No |
Table name | Description |
---|---|
UA_Offer | |
UACO_OptSession | An entry in this table represents a single Contact Optimization session with all of its metadata. |
Table name | Description |
---|---|
UACO_OfferSeg | This table contains the scores that are used at the intersection of an offer and segment in the score matrix. |
UACO_SesnRunHist
This table contains the history of session runs that were run. It references the report files that were generated by the specific runs.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RunID | BIGINT | NOT NULL | The ID of the session run. This number is automatically incremented after each run for a
particular session. Valid Values: Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
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 Run? No Configuration? No |
ACOSessionID | BIGINT | NOT NULL | The identifier that uniquely identifies each session. Valid Values: Any valid ACOSessionID from the UACO_OptSession 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 Run? No Configuration? No |
RunBy | INTEGER | NOT NULL | The ASM user ID of the user that last ran the session. Valid Values: Valid ASM 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 Run? No Configuration? No |
StartTime | TIMESTAMP | NOT NULL | The date and time that the session 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? Yes Stored Save? No Stored Run? No Configuration? Yes |
EndTime | TIMESTAMP | NULL | The date and time that the session run completed. 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 Run? Yes Configuration? Yes |
FinalStatus | VARCHAR | NULL | An XML string that is the final status of the session run. Valid Values: XML String. |
1028 | 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 Run? Yes Configuration? No |
ReportFileName | VARCHAR | NOT NULL | The name of the report file that was generated for this particular session run. Valid Values: Any valid file name that is generated by the system by using the ACOSessionID. |
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? No Stored Run? No Configuration? No |
RunTypeID | BIGINT | NOT NULL | The type of run. Valid Values: 1 = production run 2 = test run |
19 | Is Primary Key? No Is Foreign Key? Yes Required Field? Yes System Generated? No System Generated Override? No User Entered? No Stored Create? No Stored Save? No Stored Run? No Configuration? Generated at DDL execution Time |
Table name | Description |
---|---|
UACO_SesnRunType | This table contains a look up of valid run types. The contents of this table are fixed with the expected values for any particular release of Contact Optimization. |
UACO_OptSession | An entry in this table represents a single Contact Optimization session with all of its metadata. |
UACO_SesnRunType
This table contains a look up of valid run types. The contents of this table are fixed with the expected values for any particular release of Contact Optimization.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
RunTypeID | BIGINT | NOT NULL | This enumerates the HCL
Campaign session run types (excluding test mode). Valid Values: 1 = production run 2 = test run |
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 Run? No Configuration? Generated at DDL execution Time |
Description | VARCHAR | NULL | The description of the run type. Valid Values: Any characters. |
64 | 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 Run? No Configuration? Generated at DDL execution time. |
Table name | Description |
---|---|
UACO_SesnRunHist | This table contains the history of session runs that were run. It references the report files that were generated by the specific runs. |
UACO_SesnSegment
This table contributes to the definition of two items: the score matrix and the "displayed segments" used in the session.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
SegmentID | BIGINT | NOT NULL | The identifier of the strategic segment. Valid Values: Any 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? No Stored Create? Yes Stored Save? Yes Stored Run? No Configuration? No |
ACOSessionID | BIGINT | NOT NULL | The identifier that uniquely identifies each session. Valid Values: Any valid ACOSessionID from the UACO_OptSession 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 Run? No Configuration? No |
SegmentOrder | INTEGER | NOT NULL | The order that the segment is used to evaluate when applying
the score matrix. Because the value of the score matrix is a combination
of the segment and the offer, the audience level can theoretically
be in more than one segment. The SegmentOrder defines which one is
checked first. The first segment that matches is used to determine
the score of the transaction. This is also used as the display order
for reporting purposes. Valid Values: Unique number across all entries for this ACOSessionID. Must be a nonzero positive increasing number. |
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 Run? No Configuration? No |
ScoreAllOffers | DOUBLE | NOT NULL | This is the score for all offers that do not have a score value in
UACO_OfferSeg for the specified SegmentID in the current row. When evaluating
the score matrix, this score is used when the offer and segment combination does not yield an
explicit value in the UACO_OfferSeg table. Valid Values: Any positive numeric value. |
53 | 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 Run? No Configuration? No |
Enable | INTEGER | NOT NULL | This value is used as an indicator that the value stored in
the ScoreAllOffers is valid. If this value is set to 1, then the value
in ScoreAllOffers is used. Otherwise, it is ignored when determining
the score of the Offer and Segment intersection. Valid Values: 0 or 1 |
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 Run? No Configuration? No |
Table name | Description |
---|---|
UACO_OptSession | An entry in this table represents a single Contact Optimization session with all of its metadata. |
Table name | Description |
---|---|
UACO_OfferSeg | This table contains the scores that are used at the intersection of an offer and segment in the score matrix. |
UACO_SesnStatus
This table contains a look up of valid values for the status of a Contact Optimization session. The contents of this table are fixed with the expected values for any particular release of Contact Optimization.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
SessionStatusID | BIGINT | NOT NULL | The status of this session. Valid Values: 1 = Free 2 = Locked |
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 Run? No Configuration? Assigned during DDL execution. |
Description | VARCHAR | NULL | The description of the value of the SessionStatusID. Valid Values: Any text characters. |
64 | 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 Run? No Configuration? Assigned during DDL execution. |
Table name | Description |
---|---|
UACO_OptSession | An entry in this table represents a single Contact Optimization session with all of its metadata. |
UACO_UserTable
This is an example of a user table that can be specified by the user to define the appended columns to the PCT during session creation time.
Field Name | Type | Null? | Description | Length | Additional Attributes |
---|---|---|---|---|---|
CharColumn | CHAR | NULL | An example of using a char-based column as a user-defined column. If the user selects this table to be part of creating a session, then each column in this table is part of the PCT. | 20 | Is Primary Key? No Is Foreign Key? No Required Field? Yes System Generated? No System Generated Override? No User Entered? Yes Stored Create? No Stored Save? No Stored Run? No Configuration? No |
RealColumn | DOUBLE | NULL | An example of using a real-based column as a user-defined column. If the user selects this table to be part of creating a session, then each column in this table is part of the PCT. | 53 | Is Primary Key? No Is Foreign Key? No Required Field? Yes System Generated? No System Generated Override? No User Entered? Yes Stored Create? No Stored Save? No Stored Run? No Configuration? No |
IntColumn | BIGINT | NOT NULL | An example of using an int-based column as a user-defined column. If the user selects this table to be part of creating a session, then each column in this table is part of the PCT. | 19 | Is Primary Key? No Is Foreign Key? No Required Field? Yes System Generated? No System Generated Override? No User Entered? Yes Stored Create? No Stored Save? No Stored Run? No Configuration? No |
VarCharColumn | VARCHAR | NULL | An example of using a varchar-based column as a user-defined column. If the user selects this table to be part of creating a session, then each column in this table is part of the PCT. | 64 | Is Primary Key? No Is Foreign Key? No Required Field? Yes System Generated? No System Generated Override? No User Entered? Yes Stored Create? No Stored Save? No Stored Run? No Configuration? No |