Table Description
Concern Role Contact: A party nominated by a participant to represent that participant in their interactions with the organization.

When a registered participant was not selected as the contact,the contact will be automatically registered as a participant of type representative.

Example

  • John Smith is a contact for his incapacitated brother.
  • ACME Ltd has two nominated contacts who manage all interactions between ACME Ltd and the organization.
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::ConcernRoleContact::ConcernRoleContact
Controlling File: core\model\Packages\Concern\ConcernRoleContact_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contactIDkeynoUnique reference number assigned by the system to a contact.CONTACT_ID SVR_INT64
concernRoleIDdetailsnoUnique reference of the Concern Role this contact is associated with. CONCERN_ROLE_ID SVR_INT64
contactConRoleIDdetailsyesThe Concern Role ID of the Contact.CONCERN_ROLE_ID SVR_INT64
contactTypeCodedetails Code value to indicate the type of contact.CONTACT_TYPE_CODEContactTypeSVR_STRING<10>
statusCodedetails Code value to indicate the status of the contact.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
namedetails Name of the non-registered contact.CONTACT_NAME SVR_STRING<131>
primaryAddressIDdetailsyesUnique reference number assigned to the address for this contact.ADDRESS_ID SVR_INT64
primaryPhoneNumberIDdetailsyesUnique reference number assigned to the phone number for this contact.PHONE_NUMBER_ID SVR_INT64
primaryEmailAddressIDdetailsyesUnique reference number assigned to the email address for this contact.EMAIL_ADDRESS_ID SVR_INT64
commentsdetails Free text registered by the User.COMMENTS SVR_STRING<300>
startDatedetails start date for this contact.CURAM_DATE SVR_DATE
endDatedetails end date for this contact.CURAM_DATE SVR_DATE
Foreign Keys (8)
ChildParent
ConcernRoleContact.primaryAddressIDAddress.addressID
ConcernRoleContact.concernRoleIDConcernRole.concernRoleID
ConcernRoleContact.contactConRoleIDConcernRole.concernRoleID
ConcernRoleContact.primaryEmailAddressIDEmailAddress.emailAddressID
ConcernRoleContact.primaryPhoneNumberIDPhoneNumber.phoneNumberID
ContactAddress.contactIDConcernRoleContact.contactID
ContactEmailAddress.contactIDConcernRoleContact.contactID
ContactPhoneNumber.contactIDConcernRoleContact.contactID
Indices (4)
Index NameAttributes
ConcRoleContIdxprimaryAddressID, primaryEmailAddressID, primaryPhoneNumberID, contactConRoleID
ContactConRoleIdxcontactConRoleID
ContactListIndexconcernRoleID
IND__354144204statusCode
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByConcernRoleIDnsreadmulti reads a list of all of the contacts for a specific concern 
searchActiveByConcernRoleIDnsreadmulti reads a list of all active contacts for a specific concern 
readByContactConRoleIDnsread Reads contact details by contact concern role ID. 
searchByContactConRoleIDnsreadmulti @deprecated Since Curam 6.0 SP2 ,replaced by searchByContactConcernRoleID. This method is deprecated because it did not follow the curam naming convention and hence replaced by searchByContactConcernRoleID. See release note: CEF-5893. 
searchByContactConcernRoleIDnsreadmulti reads a list of all active contacts for a specific Contact concern. 
Related Pages (66)
Add Prospect Employer (AddProspectEmployer_registerWizard)
Match Client (Application_matchClientConfirmation)
Edit Educational Institute (EducationalInstitute_modify)
Register Educational Institute (EducationalInstitute_register)
Edit Employer (Employer_modifyEmployer)
Register Employer (Employer_register)
Delete External Party Contact (ExternalParty_cancelContact)
New External Party Contact (ExternalParty_createUnregisteredCompanyContact)
Contacts (ExternalParty_listContact)
Edit Contact (ExternalParty_modifyCompanyContactFromList)
Edit Contact (ExternalParty_modifyCompanyContactFromView)
View External Party Contact (ExternalParty_viewCompanyContact)
Edit Information Provider (InformationProvider_modifyInformationProvider)
Register Information Provider (InformationProvider_register)
Contacts (Intake_listParticipantContact)
Contacts (Intake_listPersonContact)
Contacts (Intake_listProspectPersonContact)
Client Merge Wizard (Intake_MergeProspecrToPersonWizard)
Delete Contact (Participant_cancelContact)
New Contact (Participant_createRegisteredCompanyContact)
New Contact (Participant_createRegisteredContact)
New Contact (Participant_createUnregisteredCompanyContact)
New Contact (Participant_createUnregisteredContact)
New Email Communication (Participant_getEmailCorrespondent)
New Microsoft Word Communication (Participant_getMSWordCorrespondent)
New Pro Forma Communication (Participant_getProFormaCorrespondent)
Record Communication (Participant_getRecordCommCorrespondent)
Contacts (Participant_listCompanyContact)
Contacts (Participant_listContact)
Merge Duplicate (Participant_mergeContacts)
Client Merge Wizard (Participant_mergeWizard)
Client Merge Wizard (Participant_mergeWizardForViewDuplicate)
Edit Contact (Participant_modifyCompanyContactFromList)
Edit Contact (Participant_modifyCompanyContactFromView)
Edit Contact (Participant_modifyContactFromList)
Edit Contact (Participant_modifyContactFromView)
View Contact (Participant_viewCompanyContact)
View Contact (Participant_viewCompanyContact1)
Contact (Participant_viewContact)
View Contact (Participant_viewMergeContact)
Edit Person (Person_evidenceModify)
Edit Client Details (Person_evidenceModifyClient)
Edit Person (Person_modifyPerson)
Edit Product Provider (ProductProvider_modifyProductProvider)
Register Product Provider (ProductProvider_register)
Contacts (Prospect_listContact)
Register Employer (ProspectEmployer_duplicateCheckWizard)
Register Prospect Employer (ProspectEmployer_register)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Enroll Provider Group (ProviderManagement_enrollAsProviderGroup)
Enroll Provider Group (ProviderManagement_enrollProviderGroup)
Register Educational Institute (RegisterEducationalInstitute_registerWizard)
Register Employer (RegisterEmployer_registerWizard)
Register Information Provider (RegisterInformationProvider_registerWizard)
Register Product Provider (RegisterProductProvider_registerWizard)
Register Service Supplier (RegisterServiceSupplier_registerWizard)
Register Utility (RegisterUtility_registerWizard)
Edit Representative (Representative_modifyRepresentative)
Edit Representative (Representative_modifyRepresentativeDetails)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
Edit Service Supplier (ServiceSupplier_modifyServiceSupplier)
Register Service Supplier (ServiceSupplier_register)
Edit Utility (Utility_modifyUtility)
Register Utility (Utility_register)