Table Description
Citizenship Snapshot: Maintains a history of changes to citizenship record.

Example

If a user modifies, for example, the reason for a participants citizenship record, a snapshot of the citizenship data prior to making this modification is written to the citizenship snapshot table. Likewise when any of the citizenship 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::Citizenship::CitizenshipSnapshot
Controlling File: core\model\Packages\Concern\Citizenship_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetailsnoIdentifier of the participant for whom the citizenship record captured.CONCERN_ROLE_ID SVR_INT64
reasonCodedetails Code value to indicate the reason for Citizenship. Uses CitizenshipReason codetable.CITIZENSHIP_REASON_CODECitizenshipReasonSVR_STRING<10>
countryCodedetails Code value to indicate the country of citizenship. Uses Country codetable.COUNTRY_CODECountrySVR_STRING<10>
fromDatedetails Date citizenship is effective from.CURAM_DATE SVR_DATE
toDatedetails Date citizenship is effective to.CURAM_DATE SVR_DATE
statusCodedetails Code value to indicate the status of the citizenship record. i.e. Active or Canceled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
citizenshipSnapshotIDkeynoUnique identifier of the citizenship snapshot record.INTERNAL_ID SVR_INT64
commentsdetails Free text entered by the user.COMMENTS SVR_STRING<300>
citizenshipIDdetails Unique reference number of the related Citizenship record.CITIZENSHIP_ID SVR_INT64
creationDateTimedetails The date and time the citizenship snapshot record was createdCURAM_DATETIME SVR_DATETIME
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: citizenshipSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByCitizenshipIDnsmulti Retrieves a list of CitizenshipSnapshot details for the specified citizenshipID.SQL
Related Pages (1)