Table Description
System Message: A message defined by an administrator which can be displayed in a portal. System messages can be used by agencies to provide information which is relevant to all users of a portal, for example, if an agency wanted to provide information and help line numbers to citizens who have been affected by a natural disaster e.g. floods, hurricanes or earthquakes.

Example

James Smith logs into the citizen account and sees message on the citizen account home page indicating 'The government help line is now active. This help line is to provide information on government services for people affected by the recent flooding. Call 01 779 9971 for information.' This entity stores the details of this message.
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::WorkspaceServices::SystemMessage::Entity::SystemMessage
Controlling File: WorkspaceServices\model\Packages\SystemMessage\SystemMessage_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
systemMessageIDkeynoUnique identifier of this system message record.INTERNAL_ID SVR_INT64
effectiveDateTimedetailsnoEffective date and time of the system message i.e. when the message is displayed in the portal.CURAM_DATETIME SVR_DATETIME
expiryDateTimedetailsnoExpiry date of this system message i.e. when the message is no longer displayed in the portal.CURAM_DATETIME SVR_DATETIME
creationDatedetailsnoCreation date of the system message.CURAM_DATE SVR_DATE
createdBydetailsnoUser name of the user who created the system message.USER_NAME SVR_STRING<64>
titleTextIDdetailsnoTitle of the system message.LOCALIZABLE_TEXT_ID SVR_INT64
messageTextIDdetailsnoThe text of the system message.LOCALIZABLE_TEXT_ID SVR_INT64
statusdetailsnoThe status of the system message e.g. Pending, Active.SYSTEM_MESSAGE_STATUSSystemMessageStatusSVR_STRING<10>
priorityInddetailsnoIndicator to dictate if this message is a priority or not.CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (2)
ChildParent
SystemMessage.messageTextIDLocalizableText.localizableTextID
SystemMessage.titleTextIDLocalizableText.localizableTextID
Indices (2)
Index NameAttributes
IND__1395047256messageTextID
IND__723713927titleTextID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: systemMessageID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByStatusAndDatensreadmultiWHERE: effectiveDateTime <= :effectiveDateTime AND expiryDateTime>= :effectiveDateTime AND expiryDateTime > effectiveDateTime and status = :status
Returns a set of records based on the status and date specified where the date secified falls between the effective date and the expiry date. 
searchAllnkreadmulti Returns all records stored on the entity. 
Related Pages (8)