Unica Campaign Interact Cognos Framework Manager Model Specification

Project: InteractModel
Supported Locale(s): en fr de es
Package(s): Unica Interact Package

Name	CM DataSource
InteractDTDS	InteractDTDS
InteractRTDS	InteractRTDS
InteractLearningDS	InteractLearningDS

Parameter Map	Key - Values
Environment	Redirect URL: http://localhost:7001/Campaign/redirectToSummary.do?type= Version: 8.1.0.00

Folder: Business View
Folder: Model View
Folder: Import View

Business View

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Interactive Channel by Offer Performance

Interactive Channel by Offer Performance Summary

Offer ID

decimal

identifier

[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Offer ID]

Offer Name

characterLength16

attribute

[Interactive Channel by Offer Performance Summary Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Interactive Channel by Offer Performance Summary Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Interactive Channel ID

decimal

identifier

[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interactive Channel]

Interaction Point ID

decimal

identifier

[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interaction Point]

Presented

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Rejected])

Interactive Channel by Offer Performance Last 14 Days

Offer ID

decimal

identifier

[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Offer ID]

Offer Name

characterLength16

attribute

[Interactive Channel by Offer Performance by Day Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Interactive Channel by Offer Performance by Day Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Interactive Channel ID

decimal

identifier

[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interactive Channel]

Interaction Point ID

decimal

identifier

[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interaction Point]

Actual Date

dateTime

attribute

[Interactive Channel by Offer Performance by Day Star Schema].[Calendar][Interact Model].[Calendar].[Actual Date]

Presented

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Random])

Eligible Opportunities

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Eligible Opportunities])

Accepted

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Rejected])

Interactive Channel by Offer Performance by Hour

Offer ID

decimal

identifier

[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Offer ID]

Offer Name

characterLength16

attribute

[Interactive Channel by Offer Performance by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Interactive Channel by Offer Performance by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Interactive Channel ID

decimal

identifier

Interactive Channel

characterLength16

attribute

Interaction Point ID

float64

identifier

Interaction Point

characterLength16

attribute

Hour

int64

attribute

Actual Date

dateTime

attribute

Presented

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Random])

Accepted

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Rejected])

Interactive Channel by Segment Performance

Interactive Channel by Segment Performancy Summary

Interactive Channel ID

decimal

identifier

[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

Interaction Point ID

float64

identifier

Interaction Point

characterLength16

attribute

Segment ID

decimal

identifier

[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Segment ID]

Segment

characterLength16

attribute

[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Segment]

Presented

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Random])

Defaulted

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Times Defaulted][Interact Model].[Interactive Channel by Segment Times Defaulted].[Defaulted] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Times Defaulted][Interact Model].[Interactive Channel by Segment Times Defaulted].[Defaulted])

Accepted

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Rejected])

Interactive Channel by Segment Performance by Day

Interactive Channel ID

decimal

identifier

[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

Interaction Point ID

float64

identifier

Interaction Point

characterLength16

attribute

Segment ID

decimal

identifier

Segment

characterLength16

attribute

Actual Date

dateTime

identifier

Presented

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Random])

Accepted

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Rejected])

Interactive Channel by Segment Performance by Hour

Interactive Channel ID

decimal

identifier

[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

Interaction Point ID

float64

identifier

Interaction Point

characterLength16

attribute

Segment ID

decimal

identifier

Segment

characterLength16

attribute

Hour

int64

identifier

Actual Date

dateTime

identifier

Presented

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Random])

Accepted

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Rejected])

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Cumulative Interactive Channel by Segment by Day	Cumulative Interactive Channel by Segment Number of Times Presented by Day	(shortcut)	[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day]
	Cumulative Interactive Channel by Segment Response History by Day	(shortcut)	[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day]
	Last 14 Days Calendar	(shortcut)	[Interact Model].[Last 14 Days Calendar]

Interactive Channel by Interaction Point Performance

Interactive Channel by Interaction Point Performance Summary

Interactive Channel ID

decimal

identifier

[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel]

Interaction Point ID

float64

identifier

[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point]

Presented

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Random])

Defaulted

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Times Defaulted][Interact Model].[Interactive Channel by IP Times Defaulted].[Defaulted] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Times Defaulted][Interact Model].[Interactive Channel by IP Times Defaulted].[Defaulted])

Accepted

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Rejected])

Interactive Channel by Interaction Point Performance Last 7 Days

Interactive Channel ID

decimal

identifier

[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel]

Interaction Point ID

float64

identifier

[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point]

Actual Date

dateTime

identifier

[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Actual Date]

Presented

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random])

Accepted

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected])

Interactive Channel by Interaction Point Performance Last 24 Hours

Interactive Channel ID

decimal

identifier

[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interactive Channel]

Interaction Point ID

float64

identifier

[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interaction Point]

Hour

float64

identifier

[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Hour]

Actual Date

dateTime

identifier

[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Actual Date]

Presented

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented])

Presented Model-Driven

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Model-Driven])

Presented Random

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Random])

Accepted

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted])

Accepted Model-Driven

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Random])

Rejected

float64

fact

IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Rejected])

Namespace/Folder	Query Subject	Query Item	Type	Usage	Ref Obj/Expr.
Dashboard	Dashboard Interactive Channel by Interaction Point Performance Last 7 Days	Interactive Channel ID	decimal	identifier	[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel ID]
		Interactive Channel	characterLength16	attribute	[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel]
		Interaction Point ID	float64	identifier	[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point ID]
		Interaction Point	characterLength16	attribute	[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point]
		Actual Date	dateTime	identifier	[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Actual Date]
		Presented	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented])
		Presented Model-Driven	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven])
		Presented Random	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random])
		Accepted	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted])
		Accepted Model-Driven	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven])
		Accepted Random	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random])
		Rejected	float64	fact	IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected])

Campaign by Cell Performance

Campaign Cell Performance Summary

Campaign ID

decimal

identifier

[Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell Performance Summary Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell Performance Summary Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell Performance Summary Star Schema].[Cells][Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell Performance Summary Star Schema].[Cells][Interact Model].[Cells].[Cell Code]

Presented

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Random] is missing) THEN (0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Rejected])

Campaign Cell Performance by Last 7 Days

Campaign ID

decimal

identifier

[Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Code]

Actual Date

dateTime

identifier

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Actual Date]

Presented

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected])

Campaign Cell Performance by Last 24 Hours

Campaign ID

decimal

identifier

[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell Code]

Hour

float64

identifier

[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Hour]

Actual Date

dateTime

identifier

[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Actual Date]

Presented

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected])

Campaign Cell Performance by Hour

Campaign ID

decimal

identifier

[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Cells][Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell Performance by Hour Star Schema].[Cells][Interact Model].[Cells].[Cell Code]

Actual Date

dateTime

identifier

[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Actual Date]

Hour

int64

identifier

[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Hour]

Presented

float64

fact

Presented Model-Driven

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random])

Eligible Opportunities

float64

fact

Accepted

float64

fact

Accepted Model-Driven

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected])

Campaign Cell Performance by Last 14 Days

Campaign ID

decimal

identifier

[Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Code]

Actual Date

dateTime

identifier

[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Actual Date]

Presented

float64

fact

Presented Model-Driven

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random])

Eligible Opportunities

float64

fact

Accepted

float64

fact

Accepted Model-Driven

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected])

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Cumulative Campaign Cell Performance by Day	Campaign	(shortcut)	[Interact Model].[Campaign]
	Cells	(shortcut)	[Interact Model].[Cells]
	Cumulative Campaign Cell Number of Times Presented by Day	(shortcut)	[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day]
	Cumulative Campaign Cell Performance Response History by Day	(shortcut)	[Interact Model].[Cumulative Campaign Cell Performance Response History by Day]
	Last 14 Days Calendar	(shortcut)	[Interact Model].[Last 14 Days Calendar]

Campaign by Cell by Offer Performance

Campaign by Cell by Offer Performance Summary

Campaign ID

decimal

identifier

[Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell by Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell by Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell by Offer Performance Star Schema].[Cells][Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell by Offer Performance Star Schema].[Cells][Interact Model].[Cells].[Cell Code]

Offer ID

decimal

identifier

[Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Cell by Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Cell by Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Presented

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Random] is missing) THEN (0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Rejected])

Campaign by Cell by Interaction Point Performance

Campaign Cell by Interaction Point Summary

Campaign ID

decimal

fact

[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Cell by IP Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Cell by IP Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Cell ID

decimal

identifier

[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Cell by IP Star Schema].[Cells][Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Cell by IP Star Schema].[Cells][Interact Model].[Cells].[Cell Code]

Interaction Point ID

decimal

identifier

[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Interaction Point]

Presented

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Random])

Rejected

float64

fact

IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Rejected])

Campaign by Offer Performance

Campaign by Offer Performance Summary

Campaign ID

decimal

identifier

[Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Offer ID

decimal

identifier

[Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Presented

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Random])

Rejected

float64

fact

IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Rejected])

Campaign by Offer Performance by Last 7 Days

Campaign ID

decimal

identifier

[Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Offer by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Offer by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Offer ID

decimal

identifier

[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer Code 1]

Actual Date

dateTime

identifier

[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Actual Date]

Presented

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Random])

Rejected

float64

fact

IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Rejected])

Campaign by Offer Performance by Last 24 Hours

Campaign ID

decimal

identifier

[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Offer ID

decimal

identifier

[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer Code 1]

Hour

float64

identifier

[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Hour]

Actual Date

dateTime

identifier

[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Actual Date]

Presented

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random])

Rejected

float64

fact

IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected])

Campaign by Offer Performance by Hour

Campaign ID

decimal

identifier

[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Offer ID

decimal

identifier

[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Offer by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Hour

int64

identifier

[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Hour]

Actual Date

dateTime

identifier

[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Actual Date]

Presented

float64

fact

Presented Model-Driven

float64

fact

Presented Random

float64

fact

Eligible Opportunities

float64

fact

Accepted

float64

fact

Accepted Model-Driven

float64

fact

Accepted Random

float64

fact

Rejected

float64

fact

Campaign by Offer by Cell Performance

Campaign by Offer by Cell Performance Summary

Campaign ID

decimal

identifier

[Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Offer Cell Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Offer Cell Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Offer ID

decimal

identifier

[Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Offer Cell Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Offer Cell Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Cell ID

decimal

identifier

[Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Cell ID]

Cell Name

characterLength16

attribute

[Campaign Offer Cell Star Schema].[Cells][Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Campaign Offer Cell Star Schema].[Cells][Interact Model].[Cells].[Cell Code]

Presented

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Random])

Rejected

float64

fact

IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Rejected])

Campaign by Offer by Interaction Point Performance

Campaign by Offer by Interaction Point Summary

Campaign ID

decimal

identifier

[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Campaign ID]

Campaign Name

characterLength16

attribute

[Campaign Offer by Interaction Point Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name]

Campaign Code

characterLength16

attribute

[Campaign Offer by Interaction Point Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Offer ID

decimal

identifier

[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Offer ID]

Offer Name

characterLength16

attribute

[Campaign Offer by Interaction Point Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Campaign Offer by Interaction Point Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Interaction Point ID

decimal

identifier

[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Interaction Point]

Presented

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented])

Presented Model-Driven

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Model-Driven])

Presented Random

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Random])

Eligible Opportunities

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Eligible Opportunities])

Accepted

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted])

Accepted Model-Driven

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Model-Driven])

Accepted Random

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Random])

Rejected

float64

fact

IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Rejected])

Campaign Interactive Offer Learning Details

Interactive Offer Learning Details

Campaign ID

decimal

identifier

[Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign ID]

Campaign Name

characterLength16

attribute

[Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign Name]

Campaign Code

characterLength16

attribute

[Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign Code]

Offer ID

decimal

identifier

[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Offer ID]

Offer Name

characterLength16

attribute

[Interactive Offer Learning Star Schema].[Offer][Interact Model].[Offer].[Offer Name]

Offer Code 1

characterLength16

attribute

[Interactive Offer Learning Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Attribute Name

characterLength16

attribute

[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Attribute Name]

Attribute Value

characterLength16

attribute

[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Attribute Value]

Likelyhood of Response

float64

fact

[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Likelyhood of Response]

Predictability

int64

attribute

[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Predictability]

Channel_Campaign - Interactive Channel Deployment History

Interactive Channel Campaign - Interactive Channel Deployment History

Interactive Channel ID

decimal

identifier

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Interactive Channel ID]

