 |
 |
|
|
The database views bringing together various fields from across the IRIS database into views that can then be reported on; there are three levels of views that build upon each other to provide the information necessary to create useful reports.
A database view is a window into the database; through which you can read information from the database. Data cannot changed or deleted through use of the views when developing reports in Excel or any other reporting tool.
There are three levels of views provided, which can be distinguished by the first three letters in their names:
Views starting 'ibv' (IRIS Business Views) are those with business logic built in and are therefore geared to specific business requirements.
Not all the business views are suitable to be used directly by unexperienced users; there are views concerned with categorization of staff members, jobs and clients. These are of little use by themselves but can be joined to other business views to allow the result set to be broken out by the categories. Thus each specific business view can acquire the same categorization by simply joining to one of these.
Some views can contain large amounts of data which will swamp Microsoft Excel and increase the time to retrieve the data. An advanced user accessing these views could programmatically supply appropriate criteria to restrict the result set but since there is no practical way of modifying a data source a set of derived views has been provided for direct connection to tools like Microsoft Excel, these views are identified by the following standard suffixes:
CCY = current calendar year
CC2Y = current and previous calendar year
CLY = current ledger year
CL2Y = current and previous ledger year
LCP = latest closed period
LCPC = latest closed period plus the same period from the previous year
LCPY = latest closed period plus all periods up to that one in the same year
LCPYC = as LCPY with comparatives from the previous year
Click here to view a list of the Business Level Views.
Views starting 'icv' constitute a layer above the idv views. They are
available for advanced users; for example those that have the capabilities
to write customised SQL scripts. These second level views are primarily
concerned with doing common joins between data fields and aggregating
base views.
Click here to view a list of the Second Level Views.
Views starting 'idv' are basic shells above the existing database. They
are, again, available for advanced users; for example those that have
the capabilities to write customised SQL scripts. These base level views
provide the initial building blocks required to aggregate data fields
together that enable the delivery of the business level views.
Click here to view a list of the Base Level Views.