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. |
| o | Standard 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. |
| o | Extended 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. |
|