Campaign ID

decimal

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Campaign ID]

Campaign Name

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Campaign Name]

Campaign Code

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]

Session ID

decimal

identifier

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Session ID]

Session Name

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Session Name]

Flowchart ID

decimal

identifier

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart ID]

Flowchart Name

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart Name]

Flowchart Deployment Type

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Flowchart Deployment Type][Interact Model].[Flowchart Deployment Type].[Flowchart Deployment Type]

Audience Level

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Audience Level]

Deployment ID

decimal

identifier

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment ID]

Deployment Deploy Type ID

int64

attribute

[Interact Model].[Interactive Channel Deployment History].[Deployment Deploy Type ID]

Deployment Destination

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Destination]

Deployment Server Group

int64

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Server Group]

Production Group

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[isProduction][Interact Model].[isProduction].[Production Group]

Deployment Type

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Deploy Type][Interact Model].[Deployment Type].[Deployment Type]

StrategyID

decimal

identifier

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[StrategyID]

Strategy Name

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Strategy Name]

Deployment Owner

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Owner]

Time of Deployment

dateTime

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Time of Deployment]

Strategy Tab URL

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Strategy Tab URL]

Flowchart Tab URL

characterLength16

attribute

[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart Tab URL]

Channel Treatment Rule Inventory

Treatment Rule Inventory Summary

Treatment Rule ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Treatment Rule ID]

Deployment ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Deployment ID]

Interactive Channel ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Interactive Channel]

Cell ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Cell ID]

Cell Name

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Cell Name]

Cell Code

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Cells][Interact Model].[Cells].[Cell Code]

Zone ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone ID]

Zone

characterLength16

attribute

IF ([Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone] is NULL) THEN ([Interact Model].[Treatment Rule Inventory].[All Zones] ) ELSE([Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone] )

Strategy ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Strategy ID]

Strategy Name

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Strategy Name]

Offer ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Offer ID]

Offer Name

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Offer Name]

Offer Code 1

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1]

Campaign ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign ID]

Campaign Name

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign Name]

Campaign Code

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign Code]

Segment ID

decimal

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Segment ID]

Segment

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Segment]

Marketing Score

int64

fact

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Marketing Score]

Enable State ID

int64

identifier

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Enable State ID]

Predicate State

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Predicate State][Interact Model].[Predicate State].[Predicate State]

Predicate

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Predicate]

Last Update Date

dateTime

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Last Update Date]

StrategyTab URL

characterLength16

attribute

[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[StrategyTab URL]

Interactive Channel Event Activity

Event Activity Peak Day All

(shortcut)

[Peak and Slow All].[Peak Day All]

Event Activity Slow Day All

(shortcut)

[Peak and Slow All].[Slow Day All]

Event Activity Peak Hour All

(shortcut)

[Peak and Slow All].[Peak Hour All]

Event Activity Slow Hour All

(shortcut)

[Peak and Slow All].[Slow Hour All]

Interactive Channel Event Activity

Channel Event Listing

Interactive Channel ID

int32

identifier

[Interact Model].[Event Common].[Interactive Channel ID]

Interactive Channel Name

characterLength16

attribute

[Interact Model].[Event Common].[Interactive Channel Name]

Category ID

int32

identifier

[Interact Model].[Event Common].[Category ID]

Category Name

characterLength16

attribute

[Interact Model].[Event Common].[Category Name]

Event ID

int32

identifier

[Interact Model].[Event Common].[Event ID]

Event Name

characterLength16

attribute

[Interact Model].[Event Common].[Event Name]

Total Occurrences

int32

fact

IF ([Interact Model].[Event Common].[Occurrences] is missing) THEN (0) ELSE ([Interact Model].[Event Common].[Occurrences])

Channel Event Activity 7 Days

Interactive Channel ID

int32

identifier

[Interact Model].[Event Common by Day].[Interactive Channel ID]

Interactive Channel Name

characterLength16

attribute

[Interact Model].[Event Common by Day].[Interactive Channel Name]

Category ID

int32

identifier

[Interact Model].[Event Common by Day].[Category ID]

Category Name

characterLength16

attribute

[Interact Model].[Event Common by Day].[Category Name]

Event ID

int32

identifier

[Interact Model].[Event Common by Day].[Event ID]

Event Name

characterLength16

attribute

[Interact Model].[Event Common by Day].[Event Name]

Actual Date

date

attribute

[Interact Model].[Event Common by Day].[Actual Date]

Occurrences

int32

fact

IF ([Interact Model].[Event Activity Day].[Occurrences] is missing) THEN (0) ELSE ([Interact Model].[Event Activity Day].[Occurrences])

Peak Day

date

attribute

[Interact Model].[Peak Day].[Peak Day]

Max Occurrences

int32

fact

[Interact Model].[Peak Day].[Max Occurrences]

Slowest Day

date

attribute

[Interact Model].[Slow Day].[Slowest Day]

Min Occurrences

int32

fact

[Interact Model].[Slow Day].[Min Occurrences]

Channel Event Activity 24 Hrs

Interactive Channel ID

decimal

identifier

[Interact Model].[Event Common by Hour].[Interactive Channel ID]

Interactive Channel Name

characterLength16

attribute

[Interact Model].[Event Common by Hour].[Interactive Channel Name]

Category ID

decimal

identifier

[Interact Model].[Event Common by Hour].[Category ID]

Category Name

characterLength16

attribute

[Interact Model].[Event Common by Hour].[Category Name]

Event ID

decimal

identifier

[Interact Model].[Event Common by Hour].[Event ID]

Event Name

characterLength16

attribute

[Interact Model].[Event Common by Hour].[Event Name]

Actual Date

date

attribute

[Interact Model].[Event Common by Hour].[Actual Date]

Hour

float64

attribute

[Interact Model].[Event Common by Hour].[Hour]

Occurrences

float64

fact

IF ([Interact Model].[Event Activity HR].[Occurrences] is missing) THEN (0) ELSE ([Interact Model].[Event Activity HR].[Occurrences])

Peak Day

date

attribute

[Interact Model].[Peak Hour].[Peak Day]

Peak Hour

int64

attribute

[Interact Model].[Peak Hour].[Peak Hour]

Max Occurrences

float64

fact

[Interact Model].[Peak Hour].[Max Occur]

Slowest Day

date

attribute

[Interact Model].[Slow Hour].[Slowest Day]

Slowest Hour

int64

attribute

[Interact Model].[Slow Hour].[Slowest Hour]

Min Occurrences

float64

fact

[Interact Model].[Slow Hour].[Min Occur]

Common Views

Campaign View

(shortcut)

[Interact Model].[Campaign]

Calendar View

(shortcut)

[Interact Model].[Calendar]

Time View

(shortcut)

[Interact Model].[Time]

Last 24 Hours View

(shortcut)

[Interact Model].[Last 24 Hours Lookup]

Model View

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Common

Campaign

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CAMPAIGN].[CAMPAIGNID]

Campaign Name

characterLength16

attribute

[InteractDTDS].[UARI_CAMPAIGN].[NAME]

Description

characterLength16

attribute

[InteractDTDS].[UARI_CAMPAIGN].[DESCRIPTION]

Campaign Code

characterLength16

attribute

[InteractDTDS].[UARI_CAMPAIGN].[CAMPAIGNCODE]

Objectives

characterLength16

attribute

[InteractDTDS].[UARI_CAMPAIGN].[OBJECTIVES]

Last Run Date

dateTime

attribute

[InteractDTDS].[UARI_CAMPAIGN].[LASTRUNDATE]

Initiative

characterLength16

attribute

[InteractDTDS].[UARI_CAMPAIGN].[INITIATIVE]

Created Date

dateTime

attribute

[InteractDTDS].[UARI_CAMPAIGN].[CREATEDATE]

Start Date

dateTime

attribute

[InteractDTDS].[UARI_CAMPAIGN].[STARTDATE]

End Date

dateTime

identifier

[InteractDTDS].[UARI_CAMPAIGN].[ENDDATE]

Offer

Offer ID

decimal

identifier

[InteractDTDS].[UARI_OFFER].[OFFERID]

Offer Name

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[NAME]

Offer Description

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[DESCRIPTION]

Offer Code 1

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[OFFERCODE1]

Offer Code 2

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[OFFERCODE2]

Offer Code 3

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[OFFERCODE3]

Offer Code 4

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[OFFERCODE4]

Offer Code 5

characterLength16

attribute

[InteractDTDS].[UARI_OFFER].[OFFERCODE5]

Cells

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CELLS].[CELLID]

Cell Name

characterLength16

attribute

[InteractDTDS].[UARI_CELLS].[CELLNAME]

Cell Code

characterLength16

attribute

[InteractDTDS].[UARI_CELLS].[CELLCODE]

Control Cell ID

decimal

identifier

[InteractDTDS].[UARI_CELLS].[CONTROLCELLID]

Is Control

int64

attribute

[InteractDTDS].[UARI_CELLS].[ISCONTROL]

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CELLS].[CAMPAIGNID]

Eligible Stat

Sequence Number

decimal

identifier

[InteractRTDS].[UARI_ELIGSTAT].[SEQNUM]

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_ELIGSTAT].[ICID]

Interactive Channel

characterLength16

attribute

[InteractRTDS].[UARI_ELIGSTAT].[ICNAME]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_ELIGSTAT].[OFFERID]

Offer Name

characterLength16

attribute

[InteractRTDS].[UARI_ELIGSTAT].[OFFERNAME]

Time ID

decimal

fact

[InteractRTDS].[UARI_ELIGSTAT].[TIMEID]

Date ID

decimal

fact

[InteractRTDS].[UARI_ELIGSTAT].[DATEID]

Cell ID

decimal

fact

[InteractRTDS].[UARI_ELIGSTAT].[CELLID]

Cell Name

characterLength16

attribute

[InteractRTDS].[UARI_ELIGSTAT].[CELLNAME]

Cell Code

characterLength16

attribute

[InteractRTDS].[UARI_ELIGSTAT].[CELLCODE]

Interaction Point ID

decimal

fact

[InteractRTDS].[UARI_ELIGSTAT].[IPID]

Interaction Point

characterLength16

attribute

[InteractRTDS].[UARI_ELIGSTAT].[IPNAME]

Eligible Opportunities

decimal

fact

[InteractRTDS].[UARI_ELIGSTAT].[ELIGIBLEOPPS]

Defaulted Stat

Sequence Number

decimal

identifier

[InteractRTDS].[UARI_DEFAULTEDSTAT].[SEQNUM]

Time ID

decimal

identifier

[InteractRTDS].[UARI_DEFAULTEDSTAT].[TIMEID]

Date ID

decimal

identifier

[InteractRTDS].[UARI_DEFAULTEDSTAT].[DATEID]

Segment ID

decimal

identifier

[InteractRTDS].[UARI_DEFAULTEDSTAT].[SEGMENTID]

Segment

characterLength16

attribute

[InteractRTDS].[UARI_DEFAULTEDSTAT].[SEGMENTNAME]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_DEFAULTEDSTAT].[IPID]

Interaction Point

characterLength16

attribute

[InteractRTDS].[UARI_DEFAULTEDSTAT].[IPNAME]

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_DEFAULTEDSTAT].[ICID]

Defaulted

decimal

fact

[InteractRTDS].[UARI_DEFAULTEDSTAT].[OCCURRENCES]

Treatment Rule Inventory Campaign to Offer

Offer ID

decimal

identifier

[InteractDTDS].[UARI_TRI_CAMP_OFF].[OFFERID]

Offer Name

characterLength16

attribute

[InteractDTDS].[UARI_TRI_CAMP_OFF].[OFFERNAME]

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNID]

Campaign Name

characterLength16

attribute

[InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNNAME]

Campaign Code

characterLength16

attribute

[InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNCODE]

Localization Lookup

Lookup ID

int64

fact

[InteractDTDS].[UARI_LOOKUP].[LKUP_ID]

Lookup Code

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LKUP_CODE]

Lookup Type

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LKUP_TYPE]

Description

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[DESCRIPTION]

Locale

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LOCALE]

Localized String

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LOCALIZED_STRING]

Calendar

Date ID

decimal

identifier

[InteractDTDS].[UARI_CALENDAR].[DATEID]

Year

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[YEAR]

Fiscal Year

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[FISCALYEAR]

Quarter

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[QUARTER]

