Difference between revisions of "Telemarque Custom Data Views"
m (→Suggested Views) |
(→Suggested Views) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 45: | Line 45: | ||
3) Press '''Save''' | 3) Press '''Save''' | ||
| − | Repeat each step above with new values for '''Order''', '''View Name''' and '''Select SQL'''. | + | Repeat each step above with new values for '''Order''', '''View Name''' and '''Select SQL'''. See the suggested views below for the required SQL. |
| Line 51: | Line 51: | ||
''The first flexiview added'' | ''The first flexiview added'' | ||
| − | |||
== Suggested Views == | == Suggested Views == | ||
| + | |||
| + | The following table describes the SQL for flexiviews that will assist with data quality in Telemarque. | ||
| Line 61: | Line 62: | ||
! scope="col" | Select SQL | ! scope="col" | Select SQL | ||
|- | |- | ||
| − | | 100 || align="center"| Missing NHS Number || align="left"| | + | | 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"| | + | | 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"| | + | | 120 || align="center"| Missing DOB|| align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (BIRTHDATE is NULL); </nowiki> |
|- | |- | ||
| − | | 130 || align="center"| Missing Postcode || align="left"| | + | | 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"| | + | | 140 || align="center"| Missing Gender || align="left"| <nowiki>SELECT * FROM DEMOGRAPHICS WHERE (GENDER is NULL) OR (GENDER = ''); </nowiki> |
|} | |} | ||
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
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.
