Telemarque Custom Data Views

Telemarque supports the addition of custom views that allow the addition of SQL queries as views within the application main screen.

Opening the Flexiview Config

1. Open the Flexiview Config application: Start Menu > Telemarque > Tools > Flexiview Config

2. Select the Telemarque database from the drop down list & click Open.

3. Sign in as SYSDBA with your password.

4. Initially the list will be empty.

The blank flexiview config editor

Adding a Flexiview

This will add a custom data view based on patient records (demographics).

1) Press the + sign on the toolbar (left hand side, just under the Open button)

2) Complete the fields opposite as follows:

• Order: a number, indicating the position of this custom view in the list of custom views in the Telemarque screen. Suggest starting at 100 and working upwards in increments of 10.
• View Name: a unique name describing what this view will show, e.g. "Missing NHS Numbers"
• Page Name: always set to Views
• User Name: leave blank or use your own Telemarque user name if you only want this to appear for yourself.
• Select SQL (required): copy and paste a valid SQL query into this box. Press Test to make sure it's working okay.
• Where SQL: leave blank
• ID Fields: always set to CPI
• Open Code: always set to ROOT001
• Filter Type: always set to 0 (zero)
• Field Aliases: leave blank
• Field Pick Lists: leave blank
• Hidden Fields: leave blank
• Grouped Fields: leave blank

3) Press Save

Repeat each step above with new values for Order, View Name and Select SQL. See the suggested views below for the required SQL.

The first flexiview added

Suggested Views

The following table describes the SQL for flexiviews that will assist with data quality in Telemarque.

Order	View Name	Select SQL
100	Missing NHS Number	SELECT * FROM DEMOGRAPHICS WHERE (NHSNUMBER is NULL) OR (NHSNUMBER = '');
110	Missing Hosp Number	SELECT * FROM DEMOGRAPHICS WHERE (HOSPITALNO is NULL) OR (HOSPITALNO = '');
120	Missing DOB	SELECT * FROM DEMOGRAPHICS WHERE (BIRTHDATE is NULL);
130	Missing Postcode	SELECT * FROM DEMOGRAPHICS WHERE (POSTCODE is NULL) OR (POSTCODE = '');
140	Missing Gender	SELECT * FROM DEMOGRAPHICS WHERE (GENDER is NULL) OR (GENDER = '');

Using Flexiviews

Once you have all the flexiviews you need, start Telemarque (or exit and re-start) and the views will appear on the left hand side of the main application window.

Click on each one to see the contents. Double click a row to open the record in question.