Fiscal Quarter

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[FISCALQUARTER]

Month

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[MONTH]

Week of Year

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[WEEKOFYEAR]

Week of Month

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[WEEKOFMONTH]

Day of Year

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[DAYOFYEAR]

Day of Month

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[DAYOFMONTH]

Day of Week

int64

attribute

[InteractDTDS].[UARI_CALENDAR].[DAYOFWEEK]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE]

First Day of Week

dateTime

attribute

[InteractDTDS].[UARI_CALENDAR].[FIRSTDAYOFWEEK]

Last Day of Week

dateTime

attribute

[InteractDTDS].[UARI_CALENDAR].[LASTDAYOFWEEK]

Time

Time ID

decimal

identifier

[InteractDTDS].[UARI_TIME].[TIMEID]

Hour

int64

identifier

[InteractDTDS].[UARI_TIME].[HOUR]

Minute

int64

identifier

[InteractDTDS].[UARI_TIME].[MINUTE]

Last 14 Days Calendar

Date ID

decimal

identifier

[Interact Model].[Calendar].[Date ID]

Year

int64

attribute

[Interact Model].[Calendar].[Year]

Fiscal Year

int64

attribute

[Interact Model].[Calendar].[Fiscal Year]

Quarter

int64

attribute

[Interact Model].[Calendar].[Quarter]

Fiscal Quarter

int64

attribute

[Interact Model].[Calendar].[Fiscal Quarter]

Month

int64

attribute

[Interact Model].[Calendar].[Month]

Week of Year

int64

attribute

[Interact Model].[Calendar].[Week of Year]

Week of Month

int64

attribute

[Interact Model].[Calendar].[Week of Month]

Day of Year

int64

attribute

[Interact Model].[Calendar].[Day of Year]

Day of Month

int64

attribute

[Interact Model].[Calendar].[Day of Month]

Day of Week

int64

attribute

[Interact Model].[Calendar].[Day of Week]

Actual Date

dateTime

identifier

[Interact Model].[Calendar].[Actual Date]

First Day of Week

dateTime

attribute

[Interact Model].[Calendar].[First Day of Week]

Last Day of Week

dateTime

attribute

[Interact Model].[Calendar].[Last Day of Week]

Last 24 Hours Lookup

Hour

decimal

attribute

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Summary

Interactive Channel by Offer Number of Times Presented

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_OCH].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_OCH].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_OCH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_OCH].[IPNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_ICP_OCH].[OFFERID]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_OCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_OCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_OCH].[NUM_PRES_RANDOM]

Interactive Channel by Offer Elig Opps

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_ICP_OES].[ICID]

Interactive Channel

characterLength16

attribute

[InteractRTDS].[UARI_ICP_OES].[ICNAME]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_ICP_OES].[IPID]

Interaction Point

characterLength16

attribute

[InteractRTDS].[UARI_ICP_OES].[IPNAME]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_ICP_OES].[OFFERID]

Eligible Opportunities

float64

fact

IF([InteractRTDS].[UARI_ICP_OES].[ELIGIBLEOPPS] is missing) THEN(0) ELSE([InteractRTDS].[UARI_ICP_OES].[ELIGIBLEOPPS])

Interactive Channel by Offer Response History

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_ORH].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_ORH].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_ORH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_ORH].[IPNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_ICP_ORH].[OFFERID]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_ORH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_ORH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_ORH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_ORH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by Offer Performance Summary Star Schema	Offer	(shortcut)	[Interact Model].[Offer]
	Interactive Channel by Offer Number of Times Presented	(shortcut)	[Interact Model].[Interactive Channel by Offer Number of Times Presented]
	Interactive Channel by Offer Elig Opps	(shortcut)	[Interact Model].[Interactive Channel by Offer Elig Opps]
	Interactive Channel by Offer Response History	(shortcut)	[Interact Model].[Interactive Channel by Offer Response History]

By Day

Interactive Channel by Offer Number of Times Presented by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_OCH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_OCH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_OCH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_OCH_DY].[IPNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_ICP_OCH_DY].[OFFERID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_OCH_DY].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_OCH_DY].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_OCH_DY].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_OCH_DY].[NUM_PRES_RANDOM]

Interactive Channel by Offer Elig Opps by Day

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_ICP_OES_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractRTDS].[UARI_ICP_OES_DY].[ICNAME]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_ICP_OES_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractRTDS].[UARI_ICP_OES_DY].[IPNAME]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_ICP_OES_DY].[OFFERID]

Actual Date

dateTime

identifier

[InteractRTDS].[UARI_ICP_OES_DY].[ACTUALDATE]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_ICP_OES_DY].[ELIGIBLEOPPS]

Interactive Channel by Offer Response History by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_ORH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_ORH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_ORH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_ORH_DY].[IPNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_ICP_ORH_DY].[OFFERID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_ORH_DY].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by Offer Performance by Day Star Schema	Offer	(shortcut)	[Interact Model].[Offer]
	Interactive Channel by Offer Number of Times Presented by Day	(shortcut)	[Interact Model].[Interactive Channel by Offer Number of Times Presented by Day]
	Interactive Channel by Offer Elig Opps by Day	(shortcut)	[Interact Model].[Interactive Channel by Offer Elig Opps by Day]
	Interactive Channel by Offer Response History by Day	(shortcut)	[Interact Model].[Interactive Channel by Offer Response History by Day]
	Calendar	(shortcut)	[Interact Model].[Calendar]

By Hour

Interactive Channel by Offer Number of Times Presented by Hour

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_OCH_HR].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_OCH_HR].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_OCH_HR].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_OCH_HR].[IPNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_ICP_OCH_HR].[OFFERID]

Hour

int64

identifier

[InteractDTDS].[UARI_ICP_OCH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_OCH_HR].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_OCH_HR].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_OCH_HR].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_OCH_HR].[NUM_PRES_RANDOM]

Interactive Channel by Offer Respone History by Hour

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_ORH_HR].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_ORH_HR].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_ORH_HR].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_ORH_HR].[IPNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_ICP_ORH_HR].[OFFERID]

Hour

int64

identifier

[InteractDTDS].[UARI_ICP_ORH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_ORH_HR].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by Offer Performance by Hour Star Schema	Offer	(shortcut)	[Interact Model].[Offer]
	Interactive Channel by Offer Number of Times Presented by Hour	(shortcut)	[Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour]
	Interactive Channel by Offer Respone History by Hour	(shortcut)	[Interact Model].[Interactive Channel by Offer Respone History by Hour]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Segment Summary

Interactive Channel by Segment Number of Times Presented

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGCH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH].[SEGMENT_NAME]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH].[NUM_PRES_RANDOM]

Interactive Channel by Segment Times Defaulted

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_ICP_SEGDS].[ICID]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_ICP_SEGDS].[IPID]

Segment ID

decimal

identifier

[InteractRTDS].[UARI_ICP_SEGDS].[SEGMENTID]

Defaulted

float64

fact

[InteractRTDS].[UARI_ICP_SEGDS].[NUM_OF_OCCURRENCES]

Interactive Channel by Segment Response History

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGRH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH].[SEGMENT_NAME]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by Segment Summary Star Schema	Interactive Channel by Segment Number of Times Presented	(shortcut)	[Interact Model].[Interactive Channel by Segment Number of Times Presented]
	Interactive Channel by Segment Times Defaulted	(shortcut)	[Interact Model].[Interactive Channel by Segment Times Defaulted]
	Interactive Channel by Segment Response History	(shortcut)	[Interact Model].[Interactive Channel by Segment Response History]

Segment by Day

Interactive Channel by Segment Number of Times Presented by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENT_NAME]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM]

Interactive Channel by Segment Response History by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENT_NAME]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Query Item	Type	Usage	Ref Obj/Expr.
Interactive Channel by Segment by Day Star Schema	Interactive Channel by Segment Number of Times Presented by Day		(shortcut)		[Interact Model].[Interactive Channel by Segment Number of Times Presented by Day]
Interactive Channel by Segment by Day Star Schema	Interactive Channel by Segment Response History by Day		(shortcut)		[Interact Model].[Interactive Channel by Segment Response History by Day]

Segment by Hour

Interactive Channel by Segment Number of Times Presented by Hour

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH_HR].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_HR].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGCH_HR].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_HR].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH_HR].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_HR].[SEGMENT_NAME]

Hour

int64

identifier

[InteractDTDS].[UARI_ICP_SEGCH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_SEGCH_HR].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_PRES_RANDOM]

Interactive Channel by Segment Response History by Hour

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH_HR].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_HR].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGRH_HR].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_HR].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH_HR].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_HR].[SEGMENT_NAME]

Hour

int64

identifier

[InteractDTDS].[UARI_ICP_SEGRH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_SEGRH_HR].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Query Item	Type	Usage	Ref Obj/Expr.
Interactive Channel by Segment by Hour Star Schema	Interactive Channel by Segment Number of Times Presented by Hour		(shortcut)		[Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour]
Interactive Channel by Segment by Hour Star Schema	Interactive Channel by Segment Response History by Hour		(shortcut)		[Interact Model].[Interactive Channel by Segment Response History by Hour]

Cumulative Segment by Day

Cumulative Interactive Channel by Segment Number of Times Presented by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENT_NAME]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_SEGCH_DY].[ACTUALDATE]

Presented

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES])

Presented Model-Driven

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN])

Presented Random

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM])

Cumulative Presented

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] )

Cumulative Presented Model-Driven

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] )

Cumulative Presented Random

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented Random] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] )

Cumulative Interactive Channel by Segment Response History by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPNAME]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENT_NAME]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_SEGRH_DY].[ACTUALDATE]

Accepted

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP])

Accepted Model-Driven

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN])

Accepted Random

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM])

Rejected

float64

fact

IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ])

Cumulative Accepted

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] )

Cumulative Accepted Model-Driven

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted Model-Driven] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] )

Cumulative Accepted Random

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted Random] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] )

Cumulative Rejected

float64

fact

running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Rejected] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] )

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Cumulative Interactive Channel by Segment by Day Star Schema	Cumulative Interactive Channel by Segment Number of Times Presented by Day	(shortcut)	[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day]
	Cumulative Interactive Channel by Segment Response History by Day	(shortcut)	[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day]
	Last 14 Days Calendar	(shortcut)	[Interact Model].[Last 14 Days Calendar]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Interaction Point Summary

Interactive Channel by IP Number of Times Presented

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_IPCH].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPCH].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_IPCH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPCH].[IPNAME]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_IPCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_IPCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_IPCH].[NUM_PRES_RANDOM]

Interactive Channel by IP Times Defaulted

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_ICP_IPDS].[ICID]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_ICP_IPDS].[IPID]

Defaulted

float64

fact

[InteractRTDS].[UARI_ICP_IPDS].[NUM_OF_OCCURRENCES]

Interactive Channel by IP Response History

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_IPRH].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPRH].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_IPRH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPRH].[IPNAME]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_IPRH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_IPRH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_IPRH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_IPRH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by IP Summary Star Schema	Interactive Channel by IP Number of Times Presented	(shortcut)	[Interact Model].[Interactive Channel by IP Number of Times Presented]
	Interactive Channel by IP Times Defaulted	(shortcut)	[Interact Model].[Interactive Channel by IP Times Defaulted]
	Interactive Channel by IP Response History	(shortcut)	[Interact Model].[Interactive Channel by IP Response History]

Interaction Point by Day

Interactive Channel by IP Number of Times Presented by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_IPCH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPCH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_IPCH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPCH_DY].[IPNAME]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_IPCH_DY].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_PRES_RANDOM]

Interactive Channel by IP Response History by Day

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_IPRH_DY].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPRH_DY].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_IPRH_DY].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPRH_DY].[IPNAME]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_IPRH_DY].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_TIME_REJ]

InteractiveChannelToCalendar

Date ID

decimal

identifier

[InteractDTDS].[UARI_CALENDAR].[DATEID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE]

Interactive Channel ID

decimal

identifier

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel]

Interaction Point ID

float64

identifier

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by IP by Day Star Schema	Interactive Channel by IP Number of Times Presented by Day	(shortcut)	[Interact Model].[Interactive Channel by IP Number of Times Presented by Day]
	Interactive Channel by IP Response History by Day	(shortcut)	[Interact Model].[Interactive Channel by IP Response History by Day]
	InteractiveChannelToCalendar	(shortcut)	[Interact Model].[InteractiveChannelToCalendar]

