Home

InterCON 1.0 - Romanian Family Health Initiative

1. www inter con ro 27 5 Exporting Data and Reports Printing The information in this section might not be applicable to all users since following the instructions below may produce different outcomes depending on the Operating System Internet browser and MS Office package running on the user s computer All the same it presents general instructions that may be adapted depending on the situation If the mouse is placed on the tables inside the report a right click on the mouse will produce a menu that contains among other options the option Export to Microsoft Excel after selecting this option the respective table will be automatically opened and paged in Microsoft Excel This option is available on systems running under Windows XP but is not restricted to that E Formular Trimestrial de Raportare si Comanda a Contraceptivelor Gratuite Microsoft Internet Explorer Elle Ede Wew Favorites Tools Help d Formular Trimestrial de Raportare si Comanda a Contraceptivelor Gratuite pentru Directia Judeteana de Sanatate Publica PRAHOVA Trane stra 4 Anul 2006 Ingectabil A Contraceptive gratuite Depoproveral B Umtate de masura Fiola cu sennga Stoc la inceputal MET rului 0 00 Th ani m cursul D nismestrulu 99090 Total eliberate catre E cabinetele MFPFin 1 o rursul time stabi t Ajustari de stoc 7 CSD ESF Total distribute de Select Al H cabinetele MPPFin
2. In this window look for the product for which the information is introduced then click the icon next to the selected unit The mouse must be placed directly over the above mentioned icon so that the cursor changes its shape After clicking the selection symbol the window is closed and the fields in the Aad Distribution Data screen Product section will be filled with the values corresponding to the selected unit It may take a few seconds until the fields are filled with the values corresponding to the selected unit Please wait until all fields are filled before taking further steps and before initiating a new operation To search the record pertaining to the wanted individual reporting unit the user may insert a few characters from the name of the product in the box on the upper side of the window then press Tab or click outside the box The list that will be automatically generated will include only the records fulfilling the search criteria In order to fill in the list again with all available records leave the filtering box empty and press Tab or click anywhere outside the box 3 Entering data in the fields of the Stock section Depending on the Individual Reporting Unit for which the user enters data some fields are activated or deactivated the values in the deactivated fields will be automatically calculated by the software Year and Month these data items deal with the time component of the stock appropriate
3. e UNITAT ELT II NCHA ACW VALE FTT ETT Tel ln Poli LE m e dcm EIL iW spen pee f L L ETH RAPOARIE Copyright 2006 TSI amp SECS gt E Done Local intranet This module allows viewing searching modifying and deleting data concerning ndividual Reporting Units recorded The page is structured in two sections the search section where the data filtering criteria can be introduced and the viewing section structured in a table format The viewing is restricted to seven rows per page in order to go to another page the user must click on the corresponding number at the bottom of the table Searching data this operation is done by inserting the search criteria in the free text fields and or by selecting pre formatted options in lists available for some of the fields and then clicking on Search The Cancel button brings the search section back to its previous condition by erasing the fields in case of the first search or brings the initial search criteria back in case of a new search If no records in the database are found to correspond to the introduced search criteria a warning message will be displayed as follows There are no records corresponding to the chosen search criteria www inter con ro e In the text fields that define the record search introducing a few characters of the desired value text information are enough to trigger the search operation it is not necessary to i
4. Brief Glossary Advanced processing Alpha numeric Case sensitive Database Non editable Parameters Values list Web based Web browser Automated data processing performed by the application that is triggered by the user when clicking on the Save button in the pages of the application where this button is present Saving is not usually perceived by the users but while attempting saving there are cases when the application generates a list of errors and messages in front of the current page In such cases the user should re access the menu and should fill in the data again trying to avoid the highlighted errors If the application generates errors unspecified in this manual the application administrator must be immediately informed May contain both letters and figures Distinguishes between upper case and lower case A system that allows information data to be saved and offers the possibility of searching retrieving and or modifying the data items Refers to a section of a page accessed by the user that has only an informative purpose and can not be modified by the user Variables whose value determines a specific behaviour in the specific context they are used in Different values of a parameter will determine different behaviours Succession of values ordered by a logical criterion out of which the user can choose one version at a time An application running on the Internet and accessible t
5. 12 Deleting data records this operation is done by identifying the units with data that the user wants to delete in the viewing table followed by clicking the icon from the Actions section A confirmation message will be displayed to verify that the delete option wasn t selected by mistake By clicking on the OK button in the window the record will be deleted from the database The application will update the viewing screen and the deleted record will no longer be displayed Microsoft Internet Explorer 2 Sunteti sigur ca doriti stergerea inregistrarii curente e There is a hierarchical subordi nation relationship between the individual units and the DPHA unit meaning that the DPHA unit in a district must not be deleted as long as there are individual units recorded for the same district Such an action will generate the following error message DPHA unit cannot be deleted while there are inferior units recorded www inter con ro 3 Distribution Data This module can be accessed by clicking on the link Distribution Data from the menu on the left side of the page The module facilitates the easy secured and computerised administration of distribution data submitted by the reporting units It allows easy display of historical data alerts users concerning stocks that are in danger of expiration and fastens and standardizes data reporting The submenu from the upper bar of the page is structured in Ad
6. Data e retreat a Nummar furnizor care iiu au minds rapoartele de consum Nr de rapoarte tase B oo B a ate carene pe fini OA BI PP fi rapoarte care ma wa font rimase CIA 14698 341 537 Contraceptive distribuite cu PLATA Rule 26 7 2007 12517 w T gt Dore a 4 To view the Quarterly Reports for contraceptives distribution for other districts user should access the RAPACCES section of InterCON see information on the access module in the first part of this user manual 2 Annex 2 Report Annex regarding details on contraceptives dispensed This report incorporates part of the indicators that are reported by DPHAs to the central level every quarter it contains the following information quarter and year to which the report refers to the quantities of contraceptive products COC POP IUDs injectables condoms that were distributed during the quarter costs per category of products total number of theoretical beneficiaries CYPs mean cost per CYP and total costs per quarter broken down per products received from donations or from governmental procurements In order to generate this report see image below type in the year select the quarter of interest from the list and click on Run Annex 2 Report www inter con ro He LO Windows Internet I m G hec i 179090 nde oho voro eel e meto ina R gt e mm de Susp Rapoarte j ES secs Raport Luna
7. Inbox for ana vas amp 12 Lou Reed feat T start m 4 Windows Exp I MINISTERUL SANATATII PUBLICE FROM THE AMERICAN PEOPLE Luni de Data stoc introducerii isponibil D 2006 01 000 boo Doo 2990 7 1000 Depoprovera2 12 2006 01 09 2007 990 00 ooo 000 0 00 2990 00 889 87 eb Send tow g Settingsw x E ans sv Games v X Tip Pers E S USAI En amp wes e D Music w Utilizator PRAHOVA Data 1 12 2006 InterCON 1 0 User s Manual Title InterCON 1 0 User s Manual Author Eng Alexandru Stanica software systems engineer The specialists who contributed to the different stages of elaborating the present document are presented below in alphabetical order Violeta Cindea MD Regional Coordinator SECS Cristina Coca National Coordinator SECS Adrian Cozma MD Regional Coordinator SECS Lia Cseke MD Regional Coordinator SECS Borbala Koo MD Executive Director SECS Adriana Melnic MD Regional Coordinator SECS Patricia Mihaescu Program Coordinator JSI R amp T David Papworth Sr Technical Advisor JSI Inc Dr Magdalena Patruleasa Program Coordinator JSI R amp T Rocsana Ristea Regional Coordinator SECS Venera Runceanu Database coordinator SECS Laurentiu Stan MD Program Coordinator JSI R amp T Nicolae Tarba MD Regional Coordinator SECS Ana Vasilache National Coordinator SECS 2007 JSI Research
8. 48 30 45 32 10 soms 55 92 sol 589 69cM6 60 59 32 X 59 Jcamerpri 45 55 sol 30 canera 50 sol sol se 14 denner ers 32 32 32 a n M o4 MY ID Lista UIR stoc exced 11 Lista UIR stoc insuficiente 12 Lista UIR stoc adecvat 1 4 Gata SS NENNEN NENNEN I NENNEN NUM www inter con ro 8 Perishables stock adjustments report per providers per product This report is generated for the district level and shows only providers that have reported products with perishable stock adjustment This report is very useful because if district program managers notice that certain service providers have substantial or repeated stock adjustments due to losses they will have to study what their cause may be it alerts the coordinator of free contraceptives distribution so that he she can take the necessary corrective measures depending on the specific situation For instance it is possible to have a batch of products with many missing products then the warehouse administrator must break the seal of the boxes and count them before distributing them to the service providers Microsoft Excel Rapoarte generate de intercon xls fad ai s B i u H4 g bio ti D n Dea GAT AMR 0 ANR Bm e ta ta ta d0 6 2 gd Mi STA GOR IRN Fou cene oi da dpa V x B5 amp CM i A B C D E F G 1 FURNIZORII SI ACELE PRODUSE PENTRU CARE AU EXISTAT PERISABILITATI
9. 5 Distribution reports per method and per district This report is generated for the national levels and presents the total quantities of contraceptives dispensed by the services providers in a certain district over a certain quarter broken down by method COC POP injectables condoms and IUDs E Microsoft Excel Rapoarte generate de Intercon xls Arial 2 BIU FSH S kmp fe Uu BRUN A Dc e s MB SF oo amp r NHi ww g Desen wera sitenare EMT rp Ba5 22 A zSsSBa Ea f fa a A Da Ka i ki de Ya RAspuns cu modific rs bire 7 EE pa Editare Mizualizse Inserara Format linstrumente Date Fersastr Ajutor Tastati o intrebare z F X f BACAI B G D E F G H F Consumuri in trimestrul 200 in 41 de judete si Mun Bucuresti 4 Nr Judet COC monofazic Injectabile aaea 145000 1200 soo 85400 150 6 2 ARAD 25 00 1 000 1500 100 000 250 7 3lARGES o 15500 800 2500 50 err 4 BACAU 17 800 1 500 1 000 48 700 25 g SBHOR 38 100 2 500 1 200 22 500 75 10 6 BISTRITA NASAUD 44500 1 000 1 000 120 000 225 z BOTOSANI 85 000 22 500 150 42 8 BRASOV 12 500 1 a 15400 79 43 9 BRAILA 10 500 ol em 2 ms 28 400 250 44 10 BUZAU 24 000 1 000 15 400 100 45 11 CARAS SEVERIN 10 000 1 200 1 200 22 500 25 a mau 4 Cc distrib per per metoda la ASP 6 Stocurper metoda la furnizor 4 ar This report can be accessed from the RAPACCES section of InterCON 57 www inter con ro 6 Distribut
10. Inter ON 1 Login Windows Internet Explorer Autentificare InterCON 1 0 InterCON este o aplicatie intemet destinata si Er ogic 1 0 Microsoft Internet Explorer distnbutiei de contraceptive fumizate gratuit p lt File National de Sanatate nr 5 prin automatizarea activit Edit View Favorites Tools Help catre nivelul national precum si a monitorizarii activi Qe x AAS Initiativa elaborarii acestei aplicatii apartine Minist ad Rel Nw 7 Search g Favorites ps iu er e puna la dispozitia autoritatilor de sanatate publica j Addr D cv secs ro 93 n w de folosit de catre orice utilizator autorizat care sa st CeV secs ro 93 s secsccv index php a a timp real a informatiilor privind distributia contra 4 SOS TUNIS B8 Go Links fumizorii de servicii de planificarea familiala Apli a a Mi Go amp Ve Bookmarks v PageRank Popups okay heck Link Informational de Management Logistic al N n a EI s okay Y ONE 5 Autor il e Sendtow O Settings contraceptivele gratuite Y vi Search Web 2 Ely i Q c3wa QUAE Chiar daca aplicatia a fost dezvoltata pentru a Utilizator PRA T ti are nevoie a ator PRAHOVA contraceptivele cu distributie gratuita datorita flexit Adaugare Unitati Individuale de R ortare Vizualizare Actualizare Unitati Individuale de Raportare Data 1 12 2006 cu usurinta si pentru raportarea altor produse cul mmt Se niat individuale de Raportare n
11. values for the year and month when stock was observed should be selected from the two available lists Any operation concerning the distribution data corresponding to any reporting unit and to any product is permitted by the software only within the current quarter plus one month but never in advance for instance if we are in the 10 month of the year www inter con ro 15 16 2006 an operation on stocks is allowed only for the months of the previous quarter 7 8 9 and the stocks for the current moths the 10 of 2006 Thus the field Year is filled in with the value corresponding to the current year an exception appears at the beginning of the year when users can enter data for the month of the current year and for last three months of the year ended In the field Month the user can enter data for the current quarter namely for the months equal to or smaller than the current month or to the current month plus the months corresponding to the previous quarter when the current month is the first month of the current quarter Initial stock this is a non editable field date cannot be typed in whose value will be calculated automatically it represents the final stock for the last month entered in the database If no distribution data was introduced for any of the months then the field is automatically filled in with the value O Entries this represents the quantity of a certain product received by the reportin
12. 0722568524 Hrl 1 BUCURESTI SECTORUL 2 BUCURESTI at Tanasescu Irina 334 0744200950 Pantelituan Nr Sos 3 BUCURESTI BUCURESTI BUCURESTI 3 tal Sf PF m 340 Medie Chireulesco Podica 123 rodicaclurculesc ui vahoo com 758370454 Pantelimon igector 2 i BUCURESTI MUNICIPIUL CMI Lumuruta Luminita o 10 BUCURESTI SECTORUL BUCURESTI Wen CMI Aue I vom BUCURESTI MUNICIPIUL n To view the Providers Lists from other districts the user should access the RAPACCES section of Inter CON www inter con ro 5 List of units with exceeding stocks on hand per method This report is generated for the district level and shows only providers who have a number of months of stock available as stock on hand higher than the one allowed by the logistics system higher than 6 months This report helps to prevent expiration of contraceptive stocks with service providers it draws attention to those providers who if continuing to have a mean consumption similar to the most recent ones won t be able to dispense the products before the date of expiration see image below E Microsoft Excel Rapoarte generate de Intercan xls Arial 10 BI U SSS BI So Ee WA De Me SAP E60 amp r HN As B ita fg Tg 2d Vh X3 wj ki gel Wy pL Aer ins cu modifichiri FArsit reni re E m Fisier Editare vizualizare Inserare Format Instrumente Date Fereastr Ajutor Taskati o intrebare Hmx B5 fe Chili FURNIZORII CARE AU UN NR DE LUNI DE STOC
13. AJUSTARI DE STOC 2 3 4 el D i EC MI zano E a lil E E n www inter con ro 45 9 Stock on hand at provider level per product This report is generated for the district level and gives the list of providers together with the stocks on hand per product e g LoFemenal 8 Marvelon 10 etc specific for each service provider The month or the quarter may be selected to generate a certain report Microsoft Excel Rapoarte generate de Intercon xls T 0 RS SSSH OX me Ee dei Dclu amp ea timA amp teo amp 1 2 Bam 0 ta a ua B Jigit 2 Man eis aas quud Feud alc Mgr mesh dd asta o treba EX ALIS_ 5 l UIR per prod Sb Lista STOCURI UIR per metoda f 10 Lista WIR stoc ex 4 f AT ne eee M O4 H S Lista STOCURI 46 www inter con ro 10 Providers stock on hand report per method This report is generated for the district level and contains a list of providers with their stocks on hand of contraceptives per type of method COC POP injectables condoms IUDs The months or the quarter may be selected to generate a certain report E Microsoft Excel Rapoarte generate de Intercon xls Arial x B z U E z Hi 9 4 3 Pd dA Dc 83 bee SF orm Br 85 Mam 2 a fa ta ad Vh Xa 3 Mo erica cu modifichi Sf r it revizuite V W Fi ier Edare Vizuslizre Inserare Format Instrumente Date Fersastr amp Ajutor Ta
14. De Distnbute A Contrateptweior Gratute LE qo Antonino VIR ALEXANDRESCU CAMELIA v Rulesza ine Co 4 Raport Lunar Prind Unitate Ce tiu Au Fumizat Rapoarte De Consum RI An Luna CY Y YMACY Y YMM Rweaza Lista Date Orstributw UNTATI Aniuna YYYYM YYYYMM p Rapor T nmesinal De Distnbune Comanda A Contraceptrveior Gratute e An YYY Y Trimestry UIR ALEXANDRESCU CAMELIA lt Rueaza DATE Rapoarte Dwecka De Sanatate Pubic a F oermular Trimestral Si inde aton DISTRIBUTIE e An vYYY 2007 Trmestru B a anca Tapi eH http 4 80 86 123 91 90 Indicatori Anexa Mozilla Firefox P Qm te Tipul mumarul si costurile contraceptivelor distribuite per trimestra www inter con ro 36 For easier processing data in this table can be copied to a Microsoft Excel spreadsheet To do so open the report select it by clicking on the page and pressing Cirl A at the same time then press Ctrl C at the same time Open an Excel spreadsheet and press Ctrl V at the same time The report will be completely copied in Excel If you want to view Annex 2 Reports for other districts go to RAPACCES section of InterCON B Reports used at district level for program management 1 Monthly report on free contraceptives distribution This report is similar to the paper based form used by the service providers to report to DPHA on their monthl
15. E mit Pubkce Autontatile de Samatate Publica Judetene ROGUE AZ Sanatati Publice e Raportati once dizfunctionalitate sau suspiciune de atac admmnistratorului SECS IST Inc USAID A S USAID ESE SOCS Se CH iem i DEN PA RWGAGCONSG LS PEP ETEN 4 L3 ni a Jai RAT dici p ach sat B fop mazutrata D Sockets da ESccatie Contraogctheb si Sex BIB SETE pi Sstitutui se Cernetane si Formans John Son ine in cee pager dia initiative pentru Eerste Familia in Berrie program nabonal al cm sono prroral araba apr nies Mer dana Sarata Subiti ir asigurarea consu populistai dir Romania ta seniai cg pianificare lare hala sar atatea Serco Geri Realizata aaa Dore amp 9 Internet 100 e Do not open multiple web browser windows with this address If you try to connect simultaneously from more windows on the same computer it is possible that the application will work abnormally and the user will receive warning messages signalling that it is not possible to connect to the application e Using the browser menus and the toolbar options is NOT RECOMMENDED except for the printing option from File Print or by Ctrl P combination of keys as it can generate unwanted behaviours from the application Use only the buttons links and options incorporated in the application s menus The authentication page of the application requests that the user enter a user name and a password This confidential information is communicated only to authorized users b
16. PE METODA CARE DEPASESC CELE 6 LUNI MINIME ADMISE CALCULATE PE BAZA CONSUMURILOR MEDII DIN ULTIMELE 3 LUNI e n case of imminent product expiration the measure to be applied by district program managers is to withdraw the exceeding stock from the respective service provider and to re distribute these products to under stocked providers 42 www inter con ro 6 List of units with insufficient stocks on hand per method This report is generated for the district level and shows only the providers who have a number of months of available stock as stock on hand below the one allowed by the logistic system smaller than 3 months This report helps program managers to ensure continuity of contraceptive supplies and stocks where they are most needed namely at the provider level More precisely it offers information about dispensing units service providers that need to be re supplied as soon as possible EA Microsoft Excel Rapoarte generate de Intercan xls LE Arial 10 B 7 U SSS mi Pe A A EAEE T EAE EERE F a ta ta A a G Vs Yeras cumodcin s rsk reviure m Fisier Editare vizualizare Inserare Format Instrumente Date Fereastr Ajutor Taskali o intrebare F x A16 C F Fa FURNIZORII CARE AU UN NR DE LUNI DE STOC PE METODA CARE SUNT SUB CELE 3 LUNI MINIME ADMISE CALCULATE PE BAZA CONSUMURILOR MEDII DIN ULTIMELE 3 LUNI Prezervativ Eno monete Po Inpectalile te CM1 O sees os 8
17. by month It is recommended to avoid as much as possible entering all data for the quarter at the end of the reporting quarter Data cannot be recorded for the month k May for instance of a quarter if there are no data recorded for the month k 1 April If there are no information concerning the distribution data for the month k 1 then these can be inserted with the value 0 and modified later on this approach can be used only in exceptional cases and only after consulting with the superior level Exceptions are the first months of each quarter whose data are not conditioned by data recorded for the previous month In these cases the initial stock is computed based on the final stock of the last record or it is O if no information were recorded in the database up to that moment Whenever this restriction chronologically data entry is not respected one of the following error messages will be displayed e There are stocks recorded for the following months Data record must be chronological To record data for the current month you must delete the data for the following months Or e The stock for this unit and this product is not recorded for the previous month or e Please check the month and the year for which you want to delete distribution data These operations are no longer allowed for the current selection Recording distribution data e g for a new product in the database must start with the highest ranking
18. con ro 55 4 Stock on hand at provider level per product and per district This report is generated for the national level and presents the cumulative contraceptives stocks on hand available at provider level by type of product e g LoFemenal 8 Marvelon 10 etc and by district by the end of a certain quarter see image below 1 Microsoft Excel Rapoarte generate de Intercon xls o Arial 2 BZU amp SH mt SER A D gt BR SRY SEO Soru amp r A E MIA 0 iil tl D Desen gt l Fomeauomxe O E 4d go db A S5 ta fa 82 4 C GS yz g We Rasp modfichi pr sil vizu D G Fi ier Edtare Vizualzare Inserare Format Instrumente Date Fereastr Ajutor sti o intreba o_BPX D7 fe 47250 a E EF B Stocuri la nivelul furnizorilor la sfarsitul trimestrului 200 in 41 de judete si Mun Bucuresti Nr Judet X LoFemenal3 LoFemenal 4 LoFemenal 5 LoFemenal LoFemenal 7 ABA 25325 0 0 0 25 325 2ARAD 47250 25325 0 o 47250 ARGES 25200 472560 of 0 25200 8 BACAU 21400 2520 0 21 400 o 9 SBIR 25 325 2140 o o 0 10 GBISTRITANASAUD 47 250 o o o 0 11 7Borosw 25200 o o o 0 i2 8prasov zao o o 0 i gerana oA o aas o o 14 __10 BuzAu o o aa o 0 EX ay Lo iS yc Ie TER 4 Cc detrib pe TT i 200 n P Gata NUM This report can be accessed in the RAPACCES section of InterCON 56 www inter con ro
19. consumption rate is maintained the quantity distributed during the last 3 months mean monthly consumption months of stock available the date when the record was entered in the database In order to generate this report type in the year and then the number of the month from 1 to 12 without blank space between them and click the button Run located next to the List of Distribution Report see image below fo Logic 1 0 Windows Internet Explores o OF nni m 122 9 Rae re ote Xx il na dux 1 0 PO e up j too E EE B USAID a E UE secs Raport Luna De Datnbube A Contra eptimelor Gratute BRE R ia Lud amem ey rm ga Antuna Y Y YYM rnrYvY MM WR ALEXANDRE SDU CAMELA Rueaza ImterCON10 ns ZII NM Raport Luna Prind Unitatte Ce Nu Au Fungal Rapoarte De Consum AniLuna V VYYM YYYYMM Pusara Lata Date Desire Re Lista Date Ces UNITAR An Luna Y YY C MODI EYTMIM Ruteaza fi AM Rapat Tomestnal De DestribumeComanda A Conia epre Gratuite Lj An Y vvv Trimestru UR ALEXANDRESCU CAMELA w Rueara DATE Rapoarte Corrects De Sanatate Pubica Formulas Trimestruai Si nda Moni i DISTRIBUTE d An YYYY 2007 Trmestru B Rubeata Raport Trimestrali e Ru eaia Raport indicatori LI cee lieta bee om m ane Moye i NO a Ruleaza Raport Anexa2 ma mei Ruleara Raponi Restanteri Pes N w Done amp v Interrupt 100 www inter con ro Example Listing of Distributi
20. must fill in the time parameter e g in the format 20071 for the report pertaining the end of January 2007 to be generated prew 1 Mozilli http 80 86 173 91 90 Raport rapoarte consum Mozilla Firefox Luna 20071 2007 28 02 2008 mo 2007 31 12 0007 0 2007 30 06 2009 99 00 2007 31122007 4000 dd 2007 30 06 2009 338 00 0 00 2007 3105 20080 00 2007 23 02 2011 I 2007 30 04 2013 0 00 2007 30 04 2007 0 00 2007 311212007 o 2007 311272007 p o 2007 31 10 2007 1 00 Reports from the District Public Health Authority Quarterly Report Order Form and Indicators Reports This report contains a group of five DPHAs reports Quarterly Report Indicators Report Annex 2 report Overdue IURs report Distribution Data Report To generate any of these of reports two parameters are needed reporting year in the format YYYY for example 2006 the quarter of interest selected from the pop up list available For viewing the report click the animated button Later you may choose from one or more of the options below a By clicking the button Run Quarterly Report E Ruleaza Raport Trimestrial E a report as shown in the example below is generated 3 This chapter presents the most important reports generates by this facility while the remaining reports that were developed in more advanced version of the application are presented in forthcoming chapt
21. system 1 Quarterly report on distribution order of free contraceptives 2 Annex 2 Report Annex regarding contraceptives distribution B Reports used at district level for program management Monthly report on free contraceptives distribution Quarterly report on distribution order of free contraceptives Indicators report FP services providers report List of units with exceeding stocks on hand per method List of units with insufficient stocks on hand per method List of units with adequate stocks on hand per method Perishables stock adjustments per product per provider Providers stock on hand per product 10 Providers stock on hand per method O 0 NODOUIDSWNN C Verification reports used to check the correctness of data entered in the database 1 Listing of distribution data 2 Monthly report on overdue units units that didn t submit consumption reports on time 3 Quarterly report on overdue units D Reports for the program management at national level 1 Stock on hand at district level per product 2 Stock on hand at provider level per method and per district 31 3 Stock on hand at district level per method 4 Stock on hand at provider level per product and per district B 6 Distribution reports per method and per district Distribution reports per product and per district www inter con ro 32 Some of these reports were already presented in chapter 4 of this user manual In th
22. unit followed by other units in decreasing order of the reporting rank as figured in the box below Nivel central de management al obiectivului rang 2 ASPJ rang 1 U UIR rang 0 www inter con ro 19 20 Thus the data on quantities of each product that enters the logistic system must be recorded under the central level first after that the software can record the transactions of the district warehouses with DPHAs only after the previous step is completed can the district operator proceed with entering transactions reported by the IRUs in the respective district If this order is not obeyed and the user introduces information on a certain product for a certain reporting unit before entering the corresponding information on stocks of that product entered at the superior level the application will display the following error message The distribution data for the superior unit are not introduced If such a situation occurs while you have the product in your warehouse please contact the higher ranking unit Entering updating or deleting distribution data at a certain level leads to automated modifications for the quantities of product with the superior level that are made according to the following formulas Exits from a certain Sum of the entries at units situated reporting level k one level below Z entries at level k 1 Initial stock for month j Final stock for month j 1 In the viewing section th
23. 1 2s os CMI 4 25 oe 27 25 ENNECTE 28 28 29 24 sem 6 sel 24 24 95 o slenaner ra 25 25 281 27 24 a ac 29 28 sl 2s i 4 Hj i0 Lista UIR stoc exced 11 Lista UIR stoc insuficiente 12 Lista UIR stoc adecvat 1 TS Gata NUM www inter con ro 43 44 7 List of units with adequate stocks on hand per method This report is generated for the district level and shows only the providers who have an adequate number of months of stocks as stock on hand available namely between 3 6 months of stock available calculated as per the most recent quarterly consumption rate e As shown in the Logistic System Procedures Guide under the current design of the Romanian logistic system for free contraceptives having available stock for 3 to 6 months of consumption is optimal for ensuring continuity of product availability at provider level and thus to prevent stock outs F1 Microsoft Excel Rapoarte generate de Intercon xls Arial 0 B ZI U zm xwx ii5 x 7U m 5 A D a Eb ARF X GR oe A EA M AA i 3 Ea fa fa d V Ma IM get Pe R spuns cu modific ri SFR Ure a amp Fisier Editare vizualizare Inserare Format Instrumente Date Fereastr Ajutor Tastabi o intrebare _ 7 X B5 hi f amp CMII A B E D E F G al FURNIZORII CARE AU UN NR DE LUNI DE STOC PER METODA CARE SUNT INTRE 3 SI 6 LUNI DE STOC ADMISE CALCULATE PE BAZA CONSUMURILOR MEDII DIN ULTIMELE 3 LUNI 9 aema
24. Clinics etc district level that refers to the District Public Health Authorities DPHAs local health authorities in Romania e central level The submenu from the upper page bar has two options Add and View Update www inter con ro Adding Individual Reporting Units Logic 1 0 Microsoft Internet Explorer Fie Edt View Favortes Tools Help E Q O ig fb Pret reme 5 2 I L ory Address al hitpzl ccv secs ro S3 secsocwfindex php a 5 eb Google Ce Goo dt E FF Bokmaks Cem Gi Popups cher SP check AutoLink AuboFil mp Send toe _ Settings YI d w Seachweh gt Comal A Shopping Gry ramen EPansaers gh Games d Musie gt l teisrstar PRA HUI A Data 1 12 2006 a a a B Suo Adaugare Utat ladiiduale de Raportare es SCC roducere Dale Cabinete individuale De Raportare linterCON 1 0 Info Unitate individuala I Nume Unitate _ Tip Unitate Cabinet PF cli Localitate ADUNATI ADUMATI Cod Postal 107005 LIMA TI Adresa INDIVIDUALE RAPORTARE e info Persoana Contact Tip Pers Contact Medic LATE DISTRIBUTIE Nume Pers Contact Prenume Pers Contact e Teleton 0244 Emal TMo RAPOARTE A Nr Asigurati Baciatataa de Educate Contraceptiva si Saul a This facility allows for the addition of new data concerning the Individual Reporting Units The page is stru
25. E lispponih Fa irr Achim Mepoprovers 12 200601 09 2007700 000 200 000 300 504 500 147 299 0112006 Fa a e Lofemena 12 200631082007 70 00 Doo 1500 DOO 5500 4338 50 1500 367 012 2006 DISTRIBUTIE 2 Adela purus Prezervatv2 12 2006 3L 0L 2007 140 00 DOD 3000 D00 nooo 371 700 BR 40 01 12 2006 L FE E AA Depoproveraz 12 2006 0 09 2007 299000000 O00 DOO 299000 229 27 1000 333 E9790 1 12 2006 Rannan 2 PEA Depoprovera 12 2006 23 02 2008 3000 00 0 00 000 000 3000001357 000 000 ow 01 12 2006 17 FE AA Liepoproverad 12 2006 SLOT 2008 2000 00 0 00 Don 000 3000 00 19 00 0 00 0 00 0 00 D1 12 2006 PE P E Depeprovera 12 2006 28 02 2007 300000000 000 ooo 300000200 6006 pan 000 01 12 2006 Societatea de Educatie Contraceptives zi Sexusla i 45 PEC Ei si JI www inter con ro The screen corresponding to this facility is structured in two sections search section where the data filtering criteria will be typed in and view section structured in a table format Initially the screen only contains a search section the view section becomes visible only after introducing search criteria These criteria must be introduced in such a way that the number of records to match the search criteria will not exceed 140 records Otherwise the following error message will appear on screen Too many records correspond to your search criteria Please make a more restrictive criteria set The view mode is restricted to
26. The initiative for the elaboration of this application belongs to the Ministry for Public Health in its goal to provide public health authorities with a reporting instrument user friendly for any authorised personnel It permits accurate and real time consolidation of information concerning the distribution of contraceptives offered as a gratuity to the clients of the family planning services providers The application is a part of the national Logistics Management Information System for free contraceptives The initiative for the elaboration of this application belongs to the Ministry for Public Health in its goal to provide public health authorities with a reporting instrument that is user friendly for any authorised personnel It permits accurate and real time consolidation of information concerning the distribution of contraceptives offered free of charge to the clients of family planning services providers The application is a part of the national Logistics Management Information System for free contraceptives History of modifications Version Date Modified pages Description of modifications Availability and updates of the document Location of the document The most recent version of the document can be accessed at the address www inter con ro The InterCON 1 0 application can be accessed at the address www inter con ro Any comments and suggestions regarding the improvement of this document can be addressed to Mrs Ana Vasilache
27. a si Forman Jahr Drow ine n amara program ulus Initiative pentru Bereta Famila in Berges program nebonal al asno sono pnnopa ese apr rem ir dara Tarpa Pubis it adigurar amp s aaa lui posoiatai dir Romania ta serii cg plarificare bare hala car atatea meetotiuogni Faalizarea soere PELO II EI IL I L I RE II RE RITIRI III RE TIPAR E T M TI ITA one Qr ion e From the pop up menu that will appear on screen the district of interest can be selected after selecting the district click on Confirm the user will be directed to the page where the Reports of the respective district can be generated see the image below 30 www inter con ro This section contains the reports generated by InterCON at each district level Logic 1 0 Windows Internet Explorer CIEN Bia e e Bine ati venit Sunteti conectat cu userul RAPACCES Din motive de securitate unele pagini ale acestui site sunt valabile doar o ora In cazul in care o pagina expira va fi nevoie sa va reconectati Accesati modulele aplicatiei din meniul de pe bara din stanga paginii Meniurile aplicatie sunt afisate astfel incat se poata fi accesate la once moment indiferent de pagina curenta Submeniurile corespunzatoare fecaru modul sunt afisate in bara de sus a paginii The reports generated by InterCON 1 0 can be grouped in four categories A Reports sent by DPHA to the higher ranking level of the logistic
28. accessed from the RAPACCES section of InterCON 3 Stock on hand at district level per method This report is generated for the national level and presents the contraceptives stocks on hand by method COC POP injectables condoms and IUDs available in the DPHAs warehouses at the end of a certain quarter see image below ti Microsoft Excel Rapoarte generate de Intercon xls Arial 2 BIU z35EH Sem 3E AA Des St BIS wr Hi wj B Desen Forme automate DoBA Tia de A S2 EB ta fa te d Ba At RL adfici Sf rgit re _ I Fiser Editare Wizualizare Inserare Format Instrumente Date Fereastr Ajutor stati o intrebare B8x F12 fe 15400 LAL e eee ee ee ee E E G E Stocuri la ASP la sfarsitul trimestrului 200 in 41 de judete si Mun Bucuresti 4 Nr Judet COC POP Injectabile Prezervative DIU s 1ALBA 4500 1200 1 500 8540 150 7 3ARGES 15500 800 2500 50000 145 9 4BACAU 17800 1 500 1000 48700 25 9 S BIHOR 38100 X 2500 1200 2250 75 10 G BISTRITANASAUD 44 500 1000 1 000 120 000 225 BOTOSANI 85099 120 eo 2250 150 15400 79 a sBALA osoo soo 250 28 400 w iopuzau 24000 18X 100 1540 too 15 11 CARAS SEVERIN 10 000 1 200 1 200 22 500 23 5 M 4 Mid 4 Cc distrib per metoda 5 Stocuri per metoda la ASP 4 amp Stocurper metoda la furnizor am This report can be accessed from the RAPACCES section of Inter CON www inter
29. amp Training Institute Inc Romania Representative JSI and The Society for Education on Contraception and Sexuality SECS This manual has been developed by the Romanian Representative of JSI Research amp Training Institute Inc JSI Romania and The Society for Education on Contraception and Sexuality SECS within The Romanian Family Health Initiative program Parts of this manual may be reproduced and or adapted provided written permission is received from JSI Research amp Training Institute Inc and SECS or JSI Romania and SECS USI and SECS are acknowledged and any adaptations are sent to JSI Boston JSI Romania and SECS Please send a copy of all adaptations from this manual to JSI Research amp Training Institute Inc 44 Farnsworth Street Boston MA 02210 1211 U S A www jsi com romania Email office jsi ro and The Society for Education on Contraception and Sexuality 3B Dimitrie Racovita Street Sector 2 Bucharest Romania WWW SeCS ro WWW Sexdex ro e mail sediu secs ro This manual is made possible by the generous support of the American people through the United States Agency for International Development USAID under cooperative agreement 186 A 00 01 0010103 00 The contents are the responsibility of JSI Romania SECS and do not necessarily reflect the views of USAID or the United States Government Descrierea CIP a Bibliotecii Nationale a Rom niei INSTITUTUL DE CERCETARE SI FORMARE JSI Bucures
30. at the e mail address ana vasilache secs ro Signatories of this version of the manual Alexandru Stanica Software systems engineer June 15 2007 Ana Vasilache Program Coordinator Society for Edu i i 5007 cation on Contraception and Sexuality e Latest version of the User manual was issued in July 2007 www inter con ro 1 Introduction InterCON 1 0 is a web based application promoting automation and thus simplification of monitoring and analysis of the distribution of free contraceptives its use could be extended to other products with a free distribution regime The application has a modular structure and allows user s quick and easy access to all modules The interface is simple and ensures easy and safe data processing storage and retrieval The application can be accessed via the web browser authors recommend Internet Explorer version 5 0 or higher at the address www inter con ro Login Windows Internet Explorer i fer O y htp piia intercon ro wo A P n e iw tes Autentificare InterCON 1 0 d amp itnbune de contraceptie fumuzate ganat populate ebzb de im cadrul Programu Utilizator abona de Sanatate rr 2 pon automantarea actrvitati de raportare dmspre nm elul pudetean came mvehd national precum si a mormtonzam act tate de raportare Parola inmates elaborem acesiti apheari aparine A astern Sanatzhi Publice care a dort sa puna la dispozitia a
31. ationale de S http 80 86 123 91 90 Raj Ele Edt view m introducere Date Cal Securiti History Bookmar RAPORT FURNIZORI Inter CON 1 0 Info Unitate individuala e Asia e Uni 7 m popa d Nume Unif Logic 1 0 Microsoft Internet Explorer Acce r Judet Localitate File Edit View Favorit es Tools Hel 2 EMT a Localitate P sel NEAMT ADJUDENI cascade 7 ix ig PI Search Favorites ES x LJ or el Adresa Ac ire se http liccv secs ro 93 secscevlindex php O E IE UNITA TI eae Go ink 2 NEAMT ADJUDENI RA PIATSRE Google Gl Vo 645 E dy Bookmarks PageRank Popups okay Pm x 9 check gt N Autounk ry DI R pe sal info Pers 3E 2 Vj Search Web gt 9 Er mau f Shopping My Yahoo P NEAMT AGAPIA ae re pn Adaugare Date Distributie Vizualizare Actualizare Date Distributie NEAMT poa DATE Pas start H DISTRIBUTIE Nume ES SOCS SIRAT R amp T Telefon fo InterCON 1 0 Nr Asigut Produ Salveaza Societatea de Educatie Contraceptiva si Sexuala iJ Cauta Raportare Anuleaza i I Prev LAUD Distribuite Consum Es Windows Ex INDIVIDUALE Egi 3 luni lunar ems RAPORTA Achim 212 ORASENE ZE kdl Adde D cis jm Achim Achim B 12 M emm 0 00 PA n Adela Adela Omens T Depoprovered 12 2006 31 07 2008 3000 00 0 00 Societatea de Educatie 12 3 4 5 6 Contraceptiva si Sexuala SECS si JSI
32. ch as address telephone e mail To generate this report double click on the icon Hun next to the FP Services Providers Report see image below 40 www inter con ro a Logic 1 0 Windows Internet Explore G p ete ja 17 i php tas A pP GA Borso DO aop De ums f il HW Suso A a aD AnViuna Y Y Y Y M Y Y Y YMM L IE Ma J r SIE SOCS Lista Date Distrbube RAT AnLuna Y Y YYM YYYYMM Rueaza Raport Thmestnal De Destributie comanda A Contra epitve Gratuite InterCON 1 0 An YYY Y Trimestru UIR ALEXANDRESCU CAMELIA w Rueaza Rapoarte Directa De Sanatate Pul a Formular Teomestnal Si ind aton An YYYY 2007 Trimestru B Ruleaza Raport Tomestnal o Ruleaza Raport indicaton e Ruleaza Raport Anexa e Ruleaza Raport Restantie i rM Mummius Teeme has mod Sata dr pin Rapor Furman Sewer PF Rileaza http B0 86 123 91 90 Raport rapoarte consum Mozilla Firefox oper BUCURESTI MUNICIPIUL CMI Dragostin aa camen La La Los BUCURESTI SESTOROLI BUCURESTI Mib cur Mede NULLO NULL NULL NULL NULL po ton TI MUNICIPIUL CFF ca mei 0744322000 3 2223553 07441 76419 4 Stamescu Powandra 6653728 O rucsitzaiGhyahoo com 044529560 5 TOMA ADRIAN 021 2524025 adicamen2000 vahoo com 0745037838 BUCUREST MUNICIPIUL CPP Dr AA 107100 amp BUCURESTI SECTORUL 3 BUCURESTI n Svasta Simona 128
33. ctured in two sections e Individual Unit Info contains information of general interest about the Individual Reporting Units e Contact Person Info contains data about the contact person attached to the Individual Reporting Unit The Save button allows the user to save the entered information in the database the Cancel button cleans up the form of all entered data in the database and should be used whenever the user wants to discard wrongly entered data Certain fields from the data input page such as Town Postal Code contain predefined data that must be updated at first use or whenever necessary Unit name It is an alphanumeric field of maximum 64 characters used for recording the name of the Individual Reporting Unit It is a mandatory field Both letters and figures can be used but for instance the application records a value made up only from blanks There are some cases when this field could be considered as invalid during advanced data processing Unit type It is a list of values identifying the type of the reporting unit Localitate This field has a pop up list including the names of all administrative units e g towns or villages located in the district for which the data are recorded This list is set in an alphabetical order Select from the list the name of the town village where the Individual Reporting Unit is located Ttwo names separated by dash represent the name of 9 a town where the service provider opera
34. d and View Update Every time the Distribution Data link is accessed the Expiration Interval window is automatically opened drawing the user s attention to products in danger of expiration as per the following description For the Individual Reporting Units the warning appears automatically for products expiring in less than 4 months Forthe District Public Health Authorities the warning message appears automatically for products expiring in less than 7 months 73 Interval Expirare Microsoft Internet Explorer File Edit View Favorites Tools Help v Seachweb wWIMyMSN gt Oe 4 DI lt spaces E dere Atentie Aceste produse expira in mai putin de 4 UIR 7 DSP luni Indicator nbll alculat pana la expirare Nr luni visae 4 7 4 www inter con ro 14 3 1 Adding Distribution Data PT opic 1 0 Microsoft Internet Explorer Fie Edt View Favorites Tools Help ie Qe i m 2 sed gerani 2 Mc o g der A http lfcev secsiro Salsecsec indes php Be Google GC w Goo E y mansis PFS Lee psoksy SP check gesto a Send tow s Settings YI d w Search Web tele B Mab A shopping reco ED answers ala Games Muse m i a i 4 i Utilzator PRAHOVA r E USAID Adaugare Date Distributie Vizmalzare Actualizare Date Distributie Data 1512 2006 und ES secs introducere Date Distributie Unitate individuala Rapo
35. d for the name and surname of the contact person Telephone This is a field containing a maximum of 20 numeric characters including the separator The first part is represented by the prefix of the district where the specific locality is located which is automatically filled in by the application but this field can be edited if the contact person lives and works in different districts The second part is the contact person s telephone number E mail This is a non mandatory field defining the contact person s e mail address It can have a maximum of 20 alphanumeric symbols Information that is entered must be in the format address 9 domain xxx Cell Phone This is a non mandatory alphanumeric field of maximum 16 characters where the contact person s cell phone number is inserted When saved data entered in this screen are validated and in case errors are detected a dialog box will indicate the field s with data entry errors An example of an error message is shown in the following box Microsoft Internet Explorer Campul Nume Unitati trebuie completat Campul Telefon trebuie sa contina numai numere Campul Nr Asigurati trebuie completat Campul Email nu este de Forma adresa amp domeniu xxx EUIR data must be entered in hierarchical order at first use of the application data on the District Public Health Authority in the Type field select DPHA option and only after that data for services such a
36. e following sections other reports or supplementary details will also be presented A Reports sent by the DPHAs 1 Quarterly report on distribution order of free contraceptives This report contains the following information e The DPHA name and For each contraceptive product expiration date stock on hand at the beginning of the quarter entries during the quarter quantities distributed during the quarter perishables stock adjustments stock on hand at the end of the quarter and quantity ordered at the end of the quarter In order to generate this report see image below insert the year select the quarter from the pop up list and click Run Quarterly Report i Window Indernet Lap kere i gs epo 9r 173 91 Sof nde pho 9 X pe 4 LI d Bux a r hU w ithe Que 2 _ 7 a USAID Rapoarte E SO CS Raport Lunar De Dstnbube A Contraceptweior Gratute a onto Munari UIR ALEXANDRESCU CAMELIA a Raport Lunar Prirsd Unitabie Ce Nu Au Fumua Rapoarte De Consum a AnLuna Y Y YYM YY YYMM Lista Date Otstripute UNIAD ANLUNAMYYYYMYYYYMM Rulenza Anon Rapor Tnmestral De Distribube Comanda A Contraceptiveior Gratute An YYvv Trimestru UIR ALEXANDRESCU CAMELIA Dare Rapoarte Dwecka De Sanatale Publi a Formular Trimestnal Si indicatori AN YYYY 2007 Trmestru B Ruleaza Raport Trime strial Ao migrena Toce wea De EO aio ED bi A N e a Tori Ruleaza Raport Anexa Ruleaza Raport Restan
37. e icon from the Actions column The user will be automatically redirected to the data entry screen where all fields will be filled with previously recorded data All the considerations presented in Add Distribution Data chapter remain valid in the case of data modification After modifying the necessary fields data is validated If all information on the screen is correctly introduced the following message will appear at the bottom side of the page after clicking on the Save button Saved successfully The screen will remain filled with the new values If the Cancel button is clicked the recent modifications are discarded and the screen will be re filled with the values originally recorded in the database 18 www inter con ro Deleting data this operation is done by finding the record whose data you want to delete in the viewing table and then clicking the icon from the Actions section A confirmation message will appear on the screen as shown to the right in order to avoid deleting data by error Microsoft Internet Explorer N j Sunteti sigur ca doriti stergerea inregistrari curente After clicking the OK button the respective record is completely deleted from the database The application will update the viewing screen and the deleted record will no longer be displayed on the screen 3 3 Considerations on Processing Distribution Data For each quarter recording of stocks must be done chronologically and month
38. e values displayed for the district level units at various moments in time will be modified while the updates on the distribution data for services providers will be entered into the system There could be situations when a product is erroneously registered for instance at district level under a wrong label e g Marvelon 15 instead of Marvelon 14 thus deletion of wrong entries is necessary when a mistake is detected Deleting distribution data from district level unit can be done as long as there are no distribution data recorded under the same label for the inferior level unit s IRU In such cases the application will display the following error message e There are stocks recorded for subordinate units In order to delete the information pertaining to the DPHA level the logistic operator must first delete all the entries for the same product at IRU level and of course re enter the data under the correct label Secondly stocks for any reporting unit can not take negative values Thus in the process of automatic calculation of total exits from the DPHA warehouse based on entries at IRUs level the final stock with DPHA must remain positive Otherwise the following error message will be displayed e Final stock of superior unit cannot cover current entries For each unit product combination only one set of data can be entered for each month If the user attempts to enter more than one set of data the system will generate the foll
39. egistc al Vimstendu Sanatan Pubkce pen AGCESIOON ____ Char daca aplicaba a fost dervoltata pentru A permute colectarea infomnatillor pivin Umhzatonul autenzat nu are nevow de mstalarea mo uma soft supkmentar contracepuvele cu distribute gratuita datonta flesibilitata acestea apheane poate fi folosite fund suficient accesul la a comesnane internet si la un program de navigare cu suta si pertru raportarea alter produse cu regim ehn furmzate pen programele ip Intemet Explorer sau Netscape Navigator Versunea recomandata pentru nationale de sanatate browser este intemet Explorer 5 sau supencara Piutarea pe alte verzrum de browser mu a fost vesraca secure 5 5 5 1 men pi ta o abii d iaa dud eek yo ip accesarea aphcate trebue sa introduceti mamele de utthzator st parola care e Asizurat a ca programul dumnes castra de navigare suporta cookre un s mu are Ma fiere eee anioni aeaa pop up unle blocat e Accesarea aphcane se vaface de Catre un sigur utilzrator desemnat de catre _tegatunuse 3 J mstitutia beneficiara o mtatea de Management de Program a Aluustenuha Sanatatu Publice Auitoritatile de Sanatate P fudoteme Mowsterul Sanatati Publice i ada cp ins d i anis SECS e Eaportat once disfunctonaltate sau suspiciune de atac adminis tratorului ISI Iac USAID Lim AP x USAID EST SOCS p TET Td DE Ptr Js RAT Acasa ail Sates a PDE a vErata oe Societe de Ens catis Cortanent ua i Dax BIB SECS ti GBELELA oe Cert
40. ers www inter con ro Quarterly Report Order Form for Free Contraceptives for the District Public Health Authority XXX Quarter 1 Year 2007 Free Contraceptives Marvelon 6 DIU 3 Megestron 3 Exluton 2 10 Measurement unit Folie Folie buc fiola cu Folie buc 20 pastile 20 pastile seringa 20 pastile C Stock on hand at the 21900 1615 2202 5146 beginning of the quarter i 7 B the quarter 10068 mu ME uu EN Lor Total dispensed by FDs FP clinics NEN Total issued to the FDs FP clinics during the quarter Stock Adjustements Perishables Stock on hand at the end of the quarter C D E F 858 26 5122 769 105 5205 during the quarter Total stock on hand in 8499 1104 951 6551 FDs FP clinics at the end of the quarter J Quantity ordered 3570 1618 2xH G Approved quantity E Explanation for perishables adjustments 1012 1134 10298 Report approved by the Coordinator of free contraceptives distribution Date signature and stamp Report approved by the Financial Accounting Deputy Director Date signature Order approved by the National Coordinator free contraceptives distribution Date signature Number of providers who didn t send consumption reports Month No of reports that should have been sent A reports that weren t sent C A 2 86 5 71 5 71 Run at 14 4 2007 3 10 20 www inter con ro 26 b By clicking the button Run Indicators Reports e R
41. g unit from the higher level unit It is a numeric field of real type it cannot have negative values and also it is a mandatory field Adjustment this represents the difference observed during the physical inventory either as a surplus value entered will be a positive number or in minus value entered will be a negative number The field is numeric of real type and mandatory if there are no adjustments leave the field filled in with the implicit value O Exits at IRU level When an IRU unit is selected the field is editable of real numeric type It represents the quantity of the product distributed by the respective unit at DPHA level When the DPHA unit is selected the field is non editable and it will be automatically calculated as the sum of the entries from all the IRU units for which distribution data are introduced the DPHA distributes quantities of the product to IRUs so the sum of exits from the DPHA warehouse is equal to sum of the entries to all IRU units re supplied When entering data for the DPHA district level unit the Exits field will be filled in with the value O initially however while IRU data will be entered the value for the DPHA stock will be modified automatically for the reasons presented above due to products shift among stocks Final stock this is a non editable field and it represents the stock remaining in the deposit of the reporting unit at the end of the reporting m
42. hrough a web browser An application used for accessing Internet pages The best known web browsers are Microsoft Internet Explorer Netscape Navigator Opera Mozilla Firefox For the InterCON application we recommend using Internet Explorer version 5 0 or higher www inter con ro 59 S N S NO T O S NOI O S 1 N O www inter con ro
43. i eptivelor Gratuite Mozilla Firefox De Ed yew T rte Toss T ee _ tune stiu S Explicatia pensabilitatilor apastarilor Rapert aprobat de Coordonatorul distributie contraceptivelor gratuite Data semnatura si stampila aport aprobat de Durectorul Adjunct Financiar Contabil Data semnatura Comanda aprobata de Coord Nahonal al distribute contraceptivelor gratuite Data semnatara m cease a poa tc6 Je CIA 15 10 ion Contraceptive distribuite cu PLATA Eulat 23 7 2007 133320 fom 51 www inter con ro 3 Quarterly report on overdue units This report lists the providers for which no report was entered in the database for the quarter In order to generate this report select the quarter from the pop up list and then click Run Overdue Report see image below Oo TETEE nde te wo X mw 9 Boxe LE E Jeees e Raport Luna De Dastnbube A Contraceptrveice Gratuite AniLuna v Y YYMAYYYYMM UIR ALEXANDRESCU CAMELIA Rapot Lunar Prid Unitabio Ce Nu Au Fuma Rapoarte De Conpum A P AnLuna Y YYYM YYYY MM InterCON 1 0 Lista Cate Desiree Umran Antunajvyyvmvyvyvm Reeaza pa mr Rapont Tamestnai De Destribube Comanga A Contraceptivelor Gratute i AmYYYY Trimestru V UIR ALEXANDRESCU CAMELA Rapoane Direct Ce Sanatale Pubi a Formulas Truman Si inca ato
44. ion reports per product and per district This report is generated for the national levels and presents the total quantities of contraceptives dispensed by the services providers in a certain district over a certain quarter broken down by type of product e g LoFemenal 8 Marvelon 10 etc E Microsoft Excel Rapoarte generate de Intercon xls Arial R2 BIU FES BE BS 0008 EE A Ao Dc E Gay shea SF o c Br Fi ab B Desen la Forme automate 1 O E A 23 tha dhe Ea tata ad Ch Ma 3 Aversa cu modific ri sf rsit evizure _ Figiet Editare wizualizar amp Insersre Format Instrumente Date Fereastr Ajutor Tastati o intrebar x CA o fe 25325 A B C D E F Consumuri in trimestrul 200 in 41 de judete si Mun Bucuresti Ac LoFemenal 4 LoFemenal 5 LoFemenal 6 Lc 2hRD 472500 25325 0 X O0 _slarces 2520 472500 o o 4jaceou 2140 2520 o o spor 2532 2140 o o 9 GJBISTRITANASAUD 47250 0 o O to__7 sorosai 2520 10 o o0 1 8jRasv 21400 0 00 o i2 9jerata 0 0 2535 amp TOpua 0 0 47280 9 o A RA Am rom E 8D ii a d A ki _ l n FA E M 4 H1 Cc distrib per produs 2 Stocuri per produs la ASP 3 Stocurper produs la furnizori IP l This report can be accessed from the RAPACCES section of InterCON 58 www inter con ro
45. lectronic version of this manual can be accessed by clicking on the icon J situated in the upper left corner of the application s homepage www inter con ro 2 Individual Reporting Units IRUs The data entry page of an IRU can be accessed by browsing and clicking on the link Individual Reporting Units situated in the left hand menu of the nterCON homepage 3 Logic 1 0 Microsoft Internet Explorer File Edi wiew Favorites Took Help z Qua E 75 yp Search coc Favorit i LJ er v ceres httpifecv secs ro oasecsccvi index php Google Ge OD Eb e dy Beeimantae PHF e DO popups okay o Check mutolink ep Send tow settnase Yr d Seach Web o ir o Mal b Shopping Qe My Yahoo EJ Answer 5 gli Games Muse m H ip T EN NINE NE Utilizator PRAHOTA SEFI a at rap USAID Vgl J Date 1 12 2006 La ESI secs InterCON 1 0 Unitati Individuale de Raportare RAPOARTE I Societatea de Educatie Candirace pri a si Eexuala SECS si J amp l This module allows easy administration of the data concerning any of the units belonging to the distribution and reporting system for contraceptives IRUs can be classified according in three hierarchical categories primary level represented by the category of individual reporting units where contraceptives are dispensed to program beneficiaries e g family doctors Family Planing FP
46. m An YyYyy 2007 Trimestru M L Ruleata Raport Restanven MUNICIPIUL BUCURESTI 2006 12 CM Haratu Mana BUCURESTI SECTORUL 3 MUNICIFIUL BUCURESTI Fulat 24 7 2007 14 la 24 52 e This number of non reporters coincides with the data in the row No of reports that were not sent C A B of the Quarterly Contraceptives Distribution Report to DPHA as shown in the image below www inter con ro D REPORTS FOR THE PROGRAM MANAGEMENT AT NATIONAL LEVEL 1 Stock on hand at district level per product This report is generated for the national level and presents the stocks on hand by type of product e g LoFemenal 8 Marvelon 10 etc available in the DPHAs warehouses by the end of a certain quarter see image below Arial 2 B7 uU SSH mo oo te o 5 A A Da Eb GAS ig Soro EET zl agli F Desan Fomeautomates a O OR dl Di Sb d A s a20o a ta ta a a 2 By jd venison cu moans w Fiser Editare vizualizare Inserare Format Instrumente sa Fereastr re Tast 8 X E11 Li B A E DS eas E F G H E Stocuri la nivelul ASP la sfarsitul trimestrului 200 in 41 de judete si Mun Bucurest COC oe he tele Judet nal E NA 4 5 S 6 nal 7 nal 8 EE 25325 0 2AR D 47250 25325 0 0 47250 0 L I ATE A4Baceau 21400 25200 o 0 2140 0 E III NINE III PIC 34 o a 6 BISTRITA NASAUDL__47 250 0 o o o of 7leorosai 2520 o o o o
47. mestrial g Ruleaza Raport Indicatori tm si Sanus d SECS 251 Mic A Teren Ruleaza Raport Anexa ingtatute bre EN Y Ruleaza Raport Restantieri lhi tte Done internet _ Ame e The providers were instructed during the basic FP training to send consumption reports even for the months when they did not have consumption e Also it is noteworthy to mention that logistic operators should promptly enter in the InterCON database all consumption data received from all providers that submitted their reports on time including the reports that show no products were dispensed to beneficiaries by a certain provider over a certain month If a provider had no product entries no perishables and or zero consumption insert O for entries O for adjustments and 0 for exits as appropriate www inter con ro Example Monthly report on overdue units that is units that did not turn the monthly consumption reports in on time Logic 1 0 Mozilla Firefox e http 4 8B0 86 123 91 90 Raport rapoarte consum Mozilla Firefox urii Raport lunar privind unitatile ce um au furnizat rapoarte de consum Luna 20071 BUCURESTI SECTORUL 1 MUNICIPIUL BUC TRESTI BUCURESTI SECTORUL 3 MUNICIPIUL BU CUEESTI r Rapoarte Directia De Sanatate Publica Formular Trimestrial Si Indicatori An YYYY 2007 Trimestru p Ruleaza Raport Trimestrial http H0 06 173 91 90 Formular Tramesirial de Raportare si Comanda a Contra
48. n Fst de ne cs 8 Coro i ME T im Tapori baco emdi de Dali ema rana si stampile Rapor aprobat de Coordonatorul ana Tata je m Daa 7 If the three parameters mentioned above are not correctly provided the application will generate the following warning message e The report cannot be run Please check the report parameters Monthly Report on overdue IRUS did not submit consumption reports This facility generates the list of IRUs for which there are no consumption data for a certain month given that they did not turn in the monthly reports In order to view these units the user must input in the appropriate section the desired time parameter in the format 20071 for the report pertaining to the end of January 2007 to be generated Logic 1 0 Mozilla Firafox s Die Edt Wem Hoy Bookmarks oale Help Raport lunar privind unitatile ce nu au furnizat rapoarte de consum Luna 10071 BISTRET BISTRET Even CENTRUL DEFICIENTE AUDITIVE CRAIOVA MINTICIRIUL CRAIOVA 20074 Eat 1444 2007 12 5548 www inter con ro Listing Distribution Data In this report the user can find all the distribution data for a certain districts data that was entered for a certain month This report is useful especialy when logistic staff wants to verify correctness of distribution data entered in the system and that pertains to a certain month In order to view the desired data that was recorded in the database the user
49. ntrari trebuie sa contina numai numere presents an example of a mes Campul Iesiri trebuie sa contina numai numere sage concerning disagreements between the data type required by the system and the data typed in by the user If all information in the data entry window is correct after clicking the Save button the following message will appear in the lower part of the page Saved successfully All data previously displayed on the screen will disappear and the software will become ready for inserting a new set of data 3 2 View Update Distribution Data This module allows viewing searching modifying and deleting values corresponding to Distribution Data E ogi 1 0 Microsoft Internet Explorer Fie Edt view Favorites Tools Help r L O Sig f ss Perce O 2 2 M LJ org dires 48 httpsJfcc secs ro cia v Eje Links Googie Ge CE W Eb Fe Semakse Penke h popupsokay Check Natalie 900 ap Sendtoe D Settrose Y t Susan QA na ana Dia Yahoo EJ Answers gt Seschweh ely Mi Coama A hoon tor PRAHOTA Virualizare Actuahrare Date Distribute Data 1 12 2006 Utibza ta 9 Adaugare Date Distribute JSE SOCS Vizua amp zare Date Distributie Ia Ra InterCON 1 0 UNITATI Unitate Pers rik sit Data IMDIVIDUALE Limteliraportere Contact 779415 Luna An Data Ex sto traducerii RAPORTAR
50. ntroduce the entire value For instance if the string A is inserted in the IRU field then all Individual Reporting Units whose name begin with or contain the letter a or A will be searched for e The text fields that define the search operation are not case sensitive no distinction is made between upper case and lower case Example Search result for spit a n abbreviation for Romanian equivalent of hospital string ZE pital Municipal Campina The application searched for all the rows containing the sequence of characters hosp in the Name field Modifying data this operation is done by identifying the unit with data that we want to modify in the view table and then clicking the icon from the Actions section The user will be automatically redirected to the data entry page where all the fields will be filled with the most recent data for the respective unit All aspects presented in the Add Individual Reporting Units section of this user manual remain valid also in case of the modification of data already recorded After modifying the desired fields if all the information on screen is correct after clicking on the Save button the following message will appear on the lower part of the page Saved successfully The screen will remain filled with the newly entered values If the Cancel button is clicked then the modifications are discarded and the initial values re fill the fields in the screen www inter con ro
51. o cmsul tiumestimhu Create Shortcut Total stor m Add to Favorites I cabinetele MF PF la ene sfarsitul trimestralui Ercoding Cantitate comeanilata Print 2xH G Refresh K Cantitate aprobata Expert to Microsoft Excel Properties From the report page menu the option Edit Select All selects the entire content of the report Then open Microsoft Excel or Microsoft Word and select the option Edit Paste The report will be automatically opened in Microsoft Excel or Microsoft Word as appropriate can be edited or printed through the respective editor 28 www inter con ro From the report page menu the EE E 21x option File Page Setup selects ap Paper the printing options see the Sige following image fa Ga Source The Paper section specifies the Automatically Select type of paper used for printing most commonly A4 The Orientation section specifies the printing style portrait or 0 landscape For reports exten ding on the horizontal choose Landscape The Margins section specifies the distance that will be left from the page borders If the reports have to be filed more distance will have to be left on the left side Otherwise the margins can be set so that the report best fills the page The Preview option from File Print menu allows viewing a preview of the printing where you can also see the automatic paging of reports that do not fit in one
52. o elise ze T d o o TRU Stocuri per produs la ASP 3 Stocurp sisi lup M4 MN lista RAPOARTE 1 Ccditrib Gata This report can be accessed from the RAPACCES section of InterCON see appropriate section in the first part of this user manual 53 www inter con ro 54 2 Stock on hand at provider level per method and per district This report is generated for the national level and presents the cumulative contraceptives stocks on hand at the providers level for each method COC POP injectables UDs and condoms by the end of a certain quarter See image below E Microsoft Excel Rapoarte generate de Intercon xls LIE Arial R2 BZU EZB So E et he Ae Dc e Say Ghi o c 7 87 ww B Desen RO Ge 2 a 4 A 2 Be Ca ta ta ad X GU Fe Raspuns cu modific ri Sf r it revizuire y E Fiser Editare Vizualizare Inserare Format Instrumente Date Fereastr Ajutor Tastati o intrebare x C12 f 12500 D E F G 4 Stocuri la nivelul furnizorilor la sfarsitul trimestrului 200 in 41 de judete si Mun Bucui gt DI O Mma i ee es aea sol 120 150085400 NE 100 15 500 80 17 800 1 500 5 BIHOR 38100 2 50 6 BISTRITA NASAUD 44500 1 00 RASOV sm 1 00 o Ml 2 a o o in 8 9 BRAILA 80 28 40 10 BUZAU 1 50 si 15 40 ET 22 500 e e DU 450 se m 250 400 25 www inter con ro ila This report can be
53. on Data http 80 66 1 23 91 90 Raport rapoarte consum Mozilla Firefox a De DE Wee mw eese Pe y z Lista Date Distributie Luna 20073 3 Unitate Pen wa A Dat M mm pu 3 2007 20 09 2011 500 000 200 01042 ge pure data n Colentina 5555 Marvelon 10 3 2007 3107 2009 15100 000 3600 000 115 00 2394 500 1 04 21 Parcalabu 07 Colentina Parcalabu Prezervative 2 O 500550975097 5000 woo 2000 000 3000 271 ooo 2333 129 ouaa me Inna 10 Parcalabu Colertina xa DIU 7 0731012010 1000 ooo 200 000 00 2206 200 n 94 OONA Parcalabu nc Colentina pce Marvelon 10 3 2007 31 07 2009 000 300003200 000 26800 2455 23200 ns 347 planar Ambulatori de 1 d mraciali Leasa Tv rna Daniela DIU4 3 20073108 2008300 0 00 100 000 200 2601 200 0104 2 cese us ose ee Daniela 77 7 3 2007310772007 100200 0 00 34000 0 00 662 00 211 105000 35000 189 01 042 Spataluhu E 10 iniezione MAMEN ML Am a EZ Lil For easier processing this table can be copied to a Microsoft Excel spreadsheet To do SO open the report and select it by clicking on the page and by pressing Ctrl A at the same time then press Ctrl C at the same time Open an Excel spreadsheet and press Ctrl V at the same time The report will be completely copied in an Excel file 49 www inter con ro 50 2 Monthly repo
54. onth It is calculated automatically by the formula INITIAL STOCK ENTRIES ADJUSTMENTS EXITS Distributed during the last 3 months This is a non editable field and represents the sum of the exists from the stock for the current month plus two previous months Mean monthly consumption This is a non editable field and represents the simple arithmetic mean of consumption for the last three months It is calculated automatically by the formula TOTAL QUANTITY DISTRIBUTED DURING THE LAST THREE MONTHS 3 Months of stock available This is a non editable field and it represents an estimation of the number of months that could be covered from the current stock of product if mean consumption estimated was maintained It is automatically calculated based on the formula FINAL STOCK MEAN MONTHLY CONSUMPTION www inter con ro All the sums calculated automatically are rounded up to the second decimal TICZDROTLODTTRTDRTIEXDIOTRT LI The data in this window will be Campul Intrari trebuie completat validated by the software and in case Campul Ajustari trebuie completat date entry errors are found a warning ceri Pareri pia aia message box see example shown will appear The warning message will point to the fields for which errors or missing data for the mandatory fields are present A second example of warning RIST 9 010744 message box after validation is included also This second box Campul I
55. orts Quarterly Report on Distribution Order of Free Contraceptives corresponding to the Individual Reporting Units the list of IRUs with distribution data not updated during the latest reporting month Monthly Report on units who didn t submitt consumption reports and to the distribution data introduced for a certain month List of Distribution Data The fifth section generates quarterly reports of the District Public Health Authority calculates specific program indicators and generates the list of all services providers functioning in the district etc see Compendium section included below in this user manual 21 www inter con ro 22 Monthly Report on Free Contraceptives Distribution To generate this report the user must provide the application with the following two parameters eporting month it has the structure Year 4 figures Month 1 or 2 figures Example 20061 for January 2006 200610 for October 2006 the IRU name the individual reporting unit whose report he she wants to generate The IRU name can be selected from the alphabetical pop up list provided by the application Below is included an example of such monthly IRU report that can be generated by the application File Edk Wew History Bookmarks Tools Help Raport Lamar de Activitate si Distributie a Contraceptivelor Gratuite pentru Cabinetul ACAMENI OAIFI LUIZA NEAMT Luna And 2007 Demunnea cont ac eptrvaulm B Stoc la incep
56. owing type of message that gives a warning of duplicate entry e INS100 gt Failed entry in Stocks 1062 Duplicate Entry 39 1 10 2006 for key 2 www inter con ro 4 Basic Reports This facility allows automatic compilation and viewing of periodic logistic reports it can be accessed by clicking on the Reports links placed on the menu positioned on the left side of the homepage Logic 1 0 Mozilla Firefox Ele Edi Wew Higtory Bookmarks Tools Help lt a x e Ay IL http 60 06 123 91 20 index php Lj Customize Links 404 Mot Found Raport Lunar De Distributie A Contraceptivelor Gratuite Antuna Y Y Y Y MY Y Y YMM UIR BEDER BOGLARKA Raport Lunar Privind Unitatile Ce Nu Au Furnizat Rapoarte De Consum An LunajYYYYMYYYYMM Lista Date Distributie An Luna YYYYMYYYYMM Raport Trimestrial De Distributie Camanda A Contraceptivelar Gratuite An Y YYY Trimestru VIR BEDER BOGLARKA Rapoarte Directia De Sanatate Publica Formular Trime strial Si Indicatori AniY vv Trimestru v Ruleaza Raport Trimestrial The application can generate various types of specific reports on contraceptives distribution etc The Reports screen is structured in several sections depending on the reporting period and the level IRU district or national for which the report is generated The first four sections refer to IRUs and provides monthly reports Monthly Report for Free Contraceptives Distribution and quarterly rep
57. page The File Print option prints the report following the settings previously specified 29 www inter con ro 6 Compendium of Reports Generated by InterCON 1 0 The InterCON 1 0 application has three levels of access e at national level e at district level and e a public section that can be accessed by anyone interested in the monitoring of free contraceptives distribution For the public section please visit the InterCON web site at www inter con ro Type in the user name RAPACCES and the password rp ms ro ZEROO71 see the image below Login Windows Internet Explorer O m E hetpil vens nter con ro vo A Po Gwen R J a one oa InterCON este o aphcans semet destinata umplhcam procesulu de momtonzarea 2 ditnbubne de contraceptie farucate manat populate ekzmb de im ca m Programul Utilizator RAPACCES Natonal de Sanatate ru 3 pon automabrarea achvitati de raportare dnspre ni elul pudetean catre mtelul national precum si a morutonzam act tats de raportare Parola sreseessazionen Inmatra elaboram acestei apheam aparine limsteruhn Sanatati Pubbce care a dent sa Ec puna la dispozitia autonrat cr de sanatate publica judetene ur instrument de raportare utot i onectare de folosit de catre once utbrator aurenzat care sa permuta consobdarea cu acuratete si m tmp real a formater pound dsmbune contraceptivelor kstrbuse gratute de catre arr Infomanonal de Management L
58. piration stock on hand at the beginning of the quarter entries during the quarter distributions during the quarter perishables stock adjustments stock on hand at the end of the quarter and quantity on order In order to generate this report select the quarter from the list and then click Run in the section Quarterly Distribution Report Order of Free Contraceptives see image below 37 www inter con ro Hinde Internet At IET G O e reni omm ne x pe me dre Otome er SOCS Raport Lunar De Distnbutie A Contraceptiveior Gratute sear iMerCON 7 9 Menon UIA ALEXANDRESCU CAMELIA sio Raport Lunar Prema Unitatte Ce Mu Au Furruzat rapoarte De Consum ANLUNA YYYYMYYYYMM Reseaza UNIAD Aniuna YYYYM YYYYMM y mr Raport Tnmestnai De Distributie Comanda A Contraceptivetor Gratute AMYYYY Trimestru Y UIR ALEXANDRESCU CAMELIA Dare Rapoarte Drecta De Sanatate Pute a Fomula Trumestriai Si inci aon MES TRIBUTIE AnYYYY 2007 Trimestru B P A Ruleata Rapor Trimestral E Ruteaza Aapon ir lo m henee E Ruteata Raport Restantieri Example Quarterly Distribution Report Order on Free Contraceptives http 850 86 123 91 90 Formular Trimestrial de Raportare si Comanda a Contraceptivelor Gratuite Mozilla Firefox Ele Ed Wew aor Bookmads Tools Help 38 To view the Quarterly Free Contraceptives Distribution Order Reports for providers in other distric
59. rt Trimestral 39 www inter con ro Example Indicators Report Mozilla Firefox http 80 86 123 91 90 Indicatori DSPAIMP Tipul uunarul si costurile conn aceptivelor disnibure per numesnn An 2007 Trmestra TOTAL Total MS DONATII Contraceptiv re itg 4 Marvolo ine Data 4 mm erra a 28 03 2008 31 02 2000 30 04 2007 31 02 2000 31 07 2007 Unitate de Finacu Folie 20 fiola cu buo distribuite 185 00 19 00 3938 00 103 00 7 00 Qum 34 16 300565 pus 132991464 1451939 Cosimi tip de contraceptiv 612 55 87744 11814 58 05 distribuit Factor de sah law dirus e AI 4 0000 01250 130000 40000 120 000 430 67 3148 56215 Cops E dI 24 IU 5 di D 15 3 gratuitas 46 25 152 peu 55 5n pu 3 ps Foalat 23 7 2007 14 5231 Dong For easier processing this table can be copied to a Microsoft Excel spreadsheet To do SO open the report and click on the page of the report pres Ctrl A at the same time then press Ctrl C at the same time Then open an Excel spreadsheet and press Ctrl V at the same time The report will be completely copied in Excel To view Indicators Reports for other districts go to RAPACCES section of Inter CON 4 FP Services Providers Report This report lists all active providers in the district With this report users will always know how many services providing units they have family doctors and FP clinics and they will be able to retrieve their contact details su
60. rt on overdue units This report contains the names of the FP services providers who did not report their consumption data on time for a certain month plus details such as the name of the unit the locality where he she practices and the date of the last report turned in to the DPHA This report is extremely useful because it helps program managers to have a very clear image concerning distribution reporting units that did not submit the monthly consumption reports on time without having to keep separate files In order to generate this report type in the year and the number of the month with no gap between them and click Run Report Overdue see image below Logic 1 0 Windows Internet Explorer ei Qon e herp 90 28 123 91 50 ndex oe LATER jel t OR osx lege 1 0 PT E dw Page Ihr e sax be sana aa LA I E a Rapoarte a i ESI SECS RaponLunar De Distributie A Contraceptivelor Gratuite MIRAT 10 An Luna Y Y Y YM Y Y Y Y MM UIR ALEXANDRESCU CAMELIA n Rapor Lunar Privind Unilatie Ce Mu Au Furnizat Rapoarte De Consum E a E An Luna YYYYM YYYYMM JL Lista Date Distributie An Luna YYYYMIYYYYMM Raport Tnmaestrial De Distributie Comanda A Contraceptivelor Gratuite L Amn YYYY Trimestru li UIR ALEXANDRESCU CAMELIA w Rulesza DATE Rapoarte Directa De Sanatate Publica Formular Trimestrial Si Indicatori e An YYYY 2007 trimestru UE Ruleaza Raport Tri
61. rtare InterCON 1 0 a Hume Localitate Ja d Tip Pers Contact L Produs UNITATI Nume Data Expirarii EU p Lista RAPORTARE Sto CS An 2006 Luna 12 DATE Stoc Initial intrari Ajustare lesiri 0 RAPOARTE Stoc Final Distribuite in Ultimele 3 Lumi Societatea de Educate Contraceptiva si Semuala Consum Mediu Lunar SEC 5 m J51 w The data entry page for distribution data is structured in three sections Individual Reporting Unit Product and Stocks For each combination Reporting Unit Product the distribution data must be separately inserted The first two sections contain non editable fields new information cannot be inserted they can only display the existing records a record can be selected by clicking the List buttons The data entry steps are 1 Click on the List button from the Individual Reporting Units section After clicking this button the Reporting Units Selection window will appear In this window find the reporting unit for which you want to introduce the latest distribution data then click the icon next to the selected unit The mouse must be placed exactly over the above mentioned icon so that the cursor changes its shape symbol After clicking the selection symbol the window is closed and the Individual Reporting Unit section in the Add Distribution Data page is filled with the values corresponding to the selected unit It may take a few seconds until the fields are filled wi
62. s FP clinics or individual family doctor practices can be recorded Otherwise an error message like the one below would be displayed after clicking on Save There is no DPHA unit for this district Please insert a DPHA unit before introducing Individual Reporting Units In such a case the user will have to access the menu Add Individual Reporting Units again and insert the data corresponding to the DPHA level www inter con ro 10 Only one DPHA reporting unit can be entered for one same district In case of attempting to duplicate this operation the following message will appear Only one DPHA reporting unit can be entered per district Duplications will produce the following message If all the information in the data entry window is correct after clicking Save the following message will appear on the upper part of the page Saved successfully All data will disappear from the screen and the application will become ready for inserting new data View Update Individual Reporting Units f opic 1 0 Microsof Internet Explorer Fle Edt Yew Frate Took feo E Qua Sh DO Pret gere O Du ML E httprijibesbost produetie SecsCCI20v1 inde php Eje o v schivo wu dise g Wt Exin PER 4a Maat ar 3 N SOCS Adaugare Uratati Indonduale de Eaportare Viruahzare Actualizare Urutan Indunduale de Raportare me MIRAT Logic 10 Virualtzare Date Cabinete indi iduale de Raportare
63. seven rows per page to go to another page click the corresponding number at the bottom of the table Searching data this operation is done by introducing search criteria in the free text fields and or selecting an option from the list fields and then clicking on Search The Cancel button brings back the search section to its former state with all fields emptied if it is the first search or brings back the initial search criteria if it is a new search If no record corresponds to the search criteria the following message will be displayed There are no records corresponding to your search criteria In the text fields that serve to define the search criteria a few characters from the wanted text are enough to initiate the operation it is not necessary to introduce the entire term For instance if the string A is entered in the Reporting Unit field then all Individual Reporting Units starting with or containing the letter A or a are searched for and displayed Inthe text fields that define the search there is no distinction between upper case and lower case Exemplu Cauta Cauta Anuleaza Anuleaza Unitate PER stoc Intrari Ies 7a Bia Depoproveral 10 200601 04 2006 000 300 00 000 ado 30000 697 1 atribuite at Suma Stoc Interval Ajustare Final Expirare j Modifying data this operation is done by finding the desired unit in the viewing table and clicking th
64. st EX F2 fe A B C D E F G Stocuri la nivelul UIR la sfarsitul trimestrului 200 E i umen coc monotazie prezervative DIU lea 1 25 1 0 02 30 1 semis 14 83 X 0 12 2 4CM4 1 Q 85 3 20 4 8 10 semis 147 74 0 A 9 5 6eme 1997 eis ll lei ov 3 140 7CABINETPF 1200 25 7 0 220 15 11 SICABINETPF2 151 15 25 amp 240 o 12 9CABINETPF3 250 14 2 120 o 13 10 CABINETPF4 175 25 27 3150 o 15 REGE M 9 Lista STOCURI UIR per prod 9b Lista STOCURI UIR per metoda 10 Lista UIR stoc er 4 o Gata NUM 47 www inter con ro 48 C Verifications reports 1 Listing of Distribution Data This comprehensive report lists all data introduced for a certain month or quarter by provider It is very useful for checking the accuracy of data recorded in the InterCON database This report contains the following types of information name of the unit contact person product month and year for which the data were entered expiration date of the products initial stock on hand for the month for which the data were entered entries for the month exits consumption final stock on hand for the respective month expiration interval number of months remaining until the expiration date of the product minus 4 months for providers and 7 months for DPHA if the same
65. t and press Cirl V at the same time The report will be completely copied in Excel The image below presents a second part of the DPHA quarterly report on contraceptives distribution as it is generated by nterCON This section of the report also contains statistics useful for program management such as the number of reports that weren t submitted thus entered in the dataset during each month of the quarter This information is very practical both for the District Coordinator of free contraceptives distribution and for the superior level the central level that can view the percentage of service providers non reporting late reporting thus they can understand how far the reported consumption could be from the true consumption 33 www inter con ro 34 e tis in the best interest of the family planning program managers to permanently seek minimization of the percentage of non reporters i http 00 86 173 91 90 Formuotar Trimestrial de Raportare vi Comanda a Contraceptivelor Gratuite Marilla f iretox Be Lt pee buon Qodeuhs loh tb f O mine ct vl di J comandata 6 Li 0 Li 3458 0 1192 620 108 K ant ate Expbe atua pensatdeatos apustardor __ Faport aprobat de Coordonatord darti ume contraceptvelor gatete Data negat d itae ua Faport aprobat de Directord Adpnc Financiar Comabd ___ Data att gata a Comnda aprobata de Coord Naaonal al amp rtribate contraceptreelor gratude
66. teri www inter con ro Example Quarterly DPHA report on distribution order of free contraceptives http 50 86 123 91 90 Formular Trimestrial de Raportare si Comanda a Contraceptivelor Gratuite Mozilla Firefox Formular Trimestrial de Raportare si Comanda a Contraceptiveler Gratuite pentru COC Monofizie COC Menafucie DI Dajertdi O jet O metil POP A Contraceptive gratuite Marlon 6 Maroon DIU 4 Depoprovera 10 Depoproven 2 Megeten 3 anton 2 Data Expirarii 30 04 007 30040008 31M8t008 28020006 IWPR O 31080009 O 3omonoi 50040011 51470007 B Unitate de masura Foli 20 past Fotie paste bue Fislaeuseringa Fisl eu seringa fiola cu seringe Foli 10 pastile bu buc ou epe 715300 enn co 4500 0 00 000 Mi200 20000 000 5343 00 D n 0 00 n 0 00 nn 000 non 1440000 oo P trimestrubui P Total elihe rate catre E cabinetele MPOPF in 5094 00 eon 0 00 0 00 0 00 299 DO O00 Doo 4282 00 Ch _ EM peo m mr DUE er petted ao 09 po 0 00 0 00 T om masi 2060 2000 45 0 0 1313 2100 14400 1061 3932 00 19 00 dn ma 422700 545400 27100 1180 30500 311400 ak aree LL _ 5807 me iT pu E 107 2100 amo 1393 For easier data processing data in this table can be copied into a Microsoft Excel spreadsheet In order to do so open the report select it by clicking on the page and pressing Ctrl A at the same time then press Ctrl C at the same time Open an Excel spreadshee
67. tes before the dash and the name of the higher f level administrative unit locality after the dash as defined in the SIRUTA geo administrative Computerized System of the Territorial Administrative Units Register SIRUTA represents a key instrument for the computerized processing of data in territorial profile in Romania used for reporting various official statistics including economic and financial data www inter con ro classification and coding system kept by the National Statistics Institute For instance in the case of a village the first name is the name of the village and the second indicates the name of the commune to which the village is affiliated from the administrative point of view This structure is helpful to discriminate between two villages with the same name belonging to different communes located in the same district Postal Code This field cannot be edited it appears automatically after selection of the desired value of the Town field from the predefined pop up list Address This is an alphanumeric field with a maximum length of 128 characters in which text can be inserted on several lines Filling it in is not mandatory Its structure is not fixed but the following succession is preferable Street No Bl Entrance Floor Apartment Type of Contact Person This is a list of values that identifies the type of contact person in the IRU Contact Person name and surname This is a non mandatory fiel
68. th the values corresponding to the selected unit Please wait until all fields are filled before taking a new step or initiating a new operation To search the record pertaining to the wanted individual reporting unit the user can introduce a few characters from its name in the upper side box of the page then press the Tab button or click outside the box The list that will be automatically generated will include only the records fulfilling the search criteria In order to fill in the list again with all available records leave the filtering box empty and press Tab or click anywhere outside the box www inter con ro 2 Click on List button from the Product section By clicking on the List button the Product Selection window will open Selectie Produs Windows Internet Explorer Ebley jf60 86 123 91 90 ste_preckuse_stocur phot eite acioneeddtcumtrur Selecbo Produs introduceti cateva caractere din nume Im Pret 31 08 2007 USAID 0 76 30 09 2008 MSP USAID 0 76 30 11 2008 MSP USAID 0 76 30 04 2009 MSP USAID 076 e 3 S E n L SS SS ERN TE FANNE CONG S TA NG 30 06 2009 MSP USAID 31 08 2009 Ministerul Sanatata 2 87 31 05 2009 MSP UNFPA d ll 30 06 2009 MSP UNFPA I E E 31 08 2009 Ministerul Sanatatz 1 47 31 10 2009 Ministerul Sanatatz 1 47 28 02 2008 Ministerul Sanatats 3 00 a Dane 9 Internet 100
69. ti InterCON User s Manual Institutul de Cercetare si Formare JSI Bucuresti Speed Promotion 2007 ISBN 978 973 8942 50 9 613 888 314 336 Contents Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 TECHMICALTIONW uacua uox wad bree een eed eee a B8 n n a 4 INIFOGUGHION 5 Individual Reporting Units IRU eee 7 Adding Individual Reporting Units LL 8 View Update Individual Reporting Units lll 10 BistriDulion Bald 122999 oxRGUR des e i eee 8 ii 13 Add Distribution Data ans xctoe mper ant d ae Re eos i Ee Fig and d d mai 14 View Update Distribution Data 17 Considerations concerning the handling of distribution data 19 Basi HEDOris 6 xus cee she one dsh eee bee NU ERE RE ee dS EUR 21 Exporting data and reports printing 28 Compendium of Reports Generated by InterCON 1 0 30 Brief GIGSSAlY r m 59 www inter con ro Technical Note InterCON 1 0 is an Internet application produced in order to simplify the process of monitoring the flow of free of charge contraceptives dispensed to the eligible population through the National Prevention Program Sub program 1 3 for Women and Children s Health it supports automated reporting from the district level to the central level and helps monitor timeliness of reporting by family planning services providers
70. ts go to RAPACCES section of Inter CON www inter con ro 3 Indicators Report This report provides automated calculation of program indicators that are reported by DPHA to the central level each quarter and annually it contains the following information quarter and year of the report and for each contraceptive product quantity distributed during the quarter by the service providers costs per contraceptives dispensed total beneficiaries mean cost with contraception per program beneficiary and total costs per quarter recouped per products received from donations respective via governmental procurements To generate this report type in the year select the quarter from the pop up list and then click on Run in the Indicators Report section see image below o het MD 17 01 90 ndes ehe wo X PE fr P D cre Otome E suo i LIS USAID Rapoarte SGCS Rapor Luna De Datnbube A Contraceptwelor Gratute Fu RAT ai Li sian O A Luna r Y YYMPOCC YYMM VIR ALEXANDRESCU CAMELIA R arcta Raport Lunar Prid Untabie Ce fiu Au Fuma Rapoa e De Consum Anluna YYYYM r Y YYMM Ruteaza Lata Date Orstribultw AnXiuna Y Y YYM Y Y YYMM Raponi Tnmestnal De Disinbutie Comanda A Contra eptiveior Gratute e ANIYYYY Trimestru UIR ALEXANDRESCU CAMELIA v Ruseaza DATE Rapoarte Drecha De Sanatate Pubbc a Formulas Temestnad Si inc atn Drs TRIBUTME An YYYY 2007 Trimestru B e am Bo Rapo
71. uleaza Raport Indicatori the user can generate a report concerning the program specific indicators physical and efficiency as shown in the example below rori DPAP kiicrozati Internet ivpiora A Be Est dew Favorite oc pep e Total UA cu gratuita 225 225 z5 Ruda Lee VU 22 24 4 c By clicking the animated button Run Annex 2 Report Ruleaza Raport Anexa2 the application generates a report concerning the types and quantities of contraceptives distributed in the district during the reporting quarter thus facilitating the calculation of program effectiveness indicators 3 italori Amera Microselt Internet Explore Ble Edt Wew Favorites Took Hep An 2006 Trmestrud 2349 2349 Tera UA cu gratuita 15 ars 25 CostmelnUA MTL 0 1044 1044 Bulat 16 10 2008 22 26 17 If the necessary parameters are not correctly set the following error message will be displayed e The report cannot be run Please check the parameters of the report www inter con ro FP Services Providers Report This report contains the list of all units service providers that distribute free contraceptives in the district for the date when the report is generated tig D Ha MA I Kapott rapa EXIT De Cdk wew store Bookmarks Too elo RAPORT FURNIZORI SERVICTI PF TAMASEMI COU FLORIN CMI MEDICAL FLORIN I EE DISPENSAR a le FEET MEDICAL AGAPIA Med GAUBE PORNA DISPENSAR PUNCA MIRCEA LAFTE DANIELA
72. ut hm 600 Intra in corned banii 0 00 D Disn buite n ceai bad 0 00 di Astan de stoc Stoc la sfarsitul how B C D E G Distabute im ultimele 3 buni 0 00 H Conswe medi lunar G 3 6 00 T Luni de stor disponibiliFH 0 00 Prezervative 11 0 00 0 00 Eaport intocrmt de Eaport venficat de Coordonatorul DCG semnatura Y semnatura E If the two parameters mentioned above are not correctly provided the application will generate the following warning message e The report cannot be run Please check the report parameters Quarterly Report on Free Contraceptives Distribution Order To generate this repor the user must provide the application with the following three parameters in reporting year it has the structure YYYY for instance 2006 reporting quarter it can be chosen from the pop up list provided by the application and the IRU name the individual reporting unit whose report he she wants to generate The IRU name can ne selected from the alphabetical pop up list provided by the application www inter con ro Below is included an example of such quarterly IRU report that can be generated by the application drm ula sirial c at DGE LATE si Lome ia Li Be Eit Mew Fates pob H Formular Trimestrial de Raperrare si Comanda a Contraceptivelor Graiulie pentru Cahlmetul Anghel Pasaltescu Di raza Trimestrub 4 Amul 2006 100 00 Distuibite n cual imesta 2 00 i m
73. utoniatiler de sanatate publica pudeiene ur mstrument de raportare uio Conectare de folosit de catre once utibrator autenzar care sa permuta consoldarea cu acuratete sa m ump real a mformatuler pavind dembune contracepovelor dstribuste gratuxe de catre fiumizora de cerccu de planificarea famuhala Aplicatia face pate integranta din Sistemul Infonnanonal de Management Logistico al Mimesterula Samatata Pubbce peme contracepti ele gratuite Char daca aplicaba a fost dervokata pentru A permute colectarea infomnatillor prvina Umhzatorul automzat nu are nevow de instalarea mo uma soft supkmentar comtracepuvele cu dis timbute graturta datanta fleaitktats acesteis apheaha poate fi folosite fand sufcent accesul la a comes intemet s la un program de navigare cu usummta si pentru raportarea alter produse cu regem gratus furmrate pren programele ip Internet Explorer sau Netscape Navigator Versunea recomandata pentru mationale de sanatate browser este intemet Explorer 5 0 sau supeneara Pularea pe alte versnm de browser mu a fost temata Accesul se face cu atopa urma nume de unbzator si a une parole Pentas accesarea aphcatie trebue sa mtroduceti mamele de utthzator st parola care e Asiguratva ca program ul dumnea castra de navigare suporta cogkre um 4 mu are ntn sini anaes Rees pop up unle blocat e Accesarea aphcane se va face de catre un singur utihrator desemnat de catre L aminan mstituta beneficiara mtatea de Management de Program a anisterulus Sanatatu LI
74. xample Monthly report on free contraceptives distribution Raport Lunar de Activitate si Distributie a Contraceptivelor Gratuite Windows Internet Explore acd Raport Lunar de Activitate si Distributie a Contraceptivelor Gratuite pentru Cabinetul MATEOC GABRIELA BRASOV Luna 4 Anul 2007 a vului Marvelon DIU 6 Megestron 4 Prezervative 10 Prerervatrve 11 P Data Expirarii 3006 2007 31012011 30092009 31 07 2007 30 04 2011 Stoc la inceputul hunii 375 00 600 3400 0 00 0 00 Ina in cursul lunii 1662 00 000 0 00 5578 00 2134 00 B Distribuite n cursul lumii 37600 400 8 00 184 00 0 00 E Ajeatari de stoe 0 00 0 00 0 00 0 00 0 00 B C D E 1661 00 2 00 26 00 5394 00 2134 00 ge siimele3 occ 09 500 1200 3004 00 000 H Consum mediu hmar G 3 328 33 167 400 1001 33 0 00 E Luni de stoc disponibil cp ES 650 4 30 0 00 Rapon intocmit de Rapon verificat de Coordonatoral DCG 2 If you want to view Monthly Distribution Reports for contraceptives from providers in other districts go to RAPACCES of InterCON see accessing module in the first part of this user manual 2 Quarterly report on distribution order of free contraceptives The layout of this report is similar to the paper based quarterly reports order forms used by family planning service providers to report to DPHA it contains the following information name of the unit providing the commodities and for each product date of ex
75. y consumption contraceptives dispensed to beneficiaries it contains the following information name of the unit dispensing the commodities and for each contraceptive product date of expiration stock on hand at the beginning of the month entries during the month quantities dispensed during the month perishables stock adjustments stock on hand at the end of the month quantities dispensed during the last 3 months mean monthly consumption and months of stock available In order to generate this monthly report see image below type in the year then the number of the month without blanks between them and click on Run at the right side of the screen f Lexic 1 0 Windows inie nei Explorer o F pim 1 7 9 Sees phy i A p Fr het Raport lunar De Dart e A Contaceptve zaute pE SOCS InterCON 1 0 Raport Luna Pr Uniatte Ce hu Au Fumiat Rapoarte De Conmum ANMLUNA YYYYM YYYYMM UIR ALEXANDRE SCU CAMELIA Rasare I dl ws Antuna Mor vv MM Henid gt Leta ate heroe UNTAT ANLUNAYYYYMYYYYMM Aussa 1 T omesthal De Destributw Comanda A Contra epitveior Gratuite AMYYYY Trimestru um ALEXANDRESCU CAMELIA w Release Art Rape Drecha De Sanglate Put a Forma Timesu Si inde aor LAS TRIBUTE AniYwww 20 trimestru B e Rulears Raport Trimestral Ruieara Raport incicaton tcner EE r Rulesrs Raport Anexaz e Ruleaza Raport Restanter www inter con ro E
76. y the application administrator You cannot change this information you should contact the applica tion administrator regarding any problems experienced during the use of the application www inter con ro Both the user name and the password are case sensitive the application distinguishes between upper case and lower case Wait for the pages of the application to load completely before going to another page The homepage of the application contains some instructions for users these are dynamically displayed in the central area of the screen Also on the left side you will find the main menu that will be permanently displayed no matter what page you are accessing lt Logic 1 0 Windows Internet Explorer Bine ati venit Sunteti conectat cu userul ALBA Din motive de securtate unele pagini ale acestui site sunt valabile doar o ora In cazul in care o pagina expira va fi nevoie sa va reconectati Accesati modulele aplicatiei din meniul de pe bara din stanga paginii Meniurile aplicatiei sunt afisate astfel incat se poata fi accesate la orice moment indiferent de pagina curenta Submeniurile corespunzataare i ecarui modul sunt afisate in bara de sus a paginii e Before leaving the application the user MUST LOG OUT This is done by clicking the icon BI At this moment the user is redirected to the authentication page If necessary the application can be accessed again e The e

InterCON 1.0 - Romanian Family Health Initiative

Contents

Download Pdf Manuals

Related Search

Related Contents