Table Description
CaseParticipantRoleLink: Creates a link between case participant and related type
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::Appeals::Service Layer::entity::Hearing::Hearing Participation::CaseParticipantRoleLink
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\Hearing Participation\Hearing Participation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseParticipantRoleLinkIDkeynoUnique generated IDINTERNAL_ID SVR_INT64
relatedIDdetailsnoRepresents the relationship with hearing representative or hearing witness.CASE_PARTICIPANT_ROLE_ID SVR_INT64
caseParticipantRoleIDdetailsnoA case participant who added as a legal participant for a hearingCASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails Represents the creation date of the linkCURAM_DATE SVR_DATE
endDatedetails Represents the end date of the linkCURAM_DATE SVR_DATE
recordStatusdetails Represents the record status active canceled etcRECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
CaseParticipantRoleLink.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND__890442310relatedID
IND_1937551624caseParticipantRoleID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: caseParticipantRoleLinkID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
getCaseParticipantRoleIDAndNameByRelatedIDns Provides the name and Id of case participant for a related ID. where related id may be hearing representativeID or hearing witness id.SQL
modifyCaseParticipantRoleIDByRelatedID  Changes case participant role id while making changes for related Id. 
readParticipantDetailsByRelatedIDnsmulti Provides legal participant details for a related Id.SQL
getBehalfOfByCaseParticipantRoleIDns Provides the name of a person who is participated behalf of a case participant.SQL
readParticipantsNameAgeGendernsmulti  SQL
modifyCaseParticipantRoleIDByRelatedIDnsmodifyOPTIMISTIC_LOCKING: no
Modifies CaseParticipantRoleID. 
readByRelatedIDnsread Reads the CaseParticipantRoleLink details by given related ID. 
Related Pages (25)