Interaction Point by Hour

Interactive Channel by IP Number of Times Presented by Hour

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_IPCH_HR].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPCH_HR].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_IPCH_HR].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPCH_HR].[IPNAME]

Hour

int64

identifier

[InteractDTDS].[UARI_ICP_IPCH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_IPCH_HR].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_PRES_RANDOM]

Interactive Channel by IP Response History by Hour

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_ICP_IPRH_HR].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPRH_HR].[ICNAME]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_ICP_IPRH_HR].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_ICP_IPRH_HR].[IPNAME]

Hour

int64

identifier

[InteractDTDS].[UARI_ICP_IPRH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_ICP_IPRH_HR].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_TIME_REJ]

Interactive Channel - Last 24 Hours Lookup

Hour

float64

attribute

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE]

Interactive Channel ID

decimal

identifier

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID]

Interactive Channel

characterLength16

attribute

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel]

Interaction Point ID

float64

identifier

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID]

Interaction Point

characterLength16

attribute

[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel by IP by Hour Star Schema	Interactive Channel by IP Number of Times Presented by Hour	(shortcut)	[Interact Model].[Interactive Channel by IP Number of Times Presented by Hour]
	Interactive Channel by IP Response History by Hour	(shortcut)	[Interact Model].[Interactive Channel by IP Response History by Hour]
	Last 24 Hours	(shortcut)	[Interact Model].[Last 24 Hours Lookup]
	Interactive Channel - Last 24 Hours Lookup	(shortcut)	[Interact Model].[Interactive Channel - Last 24 Hours Lookup]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Campaign Cell Summary

Campaign Cell Performance Number of Times Presented

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH].[CELLID]

Presented

float64

fact

[InteractDTDS].[UARI_CCP_CH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_CH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_CCP_CH].[NUM_PRES_RANDOM]

Campaign Cell Performance Elig Opps

Campaign ID

int64

identifier

[InteractRTDS].[UARI_CCP_ES].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_CCP_ES].[CELLID]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_CCP_ES].[ELIGIBLEOPPS]

Campaign Cell Performance Response History

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH].[CELLID]

Accepted

float64

fact

[InteractDTDS].[UARI_CCP_RH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_RH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_CCP_RH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_CCP_RH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Cell Performance Summary Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Cells	(shortcut)	[Interact Model].[Cells]
	Campaign Cell Performance Number of Times Presented	(shortcut)	[Interact Model].[Campaign Cell Performance Number of Times Presented]
	Campaign Cell Performance Elig Opps	(shortcut)	[Interact Model].[Campaign Cell Performance Elig Opps]
	Campaign Cell Performance Response History	(shortcut)	[Interact Model].[Campaign Cell Performance Response History]

Campaign Cell by Day

Campaign Cell Number of Times Presented by Day

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH_DY].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH_DY].[CELLID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CCP_CH_DY].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM]

Campaign Cell Performance Elig Opps by Day

Campaign ID

int64

identifier

[InteractRTDS].[UARI_CCP_ES_DY].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_CCP_ES_DY].[CELLID]

Actual Date

dateTime

identifier

[InteractRTDS].[UARI_CCP_ES_DY].[ACTUALDATE]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS]

Campaign Cell Performance Response History by Day

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH_DY].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH_DY].[CELLID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CCP_RH_DY].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ]

CellToCalendar

Date ID

decimal

identifier

[InteractDTDS].[UARI_CALENDAR].[DATEID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE]

Cell ID

decimal

identifier

[Interact Model].[Cells].[Cell ID]

Cell Name

characterLength16

attribute

[Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Interact Model].[Cells].[Cell Code]

Control Cell ID

decimal

identifier

[Interact Model].[Cells].[Control Cell ID]

Is Control

int64

attribute

[Interact Model].[Cells].[Is Control]

Campaign ID

decimal

identifier

[Interact Model].[Cells].[Campaign ID]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Cell Performance by Day Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Campaign Cell Number of Times Presented by Day	(shortcut)	[Interact Model].[Campaign Cell Number of Times Presented by Day]
	Campaign Cell Performance Elig Opps by Day	(shortcut)	[Interact Model].[Campaign Cell Performance Elig Opps by Day]
	Campaign Cell Performance Response History by Day	(shortcut)	[Interact Model].[Campaign Cell Performance Response History by Day]
	CellToCalendar	(shortcut)	[Interact Model].[CellToCalendar]

Campaign Cell by Hour

Campaign Cell Number of Times Presented by Hour

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH_HR].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH_HR].[CELLID]

Hour

int64

identifier

[InteractDTDS].[UARI_CCP_CH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CCP_CH_HR].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_CCP_CH_HR].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_CH_HR].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_CCP_CH_HR].[NUM_PRES_RANDOM]

Campaign Cell Performance Elig Opps by Hour

Campaign ID

int64

identifier

[InteractRTDS].[UARI_CCP_ES_HR].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_CCP_ES_HR].[CELLID]

Hour

int64

identifier

[InteractRTDS].[UARI_CCP_ES_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractRTDS].[UARI_CCP_ES_HR].[ACTUALDATE]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_CCP_ES_HR].[ELIGIBLEOPPS]

Campaign Cell Performance Response History by Hour

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH_HR].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH_HR].[CELLID]

Hour

int64

identifier

[InteractDTDS].[UARI_CCP_RH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CCP_RH_HR].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_CCP_RH_HR].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_RH_HR].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_CCP_RH_HR].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_CCP_RH_HR].[NUM_TIME_REJ]

Cell - Last 24 Hours Lookup

Hour

float64

attribute

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE]

Cell ID

decimal

identifier

[Interact Model].[Cells].[Cell ID]

Cell Name

characterLength16

attribute

[Interact Model].[Cells].[Cell Name]

Cell Code

characterLength16

attribute

[Interact Model].[Cells].[Cell Code]

Control Cell ID

decimal

identifier

[Interact Model].[Cells].[Control Cell ID]

Is Control

int64

attribute

[Interact Model].[Cells].[Is Control]

Campaign ID

decimal

identifier

[Interact Model].[Cells].[Campaign ID]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Cell Performance by Hour Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Cells	(shortcut)	[Interact Model].[Cells]
	Campaign Cell Number of Times Presented by Hour	(shortcut)	[Interact Model].[Campaign Cell Number of Times Presented by Hour]
	Campaign Cell Performance Elig Opps by Hour	(shortcut)	[Interact Model].[Campaign Cell Performance Elig Opps by Hour]
	Campaign Cell Performance Response History by Hour	(shortcut)	[Interact Model].[Campaign Cell Performance Response History by Hour]
	Cell - Last 24 Hours Lookup	(shortcut)	[Interact Model].[Cell - Last 24 Hours Lookup]

Cumulative Campaign Cell by Day

Cumulative Campaign Cell Number of Times Presented by Day

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH_DY].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_CH_DY].[CELLID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CCP_CH_DY].[ACTUALDATE]

Presented

float64

fact

IF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES])

Presented Model-Driven

float64

fact

IF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN])

Presented Random

float64

fact

IF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM])

Cumulative Presented

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] )

Cumulative Presented Model-Driven

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] )

Cumulative Presented Random

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented Random] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] )

Cumulative Campaign Cell Performance Elig Opps by Day

Campaign ID

decimal

identifier

[InteractRTDS].[UARI_CCP_ES_DY].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_CCP_ES_DY].[CELLID]

Actual Date

dateTime

identifier

[InteractRTDS].[UARI_CCP_ES_DY].[ACTUALDATE]

Eligible Opportunities

float64

fact

IF([InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS] is missing) THEN(0) ELSE([InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS])

Cumulative Eligible Opportunities

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] AT [Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Cell ID] )

Cumulative Campaign Cell Performance Response History by Day

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH_DY].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_RH_DY].[CELLID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CCP_RH_DY].[ACTUALDATE]

Accepted

float64

fact

IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP])

Accepted Model-Driven

float64

fact

IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN])

Accepted Random

float64

fact

IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM])

Rejected

float64

fact

IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ])

Cumulative Accepted

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] )

Cumulative Accepted Model-Driven

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted Model-Driven] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] )

Cumulative Accepted Random

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted Random] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] )

Cumulative Rejected

float64

fact

running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Rejected] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] )

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Cumulative Campaign Cell Performance by Day Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Cells	(shortcut)	[Interact Model].[Cells]
	Cumulative Campaign Cell Number of Times Presented by Day	(shortcut)	[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day]
	Cumulative Campaign Cell Performance Response History by Day	(shortcut)	[Interact Model].[Cumulative Campaign Cell Performance Response History by Day]
	Last 14 Days Calendar	(shortcut)	[Interact Model].[Last 14 Days Calendar]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Campaign Cell by Offer Summary

Campaign Cell by Offer Number of Times Presented

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_OCH].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_OCH].[CELLID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_CCP_OCH].[OFFERID]

Presented

float64

fact

[InteractDTDS].[UARI_CCP_OCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_OCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_CCP_OCH].[NUM_PRES_RANDOM]

Campaign Cell by Offer Elig Opps

Campaign ID

int64

identifier

[InteractRTDS].[UARI_CCP_OES].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_CCP_OES].[CELLID]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_CCP_OES].[OFFERID]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_CCP_OES].[ELIGIBLEOPPS]

Campaign Cell by Offer Response History

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_ORH].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_ORH].[CELLID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_CCP_ORH].[OFFERID]

Accepted

float64

fact

[InteractDTDS].[UARI_CCP_ORH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_ORH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_CCP_ORH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_CCP_ORH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Cell by Offer Performance Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Offer	(shortcut)	[Interact Model].[Offer]
	Cells	(shortcut)	[Interact Model].[Cells]
	Campaign Cell by Offer Number of Times Presented	(shortcut)	[Interact Model].[Campaign Cell by Offer Number of Times Presented]
	Campaign Cell by Offer Elig Opps	(shortcut)	[Interact Model].[Campaign Cell by Offer Elig Opps]
	Campaign Cell by Offer Response History	(shortcut)	[Interact Model].[Campaign Cell by Offer Response History]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Campaign Cell by Interaction Point Summaries

Campaign Cell by IP Number of Times Presented

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_IPCH].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_IPCH].[CELLID]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_CCP_IPCH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_CCP_IPCH].[IPNAME]

Presented

float64

fact

[InteractDTDS].[UARI_CCP_IPCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_IPCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_CCP_IPCH].[NUM_PRES_RANDOM]

Campaign Cell by IP Elig Opps

Campaign ID

int64

fact

[InteractRTDS].[UARI_CCP_IPES].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_CCP_IPES].[CELLID]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_CCP_IPES].[IPID]

Interaction Point

characterLength16

attribute

[InteractRTDS].[UARI_CCP_IPES].[IPNAME]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_CCP_IPES].[ELIGIBLEOPPS]

Campaign Cell by IP Response History

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_CCP_IPRH].[CAMPAIGNID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_CCP_IPRH].[CELLID]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_CCP_IPRH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_CCP_IPRH].[IPNAME]

Accepted

float64

fact

[InteractDTDS].[UARI_CCP_IPRH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_CCP_IPRH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_CCP_IPRH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_CCP_IPRH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Cell by IP Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Cells	(shortcut)	[Interact Model].[Cells]
	Campaign Cell by IP Number of Times Presented	(shortcut)	[Interact Model].[Campaign Cell by IP Number of Times Presented]
	Campaign Cell by IP Elig Opps	(shortcut)	[Interact Model].[Campaign Cell by IP Elig Opps]
	Campaign Cell by IP Response History	(shortcut)	[Interact Model].[Campaign Cell by IP Response History]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Campaign Offer Summary

Campaign Offer Number of Times Presented

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_CH].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_CH].[OFFERID]

Presented

float64

fact

[InteractDTDS].[UARI_COP_CH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_CH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_COP_CH].[NUM_PRES_RANDOM]

Campaign Offer Elig Opps

Campaign ID

float64

identifier

[InteractRTDS].[UARI_COP_ES].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_COP_ES].[OFFERID]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_COP_ES].[ELIGIBLEOPPS]

Campaign Offer Response History

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_RH].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_RH].[OFFERID]

Accepted

float64

fact

