D:ConcernRoleRelationship

Table Description

Concern Role Relationship: A relationship between two participants.

A participant many have many concern role relationships. Concern role relationships can be created between any two participant types.

Relationships are always created in pairs. When a concern role relationship is created, e.g. 'Father to Son', the reciprocal 'Son to Father' concern role relationship is automatically created.

Example

John Smith is the father of Robert Smith. A 'Parent to Child' relationship is created between John and Robert Smith. The reciprocal relationship is a 'Child to Parent' relationship between Robert Smith and John Smith.

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::Concern::Entity Objects::ConcernRoleRelationship::ConcernRoleRelationship
Controlling File:	core\model\Packages\Concern\ConcernRoleRelationship_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING	yes
LAST_UPDATED_FIELD	yes

Attributes (12)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
concernRoleID	details	no	Unique reference number assigned by the system to a Concern Role record.	CONCERN_ROLE_ID		SVR_INT64
concernRoleType	details		Code value to denote the type of concern role.	CONCERN_ROLE_TYPE_CODE	ConcernRoleType	SVR_STRING<10>
relConcernRoleID	details	no	Concern Role ID of the Concern related to this Concern.	CONCERN_ROLE_ID		SVR_INT64
relConcernRoleType	details		Code value to indicate the Role Type of the Related Concern.	CONCERN_ROLE_TYPE_CODE	ConcernRoleType	SVR_STRING<10>
startDate	details		Date on which the Concern Role Relationship was registered as having commenced.	CURAM_DATE		SVR_DATE
endDate	details		Date on which the Concern Role Relationship was registered as having ceased.	CURAM_DATE		SVR_DATE
relationshipType	details		Code value to denote the type of the relationship between Concerns.	RELATIONSHIP_TYPE_CODE	RelationshipTypeCode	SVR_STRING<10>
relEndReasonCode	details		Code to denote the reason for the cessation of the Concern Role Relationship.	RELATIONSHIP_END_REASON_CODE	RelationshipEndReason	SVR_STRING<10>
statusCode	details		Code table code describing the record status of the concern role relationship record.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>
comments	details		Free text registered by the User.	COMMENTS		SVR_STRING<300>
concernRoleRelationshipID	key	no	Unique internal reference number assigned to the concern role relationship.	CONCERN_ROLE_RELATIONSHIP_ID		SVR_INT64
concernRoleRecipRelationID	details	no	This field will be populated by the concernRoleRelationshipID for the reciprocal relationship and is therefore a foreign key to this table - however, this key cannot be constrained since rows on this entity are inserted in pairs (row A references row B and vice versa) - so when row A is inserted, row B does not yet exist.	CONCERN_ROLE_RELATIONSHIP_ID		SVR_INT64

Foreign Keys (4)

Child	Parent
ConcernRoleRelationship.concernRoleID	ConcernRole.concernRoleID
ConcernRoleRelationship.relConcernRoleID	ConcernRole.concernRoleID
HouseholdRelationship.concernRoleRelationshipID	ConcernRoleRelationship.concernRoleRelationshipID
ISHholdRshipEvidence.participantRoleRshipID	ConcernRoleRelationship.concernRoleRelationshipID

Indices (2)

Index Name	Attributes
CRRelationshipInd	concernRoleID, relConcernRoleID, relationshipType, endDate, startDate, statusCode
CRRecipRelIndx	concernRoleRecipRelationID

Operations (14)

Operation	Stereotype	Options	Description	SQL
insert	insert	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Standard insert method. If participant data case is enabled for persons/prospect persons then an exception will be thrown if the insert method is called for a person or prospect person from outside of the participant data case module.
modify	modify	OPTIMISTIC_LOCKING: yes POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Standard modify method. If participant data case is enabled for persons/prospect persons then an exception will be thrown if the modify method is called for a person or prospect person from outside of the participant data case module.
read	read		Standard Operation
remove	remove	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Standard remove method. If participant data case is enabled for persons/prospect persons then an exception will be thrown if the remove method is called for a person or prospect person from outside of the participant data case module.
searchByConcernRoleID	readmulti		method to return all relationships for the given ConcernRoleID
countRelationships	ns		Counts the number of a relationship type for a particular concern role.	SQL
searchByConcernRoleIDAndType	nsreadmulti		Method that retrieves all concern role relationships by concern role identifier and relationship type
readExistingRelationship	nsread		Reads a concern role relationship record based on the concern role ID, related concern role ID and the relationship type.
readReciprocalRelationship	nsread		reads a concern role relationship using the reciprocal relationship ID key
searchDuplicateRelationship	nsmulti		Searches for a duplicate Relationship based on the relationship details	SQL
searchByConcernRoleIDAndStatus	nsreadmulti		Method which returns a list of concernRoleRelationships based on a concernRoleID and a statusCode.
readRelatedConcernDetails	nsread		Retrieve the details of the Related Concern from a Concern Role Relationship.
pdcInsert	nsinsert	POST_DATA_ACCESS: yes	Invocation of this method is restricted and should only be called by PDC classes.
pdcModify	nsmodify	OPTIMISTIC_LOCKING: yes POST_DATA_ACCESS: yes	Invocation of this method is restricted and should only be called by PDC classes.

