Table Description
Employer Snapshot: Maintains a history of changes to the employer details record.

Example

If a user modifies, for example, the business description for the employer, a snapshot of the employer data prior to making this modification is written to the employer snapshot table. Likewise when any of the 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::Employer::EmployerSnapshot
Controlling File: core\model\Packages\Concern\Employer_cat.efx
Attributes (22)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetails Identifier of the employer participant record.CONCERN_ROLE_ID SVR_INT64
registeredNamedetails The name, label or business identity associated with the employer which is legally registered with the appropriate government agency and through which the employer is addressed.REGISTERED_NAME SVR_STRING<131>
tradingNamedetails The name, label or business identity associated with the employer and under which they trade.TRADING_NAME SVR_STRING<131>
industryTypedetails Code value to denote the industry in which the employer trades. Uses IndustryType codetable.INDUSTRY_TYPE_CODEIndustryTypeSVR_STRING<10>
companyTypedetails Code value to denote the type of company. Uses CompanyType codetable.COMPANY_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 to denote if an EOP return is exempted or not for submission to the organization.CURAM_INDICATOR SVR_BOOLEAN
statusCodedetails Code table code describing the record status of the employer snapshot record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text entered by the user.COMMENTS SVR_STRING<300>
primaryAlternateIDdetails The primary alternate reference number for the employer.ALTERNATE_ID SVR_STRING<18>
numberPermanentStaffdetails An estimated number of permanent staff for the employer.NUMBER_PERMANENT_STAFF SVR_INT32
numberCasualStaffdetails An estimated number of casual staff for the employer.NUMBER_CASUAL_STAFF SVR_INT32
pinNumberdetails Employer's personal identification number (PIN). This personal information number allows them to identify themselves to a number of online Curam services.CUSTOMER_PIN_NUMBER SVR_STRING<4>
paymentFrequencydetails The frequency for which any payments due to the employer will be made, e.g., weekly, monthly.FREQUENCY_PATTERN SVR_STRING<9>
nextPaymentDatedetails The next payment calculation date for the employer.CURAM_DATE SVR_DATE
currencyTypedetails The preferred currency for the employer.CURRENCY_CODECurrencySVR_STRING<10>
methodOfPmtCodedetails Code to denote preferred method of payment of the employer.METHOD_OF_DELIVERY_CODEMethodOfDeliverySVR_STRING<10>
employerSnapshotIDkeynoUnique identifier of the employer snapshot record.INTERNAL_ID SVR_INT64
creationDateTimedetails The date and time the employer snapshot record was created.CURAM_DATETIME SVR_DATETIME
upperRegisteredNamedetailsyesThe registered name of the Employer stored in upper case format.REGISTERED_NAME SVR_STRING<131>
upperTradingNamedetailsyesThe trading name of the Employer stored in upper case format.TRADING_NAME SVR_STRING<131>
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: employerSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByConcernRoleIDnsmulti Retrieves a list of Employer Snapshot details for the specified concernRoleID.SQL
Related Pages (1)