[InteractDTDS].[UARI_COP_RH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_RH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_COP_RH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_COP_RH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Offer Performance Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Offer	(shortcut)	[Interact Model].[Offer]
	Campaign Offer Number of Times Presented	(shortcut)	[Interact Model].[Campaign Offer Number of Times Presented]
	Campaign Offer Elig Opps	(shortcut)	[Interact Model].[Campaign Offer Elig Opps]
	Campaign Offer Response History	(shortcut)	[Interact Model].[Campaign Offer Response History]

Campaign Offer by Day

Campaign Offer Number of Times Presented by Day

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_CH_DY].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_CH_DY].[OFFERID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_COP_CH_DY].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_COP_CH_DY].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_CH_DY].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_COP_CH_DY].[NUM_PRES_RANDOM]

Campaign Offer Elig Opps by Day

Campaign ID

float64

identifier

[InteractRTDS].[UARI_COP_ES_DY].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_COP_ES_DY].[OFFERID]

Actual Date

dateTime

identifier

[InteractRTDS].[UARI_COP_ES_DY].[ACTUALDATE]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_COP_ES_DY].[ELIGIBLEOPPS]

Campaign Offer Response History by Day

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_RH_DY].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_RH_DY].[OFFERID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_COP_RH_DY].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_COP_RH_DY].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_RH_DY].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_COP_RH_DY].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_COP_RH_DY].[NUM_TIME_REJ]

OfferToCalendar

Date ID

decimal

identifier

[InteractDTDS].[UARI_CALENDAR].[DATEID]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE]

Offer ID

decimal

identifier

[Interact Model].[Offer].[Offer ID]

Offer Name

characterLength16

attribute

[Interact Model].[Offer].[Offer Name]

Offer Description

characterLength16

attribute

[Interact Model].[Offer].[Offer Description]

Offer Code 1

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 1]

Offer Code 2

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 2]

Offer Code 3

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 3]

Offer Code 4

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 4]

Offer Code 5

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 5]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Offer by Day Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Campaign Offer Number of Times Presented by Day	(shortcut)	[Interact Model].[Campaign Offer Number of Times Presented by Day]
	Campaign Offer Elig Opps by Day	(shortcut)	[Interact Model].[Campaign Offer Elig Opps by Day]
	Campaign Offer Response History by Day	(shortcut)	[Interact Model].[Campaign Offer Response History by Day]
	OfferToCalendar	(shortcut)	[Interact Model].[OfferToCalendar]

Campaign Offer by Hour

Campaign Offer Number of Times Presented by Hour

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_CH_HR].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_CH_HR].[OFFERID]

Hour

int64

identifier

[InteractDTDS].[UARI_COP_CH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_COP_CH_HR].[ACTUALDATE]

Presented

float64

fact

[InteractDTDS].[UARI_COP_CH_HR].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_CH_HR].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_COP_CH_HR].[NUM_PRES_RANDOM]

Campaign Offer Elig Opps by Hour

Campaign ID

float64

identifier

[InteractRTDS].[UARI_COP_ES_HR].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_COP_ES_HR].[OFFERID]

Hour

int64

identifier

[InteractRTDS].[UARI_COP_ES_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractRTDS].[UARI_COP_ES_HR].[ACTUALDATE]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_COP_ES_HR].[ELIGIBLEOPPS]

Campaign Offer Response History by Hour

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_RH_HR].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_RH_HR].[OFFERID]

Hour

int64

identifier

[InteractDTDS].[UARI_COP_RH_HR].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[UARI_COP_RH_HR].[ACTUALDATE]

Accepted

float64

fact

[InteractDTDS].[UARI_COP_RH_HR].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_RH_HR].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_COP_RH_HR].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_COP_RH_HR].[NUM_TIME_REJ]

Offer-Last 24 Hours Lookup

Hour

float64

attribute

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR]

Actual Date

dateTime

identifier

[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE]

Offer ID

decimal

identifier

[Interact Model].[Offer].[Offer ID]

Offer Name

characterLength16

attribute

[Interact Model].[Offer].[Offer Name]

Offer Description

characterLength16

attribute

[Interact Model].[Offer].[Offer Description]

Offer Code 1

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 1]

Offer Code 2

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 2]

Offer Code 3

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 3]

Offer Code 4

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 4]

Offer Code 5

characterLength16

attribute

[Interact Model].[Offer].[Offer Code 5]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Offer by Hour Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Offer	(shortcut)	[Interact Model].[Offer]
	Campaign Offer Number of Times Presented by Hour	(shortcut)	[Interact Model].[Campaign Offer Number of Times Presented by Hour]
	Campaign Offer Elig Opps by Hour	(shortcut)	[Interact Model].[Campaign Offer Elig Opps by Hour]
	Campaign Offer Response History by Hour	(shortcut)	[Interact Model].[Campaign Offer Response History by Hour]
	Offer-Last 24 Hours Lookup	(shortcut)	[Interact Model].[Offer-Last 24 Hours Lookup]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Campaign Offer by Cell Summary

Campaign Offer by Cell Number of Times Presented

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_CCH].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_CCH].[OFFERID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_COP_CCH].[CELLID]

Presented

float64

fact

[InteractDTDS].[UARI_COP_CCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_CCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_COP_CCH].[NUM_PRES_RANDOM]

Campaign Offer by Cell Elig Opps

Campaign ID

int64

identifier

[InteractRTDS].[UARI_COP_CES].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_COP_CES].[OFFERID]

Cell ID

decimal

identifier

[InteractRTDS].[UARI_COP_CES].[CELLID]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_COP_CES].[ELIGIBLEOPPS]

Campaign Offer by Cell Response History

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_CRH].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_CRH].[OFFERID]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_COP_CRH].[CELLID]

Accepted

float64

fact

[InteractDTDS].[UARI_COP_CRH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_CRH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_COP_CRH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_COP_CRH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Offer Cell Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Offer	(shortcut)	[Interact Model].[Offer]
	Cells	(shortcut)	[Interact Model].[Cells]
	Campaign Offer by Cell Number of Times Presented	(shortcut)	[Interact Model].[Campaign Offer by Cell Number of Times Presented]
	Campaign Offer by Cell Elig Opps	(shortcut)	[Interact Model].[Campaign Offer by Cell Elig Opps]
	Campaign Offer by Cell Response History	(shortcut)	[Interact Model].[Campaign Offer by Cell Response History]

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Campaign Offer by Interaction Point Summary

Campaign Offer by IP Number of Times Presented

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_IPCH].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_IPCH].[OFFERID]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_COP_IPCH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_COP_IPCH].[IPNAME]

Presented

float64

fact

[InteractDTDS].[UARI_COP_IPCH].[NUM_TIMES_PRES]

Presented Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_IPCH].[NUM_PRES_MODELDRVN]

Presented Random

float64

fact

[InteractDTDS].[UARI_COP_IPCH].[NUM_PRES_RANDOM]

Campaign Offer by IP Elig Opps

Campaign ID

int64

identifier

[InteractRTDS].[UARI_COP_IPES].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractRTDS].[UARI_COP_IPES].[OFFERID]

Interaction Point ID

decimal

identifier

[InteractRTDS].[UARI_COP_IPES].[IPID]

Interaction Point

characterLength16

attribute

[InteractRTDS].[UARI_COP_IPES].[IPNAME]

Eligible Opportunities

float64

fact

[InteractRTDS].[UARI_COP_IPES].[ELIGIBLEOPPS]

Campaign Offer by IP Response History

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_COP_IPRH].[CAMPAIGNID]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_COP_IPRH].[OFFERID]

Interaction Point ID

float64

identifier

[InteractDTDS].[UARI_COP_IPRH].[IPID]

Interaction Point

characterLength16

attribute

[InteractDTDS].[UARI_COP_IPRH].[IPNAME]

Accepted

float64

fact

[InteractDTDS].[UARI_COP_IPRH].[NUM_TIMES_ACCP]

Accepted Model-Driven

float64

fact

[InteractDTDS].[UARI_COP_IPRH].[NUM_ACCP_MODELDRVN]

Accepted Random

float64

fact

[InteractDTDS].[UARI_COP_IPRH].[NUM_ACCP_RANDOM]

Rejected

float64

fact

[InteractDTDS].[UARI_COP_IPRH].[NUM_TIME_REJ]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Campaign Offer by Interaction Point Star Schema	Campaign	(shortcut)	[Interact Model].[Campaign]
	Offer	(shortcut)	[Interact Model].[Offer]
	Campaign Offer by IP Number of Times Presented	(shortcut)	[Interact Model].[Campaign Offer by IP Number of Times Presented]
	Campaign Offer by IP Elig Opps	(shortcut)	[Interact Model].[Campaign Offer by IP Elig Opps]
	Campaign Offer by IP Response History	(shortcut)	[Interact Model].[Campaign Offer by IP Response History]

Interactive Channel Deployment

Interactive Channel Deployment History

Deployment ID

decimal

identifier

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYMENTID]

Deployment Deploy Type ID

int64

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYDEPTYPEID]

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_DEPLOYMENT].[ICID]

Campaign ID

decimal

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[CAMPAIGNID]

Campaign Name

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[CAMPAIGNNAME]

StrategyID

decimal

identifier

[InteractDTDS].[UARI_DEPLOYMENT].[STRATEGYID]

Strategy Name

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[STRATEGYNAME]

Deployment Type ID

int64

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYTYPEID]

Deployment Type

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYTYPE]

Session ID

decimal

identifier

[InteractDTDS].[UARI_DEPLOYMENT].[SESSIONID]

Session Name

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[SESSIONNAME]

Flowchart ID

decimal

identifier

[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHARTID]

Flowchart Name

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHARTNAME]

Flowchart Type ID

int64

identifier

[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHDEPLOYTYPEID]

Flowchart Type

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHDEPLOYTYPE]

Audience Level

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[AUDIENCELEVEL]

Deployment Destination

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTDEST]

Deployment Server Group

int64

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTSVRGRP]

Deployment Owner

characterLength16

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTOWNER]

Time of Deployment

dateTime

attribute

[InteractDTDS].[UARI_DEPLOYMENT].[TIMEDEPLMNT]

Strategy Tab URL

characterLength16

attribute

#sq($Environment{'Redirect URL'})# + 'strategy&id=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[StrategyID] , integer), varchar(10)) + '&campaignID=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Campaign ID] , integer), varchar(10))

Flowchart Tab URL

characterLength16

attribute

#sq($Environment{'Redirect URL'})# + 'flowchart&id=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Flowchart ID] , integer), varchar(10)) + '&sessionID=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Session ID] , integer), varchar(10))

isProduction

Lookup ID

int64

fact

[Interact Model].[Localization Lookup].[Lookup ID]

Lookup Type

characterLength16

attribute

[Interact Model].[Localization Lookup].[Lookup Type]

Description

characterLength16

attribute

[Interact Model].[Localization Lookup].[Description]

Production Group

characterLength16

attribute

[Interact Model].[Localization Lookup].[Localized String]

Deployment Type

Lookup ID

int64

fact

[Interact Model].[Localization Lookup].[Lookup ID]

Lookup Type

characterLength16

attribute

[Interact Model].[Localization Lookup].[Lookup Type]

Description

characterLength16

attribute

[Interact Model].[Localization Lookup].[Description]

Deployment Type

characterLength16

attribute

[Interact Model].[Localization Lookup].[Localized String]

Flowchart Deployment Type

Lookup ID

int64

fact

[Interact Model].[Localization Lookup].[Lookup ID]

Lookup Type

characterLength16

attribute

[Interact Model].[Localization Lookup].[Lookup Type]

Description

characterLength16

attribute

[Interact Model].[Localization Lookup].[Description]

Flowchart Deployment Type

characterLength16

attribute

[Interact Model].[Localization Lookup].[Localized String]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Channel Deployment Star Schema	Interactive Channel Deployment History	(shortcut)	[Interact Model].[Interactive Channel Deployment History]
	isProduction	(shortcut)	[Interact Model].[isProduction]
	Deploy Type	(shortcut)	[Interact Model].[Deployment Type]
	Flowchart Deployment Type	(shortcut)	[Interact Model].[Flowchart Deployment Type]
	Campaign	(shortcut)	[Interact Model].[Campaign]

Campaign Interactive Offer Learning

Interactive Offer Learning

Offer ID

decimal

identifier

[InteractLearningDS].[UARI_LEARNING].[OFFERID]

Attribute Name

characterLength16

attribute

[InteractLearningDS].[UARI_LEARNING].[ATTRIBUTENAME]

