Home

Epi-Centre User Manual

1. Laboratory Technician in place C Yes Trained in RNTCP Yes Data Entry Operator Yes Trained in EPI Centre Yes Driver C Yes a 15 In the table format data entry screen like the one shown in Fig 21 cursor can be moved up down left and right to any desired cell by pressing the corresponding arrow keys from the keyboard The Enter key from the keyboard will take the cursor to the cell in the adjacent column If the cell pointer is already in last column then the cell pointer will move to the cell in the first column of the next row Alternatively clicking by mouse on any cell will move the cell pointer to the cell which is being clicked Programme Management District Page 2 of 11 Quarterly Report on Programme Management and Logistics District Level State Pra District Quarter 2 Year 2008 Supervisory activities by the staff of the DTC DTO and second MO DTC T f Unit Number of 1 in the Number of 2 participating in the Number of these 3 visited Mae uf District RNTCP during quarter by 2 MOfs DTC Tuberculosis Units 1 Designated MCs PHIs other than DMCs TB Hospital Medical college Other Govt hospitals Treatment Observation Centres DOT Non governmental organization health Private sector hospital Nursing home Fig 21 Grey colored cells are barred for data entry either they are self calculated fields Fig 22 or no values are expected
2. e e The following screen of main menu is displayed Fig 14 Epi Centre 2006 District level m Data Entry Send Receive Check Output Utilities Hap Quit Quit from Epi Centre 2006 Fig 14 e To quit Epi Centre click on Quit option in the main menu as shown in Fig 14 Alternatively you can quit Epi centre by clicking on the Close button X but for this you have to additionally confirm by clicking on Yes button has shown below in Fig 15 This protection is given to prevent users from accidentally closing Epi Centre actually when they wanted to close some other application or some other child window of Epi Centre But on clicking the Quit option from the main menu the additional confirmation is not required as it is assumed that the user has purposefully clicked on the quit button to close Epi Centre ms y lar i ara o Pb wipid Iwi i T BELL IELLULTSETLIBE AA Eternia Meret ar eceeecxe a IN 7T M Chapter 2 Data Entry The Data Entry option under main menu allows a user to enter modify all quarterly aggregated reports and also allows users to add update state district and TU information The options under this are Case Finding TU wise Sputum Conversion TU wise Treatment Outcome TU wise Programme Management TU District District Level reporting only available to the National level users Master Maintenance State D
3. Epi Centre for Windows User Manual Epi C entre for Windows User Manual Contents introducing EpEGentre cass ipid invo ra dab LC C e v c LR E D E E Edna V Reatires an neo aerea V Who should re d this DOOK o5 stria ordei tain A atto ma hase dto veda ee pu o sud rb dee ca ia V A icu poo and dpcun N toit un botes ise E dates even Dead boven Gergana babu snee ELO ete to Doce does vi Recommended Software and Hardware requirements cccccccccceccsesesnsececeeceesesnceececcesseseaeeeeeseeseeseaeeeeseesseeesaaaes vi vin ic D vi PVA WA mE vi MA aene comete DE LA Md M E E E iL Ex E ES vi Chapter Instalador a HR e ro rH v o Getme ota loo ostendit cara hc doles ond S t dedico tu te bU or d ope et Are ac cap o a ad artis 5 Chapter 2 Data ENUY ida Quarterly Reports in various formats CF SC RT PM D o oooccccnnnnonononcnnnnonononnnnnononnnnnononnnnncnnnnnnnnonnnncnnnonnnnnnnnncnnnos 10 Addins a NE We TOC OL eso etes NOD UIS UN C UA dep LEN Ic De CL o ruso adu cest EA et du sudes p UR 10 IModirysitis the existe Te CODO Sto eel ooo ot oe O a cob ba Sane soe be Wah tii etos stud cC 12 Cursor movements in Programme Mana iii 15 Master Vai DIO fi E cco omis edes ctv debo cde eed red D elu ale EE os el Ra MM pg a Or o M Dir gd Io pua Lan tic oe 17 District wise and TU wise Projected populatiON oooococcccnonononocnnnnnnnonannonononononononon
4. READ Mails are shown in regular font style in the Email summary list window e Contents of the mail can be read in E mail contents reading pane as shown in Fig 34 with header contents and message displayed separately as shown in Fig 35 e By default the emails are sorted in descending order of date i e the most recent email will be on the top of the list You can change the sorting pattern by clicking on the column headings From Subject Date Received A single click on any column heading will sort the list in the reverse order from its current sort order i e if 1t was in ascending order then it will be arranged in descending order e To upload the data from an email you have to first click on the email for which the data is to be uploaded in the Email summary list The content of the email message is displayed in the reading pane and the Upload data button gets enabled 28 Click on the Upload data button to start uploading the data Fig 36 Epi Centre reads the contents of the email attachment and then adds it to its own database if it didn t find a previous entry of the same record else it updates the existing record w Retrieve Email Data Show mail with subject Both GR amp RA mails Y AllMails 350 C Unread Mails 278 C Read Mails 72 DTO BARAN QR New and updated quarterly data from Ep 2006 12 29 Fri 9 DTO QR New and updated quarterly data from E 2006 12 30 Sat 1 dto
5. Retrieve data for E mail Status of requested approvals Additional E mail features Customize currently disabled Failed sending E mails o Resend data o Clear last E mail history Send data from State to District currently disabled Send data from Central to State District currently disabled According to the location of the installation of Epi Centre 1 e National State District Consultants the menu options vary for this category For ex if Epi Centre is installed in the National or Consultants computer then first 4 option of sending data files will remain disabled in their computers The reason for this 1s that the Consultant will never be sending quarterly data files to national level as they do not have permission to enter data i Fpi Centre 2006 District level Data Entry EE Check Output Utilities Help Quit Email quarterly data to CTD State and Others Email Far requesting approval From CTD Save quarterly data Files to Save request approval data Files to Retrieve data from email Status of requested approvals Additional Email Features Send data From State to district Send data From Central to StaterDistrict Fig 29 23 E mail quarterly data to CTD State and Others This option allows users at state or district level to e mail all new and updated quarterly data to a level higher 1 e District will send data to National STO STDC if any and all Consultants in the State St
6. This manual will cover Installation of Epi Centre software How to start the program The process of entering data Compilation of data via E mail Analysis of data Explanation and examples of the other additional functions and features of the program Frequently Asked Questions Understanding common errors and rectifying them yi Chapter 1 Installation EPI CENTRE has to be installed from the CD onto the hard disk drive before it can be used We cannot use the software directly from the CD The instructions below will guide you through the installation process which is very simple Please do not change any option unless absolutely necessary e Insert the CD labeled EPI CENTRE FOR WINDOWS in the CD drive and wait for few seconds The system will start the Installation process automatically windows installer will prepare to start installation process as shown in Fig 1 below Epi Centre Setup Starting Epi Centre Setup Please wait Fig 1 e Epi Centre Dialog box will appear click on NEXT Fig 2 Epi Centre Setup Fig 2 e Welcome Dialog box will appear click on NEXT to continue with setup Fig 3 Welcome Welcome to the Epi Centre Setup program This program will install Epi Centre on your computer It is strongly recommended that you exit all Windows programs before running this Setup program Click Cancel to quit Setup and then close any programs you have running Click Next to continue
7. a LAN settings the network path has to be provided to Epi Centre so that each time information is required from the database it can be accessed from the server by the software installed in the users machine The database is kept in the same path in the server as it is kept in the user s machine i e Epi Centre2006 Data FilesV So while entering the server path you should enter the complete path where Epi Centre2006 is installed including the server name Administrative Tools Create Mew Users Change Password Delete Users Authorise a district to enter another district data Epri Centre uses the following information to connect your computer to a database file placed in any network drive You can enter change the name of the network drive to access your commonly shared database file Network details Are vou connected ta any Local Area Network LAN d OK Cancel Apply Fig 65 Please Note There is no need to prefix W before the server name as Epi Centre prefixes the W before the server name Warnings Please do not enter any details in this sheet tab unless you are actually working in the LAN Any testing may be disastrous as this will stop functioning of Epi Centre During configuration get in touch with the helpdesk to receive assistance and proper guidance 90 Authorise a district to enter another district data This tool is used by State Consultants and National level users
8. appears mg Both OR amp RA mails le AllMails QR New and Updated quarterly Data Approval Requests Email summary list From To Email contents Reading pane Cc Attachments Fig 34 2 e Depending on the installation location of Epi Centre choices for the combo box of Show emails with subject may vary Fig 34 gt In case the installation location is district then it displays only RA mails in the Email summary list and Show mails with subject combo box displays the subject of RA mails The combo box is disabled for selection Hence in this case subjects for other types of emails are not visible selectable or uploadable gt Incase the installation location is other than district then you can select any one out of the 3 choices available in the Show emails with subject combo box e BOTH QR AND RA MAILS Display all Epi Centre related emails lying in the Inbox of MS Outlook e QR NEW AND UPDATED QUARTERLY DATA Displays only mails with the above mentioned subject from the Inbox of MS Outlook e RA APPROVAL REQUESTS Displays only mails with the above mentioned subject from the Inbox of MS Outlook Retrieve Email Data amp AA malls AllMails 24 C Unread Mails 12 de gt m G Date Received Dutta Mr Prasenjit WR RA Requesting approval for changing freezed d Du
9. can be well understood on careful scrutiny of the above figures i e Fig 51 52 amp 53 The map display window has few short cut button icons which is described below V It finds a map feature matching with the specified text given in the find string A map feature can be a State or District or TU boundary and after finding 1t highlights the boundary by blinking the location Find doesn t search in numeric fields Characters need not be enclosed in quotes Find is not case sensitive You can enter the part of the text For example just typing KOL and click FIND will also find Kolar Kollam Kolhapur Kolkata etc Wildcard characters are not supported by Find Find 11 matches found Kolar Kollam Kolhapur Kalazb Eu Highlight Insert Pin Pan To oom To Fig 54 40 Click on the desired item in the list 3 Pick a feature and click on any of the appropriate buttons to perform the task Highlight Insert Pin Pan To oom To E Labels all the map units with its name on the map like labels all districts with its name E Zooms to the fullest extent of the page On clicking it displays the entire map on the screen Highlights the selected feature on the map by blinking the entire polygon Inserts a dot point on the selected feature on the map Scrolls the map to display the selected feature in the centre Zooms the selected features to the fullest extent
10. first district record 44 Displays the previous state Displays the pervious district 4 Displays the next district dd Displays the next state d Displays the last district record Ud Allow users to add a new district record Allows editing the current record amp Deletes the current record amp Prints the current record BN Finds a record matching the search criteria District level users can not add a new district A Data Manager at State or National level can only add a new district District once created can not be deleted The name or spelling of the district also can not be changed in case if the district name or spelling has changed In case if a district has stopped functioning because of a merger or split the district needs to be stopped by clicking on the Yes option button and entering the stop date In future for all quarters after the stop date data entry for that particular district will not be allowed 18 TU On selecting TU option the window for Tuberculosis Unit Master Maintenance appears Fig 25 w TU Master 14 lt lt a 44 4 b oh gt gt gt pl al EF Eb d Tuberculosis Unit Master Maintenance State Name District Name TU Name Contact Details MO TC Name Mobile no Office Address Phone no Fax no PNEU Emallbitan AtemateEmallD iq Displays very first TU record 444 Displays previous state record 44 Displays previous district recor
11. of 11 Quarterly Report on Programme Management and Logistics District Level State f District Quarter Year Total population of the district in numbers 3915378 gt CorfimSelecti n Population of the district covered by the ANTCP in numbers 3915378 Public Sector include Medical Private Sector Private Medical Stake holders Colleges Govt health department Practitioner Private Clinics Nursing Total other Covt Department and PSUs Homes and _ sector in the District The following reports are enclosed Tick to indicate that the report is enclosed M Quarterly Report on Case Finding Quarterly Report on Results of Treatment Quarterly Report on Programme Management If any report is not enclosed 4 Number of PHIs expected to submit monthly PMRs B Number of PHIs that submitted monthly PMR s for all 3 months in the Cancel Exit Fig 20a Programme Management District Page 5 of 11 Quarterly Report on Programme Management and Logistics District Level State District Quarter Year Random blinded re checking of routine slides at Num Deno Per Number of DMC with high false Results HFN and or HFP results 8 31 25 in the year January to December ae Tuberculosis Officer in place FT Trained in RNTCP C Yes Statistical Assistant in place Yes Trained in RNTCP C Nes Treatment Organizer in place C Yes Na Trained in RNTCP C Yes
12. restart my computer now No will restart my computer later Remove any disks from their drives and then click Close to complete setup Fig 9 e A shortcut icon will automatically be created on the main Windows desktop screen e Double click on the shortcut icon to start EPI CENTRE for Windows Alternatively to start Epi Centre click on Start Programs Epi Centre 2006 Epi Centre If you have selected a location other than the default path during installation of EPI CENTRE for Windows you have to be careful while editing the location at various points while using EPI CENTRE for Windows Getting Started Once EPI CENTRE for Windows is successfully installed it can be used for Tuberculosis data management But it needs to be customized to make it ready for use before entering the quarterly data of Case Finding Smear Conversation Treatment Results and Programme Management reports To customize or make it ready to use do the following Double click EPI CENTRE shortcut icon on the desktop The following screen Fig 10 is displayed Installation location information has to be provided If Epi Centre is installed at the state or district computer then the name of the state or district where it is installed have to be correctly provided Installation location in STDC computer will be as a state Consultants do not need to provide any state or district information as they at times work beyond state bou
13. saved the next time when it 1s opened the blinking message previously showing Period is beyond 75 days changes to AUTHORIZATION AWAITED Fig 18 informing users that an modification to the data has already been saved The previously modified data can be viewed and printed later by clicking on the VIEW APPROVAL REQUESTED DATA button Fig 18 13 Quarterly Report on New and Retreatment Cases of Tuberculosis TU wise report Oe f r HT All new and E patenis registered in the quarter Pen pa mn p Cored Be t Fig 16 Once Request Approval data is emailed to CTD further modifications are prevented till CTD approves the current request Fig 19 But original data and Request Approval data still can be viewed and printed L Caco Finding Quarterly Report on New and Retreatment Cases of Tuberculosis TU wlIse report Siste Aretes Pradesh Dust anias TW adea DIE Que 1e Yew al Cont Selection Fees SS All new ond relapse polbents nenishiereri bo the unter Record cant be gos unii CT dears E Secos Positive i he pending request Fre thes selection Memes pica pagos ied Fig 19 14 Cursor movements in Programme Management The data type encircled in Fig 20 a and b i e check boxes and option buttons can be selected or deselected by clicking on the desired option with the help of a mouse only Programme Management District Page 1
14. with the Setup program Unauthorized reproduction or distribution of this program or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under law e Important Notes Dialog box will appear click on NEXT Fig 4 to proceed Important Notes This software will work best with the following computer configuration A Minimum Hardware requirements Pentium Ill Pentium IV recomended 128 MB RAM 255 MB recomended 16x CD ROM drive YGA monitor type with minimum 1024 x 768 resolution Software requirements Windows lt P Professional edition MS Office MS Excel MS Powerpoint MS Dutlook configured for TBC India mails Other requirements On clicking Next button Change Destination Location Dialog box appears Changing the default destination is not recommended Click on NEXT Fig 5 Choose Destination Location Setup will install Epi Centre in the following directory To install to this directory click Next To install to a different directory click Browse and select another directory fou can choose not to install Epi Centre by clicking Cancel to exit Setup Fes Directory jc SEpi Centre2006 Browse Space Required 110656 K Space Available 55909296 K Program Folder Dialog box will appear Changing of the default folder EPI CENTRE is not recommended Click on NEXT Fi
15. E Selected quarter All quarters mtr chus Refresh List Jaipur 1 2006 NSP Jaipur 1 2006 Rel Jaipur 1 2006 TAD Print Recreate data OK Fig 43 e Cohort difference list is shown as per the selections made district wise Fig 43 33 Quarterly reports not received This option allows the user to find out the status of receipt of quarterly reports from districts The report can be seen TU wise or district wise The basis on which the report checks the status of quarterly reports received is on the following Case Finding and Programme Management for the selected quarter and year Smear Conversion for the previous quarter of Case Finding reports Results of Treatment same quarter of the previous year The default setting for this report is TU wise On click on any state name or district name in the tree view on the left hand pane it shows the receipt status of the TU in the selected state or district Blank indicates that reports are not received Y indicates that the report has been received and NE indicates that the reports are Not expected either the TU has stopped functioning or started later than the selected quarter To view the status of reports received e Select the quarter and year e Click on any state to view the status of quarterly reports for all the TUs in that state e Or click on the sign besides the particular state to expand the state name tree and make the districts of th
16. Ly e Display the attributes of a map feature To use this click on the Identify tool in the shortcut bar and then click on any map feature in the map All Attributes of the identified map features are displayed E Zooms In the contents of the map in the zoom box you defined by drawing with the help of a mouse on the map view X Zooms Out from the position you click or the area you define on a map view You can pan scroll the view by dragging it with the help of a mouse in any direction Draws a point with a symbol on map view k The Identify Zoom In Zoom Out Pan and Draw point shortcut buttons are recursive in nature i e once any of this buttons are clicked the same job can be done again and again till it is not stopped by clicking on the Arrow button The Arrow button stops the previously selected repetitive function and returns the mouse pointer symbol back to a normal arrow To plot performance indicator data on a map e First select the level of map you want to display 1 e national level map or a state level map or a district level map National level maps are not available to the state and district level users Fig 55 Relapse Cure rate NSP Transferred Out rate Sm oh 7 3 eorom ek eh 27 27 0 0 a e Map leve E Map levels e National p C State wise C District Plot Map Map of 1 of 2006 e Once the level of map is selected the next step 1s to select the sub level 1 e state wise or
17. P TT NN 48 ICE c o e A OQ 49 aedi M UE 50 Authorise a district to enter another district data serrr E a E E 51 impor Expor Master data le unidad lidad 53 Introducing Epi Centre Welcome to Epi Centre application This software is developed for the programme managers at district state and national level to record report maintain and monitor Tuberculosis data It can also be used for supporting research activities and statistical analysis Epi Centre consists of several components Database Entry Module Manages entry of quarterly TU wise data Data Compilation Module Automated sending and retrieval of Tuberculosis data via E mail Data Exporter Module Exports selected raw data from Epi Centre into MS Excel Analysis Module Multi varied Single Interface reporting tool generating tables and graphs Thematic Representation Module Epidemiological representation of data and statistics on maps using modern GIS tools Features in the Software Users of previous version of the Epi Centre software would notice a number of new features and improvements besides simplifications However secured access to information has been given prime importance User friendly ergonomically designed screens intended to maximize productivity by reducing operator fatigue and discomfort Limited and secured access to information at all levels Depending on installation location and user type right to access information is decided For e g dis
18. aging various administrative functions like Create new users Change password of existing users Delete users Network details to provide the server path in case Epi Centre is used in a LAN settings Authorise a district to enter another district data Create new users New users can be created by any Data Manager only Other types of users do not have privileges to create new users Two users with the same name and same user type can not be created User name and password are not case sensitive Figure shown below displays different attributes of the Create New user sheet tab Fig 62 The password can be entered with a combination of characters numerical and special characters and does not require any minimum or maximum length A character entered in upper case in password string does not have any special significance Administrative Tools Network details Authorize a district to enter another district data Change Password Delete Users User Type User Mame Enter Password Re Enter Password Or Cancel Fig 62 Change password As the name denote Change password 1s to change the password of a user Below are few points to remember during change of password e A user can only change his her password and can not change password of any other user 48 e lt A Data Manager can change password of any user but he also would need an authorization from the user in form of h
19. ank e In this option also all records which has been previously emailed but not updated after it was emailed are removed from the copied database file So only new and updated records are present in the file The new file 1s then compacted encrypted and password protected before it is saved in the desired location 26 Retrieve data from E mail This option is used by all i e users at National State District and Consultants level It allows retrieving and uploading data from E mails received There can be 2 types of emails which are received They can be either with subject QR New and updated quarterly data from Epi Centre normally referred as QR mails They are send by districts or state to National STDC Consultants and state 1f send from district Or RA Requesting approval for changing freezed data normally referred as RA mails They are send by district to National State STDC and Consultants or approval dis approval status are send back to the districts by the National level National State STDC and Consultants receive both QR and RA mails Districts receive only return RA mail from National level with approval disapproval status e Onselecting the option of retrieving data from E mail CHOOSE PROFILE dialog box appears Fig 33 Choose Profile Profile Mame STET Fig 33 e Click on OK to proceed with OUTLOOK as the default profile as shown in Fig 33 e RETRIEVE EMAIL DATA window
20. arter data 1s included in the report e Report Frequency This option describes the reporting frequency i e whether the output will be displayed quarterly or summarized as per calendar year annually or summarized as per a cycle of 4 quarters Each cycle starts from the starting quarter and ends after adding 3 more quarters to the starting quarter to make a full one year data or 4 quarters data Cycle year method compiles data for one full cycle of 4 quarters e Summary of data for the entire period This option will compile data for all the quarters from the beginning of the period to the end of the period mentioned for the report For ex when this option is selected for a period from 1 quarter 1999 till 4th quarter 2007 for the entire country for total number of NSP cases for India it will calculate and show the total number of NSP patients treated till a quarter 2007 in the country from 1 quarter 1999 e A sample report is shown in Fig 47 Report Ex dire SAAT XE ER Moves to next page New Smear Positive Conversion Rate Ag on J8 Noy 2008 For Te penod 14 quarber 2005 10 Ih quarter 2005 Total Hegalree at Abergele at ote TET I A Prints the report race ON OYM cc mome Sams ate Andaman amp Hicebar J 4 Ha 560 ai Era E rl Micohar 3 2005 560 A72 y ors MHicobar BTS J 2005 360 471 32 50 Exports the report maras j 3 w m a n ws Hijaab a 005 9261 afi xz o Hyderabad DTC 3 2005 561 472 31 0 W
21. at state visible Then click on the district to check the status of receipt of quarterly reports e To view the status of receipt of quarterly reports of the entire country tick on the check box Check for all TUs of all districts and states in the specified quarter ifeiptay ly Reports Status of quarterly reports Select a quarter and year to check the status m C District wise e Check status of quarterly reports al lt A Quarter Year px TU wise C Show list of pending reports Rajasthan State Distr TU cF sc Rr PM Check for all TUs of all districts and 3 E a States in the specified quarter Print Exit Fig 44 34 Chapter 5 Output Output option in the main menu is used for generating standard performance indicators in the form of tables graphs It also displays the information on performance indicators by plotting the processed information on maps i Epi Centre 2006 State level Data Entry Send Receive Check Komata Utilities Help Quit Case Finding b one Tebes craphs Treatment Outcome b Map Programme Management Trend Analysis Tables Graphs gt Automated Feedback Print Forms Fig 45 Tables To display the performance indicator information in the form of Tables or Graphs Report Selection window appears This is a single window interface for all different types of performance indicator reports By the Report selection criteria windo
22. ate will send data to National STDC if any and all Consultants in the State On selecting this option Fig 30 all records which have been previously emailed are removed from a copied file of the original database to reduce the attachment size The file is then compacted encrypted password protected and renamed as EPI CENTRE CPY before being attached to the E mail Note The original file is kept safely in the DATA folder in its original format All concerned persons addresses are automatically filled in the respective text boxes 1 e To and Cc Both the text boxes are locked and cannot be modified BCC address field is enabled and left empty E mail id of any other intended recipients can be typed in the space reserved for BCC option Each address should be separated by a semi colon SUBJECT of the E mail 1s also auto generated and cannot be modified Standard auto generated text appears in the body text of the E mail message Extra information can be written in the space provided Once the email is composed click on the SEND DATA button to E mail Clicking on CANCEL will abort or cancel the process Records included in the E mail attachment are marked as E MAILED in the original database only after the composed e mail is successfully sent to the OUTBOX of the Microsoft Outlook or Outlook Express Subject Attachments Respected Sir Please find attached herew
23. bled Fig 26 4 4 o Pl ADA District Master Maintenance Slate Name State Lode District Nama Dist Code Implement alien Date ES Contact Details i Predominantly Tribal Predominantly Rural Urban Yea No Proce X C Rus 7 Urban Office Address DTO posting history Mobile StatDate EndDate Status Phone mt Fano Emal ID A emate Emai ID Projected Population Yeo PPNI PPQr2 PPO PPQv4 Pes Proected Poulton C Ed Has the district stopped existing Yer No IE Yes When En Fig 26 WHO Consultant posting history Nave Moker Stat Date End Date Status On clicking on the Add button the following window opens Fig 27 Projected population District District Name Kanker Quarter Year 2007 El Projected Population o Fig 27 To enter all the four quarters projected population figures for the entire year in one go select 1 Quarter while selecting the quarter While saving the projected population figures Epi Centre automatically fills up remaining quarters of the year with the same figures That 1s on selecting 1 quarter the same population figure of 1 quarter is replicated in other 3 quarters If x quarter is selected then remaining 2 quarters 1 e 3 and 4 quarter will be filled up with Du quarter population figures and in this case 1 quarter will remain blank Click on the Save but
24. ct the period of data to export by providing the desired information in the From quarter and year and To quarter and year During exporting data from the quarters of From and To are included during exporting The tree structure on the left side of the window displays the variable list from all the quarterly forms The form names are displayed in Red CF SC RT On double clicking on the first level variables below the form name or clicking on the sign besides the variables will expand the next level This process can be continued till the unitary level variables are displayed Fig 60 46 Export data to MS Excel 4 Export data to MS Excel FE State an states District all districts y From Quarter All qtrs oe fan qtrs 4 Year 2006 Year En 2006 A Block 1 E Es NSP NSN Jt Male Vall Val xj Val Total Val Add NEP Relapse tH Block 2 Remove Block 3 NSFP EREMAVE AT Relapse z carat 5 Failure m Please select all necessary conditions and fields before clicking on Export data button Export data Cancel Fig 60 Once the lowest level variables or unitary variables are displayed the desired variables for exporting can be selected by either double clicking on the variables or clicking on the variable and then clicking on Add gt button This will append to the list of selected variables on the right hand side list as sh
25. d 4 Displays pervious TU record 4 Displays next TU record dd Displays next district record Displays next state record d Displays very last TU record Ud Adds a new TU record f Edits the current record Deletes the current record amp Prints the current record B Find the record StateCode 55 District Code 99 995 TUCode 3959 Implementation Date Year wise population TU population can be entered Predominantly Tribal C Yes No Percent x Predominantly Rural Urban C Rural C Urban Has the TU stopped functioning so olb Mazwi B8 Fig 25 A Data Manager at any level except Consultants can add a new TU TU once created can not be deleted The name or spelling of the TU also can not be changed in case if the TU name or spelling has changed or the TU has been merged with another TU In case a TU has stopped functioning because of a merger or split the TU needs to be stopped by clicking on the Yes option button and entering the stop date In future for all quarter after the stop date data entry for that particular TU will not be allowed 19 District wise and TU wise Projected population District wise District wise projected population are prepared and provided by CTD This can be entered quarter wise under District Master Maintenance refer to Fig 24 Once the district 1s opened in editing mode the Add button in the Projected population frame is ena
26. district wise maps in case of National level and district wise or TU wise in case of state level e The state name has to be selected first before the sub levels are selected 1 e district wise or TU wise if a state level map is selected e On completion of the above selection an empty map is shown in the map view area e Click on Plot Map to display the performance indicator data on the map Fig 56 w NSP Conversion rate i GUJARAT DISTRICT i GUJARAT TU alue Less than 65 65 69 9 Greater than 89 9 Map of 1 of 2007 Bet Fig 56 e To return to the map selection window click on Return button encircled as shown in Fig 56 e To close the window click on Exit button 42 Print Forms This option allows users to print quarterly reports of all levels TU wise District wise and State wise The resultant output can be viewed on the screen or printed directly on a printer To print the quarterly forms select Output Print forms from the main menu The Print Form window opens as shown in Fig 57 Select the Print Options before making any selection To summarise all TUs in a district and print district level report select District wise option button State wise reports can be printed by selecting State w1se option button All districts in the selected state will be summarised to prepare the state level report Print Form Print Options f TU wise Andama
27. eived District wise Fig 38 Cohort Analysis Ideally the number of patients reported for each category of TB patients in the Case Finding form should match with the cases reported in the Sputum Conversion and Treatment Outcome forms During data entry of Sputum Conversion or Treatment Outcome any mismatch in cohort reporting is checked and recorded in the database while saving This option displays the previously recorded cohort mismatches TU wise This option displays the TU wise cohort mismatches for each category of TB patients Fig 39 w GONO Erence State Tu Quar Year Categ cr sc RT io 3 Rajasthan Jaipur Amer 1 2006 Rel 2 Rajasthan Jaipur Amer 1 2006 TAD Rajasthan Jaipur DTC Jaipur 1 2006 NSP 1 1 1 0 5 0 Rajasthan Jaipur DTC Jaipur 2006 Rel D 0 0 123 Rajasthan Jaipur DTC Jaipur 2006 Fail Rajasthan Jaipur DTC Jaipur 2006 TAD Print Refresh OK Fig 59 31 for all years SALTAR AS i qu um a a nd AL Maa mnr STG diee Fig 40 m Bee This option recalculates the cohort mismatches that have been previously recorded in the database When modifications are done in the Sputum Conversion and Treatment Outcome data records of previous discrepancies are automatically removed from the database if the figures match In case of Case Finding data modification automatic checking of cohorts discrepancy doesn t occur while the data is saved and hence
28. es Admin Tools Export data to Excel e Ep Centre 2006 Districtleyel Data Entry Send Receive Check Output M Help Quit Scientific Calculator Notepad Epi Map Import and Export Master data files Export data to Excel Export entire files Fig 58 Scientific Calculator You can use Calculator to perform any of the standard operations for which you would normally use a handheld calculator Calculator performs basic arithmetic operations such as addition subtraction etc Functions found on a scientific calculator such as logarithms and factorials can also be done with the help of this calculator Notepad Notepad is a basic text editor that you can use to create simple documents The most common use for Notepad is to view or edit text txt files Epi Map EpiMap is a freely available mapping application program that can be used as an effective tool to perform some of the basic Geographical Information System GIS functions It does not contain all the features available in a GIS application like Arc View but is useful for simple spatial representation of data If you do not have access to any desktop GIS application but still want to undertake additional spatial analysis EpiMap is a helpful tool to work beyond the standard in built spatial analysis of Epi Centre To use the Epi Map tool you have to additionally install it from Epi Info for Windows CD available on request or downloadable from the www cdc gov web si
29. est Beal j E MA 6 004 cor d Hbi 4 7005 507 418 31 ars Ragnan_RH a guns ao 33 3 HER Doenur_RH a 2005 4 32 1 Hi T Gabbiria_S6H a 2005 a1 33 3 qu Haora DTE 2005 n2 Bl 5 30 Jagadcshpur HORNA 2005 18 1J 4 07 JagatbaBarpur FH 4 7004 54 44 1 3355 deuria BPH a 2004 a6 40 are TL Jaiswal Hosp 4 2005 46 35 T 915 Lidggmaranpur PHI 2004 af 38 544 Vibes Chest Clinic 4 2005 gg B5 10 15 Lol obren 4 2005 om 508 125 ors Alpurduar 4 3005 116 amp 13 11 Brp r a 7005 14 in 13 529 D upguti a 2004 ya 45 28 di DTC Jalpaiguri 4 2005 i 62 14 ab Falakata 3005 hi 45 10 fiis Mal a 3004 138 a 34 fis Fig 47 36 Charts The Chart option displays performance indicators graphically The various variable options in the Charts sheet tab of the Report Selection window is shown in Fig 48 m Report Selections Case Finding Data Listing Grapb Li State f Bar Line District All Districts Y i Pie T Scatter Period From Quarter Selecta que Year 2006 r Quarterly Period To C Annually Quarter Yeat Cycle rear 00 Check the Trend over time Show Cancel Fig 48 e Area Selection If All States and All districts are selected then the graph would be displayed on data of the entire country If a specific state but all districts are selected then data from all the districts in that specific state is displayed in the g
30. evel national state district level computer the data was originally entered At State level computer Limited access Users can modify data any number of times if it was entered at the state level computer If it was uploaded from an email send by a district then it can t be modified but can be opened for viewing and printing only Any entry modification done at the state level computer will always be overwritten by data received from the district through email for the same selection At District level computer No restrictions Users can modify data for any number of times both for his district as well as data entered for any other district within the state for the current quarter If modification is permitted then data will be saved in the original database Epi Centre mdb If modified after 75 days from the last day of the quarter At National level computer No restrictions Users can modify data any number of times irrespective of the site of data entry i e at which ever level national state district computer the data was originally entered it can be modified by national level users Modified data will be saved in the original database Epi Centre mdb At State level computer No access Users can t modify data after 75 days even if it was entered at the state level computer It can be only opened for viewing printing and deleting 12 At District level computer Limited access Users can modi
31. fy data only for their district Any data entered for any other district within the state is allowed for viewing printing and deleting User can modify the data as many number of times as required but once the modified data is emailed to CTD and others it is blocked for editing It remains blocked till the time CTD doesn t approve or disapprove it For details on the approval process please refer to Chapter 3 Modified data will be saved in the temporary database TmpApvr mdb If allowed for editing an alert message appears at the beginning informing users that YOU WILL NEED TO GET AUTHORIZATION FROM CTD FOR CHANGING THE RECORD AS IT IS BLOCKED FOR EDITING THE DATA WILL BE SAVED IN A TEMPORARY FILE Fig 17 Quarterly Report on New and Retreatment Cases of Tuberculosis TU wise report Fig 17 A blinking message continuously alerts PERIOD IS BEYOND 75 DAYS Fig 17 Note The data which Is displayed in the text boxes for the selection is always shown from the original database Epi Centre mdb The PRINT button in this case also prints data from the original database Epi Centre mdb even if modifications are saved in a temporary file TmpApvr MDB As long as CTD does not approve the modification of freezed data it will not be reflected in the original database Modification to the original data can be done now and it will be saved in a separate temporary database file TMPAPVR mdb Once modification to freezed data is
32. g 6 Select Program Folder Setup will add program icons to the Program Folder listed below You may type a new folder name or select one from the Existing Folders list Click Next to continue Program Folder Existing Folders Accessories Administrative Tools Ares Music Broadcom CleverKeys de Smat Label Design ESRI Games Lavasoft Ad Aware SE Personal Cancel e Ready to Install Dialog box will appear If you want to change any of the previous setting click on Back to go to the previous screen else if everything is correctly selected Click on NEXT Fig 7 to start installation Ready To Install Setup now has enough information to start installing Epi Centre Click Back to make any changes before continuing Click Cancel to exit Setup Fig 7 e The Installation process starts and all necessary files are being copied into the specified folder Fig 8 Necessary DLL amp OCX files are registered automatically Copying file CAE pr Centre2z0064DE FarmssMSLU DLL n h Cancel This installation was created with Installer ISE from Mind ision Software http ea mindvisian com Fig 8 Click on CLOSE button Fig 9 to restart the computer now It is mandatory to restart the computers to activate the recent changes Finished Setup has finished copying files to your computer Before you can use the program you must restart Windows or pour computer Yes want to
33. ge freezed data District level users uses this option to upload status of requested approval data from the email they received from national level This means that Epi Centre will read the approval status of each request from the email attachment and Printed Dis Approved Printed For pri rinting c ipis mening checkbox and click Print M of 10 items can be selected at a time for printing Print Exit Fig 37 When selected REQUEST APPROVAL STATUS window appears Fig 37 To view the items of specific type of status click on the down arrow to list the options in APPROVAL STATUS Fig 37 gt APPROVAL REQUEST PENDING List the request approvals which are pending for being approved gt APPROVED BUT NOT UPLOADED List the items approved but the modified data has not been uploaded DISAPPROVED List the disapproved request approvals gt ALL EXCEPT UPLOADED Lists all the request approvals of which data is not uploaded gt APPROVED AND DISAPPROVED DATA Lists all approved and disapproved request approvals gt APPROVED AND UPLOADED Lists all approved and uploaded data 30 Chapter 4 Check Sub options under CHECK menu options are Cohort Analysis gt TU wise gt District wise Quarterly reports not received i Epi Centre 2006 National level Data Entry Send Receive eye Output Utilities Help Quit MENTE a Quarterly reports not rec
34. hat the data from the other district is garbage e To avoid this central level state level and consultants needs to be informed by email that the other district data is entered by an adjoining district and it should be accepted in the system e On receiving the email users at the 3 levels 1 e national state and consultant will open admin tools and click on the sheet tab Authorise a district to enter another district data as shown below in Fig 66 Administrative Tools Create Mew Users Change Password Delete Users Network details Period selection Authorization for another district Quarter Pe Year 2007 List of Authorised Districts State JH District who ts entering data For another district Fig 66 e This authorization is valid for only one quarter If the same arrangement exists in the next quarter the same procedure has to be followed e The authorization of a district to enter another district data can be done within a state only 51 A district can be authorized to enter multiple district data in a single quarter If authorization 1s not awarded before uploading data from the email then data of the district which sends the email is only uploaded and the other district data is rejected for uploading Below is an example Fig 67 where Ghaziabad of Uttar Pradesh 1s planned to enter and send data of Gautam Budh Nagar and Meerut for 1 quarter 2008 The auth
35. in those cells Fig 21 Programme Management District Page 5 of 11 Quarterly Report on Programme Management and Logistics District Level State Prad District Huderat Quarter 1g Year Random blinded re checking of routine slides at Number of DMC with high false Results HFN and or HFP results in the year January to December Staff Position and Training Click if in place or not during quarter and trained or not District Tuberculosis Officer in place FT E Trained in RNTCP C Yes Statistical Assistant in place C Yes Trained in RNTCP C Yes Treatment Organizer in place C Yes No Trained in RNTCP C Yes Laboratory Technician in place C Yes s Trained in ANTCP C Yes Data Entry Operator Yes Trained in EPI Centre Yes Driver C Yes Fig 22 16 Master Maintenance The master file maintenance comprises of State District TU and TU population By these options you can add enter or modify details for the State District and TU like address telephone no email id etc State On selecting State option from the main menu under Data Entry Master Maintenance the following screen for State Master Maintenance appears Fig 23 Mi al gt pl ara State Master Maintenance SlaleNane aye Code Contact Dosis STO Present C E Ho Once Addiesi lured 5 TUE Nome Damn State HO Dorrullant Hane 310 posting his
36. ing on the Total District Population figure text box and fill in the data On saving the District Master Maintenance sheet is also updated Epi Centre automatically saves the same population figures for every TU for the remaining quarters of the year after the selected quarter i e if the selected quarter is 1 quarter then Epi Centre will automatically fill 2 3 amp 4 quarter with the same population figures for all TUs Similarly if 2 quarter is the selected quarter then Epi Centre will fill 3 and 4 quarter but leave 1 quarter as blank Clear record locking selection Epi Centre protects from more than one user working on the same record at the same time from two workstations on a network It locks the record once the user confirms the selection Any other user is prevented from entering viewing or modifying data for the same selection In case of a previous failure to save the data or cancellation of the selection due to any reason the record remains locked and no modifications are permitted even by the same user at a later point of time even in a single user machine Clear record locking selection will release the record for further entry or modifications 21 22 Chapter 3 Send Receive The various sub options under SEND RECEIVE menu options are E mail quarterly data to CTD State and Others E mail for requesting approval from CTD Save quarterly data files to Save request approval data files to
37. is her old password This is to protect the individual users privacy so that a Data Manager can not change the password on his own and restrict the user from accessing the data e Incase of emergency where the user has forgotten his password and wants to reset the password a Data Manager can help him to reset the password In this case the password of the user will be reset to NEWPASSI23 e The Reset button is visible only when the user has logged on as Admin Data Manager Administrative Tools Network details Authorisze a district to enter another district data Create Hew Users i Delete Users User Type User Marne Old Password Mew Password He Enter Password OF Cancel Apply Fig 63 Delete Users This function will allow the Data Manager to delete a user who has already left the programme or the user has been wrongly created A normal user cannot delete him her or any other user To protect the privacy of individuals the Data Manager also cannot delete a user without his her consent in the form of his her password Administrative Tools Network details Authore a district to enter another district data Create Mew Users Change Password User Type User Name Enter Password Ok Cancel Fig 64 49 Network details Epi Centre can be installed on a single user computer or on a Local Area Network LAN To use Epi Centre in
38. is option will help the user to save the file which was supposed to be sent as an email attachment into a floppy disk or pen drive or CD Save quarterly data file to Save in Se Local Disk C 5092 12d6128686521d CJ Epi Centre Cj STAR da C Acrobat 5 Epi Centre2006 5 Update patches My Recent y ajay Data Files S Epi Centrez006 Pra C WINDOWS Antivirus tools ESRI E ASLog txt d O Avijit i886 ed AUTOEXEC OLD Documents Cjb s48dseresob472f8 NETSS E avsetup lag Desktop centre Office 2003 E CFN1Q07 REC 5 Centretu 9 Program Files Ed CONFIG OLD O centretuz Repair Epi Centre dell scr del E scandac Ed INFCACHE 1 Documents and Settings 5DR TB4 10 545 drivers ysdrtb4 El MSDOS 5 5 EPI6 5 Songs ES PMP1QU7 REC hy Documents u My Network Save as type Cancel Places Fig 32 e Once you click on this option from the Send Receive option of the main menu the Save quarterly data file to or Save request approval data file to window opens Fig 32 e First select the location to save the file Either it can be a Floppy disk or Pen drive or CD RW drive or any other location where you want to be save the file e The name of the file should be given as Epi Centre cpy in the first case or ImpApvr cpy in the second case The name of the file is not case sensitive e The type of the file mentioned in the Save as type textbox should be left bl
39. istrict TU gt Projected population w Epi Centre 2006 District level Send Receive Check Output Utilities Window Help Quit Case Finding TU wise Ctrl Sputum Conversion TU wise Ctrl s Treatment Outcome TU wise Ctrl F Programme Management Master maintenance k Clear record lacking details Clear record locking details Fig 15 The following commands have the same meaning during all data entry options mentioned above Backspace q Right Arrow Left Arrow 1 Up Arrow Down Arrow lt Tab gt Deletes the character to the left of the cursor Moves the cursor one character to the right Moves the cursor one character to the left Moves the cursor to the previous item in the pop up drop down list Moves the cursor to the next item in the pop up drop down list Moves the cursor to the next field lt Home gt Moves the cursor to first character of the field lt End gt Moves the cursor to last character of the field lt Delete gt Deletes a character at the cursor location Quarterly Reports in various formats CF SC RT PM The following have the same meaning during data entry in all reporting formats screens Fig 16 EEUU Saves the current record entered modified Logically delet th d from the database Physically th d exists but ogically deletes mm e record from the database Physically the record exists bu only the flag for record deletion is set to True Cancels the p
40. ith the new and updated quarterly data from Epi Centre software Thanking you Body text of email message DTO Hyderabad district Andhra Pradesh state Send data Cancel Fig 30 24 E mail for requesting approval from CTD This option is used only at the District level By this option the districts can request national level for approving the modification of existing freezed data The process is same as previous except for the following differences e Subject of the e mail is RA REQUESTING APPROVAL FOR CHANGING FREEZED DATA e The E mail attachment file is renamed as TMPAPVR CPY before being attached to the E mail Email all approval requests to Central TB Division Subject Attachments Respected Sir Please find attached herewith the updation for the locked data beyond 75 days We request you for approving the DTO Hyderabad district j Andhra Pradesh state Send data Cancel Fig 31 25 Save quarterly data files to or Save request approval data files to This option can be used only in a case of emergency when emails can not be send from the host computer the computer on which Epi Centre 1s installed and used because of internet not working or telephone lines are down hence can not connect to the internet nor send emails or for any other similar reasons In such circumstances the quarterly data files can be sent from any external computer maybe from an internet caf Th
41. lay window displays the default District map with TU boundaries as shown in Fig 53 NSP Conversion rate 1 w NSP Conversion rate 45 T amp lm d E Ely ey ek Map levels a m Map levels National iin ts C State wise gt ona E District wise 5 T a C C State EA As State District wise 1d e 2 de ae wi at Eb C District wise 22 TAB Fut Yu ane t 3 She Commie oe ri C TU wise pis May uso M TU wise Y 1 C District y Ey po mm Pans NL anm t y ca bis t Nae i i d fee y 1 Ve E tT ul p k n E LT ad Plot Map 1 E ern o Plot Map s T i UE Ur a y Pe Map of 1 of 2007 Exito Map of 1 of 2007 Fig 51 Fig 52 39 w NSP Conversion rate aula 212 eorom e x Map levels C C C C State C District wise C TU wise District gs 7 Plot Map Map of 1 of 2007 Fig 53 f Exports the map to power point slide w Find Features amp Prints the map as shown on the screen to a printer 1 Enter a search string Case insensitive kal 2 Choose which layers to search 3 Pick a feature IndisDistrict DIST NAME India Distict DIST MAME IndiaDistrict DIST MAME JE India District DIST NAME 4 Select the operation to perform Depending on installation location the Map level options also changes National level users can view maps till the district level and state and district level users can view TU level maps This
42. n amp Nicobar O Andhra Pradesh O Arunachal Pradesh C amp ssam C Bihar C Chandigarh C Chhattisgarh C Dadar amp Nagar Havel C Daman amp Diu O Delhi L Goa O Gujarat Year 2008 D Ahmadabad MC Quarter ES m REDI Districb wise Skate wise Form Type Case Finding t Sputum Conversion E eee eee eee Se eee ee RES ES Result OF Treatment O Singarva Ta Printer C To Screen Print Report Exit Fig 57 After selecting the Print Option select the desired reporting unit by checking the check box besides the name for which form printing is required Multiple selections are possible and checking the check box of a higher level will automatically select all the reporting units under it Like if we had selected TU wise printing of reports and checked the check box besides Ahmadabad district name then all TUs of Ahmadabad are automatically checked and on printing it will print all the TUs of Ahmadabad one by one Printing to screen has no restrictions regarding number of selection of reporting units but when printing to printer restrict your selection of reporting units to maximum 10 at a time The maximum number of selection can vary from computer to computer depending on the available free RAM space 43 44 Chapter 6 Utilities The various sub options under UTILITIES menu are Scientific Calculator Notepad Epi Map Import and Export Master Data Fil
43. ndaries working in more than one state or may be transferred to another state Names of all existing districts and state are already pre loaded along with the software c p M Ts Laon Rode Y Raad the onscrean instructions carefully before proceeding Pl ste pride all necessary infoemabon for custernisang this Sitea and compieing the installahon process ros il itt malin Bal is nemuaieed Epic fmc alty lahor During fir ifyou fi ihai you dongi hareu curtain inforrralion pees Counce bution fo abort the process Fig 10 Select the option according to the level of reporting unit Central State or District from drop down list for Installation Location Fig 10 On selecting STATE option in Installation Location window the field for STATE NAME is displayed Select the appropriate state from the drop down list Fig 11 j d uu ye NE E C CA A A 00d N Read the onscreen instructions carefully before proceeding Please provide all recess information for cuslomising this sofware and completing the mslallalion pro cesa Ifyou Tail ta peoviche arg information fal is required Eph Carve may noi funcion mammal iaer During this process i you feet matynu danoi have certain informa on press Cancel bomen lo abori fe protses e On selecting District option in Installation Location window the fields for STATE NAME and DISTRICT NAME are displayed Enter the information from the drop down list of the respective fields Fig 12 A
44. only District level users do not need to use this tool at all This tool is used to authorize a district to enter another district data There is no restriction at district level to enter data of another district Any district level user can enter not only data for his her district but also data for any other district And since there is no control by the user over the data that is sent through email there is a fair chance of garbage entering into the state and national level computer To avoid this the following steps will help to minimize the risk Also there may be a district where the Data Entry Operator DEO in not in place and in such circumstances it may be required that a DEO of an adjoining districts enters the data and sends it to state consultant and national level along with his own district data e Identify a district level DEO who can enter the data of the district where the DEO post is vacant If the adjoining district DEO can travel to the district and enter the data in that districts computer then there is no need of any adjustments at any level e But incase the identified DEO can not travel to the other district in that case the data from the other district has to be entered in his her computer If at the state level or consultant level or national level computer the district is not given permission to enter and send data then inspite of the district entering and sending data it will be rejected at the higher level assuming t
45. ononnnonononnnnnncnnnno nennen nennen nnns 20 TUS THUG DSW IS e aote fe ate DOLO E E tetto a sin iu dud E epi anevada dtt na Ms tat ciue eps usb d e ee eR 20 QUE e O 21 Cleat record locking SelectloDio os A cun dedo ca mudo NOn AA don aoa adir odd vv a RR DEAE Rs 21 Chapters SENG RecelVessmaiiserend oon nd n ne V E Vb X e D ECL EY A d Esmail quarterly data to C TD State and OUIGETS ccr des Ep id qu eit buc aae uada tem Doudou uat 24 E mail tor requesting approval from C TD iiu iter ii Eo te Ga ret tab EEE E AE 25 Save quarteriy data Tes TO MR A A EA E A 26 Reeve data ron Ea a o ori 2 LOUIS OWE requested appro val Sida eae er cable cap AAA ce dudes ii Pe Se 29 Status Or tre quesicd ApPIOV Als uta edet du d delicate E A di 30 Chapter gos OCI uaa rivi oett na era EEUU VETE DE EE A OO En PE L CONOS MP 31 gU A E 31 DIA ii ii 32 Quarterly reports NOLTCCCL di ias 34 Chapter gt OU MU taaan Tabla 35 To plot performance indicator data on a map sss eene enne en nnne nennen seien tenerse enne 41 Rat EOS di ia 43 Scientiic C aleulatof dias 45 Note dead dtes anch ppt Ut A E 45 IE Na a crests carte ect LaL ME LU LE um table up D M E dum NE Ms utc dE 45 Expor Cala Ox Cel girs ceperat S d cuo Coe c qua a UR La EM tup ur o use la Ce su TERR EE 46 AMI TOS seas Serica eee liad a E E ERR t NUR eee eas ee eausa osculis e eee eae 48 ORCA ES TNS er tm 48 CHang epa S VIT P
46. orization is done at all levels 1 e state consultant and national level computer Now when Ghaziabad sends an email with data of his her district along with data of Gautam Budh Nagar and Meerut it is accepted and uploaded in Epi Centre Administrative Tools Create New Users Change Password Delete Users Network details Autharize a district to enter another district data Period selection Authorization for another district Quarter E Qtr EE Year 2008 z List of Authorised Districts Gautam Budh Nagar M t State Sen Uttar Pradesh District who it entering data for another district Ghaziabad i Delete Lk L ancel Clear Fig 66 92 Import Export Master data files Import Export function facilitates the data entry by a district for another district where the DEO is not in place In this case the name or codification of TU names for that district should not be done again This is to avoid wrong codification or spelling mistakes in the TU names If data entry has to done by another district then the state should export the name of the TUs and send the exported data by email to the district which is entering the data On receiving the email the district will import the TU names into their master database and then start data entry e If installation location is state then this function will perform to export dat to a file which can be later send by email fig 67 w Export TU Da
47. own is Fig 61 encircled Dy Export datato MS Excel ES Export data to MS Excel EE State all states District E districts y From Quarter fan qtrs 7 QT All qtrs Year af ear 2006 d Failure CF Block 1 NSN Male Val TAD a SC kRelapse Negative RT ATANSPCured T otal RT NSP DiedT otal NSP Registered Cured Male Female Total Completed lt Remove Died Male oe Remove All Tota g Please select all necessary conditions and fields before clicking on Export data button Export data Cancel Fig 61 Faili ire To change the order of selected variables in the list highlight the variable name and click Move up or Move down paton To remove a variable from the selected list select the variable from the selected list and by clicking on the desired variable name and then click on REMOVE button To remove all the fields together click on REMOVE ALL button Once the selected list is finalized both in terms of the selection of all desired variables and the order in which it should be exported to MS Excel click on the EXPORT DATA button This will export data open MS Excel and display the exported data in a spreadsheet Please Note The exported data is not saved anywhere in the hard disk To save the exported data click on File Save in MS Excel to save it in a different folder 47 Admin Tools The Admin Tools is a tool for man
48. raph And if a specific state and a specific district from the specified state are selected then the graph is displayed with information from that particular district only e Period From This is generally to define the quarter and year for which the graph is to be displayed In case of trends this defines the starting period of the line graph showing a trend The mentioned quarter data is included in the report e Period To This is only available when the Check the trend over time check box is checked To define the ending period of the line graph showing a trend the quarter and year is selected The mentioned quarter data 1s included in the graph e Report Frequency This option describes the reporting frequency 1 e whether the output will be displayed quarterly or summarized as per calendar year annually or summarized as per a cycle of 4 quarters Each cycle starts from the starting quarter and ends after adding 3 more quarters to the starting quarter to make a full one year data or 4 quarters data Cycle year method compiles data for one full cycle of 4 quarters e Check the trend over time This option will compile data for all the quarters from the beginning of the period to the end of the period mentioned for the graph 37 e A sample graph is shown in Fig 49 Hepo x amp de 100 District wise Conversion Rate For West Dengal VETE Total Negative at Neyative at Conversion Registered months 5 mon
49. rocess of entry or modification flushes clears all data and cursor Lance moves to very first blank field State name for a new selection Prints the current record from the original database Epi Centre mdb Preview Ent 1s shown on screen and can be later printed by clicking on the print button Evi Exits from the reporting format data entry screen and cursor moves back to the main menu Quarterly Report on New and Retreatment Cases of Tuberculosis TU wise report Fig 16 Adding a new record e Select the desired STATE name from the state drop down list Fig 16 e Select the desired DISTRICT name from the district drop down list Only districts belonging to the State previously selected from the State drop down list will be displayed e Select the desired TU name from the drop down list Only TU s belonging to the District previously selected from District drop down list will be displayed e Select the desired Quarter from quarter drop down list 10 e Select the desired year by clicking on up or down button or by pressing up and down arrow key from the keyboard e Click on CONFIRM SELECTION button to finalize the selection criteria e Once confirmed selection criteria fields like State name District name TU name etc gets locked If the data for the selection criteria already exits in the database it will be populated in the respective text boxes e Enter or modify the data in each text box and pres
50. s Enter or TAB to move to the next field e The cursor automatically moves to the first text box of the next page sheet tab only on valid data entry in the previous sheet tab You can change tabs by clicking on the particular tab Forward movement of tab 1s only permitted in case current tab 1s completely filled with valid values No restriction on backward tab movement e SAVE button gets enabled only at the end of the data entry form 1 e when all data has been entered correctly Invalid data entry will not allow the cursor to move to the next field Mismatch of data will move the cursor to the original parent field from where the error may have originated Data can t be printed while it is being entered or modified To print save the record and reopen it Click on the Print button to see the preview Click on the Print button from the preview window to print it on a printer Please note After a record is reopened for printing purpose any modification purposeful or by mistake will disable the Print button immediately 11 Modifying the existing record To modify an existing data select the desired State District TU Quarter and Year respectively Confirm the selection and the data will be displayed if found If modified within 75 days from the last day of the quarter At National level computer No restrictions Users can modify data any number of times irrespective of the site of data entry 1 e at which l
51. ta This option will allow you to export TU information of a particular district to a specified file to be emailed to the requesting district After exporting attach the file to an email and send it to the district State Gujarat select district whose data to be exported Fig 67 e If the location is District then this function performs to import data from a file received through email Fig 68 m Import TU Data This option will allow vau ta add other districts TU information from the specified file which was emailed by the state After importing vau can enter modity TU wise quarterly data of other district for the current quarter only State Gujarat select district whose data to be imported Import From Exit Fig 66 53
52. te 45 Export data to Excel One of the most interesting features of Epi Centre 2006 is the exporting of raw data to MS Excel This option helps the programme managers Epidemiologist and all others associated with the programme which would be required to work beyond the standard outputs of Epi Centre and with the raw data The export data to Excel works on a quarterly reporting pattern i e Sputum conversion data is exported from one previous quarter along with case finding data and Treatment outcome is from one previous year This is just the same way as routine reporting Occurs To export raw data to MS Excel Select the desired STATE from the drop down list Even if All state and All districts are selected only available data is exported This means that if a user at state level forgets to select the state name or wrongly enters another state name there would either be no action or the same dataset will be exported had a state name been properly selected This 1s because in the state computer there is no other states data ES Export data to MS Excel EE State All states SS District Al districts Block 1 Block 2 Block 3 NSP Relapse Failure TAD NSP NSN NEP Relapse Fail ire Please select all necessary conditions and fields before clicking on Export data button Export data Cancel Fig 59 Same principle of selection is applicable in the case of district selection Sele
53. ths Rate 410 33 120 375 501 38 Map The geographic representation of data is an important feature of the Epi Centre 2006 software With the help of this feature programme managers can quickly have an overview of the performance of various reporting units in his her area He can also perform epidemiological interpretation of data by looking into the clustering patterns and other aspects of the programme which may be visible on a map and in most circumstances not perceptible in a table graph To plot the programme performance indicator data on a map select the appropriate Map type Quarter and Year Selection for Maps window appears as shown in Fig 50 Select the year and quarter and then proceed to the next level by clicking on OK Select a quarter Select a year 2006 OF Cancel Fig 50 Similar to the tables and graphs maps are also displayed through a single window interface Depending on the location of installation of Epi Centre the option for the map criteria selection window changes and the default map that is displayed also varies If installation location is National then the map display window displays the country map with district and state boundaries as shown in Fig 51 If installation location is State then the map display window displays the default state map with district and TU boundaries as shown in Fig 52 If installation location is District then the map disp
54. to settle previous cohort discrepancies we need to refresh the list This option scans through the entire database and prepares a new list of records with cohort discrepancies District wise This option displays the District wise cohort mismatches Fig 41 L Cunurt diffsysyess Distrlet ysi5 All C Selected quarter _ ____ State District Quar Year Categ cr sc RT Rajasthan 2006 NSP 21 ERN RR Rajasthan Jaipur 1 2006 Rel Rajasthan Jaipur 1 2006 TAD Print Recreate data OK Fig 41 32 Cohort differences found in districts between CF SC amp RT reports quarter wise for all years Fig 42 Recreate data P Similar to the TU during data modification of Case Finding mismatchs in cohort reporting are not checked or recorded in the database while saving This option recalculates the cohort discrepancies and record it in the database e The discrepancies can be viewed for a selected quarter and for all quarters To filter and display selected discrepancies Click on Selected quarter option button e On selecting Selected Quarter tick the check box for the desired quarters encircled e Select the Year by clicking on up and down arrow keys e To refresh the list with only selected quarters discrepancy list click on the REFRESH LIST button Fig 43 L Cunurt diffsysyess Ulstrict zii2 C AI 3rd quarter Year 2006 a z
55. ton to save the data The window will close automatically and the Projected population list in the District Master maintenance window will be updated 20 TU wise Select the state district quarter and year Click on the Confirm button to confirm the selection On confirming the selection criteria the Total district population figure is automatically filled in from the previously entered District Master Maintenance sheet The name of all functional TUs are displayed in the right hand side grid Fill in the projected population figures for all the TUs TU wise projected population can be saved only if the district projected population is found for the selected year and quarter and the total sum of all TUs projected population figures match with district projected population figures TU Population Population State District Quarter Year 2007 Total District Population 0 TU Population entered till now 0 Balance 0 Note Save button gets enabled only when the Balance is 0 i e the difference between Total TU population and district population becomes D Fig 28 If the district projected population figures for the selected criteria where not previously entered in the District Master Maintenance sheet then the Total district population figure is filled as Zero You can enter modify the projected population of the district for the selected year and quarter by double click
56. tory Stat Date EndDate Status Ls ta State Training and Dermonstralion Centre 510 Deer a STOC ext O Yer Ho Saa Fig 23 iq Displays the first state record d Displays previous state 4 Displays next state d Displays the last state record Allows editing the current record Deletes the current record amp Prints the current record There is no option of adding a new state as this is a rare cirrumstance and only a database administrator at Central level can add a new state if need arises Same with Delete option 17 District On selecting the District option from the main menu under Data Entry Master Maintenance the following screen for District Master Maintenance appears Fig 24 I4 4 in 0l ADA District Master Maintenance Slate Name State Code District Name District Code gt implementation Date ES Contact D tails Predominantly Tribal Predominantly Rural Urban Office Address Yea 8 No Pericent x Rus Urban DTO posting history Mobile Stut Dae EndDate Status Phone nic Fano Emad ID Altemate Emi ID Pri Populati wwe ya WHO Consultant posting history Y e ny ow gt gt LI T 2 Yo PP et ears PAQUI TES Nane Maie Stat Date ErdDate Status PP Proectes Poculaton Add Has the district stopped existing es Mo IlYes When En Fig 24 iq Displays the
57. trict data entry operator cannot modify state level information Database is encrypted and password protected Automated back up of database every time user quits Epi Centre software Powered Geographic Information Systems GIS tools for online representation of data on maps Multi varied Single Interface reporting tool for epidemiological interpretation of data in form of tables and graphs Bar Pie Line etc Fully automated e mail sending and retrieval directly from user s Inbox Simplified selected data exporting to MS Excel for further analysis Easy switch over from stand alone to network LAN and vice versa Who should read this book This book will be useful for Epi Centre users like Data Entry Operators District and State Programme Managers Field Consultants Epidemiologists etc Prerequisites You should be familiar with Microsoft Windows operating system MS Office components MS Word MS Excel MS PowerPoint MS Outlook Recommended Software and Hardware requirements S oftware Windows XP Professional edition with Service Pack 2 works on Win NT or Windows 2000 also Microsoft Office XP or 2003 Professional edition Microsoft Outlook or Outlook Express configured for TBCINDIA E mail Hardware Pentium IV processor 256 MB of Random Access Memory At least 250 MB of free hard disk space Internet connection Dial up or Broadband 24x CD writer drive Any Printer for printing outputs What Is this book about
58. tta Mr Prasenjit WRO India R Requesting approval for changing freezed data duttapr searo who int QR New and updated quarterly data from Epi C Dutta Mr Prasenjit WR QR New and updated quarterly data from Epi C 2006710720 Fri 12M Dutta Mr Prasenjit WR RA Requesting approval for changing freezed d 2006 10 20 Fri 12 DTO Hugli BR New and updated quarterly data from Epi Centre 2005 1079 Mon 11 11 Dutta Mr Prasenjit WAO India QA New and updated quarterly data from Epi Centre 2006 11 10 Fri 5 07 PI Mr Prasenjit Dutta R Requesting approval for changing freezed data 2006 11 13 Mon 12 0 Dutta Mr Prasenjit WR QR New and updated quarterly data from Epi Ce 2006 87 23 Wed 6 Dutta Mr Prasenjit WRO India QA New and updated quarterly data from Epi Centre 2006 9 26 Tue 11 25 y lt amp From Dutta Mr Prasenjit WRO India Sent 2006 10 13 Fri 12 22 PM H ea d er To choudhurya searo who int nfo rm ati 0 n Ce Attachments Tmp pvr cpy Tmp pvr cpy Respected Sir Please find attached herewith the updation for the locked data beyond 75 days We request you for approving the Message contents DTO Hyderabad district reading pane Andhra Pradesh state Upload data Exit Fig 35 e To select only E mails like UNREAD Mails or READ Mails click on bulleted buttons encircled Fig 35 The UNREAD mails are shown in bold and
59. w multiple variables can be selected to define the necessary parameters for the desired report There are 2 sheet tabs in the report selection window Tables tab in Report Selection window generates tables for the required criteria and Charts displays the performance indicators graphically Fig 46 m Report Selections Tables Area selection C State wise C District wise Start period From End period Ta Quarter Select a quarte Quarter Select a quart Year 2006 Year 2006 Summary of data for the entire period Show Cancel Fig 46 35 gt The different variables displayed in the Tables sheet tab are explained below e Area Selection If All States and All districts are selected then the report would be displayed for the entire country If a specific state but all districts are selected then all districts in that specific state 1s displayed in the report And if a specific state and a specific district from the specified state is selected then the report is displayed with information from that particular district only e Summary Level This selection criterion is to display the report summarized on either state wise or district wise or TU wise e Start Period From To define the starting period for the report The mentioned quarter data 1s included in the report e End Period To To define the ending period of the report The mentioned qu
60. wbudj QR New and updated data from Epi Centre 200671278 Fri 12 DTC Purulia QR New and updated quarterly data from E 2006 1278 Fri 4 2 DTC Purulia QR New and updated quarterly data from Epi Centre 2005 12 8 Fri 4 39 PI dtowbudj QR New and updated quarterly data from Epi Centre 2006 12 8 Fri 4 48 Pl D T C S DAKSHIN DINAJPUR QR New and updated quarterly data from Ep 2006 1278 Fri 9 3 dtcsmid QR New and updated quarterly data from Ep 2006 1278 Fri 9 4 v lt From DTO JALORE To quarterlyreports tbcindia org Ec storj tbcindia org rconsultants tbeindia org Attachments Epi Centre cpy Sent 2006 12 30 Sat 11 55 Respected Sir Please find attached herewith the new and updated quarterly data from Epi Centre software Thanking you DTO Jalore district Rajasthan state Upload data 2 Exit Fig 56 After uploading all the records from the email attachment the email is moved from the Inbox of MS Outlook to Epi Centre mails folder in MS Outlook The email summary list is also refreshed in Epi Centre by removing the uploaded email from the summary list So once all the emails are uploaded then the email summary list becomes empty e Click on EXIT button to quit from RETRIEVE EMAIL DATA window Note The 29 Status of requested approvals National level users uses this option to approve or disapprove email request received from the districts to permit them to chan
61. x AN TE dor t ku e proceeding Please provide all necessary information for customising this software and completing the installation process If you fail to provide any information that is required Epi Centre may not function normally later During this process if you feel that you donot have certain information press Cancel button to abort the process Installation location District X Select the state Andhra Pradesh v Select the district Select the consultant who is assisting this district Fig 12 DISTRICT option does not activate till you select a STATE Names listed in District field are based on State selected previously e Click on NEXT Fig 12 e Congratulation screen is displayed Click on FINISHED to complete the customization process Logon Information Dialog box appears Fig 13 m Epi Centre Logon Information Type username and password Log on as Data Entry Operator m OK Cancel Fig 13 e Since there are no users created yet so for the first time logon with the following information and create users as per your requirement User Name admin Password nimda Log on as Data Manager Please note User name and Password are not case sensitive e Please remember to create users immediately after successful first time login To do this click on Utilities Admin Tools from the main menu and refer to page no 48 for details on how to create users

Epi-Centre User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents