Table Description
Alternate Name Snapshot: Maintains a history of changes to alternate name record.

Example

If a user modifies, for example, the title aspect of an alternate name record, a snapshot of the alternate name data prior to making this modification is written to the alternate name snapshot table. Likewise when any of the alternate name 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::AlternateName::AlternateNameSnapshot
Controlling File: core\model\Packages\Concern\AlternateName_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (17)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
alternateNameSnapshotIDkeynoUnique identifier of the alternate name snapshot record.ALTERNATE_NAME_SNAPSHOT_ID SVR_INT64
alternateNameIDdetails Identifier of the related alternate name record.ALTERNATE_NAME_ID SVR_INT64
concernRoleIDdetails Identifier of the participant for whom the alternate name was capturedCONCERN_ROLE_ID SVR_INT64
titledetails A form of nomenclature identifying the person's status.TITLE SVR_STRING<15>
firstForenamedetails The first or Christian name of the person.FIRST_FORENAME SVR_STRING<65>
otherForenamedetails An alternative Christian or name for the person.OTHER_FORENAME SVR_STRING<65>
surnamedetails The common name, or the hereditary name, of the person.SURNAME SVR_STRING<65>
nameSuffixdetails An extension to a name.NAME_SUFFIX SVR_STRING<20>
nameTypedetails Code value to denote the type of name recorded e.g. registered name, preferred name. Uses AlternateNameType codetable.ALTERNATE_NAME_TYPE_CODEAlternateNameTypeSVR_STRING<10>
nameStatusdetails Code value to indicate the status of the alternate name i.e. Active or Canceled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
fullNamedetails Combination of forename + surname.CONCERN_ROLE_NAME SVR_STRING<131>
commentsdetails Free text entered by the user.COMMENTS SVR_STRING<300>
initialsdetails The initials of the person.PERSON_INITIALS SVR_STRING<10>
creationDateTimedetails The date and time the alternate name snapshot record was created.CURAM_DATETIME SVR_DATETIME
phoneticEncodingdetailsyesPhonetic encode value for surname.PHONETIC_ENCODING SVR_STRING<4>
upperFirstForenamedetailsyesThe first forename in uppercase format.FIRST_FORENAME SVR_STRING<65>
upperSurnamedetailsyesThe surname in uppercase format.SURNAME SVR_STRING<65>
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: alternateNameSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByAlternateNameIDnsmulti Retrieves a list of alternate name snapshot details for the specified alternate name record. SQL
Related Pages (1)