Attribute Value

characterLength16

attribute

[InteractLearningDS].[UARI_LEARNING].[ATTRIBUTEVALUE]

Likelyhood of Response

float64

fact

[InteractLearningDS].[UARI_LEARNING].[ACCEPTPERCENTAGE]

Predictability

int64

attribute

[InteractLearningDS].[UARI_LEARNING].[PREDICTABILITY]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Interactive Offer Learning Star Schema	Interactive Offer Learning	(shortcut)	[Interact Model].[Interactive Offer Learning]
	Offer	(shortcut)	[Interact Model].[Offer]
	Treatment Rule Inventory Campaign to Offer	(shortcut)	[Interact Model].[Treatment Rule Inventory Campaign to Offer]

Treatment Rule Inventory Folder

Treatment Rule Inventory

Treatment Rule ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[TREATMENTRULEID]

Deployment ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[DEPLOYMENTID]

Interactive Channel ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[ICID]

Interactive Channel

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[ICNAME]

Cell ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[CELLID]

Cell Name

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[CELLNAME]

Zone ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[ZONEID]

Zone

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[ZONENAME]

Strategy ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[STRATEGYID]

Strategy Name

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[STRATEGYNAME]

Offer ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[OFFERID]

Offer Name

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[OFFERNAME]

Campaign ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNID]

Campaign Name

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNNAME]

Campaign Code

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNCODE]

Segment ID

decimal

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[SEGMENTID]

Segment

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[SEGMENTNAME]

Marketing Score

int64

fact

[InteractDTDS].[UARI_TRMTRULEINV].[MARKETINGSCORE]

Enable State ID

int64

identifier

[InteractDTDS].[UARI_TRMTRULEINV].[ENABLESTATEID]

Predicate State

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[PREDICATESTATE]

Predicate

characterLength16

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[PREDICATE]

Last Update Date

dateTime

attribute

[InteractDTDS].[UARI_TRMTRULEINV].[LASTUPDATE]

StrategyTab URL

characterLength16

attribute

#sq($Environment{'Redirect URL'})# + 'strategy&id=' + cast(cast([Interact Model].[Treatment Rule Inventory].[Strategy ID] , integer), varchar(10)) + '&campaignID=' + cast(cast([Interact Model].[Treatment Rule Inventory].[Campaign ID] , integer), varchar(10))

All Zones

characterLength16

attribute

[Interact Model].[All Zones].[All Zones]

All Zones

Lookup ID

int64

fact

[Interact Model].[Localization Lookup].[Lookup ID]

Lookup Code

characterLength16

attribute

[Interact Model].[Localization Lookup].[Lookup Code]

Lookup Type

characterLength16

attribute

[Interact Model].[Localization Lookup].[Lookup Type]

Description

characterLength16

attribute

[Interact Model].[Localization Lookup].[Description]

Locale

characterLength16

attribute

[Interact Model].[Localization Lookup].[Locale]

All Zones

characterLength16

attribute

[Interact Model].[Localization Lookup].[Localized String]

Predicate State

Lookup ID

int64

fact

[InteractDTDS].[UARI_LOOKUP].[LKUP_ID]

Lookup Code

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LKUP_CODE]

Lookup Type

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LKUP_TYPE]

Description

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[DESCRIPTION]

Locale

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LOCALE]

Predicate State

characterLength16

attribute

[InteractDTDS].[UARI_LOOKUP].[LOCALIZED_STRING]

Namespace/Folder	Query Subject	Type	Ref Obj/Expr.
Treatment Rule Inventory Star Schema	Treatment Rule Inventory	(shortcut)	[Interact Model].[Treatment Rule Inventory]
	Offer	(shortcut)	[Interact Model].[Offer]
	Cells	(shortcut)	[Interact Model].[Cells]
	Predicate State	(shortcut)	[Interact Model].[Predicate State]

Channel Event Activity

Last 24 Hours

(shortcut)

[Interact Model].[Last 24 Hours Lookup]

Channel Event Activity

Event Common

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_EV_ACT].[ICID]

Interactive Channel Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT].[ICNAME]

Category ID

decimal

identifier

[InteractRTDS].[UARI_EV_ACT].[CATEGORYID]

Category Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT].[CATEGORYNAME]

Event ID

decimal

identifier

[InteractRTDS].[UARI_EV_ACT].[EVENTID]

Event Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT].[EVENTNAME]

Occurrences

float64

fact

[InteractRTDS].[UARI_EV_ACT].[NUM_OCCURRENCES]

Event Common by Day

Interactive Channel ID

int32

identifier

[Interact Model].[Event Common].[Interactive Channel ID]

Interactive Channel Name

characterLength16

attribute

[Interact Model].[Event Common].[Interactive Channel Name]

Category ID

int32

identifier

[Interact Model].[Event Common].[Category ID]

Category Name

characterLength16

attribute

[Interact Model].[Event Common].[Category Name]

Event ID

int32

identifier

[Interact Model].[Event Common].[Event ID]

Event Name

characterLength16

attribute

[Interact Model].[Event Common].[Event Name]

Actual Date

dateTime

identifier

[Interact Model].[Last 7 Days Calendar].[Actual Date]

Event Activity Day

Interactive Channel ID

int32

identifier

[InteractRTDS].[UARI_EV_ACT_DY].[ICID]

Interactive Channel Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT_DY].[ICNAME]

Category ID

int32

identifier

[InteractRTDS].[UARI_EV_ACT_DY].[CATEGORYID]

Category Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT_DY].[CATEGORYNAME]

Event ID

int32

identifier

[InteractRTDS].[UARI_EV_ACT_DY].[EVENTID]

Event Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT_DY].[EVENTNAME]

Occurrences

int32

fact

[InteractRTDS].[UARI_EV_ACT_DY].[NUM_OCCURRENCES]

Actual Date

date

attribute

cast([InteractRTDS].[UARI_EV_ACT_DY].[ACTUALDATE], date)

Last 7 Days Calendar

Date ID

int32

identifier

[InteractDTDS].[UARI_CALENDAR].[DATEID]

Year

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[YEAR]

Fiscal Year

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[FISCALYEAR]

Quarter

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[QUARTER]

Fiscal Quarter

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[FISCALQUARTER]

Month

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[MONTH]

Week of Year

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[WEEKOFYEAR]

Week of Month

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[WEEKOFMONTH]

Day of Year

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[DAYOFYEAR]

Day of Month

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[DAYOFMONTH]

Day of Week

int32

attribute

[InteractDTDS].[UARI_CALENDAR].[DAYOFWEEK]

Actual Date

date

identifier

cast([InteractDTDS].[UARI_CALENDAR].[ACTUALDATE], date)

First Day of Week

dateTime

attribute

[InteractDTDS].[UARI_CALENDAR].[FIRSTDAYOFWEEK]

Last Day of Week

dateTime

attribute

[InteractDTDS].[UARI_CALENDAR].[LASTDAYOFWEEK]

Event Common by Hour

Interactive Channel ID

decimal

identifier

[Interact Model].[Event Common].[Interactive Channel ID]

Interactive Channel Name

characterLength16

attribute

[Interact Model].[Event Common].[Interactive Channel Name]

Category ID

decimal

identifier

[Interact Model].[Event Common].[Category ID]

Category Name

characterLength16

attribute

[Interact Model].[Event Common].[Category Name]

Event ID

decimal

identifier

[Interact Model].[Event Common].[Event ID]

Event Name

characterLength16

attribute

[Interact Model].[Event Common].[Event Name]

Actual Date

date

identifier

cast([Interact Model].[Last 24 Hours][Interact Model].[Last 24 Hours Lookup].[Actual Date], date)

Hour

float64

attribute

[Interact Model].[Last 24 Hours][Interact Model].[Last 24 Hours Lookup].[Hour]

Event Activity HR

Interactive Channel ID

decimal

identifier

[InteractRTDS].[UARI_EV_ACT_HR].[ICID]

Interactive Channel Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT_HR].[ICNAME]

Category ID

decimal

identifier

[InteractRTDS].[UARI_EV_ACT_HR].[CATEGORYID]

Cat Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT_HR].[CATEGORYNAME]

Event ID

decimal

identifier

[InteractRTDS].[UARI_EV_ACT_HR].[EVENTID]

Event Name

characterLength16

attribute

[InteractRTDS].[UARI_EV_ACT_HR].[EVENTNAME]

Occurrences

float64

fact

[InteractRTDS].[UARI_EV_ACT_HR].[NUM_OCCURRENCES]

Actual Date

date

attribute

cast([InteractRTDS].[UARI_EV_ACT_HR].[ACTUALDATE], date)

Hour

int64

attribute

[InteractRTDS].[UARI_EV_ACT_HR].[HR]

Peak Day

Interactive Channel ID

decimal

identifier

[Interact Model].[Event Activity Day].[Interactive Channel ID]

Category ID

decimal

identifier

[Interact Model].[Event Activity Day].[Category ID]

Event ID

decimal

identifier

[Interact Model].[Event Activity Day].[Event ID]

Peak Day

dateTime

attribute

[Interact Model].[Event Activity Day].[Actual Date]

Max Occurrences

float64

fact

maximum ([Interact Model].[Event Activity Day].[Occurrences] for [Interact Model].[Peak Day].[Interactive Channel ID], [Interact Model].[Peak Day].[Category ID],[Interact Model].[Peak Day].[Event ID] )

Slow Day

Interactive Channel ID

decimal

identifier

[Interact Model].[Event Activity Day].[Interactive Channel ID]

Category ID

decimal

identifier

[Interact Model].[Event Activity Day].[Category ID]

Event ID

decimal

identifier

[Interact Model].[Event Activity Day].[Event ID]

Slowest Day

dateTime

attribute

[Interact Model].[Event Activity Day].[Actual Date]

Min Occurrences

float64

fact

minimum ([Interact Model].[Event Activity Day].[Occurrences] for [Interact Model].[Slow Day].[Interactive Channel ID], [Interact Model].[Slow Day].[Category ID],[Interact Model].[Slow Day].[Event ID] )

Peak Hour

Int Channel ID

decimal

identifier

[Interact Model].[Event Activity HR].[Interactive Channel ID]

Cat ID

decimal

identifier

[Interact Model].[Event Activity HR].[Category ID]

Event ID

decimal

identifier

[Interact Model].[Event Activity HR].[Event ID]

Peak Day

dateTime

attribute

[Interact Model].[Event Activity HR].[Actual Date]

Peak Hour

int64

attribute

[Interact Model].[Event Activity HR].[Hour]

Max Occur

float64

fact

maximum ([Interact Model].[Event Activity HR].[Occurrences] for [Interact Model].[Peak Hour].[Int Channel ID] , [Interact Model].[Peak Hour].[Cat ID] , [Interact Model].[Peak Hour].[Event ID] )

Slow Hour

Int Channel ID

decimal

identifier

[Interact Model].[Event Activity HR].[Interactive Channel ID]

Cat ID

decimal

identifier

[Interact Model].[Event Activity HR].[Category ID]

Event ID

decimal

identifier

[Interact Model].[Event Activity HR].[Event ID]

Slowest Day

dateTime

attribute

[Interact Model].[Event Activity HR].[Actual Date]

Slowest Hour

int64

attribute

[Interact Model].[Event Activity HR].[Hour]

Min Occur

float64

fact

minimum ([Interact Model].[Event Activity HR].[Occurrences] for [Interact Model].[Slow Hour].[Int Channel ID], [Interact Model].[Slow Hour].[Cat ID] ,[Interact Model].[Slow Hour].[Event ID] )

