Dependents - before and after changes on a report

Hi Sue,

I have a similar request from our Benefit Department. We are looking developing a Oracle Trigger to record all the identified emdepden data to a new table. After the data is stored, a crystal report would be developed to read the file.

A short term suggestion is to run a automated query to copy the employee number, dependent number and the birth date to a flat file each night and compare the the two files for a changes.

Paul

Sue,
If you have process flow integrator with JDBC enabled I could show you a solution that runs weekly to find any changes in a table. (Technically, it can be used with any table that does not have logging enabled.)

Hi Shane,

I am told that we have process flow integrator with JDBC enabled. Anything that you can provide would be great.

Thanks,
Sue 

Another option is Smart Notifications, which is perfect for tracking before/after changes in datasets.

My understanding of smart notes is that you can only capture the latest data for the report and not both the before and after data.  Is there a way to capture both before and after data on a smart note?

The way LSN works with infosets makes it a decent tool for tracking and notifying/reporting changes. Here’s a quick example I put together to show how it “noticed” the change in this dependent’s social number: