Table Description
Citizen Workspace External Party Link: Stores the relationship between a Citizen Self Service account and a Person on an external system. Each Citizen Self Service account may be associated with at most one person per external system.

This entity will allow a citizen to access information in the citizen account i.e. messages, outreach campaigns, payments, activities, contact information, applications, screenings and triage. This account will also allow the citizen to submit life events to the agency allowing them to report significant life changes to the social enterprise agency which may effect the benefits they are receiving.

Example

James Smith selects to login to the citizen self service. His citizen self service account has not been linked to his person record using this entity. As such, he will not have access to the information mentioned above. He will only have the ability to check status of applications submitted at an earlier date. Linda Smith selects to login to the citizen self service account. Her citizen self service account has been linked to her person record using this entity and as such will have access to all information outlined above.
Model Details
Location in Model: Logical View::MetaModel::Curam::WorkspaceServices::Entity::CitizenWorkspaceExternalPartyLink::CWExternalPartyLink
Controlling File: WorkspaceServices\model\Packages\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
cwExternalPartyLinkIDkeynoUnique reference number of the citizen workspace external party link record.INTERNAL_ID SVR_INT64
cwUserNamedetailsnoUser name of the citizen stored on the external user table.USER_NAME SVR_STRING<64>
externalPartyIDdetailsnoUnique identifier of the person record who is being linked to the citizen self service user account.EXTERNAL_PARTY_NAME SVR_STRING<131>
externalSystemIDdetailsnoUnique reference number of the external system that the person is stored on.EXTERNAL_SYSTEM_ID SVR_STRING<50>
createdByUserNamedetails User name of the user who created the citizen workspace external party link record.EXTERNAL_PARTY_NAME SVR_STRING<131>
recordStatusdetails Record status of the citizen workspace external party link record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
externalSysReferenceTypedetails Codetable to identify if the person is on a Curam system or a remote system.EXTERNAL_SYS_REF_TYPEExternalSysReferenceTypeSVR_STRING<10>
Indices (3)
Index NameAttributes
CWExtPartIdx1cwUserName
CWExtPartIdx2externalPartyID
IND_555740819externalSystemID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: cwExternalPartyLinkID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
readActiveByExternalPartyAndSystemRecordStatusnsread Returns a record based on the external system ID, External System and record status in question. 
searchActiveByCWUserNameRecordStatusnsreadmulti Searches for records based on the Citizen Workspace ID. 
readActiveByCWUserNameExternalSystemRecordStatusnsread Returns a record based on the Citizen Workspace ID and External System in question. 
removeremove Standard Operation 
searchActiveByUsernameExSysReferencereadmulti Searches for active records by username and the external system reference type. Used to retrieve links for a given user that are links to Remote Systems. 
Related Pages (6)