Table Description
Concern Role Snapshot: Maintains a history of changes to concern role record.

Example

If a user modifies, for example, the primary alternate ID for a participant, a snapshot of the participant data prior to making this modification is written to the concern role snapshot table. Likewise when any of the participant details are modified a snapshot of the previous version of the record is created.
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::ConcernRole::ConcernRoleSnapshot
Controlling File: core\model\Packages\Concern\ConcernRole_cat.efx
Attributes (25)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernIDdetailsnoIdentifier of the concern record associated with this participant.CONCERN_ID SVR_INT64
concernRoleIDdetails Identifier of the participants concern role record.CONCERN_ROLE_ID SVR_INT64
concernRoleTypedetails Code value to denote the type of role for this instance of interaction between the participant and the organization e.g. employer, person etc. Uses ConcerRoleType codetable.CONCERN_ROLE_TYPE_CODEConcernRoleTypeSVR_STRING<10>
creationDatedetails Date participant, in that role, was created on the system.CURAM_DATE SVR_DATE
registrationDatedetails Date participant, in that role, was officially registered.CURAM_DATE SVR_DATE
startDatedetails Date on which the concern, in that role, initiated an interaction with the organization.CURAM_DATE SVR_DATE
endDatedetails Date on which the concern, in that role, ended an interaction with the organization.CURAM_DATE SVR_DATE
statusCodedetails Code value to indicate the status of the concern role record. Uses ConcernRoleStatus codetable.CONCERN_ROLE_STATUS_CODEConcernRoleStatusSVR_STRING<10>
concernRoleNamedetails The name utilized by the participant in their interaction with the organization in that role type.CONCERN_ROLE_NAME SVR_STRING<131>
primaryAddressIDdetailsyesThe identifier of the primary address for the participant in this role.ADDRESS_ID SVR_INT64
primaryAlternateIDdetails The primary reference number used to identify the participant in this role.ALTERNATE_ID SVR_STRING<18>
commentsdetails Free text entered by the User.COMMENTS SVR_STRING<300>
primaryPhoneNumberIDdetailsyesIdentifier of the primary phone number for the participant in this role.PHONE_NUMBER_ID SVR_INT64
primaryEmailAddressIDdetailsyesIdentifier of the primary email address for the participant in this role.EMAIL_ADDRESS_ID SVR_INT64
primaryBankAccountIDdetailsyesIdentifier of the primary bank account for the participant in this role.BANK_ACCOUNT_ID SVR_INT64
regUserNamedetails The name of the user who registered the participant.USER_NAME SVR_STRING<64>
prefPublicOfficeIDdetailsyesIdentifier of the public office the participant prefers to attend for their interactions with the organization.PUBLIC_OFFICE_LOCATION_ID SVR_INT64
preferredLanguagedetails The language type preferred by the participant in their verbal and written communications with the organization.LANGUAGE_CODELanguageSVR_STRING<10>
sensitivitydetails The sensitivity level of the participant in this role.SENSITIVITY_CODESensitivitySVR_STRING<10>
prefCommMethoddetails Codetable code indicating the preferred method of communication of the participant in this role. Uses CommunicationMethod codetable.COMMUNICATION_METHOD_CODECommunicationMethodSVR_STRING<10>
prefCommFromDatedetails Start date for the preferred communication methodCURAM_DATE SVR_DATE
prefCommToDatedetails End date for the preferred communication method.CURAM_DATE SVR_DATE
primaryWebAddressIDdetailsyesIdentifier of the primary web address for the participant in this role.WEB_ADDRESS_ID SVR_INT64
concernRoleSnapshotIDkeynoUnique identifier of the concern role snapshot record.INTERNAL_ID SVR_INT64
creationDateTimedetails The date and time the snapshot was created.CURAM_DATETIME SVR_DATETIME
Foreign Keys (6)
ChildParent
ConcernRoleSnapshot.primaryAddressIDAddress.addressID
ConcernRoleSnapshot.primaryBankAccountIDBankAccount.bankAccountID
ConcernRoleSnapshot.primaryEmailAddressIDEmailAddress.emailAddressID
ConcernRoleSnapshot.prefPublicOfficeIDLocation.locationID
ConcernRoleSnapshot.primaryPhoneNumberIDPhoneNumber.phoneNumberID
ConcernRoleSnapshot.primaryWebAddressIDWebAddress.webAddressID
Indices (6)
Index NameAttributes
IND_578557650primaryAddressID
IND_1578344047primaryBankAccountID
IND_502120176primaryEmailAddressID
IND__1318752056prefPublicOfficeID
IND_414715637primaryPhoneNumberID
IND_2037289336primaryWebAddressID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: concernRoleSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
Related Pages (0)