Database Table: ParticipantMessage
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. |
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
Location in Model: | Logical View::MetaModel::Curam::WorkspaceServices::ParticipantMessages::ParticipantMessage::ParticipantMessage |
Controlling File: | WorkspaceServices\model\Packages\ParticipantMessages\ParticipantMessages.efx |
Index Name | Attributes |
PartMesIdx | concernRoleID |
IND__1746438789 | relatedID |
|
Operation | Stereotype | Options | Description | SQL |
searchByParticipant | readmulti | WHERE: concernRoleID=:concernRoleID
| Searches the participant messages by participant. | |
insert | insert | AUTO_ID: participantMessageID
| Standard Operation | |
read | read | | Standard Operation | |
modify | modify | | Standard Operation | |
remove | remove | | Standard Operation | |
searchByParticipantAndMessageType | readmulti | WHERE: concernRoleID=:concernRoleID AND messageType=:messageType
| Search table by concernRoleID and message type, taken from the ParticipantMessageType codetable. | |
readByRelatedIDTypeAndConcernRole | nsread | | Retrieve a record based on its relatedID, messageType and ConcernRole. | |
searchPertinentByParticipant | readmulti | WHERE: 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 | |
|