Open Dental Forum

I was just stating that I know it is bad practice to modify another application's database. That's all.

After further investigation you are absolutely correct. I do need a timestamp column in the claim & payment tables. I know modifying an application's datasource is risky, but I think for prototyping purposes it is necessary. Hopefully, in the near future I will see timestamp columns in those tables....

Good morning Mr. Sparks, I need the modified DateTime stamp for synchronization/automation purposes. I am thinking about running a query every X minutes to retrieve modified claims & payments. I will modified claim and payment records and see what appears in the sercuritylog table. I may be able to ...

Good day all, What are the column(s)/indicators for an updated claim and payment? Example. A new claim is entered this morning. Later in the day a modification is made to that claim. How do I know that claim has been modified? What table(s) and/or column(s) should I query to pick up modified claims?...