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

Example

If a user modifies, for example, the nationality for a prospect person, a snapshot of the prospect person data prior to making this modification is written to the prospect person snapshot table. Likewise when any of the prospect 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::ProspectPerson::ProspectPersonSnapshot
Controlling File: core\model\Packages\Concern\Prospect Person_cat.efx
Attributes (30)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetails Identifier of the prospect person participant..CONCERN_ROLE_ID SVR_INT64
personBirthNamedetails The surname of the prospect person when they where born i.e. as stated on birth certification.PERSON_BIRTH_NAME SVR_STRING<65>
dateOfBirthdetails The date of birth of the prospect person.CURAM_DATE SVR_DATE
dateOfDeathdetails The date of death of the prospect person.CURAM_DATE SVR_DATE
genderdetails The classification of the prospect 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 prospect person. Uses MaritalStatus codetable.MARITAL_STATUS_CODEMaritalStatusSVR_STRING<10>
nationalityCodedetails The code with denotes the nationality of the prospect person. Uses Nationality codetable.NATIONALITY_CODENationalitySVR_STRING<10>
residencyAbroadInddetails An indicator to show if the prospect is a resident in another country.CURAM_INDICATOR SVR_BOOLEAN
motherBirthSurnamedetails The surname of the prospects mother when she was born.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 An indicator to show if the prospect persons date of birth has been verified.CURAM_INDICATOR SVR_BOOLEAN
dateOfDeathVerInddetails An indicator to show if the prospect persons date of death has been verified.CURAM_INDICATOR SVR_BOOLEAN
primaryAlternateIDdetails The primary alternate reference number of the prospect person.ALTERNATE_ID SVR_STRING<18>
countryOfBirthdetails A code to denote the country of birth of the prospect person.COUNTRY_CODECountrySVR_STRING<10>
placeOfBirthdetails The place of birth for this prospect person.PLACE_OF_BIRTH SVR_STRING<30>
pinNumberdetails The personal identification number (PIN) used by this prospect person when accessing the systemCUSTOMER_PIN_NUMBER SVR_STRING<4>
primaryAlternateNameIDdetails Unique internal reference number assigned to the primary alternate name for the prospect person.ALTERNATE_NAME_ID SVR_INT64
ethnicOriginCodedetails Code representing the ethnic origin of the person. Uses EthnicOrigin codetable.ETHNIC_ORIGIN_CODEEthnicOriginSVR_STRING<10>
personConcernRoleIDdetails The related person concernRoleID if this prospect person has been registered as an personCONCERN_ROLE_ID SVR_INT64
prospectPersonSnapshotIDkeynoUnique identifier of the prospect person snapshot record.INTERNAL_ID SVR_INT64
creationDateTimedetails The date and time the prospect person snapshot record was createdCURAM_DATETIME SVR_DATETIME
fromAgedetails The start of the estimated age range for the prospect person, where only an estimated age range is available for the prospect person in place of a precise date of birth.FROM_AGE SVR_INT32
toAgedetails The end of the estimated age range for the prospect person, where only an estimated age range is available for the prospect person in place of a precise date of birth.TO_AGE SVR_INT32
upperPersonBirthNamedetailsyesThe prospect person's birth name in uppercase format.PERSON_BIRTH_NAME SVR_STRING<65>
upperMotherBirthSurnamedetailsyesThe birth name of the prospect person's mother in uppercase format.MOTHER_BIRTH_SURNAME SVR_STRING<65>
racedetailsyesCode to denote the race of the prospect person.RACE_TAB_LIST SVR_STRING<200>
indigenousPersonInddetailsyesIndicator to denote whether the prospect person is indigenous.CURAM_INDICATOR SVR_BOOLEAN
indigenousGroupCodedetailsyesCode to denote indigenous group code of the prospect person.INDIGENOUS_TAB_LIST SVR_STRING<250>
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: prospectPersonSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByConcernRoleIDnsmulti Method to return a list of all Prospect Person snapshot records for a concernRoleID.SQL
Related Pages (1)