Question about using ISD for benefit update

karen-fields

Hello,

I will preface this question by saying I am not overly familiar with using ISD.

I am trying to test using ISD for a benefit update where a lot of staff are getting salary updates and due to that will have updates made to their life insurance plans.  Instead of processing these manaully (we currently don't have salary updates set to update immediately) I would like to use ISD to do a mass update to process these changes.

I first am querying those who have an unprocessed salary update, then filtering that query by salary change and date.  When I try to do the upload action 'ProcessChange' I am getting the error: **ERROR: Entry with key values HROrganization=1000,Employee=11111111,BenefitPlan=VADE,EmployeeBenefit16, not found.

Is anyone familiar with this error message?  Am I missing something in my upload?  

reaganr

Hi Karen,

We do not run salary updates with update immediately checked either. When we have mass pay rate changes for the majority of our employees, I use an ISD upload to process the changes to our benefit plan that is impacted. My ISD upload properties have the BenefitUpdate business class specified with the Action of ProcessChange. I have many fields in my upload, probably more than you need but I've listed them below and do not get an error. You might try adding the SequenceNumber as a start.

HROrganization

Employee

BenefitPlan

EmployeeBenefit

SequenceNumber

EffectiveDate

CalculatedStopDate

Status

UpdateType

ChangeDate

CoverageSalary

NewCoverageSalary

ContributionSalary

NewContributionSalary

CoverageBenefitGroup

CoverageEffectiveDate

ContributionEffectiveDate

CoverageAge

NewCoverageAge

ContributionAge

NewContributionAge

TransactionReason

Let me know if that doesn't work as I'd be happy to help.

Rhonda