Table Description
Citizen Workspace ExternalCase: Stores case data from a remote system used to display a citizen case information in the citizen account. This entity is used in conjunction with the CWExternalContact entity to display case contact information from remote systems in the citizen account.

Example

The citizen workspace external case stores the citizen case details fetched from the target system to display in citizen account.
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::Entity::ExternalContacts::CWExternalCase
Controlling File: WorkspaceServices\model\Packages\Entity\ExternalContact\ExternalContact.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
cwExternalCaseIDkeynoUnique reference number of this record.INTERNAL_ID SVR_INT64
citizenWorkspaceAccountIDdetailsnoUnique reference number of the account the external case is associated with.INTERNAL_ID SVR_INT64
remoteSystemIDdetailsnoUnique reference number of the remote system the case resides on.INTERNAL_ID SVR_INT64
caseNamedetailsnoName of the case.CW_EXTERNAL_CASE_NAME SVR_STRING<1024>
caseReferenceNumberdetailsnoReference number of the case.CW_EXTERNAL_CASE_REFERENCE_NUMBER SVR_STRING<256>
cwExternalContactIDdetailsyesUnique reference number of the external contact associated with this case. INTERNAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
CWExternalCase.citizenWorkspaceAccountIDIntakeClient.intakeClientID
CWExternalCase.remoteSystemIDRemoteSystem.remoteSystemID
Indices (2)
Index NameAttributes
IND_1632543851citizenWorkspaceAccountID
IND__1337636864remoteSystemID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
searchByAccountreadmultiORDER_BY: caseName
  
insertinsertAUTO_ID: cwExternalCaseID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: no
Standard Operation 
removeremove Standard Operation 
readByCaseReferenceRemoteSystemnsread Reads an External Case record that has the given Case Reference Number and Remote System ID. 
Related Pages (0)