Table Description
Participant Message: A message that can be displayed to a participant. Used to display messages to citizens in Citizen Self Service. Messages are displayed in the citizen account in order to predict why the citizen has logged in, for example, a message is displayed to let them know what their last payment was and when their next payment is due. Messages can also be displayed to inform the user of activities they are scheduled to participate in or meetings they are due to attend. This entity stores the details of these messages. These messages will be written by various areas of the system when they wish to communicate a message to a participant.

Example

James Smith logs into the citizen account and sees message on the citizen account home page indicating 'Your latest payment of $140 was due on 2010-06-14. Click here to view the payment details. Your next payment is due on 2010-12-12. Click My Payments to view your payment history.' This entity is used to store 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::ParticipantMessages::ParticipantMessage::ParticipantMessage
Controlling File: WorkspaceServices\model\Packages\ParticipantMessages\ParticipantMessages.efx
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
participantMessageIDkeynoUnique identifier for this message record.INTERNAL_ID SVR_INT64
concernRoleIDdetailsnoUnique reference number of the person with whom the messages relates.CONCERN_ROLE_ID SVR_INT64
messageTypedetailsnoThe type of message e.g. meeting, system, payment.PARTICIPANT_MESSAGE_CODEParticipantMessageTypeSVR_STRING<10>
relatedIDdetailsyesThe unique identifier of the record that is related to this message. For example, an Activity ID for a meeting.INTERNAL_ID SVR_INT64
propertyFileNamedetailsnoName of the property file where the message body is held.PROPERTY_FILE_NAME SVR_STRING<100>
titlePropertydetailsnoThe property key used to retrieve the title text for this message from the property file defined above.TITLE_MESSAGE_PROPERTY SVR_STRING<100>
messagePropertydetailsnoThe property key used to retrieve the message body text for this message.TITLE_MESSAGE_PROPERTY SVR_STRING<100>
effectiveDateTimedetailsnoThe effective date of this message i.e. when it is displayed to the citizen.CURAM_DATETIME SVR_DATETIME
expiryDateTimedetailsnoThe expiry date of this message i.e. when the message disappears from the citizen account home page.CURAM_DATETIME SVR_DATETIME
imagedetailsyesThe image or icon that can be displayed along with the message.IMAGE_NAME SVR_STRING<250>
createdDateTimedetailsnoThe date time that this record was created.CURAM_DATETIME SVR_DATETIME
Foreign Keys (1)
ChildParent
ParticipantMessage.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
PartMesIdxconcernRoleID
IND__1746438789relatedID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
searchByParticipantreadmultiWHERE: concernRoleID=:concernRoleID
Searches the participant messages by participant. 
insertinsertAUTO_ID: participantMessageID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByParticipantAndMessageTypereadmultiWHERE: concernRoleID=:concernRoleID AND messageType=:messageType
Search table by concernRoleID and message type, taken from the ParticipantMessageType codetable. 
readByRelatedIDTypeAndConcernRolensread Retrieve a record based on its relatedID, messageType and ConcernRole. 
searchPertinentByParticipantreadmultiWHERE: effectiveDateTime <= :effectiveDateTime AND expiryDateTime>= :effectiveDateTime AND expiryDateTime > effectiveDateTime and concernRoleID = :concernRoleID
Gets the list of relevent messages considering effective and expiry datetime for a participant 
Related Pages (0)