Table Description
Person Snapshot: Maintains a history of changes to a person record.

Example

If a user modifies, for example, the mothers birth name for a person, a snapshot of the person data prior to making this modification is written to the person snapshot table. Likewise when any of the person 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::Person::PersonSnapshot
Controlling File: core\model\Packages\Concern\Person_cat.efx
Attributes (31)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetails Identifier of the person participant record.CONCERN_ROLE_ID SVR_INT64
personBirthNamedetails Surname as stated on birth certification.PERSON_BIRTH_NAME SVR_STRING<65>
dateOfBirthdetails An identification date to record the date, month and year of birthCURAM_DATE SVR_DATE
dateOfDeathdetails An identification date to record the date, month and year of death.CURAM_DATE SVR_DATE
genderdetails The classification of the person as either male or female. Uses Gender codetable.GENDER SVR_STRING<10>
specialInterestCodedetails Code value to denote a special interest type. Uses SpecialInterest codetable.SPECIAL_INTEREST_CODESpecialInterestSVR_STRING<10>
maritalStatusCodedetails Code to denote the state of marriage of the person. Uses MaritalStatus codetable.MARITAL_STATUS_CODEMaritalStatusSVR_STRING<10>
nationalityCodedetails Code to denote the nationality of the person. Uses Nationality codetable.NATIONALITY_CODENationalitySVR_STRING<10>
residencyAbroadInddetails Indicator to denote whether the person has a record of residency abroad.CURAM_INDICATOR SVR_BOOLEAN
motherBirthSurnamedetails The surname, or the hereditary surname, of the person's mother.MOTHER_BIRTH_SURNAME SVR_STRING<65>
commentsdetails Free text entered by the user.COMMENTS SVR_STRING<300>
typedetails Provides a categorization of person data into Insured, Uninsured or Child. Uses PersonType codetable.PERSON_TYPE_CODEPersonTypeSVR_STRING<10>
dateOfBirthVerInddetails Indicator value that indicates whether the date of Birth has been verified.CURAM_INDICATOR SVR_BOOLEAN
dateOfDeathVerInddetails Indicator value that indicates whether or not the entered date of death has been verified.CURAM_INDICATOR SVR_BOOLEAN
primaryAlternateIDdetails The primary alternate reference number of the person.ALTERNATE_ID SVR_STRING<18>
countryOfBirthdetails The country of birth of the person.COUNTRY_CODECountrySVR_STRING<10>
placeOfBirthdetails The place of birth of the person.PLACE_OF_BIRTH SVR_STRING<30>
pinNumberdetails The PIN (personal identification number) used by a person when accessing the system.CUSTOMER_PIN_NUMBER SVR_STRING<4>
primaryAlternateNameIDdetails Unique internal reference number assigned to the primary alternate name for the person.ALTERNATE_NAME_ID SVR_INT64
ethnicOriginCodedetails Code representing the ethnic origin of the person. Uses EthnicOrigin codetable.ETHNIC_ORIGIN_CODEEthnicOriginSVR_STRING<10>
paymentFrequencydetails The frequency at which payment due to be person should be made.FREQUENCY_PATTERN SVR_STRING<9>
nextPaymentDatedetails The next scheduled date for issuing payments to the person.CURAM_DATE SVR_DATE
currencyTypedetails The preferred currency for the person.CURRENCY_CODECurrencySVR_STRING<10>
methodOfPmtCodedetails Code to denote preferred method of payment of the person.METHOD_OF_DELIVERY_CODEMethodOfDeliverySVR_STRING<10>
personSnapshotIDkeynoUnique identifier of the person snapshot record.INTERNAL_ID SVR_INT64
creationDateTimedetails The date and time the person snapshot record was created.CURAM_DATETIME SVR_DATETIME
indigenousGroupCodedetailsyesCode to denote indigenous group code of the person.INDIGENOUS_TAB_LIST SVR_STRING<250>
indigenousPersonInddetailsyesIndicator to denote whether the person is indigenous.CURAM_INDICATOR SVR_BOOLEAN
racedetailsyesCode to denote the race of the person.RACE_TAB_LIST SVR_STRING<200>
upperMotherBirthSurnamedetailsyesThe birth name of the person's mother in uppercase format.MOTHER_BIRTH_SURNAME SVR_STRING<65>
upperPersonBirthNamedetailsyesThe person's birth name in uppercase format.PERSON_BIRTH_NAME SVR_STRING<65>
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: personSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByConcernRoleIDnsmulti Method to return a list of all Person Snapshot records for a concernRoleID.SQL
Related Pages (1)