Table Description
Prospect Employer Snapshot: Maintains a history of changes to a prospect employer record.

Example

If a user modifies, for example, the business description for a prospect employer, a snapshot of the prospect employer data prior to making this modification is written to the prospect employer snapshot table. Likewise when any of the prospect employer 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::ProspectEmployer::ProspectEmployerSnapshot
Controlling File: core\model\Packages\Concern\Prospect Employer_cat.efx
Attributes (19)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetails Identifier of the prospect employer participantCONCERN_ROLE_ID SVR_INT64
registeredNamedetails The registered name of this prospect employer.REGISTERED_NAME SVR_STRING<131>
tradingNamedetails The trading name of this prospect employer.TRADING_NAME SVR_STRING<131>
industryTypedetails Code value to denote the industry in which the prospect employer trades. Uses IndustryType codetable.INDUSTRY_TYPE_CODEIndustryTypeSVR_STRING<10>
companyTypedetails A code used to denote the company type of this prospect employer. Uses CompanyType codetableCOMPANY_TYPE_CODECompanyTypeSVR_STRING<10>
businessDescdetails Free text entered to describe the general nature of the business conducted by the employer.BUSINESS_DESCRIPTION SVR_STRING<100>
specialInterestCodedetails Code value to denote a special interest indication. Uses SpecialInterest codetable.SPECIAL_INTEREST_CODESpecialInterestSVR_STRING<10>
exemptionInddetails An indicator used to show if this prospect employer is exempt from the employer component of contributions products.CURAM_INDICATOR SVR_BOOLEAN
statusCodedetails Status of the prospect employer record i.e. Active or CanceledRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text entered by the user.COMMENTS SVR_STRING<300>
primaryAlternateIDdetails The primary alternate reference number for the prospect employer.ALTERNATE_ID SVR_STRING<18>
numberPermanentStaffdetails The number of permanent employees.NUMBER_PERMANENT_STAFF SVR_INT32
numberCasualStaffdetails The number of casual employees.NUMBER_CASUAL_STAFF SVR_INT32
pinNumberdetails The personal identification number (PIN) for this prospect employer.CUSTOMER_PIN_NUMBER SVR_STRING<4>
employerConcernRoleIDdetails The related employer concernRoleID if this prospect employer has been registered as an employerCONCERN_ROLE_ID SVR_INT64
prospectEmployerSnapshotIDkeynoUnique identifier of the prospect employer snapshot record.INTERNAL_ID SVR_INT64
creationDateTimedetails The date and time the prospect employer snapshot record was created.CURAM_DATETIME SVR_DATETIME
upperRegisteredNamedetailsyesThe registered name of the Prospect Employer stored in upper case format.REGISTERED_NAME SVR_STRING<131>
upperTradingNamedetailsyesThe trading name of the Prospect Employer stored in upper case format.TRADING_NAME SVR_STRING<131>
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: prospectEmployerSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByConcernRoleIDnsmulti Retrieves a list of Prospect Employer Snapshot details for the specified concernRoleID.SQL
Related Pages (1)