Namespace/Folder	Query Subject	Query Item	Type	Usage	Ref Obj/Expr.
Peak and Slow All	Peak Day All	Interactive Channel ID	decimal	identifier	[Peak and Slow All].[Channel Event Activity Day at IC Level].[Interactive Channel ID]
		Max Occurrences	float64	fact	maximum ([Peak and Slow All].[Channel Event Activity Day at IC Level].[Occurrences] for [Peak and Slow All].[Peak Day All].[Interactive Channel ID] )
		Peak Day All	dateTime	attribute	[Peak and Slow All].[Channel Event Activity Day at IC Level].[Actual Date]
	Slow Day All	Interactive Channel ID	decimal	identifier	[Peak and Slow All].[Channel Event Activity Day at IC Level].[Interactive Channel ID]
		Min Occurrences	float64	fact	minimum ([Peak and Slow All].[Channel Event Activity Day at IC Level].[Occurrences] for [Peak and Slow All].[Slow Day All].[Interactive Channel ID])
		Slowest Day All	dateTime	attribute	[Peak and Slow All].[Channel Event Activity Day at IC Level].[Actual Date]
	Peak Hour All	Interactive Channel ID	decimal	identifier	[Peak and Slow All].[Channel Event Activity HR at IC Level].[Interactive Channel ID]
		Max Occurrences	float64	fact	maximum ([Peak and Slow All].[Channel Event Activity HR at IC Level].[Occurrences] for [Peak and Slow All].[Peak Hour All].[Interactive Channel ID] )
		Peak Day All	dateTime	attribute	[Peak and Slow All].[Channel Event Activity HR at IC Level].[Actual Date]
		Peak Hour All	int64	attribute	[Peak and Slow All].[Channel Event Activity HR at IC Level].[Hour]
	Slow Hour All	Interactive Channel ID	decimal	identifier	[Peak and Slow All].[Channel Event Activity HR at IC Level].[Interactive Channel ID]
		Min Occurrences	float64	fact	minimum ([Peak and Slow All].[Channel Event Activity HR at IC Level].[Occurrences] for [Peak and Slow All].[Slow Hour All].[Interactive Channel ID] )
		Slowest Day All	dateTime	attribute	[Peak and Slow All].[Channel Event Activity HR at IC Level].[Actual Date]
		Slowest Hour All	int64	attribute	[Peak and Slow All].[Channel Event Activity HR at IC Level].[Hour]
	Channel Event Activity HR at IC Level	Interactive Channel ID	int64	identifier	[InteractRTDS].[UARI_EV_ACT_IC_HR].[ICID]
		Occurrences	int64	fact	[InteractRTDS].[UARI_EV_ACT_IC_HR].[NUM_OCCURRENCES]
		Actual Date	dateTime	attribute	[InteractRTDS].[UARI_EV_ACT_IC_HR].[ACTUALDATE]
		Hour	int32	attribute	[InteractRTDS].[UARI_EV_ACT_IC_HR].[HR]
	Channel Event Activity Day at IC Level	Interactive Channel ID	int64	identifier	[InteractRTDS].[UARI_EV_ACT_IC_DY].[ICID]
		Occurrences	int64	fact	[InteractRTDS].[UARI_EV_ACT_IC_DY].[NUM_OCCURRENCES]
		Actual Date	dateTime	attribute	[InteractRTDS].[UARI_EV_ACT_IC_DY].[ACTUALDATE]

Import View

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Common

UARI_OFFER

OFFERID

decimal

fact

NAME

characterLength16

attribute

DESCRIPTION

characterLength16

attribute

OFFERCODE1

characterLength16

attribute

OFFERCODE2

characterLength16

attribute

OFFERCODE3

characterLength16

attribute

OFFERCODE4

characterLength16

attribute

OFFERCODE5

characterLength16

attribute

UARI_TRMTRULEINV

TREATMENTRULEID

decimal

fact

DEPLOYMENTID

decimal

fact

ICID

decimal

fact

ICNAME

characterLength16

attribute

CELLID

decimal

fact

CELLNAME

characterLength16

attribute

ZONEID

decimal

fact

ZONENAME

characterLength16

attribute

STRATEGYID

decimal

fact

STRATEGYNAME

characterLength16

attribute

OFFERID

decimal

fact

OFFERNAME

characterLength16

attribute

CAMPAIGNID

decimal

fact

CAMPAIGNNAME

characterLength16

attribute

CAMPAIGNCODE

characterLength16

attribute

SEGMENTID

decimal

fact

SEGMENTNAME

characterLength16

attribute

MARKETINGSCORE

int64

fact

LASTUPDATE

dateTime

identifier

PREDICATE

characterLength16

attribute

ENABLESTATEID

int64

fact

PREDICATESTATE

characterLength16

attribute

UARI_CAMPAIGN

CAMPAIGNID

decimal

fact

NAME

characterLength16

attribute

DESCRIPTION

characterLength16

attribute

CAMPAIGNCODE

characterLength16

attribute

OBJECTIVES

characterLength16

attribute

LASTRUNDATE

dateTime

identifier

INITIATIVE

characterLength16

attribute

CREATEDATE

dateTime

identifier

STARTDATE

dateTime

identifier

ENDDATE

dateTime

identifier

UARI_CELLS

CELLID

decimal

fact

CELLNAME

characterLength16

attribute

CELLCODE

characterLength16

attribute

CONTROLCELLID

decimal

fact

ISCONTROL

int64

fact

CAMPAIGNID

decimal

fact

UARI_TRI_CAMP_OFF

OFFERID

decimal

fact

OFFERNAME

characterLength16

attribute

CAMPAIGNID

decimal

fact

CAMPAIGNNAME

characterLength16

attribute

CAMPAIGNCODE

characterLength16

attribute

UARI_LOOKUP

LKUP_ID

int64

fact

LKUP_CODE

characterLength16

attribute

LKUP_TYPE

characterLength16

attribute

DESCRIPTION

characterLength16

attribute

LOCALE

characterLength16

attribute

LOCALIZED_STRING

characterLength16

attribute

UARI_CALENDAR

DATEID

decimal

fact

YEAR

int64

fact

FISCALYEAR

int64

fact

QUARTER

int64

fact

FISCALQUARTER

int64

fact

MONTH

int64

fact

WEEKOFYEAR

int64

fact

WEEKOFMONTH

int64

fact

DAYOFYEAR

int64

fact

DAYOFMONTH

int64

fact

DAYOFWEEK

int64

fact

ACTUALDATE

dateTime

identifier

FIRSTDAYOFWEEK

dateTime

identifier

LASTDAYOFWEEK

dateTime

identifier

UARI_TIME

TIMEID

decimal

fact

HOUR

int64

fact

MINUTE

int64

fact

LAST_24_HOURS_LOOKUP

HOUR

float64

fact

DATEID

decimal

fact

ACTUALDATE

dateTime

identifier

Deployment

UARI_DEPLOYMENT

DEPLOYMENTID

decimal

fact

DEPLOYDEPTYPEID

int64

fact

ICID

decimal

fact

CAMPAIGNID

decimal

fact

CAMPAIGNNAME

characterLength16

attribute

STRATEGYID

decimal

fact

STRATEGYNAME

characterLength16

attribute

DEPLOYTYPEID

int64

fact

DEPLOYTYPE

characterLength16

attribute

SESSIONID

decimal

fact

SESSIONNAME

characterLength16

attribute

FLOWCHARTID

decimal

fact

FLOWCHARTNAME

characterLength16

attribute

FLOWCHDEPLOYTYPEID

int64

fact

FLOWCHDEPLOYTYPE

characterLength16

attribute

AUDIENCELEVEL

characterLength16

attribute

DEPLMNTDEST

characterLength16

attribute

DEPLMNTSVRGRP

int64

fact

DEPLMNTOWNER

characterLength16

attribute

TIMEDEPLMNT

dateTime

identifier

Namespace/Folder	Query Subject	Query Item	Type	Usage
Interactive Channel by Offer	UARI_ICP_OCH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_OCH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_OCH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_ORH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_ORH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_ORH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Interactive Channel by Segment	UARI_ICP_SEGCH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_SEGCH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_SEGCH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_SEGRH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_SEGRH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_SEGRH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Interactive Channel by Interaction Point	UARI_ICP_IPCH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_IPCH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_IPCH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_IPRH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_IPRH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_IPRH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Cell Performance	UARI_CCP_CH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_CH_DY	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_CH_HR	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_RH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_CCP_RH_DY	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_CCP_RH_HR	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Cell by Offer	UARI_CCP_OCH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_ORH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Cell by Interaction Point	UARI_CCP_IPCH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_IPRH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Offer Performance	UARI_COP_CH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_CH_DY	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_CH_HR	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_RH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_COP_RH_DY	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_COP_RH_HR	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Offer by Cell	UARI_COP_CCH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_CRH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Offer by Interaction Point	UARI_COP_IPCH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_IPRH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Run Time Common

UARI_ELIGSTAT

SEQNUM

decimal

fact

ICID

decimal

fact

ICNAME

characterLength16

attribute

OFFERID

decimal

fact

OFFERNAME

characterLength16

attribute

TIMEID

decimal

fact

DATEID

decimal

fact

CELLID

decimal

fact

CELLNAME

characterLength16

attribute

CELLCODE

characterLength16

attribute

IPID

decimal

fact

IPNAME

characterLength16

attribute

ELIGIBLEOPPS

decimal

fact

UARI_DEFAULTEDSTAT

SEQNUM

decimal

fact

TIMEID

decimal

fact

DATEID

decimal

fact

SEGMENTID

decimal

fact

SEGMENTNAME

characterLength16

attribute

IPID

decimal

fact

IPNAME

characterLength16

attribute

ICID

decimal

fact

OCCURRENCES

decimal

fact

Namespace/Folder	Query Subject	Query Item	Type	Usage
Interactive Channel by Offer	UARI_ICP_OES	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_ICP_OES_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_ICP_OES_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
Interactive Channel by Segment	UARI_ICP_SEGDS	ICID	decimal	fact
		IPID	decimal	fact
		SEGMENTID	decimal	fact
		NUM_OF_OCCURRENCES	float64	fact
Interactive Channel by Interaction Point	UARI_ICP_IPDS	ICID	decimal	fact
		IPID	decimal	fact
		NUM_OF_OCCURRENCES	float64	fact
Campaign Cell Performance	UARI_CCP_ES	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_ES_DY	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_ES_HR	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_IPES	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_OES	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		OFFERID	decimal	fact
		ELIGIBLEOPPS	float64	fact
Campaign Offer Performacne	UARI_COP_ES	CAMPAIGNID	float64	fact
		OFFERID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_COP_ES_DY	CAMPAIGNID	float64	fact
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_COP_ES_HR	CAMPAIGNID	float64	fact
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_COP_CES	CAMPAIGNID	int64	fact
		OFFERID	decimal	fact
		CELLID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_COP_IPES	CAMPAIGNID	int64	fact
		OFFERID	decimal	fact
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		ELIGIBLEOPPS	float64	fact

Event Activity

UARI_EV_ACT

ICID

decimal

identifier

ICNAME

characterLength16

attribute

CATEGORYID

decimal

identifier

CATEGORYNAME

characterLength16

attribute

EVENTID

decimal

identifier

EVENTNAME

characterLength16

attribute

NUM_OCCURRENCES

float64

fact

UARI_EV_ACT_DY

ICID

decimal

identifier

ICNAME

characterLength16

attribute

CATEGORYID

decimal

identifier

CATEGORYNAME

characterLength16

attribute

EVENTID

decimal

identifier

EVENTNAME

characterLength16

attribute

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

attribute

UARI_EV_ACT_HR

ICID

decimal

identifier

ICNAME

characterLength16

attribute

CATEGORYID

decimal

identifier

CATEGORYNAME

characterLength16

attribute

EVENTID

decimal

identifier

EVENTNAME

characterLength16

attribute

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

attribute

int64

attribute

UARI_EV_ACT_IC_DY

ICID

decimal

fact

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

identifier

UARI_EV_ACT_IC_HR

ICID

decimal

fact

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

identifier

int64

fact

Namespace/Folder	Query Subject	Query Item	Type	Usage
Learning	UARI_LEARNING	OFFERID	decimal	fact
		ATTRIBUTENAME	characterLength16	attribute
		ATTRIBUTEVALUE	characterLength16	attribute
		ACCEPTPERCENTAGE	float64	fact
		PREDICTABILITY	int64	fact

Namespace/Folder

Query Subject

Query Item

Type

Usage

Ref Obj/Expr.

Common

UARI_OFFER

OFFERID

decimal

fact

NAME

characterLength16

attribute

DESCRIPTION

characterLength16

attribute

OFFERCODE1

characterLength16

attribute

OFFERCODE2

characterLength16

attribute

OFFERCODE3

characterLength16

attribute

OFFERCODE4

characterLength16

attribute

OFFERCODE5

characterLength16

attribute

UARI_TRMTRULEINV

TREATMENTRULEID

decimal

fact

DEPLOYMENTID

decimal

fact

ICID

decimal

fact

ICNAME

characterLength16

attribute

CELLID

decimal

fact

CELLNAME

characterLength16

attribute

ZONEID

decimal

