Difference between revisions of "Telemarque Custom Data Views"

From EHS Help
Jump to: navigation, search
(1st draft)
 
(→‎Suggested Views)
 
(12 intermediate revisions by the same user not shown)
Line 4: Line 4:
  
 
1. Open the Flexiview Config application:  Start Menu > Telemarque > Tools > Flexiview Config
 
1. Open the Flexiview Config application:  Start Menu > Telemarque > Tools > Flexiview Config
 +
  
 
[[File:Startmenu.png]]
 
[[File:Startmenu.png]]
 +
  
 
2. Select the Telemarque database from the drop down list & click ''Open''.
 
2. Select the Telemarque database from the drop down list & click ''Open''.
 +
 
3. Sign in as SYSDBA with your password.
 
3. Sign in as SYSDBA with your password.
 +
 +
4. Initially the list will be empty.
 +
  
 
[[File:Blank flexiviews.png]]
 
[[File:Blank flexiviews.png]]
 +
 +
''The blank flexiview config editor''
  
  
Line 27: Line 35:
 
* Select SQL (required): copy and paste a valid SQL query into this box.  Press ''Test'' to make sure it's working okay.
 
* 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
 
* Where SQL: leave blank
−
* ID Fields: set to '''CPI'''
+
* ID Fields: always set to '''CPI'''
−
* Open Code: set to '''ROOT001'''
+
* Open Code: always set to '''ROOT001'''
−
* Filter Type: set to '''0''' (zero)
+
* Filter Type: always set to '''0''' (zero)
 
* Field Aliases: leave blank
 
* Field Aliases: leave blank
 
* Field Pick Lists: leave blank
 
* Field Pick Lists: leave blank
Line 36: Line 44:
  
 
3) Press '''Save'''
 
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.
 +
 +
 +
[[File:Adding first flexiview.png]]
 +
 +
''The first flexiview added''
 +
 +
== Suggested Views ==
 +
 +
The following table describes the SQL for flexiviews that will assist with data quality in Telemarque.
 +
 +
 +
{| class="wikitable" style="width: 80%"; align: center;"
 +
! scope="col" | Order
 +
! scope="col" | View Name
 +
! scope="col" | Select SQL
 +
|-
 +
| 100 || align="center"|  Missing NHS Number || align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (NHSNUMBER is NULL) OR (NHSNUMBER = ''); </nowiki>
 +
|-
 +
| 110 || align="center"|  Missing Hosp Number || align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (HOSPITALNO is NULL) OR (HOSPITALNO = ''); </nowiki>
 +
|-
 +
| 120 || align="center"|  Missing DOB|| align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (BIRTHDATE is NULL); </nowiki>
 +
|-
 +
| 130 || align="center"|  Missing Postcode || align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (POSTCODE is NULL) OR (POSTCODE = ''); </nowiki>
 +
|-
 +
| 140 || align="center"|  Missing Gender || align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (GENDER is NULL) OR (GENDER = ''); </nowiki>
 +
|}
 +
 +
== 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.
 +
 +
[[File:Flexiviews in TM.png]]

Latest revision as of 12:16, 13 March 2018

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


Startmenu.png


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.


Blank flexiviews.png

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.


Adding first flexiview.png

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.

Flexiviews in TM.png

Retrieved from ‘https://evolutionhealthcaresystems.co.uk/help/index.php?title=Telemarque_Custom_Data_Views&oldid=5921’