VERIFIED SOLUTION i

Enquiry and Central_Enquiry tables in Confirm

Products affected: Confirm®
Product feature: Customer Services / Enquiries
 
In the Confirm® database there is an Enquiry table and a Central_Enquiry table.

In an Oracle database the Central_Enquiry table is held in the SBS schema.

In a SQL Server database the Central_Enquiry table is held in the DBO schema.

Initially an Enquiry is stored in the Central_Enquiry table.

A record is added to the Enquiry table when it has a Feature associated with it. 

If no Feature is associated with a particular Enquiry, an Enquiry record will only exist in the Central_Enquiry table and not the Enquiry table.
UPDATED:  May 7, 2018