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

Example

The concern role address captures an address in the context of a particular concern role. Therefore if a user modifies, for example, the date on which an address ends applicability for this concern role, a snapshot of the concern role address data prior to making this modification is written to the concern role address snapshot table. Likewise when any of the concern role address details are modified a snapshot of the previous version of the record is created.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Concern::Entity Objects::ConcernRoleAddress::ConcernRoleAddressSnapshot
Controlling File: core\model\Packages\Concern\ConcernRoleAddress_cat.efx
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleAddressIDdetails Identifier of the related concern role address record.CONCERN_ROLE_ADDRESS_ID SVR_INT64
concernRoleIDdetailsnoIdentifier of the participant for whom the address is maintained.CONCERN_ROLE_ID SVR_INT64
addressIDdetailsnoIdentifier of the address record.ADDRESS_ID SVR_INT64
typeCodedetails Code value to indicate the type of address e.g. business, private. Uses AddressType codetable.ADDRESS_TYPE_CODEAddressTypeSVR_STRING<10>
startDatedetails Date on which the address started to be applicable to the participant in this role.CURAM_DATE SVR_DATE
endDatedetails Date on which the address ceased to be applicable to the participant in this role.CURAM_DATE SVR_DATE
statusCodedetails Code value to indicate the status of the concern role address record. i.e. Active or Canceled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text entered by a user in relation to the address for the participant in this role.COMMENTS SVR_STRING<300>
concernRoleAddressSnapshotIDkeynoUnique identifier of concern role address snapshot record.INTERNAL_ID SVR_INT64
creationDateTimedetails The date and time the concern role address snapshot was created.CURAM_DATETIME SVR_DATETIME
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: concernRoleAddressSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByAddressIDnsmulti Method to return a list of all Concern Role Address Snapshot records for a concernRoleAddressID.SQL
Related Pages (2)