CCN Custom Reporting Service (CRS) User Manual Version 8.2
Contents
1. 2 1 Dimensions as Filters Query filters are fields that the user selects in order refine data into what is needed In the example below we would like to see all records that have a Scheduled PCI within a specific removal date range In order to do this we would need to find all records where Scheduled PCI was selected We do this by dragging the Scheduled PCI dimension and the Removal Date Range filter into the Query Filters section of the Query Panel To only retrieve Scheduled PCI cases we need to give the dimension a value of Y so the Web Intelligence knows we are only looking for Scheduled PCI cases as shown below Upon running the query you will be prompted to enter the date range values Y Removal Date Range L Scheduled PC In list T E See Advanced Training 2 3 Query Filter Prompts section for more details 2 2 Complex Queries In the example below we would like to see all records that have a Scheduled PCI or a Staged PCI completed within a specific Removal Date Range In order to do this we would need to find all records where the Scheduled PCI or Staged PCI fields were selected We do this by selecting adding the Staged PCI dimension to our existing Query Filters It should look like this T Removal Date Range nd Scheduled PCI in list wily f Staged PCI in list Notice that the 3 fields are in the same AND bracket This is known as a condition The query in its current form translates2. g ype h mr m Et 3 lt CCN_CRS_Universe unx Patient Profile Facility YF Query Filters Waitlist Category Urgency Information TAVI Referral Form s Wait Times Data Scheduling Details Offlisting Details m Adverse Events E Notes 333 i H Dofrest p Site Specific Elements m Refresh Wait Times Information m Procedure Filters p Other Filters Old Elements To filter the query drag predefined filters here or drag objects here then use the Filter Editor to define custom filters query 1 d d eE Last refresh date This document has never been refreshed Cardiac Care Network of Ontario 2015 CCN CRS User Manual 10 CARDIAC CARE NETWORK 3 5 Using the Query Panel Next we will use the Query Panel to create a basic query 1 Weare going to want to find Patient Full Name and the Age for all patients To do this you must first open the Patient Profile folder and the Patient Demographics sub folder Now we can drag Patient Full Name and Age in to the Result Objects container as shown below 2 For the next part we only want to grab patients from December 2014 To do this we need to add the Removal Date Range filter that is located in the folder called Other Filters Find this filter and drag it into the Query Filters container This filter will allows us to choose a date range for our dataset December 1 2014 to Decem
3. Cardiac Care Network of Ontario 2015 CCN CRS User Manual 17 CARDIAC CARE NETWORK 6 Open an Existing Query To open a pre existing query you must be at the landing page of the Web Intelligence tool From here you want to select the Open Existing Document button and that will open a new window Expand the folders starting with Public Folder then 01 CCN EXTERNAL and finally Hospital Name i e 693 Kingston General Hospital folder You should be able to see your folder name if you have created one if not you should see all the queries your hospital has created yy He e1 cuments Web Intelligence 5 ELILE Web inteligence gt D AJH El fr Home G My Favorites E Webintelligence E3 Inbox ij Public Folders fj 01 CCN EXTERNAL ra Reports TestQuery TestUserQuery reynald test sql new security Stanko_new_security _ stanko_sec_security Cardiac Care Network of Ontario 2015 121 KB 121 KB 117 KB 123 KB 117 KB 121 KB 1171145 10 02 6 1 7115 10 02 amp 117115 10 02 6 1 7115 10 02 amp 117115 10 02 6 1 7115 10 02 amp CCN CRS User Manual 18 CARDIAC CARE NETWORK Advanced Training 1 Count Function The remainder of the document will be about the more advanced functions that Web Intelligence has to offer First let s talk about counting the number of distinct Waitlist Entry ID results there are
4. j Sd C_10a_Cardiaccess_Patient_Profile_v3 0 C_10a_Cardiaccess_Patient_Profile_v3 0 E _52a_Wait_List_ Report_by Accepting _HCP_v12_0 E_52b_Wait_List_Report_by Procedure_v12_0 G_07_Check_Missing Data_vi3 0 No recenthy viewed documents Crystal Reports Crystal Crystal Reports Crystal Re Cardiac Care Network of Ontario 2015 CCN Data Dictionary Release 9 0 V1 0 Frequently Asked Questions CCN CRS User Manual 8 CARDIAC CARE NETWORK 3 3 Starting a New Project The following images show how to start a new project inside the Web Intelligence software Step 1 From the Web Intelligence startup page right at the top there is the icon for new document CARDIAC CARE NETWORK Home Documents Web Inteligence 5 amp Web Intelligence b Gi bat Step 2 In the Create a new Web Intelligence Document dialogue window under Select a data source select Universe and then click OK Create a new Web Intelligence Document ox Select a data source M No data source Create an empty document 4 Bex Select a Bex query as a data source E Analysis View Pick an Analysis View as a data source T cancel Step 3 In the Universe dialogue window under Available Universes select CCN_CRS_Universe unx and then click Select Universe x Select a universe for the query Available Universes Refresh universe list A Daevicinn CCN_CRS_Universe unx 37 WTISC
5. this will show us the amount of procedures that match your defined filters by following the next steps 1 You must first select the column you want counted For this example it s the Encrypted Waitlist Entry ID 2 Select Analysis tab and then Functions tab on the left side of the screen 3 Click the Count button 4 The result of the Count feature is always displayed at the bottom of the column on the last page of the report To advance to the last page you can click the icon at the bottom of the application CARDIAC CARE NETWORK Welcome 693 user Applications Help menu Log off P f Home Documents New Document File Properties Data Access Re G Bl wale _ Fitters Data Tracking py Display Conditional x Interact 4 o5 x we F Fiter fh Ranking H input Controls Break Sort Sum a New Document 7 Date FR ep ort 1 Waitlist Entry ID ww Wait 2 Ba Variables Encrypted WLEID Acceptance Date Wait 2 Age 10 18 2013 1 68 1 11 12 2013 20 81 11 12 2013 13 70 11 20 2013 0 50 11 20 2013 o 85 12 10 2013 1 80 12 12 2013 0 77 12 18 2013 0 82 12 31 2013 0 58 01 03 2014 o 71 01 10 2014 0 74 01 14 2014 o 54 3 01 14 2014 o 63 01 14 2014 0 51 01 21 2014 1a 76 01 22 2014 2 63 01 22 2014 0 76 01 29 2014 o 65 01 31 2014 0 30 er Arranged by Alphabetic order 7 Report1 dbo Report 1 Tra
6. Available Objects tab and are ready to be used All you have to do is drag the new fields i e Health Card Number into the table on any side of an existing field until a light blue rectangular icon appears Data Objects Objects Type here to filter tree ap New Document EDES Report 1 I Patient Ful Name i Variables Patient Full Name Abbot Jack 4 Heath Card Number abi gail AVVAFA ZFLVYT 77 AVVAFA ZFLVYT 83 Barbra KGH 62 BATISTA JOSE CABRAL 59 l I BATISTA JOSE CABRAL 73 Bat Jose 2 5 79 BDRZ YPVAFLT 77 Bean Jelly 46 I Bean Jelly 59 i bernabe carol 76 BFAFIIO KOAIPAC IFLYV 54 BFDY XVNPW 67 Birney Birdie 59 BLACK JACK 43 Bow Wow 63 Brown Del 60 Brown Del 82 Brown Emma 61 Brown Emma 74 BROWN STEPH V 55 Cardiac Care Network of Ontario 2015 CCN CRS User Manual 15 CARDIAC CARE NETWORK 4 Saving a Query Once you are happy with your results it is highly recommended that you Save your query as it can be reused by yourself or other colleagues This also allows us at CCN to look at your queries and if something is going wrong we can see exactly where the problem is To do so click the Save icon and try to give your document an informative name 1MPORTANT When saving your queries always make sure you are saving them on the server wtisccnrs1 This will always be the defaul
7. by Case by Date_v11 0 Crystal Reports A43a CRO v70 Crystal Reports A 7S Utilization_by_Date_v30_0 Crystal Reports B A E D O G u m eC n t S A 75e Utilization_by_Procedure_by_Patient_by_Date_ v17 Crystal Reports C_10a_Cardiaccess_Patient_Profile_v3 0 Crystal Reports C_10a_Cardiaccess_Patient_Profile_v3 0 52a_Wait_List_Report_by_Accepting_HCP_v12_0 Crystal Reports CCN Data Dictionary Release 9 0 V1 0 52b_Wait_List_Report_by Procedure_vi2_0 Crystal Reports ae TAVI Registry November 2013 v2 G_07_Check_Msssing Data_vi3 0 Crystal Reports Frequently Asked Questions No recently viewed documents ARAA Cardiac Care Network of Ontario 2015 CCN CRS User Manual 6 2 2 Documents Tab CARDIAC CARE NETWORK The Documents tab consists of your own custom hospital name folder where you and your coworkers will be saving your own queries and our pre built Custom Operational and Statistical reports If you have used our Infoview reporting system before you should be very familiar with the Custom Operational and Statistical folders CARDIAC CARE NETWORK a view gt My Documents Folders Pubic Folders IES 01 CON EXTERNAL 693 Kingston General Hospital Reports E Custom P Operational IE Statistical Search Cardiac Care Network of Ontario 2015 gt 4 80 1 1 eS amp 1 e e Deta Is Title A_10_Discharge_Transfer_Sta
8. specified Waitlist Entry ID Equal to 100001 retrieves data with value the Waitlist Entry ID of 100001 Not Equal To Not equal to the specified Waitlist Entry ID Not Equal to 100001 retrieves data value other than Waitlist Entry ID of 100001 Greater than Greater than the specified Removal Date Greater than 2013 01 01 retrieves value data for all Removal Date greater than 2013 01 01 Greater than or Equal Greater than or equal to Removal Date Greater than or Equal to 2013 01 01 to the specified value retrieves data for all Removal Date greater than and including 2013 01 01 Less than Less than the specified Removal Date Less than 2013 01 01 retrieves data value for all Removal Date less than 2013 01 01 Less than or Equal to Less than or equal tothe Removal Date Less than or equal to 2013 01 01 specified value retrieves data for all Removal Date less than and including 2013 01 01 Between Between two values Removal Date Between 2013 01 01 and 2013 12 31 including these values retrieves data for all Removal Date between and including the specified dates Not Between Not Between two values Removal Date Not between 2013 01 01 and 2013 not including these values 12 31 retrieves data for all Removal Date not between and not including the specified dates For which there is no Removal Date Is empty value retrives data with no value entered in the Removal Date entered database Is not null For which there is a value Removal
9. to If Scheduled PCI and Staged PCI are both checked off within a specific Removal Date Range return selected records Since this is an impossible scenario as only one of those can be selected at a time this query will return no results To get what we really want we have to edit this a bit further see next page Cardiac Care Network of Ontario 2015 CCN CRS User Manual 21 CARDIAC CARE NETWORK For our query to return all Scheduled PCls and Staged PCls we need to do the following two steps 1 Tocreate some flexibility with your query you want to drag one of the fields that contradict each other onto the other to create a new bracket as shown below m T Removal Date Range And Scheduled PCI in list Staged PCI in list To get the following TY Removal Date Range cr i o tl Staged PCI in list vily Scheduled PCI In list wily E 2 If it did not work well start over with the Query Filters until you get the hang of it Next we want to change the AND on the new bracket to an OR condition To do this click on the AND Y Removal Date Range l Staged PCI in ist gH Th l Scheduled PCI In ist x Now the query translates to If Scheduled PCI or Staged PCI are selected within the Removal Date Range return those records with the selected columns in the Result Object section Cardiac Care Network of Ontario 2015 CCN CRS User Manual 22 CARDIAC CARE N
10. wtisccnrs1 ccn on ca BOE BI Each user will have a unique username assigned by CCN To log in to the CCN CRS 1 Enter your username and password into the form 2 Press Enter or click the Log On button Custom Reporting Service CCN CRS Enter your user information and click Log On If you are unsure of your account information contact your system administrator system WTISCCNRS1 6400 logn CARDIAC CARE NETWORK Cardiac Care Network of Ontario 2015 CCN CRS User Manual 5 CARDIAC CARE NETWORK 2 Navigating CCN CRS 2 1 Home Tab Upon logging in you will be presented with the Home page below The Home page is divided into two different tabs Home and Documents The Home tab consists of the following sections 1 Left Navigation Pane Lists operational custom and statistical reports created by CCN 2 My Applications The Web Intelligence is located here providing you access to the Universe and allowing you to create custom queries and reports 3 Web Page Module Access to Business Object Enterprise BOE documents CCN Data Dictionary TAVI Registry and Frequently Asked Questions CARDIAC CARE NETWORK Welcome 693 user Applications Helpmenuw Log off C3 Reports E 3 ei A Operational 1 of 2 gt W Title Type yy A 10_Discharge_Transfer_Status_vi0 0 Crystal Reports A_19_Utilization_by_Physician_vi8 0 Crystal Reports A_33_Stent Utilization
11. CARDIAC CARE NETWORK CARDIAC CARE NETWORK a CCN CRS User Manual it February 2015 CCN Custom Reporting Service CRS User Manual Version 8 2 February 2015 CARDIAC CARE NETWORK INTRODUCTION TO CCN gapicessecasecexseccasbecsscesaseucrcasnassieasstoeveneriessesesevsaenabasciuscctusuetstnshedextassansseessereraeseenes 3 INTRODUCTION TO CCN CUSTOM REPORTING SERVICE CCN CRS ssseseseseoeosososososososososososososososososseos 4 What is CCN CRS and why should use it ou ceeecccccsessecccceeeseccccseesecceseeaseceesseeseeeeesseseceessaeueceesseeaeceesseanseeessagaeeessauaeceessaaeeeeees 4 BASIC ERAININ G carrii ren E E E E S 5 L TOENE Mana E E A E 5 Z NAVI AUN CCNA OR 9 sa coveuaceteeauncsaraacweaievccauaanocstatelesaucacswaneeas uaeueaasenasuatcwsaavedeuanueateuadwesauuedssanecodauacuvouneadebaueesasheweedneraesuacewentons 6 2 1 Homne TaD anecencestazeca ines A E as aiaeceessoeiasscatcoedeane ddan E E 6 2 2 DOCE T D ea E E E A EE E E E et eee 7 3 My First Web Intelligence Project ssssesesesscsesesecececsesesecececsesesecececscsesecececscsesesececscsesesesecscsesesesececsesesesecececsesesececseseseses 8 3 1 CC NEOR S LEE raien E A TEE E E EEE E EATE T EA EE TEE EE 8 3 2 Starting Up Web Intelligence cccccccesseccccssssecceceessecccsaesseceesaeeseceesaesseceeeaeeeeeesseaseeeesaeeueceesaenueceesaeasecessugaseeessaeaseessages 8 3 3 starne NEW POECI oipe ran EARE AEE E E EE EREE EE EEE 9 3 4 Understanding the Q
12. CNDEV CCN ON CA_6400 4 I P Help on selected universe Cose Cardiac Care Network of Ontario 2015 CCN CRS User Manual 9 CARDIAC CARE NETWORK 3 4 Understanding the Query Panel This is the panel where you can run a query of the CCN Cardiac Registry Choose any combination of data elements from the registry and apply any number of filters to define the query 1 Universe Outline Contains a search box and sets of folders with all available dimensions filters and measures We have kept the folder structure and naming convention the same as the CCN Cardiac Registry 2 Result Objects The selected objects that will be displayed in the generated report these will be the columns for your data i e Patient Full Name Health Card Number Address 3 Query Filters This serves as your filter s for your data You may drag predefined filters here or you may use dimensions to filter as well Think of this as your funnel to cut out data you do not require i e Data Range Age Procedure 4 Data Preview You may preview your data before running the query here to see how it will look before running a full query 200 rows id Query Panel ex i aca Query Ea EP F a Run Query amp Close zi Universe outline i Result Objects m CCN_CRS_Universe To include data in the report select objects in the Data tab and drag them here Click Run Query to return the data to the report
13. Date Is not empty value retrives data with entered in the database Removal Date entered Matches pattern Includes a specific string First Name Matches pattern And retrieves data value that is like a value for any First Name that begins with And i e Andrew Different from pattern Excludes a specific string First Name Different from pattern And retrieves that is like a value data for any First Name that does not begin with And Cardiac Care Network of Ontario 2015 CCN CRS User Manual 24
14. ETWORK 2 3 Query Filter Prompts When filtering with Dimensions they need to be told what values you require i e Y N NULL 2 otherwise they will not return correct data If you do not know what some of the options for the values are you can click the Value s from list button from the dropdown F Removal Date Range i l Scheduled PCI In list RR Pam e Staged PCI in list wily Value s from list Prompt an This will trigger a new window that will show you all the possible scenarios for that Dimension Select the one s you would like in some scenarios you may select more than one then click the little arrow and click OK List of Values ox ga ed Value s Scheduled PCI N November 25 2014 2 04 46 PM GMT 05 00 You may also change how the prompt values are being used by each Dimension For our example we have it as in list witch works just like Equal to but you may need to change this in the future depending on your scenario Check the next pages for detailed a explanation of all the options in the dropdown T Removal Date Range Vt l Scheduled PC jin list In list Staged PCI in Not in list z Egual to Not Equal to Greater than Greater than or Equal to Less than Less than or Egual to 7 Cardiac Care Network of Ontario 2015 CCN CRS User Manual 23 CARDIAC CARE NETWORK 2 4 Query Filter Operators Equal To Equal to the
15. IAC CARE NETWORK 5 Exporting a Report Now you are ready to Export your data to Excel and continue manipulating the data there To do this first you need to make sure you are in the Data Access tab as shown below Then select the Tools subtab and click on Export Data This will open a new window where you can name your document and select where you would like to export it to Saving your document this way does not save the query only its results This means that you can only rerun the document if you save it as described in the section Saving a Query Once ready click Save Home Documents New Document T File Properties Analysis Ae g Igi _ Data Providers J Tools _ _ Data Objects i i m5 wy e Y A e Y 3 k n i Y f K E 2 E ES E Change Source lt gt Export Data s New Variable PS Merge a p New Document l Age Ag Report 1 Health Card Number Patient Full Name lp Variables Patient Full Name Age Health Card Number Save Document Ei Save in E Desktop Y RA T m a Libraries Text qualifier T Hi P Computer Column delimiter gt T My Desktop th Network Charset a UTF 8 r My Documents _ Enter a new charset EL My Computer _ Setas default values Files of Type CSV 7 Brown Del 82 Brown Emma 61 Brown Emma 74 BROWN STEPH V 55 9150758630 Arranged by Alphabetic order E Report 1 y Report 1
16. ber 31 2014 3 Once you are satisfied with your query you may run it by clicking Run Query at the top right of the Query Panel Dimension Data elements i e Waitlist Entry ID in the CCN Registry These fields can be used in the Results Objects and Query Filter window WE Measure Calculations in the CCN Registry These fields can be used in the Results Objects and Query Filter window i e Wait 1 Wait 2 yY Filter Defined groups of dimensions that enable one to quickly build a specific query These filters can only be used in the Query Filter window G Query Panel ex P Add ouery AREP F a ao be 4 Universe outline g Result Objects x Remove Clear selected item from Results Objects CCN_CRS Universe 7 fy CCN_CRS_Uni Patient FullName Age H Ot amp CCN_CRS_Universe unx Patient Profile Patient LHIN Number Patient LHIN Name gj Patient Demographics Wait Time Patient ID Health Card Number Version Authority Issuing Sex Date of Birth Address p Phone pp Facility p Waitlist Category Remove All Clear all items from Results Objects Remove Filter Clear selected filter F Quer Filters ng Remove All Filters Clear all filters from the Query Filters window iE Urgency Information _ Removal Date Range i TAVI E Referral Form p Wait Times Data Scheduling Deta
17. ck Changes Off 4 lt 4 Page1ofi gt O E 100 A SE A 1 minute ago Cardiac Care Network of Ontario 2015 CCN CRS User Manual 19 CARDIAC CARE NETWORK 2 Complex Query Here you will learn how to build complex queries to retrieve specific data from your hospital The following examples can be followed through in your query panel J Query Panel e OE z Universe outline eal Result Objects A CCN_CRS_Universe y Xe Type here to filt a O Ak CCN_CRS_Universe unx Patient Profile Patient LHIN Number Patient LHIN Name H Patient Demographics Wait Time Patient ID Health Card Number Version Authority Issuing Patient Full Name Sex Date of Birth Age E Address E Phone ma Facility ma Waitlist Category ee E Urgency Information insite nt iin i TAVI E Referral Form E Wait Times Data lm Scheduling Details ma Offlisting Details ma Adverse Events ma Notes ma Site Specific Elements ma Wait Times Information ma Procedure Filters Other Fitters YF Facility Number F Ontario Funded Patients f Patient Ful Name Age F Quer Filters FA Data Preview COE ee E Y E Old Elements Q Type a text to filter the values i cuen ATE Last refresh date This document has never been refreshed _ Cardiac Care Network of Ontario 2015 CCN CRS User Manual 20 CARDIAC CARE NETWORK
18. ils Offlisting Details E Adverse Events mu Notes sA E Data Preview Refresh E Site Specific Elements Wait Times Information eee eee eee ee ee eee eee eee ee ee ee ee ee E Procedure Filters G Other Filters F Facility Number Y Ontario Funded Patients Y Removal Date Range pj Old Elements i Query 1 4E Last refresh date This document has never been refreshed Cardiac Care Network of Ontario 2015 CCN CRS User Manual 11 CARDIAC CARE NETWORK 3 6 Filter Prompts After running your query depending on your filters you may be prompted to enter values for your filters Select your prompts i e Enter Removal Start Date Enter Removal End Date and then select a value for each date by clicking the Calendar Icon and then clicking OK Keep in mind the following icon definitions v Requirement has been met Required field If not all prompts have been filled with values the OK button will be grayed out romi x Prompts Summary aj 2 Enter Removal End Date Selected Value s 2 Enter Removal End Date November 2014 Mon Tue Wed Thu Required prompts OK Cancel Cardiac Care Network of Ontario 2015 CCN CRS User Manual 12 CARDIAC CARE NETWORK 3 7 Report Panel amp Editing a Report After filling in the prompts you should be redirected to the Report Panel as shown below The Report Panel is where you view your results make change
19. ry of the continuum of cardiac services in Ontario CCN s priority is to ensure the highest quality of cardiovascular care based on evidence standards and guidelines and to actively monitor access volumes and outcomes of advanced cardiac procedures in Ontario In addition CCN works collaboratively with provincial and national organizations to share ideas and resources and co develop strategies that enhance and support the continuum of cardiovascular care including prevention rehabilitation and end of life care Working with key stakeholders CCN helps to plan coordinate implement and evaluate cardiovascular care and is responsible for the Ontario CCN Cardiac Registry The information collected in the CCN Cardiac Registry includes wait time information as well as specific clinical parameters required to evaluate key components of care and determine risk adjusted outcomes Through scientific evidence expert panels and working groups CCN uses evidence and consensus driven methods to identify best practice and strategies to effectively deliver cardiovascular services across the continuum of care Cardiac Care Network of Ontario 2015 CCN CRS User Manual 3 CARDIAC CARE NETWORK Introduction to CCN Custom Reporting Service CCN CRS In 2014 CCN implemented the CCN Custom Reporting Service CCN CRS that will facilitate end users access to their own hospital s registry data With CCN CRS users can run their existing Infoview reports
20. s Crystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports Last Run Welcome 693 user Apolications 4 1 ei gt Instances CCN CRS User Manual 7 CARDIAC CARE NETWORK 3 My First Web Intelligence Project In this section we will be creating a simple query step by step The manual will cover the following launching Web Intelligence creating a new query saving the query and exporting the results 3 1 CCN CRS Legend I Web Intelligence Application m F h E amp F ai 3 2 Refresh Button Search Button New Document Open Existing Document Save Document Print Document Search Document Edit Query New Folder Starting Up Web Intelligence To start up the Web Intelligence you must first be on the Home page as shown below and click the Web Intelligence icon located in the My Applications section CARDIAC CARE NETWORK Welcome 693 user Applications Help menu off ES Reports Operational 1 of 2 gt W Title Type A_10_Discharge_Transfer_Status_v10 0 Crystal Reports gt _19_Utilization_by_Physician_v18 0 Crystal Report A_33_Stent Utilization by Case by Date_vi1 0 Crystal Reports gt A 43a_CERO v70 Crystal Report A 7S Utilization_by_Date_v30_0 Crystal Reports B QO E D OC u m e n tS A_75e_Utilization_by_Procedure_by Patient_by Date_vi7 Crystal Report gt
21. s save the query export data etc To make changes to your report all you have to do is click the Edit button on your tab as shown below This will bring you back to the Query Panel where you can make any required changes Home Documents New Document p a B File Properties Data Access Analysis E O S ale Data Providers Taai _ Data Coe 9 P T X Purge Gr n New Variable f Merge p New Document i sval Full Name Report 1 ort 1 li Variables Abbot Jack 79 abi gail 63 VVAFA ZFLVYT 77 AVVAFA ZFLVYT 83 Barbra KGH 62 BATISTA JOSE CABRAL 59 BATISTA JOSE CABRAL 73 Bat Jose 2 5 79 BDRZ YPVAFLT 77 Bean Jelly 46 Bean Jelly 59 bernabe carol 76 BFAFIIO KOAIPAC IFLYV 54 BFDY XVNPW 67 Birney Birdie 59 BLACK JACK 43 Bow Wow 63 Brown Del 60 Brown Del 82 Brown Emma 61 Brown Emma 74 BROWN STEPH V 55 Arranged by Alphabetic order E Reports Report 1 Cardiac Care Network of Ontario 2015 CCN CRS User Manual 13 CARDIAC CARE NETWORK Upon clicking Edit you will be returned to the Query Panel where we will be adding Health Card Number to be part of the report as shown below Health Card Number can be found under the Patient Demographics subfolder of the Patient Profile folder Drag Health Card Number to the result objects tab for it to become part of your report Now you are ready to rerun the report by clicking Run Quer
22. t location when saving a Query and also you will not be able to save anywhere else except your own Hospital Name i e 693 Kingston General Hospital subfolder of 01 CCN EXTERNAL subfolder of Public Folder It is advised that you create a subfolder in your hospital folder with your own name for a cleaner structure To do this click the new folder button E at the middle top of the new screen Home Documents New Document Arranged by Alphabetic order E Reporti 2 Report 1 Cardiac Care Network of Ontario 2015 File Properties Data Access Analysis Data Providers Tools Data Objects n G Edt X Purge s New Variable 0 Merge fa p New Document ja Report 1 1 Health Card Number Patient Full Name lp Variables Patient Full Name Age Health Card Number Abbot Jack 79 9057596158 Save Document ox B Folder E Categories x Pal D Search title v az TEERAA G Home is ue We P za My Favorites test 124 KB p Webintelligence Tear 121 KB 53 Inbox jpn Public Folders FestUserQuery 121 KB ij 01 CCN EXTERNAL reynald test sql 117 KB E 693 Kingston General Hospital new security 123 KB ge Reports stanko_new_security 117 KB stanko_sec_security 121 KB wtisccnrs1 4 P Advanced gt Brown Emma 74 BROWN STEPH V in in alls n So ma CO aS So CCN CRS User Manual 16 CARD
23. tus_v10 0 A_19 _Utilization_by_Physician_vi8 0 A_33_Stent Utilization by Case by Date_vil A 43a CERO v7 0 A_75 _Utilization_by_Date_v30_0 A_75e_Utilization_by_Procedure_by_Patient_by_Date_vi7 C_i0a_Cardiaccess_Patient_Profile_v3 0 _S2a_Wait_List_Report_by_Accepting_MCP_v12_ 52b_Wait_List_Report_by Procedure vi2_0 G 07_Check_Missing Deta_vi3 0 G_37_STEMI Activity Reconciliation v1 G_47 TAVI Missing Data Report v2 G_70_STEM Activity Missing Data vi 126 K_35b_Length_of_Wait_by_PtLocation_st_Time_of_Referral_vi5 0 Actual_vs_RMWT_y7 0 K_43b_Cero_Cath_Removals_Completed_v5 0 K_634_OP_Length_of_Wait_by Referring Physician_v M_71a_Cancellation_Report_for_Patients_Waiting_v6 0 0 M_71b_Cancellation Report by Cancellation Reason_v6 0 0 _27a_ValveProcedure_v3 0 O_80_PatientsWaiting_with_PreviousCABG v5 0 81_Deaths on Waitlist v 0 _82_Removal_Reason_v9 0 0_83A_Refer On Sent v2 0 A _83B_Refer On Received _v2 0 tents per Physioan_v2 X_67a_Site Specific Rem Report_v6 0 Z_Ola_Cutover Reconciliation_v4 Type crystal Reports Crystal Reports rystal Reports Crystal Reports Type Crystal Reports A_33_Stent Utilization by Case by Date_v11 0 Crystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports rystal Reports Crystal Reports Crystal Reports Crystal Reports Crystal Reports rystal Reports Crystal Reports Crystal Report
24. uery Panel sosiisniisniienosnseris einai aeai EEDS EEN EDE a 10 3 5 Uaine Tne GUE ANE liora E E E E E NE 11 3 6 PEE PEO S i E E EE err E EE E ere EE A EE ee E E ee eee 12 3 7 Report Panel amp Editing a REDOT sccscassccsetsascctensactomanantesegaescacsennneaycennadeenenatnmneswaaadestenataeseanetegnanaseeendonanteoaaneecassaneneusannseane 13 de SWINE AUCI rena EE EEA EEEE 16 z DPU AR DOr ennea 17 6 ODEN ai Existing QUCIY crnca aE a 18 ADVANCED TRAINING corceierisusesreiseenpr enserre E E ER EE EEEE S 19 1 C ount FUNCION seriis S 19 2 LOMPE QUO arrana cian inatinawanseeea seueies Us oaesvinssaeiiaanhash ana maNnwecene A eaNeteaeeas Ana NRaNNA NA veNNeS 20 2 1 Dimensions SOY Sc gesectesneccuekcousondtannssasitcusen denetcecahacananaseatasesieicanealianme EE EEES 21 2 2 Boae 4 O10 E S E Te Meee net ane nee ner ener ey Reeve ner ee ee ate ere ee even E ee A T ee eee ee 21 2 3 Oli alg a mola alge gt deen ee ree Tee nn een reer ee eee eee E ee ee ee eee eee ee 23 2 4 Oe PAT OPET O aere E neces werent acon tga arena E E E EA 24 Cardiac Care Network of Ontario 2015 CCN CRS User Manual 2 CARDIAC CARE NETWORK Introduction to the Cardiac Care Network of Ontario The Cardiac Care Network of Ontario CCN serves as a system support to the Ministry of Health and Long Term Care MOHLTC Local Health Integration Networks LHINs hospitals and care providers and is dedicated to improving quality efficiency access and equity in the delive
25. with an enhanced user interface that will provide a more customized experience based on the needs of the end user CCN CRS also includes a Web Intelligence application that is used to run queries against the CCN Cardiac Registry Simply by dragging and dropping users can independently extract their own data from the CCN Cardiac Registry without any database experience After retrieving the data users can then export the data to other software applications such as Microsoft Excel for analysis and presentations This manual provides an overview of the CCN CRScore functions and is comprised in two section The first part of the manual is a simple step by step introduction to the system the second section demonstrates how to access the more advanced functionalities offered by the application This document is intended to be a simple guide to the CCN CRS system providing instruction on how users can extract data from the WTIS CCN Cardiac Registry and export data for analysis and presentation CCN CRS is our new portal for our users that allows users to access their own data If at any point you encounter issues or need assistance with the CCN CRS please contact the CCN Help Desk at help ccn on ca or call 416 512 7472 The Help Desk team is available Monday to Friday from 8 30 AM to 5 00 PM Cardiac Care Network of Ontario 2015 CCN CRS User Manual 4 CARDIAC CARE NETWORK Basic Training 1 Logging In To log in to CCN CRS Go to https
26. y again Once you have clicked Run Query the prompts window will reappear with your previously entered values Click OK to proceed ti Query Panel 5 x gi Add Query 7 Ty oS tal Les Ed ny Pun ouer ai Close 7 Ie Universe outline gi Result Objects h CCN_CRS_Universe gt se G St Ak CCN_CRS_Universe unx 5 Patient Profile Patient LHIN Number f Patient LHIN Name p Patient Demographics A Wait Time Patient ID f Version f Authority Issuing f Patient Full Name Sex 5 3 Patient Full Name f Age f Health Card Number Date of Birth Age Address F Query Filters Pe y R g Phone pj Facility Removal Date Range lp Waitlist Category E Urgency Information i TAVI leo Referral Form lp Wait Times Data len Scheduling Details le Offlisting Details B Adverse Events Data Preview rm Refresh len Notes len Site Specific Elements leo Wait Times Information E Procedure Filters p Other Filters IE Old Elements FE E eee Seer eee eee eee eee eee ee ee eee eee E query1 4 4 gt a Last refresh date This document has never been refreshed Cardiac Care Network of Ontario 2015 CCN CRS User Manual 14 CARDIAC CARE NETWORK Once you have made all of your changes and rerun the report you will notice in the Report Panel that the newly added fields are not showing up in your table The new fields have been added to your
Download Pdf Manuals
Related Search