11.1 About the Database Views

To provide data for your custom reports, you need to use database views. The core database views that ship with the product include both current state and history information for reporting. For most applications, you can use the views that provide both current state and history information. These views are described in the sections that follow.

In addition to the core set of views, there is a separate set of views that includes only the current state information, thereby providing a slight improvement in reporting performance. For example, the idmrpt_approver_v view provides both current state and history information, whereas the idmrpt_approver_cs_v view provides just the current state information. The structure of the two views is identical, so the columns used are exactly the same. Only the view names are different. The name for each current state view includes _cs before the _v suffix.

For most applications, you can use the views that provide both current state and history information. However, if you want to use the views that provide current state information only, here is the complete list of current state views: