Developer:

Shirley Christenson Consulting

(a Pendragon Solutions Provider)

Customer Quote:

"I am using the ODBC feature to synchronize the Palm forms direction with MS Visual FoxPro tables.  This works great!"

Overview:

The YMCA in this metropolitan area has full facilities, camps and day camps/other facilities.  The central facilities managers are doing periodic inspections of each facility.  The manager at each site will eventually have the software and equipment to do his/her own inspections.

The inspections cover compliance with local, state, and federal regulations, internal organization standards, and national accreditation standards.  The inspection forms are arranged geographically, as the inspector moves through each area of the exterior and interior of the buildings in a facility.  The inspection data is loaded into a relation database.  The inspection is scored based on a point system, and the inspection report is sorted by the assigned priority of each item inspected.

The inspections have more than 25 sections, with an average of 12 items to inspect in each section.  Each item has a cleanliness rating, a condition rating, and comments.  A set of standard comments is stored in a lookup list for each item.  The facilities managers intend to set up a custom inspection template, or form, for each of the 30 facilities because of major differences in the facilities and layout of the buildings.

Before Pendragon Forms:

A combination of paper-based inspections and reports from a contract inspection service.

Benefits:

Consistency of inspections, potential elimination of contract inspection costs, and the addition of management information in a relational database.