Database Schema and Views Reference Guide › Database Views › Review Queue Views Definitions › Naming Convention

Naming Convention

The naming convention is the same has the main product view and start WGN_V_RQ_. The views fall into three families of 3 views each, plus one other additional view. To summarise the three families: 'Event' containing events in the review queue; 'Entry' containing review queue entries; 'Event Entry' containing both events and the corresponding review queue entries. Within each family there are separate views for 'All', 'Closed', 'Open'; with an obvious naming convention indicating which; that return all, closed or open event records respectively. The additional view to these is WGN_V_RQ_CRITERIA_CL_1 and defines what a closed event is. Open events are then defined as those that are not closed.

The view names below are the same for both SQL Server and Oracle in r12.0. For SQL Server customers that have installed the review queue separately on an earlier version the names of these views differ. Any such customer upgrading to r12.0 will find that both sets of views exist, but the old named views now just point to the new views, and any future development of reports should use the new views referred to in this document. See the table below for a summary of the name changes.