Related Pages (208)

Add Prospect Employer (AddProspectEmployer_registerWizard)
Add Client (Application_AddClientConfirmation)
Application_ClientDetails
Edit Date Added (Application_editClientDetails)
New Email Communication (Application_getEmailCorrespondent)
New MS Word Communication (Application_getMSWordCorrespondentCaseMember)
New Pro Forma Communication (Application_getProFormaCorrespondent)
Record Communication (Application_getRecordCommCorrespondent)
Communications (Application_listCommunication)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
Clients (ApplicationClients)
ApplicationContextPanel
Register Person (BenefitSample_registerPerson)
CAProductHomeDetails
Add Family as Case Members (Case_createCaseRelatedMember)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
CHIPProductHomeDetails
Add Client (CommonIntake_addClient)
Register Client (CommonIntake_registerClient)
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
Person Home: (DecisionAssistApplication_viewMemberHomeForProductDelivery)
Home (DefaultIC_home)
Case Members (DefaultIC_listCaseMember)
Integrated Case Prospect Person Home (DefaultICProspectPerson_home)
New Special Caution (DefaultICSpecialCaution_createFromCase)
Test Widget (Discussion_testWidget)
Related Companies (EducationalInstitute_listRelatedCompany)
Delete Company Relationship (Employer_cancelRelatedCompany)
New Company Relationship (Employer_createRelatedCompany)
New Trading Status (Employer_createTradingStatus)
Related Companies (Employer_listRelatedCompany)
Edit Employer (Employer_modifyEmployer)
Edit Company Relationship (Employer_modifyRelatedCompany)
Edit Trading Status (Employer_modifyTradingStatusFromList)
Edit Trading Status (Employer_modifyTradingStatusFromView)
Register Employer (Employer_register)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_wzSelAllCre)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Household Relationship Evidence (EVD_createHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_createHouseholdRelationshipEvidence_wzSelAllCre)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Household Relationship Evidence (EVD_modifyHouseholdRelationshipEvidence)
View Household Relationship Evidence (EVD_viewHouseholdRelationshipEvidence)
View Household Relationship Evidence (EVD_viewHouseholdRelationshipEvidenceHistRec)
Home (EVD_viewHouseholdRelationshipEvidenceObject)
View Household Relationship Evidence (EVD_viewHouseholdRelationshipEvidenceSnapshot)
Select Member And Case For Evidence Transfer (Evidence_selectMemberAndCase)
Evidence Site Map (Evidence_siteMap)
FAProductHomeDetails
Add Member (HCRAddMemberWizard_summary)
Case Members (HCRDefaultIC_listCaseMember)
Apply Changes (HCREvidence_applyChanges)
Home (HCRIC_home)
New Investigation (ICInvestigationSample_create)
Select Member (ICInvestigationSample_selectParticipant)
Home (ICSample_home)
Case Members (ICSample_listCaseMember)
Integrated Case Person Home (ICSample_personHome)
Integrated Case Prospect Person Home (ICSample_prospectPersonHome)
Register Person (ICSample_registerPerson)
Site Map (ICSample_sportingGrantSiteMap)
Home (ICSampleSportingGrant_home)
Case Members (ICSampleSportingGrant_listCaseMember)
Register Person (IncomeScreening_registerHouseholdMember)
Register Person (IncomeScreening_registerPerson)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidence)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidenceFromCreate)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidenceFromList)
Transfer Evidence: (IncomeSupportScreening_confirmTransferEvidence)
New Household Member Details: (IncomeSupportScreening_createISHouseholdEvidence)
New Relationships For: (IncomeSupportScreening_createISHouseholdRshipEvidence)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidence)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidenceFromCreate)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidenceFromList)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Select the Head of the Household (IncomeSupportScreening_transferEvidence)
Confirm Prospect Person Not Already Registered as Person (Individual_duplicateProspectPersonRegistrationCheck)
Person Information (Individual_homePage)
Prospect Information (Individual_prospectHomePage)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
New Interview (Intake_createInterview)
Withdraw Program Request (Intake_createProgramWithdrawalRequest)
Withdraw Program Request (Intake_createProgramWithdrawalRequest1)
Register Prospect as Person (Intake_duplicateCheckForRegisterProspectPerson)
Invite Attendees (Intake_inviteAttendee)
Related Persons (Intake_listRelatedPerson)
Relationships (Intake_listRelationship)
Client Merge Wizard (Intake_MergeProspecrToPersonWizard)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
New Contract (IntegratedCase_createContract)
New Referral (IntegratedCase_createReferral)
Edit Case Details (IntegratedCase_modifyHeader)
List View (IntegratedCase_timelineCalendarList)
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Integrated Case Person Home (ISP_personHome)
Register Person (ISP_registerPerson)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
Guided Change (ISPApplication_listGuidedChange)
ISPCaseHomeDetails
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Participant Details (ISPPerson_editPersonParticipantDetails)
Participant Details (ISPPerson_editProspectPersonParticipantDetails)
Participant Details (ISPPerson_listPersonParticipantDetails)
Participant Details (ISPPerson_listProspectPersonParticipantDetails)
Re-add a Member (ISReAddMemberWizard_submit)
New Issue Case (IssueDelivery_selectEvidenceIssueTypeForICWizard)
Person Home (LegalAction_Personhome)
Create Legal Status (LegalStatus_createLegalStatusFromCase)
Register Person (LiabilitySample_registerPerson)
LIFCProductHomeDetails
LTCProductHomeDetails
Mark Duplicate (Participant_markDuplicate)
Merge Duplicate (Participant_mergeRelationships)
Client Merge Wizard (Participant_mergeWizard)
Client Merge Wizard (Participant_mergeWizardForViewDuplicate)
Delete Relationship (Person_cancelRelationship)
New Relationship (Person_createRelationship)
Person Home (Person_duplicateHomePage)
Edit Person (Person_evidenceModify)
Edit Client Details (Person_evidenceModifyClient)
Home (Person_homePage)
Home (Person_homePagePDC)
Person Home (Person_homePageTransaction)
Relationships (Person_listRelationship)
Relationship (Person_listRelationshipHistory)
Edit Person (Person_modifyPerson)
Edit Relationship (Person_modifyRelationship)
Edit Relationship (Person_modifyRelationshipFromList)
Edit Relationship (Person_modifyRelationshipFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
ProductHomeDetails
Home (Prospect_homePage)
Edit Prospect (Prospect_modifyProspect)
Confirm Registration (Prospect_registerPersonFromProspect)
Delete Company Relationship (ProspectEmployer_cancelRelatedCompany)
New Company Relationship (ProspectEmployer_createRelatedCompany)
Register Employer (ProspectEmployer_duplicateCheckWizard)
Related Companies (ProspectEmployer_listRelatedCompany)
Edit Prospect Employer (ProspectEmployer_modifyProspectEmployer)
Edit Company Relationship (ProspectEmployer_modifyRelatedCompany)
Register Prospect Employer (ProspectEmployer_register)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Delete Relationship (ProspectPerson_cancelRelationship)
New Relationship (ProspectPerson_createRelationship)
Register Prospect as Person (ProspectPerson_duplicateCheckForPDCWizard)
Register Prospect as Person (ProspectPerson_duplicateCheckWizard)
Confirm Prospect Person Not Already Registered as Person (ProspectPerson_duplicatePersonRegistrationCheck)
Confirm Prospect Person Not Already Registered as Person (ProspectPerson_duplicatePersonRegistrationCheck1)
View Prospect Person Details (ProspectPerson_evidenceView)
Prospect Person Details (ProspectPerson_evidenceViewObject)
Home (ProspectPerson_homePage)
Home (ProspectPerson_homePagePDC)
Relationships (ProspectPerson_listRelationship)
Edit Prospect Person (ProspectPerson_modifyProspectPerson)
Edit Relationship (ProspectPerson_modifyRelationshipFromList)
Edit Relationship (ProspectPerson_modifyRelationshipFromView)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Prospect Person Home (ProspectPersonRegisteredAsPerson_home)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
RefugeeProductHomeDetails
Register Employer (RegisterEmployer_registerWizard)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
Site Map (Sample_sportingGrantProductSiteMap)
Add Service Plan (ServicePlanDelivery_ICCreate)
Add Service Plan (ServicePlanDelivery_ICCreateNoTabs)
New Special Caution (SpecialCaution_createFromCase)
SpendDownProductHomeDetails
Renew TB Product Delivery (TBBCC_RenewProductDelivery)
TBBCCProductHomeDetails

Database Table: ConcernRoleRelationship