Table Description
CitizenCampaign: A campaign(outreach in the application) that is to be displayed to certain citizens in the Citizen Self Service. A rule set determines whether an outreach campaign is displayed to a citizen or not. Each campaign rule set is associated with one citizen campaign record.

Example

For example, a campaign based on whether someone is of a pensionable age may be configured.When a citizen logs in to the citizen workspace, the rule set is invoked. It reads the citizens' age and determined that this campaign is relevant to them. Accordingly, it writes an AdviceItem and other records so this campaign will be displayed to the citizen. The CitizenCampaign expiry date is assigned to the AdviceItem expiry date,and the CitizenCampaign image is associated with the advice item.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::CitizenWorkspaceAdmin::Entity::CitizenCampaign::CitizenCampaign
Controlling File: CitizenWorkspaceAdmin\model\Packages\Entity\CitizenCampaign\CitizenCampaign.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
citizenCampaignIDkeynoUnique identifierINTERNAL_ID SVR_INT64
namedetailsnoThis is a user friendly unique reference that would be referenced in the rule set. It is a string that cannot contain any spaces. It must be unique across all CitizenCampaign records.CITIZEN_CAMPAIGN_NAME SVR_STRING<50>
creationDatedetailsnoThe date on which the campaign was created CURAM_DATE SVR_DATE
createdBydetailsnoThe username of the user who created the campaignUSER_NAME SVR_STRING<64>
imageIDdetailsyesReference to the image (if any) that is associated with this campaignINTERNAL_ID SVR_INT64
statusdetailsnoReference to citizen campaign status which is taken from CitizenCampaignStatus codetableCITIZEN_CAMPAIGN_STATUS_CODECitizenCampaignStatusSVR_STRING<10>
expiryDateTimedetailsyesThe expiry date time for this campaign.CURAM_DATETIME SVR_DATETIME
adviceContextRulesIDdetails The unique identifier of the rule set specified for this campaign.INTERNAL_ID SVR_INT64
Foreign Keys (1)
ChildParent
CitizenCampaign.imageIDImage.imageID
Indices (2)
Index NameAttributes
IdxCitizenCampaignKeyNamename
IND_468428527imageID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: citizenCampaignID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchAllnkreadmulti Lists all campaigns 
readByNamensread Returns campaign details for a provided name 
searchByStatusForBatchProcessingnsmulti Returns the IDs of all records with a given status in a format suitable for Batch Processing.SQL
Related Pages (8)