Table CAMPAIGN

DescriptionA process that the modelled organisation undertakes to achieve a specific business objective. In particular, this covers coordinated communication with the marketplace in order to acquire, retain and develop (that is, cross-sell and up-sell) business.

e.g. Campaign for Universal life product launch.

Columns
CAMPAIGN_IDCAMPAIGN_ID
ACTUAL_COSTACTUAL_COST
ACTUAL_TIME_SPENTACTUAL_TIME_SPENT
ANCHOR_IDANCHOR_ID
BUDGETBUDGET
CAMPAIGN_MINI_DIMENSION_IDCAMPAIGN_MINI_DIMENSION_ID
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
MAXIMUM_TARGET_NUMBERMAXIMUM_TARGET_NUMBER
NAMENAME
OBJECTIVEOBJECTIVE
PLANNED_AGREEMENT_SALESPLANNED_AGREEMENT_SALES
PLANNED_COST_PER_OCCURRENCEPLANNED_COST_PER_OCCURRENCE
PLANNED_END_DATEPLANNED_END_DATE
PLANNED_FIXED_COSTPLANNED_FIXED_COST
PLANNED_INCOMEPLANNED_INCOME
PLANNED_MANPOWERPLANNED_MANPOWER
PLANNED_PROFITPLANNED_PROFIT
PLANNED_START_DATEPLANNED_START_DATE
PLANNED_SUM_INSUREDPLANNED_SUM_INSURED
PLANNED_TARGET_NUMBERPLANNED_TARGET_NUMBER
RESULT_END_DATERESULT_END_DATE
START_DATESTART_DATE
STATUS_DATESTATUS_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
CAMPAIGN_PKCAMPAIGN_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CAMPAIGN_ID
DescriptionThe unique identifier of the Campaign
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACTUAL_COST
DescriptionThe actual monetary amount spent for the activity occurrence up to date.

e.g. The initial mailing had an actual cost of USD 5,000.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACTUAL_TIME_SPENT
DescriptionThe actual time spent on the campaign.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BUDGET
DescriptionThe planned monetary amount allocated for the activity occurrence.

e.g. The for Universal life product launch has a budget of USD 90,000.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CAMPAIGN_MINI_DIMENSION_ID
DescriptionSoft link to Campaign mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA free-text statement used to explain the meaning of the activity. This may include information about the context of the activity as well as any background information.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 END_DATE
DescriptionThe end of the period during which the activity takes place with some regularity.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code assigned to an activity occurrence by a party for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MAXIMUM_TARGET_NUMBER
DescriptionThe maximum number of targets to be included in the campaign. A zero or null value indicates the campaign has no upper limit for targets.

e.g. 1000
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionThe word or phrase used to identify (but not uniquely) the activity.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OBJECTIVE
DescriptionThe textual description of the activity occurrence's objectives or business goals.

e.g. Sell 20,000 new policies of the cherished chariots motor product.
e.g. The objective for the for Universal life product launch has for objective an overall sum insured of 50,000,000 USD.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_AGREEMENT_SALES
DescriptionThe number of agreements (policies) planned to be sold for a product targeted by a campaign.

e.g. 20000
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_COST_PER_OCCURRENCE
DescriptionThe planned monetary amount allocated for every occurrence of the activity.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_END_DATE
DescriptionThe date at which the activity occurrence is planned to end
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_FIXED_COST
DescriptionThe total fixed costs resulting from the Campaign that the company does not intend to exceed.
This cost implies all types of costs that are not related to inbound and outbound contacts.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_INCOME
DescriptionThe total income from new agreements which the company aims to sell as a result of the Campaign. For example, the total premium income from an insurance product campaign.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_MANPOWER
DescriptionThe planned manpower required for the campaign.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_PROFIT
DescriptionThe total financial gain which the company aims to receive from the Campaign.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_START_DATE
DescriptionThe date at which the activity occurrence is planned to start
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_SUM_INSURED
DescriptionThe total sum insured (policy face amount) of new policies which the company aims to write as a result of the Campaign.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_TARGET_NUMBER
DescriptionThe number of parties which the financial services company aims to approach during the campaign.

e.g. 8000
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RESULT_END_DATE
DescriptionThe last date on which results are recorded for the campaign.
Derived from the status related information.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe beginning of the period during which the activity takes place with some regularity.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_DATE
DescriptionThe date at which a campaign becomes effective in a given status.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Campaign.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CAMPAIGN_PK
DescriptionThe unique identifier of the Campaign
MemberCAMPAIGN_ID [BIGINT]

Dependency Details

 AWM - Transformation