Data Views

Top  Previous  Next

Overview

Every SQL table in the InFocus database is also represented by a SQL view. A SQL view is a stored query that appears in other applications as a table. This can simplify user queries since many of the standard joining between tables as already been completed.


 

Key Concepts

InFocus provides two classes of SQL views for end users to use for queries—standard views and extended views.
oStandard view names are the same as the table name, but with a prefix of SV. Standard views contain all the columns of their table counterpart, as well as all code and title fields from related tables. For instance, querying timesheet items (holds timesheet line items), columns such as projected, jtid, etc. would appear. These are key fields relating to the projects and job titles tables. In standard view, code and title fields from the related table would be joined. The standard view also contains projectcode, projectname, projectpath, projectlongname, jtcode, and jtname.
oExtended Views have a name beginning with EV_. Extended views are useful views created by InFocus.
EV_ProjectTransactions - Gathers project related transactions. Field compliment is same as aggregate and non-aggregate in project management report designer.
EV_Marketing - Marketing contact information
EV_Wip - Work-in-progress data.