HOW TO CREATE  an update trigger program for PATIENTA. If the company pays < 40% there may be substantial debt remaining for the Patients. If the amount owing is greater than 10,000 and the percentage paid is less than 40%, use a trigger to store a row in a new table called DCOLLECTION  (difficult collections). The hospital will go through these entries and try to get the insurance company to pay a higher percentage.

Answer rating: 100% (QA)

Create a new table called DCOLLECTION to store the difficult collections ... View the full answer