SQL Data Views

Every SQL table in the InFocus database is also represented by a SQL view. A SQL view is a stored query that appears to other applications as a table. A SQL view simplifies user queries by joining tables for you. InFocus provides two classes of SQL views for end-users to use for queries: Standard Views (SV) and Extended Views (EV)

Standard Views (SV)

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 and, in addition, all code and title fields from related tables. For instance, if you query timesheet items (which holds timesheet line items) you would see columns such as projectid, jtid, etc. These are keys fields relating the projects and job titles tables. In Standard Views, you would see the joined in code and title fields from the related table. The Standard View would also contain projectcode, projectname, projectpath,projectlongname, jtcode and jtname.

Extended Views (EV)

Extended Views are the other view class. These have a name beginning with  "EV_". Extended Views are useful views that were created by InFocus. EV examples include, but are not limited to

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.