fact

ZONENAME

characterLength16

attribute

STRATEGYID

decimal

fact

STRATEGYNAME

characterLength16

attribute

OFFERID

decimal

fact

OFFERNAME

characterLength16

attribute

CAMPAIGNID

decimal

fact

CAMPAIGNNAME

characterLength16

attribute

CAMPAIGNCODE

characterLength16

attribute

SEGMENTID

decimal

fact

SEGMENTNAME

characterLength16

attribute

MARKETINGSCORE

int64

fact

LASTUPDATE

dateTime

identifier

PREDICATE

characterLength16

attribute

ENABLESTATEID

int64

fact

PREDICATESTATE

characterLength16

attribute

UARI_CAMPAIGN

CAMPAIGNID

decimal

fact

NAME

characterLength16

attribute

DESCRIPTION

characterLength16

attribute

CAMPAIGNCODE

characterLength16

attribute

OBJECTIVES

characterLength16

attribute

LASTRUNDATE

dateTime

identifier

INITIATIVE

characterLength16

attribute

CREATEDATE

dateTime

identifier

STARTDATE

dateTime

identifier

ENDDATE

dateTime

identifier

UARI_CELLS

CELLID

decimal

fact

CELLNAME

characterLength16

attribute

CELLCODE

characterLength16

attribute

CONTROLCELLID

decimal

fact

ISCONTROL

int64

fact

CAMPAIGNID

decimal

fact

UARI_TRI_CAMP_OFF

OFFERID

decimal

fact

OFFERNAME

characterLength16

attribute

CAMPAIGNID

decimal

fact

CAMPAIGNNAME

characterLength16

attribute

CAMPAIGNCODE

characterLength16

attribute

UARI_LOOKUP

LKUP_ID

int64

fact

LKUP_CODE

characterLength16

attribute

LKUP_TYPE

characterLength16

attribute

DESCRIPTION

characterLength16

attribute

LOCALE

characterLength16

attribute

LOCALIZED_STRING

characterLength16

attribute

UARI_CALENDAR

DATEID

decimal

fact

YEAR

int64

fact

FISCALYEAR

int64

fact

QUARTER

int64

fact

FISCALQUARTER

int64

fact

MONTH

int64

fact

WEEKOFYEAR

int64

fact

WEEKOFMONTH

int64

fact

DAYOFYEAR

int64

fact

DAYOFMONTH

int64

fact

DAYOFWEEK

int64

fact

ACTUALDATE

dateTime

identifier

FIRSTDAYOFWEEK

dateTime

identifier

LASTDAYOFWEEK

dateTime

identifier

UARI_TIME

TIMEID

decimal

fact

HOUR

int64

fact

MINUTE

int64

fact

LAST_24_HOURS_LOOKUP

HOUR

float64

fact

DATEID

decimal

fact

ACTUALDATE

dateTime

identifier

Deployment

UARI_DEPLOYMENT

DEPLOYMENTID

decimal

fact

DEPLOYDEPTYPEID

int64

fact

ICID

decimal

fact

CAMPAIGNID

decimal

fact

CAMPAIGNNAME

characterLength16

attribute

STRATEGYID

decimal

fact

STRATEGYNAME

characterLength16

attribute

DEPLOYTYPEID

int64

fact

DEPLOYTYPE

characterLength16

attribute

SESSIONID

decimal

fact

SESSIONNAME

characterLength16

attribute

FLOWCHARTID

decimal

fact

FLOWCHARTNAME

characterLength16

attribute

FLOWCHDEPLOYTYPEID

int64

fact

FLOWCHDEPLOYTYPE

characterLength16

attribute

AUDIENCELEVEL

characterLength16

attribute

DEPLMNTDEST

characterLength16

attribute

DEPLMNTSVRGRP

int64

fact

DEPLMNTOWNER

characterLength16

attribute

TIMEDEPLMNT

dateTime

identifier

Namespace/Folder	Query Subject	Query Item	Type	Usage
Interactive Channel by Offer	UARI_ICP_OCH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_OCH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_OCH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_ORH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_ORH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_ORH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Interactive Channel by Segment	UARI_ICP_SEGCH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_SEGCH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_SEGCH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_SEGRH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_SEGRH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_SEGRH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		SEGMENTID	decimal	fact
		SEGMENT_NAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Interactive Channel by Interaction Point	UARI_ICP_IPCH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_IPCH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_IPCH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_ICP_IPRH	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_IPRH_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_ICP_IPRH_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Cell Performance	UARI_CCP_CH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_CH_DY	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_CH_HR	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_RH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_CCP_RH_DY	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_CCP_RH_HR	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Cell by Offer	UARI_CCP_OCH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_ORH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Cell by Interaction Point	UARI_CCP_IPCH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_CCP_IPRH	CAMPAIGNID	decimal	fact
		CELLID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Offer Performance	UARI_COP_CH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_CH_DY	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_CH_HR	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_RH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_COP_RH_DY	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
	UARI_COP_RH_HR	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Offer by Cell	UARI_COP_CCH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_CRH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		CELLID	decimal	fact
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact
Campaign Offer by Interaction Point	UARI_COP_IPCH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_PRES	float64	fact
		NUM_PRES_MODELDRVN	float64	fact
		NUM_PRES_RANDOM	float64	fact
	UARI_COP_IPRH	CAMPAIGNID	decimal	fact
		OFFERID	decimal	fact
		IPID	float64	fact
		IPNAME	characterLength16	attribute
		NUM_TIMES_ACCP	float64	fact
		NUM_TIME_REJ	float64	fact
		NUM_ACCP_MODELDRVN	float64	fact
		NUM_ACCP_RANDOM	float64	fact

Run Time Common

UARI_ELIGSTAT

SEQNUM

decimal

fact

ICID

decimal

fact

ICNAME

characterLength16

attribute

OFFERID

decimal

fact

OFFERNAME

characterLength16

attribute

TIMEID

decimal

fact

DATEID

decimal

fact

CELLID

decimal

fact

CELLNAME

characterLength16

attribute

CELLCODE

characterLength16

attribute

IPID

decimal

fact

IPNAME

characterLength16

attribute

ELIGIBLEOPPS

decimal

fact

UARI_DEFAULTEDSTAT

SEQNUM

decimal

fact

TIMEID

decimal

fact

DATEID

decimal

fact

SEGMENTID

decimal

fact

SEGMENTNAME

characterLength16

attribute

IPID

decimal

fact

IPNAME

characterLength16

attribute

ICID

decimal

fact

OCCURRENCES

decimal

fact

Namespace/Folder	Query Subject	Query Item	Type	Usage
Interactive Channel by Offer	UARI_ICP_OES	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_ICP_OES_DY	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_ICP_OES_HR	ICID	decimal	fact
		ICNAME	characterLength16	attribute
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
Interactive Channel by Segment	UARI_ICP_SEGDS	ICID	decimal	fact
		IPID	decimal	fact
		SEGMENTID	decimal	fact
		NUM_OF_OCCURRENCES	float64	fact
Interactive Channel by Interaction Point	UARI_ICP_IPDS	ICID	decimal	fact
		IPID	decimal	fact
		NUM_OF_OCCURRENCES	float64	fact
Campaign Cell Performance	UARI_CCP_ES	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_ES_DY	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_ES_HR	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_IPES	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		ELIGIBLEOPPS	float64	fact
	UARI_CCP_OES	CAMPAIGNID	int64	fact
		CELLID	decimal	fact
		OFFERID	decimal	fact
		ELIGIBLEOPPS	float64	fact
Campaign Offer Performacne	UARI_COP_ES	CAMPAIGNID	float64	fact
		OFFERID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_COP_ES_DY	CAMPAIGNID	float64	fact
		OFFERID	decimal	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_COP_ES_HR	CAMPAIGNID	float64	fact
		OFFERID	decimal	fact
		HOUR	int64	fact
		ACTUALDATE	dateTime	identifier
		ELIGIBLEOPPS	float64	fact
	UARI_COP_CES	CAMPAIGNID	int64	fact
		OFFERID	decimal	fact
		CELLID	decimal	fact
		ELIGIBLEOPPS	float64	fact
	UARI_COP_IPES	CAMPAIGNID	int64	fact
		OFFERID	decimal	fact
		IPID	decimal	fact
		IPNAME	characterLength16	attribute
		ELIGIBLEOPPS	float64	fact

Event Activity

UARI_EV_ACT

ICID

decimal

identifier

ICNAME

characterLength16

attribute

CATEGORYID

decimal

identifier

CATEGORYNAME

characterLength16

attribute

EVENTID

decimal

identifier

EVENTNAME

characterLength16

attribute

NUM_OCCURRENCES

float64

fact

UARI_EV_ACT_DY

ICID

decimal

identifier

ICNAME

characterLength16

attribute

CATEGORYID

decimal

identifier

CATEGORYNAME

characterLength16

attribute

EVENTID

decimal

identifier

EVENTNAME

characterLength16

attribute

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

attribute

UARI_EV_ACT_HR

ICID

decimal

identifier

ICNAME

characterLength16

attribute

CATEGORYID

decimal

identifier

CATEGORYNAME

characterLength16

attribute

EVENTID

decimal

identifier

EVENTNAME

characterLength16

attribute

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

attribute

int64

attribute

UARI_EV_ACT_IC_DY

ICID

decimal

fact

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

identifier

UARI_EV_ACT_IC_HR

ICID

decimal

fact

NUM_OCCURRENCES

float64

fact

ACTUALDATE

dateTime

identifier

int64

fact

Learning

UARI_LEARNING

OFFERID

decimal

fact

ATTRIBUTENAME

characterLength16

attribute

ATTRIBUTEVALUE

characterLength16

attribute

ACCEPTPERCENTAGE

float64

fact

PREDICTABILITY

int64

fact

Copyright

© Copyright Unica Corporation 2003 - 2010. All rights reserved.

Unica Corporation
Reservoir Place North
170 Tracer Lane
Waltham, MA 02451-1379

Examples and Data

All software and related documentation is subject to restrictions on use and disclosure as set forth in the Unica Software License and Services Agreement, with restricted rights for U.S. government users and applicable export regulations.

Companies, names, and data used in examples herein are fictitious unless otherwise noted.

Trademarks and Patents

Unica®, the Unica logo, Affinium®, MarketingCentral®, MarketSoft®, MarketSoft logo, DemandMore®, Leads to Revenue®, NetTracker®, My NetTracker®, and Ask NetTracker® are registered trademarks of Unica Corporation with the U.S. Patent and Trademark Office.

Affinium Campaign™, Affinium Campaign Collaborate™, Affinium Campaign eMessage™, Affinium Campaign Interact™, Affinium Campaign Optimize™, Affinium Detect™, Affinium Leads™, Affinium Leads Referral™, Affinium Leads Contact™, Affinium Model™, Affinium NetInsight™, Affinium Insight™, Affinium Plan™, Affinium Mart™, Universal Dynamic Interconnect™, Interconnect Modules™, Marketic™, Powering Marketing Success™, Drill Anywhere™, Marketing Objects™, Trend Anything™, Customer Value Maximization™, MAP™, One-to-One Optimization™, and Right-time Marketing™ are trademarks of Unica Corporation. All other trademarks are the property of their respective owners.

Portions of the software described in this document are covered by U.S. Patent Numbers: 6,317,752, 6,269,325, 6,542,894, and 6,782,390.

The NetTracker, Affinium Insight, and Affinium NetInsight products are licensed under the following patents and patent publications: US5,675,510, US6,115,680, US6,108,637, US5,796,952, US6,138,155, US6,653,696, US6,763,386, AU0701813, BR9609217, CA2223919, EP0843946, JP03317705, MX193614, NO09705728, AU735285, CA2246746, CN1174316, CN1547123, CN1547124, DK870234, DE69720186, ES2195170, AU727170, BR9808033, CA2284530, CN1251669, IL131871, JP2000514942, KR341110, NZ337756, WO9641495, EP0870234, EP1130526, EP1168196, US20040078292, WO9810349, US20050114511, US20040221033, WO9843380.

Markup functionality in Affinium Plan is enabled through use of third-party software components from AdLib™ eDocument Solutions and Adobe® Acrobat®. "Powered by AdLib™."

NOTICE: This document contains confidential and proprietary information of Unica Corporation ("Unica"). Use, duplication, or disclosure without the express written consent of Unica Corporation is prohibited.