D:CaseParticipantRoleNote

Table Description

Case Participant Role Note: A link between a note and a participant in a specific case participant role on a case.

A participant can have multiple case participant roles on a case. One or more A case participant role notes can be recorded for each case participant role.

Example

John Smith has three case participant roles:

for case 1:

John Smith is the 'Primary Client'; and
John Smith is also a 'Nominee'; and

for case 2 John Smith is a 'Correspondent'.

Within each case, one or more notes can be recorded for each of John's case participant role.

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::Core::Reference Model::Service Layer::Case Participant Note::Entity::CaseParticipantRoleNote
Controlling File:	core\model\Packages\Reference Model\Service Layer\Case Participant Role Note\Entity_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (4)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
caseParticipantRoleNoteID	key	no	Unique identifier of a case participant role note.	CASE_PARTICIPANT_ROLE_NOTE_ID		SVR_INT64
caseParticipantRoleID	details	no	Unique identifier of a case participant role. Links the case participant role note to the related case participant role.	CASE_PARTICIPANT_ROLE_NOTE_ID		SVR_INT64
noteID	details	no	Unique identifier of the related note. Links the case participant role note to the associated note.	NOTE_ID		SVR_INT64
recordStatus	details	no	Current record status of the case participant role note.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>

Foreign Keys (2)

Child	Parent
CaseParticipantRoleNote.caseParticipantRoleID	CaseParticipantRole.caseParticipantRoleID
CaseParticipantRoleNote.noteID	Note.noteID

Indices (2)

Index Name	Attributes
CasePartNoteIndex	noteID
casePartRolNoteIdx	caseParticipantRoleID

Operations (17)

Operation	Stereotype	Options	Description	SQL
insert			Inserts the details of a case participant role note
modify			Modifies the details of a CaseParticipantRole note @deprecated - replaced by {@link #modify1()} @deprecated-since Version 6.0
cancel	nsmodify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Cancels the details of a Case Participant Role note.
readNote	ns		Retrieves the details of a Case participant role note. @deprecated - replaced by {@link #readNote1()} @deprecated-since Version 6.0	SQL
searchByCaseParticipantRoleID	nsmulti		Retrieves a list of Case Participant Role Notes. @deprecated - replaced by {@link #searchByCaseParticipantRoleID1()} @deprecated-since Version 6.0	SQL
validate			Validates the details of a case participant role note.
validateModify			Validates the details of a case participant role note prior to modification
validateCancel			Validates the details of a case participant role note prior to cancellation.
readRecordStatus	nsread		Retrieves the record status of this Case Participant Role Note.
insert	insert	AUTO_ID: caseParticipantRoleNoteID PRE_DATA_ACCESS: yes	Inserts the details of a case participant role note.
modifyCaseParticipantRoleAndNote	nsmodify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Modifies the details of a case participant role note.
readParticipantCaseAndNote	ns		Retrieves the participant and sensitivity code, case id and sensitivity related to this case participant role note.	SQL
read			@superseded - replaced by readNote
modify			@superseded - replaced by modifyCaseParticipantRoleAndNote
searchByCaseParticipantRoleID1	nsmulti		Retrieves a list of Case Participant Role Notes.	SQL
readNote1	ns		Retrieves the details of a Case participant role note.	SQL
modify1			Modifies the details of a CaseParticipantRole note

Related Pages (0)

Database Table: CaseParticipantRoleNote