Home

EPINet-OR Manual - International Safety Center

1. sign Note that the sign isnow a sign and the submacro hasbeen expanded to display all steps See pictures shown above Foreach line that starts with Database name change CA epinet epinetmdb to the desired location For example J myfolder epinet mdb Close the macro by left clicking the small x below the larger X in the upper right of the screen NOTthe box You delete the submacro if you click the x inside the upper left of the box Left click lt Yes gt to Save the changes when prompted Close the Navigation pane by left clicking the double left pointing arrows lt lt Left click the down arrow under View on the Views ribbon Left click lt Form View gt Change default EXPORT file destination from C EPINet EPINet OR defaults to importing and exporting data to the C drive Thisisnot a problem if the user never needsto import or export data However asan administrator you expect to receive data from the userona periodic basis so you must make modifications to allow data export to another location Changing the import location isa separate process There are more submacrosto change when altering the export destination than when altering the import location 1 2 Open EPINet OR using the admin usemame and epinet password Left click the lt Home gt tab 42 3 Left click the down armow under View on the Views ribbon then Design View gt 4 Ifthe Navigation pane doesn
2. EPINet O FOR MICROSOFT ACCESS EXPOSURE PREVENTION P INFORMATION NETWORK gt 2010 U S Janine Jagger M P H Ph D and Ginger B Parker M B A International Safety Center ginger parker internationalsafetycenter org 434 962 3470 EPINet is a trademark of the University of Virginia Windows is a registered trademark of Microsoft Corporation in the United States and or other countries Operates in Windows XP Windows Vista Windows 7 and Windows 8 environments 2000 BD and Company The authors wish to acknowledge the technical assistance of Joanne Rogol Data Services Charlottesville VA Contents What Is Access 2010 EPINet OR 5 scicsssscsascssssaasssnscezsosnssenssssscansassionteonssensonssseeeeespenssoosoeds 5 Program requirements for running Access 2010 EPINet OR c csssscsssseessseeeseeeeesseees 6 Installing EPINet OR cececasicccccsarconestawcccexsceecnnivinserussesqsews cecesansteeassaneesnaneem eae 7 Tabs Ribbons and NOS isis sisssescevccsvsisedceccceed Sssdisciossendeeccsavetioscentecs csavdivesseuteutdsucssasseviconesenes 8 Setting up EPINet OR this will speed data entry later cc sesssseesesssseeceesesseeeeees 8 Designating Facility ID and Facility Type oo eee ceesseseesceeeceseeececeesesececsaeseeeaceatseeeesceassesaees 9 Facility D neee e enon cee ec ded vse atin ta sda saad easton E E E E 9 Setting up response choices Manufacturer List and Medical Speci
3. table Type PostExposure no spaces in the box Ensure that Structure and Data is selected then left click lt OK gt Close the database Reopen the new database and follow the steps to import Post Exposure data as before aus to oN Note The box Enter Parameter Value may appear multiple times depending on the versions importing from and importing to Click lt OK gt without entering a Parameter Value Those notificationsare not considered enor messagesand are nota problem 39 Excluding responses or including multiple responses in the Summary report Sometimes you want to exclude one or more responses or include more than one response to a question fora summary report You cannot exclude entire questions from the report The only way to exclude questions isto have no responses ever entered forthat question If you try to force that you would destroy the integrity of your data Reports altered in this way include only the allowed responsesso may have very few records The percentagesin column three of the report still represent the percentage of the total that responded that question This technique works for other questions not just job category Be sure to change the query back that all responses display in subsequent reports For this example I am eliminating all student job categones 3 5 and 17 from the Needlestick and Sharp Object Summary Report 1 Open the database using the admin usema me and epinet password
4. 2010 EPINet OR Blood and Body Fluid Needlestick and Sharp Object Access 2010 EPINet OR allows you to create bar graphs using data from either the Blood and Body Fluid Exposure or Needlestic k and Sharp Object Injury data sources The fields you can select differforthe two data sources Graphs Es Preview Blood and Body Fluids Graph Report x 1 Left click the lt Reports Graphs gt tab and papan either Blood and Body HAuid gt or Show Al lt Needlestic k and Sham Object gt on the Graphs ribbon 2 To accessthe data for your graph you must Select graph click on either lt Custom Dates gt or lt Show all gt 3 Surgical service 4a Was it an endoscopic laparascopic procedure if you se lect Custom Da tes you must fill in the 5 What is the job category of the exposed worker d ate ra ng e z 6 Where did the exposure occur 7 Was the source patient s identity known 3 Left c lic k the d esired g ra p h a nd c lic k 8a Was the body fluid visibly contaminated with blood lt Preview gt 41a If surgical gown was it amp 12 Was the exposure the result of i 13 7 I b b fluid il If you are creating a graph using the Device anor ain ee wee ee category under Needlestick and Sha po bjec t click 14 How much blood or body fluid came in contact with your skin or mucous membranes lt Which device caused the injury gt You then selecta device type from the drop down menu Needle
5. E mail More Close Print Page Pages Pages File or XPS z Preview Setup Page Size Page Layout Zoom Data Generate the report a Left click the Print Preview gt tab lt More gt on the Data ribbon Close print and finally the Word gt option on the drop down menu ee In the boxthat opens confim the name and destination for SEE Epari tis selected orean your report You may use the Browse feature to provide a new name and location for your Microsoft Word report Click the option Open the destination file afterthe export operation iscomplete Click lt K gt Sa ae EN E an HTML document If you have accepted the default name and location and have previously generated a report using the default name and location you have the option of wnting over it or providing a new name and location If you have clicked the Open destination option your document will open asan rtf file in Microsoft Word You may make fomatting changes in Microsoft Word and print using the standard Word commands Changes made in Word do not change data in the database Closing Microsoft Word retums you to Access 2010 EPINet OR The default name of the file created is rptBBFSummary rtf OrrptNeedleSummary rtf Sending the report to Microsoft Excel 1 2 Generate the report Left click Print Preview gt then double click lt amp xcel gt on the Data ribbon As with Word the box that opensdesignatesthe name and location of the spread
6. If you have not entered namesin your records a comma appearsin the name field in the record selection list If you have not entered names select the report by Incident ID Date and Facility ID A healthcare worker may have reported a number of injunesand or exposures so a name may appeara number of times in the database Summary c ustom reports You can produce a variety of summary reports underthe Reports Graphstab Most of the reports give you a number of options selecting all recordsin the database records within a range of dates orrecords meeting the criteria you select from drop down menus Standard Summary report These reports provide an accounting of the combined records within the database or just the records that meet the criteria you specify These reportscondense a large amount of information into easily understood numbers and the coresponding percentages of the total number of responses for that category Summary reports provide information on injuries occuning within each location procedure and job category in your institution as well as many othercategones You can generate Summary reports for all records within the database for injures occuning during a specified range of dates orfora combination of range of datesand specific resoonsesto EPINet OR questions This latter report isa Limited selection report 1 Left click the lt Reports Graphs gt tab Custom dates Showall Limited selection then lt Summary Report un
7. Options within Access 2010 EPINet OR 0 ee cceseseeeecesceseeeceeeceseeececeetseeecseeetseeeseeeaes 26 Custom graphs Graphing more than one Variable ee ceeceeeseeeceeeeseeeceeeeeseeeceeeeteeeeeneeaes 26 Exporting Dala a er e ea aoee ese aea rea Ee sae ae ES acc caacel cans TAO EKE eA S CENE aS ete 27 Exporting raw data to another Access database ssesssssssssesiersreresesesrsrsrsrssststsesrsrsrsrererenes 27 Exporting database to an Excel Tle ssccccscsscetsasstossacapstlesessaveassasblesnatsahintonssclesassdvieanavbdadoansdseeunansas 28 Exporting summary report data case os csc cwyiveaxecesocesu cou ysey exons ces teeeaie ova ete pauentnn dean wes teeedene tucoes 29 Adding New Users and Changing User Passwords c ccsssscesssecesssecesseecesseeeesseeeeseees 29 Help alts estes Ata I ge Recetas Mal Ba eae eal a oda re A sls Bees A fe de edt A 30 Appendix Torei aeaee soma tus enon eE aeee a aae EE oar aeS anes e ienasi E Staas 31 Importing Data into a New Version of Access 2010 EPINet OR l 31 PAD e11 e D 2 eae scacasisrevassctssneeunosaws sisead A E RE 34 Miscellaneous Tips and How toS s sssssssssssssssesrersrresesrsrsrsnrsrtntntssstsrsrttenenenesenrstsnnsnentntstseennt 34 Intro to New EPINet User NOT a Program an Application This information for IT personnel etenn eken ah e E eas E ae e cote eee 34 Why EPINet has 2 different reporting fOrmS sssssssssssssssssesesesrsrsssrsnsnssssssssrsrsrerenenesrsrsrsrsrsn
8. Surgical or Glass Be sure you also select either Preview Close lt Show all gt or lt Custom Dates gt and again if you select Custom Dates fill in the desired date range If do not select either Custom dates or Show all no data will appearon the graph These graphs show all of the devices forthe type of device selected whether needle surgical orglass There isno graph option that will show the three device categories You may print the graph by clicking the print procedure described above Graphsdo not export to Microsoft Word or Microsoft Excel Custom graphs Graphing more than one variable The graph feature in Access 2010 EPINet OR doesnot allow you to select more than one vanable To create graphswith more than one variable forexample nurses J ob Category 26 injured in patient rooms Where Injury Occurred using disposable syringes Device first create a Limited Selection report export that report to Excel and then create your graph in Excel Generate a report displaying the desired information following the steps described above to generate Limited Selection reports then follow the stepsabove using the Print command to send the report to Excel Click lt Print Preview gt on the menu barthen lt E amp xcel gt on the Data ribbon The Export Excel Spreadsheet box opens displaying the file name and format You may also have the option of selecting a File format Excel 97 may be your only option You may
9. can locate the active version by right clicking on the EPINet OR shortcut clicking the Shortcut tab and noting the addressin the Start in box If you do not use a shortcut to open EPINet OR go to the location where the version you used resides COPY that file to C epinet RENAME this file that you just copied overto the epinet folder on the C drive epinet mdb This will make the addressc epinet epinet mdb A problem will arise here if file extensionsdo not display on yourcomputer If file extensions are not displayed change the computer settings to show file extensions before renaming otherwise you willbe naming the file epinet mdb mdb Or epinet mdb accdb and it will not import If you have not previously opened this new version of EPINet OR follow the steps for oE ail switchboard EPINet for Microsoft Acces File Home Create External Data Database Tools Acrobat Forms Reports Graphs Import Export About EPINet Manage User Accounts Blood and Body Fluid Post Exposure Facility Information Blood and Body Fluid Blood and Body Fluid Blood and Body Fluid Needlestick and Sharp Object Special Post Exposure All Other Tables Needlestick and Sharp Object Needlestick and Sharp Object Needlestick and Sharp Object Post Exposure Post Exposure Post Exposure Import Tables Import Post Exposure Import Facility Information Export with Names Removed Export with Names Export To Exce 1 Logon using the
10. each incident record If you are a single institution you need to designate the Facility ID during set up orit will remain the default ID Unknown The Facility ID appearsautomatically when you enter data If you are part of a network the network administrator will assign the Facility ID then when entering data you select your ID from the drop down box on the data entry form The system defaults to the first ID in the table A Facility ID can be any combination of letters and numbers Choose an ID that does not reveal your hospital s name if you plan to share your data If you select an abbreviation of the facility name others can easily identify your data Unknown isthe default Facility ID To change oradd another Facility ID use the same procedure used to designate it initially The new Facility ID is available forall future incidents but doesnot change any data previously entered Home Create External Data Database Tools Forms Reports Graphs Import Export About EPINet Manage User Accounts s ca es Blood and Body Fluid Blood and Body Fluid Medical Speciality BBF Table 1 Responses Needlestick Table 1 Responses Email text Needlestick and Sharp Object Needlestick and Sharp Object Manufacture List BBF Table 2 Responses Needlestick Table 2 Responses Post Exposure Post Exposure Facility ID User Defined Labels Data Entrv Forms Modifv Correct Data Form etup Database Tables BBF Added Ouestion Responses Needlestick Added Ouestion Respo
11. f i Mar 04 2009 i H S244 Stamp Postage Apr 10 2009 Data Forms ribbon A list of Post B150 Apr 06 2009 ss B140 Tulip Red Jan 02 2009 Exposure recordscontaining BES Marigold Yellow TERA Incident ID Name Incident date B105 Rose Red Jul 21 2009 and Facility ID willappearina green box 2 Highlight then click on the desired record and click lt Open Post Exposure for Edit gt The record isnow available fored iting P Open Post Exposure for Edit Close Unlike in Blood and Body Fluid or Needlestick and Sharp Object you cannot page through multiple records for editing you can only edit one record ata time Close the edited record to retum to the Post Exposure Edit screen to select another record to edit Generating Reports EPINet OR allows you to produce a variety of reports for either the Needlestick and Sharp Object orthe Blood and Body Fluid databases When you click the lt Report Graphs gt tab several report ribbons appear Under Blood and Body Fluid Reports and Needlestick and Sharp Object Reports you can generate a report fora Single Incident a Summary of records ora Log listing of records There isno Summary orLog report for Post Exposure Follow up Use the Reports Graphs tab to generate simple graphs Home create External Data Database Tools Forms Reports Graphs Import Export About EPINet Manage User Accounts Acrobat Single Incident Single Incident Single Incident Sharp Object by Device Blood and Body Flu
12. key Until you enter the comected date the 01 01 1990 records will be included in Summary reports only when you use the All data option EPINet OR doesnot reuse an Incident ID record number The information entered ina record islost if a valid date isnot entered When this occurs future IncidentID numbers will not match the total number of records in the database shown in the lower left of the screen This isnot a cause forconcem The total number of records in the databas is alwaysthe number in the lower left hand comer of the edit screen for that record type BBF or Needlestick regardless of the Incident ID number You can click the lt Fomms gt tab and either Blood and Body Auid gt or lt Needlestick and Sharp Object on the Data Entry Foms ribbon and tab through a blank record without having an Incident ID assigned If you do NOTtab to the Incident Date field Once you tab to the Incident date field you must entera valid date orclose the program Follow the above directionsto handle this event When you select the option to add a new record the number of records shown in the lower left comer of the screen will be 1 If you then add 5 records the number 5 will appearin the comer This represents the number of records you have added not the total number of records in the database When you select the option to edit the actual number of total records appears in the lower left comer of the data entry box The assigned Inc
13. press gt in the lower left of the screen until the desired record appears If you are looking fora recently entered record it iseasiest to go to the last record by clicking the vertical bar preceded by the right pointing anow P and pressing the Page Up key orthe back arrow lt 4 to move backwardsto it To go to the first record click the button with the vertical bar followed by a left arrow lt The button with the right arrow followed by an asterisk gt will take you to a new blank record The arrow buttons are located in the lower left section of the screen B Search records using the Find button If there are a large number of records in your database _ _ o File Home Create External Data Database Tools Forms Reports Graphs Import Export About EPINet Manage User Account search for z 2 Ascending T Selection 7 i New x x 23 Replace a record ac r cone eee 2 eF Save YF Spelling R nn a using the Mies een oe be Select 7 Windows gt AND ews Clipboard Sort amp Filter Records Find vindo button 1 Left click the Foms gt tab then click either Blood and Body Auid gt or lt Needlestick and Sharp Object gt on the Modify Conect Data Forms 5 eT ribbon ly Select 2 Place the cursorin the desired search field If you have the last Find name date or Incident ID it is best to search on these fields 3 Left click and highlight the entire field on which you plan to search 4 Lef
14. the Summary report 40 Missing OWG dll Tile erroris dalennau 41 Change default IMPORT file location from C EPINEt 0 ce eeeeeeeeecneeseeeeeceeaeeeeeeeeeaeeeeeees 41 Change default EXPORT file destination from CAEPINet 00 cee eeeeeeeeeeeceeeseeeteeetaeeeeeees 42 Problems importing Post Exposure Galas 5 5 zangntoxeeeatenntiwndshcctsdeanteniSaemeavvaonvetas ota eateries 43 Using EPINet in a Network ssi 0 ccesceseshatesseaecentaneabete teas catenald natpavmacadoaledeasaveabanhlatsaecttnases 44 aN aol ae Ge AEE T A E O 45 Calculating rates based on number of occupied DEMS s sssssssessesesesesrsrsrsesesssesrsrerererenes 45 Calculating rates based on job category sssssssessssesssssssssrsrerereresesrsrsrsrrsntntsesssrsrsrerenenenes 45 Calculating rates based on type of device ssssssesssssssssssrsrerereresesrsrsrsrsrntntsesssrsrsrsrerenenes 46 What is Access 2010 EPiNet OR This isthe manual to the Access 2010 edition of the Exposure Prevention Information Network EPINet surveillance system a computer application for Microsoft Access that tracks sha ps injunesand blood and body fluid exposures that occurto healthcare workers in Operating and Delivery Rooms as well asthe post exposure follow up EPINet OR the application wasdeveloped in 1994 by Janine J agger M P H Ph D Director of the Intemational Safety Centerand hasbeen administered by Ginger Parker M B A also o
15. the hospital they practice in Their injunes may or may not show up in hospital records If injuries are reported fornon employeesthe rates calculated will be too high since the denominator is not representative of people covered For other groups such as medical residents whose working hours may be extremely enatic it may not be possible to obtain a reasonable full time equivalent estimate fora denominator When using this method of calculating rates it is better to limit the calculations to occupational categories for which a reliable numerator and denominator can be obtained Calculating rates based on type of device Finally ratescan be calculated forspecific devices Rates of needlestic ks for specific types of needlesare necessary when comparing needlestick risk from different devices and for evaluating the effectiveness of products designed to prevent needlesticks To calculate device based rates a health care workermust accurately identify the type of needle involved when reporting his or herneedlestic k injury The numerator consists of the number of needlestic ks with a particular device during a specific date range and the denominator consists of the number of devices used during the same date range A devic e based needlestick rate using syringesasan example is calculated in the following way 100 NSI from disposable syringes during given time period 0001 10 NSI per 100 000 syringes 1 million disposable syringes used or purc
16. 2 Left click the lt Home gt tab the down anow under View on the Views ribbon and lt Design View gt 3 Left click the Queriestab that appears in the Navigation pane that openson the left If Queries is not visible at the top of the Navigation pane left click the down arrow 1 on the top right of the pane then left click lt Queries gt that appears following Alter by Group 4 Grab the right side of the Navigation pane and pull it right to expand its width so the full Query titles can be seen 5 Scroll down the list and right click lt qryNeedleSummarylnitpt 6 Scroll right to locate the field name of the question you wish to modify The column headingstend to go in the orderthe questions are asked on the questionnaire form 7 Forthisexample scroll to J ob 8 To eliminate students ADD lt gt 3 and lt 5 and lt 17 to the Criteria line Do NOTtype in the quotation marks 9 Close the query by left clicking the small x below the larger X in the upper right of the screen Left click lt Yes gt to Save the changes when prompted 10 Close the Navigation pane by left clicking the double left pointing a rows lt lt 11 Left click the down arrow under View on the Views ribbon 12 Left click lt Form View gt 13 Run the Needlestick and Sharp Object Injury Summary report Forthe BBF Summary Report change qryBBFSummarylinitrpt Forthe BBF Summary Log Report change qryBBFLogInitrpt Forthe
17. 3 in Access 2010 The fix wasa simple update Follow the steps below if you get this message Example 2 In the early 2000 sa Canadian usergot an enor message that the object file cannot be found Thisoccurred when the user tried to open the program She gota Microsoft DAO 3 xx Object Library cannot be found message Thisfile residesat C program files common files Microsoft shared DAO in my machine If you see this message have your ITperson go to the Microsoft website and update the MDAC files This promptly resolves the problem It does not help the userto copy the missing file from another computer to their computer After updating the file follow the steps below 1 Open the program while pressing the shift key This may take a try of two to get this only EPINet OR to open 2 Ifthe Navigation pane is not visible along the left of the box left click the double right pointing arrows gt gt Left click the down arrow V of the Navigation pane Left click lt Forms gt that appears after Filter by Group Scroll down the list and right click lt frmBloodBodyRuid gt Left click lt Design View gt Single you may need to double left click the square with red yellow and blue bands on the Design tab in the Tools ribbon to display the code It may be labeled View Code 8 Once the boxesof code appear click lt Tools gt then lt References gt on the menu barat the top of the code box that opens not on
18. Access Do not delete these files Move these files to c epinet creating that folderon the C drive if necessary The third mdb file isthe actual application Create a shortcut to it to place on your desktop Double click to open the application If you do not have WinZip you may download an evaluation version free of charge from the website www WinZp com We tested EPINet OR with WinZip but other decompression programs may work If using something other than WinZp use one that does not re compress the database file when it isclosed The first time you open Access 2010 EPINet OR please follow the 11 steps listed below to put in place the default settings for Access These stepsare only required the first time you open the program Not all steps may be required 1 Double left click the file Access 2010 OR EPINet US v 1 1c accdb to open the database 2 Ignore the login box Instead go to the top yellow barunderthe menu bar Security Wa ming Some active content hasbeen disabled Click for more details Click the lt Enable content box on the right Note If asked about making thisa trusted location click lt Yes gt 3 lf another yellow box doesnot appear go to step 7 4 Go to the second yellow menu bar Read Only This database hasbeen opened read only You can only change data in linked tables To make design changes save a copy of the database Click the lt Save As gt box on the right 5 Cl
19. Access requires Windows XP orhigherasthe operating system Access 2010 EPINet will not work with earlier versions of Microsoft Access Recommended Hardware intel i5 with 3 GB RAM Installing EPINet OR Save the zip file to the epinet folderona shared or network drive that is limited to the users of EPINet OR Ifthe epinet directory doesnot exist create it and copy the file to it Save the zip file to c epinet if you do not have a network drive Do not overwrite a file that exists in that location If a file with that name already exists at that location rename the pre existing file so that new file will not overwrite the old file Those with WinZp software installed can simply double click on the EPINet zip file and select the Extract option The Application will unzip to yourdefault location usually to the My Documents folder Note the default location go there and move the files to the epinet folder If you have the option of specifying the location for the files when use the Browse button to locate the epinet folderand extract the files there There will be six files Three of the six files are Word documents that are the reporting forms used with EPINet OR Create a shortcut for these filesand place them on your Desktop See Microsoft Windows documentation if you need help with creating shortcuts Two of the files EPINetFull mdb and EPINetConfidential mdb willbe empty databases used by the export features of
20. Data entry usemame and edit password Left click the lt mport Export Menu gt tab 3 Click Facility Information gt on the Import Facility Information ribbon The screen will not change upon successful completion of this procedure 4 Left click the lt mport Export Menu gt tab 5 Left click lt All Other Tables gt on the Import Facility Information ribbon The screen will not change upon successful completion of this procedure N You may see a screen notifying you that certain tables do not exist and will not import Click lt OK gt without entering a value This may occurseveral times It is most likely to occur when upgrading from Access 2003 to Access 2010 regarding an email table The existing tablesin your old version of EPINet OR should be imported even if you received messages 1 Left click the lt mport Export Menu gt tab 2 Click Blood and Body Auid gt on the Import Tables ribbon Upon successful import of your data the Facility ID User defined Fields box will open 3 Left click lt Close gt 31 Note Before you see the Facility ID User defined Fields box you may see an Enter Parameter Value box If so click lt OK gt without entering a value This may occur several times The Enter Parameter Value box appearseach time a field isimported that doesnot contain any values The most common reasonsto see this box is when you have not entered healthcare worker namesin your database You will see this box fo
21. Needlestick Summary Log Report change qryNeedleLoginitpt Note This only works forthe SPECIFIC report changed It doesnot work on graphs or single incident reports The example above excludes only a few categories so uses not equal lt gt and AND If you are excluding most of the responses such asonly excluding all except doctorsand medical students use equal and OR In thisexample step 8 would be or or Do not type the period When using the OR option be sure to include all responses that are wanted since those not included in the OR list will be excluded To include more than one response you are basically using the exclude all except option so you would use the equal OR option 40 Missing OC dil file error The missing Object Library reference is often the result of working with the EPINet program on machines that have had two different versions of Microsoft Access installed In the process the computer will include Library objects for both versions in the coded references This is something the Microsoft hascontrol overand not the user When the EPINet program is subsequently opened on a machine with ONLY one version of Access the program will have an emor message related to the missing Library Object Users only need to clear the missing reference to solve the problem Example 1 An Australian user got an enor message about a missing dil file when using EPINet for Access 200
22. R Data to Hospital Committees and Administrators How Can Put EPiNet OR Data to the Best Use in My Hospital We Provide the Following Suggestions There are many user friendly options for presenting EPINet OR data utilizing the reports provided in EPINet OR The simplest way to present hospital data isto generate the Summary reports using the drop down menus pre programmed into EPINet OR from the ReportsMenu command on the menu bara the top of the screen Afterselecting Report menu select Summary Reports and either Blood and Body Fluid or Needlestick The screen that appearswill allow you to generate a report forall of the data you have entered forthe time range that you specify or for selected responses to EPINet OR questions forthe time period you specify This last report iscalled the Limited Selection report After making your selection s left click Preview and aftera short wait the report will appear You can view the report send the report to your printer for printing send the report to an Excel soreadsheet to make graphs of the data orsend the report to Microsoft Word to delete un needed sections of the report The Limited Selection option allows you to review subsets of your data for closer analysis You can select one response from one or several of the EPINet OR questions by using the drop down menus To generate a report of injuries to nurses select the Limited Selection option enterthe date range yo
23. a community hospital and may therefore have a higher needlestick rate perbed because more needles are used per patient Calculating rates based on job category Needlestick rates can also be calculated for different professional groups such as nurses physicians laboratory technicians housekeepers and laundry workers With this method the numerator isthe total number of needlesticks reported by a specific professional group during a specific date range The denominator is the total number of full time equivalent FTE employees of a specific professional group during the same date range Using nursesasan example the rate would is calculated this way 250 nurse reported NSI in 1 yr 25 NS perFE nurse per yr 1 000 FIE nurses employed that yr Full time equivalent means that if for example you have 50 part time nurses they count as 25 full time equivalent nurses This method givesa more accurate denominator than simply counting the number of nurses employed For some occupational categories it may be difficult or impossible to calculate an accurate rate For instance in some hospitals 45 contract workers providing servicessuch as phlebotomy orhousekeeping are not considered employees of the hospital If those workers report their injuries to their contracting agency the hospital may not have a record of all incidents occuning at the facility Furthermore in many private hospitals not all of the physicians are employed by
24. ackage The version of Windows you have on yourcomputer does not matter EPINet worksin all versions from Microsoft 95 to Microsoft 8 To allay any concems your ITdepartment may have you can tell them this is not a true program Iltisa database designed for Microsoft Access As such there are no dll or exe files You simply copy filesto yourC drive ora secure location on your network Why EPiNet has 2 different reporting forms It isa question that is raised almost every time EPINet has been introduced into a new place When EPINet was in its infancy we also did not know the answer to the question of whether it would be more successfully implemented as one integrated form ortwo separate forms But now that EPINet has been introduced into many countnesand we have had experience in both methods we know the different outcomes The two forms SOI and BEF one for sharps injuries the other for body fluid exposures were initia lly separated because sharpsinjuriesand body fluid exposuresare described very differently Sharpsinjunes occurto one discrete body location and are caused by one item needle sharp device related to one medical procedure blood drawing IV insertion etc These are all check one response type of questions Body fluid exposures are different First the exposure can span several body locations The exposure Can involve multiple body fluids The range of devicesand productsimplicated in the exposure are mutually e
25. acrosdoesnot appearat the top of the Navigation pane that opensalong the au so CON 10 11 12 13 14 15 16 17 18 19 20 left of the screen left click the down arrow J and scroll down below Filterby Group and left click lt Macros gt Right c lic k lt importtable gt then left click Design View gt If the box left of Submac ro ImpornBBFVersion containsa go to the next step otherwise left click the sign You will note that the sign isnow a sign and that all of the sepsin the submacro disappear Repeat foreach submacro until all are closed Re expand the Submacro ImportBBFVersion by left clicking the sign to its left If necessary expand the line beginning If Forms Switc hboard Sec urityLevel lt gt 3 Then by clicking the sign On the line labeled Database Name change CA epinet epinetmdb to the desired location For example J myfolder epinet mdb Left click the sign to minimize thissubmacro Repeat steps7 through 10 foreach of the following macros doing so one ata time Do NOTchange any otherimport macrosin the list ImportNeedleVersion ImportPostExpVersion ImportMasterVersion ImportPostExpSpecialVersion or ImportSp PostExp Version Right clic k lt mportOtherTables gt then left click Design View gt If the sign isalready displayed to the left of ImportOtherTables continue without checking the box Otherwise left click the
26. als different professional groups or different device categories Rates consist of a numeratorand a denominator In the three methods of rate calculation that follow the numerator always consists of the number of needlesticks that occured overa specific date range The denominator is either the number of occupied beds the number of full time equivalent employees ina specific professional group orthe number of particular devices used during a given date range The date range conesponding to the numerator and denominator should always be the same Calculating rates based on number of occupied beds The simplest rate to calculate isthe total number of needlestic k injuries NSI reported during a specific date range numerator overthe number of occupied hospital bedsin an institution for the same date range denominator The average daily census of occupied hospital bedsforthe same yearasthe reported needlesticksis the relevant number to use in the denominator since it comects for unused hospital beds A realistic example would be 350 NS per yr x 100 44 NS per 100 occupied beds peryr 800 beds This givesa rough idea of the institutional needlestick expenence which can then be compared to other institutions This rate willbe affected by the level of underreporting of needlesticks and also by the types of patients treated in the hospital A regional medical centeris likely to treat a higher proportion of patients requiring intensive care than
27. alty ccceseeeeee 10 Ma utacturer Listeners oie ae EE ie E eee 10 Medical Spe ialty gece ene ane eee ee ene a ee E ERE Ea ee eee 10 Customizing Access 2010 EPINet OR sjcsssscsasscsscisisaceeavacaseserscnctaetadasesssestedensnatcnss tasecnebasacesancdete 11 Adding customized questions a scicecsentpastonseexeseetsecsiatasssees sisa ete Sees o ea ESE 11 Adding questions to paper reporting fOrMS uu ee eseesceseeeeeeeceseeeceeeceseeececeeseeeeeeatseeeeeeeaes 12 Adding questions to the software data entry fOrMS ccceeceeeseeeeteeceeeeceeeetseeecseeeteeteeneaes 12 Entering response choices for added QUESTIONS ee ceeesseeeteeeeeceseeeeeeeceaeseceesctateeeeeeetatees 13 Designing User Defined Fields Responses uu sessssssesceseceseeeeeceaeseeeeeceaeseeececeateecaeetaeees 13 Entering New ROCOFGS iis cccccessacsccaxsctivensssnceoasvsesaeavaesenerec asrin v sno een ease oops eres 14 Enter Blood and Body Fluid Exposure or Needlestick and Sharp Object Injury record 14 Adding post exposure follow up recordS eeseesescesseceeessesceseeeeecsceaesececseesesecacataceeeseeatseeeeaceas 16 Tips and handy notes for entering NEW recordS seeceeeeeeceeeseseeeeseeeceeeeeseeecaeeatseeecateateetetaeeas 17 Editing FROG ONS sins sits iscisscascawtisssiccdeessins cns sumac aaas ua uassuas sade aadenssantavnssexds anid ends casiuabivesdiaretasiexs 18 Generating FIC DONS scacscacssasesisxcayesscianaicsnkansica srona ves vesaenaevsta
28. are two digits and year is four digits separated by slashes Enterthe date and click lt OK gt 3 A scond Enter Parameter Value box will appear prompting you to Enter End date 4 Click lt OK gt again The data isexported to a file called either EPINet BBF xls EPINetNeedle xls or EPINetPostExp xls depending upon your selection These filesare placed in either My Documents or the CA epinet folder When you view the exported data in the Excel file you will 28 note that the time field is displayed in date format Simply highlight the column and change the format to Time If you cannot write to yourC drive see the Network Administrator Manual for instructions on changing the default Export location Exporting summary report data An option under the Printcommand allows you to export any of the Summary Reports to either Word or Excel This option exports only the data in the report not the raw data used to generate the report The program uses only one name rptBBFSummary xis or rtf for Blood and Body Fluid reports and one name nmptNeedleSummary xis or rtf for Needlestick and Sharp Object reports but will query you before it overwritesa pre existing report If you wish to save more than one Blood and Body Fluid or Needlestick and Sharp Object report we suggest you rename the report or move it to another folder See the section on Printing Reports for instructions Adding New Users and Chang
29. change the name and location of the file created The default isto export data with formatting and layout Click the option to Open the destination file afterthe export operation iscomplete Click the lt OK gt button at the bottom of the box If you have generated an Excel spreadsheet in EPINet OR before without changing the default name and location you will be asked if you wish to overwrite the existing file You may choose to overwrite orto change the file name If you receive on Overflow emor when exporting to Excel click the option to continue This will not affect the spreadsheet Row 1 of the Excel spreadsheet created containsthe names of the variables listed in the report These cormespond to the questions that appearat the top of the Summary report generated Row 2 contains the values assigned to that vanable The default value forthe variables is ALL The variablesthat you selected to change forthe report will show the response you selected Scroll to columnsQ R and S forthe Needlestick and Sharp Object Injury report columns M N and O forthe Blood and Body Fluid report to display the responses to the questions Scroll down the columns to locate the range you wish to chart Use Excel s commandsto create yourchart If you need help with creating charts in Excel refer to the Help feature of Excel The row containing Desc indicates the changeoverto the next question and to the next page You can delete the Desc row that split
30. cur ALL the num b er of the 10 At the time of the injury was the sharp instrument item ALL 11 The sharp item was ALL response choice 12 What type of device caused the injury ALL yo u wa nt fo ra Which device caused the injury ALL 13 If the item causing the injury was a needle or sharp ALL g Iven q ue stio n fo r medical device was it a safety design with a shielded recessed retractable or blunted needle or blade exa mp le 4 fo r 17 Dominant hand of the injured worker ALL Nurse under ob Category you OK Cancel may enter it without using the down arrow in that box ALL isthe default critena If you select criteria other than ALLand change your mind you can re select ALL for most questions listed For Facility where incident occured and Type of facility where occured the ALL option cannot be re 21 selected To re select ALL for those questions simply select lt Close gt at the bottom of the box and re select lt limited selection gt ALL will once again be the default value The criteria in the Limited Selection screens for Blood and Body Fluid and Needlestick and Sharp Object Injury reports differ You can generate a variety of reports by selecting different combinations of responses These reportsallow you to bettertarget areas for implementing exposure prevention measures How the data on the reports change overtime can indicate the success of your interventions I
31. d be empty If you find that is the case follow the steps in the previous paragraph locate the most recent file and start over If your epinet mdb file contains data confirm that it ison the C drive in a foldercalled epinet Confirm that the file name isepinet mdb not epinet mdb mdb Orepinet mdb accdb Confirm this by opening CA epinet left clicking View 32 and left clicking Details Follow this by left clicking Tools Folder Options and the Viewtab then unchecking Hide extensions for known file types C lic k Apply Note If you are importing data from a previously exported file EP INet Full mdb or EPINetConfidential mdb you may need to go into the Full or Confidential file and rename the Post Exposure table from PostExposure to tblPostExposure place caps where indicated and do not have spaces between the words To then import the post exposure table follow the steps listed above If you are importing from an Access 2003 version of EPINet you cannot import Facility Information or All Other Tables Contact ginger parker intemationalsafetyc enterorg for assistance in doing this 33 Appendix 2 Misc ellaneous Tips and How tos Into to New EPiNet User NOTa Program an Application This information for IT personnel You must have Microsoft Access you have installed on yourcomputer in orderto use EPINet It can be 2003 2007 2010 or 2013 Accessisincluded in the Microsoft Offic e Professional p
32. d file contains six files compressed using the WinZip software package A free tral version of WinZip software isavailable on the WinZp website Other compression software may work but confim that the compression software used doesnot recompressthe data upon closing the program The six files included in the zipped file are the three questionnaire formsthat are Microsoft Word documents oOR Uniform Blood and Body Fluid Exposure doc OR Uniform Needlestick and Sharp Object Injury doc and Post Exposure Follow up doc The working EPINet OR database file hasa name that specifies the version of Access a country code abbreviation and version Before compression the size of this file was6 megabytesor greater The two additional database files EPINetFull mdb and EPINetConfidential mdb are required to export data into another Accessdatabase These two database files contain three tables BBF Needlestick and tbIPostExposure EPINetFull mdb receivesthe tablescontaining all the data entered forthe penod specified during the export EPINetConfidential mdb containsalldata forthe period specified for the export except the healthcare workersname hence confidential These databases when emailed empty are quite small Program requirements for running Access 2010 EPINet OR Required Software Microsoft Office Professional for Windows version 14 2010 Microsoft Accessisa relational database created by Microsoft Corporation Microsoft
33. der either the Blood and Body Auid Reports or the Needlestick and Sharp Object Reports ribbon 2 Select lt Custom Dates gt lt Show all gt or lt Limited selection gt depending on the desired report Limited selection reportsare described below Enterthe date in mm dd yyyy format for the Custom date or Limited selection reports Once you have made your selections click lt Preview gt to generate the report Close the report you generated by clicking the lt Reports Graphs gt tab then lt Close Report on the Toolstab UB Ww NOTE For graphsand summary reports a response will not appearon the report graph until selected asa response by a healthcare worker This meansthat not all responsesthat appear in the drop down boxes willappearon the report graph For example if no one at your facility has ever reported as being a Respiratory therapist then Respiratory therapist will not appearin the Job category list on the report graph This a ppliesto questions where you can only select one response The Total recordsnumber in the lower left of that section represents the number of healthcare workers that answered that question For questions where more than one response can be selected such as Body fluid involved or Exposed parts all possible responses are displayed even if no one has selected them In this case The Total records tallied isset asthe total number of records in the report Blood and Body Huid Exposure Log Needlestick and Sha
34. dy Auid gt lt Needlestick and Sharp Object or Post Exposure gt on the Export with Names Removed or Export with Names ribbons 2 A boxlabeled Enter Parameter Value will appeartelling you to Enter Start Date in the format mm dd yyyy where month and day are two digits and year is four digits separated by slashes Enterthe date and click lt OK gt 3 A scond Enter Parameter Value box will appear prompting you to Enter End date 4 Click lt OK gt again Export each table separately You receive no notification that the data exported successfully You may receive a data mismatch enor if you have not entered a date range in the comect format Data did not export if you receive this enor The data you select to export goesto a database file in the CA epinetdirectory named either EPINetConfidential mdb Of EPINetFull mdb Whichever database file you export it to Blood and Body Fluid Exposure data will be in the BBF table Needlestick and Sharp Object Injury data will be in the Needlestick table and Post Exposure data will be in the tbIPostExposure table When you double click on the file EPINet Full mdb or EPINetConfidential mdb Microsoft Access will open and the data will appear under the Tablestab Each time you export data you overwrite the pre existing data contained in that table Data remainsin the tables until overwritten or deleted The security features of the Access 2010 EPINet OR program are not in eff
35. e injury rate fordevice A is2 per 100 devices used whereas the injury rate for device Bis 10 per 100 devices used Without knowing the denominator the number of devices used you cannot accurately determine the safety of a device Medical Specialty The listing of the physician s specialties If on question 5 Job Category either doctor attending staff or doctor intem resident fellow isselected a Medical Specialty box will automatically appear Not all physicians will provide a specialty Thisis not a required field and isnot included in reports To set up response choices into one of these tables 1 Open EPINet OR and login using the data entry usemame and edit password 2 Left click the lt Forms gt tab then Manufacturer List gt on the Enter Department Table Values or Setup Database Tables ribbons 3 Once the table isopen type a response that you want to appearon the data entry screen in the drop down box 4 Press lt Enter gt to go to the next line 10 5 When all choices have been entered Left click lt Close gt in the upper right comer of the box 6 Repeat steps 1 through 5 selecting lt Medical Specialty gt Note When adding responses to the list in the future you may need to use the scroll down arow to get to a blank line To delete a choice from the list highlight the entry and pressthe delete key or type another entry over it Do NOTdelete the word ALL if it appearsin the table Res
36. ecific range of dates orthose associated with a specific department job location procedure ordevice The userselectsthe parameters fora report from drop down menus EPINet OR also hasa report option that generates an OSHA compliant OSHA 300 log Maintaining this log is required in US hospitals The report generator provides the information needed to identify injury and exposure pattems in a facility or network Identifying problem areasis the first step in focused prevention On going data review allows forthe assessment of the effectiveness of prevention strategies EPINet OR works well in a single facility asa stand alone database orin a network of multiple facilities that merge theirdata into a common database In 2013 the US version wasupdated and re programmed for Access 2010 and works within Windows versions XP 7 and 8 Access 2010 EPINet OR provides an additional enhancement to the 2003 version by providing an option to generate an email to send to the injured or exposed healthcare workerasa reminder to retum for follow up testing With the exception of adding two questions required by Califomia OSHA in 2000 no changes have been made to the OR US Needlestick and Sharp Object Injury and OR Blood and Body Fluid Exposure forms forthe Access 2003 and 2010 versions Access 2010 EPINet OR is programmed forthe US and hasnot been translated or customized for other countries It can however be used in its present form outside
37. ect for these newly populated tables Security remains in effect forthe Access 2010 EPINet OR database A table containing the Facility IDs Types and added questions tb Master is created automatically when you export the Needlestick and Sharp Object Injury data You can delete the tables WITHIN EPINetFull mdb and EPiNetC onfidential mdb after use to protect the confidentiality of yourdata DO NOTdelete the actual mdb files only delete the tables within them To delete the tablesin EPINetFull mdb and EPiNetC onfidential mdb open each database separately and follow these steps If Ta bles is not displayed at the top of the Navigation pane on the left click the down a row and click lt lables gt under Filter by Group Right click the table to be deleted either BBF Needlestick tolMa ser or tblPostExposure and select lt Delete gt The prompt Do you want to delete the table BBF Deleting this object will remove itfrom all groupsappears The table name to be deleted will replace BBF Click lt Yes gt Exporting database to an Excel file ARE ae Needlestick and Sharp Object 1 Left click the lt mport Export gt tab then double left click Post Exposure lt Blood and Body Auid gt lt Needlestick and Sharp Object gt Eoo e or Post Exposure gt on the Exportto Excel ribbon 2 A boxlabeled Enter Parameter Value will a ppeartelling you to Enter Start Date in the format mm dd yyyy where month and day
38. erate the report nn 2 Left click Print Preview gt on the menu bar Name Brother MFC 7840W Printer x Properties 3 Left click lt Print gt on the Printribbon Status Ready j Type Brother MFC 7840W Printer 4 Inthe Print boxthat opens select the _ en eure ese printer print range and numberof copies commert mFc 7840w LAN Print to File Print Range Copies M ethod two man Number of Copies 1 1 Generate the repor Pages From 43053 coven 2 Left click the lt Reports Graphs gt tab to Selected Record s SE j again view the available options _ 3 Click lt Print on the Printribbon 4 Inthe Print box that opens select the printer print range and number of copies 5 Click lt Print gt We do not recommend that you change the preset values since EPINet OR uses customized margins Method three 1 Generate the report 2 Select lt Print under the File tab Save amp Publish Help 24 3 4 Left click Quick Print gt lt Print or lt Print Preview gt Access 2010 providesa description of each choice In the Print box that opens select the printer print range and number of copies Sending the report to Microsoft Word i m _ _ C Print Preview Forms Reports Graphs Import Export About EPINet Manage User Accounts Acrobat Print Print 4 5 Size Margins F print pata Only Landscape Columns Page Zoom 0 0 a He 8 Ou A hMhRBEaEaAaR p Two More Excel Text PDF
39. erson to key in There is even significantly less paper used when the foms are separate because you eliminate one to two empty pages for every fom filled out So the appearance of greater complexity with two separate forms isa question of appearance only In practice two separate formsare simplerand more efficient understand why you think the two forms look inefficient because that is what everybody thinks when they first look at the forms All we can do istell you what ourexpenence has been and advise you on how to get the best results The Employee Health Infection Control nurse completes the Post Exposure Follow up PE form The PE record ismatched to a specific SOI or BBF record As the form name states it is used to track testing after exposure injures not prevent them The type of information on the SOI and BBF forms is designed to assist in the purchasing and evaluating devicesor developing proceduresand protocols to prevent future injuries and exposures Delete a record Be sure to verify that the corect record ishighlighted because once deleted the record cannot be recovered and the delete cannot be undone That record number will not be used again and you cannot recover any information contained in that record Deleting a Blood and Body Fluid Exposure or Needlestick and Sharp Object Injury record does not delete the Post Exposure Follow up record associated with it That isa separate step 1 Open EPINet OR using the data entry
40. es 34 DELS A record 62 2 c vccaceueiestcravccahaiedeealy anduacaaudl a a ea aaa nating 35 Displaying File Types in FOldGrS isa 2 cecusaacde tease Gucten deg es noes elaine tee iene deans 35 Compact and Repair the Database 5 nc esssad ni cas ossasveavshe ge cae ead eta eedocesend aes 35 Handling Data corruption sseicsessaeccascshsdaaiscnceataaadevat savieetesilaPeadeanten reas eiaapareae il stead areata eae 36 Default currency symbol and date format for International users 0 0 eee eeeeeteeeeees 36 Correct time format when exporting to Exel eeseecenseseeseeeceseeeceeseeaeeecassetseeeeaeeataees 36 Define Preventable Injuries Report se ecsuesastceodhseessicssasheusareiaeareawhevasdtae eeermaseereantvmeeaes 36 Why not to ask Shift Worked QUeSTION ceeeeseeeeceteeseeeeececesesececsceaeeecacsetaeeecaesatseeeeateataees 37 Many EPINet OR Users Ask How Can Present EPINet OR Data to Hospital Committees and Administrators How Can Put EPINet OR Data to the Best Use in My Hospital We Provide the Following SUQQeStiOns cecseeseeeteeseteeseeeteceeaeeeteeneees 37 Help Can t See Any Records to Edit Over Incident 999 cc ccesescstsesctseeecseeseeseeaees 38 Change Hospital ID Once Post Exposure Follow up Data has been Entered 38 Problems importing Post Exposure Gata ececcesssesseeecneesetececneeseeececaeeaeeceeeeeaeeeseenetaeeeeees 39 Excluding responses or including multiple responses in
41. f the Center Becton Dickinson and Company BD has provided financial support since its development Data Services Inc of Charlottesville VA provided Accesscoding forthe three most recent versions EPINet isa registered trademark and iscopyrght protected by the University of Virginia Patent Foundation It includesreporting formsand customized data entry screens a pre programmed report facility and graphing capabilities EPINet OR isa tool used to track blood and body fluid exposures sustained by healthcare workers The needlestick and sharp object injury Needlestick and blood and body fluid exposure BBF reports track exposure events rather than individuals The post exposure follow up report tracks the healthcare worker ashe orshe progresses through the post exposure protocol When a sharp object injury or blood and body fluid exposure occurs the injured healthcare worker completes the appropriate report fom usually with the assistance of the occupational employee health department This department then initiates the post exposure protocol and enters the follow up data through the pre programmed data entry screens a process that takes two to three minutes per incident Each injury exposure isa single record in the database Data entry and report generation are very intuitive and require no programming expertise Reportscan be generated on selected recordsthat the user specifies such as exposures occuning within a sp
42. f the program See Setting up EPiNet OR for instructions on how to add Facility IDs EPINet OR automatically generates Incident ID numbers Incident ID numbersare not reused orrepeated if you either accidentally or deliberately delete a record EPINet OR doesnot use that ID numberagain EPINet OR assigns Incident ID numbers assoon as you entera value in any field The ID numbers begin with B1 for Blood and Body Fluid Exposures and S1 for Needlestick and Sharp Object Injuries 14 EPINet OR savesthe information you enter even if do not complete the entry if you have entered a valid date see below As long as you entered a valid date you may later edit or delete that record or you may overtype the information Enter Date with two digit numbers for month and day and four digits for year mm dd yyyy A slash automatically appears as you type the first number Allowed date values are today sdate and earlier You cannot entera date after the current date If you make an enorand the date isnot accepted orneedsto be changed highlight the entire date not just the portion in emor You cannot exit the record without a valid date unless you close the program Intemational Note The date format dependson the date format set in Regional Settings in your Control Panel If you reside in a country that enters data asdd mm yyyy EPINet OR will default to that format for data entry This date format will be consistent throug
43. f you enter the first letter or number of the response the drop down boxwill appear listing the responses beginning with that letter Describe boxes allow any response To select responses for questions where more than one response can be selected eithertab to the response and press the space barorclick the response with the mouse To go to the next page either presstab until you get to the right pointing amow oruse your mouse to move the cursorto the right pointing arrow in the bottom right of the box and click lt Enter Altemately you can click the appropriately labeled tab underthe date and time entry boxes You may also entera new record by clicking the lt Forms gt tab selecting the Modify Corect Data Forms ribbon and clicking lt Blood and Body Huid gt or lt Needlestick and Sharp Object Use the mouse to go to the lower left comer of the screen and click You will be at the curent tab in the new blank record that you were in the previous record You cannot entera new Post Exposure record in thismanner 15 To end data entry fora record click the lt Close gt button at the top of the form EPINet OR saves your information automatically and retums you to the Switchboard Post Exposure Follow Up records conespond to records previously entered in either the Blood and Body Fluid or the Needlestick and Sharp Object data files A Post Exposure Follow up record cannot be created until the matching Blood and Body Fluid Expo
44. f you select more than three orfourcritena few records may be included in the report If you have not entered a date range orno records match the criteria the report will be blank You must entera date range in the mm dd yyyy format for this report to generate Sharp Object by Device report This report providesa count of the injuries caused by each device You may generate this report forall injuries injuriesoccumning within a penod you specify or for hollow bore devices only 1 Leftclick the lt Reports Graphs gt tab then lt Sharp Object by Device gt on the Other Reports ribbon barand a Preview Needlestick by Device box will open with three selections available Custom dates Show all and Hollow bore needles 2 Click lt Show all gt lt Custom dates gt or lt Hollow bore needles gt Clic king lt C ustom dates gt or lt Hollow bore needles gt requires you to entera date range in the mm dd yyyy format With the Hollow bore needles option you can select all hollow bore devices or just specific hollow bore devices 3 Left click lt Preview gt to generate the report Preventable Injury report This report is most useful if you have entered cost data This report providesa count ofall injuries with a given device and the number of those injuries that may have been prevented by using a safety device along with the costs resulting from those injuries The report is generated forthe range of dates you specify An explanation of what con
45. facilities not using the EPINet OR Post Exposure Follow up To the question Source patient positive fon the responses are 1 HIV 2 HepB 3 HepC 4 TB 5 Other 6 HIV amp HepB 7 HIV amp HepC 8 HIV amp TB 9 HIV amp Other 10 HIV amp HepB amp TB XX Unknown XX None of the above You get the idea The allowed responseswill be a long list but providing the combinations of choicesis necessary because only 1 response can be selected forthe added questionsand treatment protocols differ depending on the pathogen It is not elegant but does provide good information on the summary reports Otherwise you would not be able to determine any combinations on the summary report To see what mean look at the summary report for BBF The protective gammentsand body fluids are listed with the number of respondents responding Yes to each item You do not know if the 13 respondent had gloves amp facemask amp gown fully protected or just gloves or how many body fluids are reported in a typical exposure Another approach is assigning individually numbered responses that can then be selected in various combinations Forexample have the question with the following allowed responses 1 Conduct in service 2 C ontact BS Exp Mgr 3 Contact Mgt then the combinations that can be selected can be A 1 B 2 C 3 D 1 amp 2 E 1 amp 3 F 2 amp 3 G 1 2 amp 3 Once more thi
46. hased during same period Ifa trial ofa safety syringe were camed out the above rate would be compared to NS from safety syringes during given period safety syringes used or purchased during same period It may be difficult to find out exactly how many devices have been used in direct patient care Usually the number of devices purchased is the closest approximation that obtainable Obtain this number for calculating device based rates from the purchasing department For devices like IV catheters that are used forone pumpos all devices purchased can be included in the denominator Some devices such as disposable syringes are used for many pumoses not all of which are patient related If large numbers of a given device category are not used for patient care such as syringes used by pharmacy for mixing drugs then the devices not used for patient care should be excluded from the denominator when calculating the injury rate To determine which rate you need to calculate decide which questions you want to answer Do you want to compare your hospital to other hospitals of different professional groups or the injury risk of different devices Make sure that denominator data isavailable for the kind of rate calculation you want to make Following these steps will help you to calculate meaningful ratesand make optimum use of your hospital s data 46
47. hout EPINet OR Enter Time in a four digit 24 hour format A colon willappearas you type the first number Enter Midnight as 00 00 24 00 is not accepted The next tab takes you back up to the Entered By field You can type the name orinitials of eitherthe person who assisted the injured exposed workerin completing the form orthe person who entered the data If you use the initials of the person who assisted in completing the form and have questions later you will know whom to see When several people enter data you may want to use this field to track data entry This field doesnot appearon summary reportsand you cannot sort by the data It is visible only when viewing the individual record EPINet OR is designed to speed data entry To enter the injury exposure data tab through the blockson the screen that corelate to the information on the completed reporting form entering the responses by number or by highlighting then left clicking the indicated response in the drop down boxes For questions that have numbered responseson the paper report form simply enter the correct response number from the report fom Enter Yes No responses by number 1 for Yes 2 for No 3 for Unknown and 4 for Not Applicable or by the drop down boxes A simple Yes or No isnot accepted Enter responses not preceded by numbers exactly aslisted in the drop down boxesor select the choice from the drop down list provided For questions with drop down boxes I
48. ick lt Yes gt when asked if you want to close all open objects 6 Click lt Browse gt and go to the epinetfolder and save the file You can give the file a new name at thistime if you wish 7 Close Access 2010 EPINet OR 8 Create a shortcut to the newly created and named file and place the shortcut on your desktop 9 Clickthe shortcutto open Access 2010 OR EPINet US vi lc accdb 10 Note again the waming Some active content has been disabled Click for more details Once again click the lt Enable content gt box on the right Thiswaming may not appear 11 Tab to the login box Enterthe usemame data entry and password edit When you open Access 2010 OR EPINet US vl 1c accdb in the future you will go straight to the login box at Step 11 The yellow waming boxes will not appear To change the usemame and password see Adding New Usersand Changing User Passwords Curent case sensitive passwordsare Read access Name Read Only Password read Data entry access Name Data Entry Password edit The program Switchboard shown below isthe primary screen in EPINet FOR MICROSOFT ACCESS EXPOSURE PREVENTION P INFORMATION NETW Tabs Ribbons and Notes The customized tabsacrossthe top of the screen display allow you to navigate to the ribbons The rbbonsallow you to add new records edit records delete records find records navigate through the records sort filter records print forms and select
49. id Close Report A f4 wm Page Print Setup Blo and j Box Fluid Report edlestic id Sha bject Reports Post Exposure Reports Other Reports Graphs Tools Page Setup Print Single ir inc ident reports Summary Report Summary Report Follow up Testing Preventable Injury Report Needlestick and Sharp Object Log Report Log Report Email Health Care Worker Single incident reports show the data entered forone selected record The data it contains is identical to the orginal handwritten reporting form In orderto protect confidentiality names do not appear on the EPINet OR single Tsing incident report To identify the individual go to Select a Needle and Sharp Object Incident the Incident ID in the database E209 rebar crass ASOT S S398 Round Merry Go Julv22 2009 4 S397 K Jul 23 2009 1 S26 A pape Satin 4 1 Left click the lt Reports Graphs gt tab S304 Juv2s2000 3 393 S Jul28 2009 3 and lt Single Incident gt under either the Fs Juv21 2009 1 Blood and Body uid Reports S389 Jur20r2009 i S388 A w2 5 Needlestick and Sharp ObjectRepors 3 rps sen Nowts72000 1 or Post Exposure Reports ribbons to E ov c pee a view a single incident report Iae Auer d Preview Close 19 2 When the selection screen opens click to highlight the desired record then click lt Preview gt 3 After viewing the report click the lt Reports Graphs gt tab then lt Close Report on the Tools ribbon to retum to the Switchboard
50. ident ID can be a largernumberthan the number of recordsin the database The paper reporting forms have a blank forthe Facility ID and IncidentID numbers It isa good idea to note these numbers on the paper reporting form when you enter the record in the database If you hand write the EPINet OR generated IncidentID number on the paper reporting form when you enter that data into the system you can easily locate the record to make changes It isalso an easy way to track which reporting forms have been added to the database 17 Editing Records The first step in editing a pre existing record isto locate it Once it islocated tab to the desired boxand enter the revised information The new information will replace the prior information as soon as you leave the record A save button isnot needed There are two ways to locate a record The method to use dependson the information you have available about the record Note Post Exposure rec ords are located ina different manner from the others See the directions below for editing Post Exposure records Blood and Body Fluid A Search records using the Page Up Page Down buttons or the left MNeedlestick and Sharp Object or right arrow in the lower left comer of the screen post Expostte Modify Correct Data Forms 1 Left click the lt Forms gt tab and then either Blood and Body Huid gt or lt Needlestick and Sharp Object on the Modify Conect Data Forms ribbon 2 Pressthe Page Down key or
51. ing User Passwords Access 2010 EPINet OR allows administrators to manage user Add Delete Users accounts Users with Read Only and Data Entry logons cannot makes changes Administratorscan add and delete users change user security levels and change user passwords Change Password For routine review of the database and report generation use the Read only logon To enter data use the Data entry logon These two logonsar all you need to use Access 2010 EPINet OR You do not need the administrative level of sec urity to use Access 2010 EPINet OR Use it only to manage usernames security levels passwordsand to compact and repairthe database The username forthe administrator is Admin the alte password is epinet We do not recommend that i you change the administrator s user name or Password ines password If you change from the default password Security level Administrator x and forget it you will have to reinstall EPINet OR You can have multiple users with administrative New Delete level sec unty Save Cancel Close To add ordelete a user orto change a users security level click the Manage User Accounts gt tab then lt Add Delete Users gt To add a new user click on lt New gt The boxes will be empty fill in the username the password and select the level of security mp To delete a username click the down anow in the Use
52. ld and make the desired selection When adding a response to the table you may need to use the scroll down arrow to reach the bottom of the list Customizing Access 2010 EPINet OR Unauthonzed changes made to EPINet OR by the user often may result in data conuption and a database that no longer works Often the only fix isto start over with a fresh copy of EPINet OR Usually the existing data can be imported into the new version but not always EPINet OR doesallow some customization asdescribed next Adding customized questions EPINet OR has progra mmed in the ability forthe user to enter up to two new questions each for Blood and Body Fluid Exposures BBFs and Needlestick and Sharp Object Injuries Needlestic ks These questions can be the same for BBFs and Needlesticks or different depending on the needs of the facility ornetwork Enter these questions and responses during set up Add questionsto a specific Facility ID If all facilities are to use the same questions add them to each ID separately You may use abbreviations to fit the space allowed forthe question in the software but on the paper injury and exposure reporting forms that the injured exposed worker completes your questions can be much longer The questions added should be easy to understand and worded carefully to ensure conect interpretation Responses to the questionsadded are limited to a drop down list created by the user Responses can
53. les tab that appearsin the Navigation pane that opens on the left If Tables is not visible at the top of the Navigation pane left click the down arrow on the top right of the pane then left click lt Tables gt that appears following Alter by Group Follow steps 3 through 5 above Left click the down a row under lt View gt on the Views ribbon Left click lt Form View gt Close the Navigation pane UBWNE eo oN Problems importing Post Exposure data The naming of Post Exposure tableshaschanged over the life of EPINet OR so an adaption may be necessary when importing the data If you receive a message that the PostExposure table is missing close the current database 1 Open the database you are trying to import from using he admin usemame and epinet password 2 Left click the lt Home gt tab the down anow under View on the Views ribbon and lt Design View gt 3 Left click the Tables tab that appears in the Navigation pane that openson the left If Tables is not visible at the top of the Navigation pane left click the down amow on the top right of the pane then left click lt Tables gt that appears following Alter by Group Locate the table tbIPostExposure Tables are listed in alphabetical orden Right click the table and left click lt Copy gt Right click in the white area and left click lt Paste gt The Paste Table As box will open and you will be asked to provide a name forthe new
54. nd to standardize your data you define the responses that will appear in the drop down menus for the customizable questions Manufacturer Lista nd Medical Specialty You enter the responses that will appear in the drop down boxes during the Set up procedure Only items you entered in these tables during Set up will appearin the drop down boxesand you can only select items that appear in the drop down boxes when entering data After Set up you can update these user populated tables whenever needed If you elect not to enter allowed responses into the tables for any of these questions the program will still work corectly However if a table has not been st up you will NOTbe able to enterdata forthat question Manufacturer List The list of manufacturers of products with potential to cause blood or body fluid injuriesor exposures used in your facility The list you enter initially does not have to be exhaustive You can amend this list at any time OSHA requires that you collect this information about an injury when feasible The Manufacturer appears on the Needlestick and Sharp Object Summary Log report Expect that report to contain more injuries from manufacturers whose devicesare used most frequently in your facility Considerthe example where manufacturer A s device appears 10 times in the report and 500 of those devices were used and manufacturer B sdevice appear 5 timeson the report but only 50 of those devices were used In thisexample th
55. net password Left click the File tab Left click lt info gt along the left of the box then lt Compactand Repair gt Enterthe administrative usema me and password when asked Close the Navigation pane by left clicking the double arows pointing left lt lt UBWNE Handling Data conuption Ifa database ata facility in the network becomes conupt via virus or user enor use data from the administrator s database to replace the data lost The only data to be re entered manually by the userisfrom the last export to the administrator If the administrator s database hasbecome comupt recoverthe master database by re importing all histoncal data Data conuption can occuraccidentally or intentionally We have been able to recover data in most cases but in some cases users have had to reenterall data because of comuption This is why we recommend filing and retaining paper questionnaire formsand saving both the orginal and cleaned database files from each facility The first step in recovering a corupt database isto contact the Information Technology person who manages the shared network server where EPINet OR resides Default currency symbol and date format for Intemational users By default EPINet OR displays the USD currency symbol Most customized versions display the currency symbol for that country The date format is set in the Regional Settings menu of the computer s Control Panel When data isimported those setting
56. not be free fom text 11 In a network of facilities if the network wantsto add customized questions all facilities in the group must add the same customized questions on their paper report formsand in the software If the network does not choose to add questions each facility may decide whether ornot to add questions When this is the case responses to those questions exported to the administrator are meaningless Few facilities or networks add questions to EPINet OR Adding questionsisa three part process adding the questionsto the reporting forms to the data entry forms and setting up the responses for the questions Adding questions to paper reporting forms To add these additional questions to the report form completed by the injured exposed healthcare worker open and edit the appropriate Word file oR Uniform Needlestick and Sharp Object Injury doc OroOR Uniform Blood and Body Fluid doc lf you are unfamiliar with inserting check boxes into your documents simply copy a section from elsewhere in the file replace the words and adjust the tabs for proper alignment Be sure to save your work and save the original copy of the report form in a back up folder EPINet OR doesnot allow questionsto be added to Post Exposure Follow up Adding questions to the software data entry forms If you want to add questionsto the EPINet OR report forms some orall of the four blocks shown in Facility ID User Defined Labels under the Fo
57. nses Email Text 1 Open EPINet OR and login using the data entry usemame and edit password 2 Left click the lt Forms gt tab then lt Facility ID User Defined Labels gt on the Setup Database Tables ribbon 3 Left click lt amp ditID gt and overtype Unknown in the Enter Facility ID box with the assigned Facility ID number 4 Select the Type of Facility from the drop down menu 5 Left click the New Blank Record symbol in the lower left comer of the box to add additional Facility IDs 6 Left click lt Close gt It isnot necessary to click Save since Microsoft Accesssavesby default 7 Ifyou are not adding questions close the application by clicking the Xin the uppemot right comer If you are adding questions follow the stepsin the next section 8 Rename the file with a name unique to that fac ility such as H123 EPINet mdb If you wish too change the wording of the reminder email sent to the injured exposed healthcare worker do so at thistime You can also go in and change the wording at any time by following these steps Open EPINet OR and login using the data entry usemame and edit password Left click the lt Forms gt tab then lt Email text gt on the Email Textribbon In the box that opens OVERTYPE the pre existing message with the new one Click lt Close gt when done PWNE Setting up response choices Manufacturer List and Medical Specialty To make data entry simplerand faster a
58. nses Blood and Body Huid questions 1 Leftclick the lt Foms gt tab then BBF Table 1 BBF Added Question Responses Needlestick Added Question Responses Responses gt on the BBF Added Question Responses ribbon to enter the responsesto an added Blood and Body Fluid question 2 Type the allowed responses to the question Each time you press lt Enter gt a new line willappear Continue until all responses have been entered 3 Leftclick the Xin the upper right of the box to close it 4 Repeat steps 1 through 3 to enter responsesfora second added Blood and Body Fluid question thistime selecting lt BBF Table 2 Responses gt Needlestick and Sharp Object questions 1 Leftclick the lt Forms gt tab then lt Needlestick Table 1 Responses gt on the Needlestick Added Question Responses ribbon to enterthe responsesto an added Needlestick and Sharp Object Injury question 2 Type the allowed responses to the question Each time you press lt Enter gt a new line will appear Continue until all responses have been entered 3 Left click the Xin the upper right of the box to close it 4 Repeat seps 1 through 3 to enter responses fora second added Needlestick and Sharp Object Injury question this time selecting lt Needlestick Table 2 Responses gt Designing User Defined Fields Responses Some users have expressed interest in utilizing the EPINet OR feature to add questions One common question added is the known serostatus of the source for
59. number of injunesthat potentially could have been prevented by using safety devicesand proper disposal procedures If costs have been included in incident reporting the preventable injury report will report savings that would have occured if these injurieshad been prevented These reportsare generated by clicking on drop down menus consistent with the other reports and graphsin EPINet OR Hospitalshave reported greater interest in in service training sessions when department specific data is presented When the hospital sets up their EPINet OR database and include department identifications any summary report can be generated forany department by simply entering a date range and selecting the department on the drop down menus To make thisdata more attention grabbing these reports can be sent to Microsoft Excel and graphed using Excels extensive charting options Help I Can t See Any Records to Edit Over Incident 999 Someone changed the sort orderof the record display to a field other than Incident ID Open the database using he data entry usemame and edit password Left click the lt Forms gt tab then lt Needlestick and Sharp Object on the Modify C orrect Data Form ribbon Left click lt Home gt Double left click to highlight the number in the Incident ID field to the right of the S Left click lt Ascending gt on the Sort amp Filter ribbon Left click the lt Forms gt tab That should do it It will remain in that sort
60. onfidentiality if printed If you wish to add names you may export the report to Microsoft Word and add the namesthat match the incident ID s To generate a custom report the Limited Selection report option isavailable for Summary and Log reports You must enteran Incident date range in the mm dd yyyy format to generate these reports 1 Left click the lt Reports Graphs gt tab then lt Summary Report gt or lt Log Report gt on the Blood and Body uid Reports or the Needlestick and Sharp Object Reports ribbon 2 Left click lt Limited selection gt and enter the desired date range 3 Clickthe down arow and highlight a response for any question s you wish select Clicking the down a mow opensa drop down menu that displays the available responses for that question These responses match the responses available on the EPINet OR reporting form 4 C lic k the Preview Needlestick Summary Report jsn response Sp C Custom dates Showall Limited selection you want Incident dates from I tof to appear y Facility where incident occurred ALL in your Type facility where incident occurred ALL re p 0 rt 3 Surgical service ALL 5 Left C lic k 4a Was it an endoscopic laparascopic procedure ALL 5 What is the job category of the injured worker ALL lt Preview gt 5 Where did the injury occur ALL 8 For what purpose was the sharp item originally used ALL Note If yo u know 9 Did the injury oc
61. order until someone else comesalong and changesit You may want to go in and make sure that the Blood and Body Fluid Exposure Incident is sorted that wasaswell Since Post Exposure Incidents are selected from a list the sort function does not work on Post Exposure Follow up Change Hospital ID Once Post Exposure Follow up Data has been Entered On rare occasions you m ay need to change a Facility ID afterthe record hasbeen created One example is if you began entering injuriesand exposures into EPINet without first setting up 38 the Facility ID table In thiscase the program will default to a facility ID of Unknown There may be occasionsas well where the wrong Facility ID wasselected and you just need to change one ormore records You can go back and corect these Facility IDs at any time once you have entered them into the table Corect the Facility ID in the same way that you edit any other field in a record While it is easy to change the Facility ID from Unknown to the actual ID for Needlestick and BBF records it isnot so easy to corect Post Exposure Follow up records EPINet hasnot programmed in the ability to change Facility ID fora Post Exposure Follow up record once it iscreated It isa manual processto do so Open EPINet OR using the admin usemame and epinet password Left click the lt Home gt tab Left click the down a row under lt View gt on the Views ribbon Left click lt Design View gt Left click the Tab
62. ot display Macros left click the down arrow and select Macros under Filter by Group 5 Right click lt exporttable gt then left click lt Design View gt E Submacro export8BFConfidential 6 Ifthe sign to the left of Submacro E If Forms Switchboard SecurityLevel l lt gt 3 Then exportBBFC onfidential is a sign continue to A SetWamings the next step Otherwise left C lic k the sig n to Warnings On No minimize the submacro OpenQuery 7 Repeat foreach Submacro until all are Query Name ExportBBFConfidential minimized Notice that the signs have been View Datasheet replaced by signsto the left of each Data Mode Edit submacro name A ImportExportData 8 Re expand the submacro Export ace as BBFC onfidential by left clicking the sign Database Type Miosan Access 9 If necessary expand the line beginning If ee ee Gee ee Forms Switc hboard Sec urityLevel lt gt 3 Object Type Table Then by clicking the sign Source BBFConfidential 10 The line that starts with Database Name is the name and location of the export file Change CA EPiNet EPINetC onfidential mdb to the desired location Forexample J myfolder epinet mdb Note There may two Database Name lines for some submacros If so change both 11 Left click the sign to close this submacro 12 Repeat steps 5 through 10 until ALLof the submacroslisted below are changed to the new location exportNeedleC onfidential exportPosicC onfiden
63. ould be collected Remember to remove someone from the follow up report you must entera 0 zero fordaysto next follow up in the record By asking fora month ahead you have time to use the email feature to remind users to come in for follow up tests Since the Incident ID tests and follow up date will continue to appear on the report until you entera new follow up date you will always know if someone ispast due for follow up testing They will not get lost and slide off the radar Follow up email to healthcare worker After generating the Follow up Testing report you can generate emails to remind the healthcare workers to come in for follow up testing 1 Left click the lt Reports Graphs gt tab then lt Email Healthcare Worker gt on the Post Exposure Reports ribbon 2 Select the healthcare worker in the Email Patient dialog box that opens To see the list of all Post Exposure Follow up entries left click the down arrow in the box beside HCW Name The list contains the Incident ID healthcare worker sname injury exposure date and email address if entered If not entered in the record the name and email sections will be blank Left click to select the desired healthcare worker Enterthe email address if it is missing Left click lt Send Email gt uBR Ww 23 This generatesan email with the default text of the program orthe text you entered during program set up You may change the text for this email by simply overt
64. p section One added feature allows you to enterthe number of daysto the next follow up test for each test conducted and EPINet OR provides the next follow up date You can then generate a Follow up testing report that provides the information needed to use the new Email Healthcare Worker feature The email feature generates an email to remind a healthcare worker to retum for follow up testing To utilize this feature enter the of daysto next follow up each time you collect blood fora follow up test When the healthcare workercomes back in forthe follow up tests place a 0 beside the first previous test and place the new daysto next follow up with the new test results 1 Positive 2 Negative Be sure to entera 0 in the time span forthe previous follow up test when you enter new days to follow up testing Each time the healthcare worker retums for follow up change the previous follow up time span to 0 and enter the new daysto next follow up beside the most recently completed follow up test When all follow ups have been completed ORto remove someone from the report enter 0 zero forall of the days to next follow up fields The follow up information will appearon the Post Exposure Follow up Testing report until all tests have zeroesasthe daysto next follow up 16 Tips and handy notes for entering new records The only field required to create a record in EPINet OR isthe date If after entering the date yo
65. ponses entered in the way described above will be the only responses accepted when entering a record into EPINet The responses you enter will appear in alphabetical order in the drop down menus for the designated question If you want the responsesto appearin a particular order precede the response with the order number For example if the responses you entered are the days of the week according to the default Friday will appear first in the drop down menu Monday willappearsecond and Saturday will appearthird To have them appear in day of the week order enterthe responses 1 Sunday 2 Monday 3 Tuesday etc Adding deleting orchanging itemsin a userpopulated table will not alterdata already entered in the database Forexample deleting Company X from the Manufacturer s List table doesnot affect any records where you selected Company X asthe manufacturer You will not be able to select Company X asa manufacturer in the future unless you again add it to the Manufacturer s table DATA ENTRY NOTE In the future there isno need to leave the data entry form to adda category to the table Simply move the cursorto anotherfield then click the lt Forms gt tab and select the Setup Database Tables ribbon Add the entry and click the X in the upper right comer of the box to close it EPINet OR saves the information you enter automatically and updates the list When you retum to the record entry screen move the cursor back to the appropriate fie
66. r Name OK username boxand highlight the name to delete Click lt Delete gt You must confirm that you want to Old Password a delete the record New Password To change user passwords click the Manage User Accounts gt tab then lt Change Password gt Enterthe verity 29 username the old password new password then confirm the new password by entering it again Help If you have problems or questions please contact Ginger Parker at the Intemational Health Care Worker Safety Center E mail ginger parker intemationalsafetyc enter org 30 Appendix 1 Importing Data into a New Version of Access 2010 EPiNet OR When importing data the first step is to create a folder with back up program and data files of your existing EPiNet OR version in another location on yourcomputer This is essential to prevent an accidental overwnte of existing data ONCE ALES HAVE BEEN OVERVVRITTEN THERE IS NO WAY TO REC OVER THE ORIGINAL ALES In order fordata import to be successful the previous version of EPINet OR must be place onthe C drive ina folder called epinet and named epinet mdb c epinet epinet mdb It must be named using the mdb file type even if the program isthe Access 2010 version and hasan accdb file type Locate the existing version of EPINet OR Do not open it It may be on the C drive but will probably be ona shared network drive If you use a shortcut to open EPINet OR you
67. rmstab on the Setup Database Tables ribbon need to be completed 1 Open EPINet OR using the data entry usema me and edit password 2 Left click the lt Forms gt tab then Facility ID User Defined Labels gt on the Setup Database Tables ribbon 3 Left click lt EditID gt 4 Using the right pointing arrow P in the lower left of the box scroll to the Facility ID for the question to be added 5 Tab to the first block beside BBF 1 that says User Defined Field 1 to enter the first Blood and Body Fluid Exposure question you are adding 6 Type the new question 7 Press lt Enter gt If you have a second question to add go to the block beside BBF 2 that says User Defined Field 2 8 Repeat steps 3 through 5 selecting Needlestick 1 and 2 to add Needlestick and Sharp Object Injury questions 9 Left click lt Close gt to close the box It isnot necessary to click Save since Microsoft Access saves by default 10 Follow the steps in the next section to enter the allowed responses forthe added questions 11 Close the Navigation pane if it appears by left clicking the double arrows pointing left lt lt The questions added only apply to the Facility ID displayed at the time of creation Repeat the above stepsto add questions to additional Facility IDs 12 Entering response c hoic es foradded BBF Table 1 Responses Needlestick Table 1 Responses questions BBF Table 2 Responses Needlestick Table 2 Respo
68. rp Object Injury Log These reports provide information on a case by case basis For this report you can select ALL records the records within a specified date range orjus the records that meet the 20 criteria you select from drop down menus You must entera date range in the format mm dd yyyy when you select Custom dates or Limited selection 1 Click the lt Reports Graphs gt tab then lt log Report on the Blood and Body Fuid Reports or the Needlestick and Sharp Object Reports ribbon to generate these reports 2 Left click either Preview with Word desc riptions gt or Preview the Report by Numeric Values gt to view the report with either text of the response visible or only the number of the response visible For example on the Numeric values report J ob category Nurse willappearasthe number 4 If you select the Word option the word Nurse will appear Recordson these reports display beginning with the most recent injury exposure date going back in time You may view this report where either the text of the responses or the numeric values of the responses in EPINet OR Click lt Preview report with Word descriptions gt for the Needlestick and Sharp Object Injury Log to generate a report that meets the OSHA 300 report criteria The log reports include the incident description text provided by the injured healthcare worker Incident ID s not healthcare worker names appear on these reports to prevent unwitting breach of c
69. rthe Email field when upgrading from an Access 2003 version of EPINet OR to the Access 2010 version 1 Left click the lt mport Export Menu gt tab 2 Click lt Needlestick and Sharp Object gt on the ImportTables ribbon Upon successful import of the data the Facility ID User defined Fields box will open 3 Left click lt Close gt Note Before you see the Facility ID User defined Fields box you may see an Enter Parameter Value box Click lt OK gt without entering a value This may occurseveral times The Enter Parameter Value box appearseach time a field isimported that doesnot contain any values The most common reason to see this box is when you have not entered healthcare worker namesin your database You will see this box forthe Email field when upgrading from an Access 2003 version of EPINet OR to the Access 2010 version Before importing the Post Exposure Follow up data you need to determine how you entered your Post Exposure data into your old version of EPINet OR If you entered responsesas Positive Negative Not tested click lt Special Post Exposure gt on the Import Post Exposure ribbon If you entered responses as 1 Positive 2 Negative and 3 Not tested click Post Exposure gt on the Import Post Exposure ribbon Upon the successful import of yourdata the Facility ID User defined Fields box will open Left click lt Close gt Before you see the Facility ID User defined Fields box yo
70. s are used Changing these settings after entering or importing data doesnot change the existing data Therefore if you plan to use iton computersin different countnes confirm that the Regional Settings are appropriate before using EPINet OR Always keep an unused version of EPINet OR saved in an easily identified but secure location asa backup Conect time format when exporting to Excel There isno way forusto specify the time format when we export to Excel It currently goesto Excel with a date of 1 0 1900 labeled Timelncident If you expand the column width time still doesnot appear Select all ofthe cells of the Timelncident column while in Excel and select the desired time format Define Preventable Injuries Report There isan algorithm that determines whether an injury isconsidered preventable it includes a all injuries from UNNEC ESSARY NEEDLES are preventable by substituting needleless devices including needles used to connect oraccessportson IV lines and all fing erstic k heelstic k LANC ET injuries are also considered preventable by using retracting lancets b of remaining injures those occuming AFTER USE of a device when a protective feature could shield the sharp are considered preventable 36 Injuries not counted as preventable in the algorithm although they may be preventable in other ways are injuriescaused by necessary needles that occur DURING performance ofa procedure before a safet
71. s the range you wish to graph The columns contain the responsesto the questions in the order they appearin the report Since several questions in EPINet OR have Yes No Unknown asthe allowed responses we advise you to print a copy of the report to assist you in identifying the corect range to graph Exporting Data H h a m h 4 ft Export data in two ways Export the raw data to another Accessdatabase orto Microso ate el thro ug h Home create External Data Database Tools Forms Reports Graphs Import Export About EPINet Selec tio ns und er Blood and Body Fluid Facility Information Blood and Body Fluid Blood and Body Fluid Blood and Body Fluid the Needlestick and Sharp Object All Other Tables Needlestick and Sharp Object Needlestick and Sharp Object Needlestick and Sharp Object j P ODJ Import Export Post Exposure Post Exposure Post Exposure Post Exposure ta b Import Tab es Import Facility Informat on Export with Names Removed Export with Names Export To Excel You can export the Summary reports to Microsoft Excel or Microsoft Word files See the Printing Reports section for instructions to export report data Exporting the Summary Reports makes it easy to enhance the format of the reported data Exporting raw data to another Access database You may select from two ribbons Export with Names Removed or Export with Names 27 1 Underthe Import Exporttab double left click the desired data source lt Blood and Bo
72. sheet created You may also have the option of selecting a File format Excel 97 may be your only option Click the option to Open the designation file afterthe export operation iscomplete You have the option of writing over or providing a new name if a file already exists with the same name at that location The default name of the worksheet created is rptBBFSummary xls Of rptNeedleSummary xls Sending the reportto a txt file N Generate the report Left click the lt Print Preview gt tab and then double click lt Text on the Data ribbon Select the name and destination for your report You have the same report optionsas in method one Select Windows Default in the box that opens 25 The report generated in thismannerisa txt file and loses the EPINet OR fomatting For these printing options Microsoft Access is still open but in the background Word or Excel is operating in the foreground Once you close Microsoft Word or Microsoft Excel you retum to the EPINet OR Switchboard While Word and Excel are open you have the full range of commands for those programsavailable and may make any changesor calculations you choose To retum to EPINet OR simply close the Word Excel or txt file There isno need to save the export steps To retum to the Main EPINet OR screen the Switchboard click the lt Reports Graphs gt tab then lt Close Report gt on the Tools ribbon Creating Graphs G ra ph Options within Access
73. sisjust an example The prefix letters make them appearin an order that is logical Of course not all combinations make be needed Since the HCW doesnot complete this part and doesnot need to know the codes it is simple forthe data entry person or coder to have a cheat sheet taped inside the folderthat contains the blank forms or the instructions Entering New Records Enter Blood and Body Huid Exposure or Needlestick and Sharp Object Injury record 1 Open EPINet OR using the data entry usemame and edit gjood and Body Fluid password 2 Clickthe lt Forms gt tab and select Blood and Body Huid gt or lt Needlestick and Sharp Object gt on the Data Entry Forms ribbon Directions for entering and updating Post Exposure Data Entry Earms Follow up information are below Needlestick and Sharp Object Post Exposure A blank record willappearand the cursor will be in the box for Last Name Type the last name and either pressthe tab key to go to the next field First Name or point and click with the mouse Type the first name and pressthe tab key to go to the Facility ID box If youdo not wish to enternames pressthe tab key twice oruse the mouse to go directly to the Facility ID box Ifthe correct Facility ID appears simply tab again If not click the down anow in the box and select it from the list displayed In orderto entera Facility ID it must appear in the drop down menu You established thisdrop down menu during Set up o
74. stitutes preventable injuries isincluded at the top of the report 1 Click the lt Reports Graphs gt tab then lt Preventable Injury Report gt on the Other Reports ribbon 2 Enterthe beginning and ending date in the Preventable Injury Dates box that appears The date format is mm dd yyyy 3 Click lt Preview gt to generate the report The report will contain the potentially preventable injury recordsin yourdatabase that occumned in the time range you specified Thisisa conservative estimate since the responses to questions where you entered Other describe cannot be evaluated and are not included in the report Post Exposure Follow up hasdifferent reporting options There is no Single Incident Summary report for Post Exposure Follow up Each post exposure entry is Follow up Testing linked by Incident IDto a Blood and Body Fluid Exposure record orto a Email Health Care Worker Needlestick and Sharp Object Injury record Post Exposure Reports 1 Left click the lt Reports Graphs gt tab then lt Single Incident gt on the Post Exposure Reports ribbon 2 Clickto highlight and select the desired incident 3 Left click lt Preview gt 22 Post Exposure Follow up Testing report This report providesa list of follow up tests required with the date the blood samples should be collected again for each healthcare worker being followed up Entriesare listed by Incident ID The report also displaysthe Hospital ID and Incident date foreach
75. sues saexeaseaulanseus savas anaieusseanesverteaneeeecd 19 SUNS incident repor S ron e a E ea E E 19 Summary custom reportS eeeeeeeeeseseseseeesessssestettertnertrtrtstsnsnsnsntntststststetetttnntnenentstnsnononentnt tetett 20 Standard Summary TPO ie esseet eean e a E EEEE E E E ESES 20 Blood and Body Fluid Exposure Log Needlestick and Sharp Object Injury Log 20 Sharp Object by e Te oa ae 9 2 qi iaemne camera er aan ert ae aster ae ar ee rar a anon ee ere a 22 Preve table NY PET acess asc ecatd cacacaaceus akc cevedeitee nls ceanseun a a eE dea E eaa Ca a aa aE E 22 Post Exposure Follow up Testing report score scccssits eects ceactyscasdelesteestersacgeteddetionaanpeteaveienes 23 Follow up email to healthcare worker ssssssssssssssssssssrsrsreresrsrsrsrsrsnsnsntsssssrsrsrenenennnenrsrsrsnenes 23 Printing Report S ys sisciccsisceisaasdensencacaatersncessundsxuasdaqeuasaasvsnsstnanexsvanssenovatuntnasedodesvansdunvencenaeavenstenss 24 Sending the report to Microsoft Word ssssssssssssssssssssrsrsrenrnesrsrsrsrsnsnsnsntststsnsrsrentnnnnnenrnrsnsnsnnnt 25 2 Sending the report to Microsoft EXCel o g is cisaciccihecisheens ee eeedso anced glebe aden eeapetene 25 Sending the report to a txt file caso okG8 es sc zeeeso chap ohedaphyed esas eave tnosayotchaver exo vasbek eeaneobeawmeaseccaan shetoers 25 Creating Graphs eeen eni Sac waa dense dentin cis eea Kae aaen Eea a eas vo ete od emcee deco amore eee 26 Graph
76. sure record or Needlestick and Sharp Object Injury record hasbeen entered BBF i Date 0 Close amp Needlestick E mail Facility ID Adding post exposure follow up records 1 Open EPINet OR using the data entry usemame and edit password 2 Click the lt Forms gt tab and select lt Post Exposure gt on the Data Enty Forms ribbon 3 Inthe upper left comer of the post exposure fom select the conect data source to locate the record of the orginal incident The data source is either BBF or Needlestick 4 Afterclicking on the data source thatis the round BBF or Needlestick button the drop down boxon the right will contain the list of Needlestick or BBF records 5 Click the down arrow in the empty box to the right then scroll to the comect incident and left click to select it The recordsappearin a list in alphabetical order by last name 6 Respond to the Post Exposure Follow up questions leaving blank any that you do not know You can leave blank orclick 3 Not Tested forany test you have not administered There will be many blank fields in Post Exposure Follow up If you entered the orginal incident asa blood and body fluid BBF exposure select BBF when starting the new Post Exposure Follow up record Otherwise click Needlestick There is no match in the drop down list if you click the Needlestick button fora BBF record The Access 2010 version of EPINet OR hasan enhanced Post Exposure Follow u
77. t click the lt Home gt tab then click lt Find gt the binoculars on the Find ribbon 5 Fillin the appropriate information in the Find and Replace box then click Jnd Next If you search on the Last name or Date rather Find and Replace S LE e than Incident ID you may need to click the Find Replace lt Find Next gt button several timesto locate the Find What ca desired record The record you are seking should eventually appear You can also search a a on other fields using the same procedure J sex at l Match Case v Search Fields As Formatted Review the choicesin the Match box If you are seeking a specific IncidentID you want to match the whole field If you are unsure of the 18 spelling of the name select lt Any Part of Field gt or lt Startof FReld gt forthe Match box Highlight the entire search field before clicking the binoculars Be sure you enter the search words in the Find What box not in the Name Date or Incident ID field in the actual record If you accidentally type in the field of the actual record whatever you type into the field is saved automatically asthe corect value forthat boxand you will have unintentionally edited a record When editing recordsin the Post Exposure data file you can only search in the list box that contains Incident ID Name Date and Facilit 1 Click the lt Forms gt tab then Post z Top Tae eee Exposure gt on the Modify Conect s276
78. table tbIPostExposure Tables are listed in alphabetical order 5 Right click the table and left click lt Copy gt 6 Right clickin the white area and left click lt Paste gt 7 The Paste Table As box will open and you will be asked to provide a name forthe new table Type PostExposure no spaces in the box 8 Ensure that Stucture and Data is selected then left click lt OK gt 9 Close the database 10 Reopen the new database and follow the steps to import Post Exposure data as before Note You could also run into the situation where the import is looking for PostExposure instead of tbIPostExposure If that isthe case follow the steps above this time copying and renaming tbIPostExposure to Post Exposure Using EPINet ina Network See the EPINet Network Administrator Manual fora complete description of EPINet s use within a network 44 Appendix 3 How to Calculate Needlestick Rates Re printed with permission from Advances in Exposure Prevention Vol 1 No 6 We are often asked the question What is the conect way to calculate needlestick rates In fact there is more than one conect way to calculate these rates depending on the types of comparisons you want to make Three different methods for calculating rates are presented below The data you collect on reported needlestick incidents can be used to calculate rates that will allow some important comparisonsto be made among different hospit
79. test Namesdo not appearon the report to protect the confidentiality of the healthcare worker if the report is printed This report is useful to get an idea of the upcoming tests but its primary use isto provide the information needed to send follow up reminder emails 1 Click the lt Reports Graphs gt tab and e OOO O OOOO 2 click Follow up Testing gt on the Post Exposure Reports ribbon to bring up Custom dates the dialog box used to select the ASE options for this report 2 Click Custom Dates or Show allin the PE Follow up Test box that appears 3 Either A Click lt Showall gt then View all gt to display all upcoming currently due orpast due follow up tests and datesthat have been entered in Post Exposure View all Close 4 Or B to generate a report with only currently and past due tests click lt C ustom dates gt select the month and click lt View specific month gt The report generated will have all past due or upcoming tests through the month selected Forexample if it is March and you want to generate the list people to contact the test s to be administered and the date the test s should be administered click lt C ustom dates gt select April in the drop down box and click lt View specific month gt The report generated gives you the teststo administer from the beginning of the records through then end of April This gives you time to contact the healthcare worker before the actual date the blood sh
80. the EPINet menu bar 9 Unclick the one that says MISSING You may need to scroll up ordown to locate the one that says missing 10 Click lt OK gt 11 Click lt Save gt if queried 12 Left click the white X in the red boxat the far right of this screen that contains the form s code to close it orclick the bottom X if two Xs are displayed in the upper right of the screen 13 Close EPINet by clicking the X in the upper right of the screen then re open EPINet NOURW These dll and DAO MDAC problemsseem to occurin countnes outside the US do not know why NOTE If you clic k DISABLE POSSIBLE UNSAFE CODE the first time a database isopened it will never work in Access 2007 or 2010 In 2007 you may be asked this question each time you open the database but in 2010 only the first time you open it Change default IMPORT file location from C EPINet EPINet OR defaults to importing data from the C drive Thisis not a problem if the user never needsto import data However asan administrator you expect to receive data from the 41 user ona periodic basis so if you cannot write to your C drive you must make modifications to allow data import from another location Changing the export location isa separate process 1 Open EPINet OR using the admin usemame and epinet password 2 Left click the lt Home gt tab 3 Left click the down arrow under View on the Views ribbon then Design View gt 4 If M
81. the US Each upgrade hasallowed the userto import data from earlier versions of the application The user should not make changesto EPINet OR Even minor changescan conupt the database It isnot necessary to enterdata immediately after collection following an injury or exposure Initiating post exposure prophylaxis is time critical but entering the data into the database is not That said timely entry of data isnecessary before post exposure follow up tracking can be fully realized Since Post Exposure Follow up records link to a BBF ora Needlestick inc ident the injury or exposure record must exist before creating the comesponding post exposure follow up record Installing the application on a secure network drive ensures data secunty and the regular performance of routine back ups It prevents total loss of data if the users computer crashes and the loss of confidentiality if an unauthorized user opens EPINet OR when is located on the C drive When installed on a network drive there isthe added advantage that users from multiple locations can access the application Facilities receive EPINet OR astwo files attached to an email 1 the manual for installation and use and 2 a compressed file containing six files We recommend opening and reviewing the manual before unzipping the compressed file The manual contains step by step instructions for setting up the application for first use as well as for its continued use The compresse
82. the reports and graphs you need Clicking the X in the uppernght comer of the screen closes EPINet Left clicking isthe default click in this manual Date format defaults to that set in the computer s regional settings In the US it defaults to mm dd yyyy In other countries the default is often dd mm yyyy Setting up EPiNet OR this will speed data entry later If you are upgrading from an earier version of EPINet please delay following the instructions for this section until you have reviewed Appendix 1 Importing Data into Access 2010 EPINet OR During Set up you will need to designate the Facility ID and Facility Type and the default text for Post Exposure Follow up reminder email You can add up to two additional questions on thistab if you choose to do so If you choose to add questions this is also the tab where you enterthe responses allowed forthe new questions You can begin entering data and using EPINet OR before completing these set up procedures however the data forthat incident will be incomplete Should you later realize that you need these data it isa cumbersome processto edit each record EPINet OR automatically generatesan Incident ID number for each record If you delete a record afterthe number has been assigned that Incident ID numberis not re used for another record and will not appearagain The data isnot saved Designating Facility ID and Facility Type Facility ID The Facility ID appearson
83. tial exportMaste C onfidential expornBBFFull exportNeedle Full exportPostFull exportMaste Full expornBBFExcel exportNeedleExcel exportPostExc el 13 Close the macro by left clicking the small x below the larger X in the upper right of the screen Click lt Yes gt when asked about saving the changes 14 Close the Navigation pane by left clicking the double left pointing a rows lt lt 15 Go backto the upper left and again click the down arrow under lt View gt on the Views ribbon on the Home tab 16 Left click lt Form View gt Note Submac ros exportMasterC onfidential and exportMasterFull may be missing from the list for this version Problems importing Post Exposure data The naming of Post Exposure tableshaschanged over the life of EPINet OR so an adaption may be necessary when importing the data If you receive a message that the PostExposure or tbiPostExposure table is missing close the curent database 43 1 Open the database you are trying to import from using he admin usemame and epinet password 2 Left click the lt Home gt tab the down arow under View on the Views ribbon and lt Design View gt 3 Leftclick the Tables tab that appears in the Navigation pane that openson the left If Tables is not visible at the top of the Navigation pane left click the down amow on the top right of the pane then left click lt Iables gt that appears following Filter by Group 4 Locate the
84. u close the record orgo to anotherrecord using the arrow keysin the lower left comerthe record EPINet OR saves what exists of that record Thisisthe case even if all the other fields are blank The next time you open EPINet OR you can utilize this blank record with the edit feature If you enter data in ANY field even if you subsequently delete what you put in that field but have NOTentered a valid date and try to close the record you receive the following waming You must entera date in the x x Date field Click lt OK gt to close the wa ming box then entera valid date If you opened the new record in erorclick lt OK gt to close the waming boxand lt Yes gt in the You can t save this record at this time box If you have tabbed to the Incident date box you cannot leave the box without entering a valid date orclosing the program Press lt Close gt at the top of the form Click lt End gt in the Invalid use of Null emor box Click the large X in the upper night comer of the EPINet OR screen then click lt END gt in the two Invalid use of Null boxes that appear This closes EPINet OR If you do not have the injury date for example if the person completing the report form wrote a birth date instead of an injury exposure date choose a fictitious date that you will always use for such cases We recommend 01 01 1990 Once you obtain the comect date from the healthcare worker you have a great search
85. u may see an Enter Parameter Value box Click lt OK gt without entering a value This may occur many times depending on the version of you old EPINet OR The Enter Parameter Value box appears each time a field isimported that doesnot contain any values A number of new fields were added to Post Exposure Follow up in the lat 3 yearsand these may appear blank in this import routine Open a Needlestick and Sharp Object Blood and Body Fluid and Post Exposure Follow up record to confirm the data hasbeen imported If not contact EPINet tech support at ginger parker intemationalsafetyc enter org Do NOTattempt to import the Blood and Body Fluid Needlestick and Sharp Object or Post Exposure Follow up data a second time If allof yourdata hasbeen imported retum to the epinet folderon the C drive and delete the epinet mdb file By deleting epinet mdb you cannot inadvertently re import the data and create duplicate records If only a portion of yourdata wasimported you were not importing from your most recent version of EPINet OR In thiscase you need to locate the most recently used EPINet OR file and start over You start over by deleting the epinet mdb file COPYING the conect file to the C drive place it in the epinet folderand rename it epinet mdb Unzip a new version of EPINet OR and repeat the import steps from the beginning There could be several reasonsthat no data wasimported The epinet mdb file coul
86. u want to see and tab down to the line saying Job category left click the small down arrow on the right side of the box to display EPINet OR allowed responses to that question and Left click 4 Nurse The report will soon appearand you have the usual options of viewing or printing the report orsending the report to Microsoft Excel or 37 Word Youcan have multiple selectionsin with the Limited Selection report such asJ ob category Where injury occured and Device to see a report of the incidents meeting the criteria selected Another EPINet OR report isthe Log report You have the many of the same selection criteria asabove but instead of summanzing the data you get a listing of the information in the recordsthat meet the criteria Selecting this report with Word descriptions meets the criteria forthe OSHA 300 log The log reports are especially helpful when generating reports for departments job categories devices and procedures because these reports include the written description of how each incident occured with each incident Graphs of the counts of responsesto questionsare available with drop down menus similar to those of the summary reports These graphs and reports can be created for needlestick and sharp object injunesor blood and body fluid exposures Special reports of the count of injunes by a device all hollow bore needle devices orall devicesare available A preventable injury report shows the
87. usema me and edit password Left click the lt Forms gt tab and either Blood and Body Huid gt lt Needlestick and Sharp Object or Post Exposure gt on the Modify Conect Data Forms ribbon Locate the duplicate record to delete and view it on the screen Left click the lt Home gt tab on the menu bar Left click the down arrow beside Delete on the Records ribbon Left click lt Delete record gt WHILE THAT REC ORD IS VISIBLE ON YOUR SCREEN When asked confirm the delete by clicking lt Yes gt N NauBKW Displaying File Types in Folders If file tyoesdo not display change the computer settings to show file types before renaming the database to prevent the txt mdb ortxt accdb problem 1 Go to the CA epinet folder left click lt View gt then lt Details gt 2 Follow this by going back to the menu barand left clicking lt Tools gt Folder Options gt and the View tab If View doesnot appearon the menu bar left click lt Organize gt then lt Folderand search options gt then the View tab 3 Uncheck Hide extensions for known file types Click lt Apply gt Compactand Repair the Database As you use EPINet OR and when you import data from facilities within the network the database growsin size You will need to compact your database Perform this task monthly if you use the Post Exposure Email notification feature frequently Otherwise do it every year orso 35 Open EPINet OR using the admin usemame and epi
88. xclusive from those causing sharps injuries They include vehicles of exposure specimen containers blood filled tubing contaminated surgical drapes etc and bamiersto exposure gloves goggles gowns etc These are check all that apply type of questions which are really a list of yes no items Because the nature of the descriptive information isso different there isnot a common set of questions that can meaningfully capture both types of events Therefore it is important forthe reporting healthcare worker HCW to provide the information that is specific to the type of exposure We separated these two formsto make it simpler for the HCW who fills out the form This way the HCW fillsout a shorterform and can make no mistake in filling out the wrong section of the form If both forms are merged into one then skip fields must be added that tell the HCW if you had a sham injury then skip to question X but if you had a body fluid exposure answer questions X to X We and others have tried this Every time there hasbeen significant data lost when HCWs skip to the wrong fieldsand try to describe a sharp injury in the body fluid section or vice versa 34 By merging the two formsinto a single form it would be a longer more complicated form for the HCW which would result in lost data because of problems in filling out the formsconectly The two separate formsare simplerand easier for the HCW to fill out and easier for the data entry p
89. y feature could be activated Why notto ask Shift Worked question Original research protocol in 1986 included about how many hours did you work and how many daysdid you work before your injury and what shift were you working This wasto look for surogate factors for fatigue It also asked were you feeling sick ortired or rushed or stressed at the time of injury These questions yielded little useful information Most healthcare workers said they were stressed or tired or rushed and what can you compare that to Are they more tired or less tired than others If they worked the night shift what doesthat mean You have to geta denominatorto compare how many nightshift workers got injured compared to the numbers of total night shift workers on the same shift the injuries occured and then you have to compare that to the day shift injunes and the total of day shift workers on the shifts that the injuries occured If you find any difference in shifts it is likely to be a small one and then what do you do with that information Isthere a prevention strategy that corespondsto different shifts You would not really know what factorthe difference isdue to it might not be fatigue since you are not directly measuring fatigue These questionsseem like a good idea when you first think of them but they do not yield information that you can use forany practical purpose Many EPiNet OR Users Ask How Can I Present EPiINet O
90. yping it You may also change the email address orenterit if not entered when creating the record NOTE You do not change the original record by entering an email address here The email address entered here is valid only for this email To enterthe email addressin the record so it appearson future emails you must edit the relevant Post Exposure record Editing the original Blood and Body Fluid Exposure or Needlestick and Sharp Object Injury record will not update the Post Exposure record Establishing the email text ispart of the program setup procedure You may go in and change the text at any time by clicking on the lt Forms gt tab then lt Email text gt on the Email Text ribbon If you use the Email Healthcare Worker feature the database will become rather large very quickly You may need to periodically open EPINet OR to compact and repairthe database Open EPINet OR with the username Admin and password epinet Click the lt File gt tab then lt Compactand Repair gt When asked enterthat usemame and password again Close EPINet OR then re open EPINet OR using your standard usema me and password Printing Reports You can send orexport reportsto a printer Microsoft Word or Excel ora txt document If you have Adobe Acrobat installed you have the option of printing to a pdf file Print Preview Acrobat Forms Reports Graphs Import Export About EPINet Manage User Accounts Method one Print io LE inns 1 Gen

EPINet-OR Manual - International Safety Center

Contents

Download Pdf Manuals

Related Search

Related Contents