Home

NDS Manual Reviewed 02.08.2006 - United Nations Office on Drugs

Contents

1. Endorsement 4 1 Import Transaction Documents 4 1 1 Import Authorization Request The Requests for import authorizations are filed with the competent authority by the establishments that are intending to import the controlled substances Usually the employees of the competent authority enter the requests into NDS To create the import authorization request you should first create an import document Import Export gt Import Export Document Imp Exp Flag gt Import M Note You will not be able to make any actions until you have chosen the proper value for Imp Exp Flag The Imp Exp Flag switch defines whether the document will be regarded by the system as import or export one Respectively the system will provide a specific set of options for the document Thus if you choose the Import option you will be able to create an import authorization request then import authorization itself proper certificates if needed and finally an endorsement However if you choose the Exp
2. M M Code of the language for which the current AreaName will be displayed in respective Language Code drop downs records reports Name that wil be displayed in drop downs records reports when the language corresponding to the LanguageCode is selected by a user Se Defines the order in which the area name will be displayed in related drop downs records reports Area Name Comments Any relevant comments and or remarks 3 7 4 Region Master and Region Country Relation Master As the Areas are parts of Countries the Countries may be parts of Regions The concept of Region in NDS is different from the one described in the 1971 Convention and stands for A group of countries united by geographical political or other characteristic features for statistical or other purposes and treated as a single whole Region Master is intended only for indication of RegionName in various languages while Region Country Relation Master is used in order to indicate which countries comprise certain region 3 7 4 1 Indication of Region Name Re
3. Estimate Import Limit The Estimated Assessed quantity of the Substance Maximum permitted quantity to be imported during the year in question Se Export Limit UOM Maximum permitted quantity to be exported during the year in question Unit of Measurement for the substance You cannot modify this value either as it is fixed in Substance Master User Manual 62 In case data are already entered for the Country you can make the data entering process much easier and less time consuming There are two specialized toolbar buttons provided in the Permitted Restricted Substance Master Button Name CH lt CopySubstanceDetails gt 2j lt CopyAllDetails gt The first one copies all codes and names of Estimated Assessed substances from the previous year to the form of the current year The estimated assessed quantities as well as import and export limits will be set to zeroes Figure 64 Action of td eect button The second button copies codes names and all indicated quantities Figure 65 Action of gi Late button 700d oc 700d oc n oo g o wy owy 00 89 ooon awy awy ow g 00 zw zw 00 89 000 0 342000 0 o M Note The entered quantities will be refer
4. Quantity Approximate quantity of alkaloid to be obtained User Manual 119 6 1 2 6 How to make a supplementary estimate Supplementary Estimates may be created using the same Form B as the original Estimates Create a new record fill in the Header fields except the SupplementNumber and open the Supplements tab Whenever you enter the country year combination which already exists the system understands it as an attempt to create a supplement Thus the SupplementNumber in newly created Form B will be different from 0 and will represent the number of supplementary estimate Figure 136 Supplements tab Remarks Medical Practitioners Drug Estimates synthetic Estimates Opium Estimates other Estimates Race Substance Code Substance Name Qty Consumed for Quantity Preparations Substances Quantity Qty in stocks l domestic medical and utilized for in Schedulelll not covered to be at 31 Dec of scientific purp manufacture of the by the added to year to of Other 1961 1961 special which the Drugs Convention Convention stocks estimates 4 w F oro gt vj Alkaloid Code Alkaloid Name Qty Consumed for Quantity Preparations Substances Quantity Qty in stocks domestic medical and utilized for in Schedulelll not cov
5. Name of the customs point as entered in details section according to the language selected ee eee eee eee Name of the customs point to be displayed when the language corresponding to LanguageCode is selected Full postal address of the customs point in the language corresponding to the LanguageCode QO M M M M Comments Any relevant comments or remarks concerning the PointName All fields in the Header section of this screen are mandatory Chapter 4 Import and Export Transactions The international control of controlled substances is carried out on two levels domestic and international ones In this Chapter we will learn in details how the import and export transactions shall be recorded and accounted for with NDS Any international transaction with controlled substances consists of the following stages Import transaction Export transaction Request for Import Authorization Request for Export Authorization Issue of import Authorization sue of Export Authorization Request for Import Certficate s 10 Endorsement 000
6. OO m Reouest Ote RETIE GEETE n EEE EE e o EE EAE A E E nulla 1 1900 E 2201 E a 01 01 1960 E 31 12 2016 21 Me 07 01 1960 t 122015 a A 01 01 1980 ist 12 2016 a Endorsment amp Certificate Dates r Substance Name O0Preparation Name Endorsement Certificate Substance i Mig 01 01 1960 EE 31 12 2016 Z 01 011950 180 31 122016 E EEEE ALL Psychotropics OTHERS WEE Narcotics C Precursors Quantity Conditions _ _ e lt _ i i lt qmunAo _oeicr tS Sched in Schedule Ind icy ALL C C I C I C Iv C F Certificate Conditions Reference Authorization Country Establishment Trading Country Trading Establish Request Subst Prep Request UOM E Number No Date Quantity mm IMP DOK P 35 000261 NK Uzbekistan Dori Darmon Russian Federation Movosibhimfarm 04 11 2003 3434RUS 8 360 00 pack 4 3589 2003 shareholding company IMP JOK P 05 12 000322 NK Uzbekistan AO AHAMKOH Russian Federation Novosibhimfarm 16 02 2005 3434RUS 9 360 00 pack 4 399 2005 Aopu fapnion IMP JOK P 03 1 000247 Nk Uzbekistan PB3II Yswegskcnopr CYPRUS Medochemie LTD 24 12 2002 545454CYP 10 940 00 amp 4 324 2003 IMP JOK P 04 12 000297 NK Uzbekistan Dori Darmon Russian Federation O40 dapwcraHaaprT 14 04 2004 565558DEN 40 000 00 pack 4374 2004 shareholding company OKT abpe IMP JOK P 13 000259 Nk Uzbekistan TaukenrTckWit ofn TAO IRAN
7. Language Code Comments ENG v GENERATED BY SYSTEM ea I3 si User Manual 80 The following data should be indicated Field Header section Region Code Region Name Country Code Country Name Relation Code Relation Name Details Section Language Code Relation Name Value Code of the region Name of the Region corresponding to the RegionCode Code of the country constituting the region Name of the Country corresponding to the CountryCode Code of the relation a treaty act pact other document or characteristic feature on the basis of which the countries are united into the region Name corresponding to the RelationCode Code of the language for which the relation name will be displayed in drop downs records reports The relation name for the current language code 3 7 5 Indication of official signatories for the Country Signature Master When the competent authority for a certain country has a substantial workload of issuing authorizations for import or export of narcotic drugs and psychotropic substances it may become necessary to automate the process of signing the import authorizations import certificates and export authorizations The Signature Master makes it very easy to do Start the Master as follows Masters gt Demographics gt Signature Master Figure 89 Signature Master Azizov AK AS ISOBVIK AZIZOV User Manual 81 To enter a new Signature do the fo
8. place where the seizure was conducted e g in illicit laboratories commercial warehouses or customs area etc Name of Substance Intended Intended Illicit Manufacture Licit Uses the name of the narcotic drug or psychotropic substance that was intended to be illicitly manufactured using the substance seized Remark confirming that the seized substance was really intended for illicit manufacture not for some legal purposes volume and extent of the illicit manufacture of the above narcotic drug or psychotropic substance licit use of the substance seized including extent importance etc User Manual 137 6 3 4 How to ind
9. 6 1 2 1 How to indicate the background information and describe the method of estimates To provide the background information you should fill the following fields of Header and Medical Practitioners tab Field Value Header Country Code The code of the country the estimates elateto dueantyHase Name conesponds rete jjj Year The year towhich the estimates relate ee This field indicates whether this form is an original estimate or a supplement If it is not Supplement Number displayed at all then the form is recognized as original estimate otherwise if it is E a ee eee es No Of Doctors Number of practicing doctors in the country No Of Dentists Number of practicing dentists 00000 No OfVets Numberoveletafan 5000 No OfPharmacles Numberofwoigphamades No Of Hospitas Number ofhospitalsinthe county NoOfBeds 0 Totdnumberofhospialbeds Methods of Metodi used for calculation of estimates 0 M Note The MethodsOfDetermining field is mandatory If no changes occur in the estimation methods then you should indicate that no changes have been made User Manual 115 6 1 2 2 How to indicate the information on annual requirements of narcotic drugs For this purpose you are to use the Drug Estimates tab of Form B Figure 132 Drug Estimates tab Remarks EY Ovws estimates Synthetic estimates opium Estimates other Estimates supplements Substance Code Substance Name Qty Consumed for Quantity
10. Note The UOMDescription field in this tab is not the same as the UOMDescription field in the header Here it represents the unit of measurement in which the controlled substance is reported on respective forms to INCB Work with this tab will require some mathematical input from the user because he she will need to indicate a correct volume quantity of controlled substance in a preparation unit so that the system will be able to make other calculations _ Cru Nw za 7 where if UOM Qy gross quantity of controlled substance Cvu concentration of controlled substance in one volume mass unit of preparation Nvu quantity of volume mass units in one unit of preparation Nuom number of mass units in the reporting Unit of Measurement We used the term volume unit to avoid confusing with a unit of measurement term Here volume unit represents the measurement unit that is stated on the preparation label It may be gram milligram or kilogram User Manual 51 Although the formula looks a bit complicated the below mentioned example would make it clear Example We have a preparation in 3 ml ampoules containing Morphine Hydrochloride solution of 5 mg ml concentration Preparations come in packs containing 10 20 or 40 ampoules Consequently the gross quantity of Morphine Hydrochloride will be 2 _ 0015 1000 As you see we first multiplied the concentration of the substance 5mg ml b
11. Domestic Trade form EMM gt EMM Domestic Trade 5 User Manual 151 Figure 165 Domestic Sales Details tab Consumed Domestic Purchase Details Domestic Sales Details Tha ur d Establishment Establishment Name Subst Prep Code Subst Prep Name beaded bale baud Ea pecore Date Code Qe ss gt Let us consider an example with an Establishment A selling 5 grams of ephedrine to Establishment B wholesaler and 3 grams of ephedrine to Establishment C retailer The transaction takes place in 2006 Then the records to be entered will be as follows Establishment A Year 2006 e Two records 5 and 3 grams of ephedrine in Domestic Sales tab Establishment B Year 2006 e 1 record for 5 grams of ephedrine in Domestic Purchases tab Establishment C Year 2006 e 1 record for 3 grams of ephedrine in Consumed tab The System also will automatically create one more record Establishment B Year 2007 e 1 record for 5 grams of ephedrine in Opening Stocks tab of EMM Stock Management form So that the purchased ephedrine will be properly accounted for during the following year Note The Domestic Sales and Domestic Purchases tabs are identical 7 3 2 How to Compare Domestic Sales and Domestic Purchases Technically from the accounting point of view any record in Domestic Sales tab of selling company should be reflected by the same record in Domestic Purcha
12. The functioning of all drop downs is the same e Click on the down arrow to open the list e Click on the desired value User Manual 20 Figure 11 Example of an Open Drop down Box Exp Country Code Exp ESHDSEY Mame oS E Country Name Uzbekistan VAMNLIATLI VEMNEZLIELA VIET MAM WALLIS AND FUTUNA ISLANDS IRIAN JAYA For example if you know the code of a substance start entering it in SubstanceCode and the system will automatically complete both SubstanceCode and SubstanceName fields following the code you are entering Substance Code Substance Name mmoos 0v MORPHINE ge Vice versa if you start entering the SubstanceName the system will keep proposing the name options until you select the one you need In this case the SubstanceCode field will be completed automatically Substance Code Substance Name NMOOS ge v MORPH ng MORPH ng You can not only select the data from drop down lists but also add and edit such data Double mouse click on any of NDS s drop downs evokes the special form called Master which enables the user to manage the data in the lists For example we have some Sample Country from which we import controlled substances for the first time and in our system there is no establishment for this country Exp Country Code Exp Country Name Sample Country E Exp CA Code Exp C4 Department Name Exp Establishment Exp Establishment Name Code Name Once you double
13. eae 12 gt Alkaloid Code Alkaloid Name Quan tity Comments We hcoz1 Conc Of Poppy Straw M AMA CONC OF POPPY STRAW M ACA CONC OF POPPY STRAW M ATA NC022 NC023 Both CPS related tabs are subdivided into fur logical parts Substance Section upper left Alkaloid Section upper right Country Breakdown Section middle e e e e Alkaloid Breakdown Section lower The following fields should be filled in each section Field Value Substance Section Substance Code Code of the reported concentrate ee Total Imports Entered Total Exports Entered Total entered in red or aggregated in black quantity of imported exported CPS ee Alkaloid Section Imports Entered ee Exports Entered Total imported exported quantity of the alkaloid Country Breakdown Section Country Code Code of the counterpart country Country Name Name of the counterpart country corresponding to the CountryCode Quantity Entered Quantity imported from exported to the counterpart country Comments Any relevant comments remarks on the import export transaction User Manual 113 Field Value Alkaloid Breakdown Section Quantity Entered Quantity of alkaloid imported from exported to the counterpart country Comments Any relevant comments remarks on the transaction with the alkaloid 6 1 2 Form B Annual Estimates The Form B should be transmitted to INCB before July 1 of the year
14. National Drug Control System NDS 6 0 User Manual CERNY UNITED NATIONS SZ Office on Drugs and Crime Table of Contents FOREWORD eee erect eo a ae ee T CHAPTER 1 SYSTEM LOGIC AND BASIC PRINCIPLES scccscesecneccuecneeeueeneeeueeeeeeuseneueuseneeeuseueseuseeeeuseeeeneeneseeseaeens 9 1 1 Transactions on international level ccccccccesseeesseecenseecenseseseesenseeeeaseeenseeeeasesoeasesonsseeeenessoas 9 1 2 Transactions on national domestic level ccccesseeeeesneeeecenseeeenseeesoesseeseeseeseoeseeesonneeeees 10 1 3 Masters Service Modules uassetnsdsispidi ranisvirERSdS AM UNA RUN NES UN USENU IN VNNN VEU KENN MN NNNM OU NEKEN NN 10 Meh RODOS sce ance dees E vedanta U m 10 wo ea AWM CS Sa SCCUR arses seca a Serene deen ea kt 11 1 6 NDS Manual text markup and notations cccccceseesseeeeeeeeseeeeeeenseeeeseeesseeeseeesseeeseoeesseessooeneees 11 CHAPTER 2 NDS FUNGTIONALITVY ius cbucuxis iesus vepE CH casia e uan usua EE AEE 13 PES NDS M 13 2 2 LOGGING Into TAG SY SCI viaccess states aa Fac Oca aw d a E Cile ue dna NE Lud rap NR done ev RON 13 2 3 Setting Application Languagge ecce eL Leeeeeeecc ll iieeee enne enn n anna a nn sees assa assa anra n sna nnns 15 2 4 Menus and Toolbars eeeeeeeeeeeeeeee enne nnn nn nnn umha manua aaa IRR IRR IRR RR R RR E SRR RR SNR RR Sra Ra
15. This tab consists of three logical parts e Substance Details Section upper e Export amp Import Details Section middle e Licit Purposes Section lower First indicate the substance legally traded in the reporting country during a reporting year Il Second indicate the countries from which the substance was imported and the countries where to the substance was exported Do not forget to indicate the quantities imported from or exported to each of the countries Il Third indicate the purposes of licit use of the substance together with the approximate quantities required for each purpose User Manual oe 152 Licit Uses and Trade tab Licit Uses and Trade Tilicit Manufacture Manufacture Methods of Diversion Stopped Shipments ani wf ani wf Acetic Acetic anhydride Acetone wf 322 087 314 an3 wf Anthranilic acid 0 10 po17 wf Phenyl 2 propanone oxime 0 005 so31 aw Saf role 0 005 pe icso02 v pupwiaid vj 14 488 464 que erm e E Origin Country Code Country Name Import Quantity 3 005 vr 4 Ps Q usma 0 00 bkn IR sw GERMANY ow 1 289 007 TAI viIRAN 10 00 REPUBICOFKOREA 156 384 Rus RusinFedeain 13 032 273 SAF y SOUTHAFRICA oy 0 80 qp I 318 eror production manufacture purposes You may enter the following data here Field Value In the Substance Details upper part E Su
16. 1 Importing establishment requests an import Exporting establishment requests an _ export authorization from its competent authority authorization from its competent authority The competent authority checks whether the requested quantity exceeds the quota of this substance in estimates assessments for this year Also the competent authority verifies if the im imported substance s The endorsed export authorization then shall be returned to the competent authority of the exporting country porting establishment has proper license s for transactions with the indicated substances and the requested quantity does not exceed the remainder of limit set in annual estimates asses sments If the request is authorized the competent 3 authority of the importing country sends the import authorization to the competent authority of the exporting country The competent authority of the exporting country checks whether the exporting establishment has 4 proper licenses for dealing with the requested substances and if yes approves the export authorization request 7 Exporting establishment transfers the expor 6 authorization along with the import authorization to the customs body of the exporting country The customs body of the exporting country makes the appropriate endorsements on the export and import 7 authorizations stating the actual quantity of exported substances crossing the border and then sends them to the customs body of the i
17. Domestic Purchases 2 00 package s lozenges Closing Balance 12 00 package s PREP 1 BROMOCOD N 10 MG 70 Opening Balance 0 00 package s lozenges Consumed 0 00 package s lozenges Closing Balance 0 00 package s Actual Trade Detailed Transaction Date Establishment Prep Type Poka Quantity odas p gt ImP 839 2006 27 4 06 Farmacia Sant Antonio Bissone SA PAST 30 10 00 package s A Stock Ledger report Actual Trade query is intended for rapid viewing of the quantities of products in stocks as well as the transactions with them The only difference from the previous Stock Ledger Report is that it is not converting the actual trade to base equivalent values but presents the actually traded products The Stock Ledger screen consists of three logical parts e Criteria e Actual Trade Total e Actual Trade Detailed In the criteria section you may enter various criteria for querying the data Please note that Year field is mandatory In the Actual Trade Section you may see the Opening Balance for particular Product transactions affecting the stocks and Closing Balance of this Product Actual Trade Detailed section hosts all the transactions that made the displayed total of this Product and this Transaction Type displayed in Section 1 Note Double click on every record on Stock Ledger opens respective record in EMM User Manual 147 7 2 How to indicate the manufacture related data For indication
18. EMM gt Domestic Purchases Sales Figure 167 Domestic Purchases Sales report Year 2006 Narcotics Precursors Establishment S oo Schedule Ind e ALL C I C I C IH C Iv C Trading SuhstiPren T A Substance Substance Name Establishment Trading Establish Purchase Quantity Sale Quantity ae d qMOO9 Morphine Taukenr rop FAO Jopr aapmon Taukenr rop 40 Jopr aapmon Acetic anhydride SuperPharm AN y36ekncroH AOpH TAbMHHOTH 10 000 000 L Morphine Taukenr rop 40 ZopuH AapwoH PBN smea3Kcnopt 0 000 2 003 G Row 173 Actual Trade Preparation Preparation Name E74 Prep Type Purchase Quantity Sale Quantity Es actores Russe dE Code UOM In the upper part of this form there are indicated the names of transaction participants and in the lower part the information upon the substances traded M 3 Note When querying do not forget to specify the criteria in the fields marked with red circle User Manual 153 7 3 4 How to detect discrepancies in domestic trade data The Domestic Purchases vs Domestic Trade Discrepancies is intended for detection of discrepancies i e the situations when the purchase data does not coincide with the sales data See also Report Queries section EMM gt Domestic Purchases Sales Discrepancies Figure 168 Domestic Purchases Sales Discrepancies Report Country MEEN Ststonce Tyee Frm C Psychotropics C OTHERS Year 2006 Narcotics Precursor
19. Opening Stocks tab a user is supposed to enter date of entering the data on closing stocks TransactionDate code and name of controlled substance in question Subs Prep and Subs Prep Name and make necessary notes Remarks Please take into account two neighbouring fields ClosingBalance and ClosingQuantity The first of them shows the quantity of some substance or preparation calculated automatically The second is provided for manual entering of quantity if it differs from automatically calculated one User Manual 145 7 1 5 How to view a Stock Ledger EMM gt Stock Ledger Report Figure 158 Stock Ledger report Year ll Split on Establishment Substance Type Schedule Ind Establishment 5 3 Subst Prep NN Base Substances C4001 ACETIC ANHYDRIDE 10 024 00 liters CA002 ACETONE 1 452 553 15 liters CA003 ANTHRANILIC ACID 0 10 g CEO001 EPHEDRINE Opening Balance 3 43 q Stock Adjustment 25 00 q Procured Withdrawn 20 00 q Closing Balance 8 43 g Actual Trade Total Opening Balance Substance Code Substance Name Prep Type iiic Quantity Euro Esa Base Quantity Base UOM pe cE001 EPHEDRINE 0 16 g CEOD1 0 16 g TIPETT 83 l IPETI 83 AMP 10 8 00 pack CEOD1 3 28 g Actual Trade Detailed na EPHEDRINE Date 01 01 2006 Pec Hayu HCC KPHM LLeHTD HM 0 08 CEO01 0 08 g E 01 01 2006 X l ocyaapcrBeH LleHrp skcneprHs 0 08 g CEOO1 0 08 g 1 12 07 2006 Nestle Uzbekistan MChJ
20. Pure Substance Master If you need to enter new pure substance as well as add or change the language related information on particular Pure Substance you may use the Pure Substance Master which may be opened either upon double clicking on the PureSubstanceCode field of Substance Master or from the Masters menu Masters gt Substances gt Pure Substance Master Figure 39 Pure Substance Master form Pure Substance Code EE tiom oo Language Code Pure Substance Name Sort Description Comments ENG Zolpidem Zolpidem N N 6 trimethyl 2 p tolymidazo 1 2 a piridine 3 acetamide In the Header section you should indicate the Code of new Pure Substance Note Before entering new PureSubstanceCode make sure that the same Code does not already exist in the system You should use the Query feature for this purpose However if you enter the Code that already exists the system will produce a warning message In the Details section of this form you may enter the name of the Pure Substance in the languages you are using Field Value Language Code Code of one of the Languages recognized by the system Pure Substance Name The name which will be displayed on the screen or in printed forms every time the respective Language is set Sort Description The content of this field defines the place of the Substance in the Pure Substance Code p drop down in the Substance Master form Comments Optional comments concerning the PureSubstanceNa
21. Sulphuric acid 124 950 00 124 950 00 124 940 00 liters O 8 CaMapkaHACKMHA xir KYRGYZSTAN AOOT Maltinyy cyyltc Sulphuric acid 65 160 00 65 160 00 32 037 00 liters PM c00022 ODAO Navoiazot Republic of Tadjiki COOO Netponeym Cy Sulphuric acid 32 580 00 32 580 00 31 656 90 liters Total Trimeperidine 5 60 5 60 5 60g This report is used to briskly retrieve the data on the completed export transactions i e the transactions on which the endorsements are already made and the substances that are accounted for as exported When the query is done the results are shown first as a list of substances So you should click on the sign of the right side to view the details 4 6 XML Export There is a new feature in NDS 6 0 i e the opportunity to export the export import data in XML format For this purpose a special button is provided in the upper right corner of the Import Export Document screen Export as xL PEM When you press it the XML generation dialog box will appear I PEN XML Export f Export current record only if valid PEM C Export Following na of valid PENs C Export all valid PENS Please press start to generate xml Cancel Choose the necessary options for XML export and press the lt Start gt button The XML file will be generated Chapter 5 Licenses Licenses in NDS are documents issued by the competent authority of a given country legally authorizing its resident establishments to h
22. nmasc r TaukeHT FO0031 r TAWKEHT MaccHE Cebsap Ll r CawapkaHg 703058 vn Hapni 700126 r TaukeHT yn YCMAHE Y3bekWcTaH r00179 r TAWKEHT 710008 r hgh noc XapKon r 3apaguaH Wo Hasonhckaa obnact CITY rodd Tashkent STREET 16 K Umarov passage Usmankhodiaey str User Manual 73 To actually import establishment related data into the system do the following Download the necessary XML file Open Import Establishment List screen as written above Browse the necessary file with Select File dialog box press the lt Open gt button Select the establishments you need Press the Save button to store newly imported establishments in the system 3 Demographics This sub menu invokes the master forms used for managing the data in drop downs related to various countries members to drug control Conventions 3 7 1 Country Master Masters gt Demographics gt Country Master This form manages the name of a Country as displayed in Country Code and Country name drop downs throughout NDS as well as other data associated with the particular Country The Country Master screen consists of Header and three tabs e Language e Convention e Annual The following data should be entered in the Header section Field Value Country Code Three letter code that represents the country throughout the system Name of the country displayed according to current Language selected for the system
23. Authorization form Figure 125 License Amendment form License Number Previous License Number Signature Establishment Code Establishment Name Contact Person po Dori Darmon shareholding company E mail Address Approval Date alid From alid To Phone Number 28 JUN 2006 28 JUN 2006 28 JUN 2007 Conditions Remarks Substance Details License Types_ Linking Substance Details Subst Prep Group Code Subst Prep Group Name No Of Units UOM Requested Qty Approved Qty Substances Preparation Groups NF001 FENTANYL b 10 00 10 00 amp Substances Preparation Groups TiPETI 414 MORPHINE HYDROCHLORIDE 3ML sil Boxes amp 5 8 License Reports Licenses gt License Reports Figure 126 License Report Establishment Split on Substance Establishment JEMETUIM s Psychatropics C OTHERS i C Narcotics C Precursors Request ee a aae a 01 01 1960 31 12 2016 E ISAN 01 01 1960 9i s1 12 20 6 a TC Approval Date p MM a a x License Number License License License CA Name Establishment Request Request Request Request Status E Approval alid From alid To Number Date alid From alid To 123 28 06 2006 28 06 2006 28 06 2007 Ministry of Health Dori Darmon shareholding 123 28 06 2006 28 06 2006 28 06 2007 Active 1 company MARCI 12 07 2006 08 06 2006 08 06 2007 Ministry of Health locyaapcrBeH LlexTp MARC
24. C with the same country year combination as in some existing Form C NDS will display a warning message In this case you should delete the newly created record and open the existing one by means of querying The Statistics tab consists of two logical parts e Drug Details Section upper e Alkaloid Details Section lower The following fields should be filled Field Value Code of reported narcotic drug The field is a drop down box containing the codes and Drug Code names of narcotic drugs only Drug Name Name tag for the DrugCode UOM Unit of measurement in which the quantity of substance is reported Data on the quantities of drugs manufactured during the year in question It should be Quantity Manufactured noted that for each substance the data entered in this field should reflect an aggregate LLL figure of the data entered in Manufactured tab Should be used to enter data on the consumption i e on supply of a narcotic drug to Quantity Consumed any person or enterprise for retail distribution medical use or scientific research during ieee eee entre eee Sa _the year in Question 4 t t tr tt ttr ttes Shanty Hees tortne Should be used to enter data on the quantities of drugs used in the manufacture of manufacture of hedule lil PI h hould indi h iti ED f Schedule Ill Schedule IIl preparations Please note that you should indicate the quantities US Or Preparations manufacture of preparations not
25. Dr Abidi Pharmaceutical 30 04 2003 5 1 8 242 N 01515BEL 1 000 00 pack 4 335 2003 lopnh gapwoH Lab User Manual 95 4 5 2 Import report Import Export gt Import Report P9 This report shows the quantities on other related data on import of substances from a country indicated in the TradingCountry field When the query is done the results are shown first as a list of substances So you should click onto the sign of the right side to view the details Please note that the transactions retrieved by this report are not necessarily completed i e there can be no endorsements made on these transactions To view the completed transactions i e the ones on which the endorsements are made use the Endorsement Report Import Transactions Figure 108 Import Report E rt authori irieation v BENE GREET con EINES EESEED NHMHNNNES S o 01 1950 ei 51 12 2016 SRI 01 01 1950 e Base uerty Actual Trade Country Quantity Quantity Quantity IT 3 4 Methylenedioxyphenyl 2 pi O00 liters rotat Acetic anhydride 1 013 01 13 01 13 01 liters 4 rotat Acetone 646 935 281 90 646 935 281 90 96572 535 55 liters Total Acetyldihydrocodeine 50 50 10g 4 rotat Alfentanil 150 00 160 00 80 00 g Total Allobarbital 1 00 1 00 05g 4 rotat Alprazolam 1157 79 1157 79 1 087 57 g 4 5 3 Endorsement Report Imports Import Export gt Endorsement Report Imports Figure 109 Endorsement Report Imports Type ARR a
26. RR raa arUA 15 PRA 1 NISIDIHAVIBEIU E edu vEP EPPRNaP NU T ET T A E AA bea MERI PRIROEDEI MIND N MIN T D MU EESHUEN RUE 15 24 2 ACCESSING he MENU RP E REOR M MT 16 2 4 3 Special Keys amp Shortcut Keys ccecccccccececeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeseceeeeeesseeeseceeeessssaeeeeeeeeeeesessaeaeeeeeeeseeaas 16 ed 4 COMMON Toolbar B BIS Sueciae E E decim tari teet I nU imonm ad pure UNE 17 2 DIN AV rere mc 18 Ge OS ON ICUS Mac 18 2 6 1 Editable Text NUMBEN Fels sicscoe cua ETT mmm 18 CR ELM GANT TTE mT 19 NON oe 19 PNIS GI deo Gee en ee ne ee ee ee A A eee 2 19 Bs OOO OOS NET uu m 19 2 7 Data Entry Screens uico sicanaceeacuseucdonasavaiace sees siunssansanamendus aneauedaansauaannaanevadyincuvanaualavsanaadsaysvanddonasune 21 2 7 1 Single Record Entry SCree n e E OEE 21 2 7 2 Multiple Record Entry SCree n ccccccccccccccccccecssseecceceeeeeeeeeeeceeeeseeeeeeeeeeeessaeeseeeeeesesseeeeeeeeseeeseseaaeeeeeeeseeaas 21 eu AC ACS Stall SSte8lieuetie sue E vimm Oe IU D Med aaseutoewasurtarcunnnie 22 2 54 RONO SC ENE eee en en E eee ene euet oi dida opo ditm e usua UI euim ga Ru etie 23 2 8 Operations with HeCOFUSueaunduiaiiuicsun uuum cxli anu euKqudve EaEeeirsuaE Uoc ca usn DNE ME uisi casu URP cERUNn a mnnn 24 2x
27. Substance Name UOM Oty Conversion Base Base Calculate j D hi 1 000 gram s i Code olume factor substance quantity OLECULAR SIEVES kilogram s 100 100 00 CM015 45 000 00 COOSPHOS 0 CODEINE PHOSPHATE HEN gram s 01 74 00 NCOOS 333 00 O001 OPIUM CRUDE gram s 00 100 00 NO001 90 00 oe i ft gt oi mm 3 Point of Entry Point of Exit Mode of Transport Shipping to a bonded warehouse not allowed Receipt of authorized goods must be confirmed to Swissmedic upon arrival 2 16 MyNDS In NDS 6 0 a new feature has been introduced the MyNDS button It allows users to customize NDS by adding their own features 2 17 Exiting NDS Click on Exit Application option from the System menu or press Ctrl lt Q gt on the keyboard or click on the Exit Application Button on the Frame toolbar to quit the application Chapter 3 Masters These modules are intended to facilitate a more convenient and effective organization of basic data So if a user needs to enter a new substance preparation establishment or create a record for either of above mentioned in a new language then he she will use the Masters module 3 1 Substances The Substance Master is one of the cornerstones of NDS Substance Master is used to define the attributes of Substances controlled on international level by INCB and on local level by respective competent author
28. Type of Preparation Preparation Type Master cccccceeeeseeeeeeeeeeeeeeeeeeaeeeeeeaaeeees 49 3 2 3 How to indicate the name of the preparation cccccccssscecceeececceeececceueeecseeecceeeessaueeesseeeessuseeesseseeessaes 50 3 2 4 How to indicate the substances the preparation contains cccccecccceececeeeeeaeeeeeeeeeseeeeseueesaueessaeeesaeeeeees 50 3 2 5 How to indicate the size of a DacKage sa ePi tede Dee ch ibo o Ute OM beue eas 51 3 2 6 How to indicate relevant comments cccccsccccssscecceeeeccceneecceuseecceeeecseueeeceaueesseseessaueeessageeeessueesssseeessags 52 3 2 7 How to export the data on Preparations cccccccccssecccceseecceeseecceueeecseueeecsuseeeseueeecsaueeessaseeesseusesssaneesseaes 53 3 2 8 How to import the data on Preparations ccccceccccsscccceeecceceeeceeceeeeeeseeececeueceeeeeecessueeeessueceesesaeeetseeeeesaees 53 3 3 COMPELENT AuIhorilies oor eire rini eo bie E ro asser eae ee use i ev dk eei o pea Ev i RI Ra cL Pega ead 54 S392 Competent AUNO VIS GT aridan debe eant En eaten on eso otc endet o ea peccunie bd ea qu qe ea 54 30 2 CA COmmURICAHOMIM ASIC E E E 57 9 9o95 CA FUNCION MISE oie rode iui ode ei P Ded quei eliam eee seed E AED E MM e eee 58 3 3 4 CA Department Mastek usines eu eaae diei Modan massi um dE es ecl ca esque lutea fM cc tcied MM ecd D LM Su aD 59 3 4 Permitted Restricted Substances ieri eer crore a uc ou ga e Yee EU co eund R ENS
29. Yn M Meupnynatopa g 1 a UZB 000545 UZB_ ESTB UFB_0009 LIzB ESTB LzB 2018458 LzB 02157438 UZB 05022664 UFB 07621385 UFB 123 UZB 15210887 UFB_ 15341283 LIZB 15397262 UFB 21212121 UFB_990 9 LIzB FIPERTIP 104 18 Le m AIT y3BekacTon Jlopi TabMWHOTH r TAWKEHT 7 nnsa SuperPharm 700021 FOFO02 Dori Darmon shareholding company Chip apMHCKME 05n opW agapwoH UB ESTA Chpgaphkckeh ofnactb OO PynacTe UZB ESTE r Taurenr M Y nyrBekckbWb paltoH vn UZB ESTB 700088 r TaukeHT yn Ypasbaesa g HaBOMMCKMM ropHo weTannypnageckai UFZB ESTA 706800 r Hason yn Hago g 27 PB3 1 y3wenskcnopr Bora Gamich Dorixenalari Goo TawKeHT CK 05n TAO Hopa agapioH LIZB ESTB yn cy Xoc Xo 2 r TAWKEHT y n31 LUzB ESTB r TawkeHT FOO003 yn Onmasop g 15 dacTHaa npaWseoacTB Topraeas komnl zB ESTB r TaukeHT mnaccas Cebsap LI 17718 UZB ESTB r Camapiang 703058 yn Hapnah g 5 Ysbekcka amp mwepikaHckoe CT1 KawannallzB ESTB 700128 r TaukeHT yn YcwaHa KOcyri LUzB ESTB YsbekwucTaH 700179 7 Taukenr C Pax UuzB ESTB dacTHaa anreka Hypaber Ovpma Acknenii Ilercknsn gom Mypy B gar H21 A A A A A A A A A A A A A A A Cn s JoHney NST Komnar 10008 r AHAHAH noc amp apkon Uza 00010 Uza 00010 UZ6_ 00070 FOO002 Tashkent STREET EST_MAME 16 K Llmarav passage Uemankhodjaey str State Expert Center and Standartization of medical means 3 6 6 How to impor
30. any screen s data in the table format Let us take a Preparation Master s Header as an example The data looks as follows Figure 27 Form view TB x rabm cec E T4 pda ZDUP DU sone Poca LU DRE LOT Freparatk To view it in a table format just press the Ctrl lt F10 gt combination Figure 28 Grid table view Grid Precentation Preparation Code Ean Code mars 2003 P 0002 on m NOT SPECIFIED z2003 P Dn003 31225 COMPRIMENS WOT SPECIFIED 2002 P 0004 COMPRES NOT SPECIFIED 2002 P 0008 j SUPROSITOIRELS HOT SPECIFIED 2003 P 0006 PRO SUPPOSITOIRE S i HOT SPECIFIED 2003 P D007 SUPPOSITOIRE S NOT SPECIFIED 2003 P 0006 COMPRIM LS HOT SPECIFIED EFFERVESCEHT S Ea 2003 P 000r M S 7 HOT SPECIFIED 2003 P 0010 COMPRIM S S CABLELS NOT SPECIFIED 2003 P 001 L p SLIPPOSITOIRE LS NOT SPECIFIED 2003 P 0012 i COMPRIM LS NOT SPECIFIED PELLICULE S 2003 P D013 l COMPRIME S S CABLE S NOT SPECIFIED 2003 P 0014 FLACOS mL MILILITERS WCG WII WC Now you can see the header data in the table view Also you can print them out or export to Excel for further processing User Manual 34 The additional Grid View Window contains 3 features accessible by clicking on any cell in the Grid with the right button of the mouse Select the requested option from the pop up menu Quick Filter Reset Quick Filter e Goto A new pop up window is open the user can star
31. as follows Parameters gt Language Master 5 Figure 178 Language Master Language Code Language Name Sort Description hrabic Comments Arabic Language fas fas I If you do not find the necessary language in the list of available languages and would like to add one do the following Add new record opecify a three letter code in LanguageCode field Specify a full and correct LanguageName Enter a string by which this language will be sorted in the language list in SortDescription field Enter necessary comments optional Save the record RL Ras coe a From now on the entered language will be displayed in the list of languages recognized by the system User Manual 164 8 2 4 Custom Numbering Custom numbering is a simple yet powerful feature which allows users not to enter manually various document and or transaction numbers but provides an opportunity to program the system to do it automatically The Custom Numbering Master is started as follows Parameters gt Define Custom Numbering Figure 179 Custom Numbering Master Pee uve cout comet tourpe o Code cedere coves cedere codes pener feet susan y TT TENENM fet z aek L zm Export Authorization EXP 1 x r2 a bisce r 7 eae EH 3 3 3 3 A Import Authorization IMP 1 rj zl r2 2 pice x o Preparation Text nPen 15 iv a Define p Numbering Substanc CodeiType C
32. box shows the numbers of currently valid licenses an MM a ummm mI UNUM Figure 123 Fields to be filled for License Extension Establishment Code Establishment Name Dari Darmon shareholding company Valid From alid To EXE pce eoc oe 5 6 2 Renewal of Expired License The license may be renewed for a new term after the expiration License gt License Renewal gt Renew Expired Licenses To renew the license you should fill in the same fields following the same rules as in case of license extension Figure 124 Fields to be filled for license renewal Establishment Code Establishment Name poosas NEENMNMMMEMEMEEEEE ESE Jd AEN Approval Date alid From alid To 11 JAN 006 D1 JAN z006 N1 JUN 2006 June 2006 EB CI B ES E 1 z 3 4 5 5b 8 8 10 11 12 13 14 15 16 1 18 19 20 21 22 23 24 OR 2E 77 2n 7 an Remarks Technically the only difference of license renewal form from the license extension form is the LicenseNumber drop down box which shows the numbers of expired licenses User Manual 107 5 7 How to amend a License You may amend the already issued and valid license Amendment means that you may not only add substances but also delete them and alter the approved quantities of substances as well as change add or delete the types of licenses License gt License Amendment 9 The rules of working with this form are the same as the rules of working with a License
33. click the ExpEstablishment field the Establishment Master will open Here we may enter all necessary details for new Establishment W Establishment Master Country Code Country Mame smc SarpleCounty we Establishment Code Establishment Marne 2006 1 2661 _ heamsa Establishment Type Code Establishment Type Marne i nse we Fahl Cada Te fbi i User Manual 21 When we exit the Establishment Master the name of new establishment will already be in the list Exp Country Code Exp Country Mame sample Country Y Exp CA Code Exp C4 Department Name Exp Establishment Exp Establishment Name Code 2006 1 2861 eoPharm 5 A 2 7 Data Entry Screens There are three types of data entry screens available in NDS 2 7 1 Single Record Entry Screen In a Single Record Entry Screen the user is allowed to make only one entry at a time Such screens are used for master maintenance programs in NDS The snapshot shown below is an example of a window allowing single record entry Figure 12 Single entry screen Establishment Type Code Establishment Type Name ANLUFACTURER p Comments Allowed To Keep Stocks es xl 2 7 2 Multiple Record Entry Screen In this type of screen the user is allowed to make multiple entries and save them in a single save operation Such screens are used for master maintenance programs in NDS User Manual 22 The snapshot shown below is an example of a window allowing multiple record e
34. columns Figure 173 Assigning viewing rights VIEW INSERT UPDATE DELETE gt v EMM Disposal x EMM Domestic Purchases Sales x EMM Domestic Purchases sales Discrepancy x EMM Domestic Purchases Sales Missing Entries EMM Domestic Trade x EMM Import Export Report x EMM Manufactured x EMM Seizures x EMM Stock movement x EMM Stock Ledger x Ty 1 dy 1 TT T ay FILI x Establishment Stock Movements Ty 1j Uy 4 T d ay ay LI Ty Ty dy Ty ay d ay d ay gd PEEL x Attachments a xu Grant All puta Revoke All After that press the Save button and close the form press the Close button The Role is created Now you can assign it to users so that they will have proper access rights User Manual 158 8 1 2 How to define a user To open a new user account define a new user use the Add user button in the left pane of User Role Management screen The User Maintenance screen will open Figure 174 User Maintenance screen ENTE Maintenance STAS Uzbekistan Ministry of Health Russian Reset Password In the Header section you are to indicate the User ID login and his her Name After that you may indicate the following information in the General Details tab Field Value Country Country the User resides in or represents CA Code Competent Authority of the Country of the User The Language in which
35. cud ev eut mat uud ds oae eui dol daa aemu Epi su ctum reU DUE dud 90 4 3 EDnaGorsemells uo ee od laud eiie Eu Redux dta aw ei S Qu cid ow dini On veins au a via Eo du eaa Euu dut aod aE 91 4 4 Additional information on import export transaction e eeeeeee ee eeeeee eene 93 A M IMPOM EXDOM RE DOMS cce t 94 4 5 T poU EX DOM REDON ie asaeetna coo notanda pe decdusa es us ex delun coast e eod tes ine recie E uS Co dai iai dd 94 4 5 2 Import tepoll usi a cesi Mau ier ee eee De Dcos t usce vE Stout ee sees eee 95 45 3 Endorsement Repon TImpoLts su ideo tees oe M ie a eat eR ED CL ee LE eA A EDEE 95 4 54 Certificates RENON uctor ean e reed ing uo siesta iUd d oufwlet eaa ieu dutwsdeboe veut funde ai Redi dae 96 4 5 Do EXPO REDON sso e EU La poen Eoo aac c pet dieutu sc unpaid A see Gati caduti deiecta Dade ute 96 4 5 5 Endorsement REDON EXDOFIS i06 e oublier eir ae Ecc iot etes dio tbe rto do cM es 97 AGS AB EXPO in 97 CHAPTER S B2 99 5 1 How to create a License Request lees a enne nnne a nhan nnn nnn nnns 99 5 T Deining substances to De licensed uuum teius emer A cepa iuo 1 pda dexae a O 100 User Manual x DO CTUING a ype Oh LICENS Cie EET 101 5 1 3 Linking substances to correspondent types of activity 0 0 0 eee cceeceeeeeeeeeeeaseeeeceaaaeeeessaaaeeeesseaaeneeeseaaes 101 5 1 4 Altaching clearance information aos eoo eid ae
36. data is done in the accompanied Excel File Example for Pivot Table NDS xls It contains a Sheet named Pivot Table that has a very simple yet nice two dimensional presentation The table you see here is a cross tabular presentation of the imports and exports of our local country as per trading country It shows all the trading partners countries of our local country on the left in rows and the Transaction Type in columns our column has two different values total imports and exports The Approved Quantities are chosen as the data to show for any Row Trading Country and Column Transaction Type IMP EXP User Manual 29 Figure 22 Example of Pivot Table in Excel File Example for Pivot Table NDS xls Ed Microsoft Excel Example for Pivot Table NDS xls File Edit View Insert Format Tools Data RoboPDF Window Help Da E amp l t sBBASl oO c 69 Snagit Window E C1 st A a a LZ SubstiPrep A vj s Sum of Approved Quantity W tensecon Tye o u 329g ww x 5i MD 4 Trading Country EXP O WP Grand Total BEN AL orn 41160 41160 B ANDORRA 1385 1385 7 ANGOLA 4 4 B AUSTRIA 2 100 102 9 BELGIUM 553 2607794 2608347 10 BURKINA FASO 3460 3460 11 CENTRAL AFRICAN REPUBLIC 180 180 12 CHAD 165 165 13 coMoROS 60 60 14 conco 963 963 15 COTE D IVOIRE 3573 3573 1B FINLAND 1 1 17 FRANCE 50 50 18 FRENCH POLYNESIA 6051 1844 7895 GABON 163
37. displayed when the right mouse button is clicked J Note When adding new records make sure the screen you are working with is set to Add mode Add mode switches on automatically upon you make one of the above mentioned actions The mode status is shown in the lower right corner of the screen If the screen is not in the Add mode you will be just editing the existing data which may spoil the contained information and cause undesirable changes in final reporting 2 8 2 Deleting An Existing Record As with adding to delete an existing record you may choose several ways e Click on the Delete toolbar button EE e OrPress F3 e OrSelectthe Delete Current Record menu item from the System menu option e Or choose the Delete Current Record option from the menu displayed when the right mouse button is clicked While deleting existing records the user can also delete multiple records simultaneously 2 8 3 Modifying An Existing Record To modify an existing record the user must first query and retrieve the records to be modified After the required records are retrieved the user can make the desired modifications All the validations applicable in the Add mode are also applicable while making the modifications Note When modifying the data make sure you are in Edit mode po m User Manual 25 2 9 Queries Sometimes it is necessary to select some records which have common features For exa
38. filled either automatically or manually In the last case the numbering policies if any exist must be strictly observed As you can see in the picture above the only difference between the import authorization request and export authorization request is two fields encircled in which the reference number of import authorization or import certificate and its date of issuance are to be entered Other fields are filled in as it has been described in the mport Authorization Request section User Manual 90 Figure 101 Example of Export Authorization Request Request Date Valid From Valid To i gum 2006 16 IUN 2006 16 JUN 2007 l H K A3V3OB LK AZIZOV P nPEN 414 v MORPHINE HYDROCHLORIDE 3ML SMG ML v amp Substance Code Substance Name Preparation Type Piee Requested Qty EXHI 20 10 Boxes e i 310 Fitered forex Ss e dm pn Do not forget to save the request after entering necessary values 4 2 2 Export Authorization In order to authorize the export authorization request you should first select the necessary requests by means of Open Requests menu option or by querying as it has been described previously in the mport Authorization section The only values you have to enter are the date of approval ApprovalDate and the quantity approved for export Approved Qty Note Upon saving the system may automatically check for availability of license s necessary
39. in which the user has logged in Figure 5 Main menu and submenus Nain Menu Submenu i United Fations International Drug Control Prograr mme System Masters Import Export KETIL oti Psychotropifs Precursors Parameters INDSEZ Window Help IT zen or imr op ee e mo m a r mcg ee X x i riim omo imam imc jq e I License Request License Approval Open Requests Licence Suspension License Reactivation License Amendment Renew Expired Licenses License Reports User Manual 16 2 4 2 Accessing the Menu To access a menu item use either the mouse or the keyboard Following are the standards adopted for navigation 2 4 2 1 Using the Mouse Selection of a Main Menu Option To open the Main Menu option point the mouse pointer to any of the menu options on the menu bar and click the left mouse button Selection of a Submenu To select a sub menu item move the selection cursor down with the mouse until the sub menu item is highlighted and then click the left mouse button 2 4 2 2 Using the Keyboard Selection of a Main Menu Option Every menu item has one of its characters underlined If the item is one of the Main Menu Options then pressing the ALT Key and the underlined character in the menu option opens the relevant menu displaying sub menu items if any or directly invokes the relevant screen Selection of a Submenu Once a Main Menu option is listed the user can either enter the underlined characte
40. new record will be created In order not to confuse it with the old one the system marks it as a copy Figure 77 Result of copying Establishment details L NDS United Nations Office on Drugs and Crime Establishment Master SBER H System Masters Import Export Licenses EMM Narcotics Psychotropics Precursors Parameters Window Help Lalka PJZ Y V H E x E RO Country Code Country Name Street Name City Establishment Code Establishment Name State Zip Code PEANP 587 sits ee Establishment Type Code Establishment Type Name Country Name phar ar IQ Coode g J A EAN Code InActive HQ Name f ommunication Details Comments S NI in DD te Language Fenn tne e Establishment Name Sort Description Street Name KA lowe ees Comments Code ENG JJ ota une ota Ges record using stablisment MPEANP 584 AUTOMATE Now you can make necessary alterations and save the record as a new establishment 3 6 3 How to indicate the sites and headquarters NDS 6 0 gives an opportunity to trace the trade in narcotic drugs and other controlled substances by networks of Establishments i e by headquarters and their subordinate sites You can indicate whether the Establishment is a site or headquarter in the Site Management section of the Establishment Master Figure 78 Site Management Section Country Code Country Name Street Name City es Establishment Code Establishment Name Sta Zip Code PEAN
41. of INCB Forms can be printed in multiple languages While the system is available from UNODC web site in English French Spanish and Russian it has been designed to allow individual countries adapt it to their own languages The main goal of this manual is to give the user an idea what NDS is and how it can make the control of narcotic drugs psychotropic substances and precursors as well as related reporting easier and more efficient Chapter 1 System logic and basic principles When starting using NDS a user should clearly realize the following e NDS is an instrument of control and reporting developed in full accordance with international conventions on control of narcotics psychotropic substances and precursors e The control is carried out on two levels national and international Special modules of NDS correspond to each level There are also a number of master forms used for organizing data in a more convenient and effective manner The co relation of all system elements is shown at the end of this Chapter 1 1 Transactions on international level On the international level the data on transactions with controlled substances are processed in the Export Import module of NDS To understand the implications of working with this module the user should remember the scheme of licit trade in narcotic drugs psychotropic substances and precursors Figure 1 Licit trade of controlled substances Step Importing country Exporting country
42. of seized substances that were destroyed during the year in question Gross weight should be indicated Quantity of seized substances that were released for licit use during the year in ose orai question Unlike all other quantities in this tab in this field you should indicate the pure Quantity taken over by Quantity taken for special stocks or special purposes during the year in question Government according to government decision Gross weight should be indicated Quantities of seized controlled substances in relation to which no government decision Quantity not disposed of pending a decision has been issued as of December 31 of the year in question Gross weight should be a JMMieated 0 05 4 LLL UOM Unit of measurement in which the substance is being reported Comments Any relevant comments remarks concerning the seizure 6 2 Psychotropics 6 2 1 Quarterly report Psychotropic Form A P According to the 1971 Convention the member states are required to prepare statistical data on trade in psychotropic substances on a quarterly basis and furnish it to INCB within one month after the end of the quarter to which the statistical data re
43. preceding the year to which the estimates relate As you are well aware the paper based Form B consists of 5 parts Part I Background information and statement of the method Part Il Annual estimates of requirements of narcotic drugs Part Ill Annual estimates of the manufacture of synthetic drugs Part IV Annual estimates of opium production Part V Annual estimates of the cultivation of the opium poppy for purposes other than opium production Figure 131 Form B Annual Estimates Country Code Country Name zB Uzbekistan ESSE f 23 IA Medical Practitioners Drug Estimates Synthetic Estimates Opium Estimates Other Estimates Supplements 1 No Of Doctors 2 No Of Dentists 3 No Of ets 4 No Of Pharmacies 5 No Of Hospitals 6 No Of Beds 7 Methods of Determininc All these parts have found their proper reflection in electronic Form B in NDS Following are the respective tabs Part Header and Medical Practitioners tab Part Il Drug Estimates tab Part III Synthetic Estimates tab Part IV Opium Estimates tab Part V Other Estimates tab User Manual 114 A country may also revise the requirement in narcotic drugs so that the quantities will be increased or decreased In this case the country should indicate such changes as supplement to Form B and furnish to INCB in the shortest possible notice The Form B may be started as follows Narcotics gt Form B
44. quantity of substance was imported Code of the Country to which this quantity of substance was exported ee In the Licit Purposes Section lower Purposes Approx Required Qty Approximate requirements in Substance for certain purpose The licit purposes the substance has been imported exported for Chapter 7 Establishment Management Module The Establishment Management Module EMM as its name indicates is intended for entering editing and otherwise managing the data on the transactions carried out by establishments In general the EMM is responsible for management of data on the domestic transactions with controlled substances inside a country The EMM consists of four data entry forms and several report screens which are used for managing data in four spheres e Stocks of controlled substances e Manufacture of controlled substances e Domestic trade in controlled substances e Seizures of controlled substances 7 1 Stock data management The EMM Stock Management Form opens as follows EMM gt EMM Stock Movement The EMM Stock Movement form contains four tabs e Opening Stocks e Inventory Adjustments e Stock Ledger e Inspection Results e Closing Stocks Figure 153 EMM Stock Management form Opening Stocks tab Country Code Country Name Year Estab Code Establishment Name 2003 0009 Dori Darmon shareholding company Opening Stocks BOTTTT TTA RI
45. row forms you may want to sort the data by some field in ascending or descending order For this purpose the quick sorting functionality is envisaged in NDS 6 0 By default the records in multiple row forms are sorted by their Codes in our example below the substances are sorted by the SubstanceCode Figure 16 Data sorted by SubstanceCode Substance Code Substance Pace Preparation Type Requested Oty i Sor P1018 we METHAMPHETAMENE D5 1060 rs ML 1 ML sa AMPCULE S i v 4 00 M amp LILITERS r3 2003 9 1130 METHAQUALONE 1 MGIML 1 ML vw AMPCURLE S 5 00 PELILITERS fa PREDAT v NOMA 1 MGIHL 1 M sE AMPOULES i 101 00 MOLILITERS ia 2003 9 1314 v HORMEPERIDIME 100 pJML 1 ML vw AMPCLRE S 6 00 MEL ILITERS r1 20 1476 v FOREHINE IHEETA D GLUCURONIDE D3 100 pral 1 ML s AMPOLLELS i T 20 00 P ILITERS r User Manual 26 To sort the data by any field just make a single mouse click on this field s header The red arrow will appear showing that now this very field sorts the data Figure 17 Data sorted by SubstanceName in ascending order TM m f ode Subskance Mame Preparation TS Requested Qty Mo of ma patos F113 qw POMA D MAL 1 NL vw AMPOLLELS i QU 00 MELILITERS fa IHDOS3 P 10L8 ng METHAMPHETAMINE DS LOO xL LRL x AMPOULES i ag 4 00 MOLILITERS O 2003 P 1130 w METHACLALONE MG ML NL vw AMPOLLEIS L 4 00 MOLILITERS r1 2000 P 1476 wt MORPHINE 3 BETA D SLUCURONIDE D3 100 pai 1 HL vw AMPOLLEGS
46. substances using the special drop down box by either selecting from the list or entering the assigned substance code When entering the quantity of the substance to be imported you may use the Info button Lu Figure 92 Substance preparation information pop up e Export Authorization Request Substance Name Mo Of Units Quantity MORPHINE HYDROCHLORIDE 3ML 5Mi ML a j 1000 0 B Box Substance Code Substance Name Base Quantity N M Da MORPHINE Pending Estimate Quantity Balance Estimate Endorsements Endorsed Quantity 000 00 6 540 01 0 00 0 00 Export Limit M009 EXPORT AFG 2006 Approved Quantity Balance Approved 0 00 0 00 0 00 0 00 License Establishment License Status Balac i AWKEHT rap TAO opa AaproH Not Licensed Trading Country Estimate Quantity Import Limit AFGHANISTAN 4 000 00 4000 00 When the data on the controlled substance are entered you should save the prepared request Once you have entered all the necessary details save the request After saving it will be recognized by the system as open until you have created an import authorization on its basis 4 1 2 Import Authorization Import authorizations are issued on the basis of entered requests There are two ways of opening the previously entered request 1 Find it with a query in ImportExport Document form 2 Open it with OpenRequest menu item Import Export gt Open Requests P o0 that the di
47. the Login screen the UserName and respective Password should be entered The password appears as asterisks The password is validated and further access to the application is provided only to valid users of the system Mu Note Be aware that you will be given the access rights that are pre defined and granted according to your ID password combination Password is not case sensitive When the password is entered you will have an opportunity to change your password Just click the Change Password button that will flash active Gee Change Password In the password changing section that will open below the Change Password button in the login screen you will need to enter your new password into EnterNewPassword field and then confirm it by entering the same combination into the ConfirmPassword field After that click the Save Password button to save the changes or Cancel button to return to previous password The User should enter the name of his her NDS account ID not his her real name of course User Manual 14 Figure 2 Password changing window 3 E h nonas k j 1 ES United Mations International Drug Control Programme United Nations Office on Drugs and Crime National Drug Control System NDS Release 6 0 107 iG 2006 UNODC Last Update Monday 10 07 2006 16 28 08 User name Hom d utilisateur s admin Hombre de usuario Password Mot de passe Clave de Acceso Enter Hew Password
48. the quantities used for manufacturing of above mentioned M Substances and Preparations You are not obliged to indicate the obtained quantities However If the indication of obtained substances seems expedient you may indicate such quantities in the Hemarks tab of respective Report form EMM provides three more tabs for recording of the data listed at the paragraph above e Used for Schedule III e Exempted Preparations Mfg e MFG Non Psychotropic The images of these tabs are given below User Manual 149 Figure 162 Used for Schedule III tab Used for Schedule III XEMEN zi hues ticle Ge geen ERA ES Z8 rn Transaction Date Subst Prep Code Subst Prep Name No Of Units Quantity Comments Substance Name Cannabis CANNABISNEITHER ACID NOR BASE Clonitazene CLONITAZEMEHYDROCHLORIDE Qi F3 n Alkaloid Code Alkaloid Name Quantity Comments Figure 163 Exempted Preparation MFG tab Losses Used for Schedule III Manufactured Exempted Preparation MFG LL 275 51 7324110 1s Transaction Date Subst Prep Code Subst Prep Name No Of Units Quantity a EE pe 12 07 2006 0 00 Substance Name Lysergide LSD LYSERGIDE LSD TARTRATE LYSERGIDE LSD TARTRATE 2 MOL OF DRUG 2 Ct LYSERGIDE LSD TARTRATE 2 MOL OF DRUG 2 Hz DD a a m1 User Manual 150 Figure 164 MFG Non Psychotropic tab B Transaction Date Subst Prep Code Subst Prep Name No Of Units Quan
49. to is the transportation related fields Itinerary Here you should indicate the full path of transportation of the substances to be imported Country of origin country of destination and all transit countries should be listed For example if the substances are to be imported to Russian Federation from Germany by railroad then the Itinerary field should look as follows From Munich Germany to St Petersburg Russia by railroad via Poland Point of Entry Here it should be stated the code of customs point where the controlled substances are supposed to cross the border of an importing transit country upon entering The value is selected from the drop down box see also Customs Point Master Point of Exit The exit customs point where the controlled substances are supposed to exit the country The value is selected from the drop down box see also Customs Point Master Mode of Transport The means of transportation used for physical transfer of controlled substances User Manual 85 Note You must indicate the customs points not the actual points of border crossing A vivid Q example of such necessity is transportation by air In this case it is nearly impossible to indicate the actual point of border crossing while the last customs point will be that located at the airport of departure The last step in creating an import authorization request and the most important one is entering the substances to be imported You can choose the
50. two main concepts you should understand before you start working with Security module User virtual person identified by means of login and password and having certain rights to work with certain modules screens records of NDS Role set of rights to work view add modify delete with certain modules screens records of NDS The Users Roles Management form is opened as follows Security Management gt Users Role Management Figure 170 Users Roles Management Form ea User Role Maintenance Use drag and drop to grant revoke users to from a role Users Roles All Users aad All Roles 89 ALL ROLE E STAS E TEST 49 GST NDS ADMIN ROLE 3 MD532 am NDS ADMIN Add User 8 1 1 How to define a role The right part of Users Roles Management form is dedicated to role management Here you can create a new role lt Add Role gt button change the attributes of already existing role lt Edit Role gt button gt and delete a role that is not necessary lt Delete Role gt button Let us review the role management on the following example we should create a role for a Guest i e the user who will be able to view all records but will not be able to add new records as well as change an delete the already existing ones User Manual 156 Press the lt Add Role gt button to create a new Role The Role Management dialog box will open Figure 171 Role Management screen Enter the Cod
51. will not describe this module in detail 1 6 NDS Manual text markup and notations In order to make the text of this manual more informative but at the same time more easily understandable the special markup is used to represent various elements of NDS Example Description SubstanceName field CSubaneeDetal i e dmpotgort Systemmodule 000 Save Password screen button or keyboard key P uid a Also the following notations are used to describe operations with menus Notation What to do MenuItem choose the menu item sss a aaa 0000000 cick with left mouse button BB double click with eft mouse button 0 SSS a single click with right mouse button Chapter 2 NDS Functionality 2 1 Starting NDS The system is started either from the Windows Start menu or by double clicking on the NDS icon which is placed by default on your Windows Desktop When the system is started you will be asked to log in 2 2 Logging into the System When the application is started the Login Screen is displayed to validate the user The Login screen is displayed as shown below Figure 1 NDS Login Screen United Nations International Drug Control Programme United Nations Office on Drugs and Crime National Drug Control System NDS Release 6 0 107 2006 UNODC Last Update Monday 10 07 2006 16 28 08 User name Hom d utilisateur Hombre de usuario Password Mot de passe Clave de Acceso In
52. 0 0 00 g CE001 0 00 g A Stock Ledger report query is intended for rapid viewing of the quantities of substances in stocks as well as the transactions with them The Stock Ledger screen consists of four logical parts e Criteria e Base Substances e Actual Trade Total e Actual Trade Detailed In the criteria section you may enter various criteria for querying the data Please note that Year field is mandatory In the Base Substance Section you may see the Opening Balance for particular Substance transactions affecting the stocks and Closing Balance of this Substance In the Actual Trade Total section you can see the information on substances and preparations containing the Base Substance indicated above in the Base Substance Section Actual Trade Detailed section hosts breakdown of transactions with the substances preparations containing the Base as well as data on other substances constituting traded substances preparations 3 Note Double click on every record on Stock Ledger opens respective record in EMM User Manual 146 7 1 6 How to view a Stock Ledger Actual Trade EMM gt Stock Ledger Report Actual Trade Figure 159 Stock Ledger report Actual Trade Year Wl Split on Establishment Actual Trade Total Substance Code Substance Name kino Transaction Type Quantity RSEN Prep Type PREP 1 BROMOCOD N 10 MG 30 Opening Balance 0 00 package s lozenges p Import 10 00 package s lozenges
53. 0 1630 20 GEORGIA 223 223 21 GERMANY 1290 64120 65410 22 GREECE 1 1 23 GUINEA 20 20 24 INDIA 25000 25000 If you see the sheet named Pivot Chart you can easily determine trends for imports and exports Figure 23 Example of Pivot Chart in Excel File Example for Pivot Table NDS xls F3 Microsoft Excel Example for Pivot Table NDS xls File Edit View Insert Format Tools Chart Window Help KO Cu Ba Bea is tes i SnagIt ES window ChatArea ha ee EE Sum of Approved Quantity 3000000 2500000 2000000 1500000 1000000 500000 Xx xzooOonuoomudnmuzrzsqsx iiuarax azzzatlmeuouurzxoztzxac lrz Qoan gt 8 x ct2p5ogqgogr2on szougou o rzsoLogoz2o95uzz2 285u0u59202 i t Foetetiezog tur Su 220fF ZuUH7FE0R9S204Z7RR8B Fae 2590 FR 08 eoo8nSGrtaocaoss X oZ X o Zu 5 F 52424 m a c om nos5utunos FSf amp ous 3023 4 2 ozczmx ogtturtszogo Cl X d 2 cur u o Z amp cz Eo ZZ X 4g zu Oo Quu o uo Ow w O g Hj G W g ui FEZ T Ye O Lu o o 2024 a SNuxzReQn oa N PEU rz E z D o x SEDO ooz gt g o I ro D zu so W p2 mo o oO en E uu t a Z o H zB e e F 2 o LLI p ul D q LE o a E o TE 3 ro ns x e O Lu O x t D a Ww co LT zZ e e J s i uz F Es T 5 O w o C I4 4 MN Pivot Table Pivot Chart Data e Move selected objects NUMI You need considerable effort to present data in the form you see in Excel Fil
54. 00 0000 00 00 00 O0 00 0000 00 00 00 00 00 0000 00 00 00 O0 00 0000 00 00 00 00 00 0000 00 00 00 oo 00 0000 00 00 00 oo 00 0000 00 00 00 oo 00 0000 00 00 00 o0 00 0000 00 00 00 00 00 0000 00 00 00 a ap 1 Jl es Delete All AINHH4 sanHcH HE MOET OPEBRIWATE 3 cHHEOHOBE 3ancbe Ha aHrnHhckom aenaerca ObASaTENbHOH 3ari ce Ha aHrnHHckom ABNAETCA ObASaTeNbHOH L1 MSMEGHEHMA HE coxpaHeHeil O l sMeHeHHe HeEnsHox Ho L1 l 3HeHeHHR HE coxpaHeHell O L1 MISMEHEHHA HE caxpaHeHei O 3anHcb Ha aHrnHHcKDoh ABNAeTCA o6 asaTenbHOH L1 MISMEHEHHA HE coxpaHeHell O 3ari ce Ha aHrnHHckom aenaerca ObASaTeNbHOH MSMEHEHHE HEBOSMOHO L1 MISMEHEHMA HE coxpaHeHeil O HenpagHnbEHbiH Kog Hsblka HenpagHnbEHbiH Kog Hsblka L1 MSMEHEHHA HE caxpaHneHelil O lloegropeHHe Koga H3bika lloegropenHe Koga H3bika LS close None MOKET BMECTHTb TONbKO 3 CHHBONA BBE ATE sanHcb ANA aHrnHHickora ASbIEA BBE ATE sanHcb ANA aurnarickora ASbIKA anTiBeibepHTe L Aa 4TOBbI caxpaHrk y AANHTe 3TY sanHcb H cosA4aHTe HOBEYHI amp oTiBeibepHTe L Aa 4TOObI caxpaHk MOTIBbIDEpHTe O Aa 4TOObI CaxpaHk BBEAHTE 3anHcb ANA aHrnHHickora qsblka amp nTiBeibepHTe L aa 4TOBbI caxpaHrk BEeAHTe sanHcb ANA aurnaHickora ASbIKA y AANHTE 3TY sanHcb H cosA4aHTe HOY HO anTiBeibepHTe Ll Aa 4TOObI caxpaHrk BEeaHTe npaeHnbHbIH Kog Asbika BEeaHTe npaeHnbHblH Kog HsblKa amp oTiBBibepHTe L Aa uTObI caxpaHk BEeAHTe Apyran kon HsbiKa BEeaHTe apyro Koa Aspire You
55. 00 4 G psoi vjpabtl vj 44 500 000 4 G PB003 ww Bromazepam e 1 700 000 4 G PB005 puobabta v 7 650 000 4 G PB006 v Burenrphne S 400 000 3 G Pcon ww lCyclobarbital vj 36 050 000 3 G coo ww lChlordiazepoxide S 25 350 000 4 G Pco05 lonan vj 12 200 000 4 G Pcon vJrdeamepte S e 11 625 000 4 G ppon basepem ve 44 770 000 4 G pro flunitrazepam e 1 500 000 3 G puo ww ilorazepam e 955 000 4 G pwo3 ww Meprobamate ss 12 000 000 4 G pwolo v Medazpam e 45 100 000 4 G pMwo16 Midazolam gf 7 300 000 4 G Pmo18 v Mesecab S e 57 500 000 4 z pwo02 Nitrazepam e 151 470 000 4 G pmonz Pewobbtl e 1 700 000 3 G ppona Phenobarbital ss 838 700 000 4 G proo v emaepam e 12 080 000 4 G PX0017 voxepam v 57 750 000 3 G qwe vm gt oI User Manual 128 After filling in the Header section fields go to Assessments tab Field Value Code of reported psychotropic substance The field is a drop down box containing the codes and names of psychotropic substances only Substance Code Substance Name Name tag for the SubstanceCode Quantity Entered Quanftyeneredmamlly 000000 Schedule NumberofSchedule I lori the substance is included into 0 UOM Unitofmeasuementhesubstaneisbemgrepoed Comments 00 M
56. 000 00 g AFGHANISTAN Dextropropoxyphene 500 00 g AFGHANISTAN Diphenoxylate 10 00g AFGHANISTAN Morphine 3 980 00 g Pethidine 80 440 00 g Pholcodine 100 00 g Codeine 57 928 00 g Fentanyl 30 00 g Methadone 3 200 00 g Morphine 2 658 00 g Missing in Details Pethidine 3 000 00 g Pholcodine 300 00 g Alfentanil 362 00 g Codeine 1 399 946 00 g Dextropropoxyphene 1 197 000 00 g Etorphine 1 00g Fentanyl 211 00 g Morphine 5 481 00 g Pethidine 8 007 00 g Pholcodine 1 358 000 00 g Save Cancel Now if you want to save the new values in the Permitted Restricted Substance Master just press the Save button Row 1 2500 User Manual 64 3 5 Groups Sometimes especially for licensing purposes it is necessary and expedient to work with groups of Substances united by some characteristics rather than with individual Substances For example in many cases the Competent Authorities can issue licenses for trading in narcotic drugs not indicating all narcotic drugs one by one in the License itself So for NDS to properly recognize such License it will be necessary to unite all narcotic drugs into some Group so that NDS will treat any of the drugs in this group in the same manner 3 5 1 How to create a Group of Substances NDS provides an opportunity to create and manage substance groups with special Group Master Masters gt Substances gt Group Master 5 Figure 68 Group Master SEE NDS United Nations Office on Dr ug
57. 1 4 Event Log Unlike the Error Log the Event Log functionality allows the user to record all actions of all users throughout NDS The Event Log may be invoked as follows Security Management gt Event Log Event Date Event Date from 01 07 2006 Event Date to 31 07 2006 Event Type Event Subtype Object Name Report Event m x Event Id Report Name Report Parameters Report Options Event User 4197 OTMET NO CEPTHOMKATAM From country UZB 01 01 1960 31 12 2016 Jata Bbigaun 0 STAS 4270 OTHETbI NO BBOS BbIBOSY From country UZB ara 3anpoca 01 01 1960 31 12 2016 TBe STAS 4271 OTHET NO CEPTHOMKATAM From country UZB 01 01 1960 31 12 2016 Aata Bbigayn 0 STAS 4753 DOMESTIC PURCHASES v5 DOMESTIC SALES DISCRFrom country UZB Substance Type Sched Ind STAS 4754 DOMESTIC PURCHASES V5 DOMESTIC SALES DISCRFrom country UZB Substance Type Sched Ind STAS 4755 DOMESTIC PURCHASES v5 DOMESTIC SALES DISCRFrom country UZB Substance Type Sched Ind STAS 4756 DOMESTIC PURCHASES v5 DOMESTIC SALES DISCRFrom country UZB Substance Type Sched Ind STAS 4757 DOMESTIC PURCHASES V5 DOMESTIC SALES DISCRFrom country UZB Substance Type Sched Ind STAS 4758 DOMESTIC PURCHASES V5 DOMESTIC SALES DISCRFrom country UZB Substance Type Sched Ind STAS DSrance De ned ndz H 2 2 2 0 0 0 o 0 0 I 1 Enter the start and end dat
58. 1 January and 31 December of the year to which the statistical data relate The quantities of psychotropic substances used Quantity Manufactured for the preparation of pharmaceutical dosage forms should not be indicated as Quantity man ufactured PENNE Quantity Used for Quantity y used for the manufacture of non psychotropic substances or products Manufacture of non permitted under article 4 paragraph b of the 1971 Convention That quantity should Psychotropic include the total amount placed in the manufacturing process during the year to which Substances or the statistical data relate even if the manufacturing process was not completed by the Products end of that year Total quantity used for manufacture of preparations exempted from certain measures of control permitted under article 3 paragraphs 2 and 3 of the 1971 Convention That preparations exempted quantity should include the total amount placed in the manufacturing process during the year to which the statistical data relate even if the manufacturing process was not under art 3 paras 2 amp 3 Epp CE MM MEUM completed by the end of that year The quantity held in stock by the Manufacturers at the end of the year in question The Manufacturers Stocks quantities of substances included into Schedules and Il should be indicated on a as at 31 December compulsory basis and the quantities of substances included into Schedules III and IV PERI on a voluntary basis NENN
59. 120006 COMPRIM Select Options For Pivot Table AV DISPOSITIF PR Trn Type 092004 ACTIQ 800uG COMPRIM Av Reference Number DISPOSITIF PR APPLICATION Authorization No 09 2004 ACTIQ BOOUG COMPRIM Av sis T DISPOSITIF PR APPLICATION rabo daa dn Establishment 09 2004 ACTIQ 400uG COMPRIM AV Ctry Code DISPOSITIF PR APPLICATION Country 09 2004 ACTIQ 200G COMPRIM AV Request Date DISPOSITIF PR APPLICATION Approval Date 09 2004 NPU O4mM4mMS DUROGESIC 2 Valid From LIGIHEURE Valid To Endorsement Date 09 2004 BRE DUROGESIC 5C Nds Trn Icimpexprefdocum Trading Country 09 2004 NPU 04 04 05 DUROGESIC UDF Selection Title Choose Saved Selection 100 HG HEURE Subst Prep E dorsed per Trading Country Endorsed per Trading Country 09 2004 NPUT2 04 FENTANYL No of Units Delete Selection JANSSEN 0 1MG 2ML INJ EN P noct Cirantify REIP b 09 2004 NPUT2 4 FENTAN L JANSSEN 0 5 MG 10 ML 596 09 2004 NPUT2 4 FENTAN L 30 00MILILITERS 10 24 09 2004 JANSSEN 0 5 MGAO ML 596 09 2004 NPU 04 04 05 DUROGESIC 8 000 00 NOT 5 24 09 2004 9 000 00 24 09 2004 31 12 2004 22 12 200 4 911 00 100 u G HEURE SPECIFIED 09 2004 NPU 04 04 05 DUROGESIC 75 9 000 00 NOT 5 24 09 2004 9 000 00 24 09 2004 31 12 2004 17 12 2004 9 000 00 p G HEURE SPECIFIEZ Mu J Note Excel pivots are only available for Reports User Manual 33 2 12 Grid view Data Grid is a new feature of NDS 6 0 It allows the user to view
60. 525 AES 9 2004 40E FRANCE JANSSEN CILAG SA NEW CALEDONIA GP N C 01 08 2004 NPU 04 04 05 DLIROGESIC 25 40 00 NOT UGAHEURE SPECIFIED EXP 4499524 AES 9 2004 40E FRANCE JANSSEN CILAG SA NEW CALEDONIA GP N C 01 09 2004 NPU 04 04 05 DUROGESIC 50 40 00 NOT UGAHEURE SPECIFIED EXP 4499522 AES 9 2004 40 FRANCE JANSSEN CILAG SA NEW CALEDONIA GP N C 01 08 2004 NPU 04 04 05 DLIROGESIC 30 00 NOT 100 pGAHEURE SPECIFIED EXP 44910564 AES 9 2004 40E FRANCE JANSSEN CILAG SA SENEGAL PHARMACIE NATIONALE 22 09 2004 NPU12 04 FENTANYL 400 00 MILILITERS JANSSEN 0 1MG 2ML INJ EN EXP 44910564 AES 9 2004 40E FRANCE JANSSEN CILAG SA SENEGAL PHARMACIE NATIONALE 22 09 2004 NPU12 4 FENTANYL 250 00 MILILITERS JANSSEN 0 5 MGAO ML 5 EXP 44910476 AES 9 2004 40E FRANCE JANSSEN CILAG SA CONGO CLINIQUE GUENIN 10 09 2004 NPL12 4 FENTANYL 30 00 MILILITERS JANSSEN 0 5 MGAO ML 596 IMP 44910451 AlS 9 2004 403 FRANCE JANSSEN CILAG C O BELGIUM JANSSEN 21 09 2004 NPU 04 04 05 DUROGESIC 9 000 00 NOT DEPOLABO PHARMACEUTICA 100 pGAHEURE SPECIFIED IMP 44910450 AlS 9 2004 403 FRANCE JANSSEN CILAG Cio BELGIUM JANSSEN 21 08 2004 NPU 04 04 05 DUROGESIC 75 9 000 00 NOT DEPOLABO PHARMACEUTICA HGHEURE SPECIFIED 4 b Let us say we want to establish a trend analysis about the total imports and exports to and from our local country to another trading countries for Fentanyl so that the final output clearly presents the data for quick and easy analysis Such an analysis on real
61. APR 2006 z M 0000 gt Valid From Valid To Signature L9 APR 2006 z L9 APR 2007 x MK A3M30B I K AZIZOV Substance Code Substance Name Preparation Type Bern Requested Qty Approved Qty UOM cwo02 METHYL ETHYL KETONE 0 E 5 ri D 2 14 a gt Fittered Notes Point of Entry Point of Exit Mode of Transport eg I 38 n sui gt As you can see there are two new fields in the Import Authorization tab In fact that is the only difference between the latter and the Import Authorization Request tab Thus all you are supposed to do to create an import authorization is to fill in those two fields ApprovalDate and ApprovedQty approved quantity Mu Note The inner logic of NDS does not allow the ApprovedQuantity to be greater than the RequestedQuantity When you fill them in the RequestNumber field will turn red Save the Import authorization When it is saved the import authorization request will be deleted from the list of open requests and any operations on it including deletion will be banned Now to make changes in the request you should delete the authorization When the authorization is being saved NDS may automatically compare the quantity with the one set for the importing country in Estimates Assessments approved by INCB If the requested substance is not listed in Estimates Assessments or its quantity exceeds the permitted quantity NDS will inform you about the v
62. CN BETMAQUADOME LIM y LES Io 4 DO MILILITERS 0 200 2 1018 vw HETHAMPHETAPINE D5 100 pail 1 ML x AMPOLECSI J 4 00 MILILITERS 0 UP EL EXE ve MOMA 1 MGIML 1 ML st AMPOLKLELS E ww TO DO MTLTLTTER S a 2 11 Excel Output The user can export data retrieved on any screen into Excel spreadsheets by clicking the lt Excel gt button 25 lt Excel gt button exports the data contained in the fields of a header of the current screen plus the fields of the current tab of the details section Clicking the button will open a dialog box where the user can select the desired fields for export User Manual 27 Figure 20 Excel Export options L Excel Export J l importeExport Documents Primary Data M Boris Selection Title Imp Country Cade Imp TA Code Imp Establishment Choose Tree Selection Exp Country Code Exp CA Code Exp Establishment Use original filter of selection Imp Exp Flag Detail Data Remarks Import Authorization save Selection Import Certificate Delete Selection Endorsements Import Certificate Request Additional Establishments select All Tree IT Reset Selection Tree CI iT E Eu Export to Excel un Close You may select the fields for export by putting a tick mark besides their names and unselect them in the same way Unselected fields are marked with a red x sign However in NDS 6 0 you are also provided with one very interesting feature selection management
63. Cert Request Number Request Date Valid From Valid To 548293NK30 14 Jun 2006 x n 10 BKNKHK 110 2006 L6 JUN 2006 l L6 JuN 2006 x L6 JUN 2007 Signature Itinerary M K A3V30B I K AZIZOV Substance Code Substance Name Preparation Type keca Requested Qty Ee 20 al nPEN 414 v MORPHINE HYDROCHLORIDE 3ML SMG ML v amp 10 Boxes e if 175 i Notes m v E z z v eg dmn Note Please pay attention to correct indication of the RequestNumber as this number will be later used for issuing of import authorization Depending upon settings in User Preferences this Mu field may be filled either automatically or manually the last case the numbering policies if any exist must be strictly observed Also the request number may be automatically set depending on the type of the requested substance s The last feature is also defined in User Preferences section Signature field Being a drop down box it allows the user to put signatures of designated persons on the import authorization that is being printed Using the Signature Master you may enter names and surnames of people having signing power as well as the image of their signatures in bmp format See also Signature Master This feature enables responsible persons to save time However because of particularities of document management in different countries the feature is optional Another group of fields we should pay a decent attention
64. E CEU acted Prev MODE ERES 60 3 4 1 How to indicate the Estimated Assessed quantities of Controlled Substances 61 3 4 2 How to import the Estimated Assessed quantities cccccccccseeeccecceeeeceecceeeeceeeceeueceesaaeeeessuaeeeeeesssaneeess 62 3 9 AR OUD eU C 64 3 5 1 How to create a Group of Substances rrene e e a e e e nnns sss snas nnn nnns nnn na 64 3 5 ESIaDIIShnmenls no aset eio aa en cae sae a Caco de muu Cae Dite asu Dro Eat Sue uc Sau Us 67 3 6 1 How to create an Establishimehl ii eot reo ioco do Pe ecd onsn ndo va proc iw desees portes cn s up ped ab ulus SUMI GE 67 3 6 2 How to copy the Establishment Details ccccccccccceccceceececeeeceeceeeceseeeececeeeeeeceuecesseeeessaceesesaeeessaeeeesaees 69 3 6 3 How to indicate the sites and headquarters cccccccccsseeeceeceeeeeeeceueeceecaaaueceeeaeaeceessuaeeeeseaaausesssaaeeeess 70 3 06 4 Estabpishimenb Type MIastel ii centers castos cu nuu eu ene Qi haeuta a teu xa ute eu t ena istas einai caer Anand tet uU LA 71 3 6 5 How to export data on establishments Establishment Export ccccceecccseeeeeeeeeceeeeceeeeseeeessaeeeseeeeeees 71 3 6 6 How to import data on establishments Establishment Import cccceccccseceeeeeeeceeeeceeeeeeeesseeeeseeeeeees 72 Sols DEMOA PNI S ose dE eive dL DE UIN C LE ID cs echt DIE 73 ITs GT S aua IASG vanr a a a a e a a E 73 Sua
65. EN Import Quantity Used for Manufacture of Quantities of substances which physically cross the border of the Country or Region during the year in question Export For Substances included in Schedules II III and IV User Manual 130 6 2 3 2 How to indicate information required in Part Il of Form P coutry breakdown of import and export The Part Il of Form P contains the countries related breakdown of the import and export of psychotropic substances To indicate such data you should use the Imports and Exports tabs of Form P Figure 146 Imports tab _ Diazepam 2 000 00 G 4 v Midazolam 3 000 00 G 4 v Ketamine 7 500 00 G 3 i Country Code Country Name Quantity Imported us T Russian Federation T 2 000 00 Qus v gt I The system automatically creates the Form P upon the first transaction with psychotropic substances for the respective year is entered in the Import Export module However you may also enter the necessary data manually In general if all import and export transactions are recorded properly in the system and respective endorsements exist the system displays all necessary data on Export and Import tabs Field Value Substance Details Section Substance Code Code of imported exported substance Substance Name Name tag for SubstanceCode Total Quantity Total quantity of the substance imported to exported from the country UOM Unit of measurement in which
66. F APARATI 3 2004 CTO zu CONPRIM AV Dea Pi APPLE Ted HIH AA Ree E Lune HIH AA LP E PAHELRE 5 XH BA ae 136 po HEURES Gs GEM MANAA TENTAN AANSSEN D rM HJE EH MPL Se Pesan ARREZEH DE oO PIAH oe ee AREESEMH 0E iH D iTi TIH NMPU Oc ED Rose Go 100 HELE CRS PEU E T5 pEUHEURE Request i Ir ferma Append Waid Yald To fndorsemend TCI kisay D TET Quantity Units Date Quantity From D Quantity Export a excel pivot E ad Select Opdions For Pivot Table m Ern Type a Feieren Mumi Colunn Hams Grientstion Postion Sub Totals __AggFenction deihorirailen Na I NNNM NN NU AN NNNM ni Minerare pars bo P y p Trading Establish iic Train sta J WF su Dim Code Papes Dale Apprawat Dake Walid Fe tae Valal To Enion caci Date Mata Tr lem ssnefibrc usns Tracing Cuenitry Unt Seher Prag Ha cf Ums E ee O cmd iu 31 122344 22 12 20004 451100 Siria 17422004 SR D User Manual 32 Figure 26 Screen dialog for Excel Pivot after selecting fields Establishment Establishment Trading Establish Zy DE Transaction amp Countries Transaction Type Country AR m zj Trading Country equest Subst Prep Request UOM No of Approval Approved alid alid To ndorsement Endorsed Itinerary Certificat zz Quantity Units Date Quantity From Date Quantity 9 2004 ACTIQ
67. Figure 14 Navigation bars Country Code Country Name Street Name Establishment Code Establishment Name State Zip Code mss Bap ahd Traders TT Establishment Type Code Establishment Type Name Country Name TRaDNG _wTRADING COMPANY z mmm EAN Code InActive a Communication Details Comments ESSET irm mI Language Keg s x ees Establishment Name Sort Description Street Name State lip Cod Country Name Comments ENG lHaji Ahmad Traders aji Ahmad Traders GNO EENEECD NN 2 7 4 Report screens These screens are provided in Import Export Licenses and EMM modules of NDS to facilitate the search of records against multiple criteria Let us consider the example of Import Export Report screen Figure 15 Import Export Report Transaction amp Countries r Establishment Transaction Type Trading Country Establishment E E NENNEN Trading Establish amma d Import authorization a Export Authorisation D EEA Endorsment amp Certificate Dates r Substance Name 00Preparation Name Endorsement Certificate Substance i EEXESEC ENEEXGC SS ENEEXE C oo pum Peete T OERS T W Narcotics C Precursors aay conations a aa AL C C Cm CIN or Certificate Conditions UAE 7C es Reference Authorization Country Establishment Trading Country Trading Establish Request Subst Prep Request Date Quantity ITem AO AHAMKOH Russian Federation Novosibhimfarm 1 6 02 2005 3434RUS o
68. Form A 6 1 1 1 Entering Imports and Exports data The Form A uses the data from Import Export module of NDS automatically calculating the quantities and capturing the countries the transactions were carried out with However you may as well enter the data on transactions manually please bear in mind that the system accepts only the data on base substances not on Q Note When entering data directly into Form A as well as to the other INCB reporting Forms Preparation or Groups If the data in the Form A are calculated by the system i e aggregated then the figures will appear in black Otherwise if the data are entered manually and do not correspond to the system calculations they will appear in red In the Figure below the data are entered manually the field press Tab key or click other field and the system will display the aggregated value Note If you want to know the results of system s calculations just delete the value and leave instead Figure 129 Form A Imports tab Remarks a Substance Code Substance Name Total Imports pe yFoo1 Fentanyl 6 4 G a M wwo0s Morphine 750 044 G PE PEUR ES Dos Federation 6 40 m 4 0 e 10 rl Both Imports and Exports tabs are subdivided into two logical parts e Substance Section upper e Country Breakdown Section lower User Manual 111 The following fields should be filled in both sect
69. Houveau Mot de Passe Hueva Clave de Acceso Confirm New Password Confirmer Mot de Passe Confirmar clave de acceso Upon login NDS screen will open appearance of the screen is given below Figure 3 NDS Screen Upon Opening k NDS United Nations Office on Drugs and Crime EX System Security Masters Import Export Licenses EMM Narcotics Precursors Parameters Window Help a User Manual 15 2 3 Setting Application Language NDS 6 0 allows a user to choose the language of the interface to make his work more convenient and effective System gt Set Application Language P5 Figure 4 Set Application Language screen I Set Application Language Language Code Language Name Just select the language you need and press the lt Ok gt button When you select a language all interface elements start being displayed in the newly chosen language If there is no data entered in the chosen language or some interface element is not available in that language they will be displayed in English 2 4 Menus and Toolbars The menu and the toolbar are two of the user friendly features of NDS application The main menu has a toolbar attached to it This toolbar consists of several tool buttons as shown below 2 4 1 Main Menu When the application is started after logging in successfully the Main Menu for the Application is displayed The Main Menu and the sheet tool bar displayed vary depending upon the module
70. I 08 06 2006 08 06 2006 08 06 2007 Active 3KCNEPTH3bI H CTaH nekap cpea MARCI11 01 01 2006 01 01 2006 01 06 2006 Ministry of Health SuperPharm MARCI11 01 01 2006 01 01 2006 01 06 2006 Expired This report query is used to briskly retrieve the data on the licenses issued in some country Double click on any of retrieved records in order to open the proper record in license module User Manual 108 5 9 Licence Type Master The License Type Master is used to indicate the types of license issued to establishment by competent authorities It may be invoked in two ways 1 from the main menu Masters gt Licenses gt License Type Master 2 by double clicking the LicenseTypeCode or LicenseTypeName drop downs in the LicenseRequest module Figure 127 License Type Master License Type Code Import Export Suffix SALES ENG v SALES LSALES LSALES RUS v TOPPOBNA TOPPOBNA wo if 172 b al 7 I Kl o O You will need to enter the following data Field LicenseTypeCode Description Unique code that will represent this type of licenses in the system This checkbox shows of the license of this type will be checked by the system when the establishment to which the license is issued to carries out an import transaction Se LicenseTypeName SortDescription This checkbox shows of the license of this type will be checked by the system when the establishment to which the license i
71. MINE Addmg New 1 0 04 6 pene ate T ae 24 2 0 2 Deleting An Existing FIeCOIG ioree onde cce pci eaa Do p ok sine deep saundedgenddnsn saci detwbcugdtuddanedetusatedekasenddenencedeandoas 24 2 8 3 Modifying An Existing Record esses eene nnne nnn enne nnne n nnne rennen nnns nnn nnns 24 DESNUDO sake 25 2 NOs Wate DOM UNG scutes seca pacientes an scan 25 FN Wes COU ON atone ceca ses ees cee rasta egw tes deme anid mest a cara en do sess a E avasestanieaant 26 2 11 1 Pivot Table Usage in NDS 28 ue He EEPO e Th 30 2 11 3 Exporting data using NDS Excel Pivot anoo rtt pra Ioan epos rR o vua hne oce aae rp aU eus ees ene s Eve Se Xp IK SOS edu UE 30 nb cuRur Sq 33 213 NE ee 35 LTA EMO LOO EE DE mm n 35 2 15 Substance Preparation Calculator ccc ccc LLL erre ecce eccL Le eee eene anna 37 2 10 MYND aes sca tess sede se ced pow ee M M 37 2 rM S ivo NOS D 37 GHAPTER 3 MASTER PO Q 39 3 1 OU SIS ot E ee ee ee eee 39 3 1 1 How to enter a new substance and define alter its attributes ec cccececseeeee
72. Manufacture tab of digital Form D a vl a a vl Figure 149 Illicit Manufacture tab iecaoi CA001 Acetic Acetic anhydride v ee lt j lt a gt gt gt 5 us _y RUSSIAN FEDERATION PDEU Transit CES an a Code Country Name Be Destination Country Code Country Name of Seizures Circumstances Place of Seizure a Pac Name Le Substance Intended a illicit Manufacture The tab consists of three logical sections e Substance details section upper e Breakdown by countries of origin middle e Information on transit countries and destination countries if different from reporting country Here you may need to enter the following data Field Value In the Substance details upper section Substance Code The code of a seized substance identified as having been used in illicit manufacture Substance Name Name tag for the SubstanceCode The quantity of the substance pure anhydrous content that was seized during the reporting year M M M M MM Number of Tab
73. N O a a a uta dou oC Rae ee ee 76 DOS GAN Ma SE EAR A E EE 77 3 7 4 Region Master and Region Country Relation Master cccccssccccecssseeceeeeeeeeeeeeseeeeeeeseeeeeeeesaaeeeeesseaeeeess 78 3 7 5 Indication of official signatories for the Country Signature Master ccccccseecceeeeeeeceeeeeeeeeeesseeeeesaees 80 3 7 6 Indication of Customs Points of the Country Customs Point Master ccccccsseeceeeeeeeeeeeeeeeeeeeeeaeaeees 81 CHAPTER 4 IMPORT AND EXPORT TRANSACTIONS eene nhanh uua aas RR IRR SNR IRR EIN R NR nnmnnn RR RR R RR R4 Dad arda 83 4 1 Import Transaction Documents isisi aaea nan eaaa nece cu aio co uoc eee a Poen eet osEe via 83 42 131 Import AUINOriZatlon REQUEST o a eite hot eee eked ete dle eee ee ed eee 83 4 1 2 Import AULDOFHZALIOF occi eeo oo Ea rari ue UOS p no qune dias quiq cav tU ceca deed mapa dM MD LI LACUS qM M MR DIE 85 41 3 Import Gerlificdte HeQUOSE sss ican so i Noa quio cad sch Siac alan hd oia taeeded Sa sace wlan td acawnntee ieee ieee Rass 87 41 4 Import GOING alo eios iUc ie uita t Sono dt cae Me hue Toda a seme U m INEDITO SN fm c DEtIcIN catceeenseresesceueeumenioteas 88 4 2 Export Transaction DOCUITIeTIIS ase eee eoo Eee uote a Peer eH eun cete ct cena dec roS AARAA 89 4 2 1 Export Authorization Request ee decies ea pose etcioa eoe de bx rcd vc su Conse Ero cin tua aspe or eigo keine 89 4 22 EDO rnr AUNOA UON a ies osea eod oe nuca nec Do feet kae qo bassa etuer
74. Now you may not only select the fields for export to Excel but also save the most frequently used selections for future use Just select the necessary fields type the selection name into the SelectionName field and press the lt SaveSelection gt button If you do not need any of previously saved selections just choose it in the Choose Tree Selection drop down and press the Delete Selection button Also you may select all fields at one time by pressing the Select All Tree gt button and unselect all fields at one time by pressing the Reset Selection Tree button After the necessary selection is made or chosen press the Export button to export the data to Excel There is another button also associated with Excel export lt ExcelRow gt 26 This button exports the unsorted data Another feature of Excel export is an opportunity to export data directly to Excel Pivot Table For this purpose a special Excel Pivot button is provided in some screens especially report query screens on NDS User Manual 2 11 1 Pivot Table Usage in NDS 28 Pivot Table is an MS Excel functionality to analyze data For understanding it can be thought of a Cross tabular data distribution presentation in an Excel Sheet Let us try to understand it through an example Figure 21 Example of Pivot Table usage in NDS from Import Export Report United Nations International Drug Control Programme IMEX Report HWA Syste
75. OOO S e Bo All Rea fede E him Roo el Detromoremde SC ede I 1029 e PI 4 m 30 User Manual 166 8 2 7 Backup Restore functionality As it follows from the name of this feature it allows administrators of NDS to backup the data on a regular basis and then restore them from the previously saved versions System gt Backup Recovery Just select the proper tab according to whether you want to make a backup copy Backup tab or restore data from backup file Restore tab Indicate the file name and press the lt OK gt button to complete the operation Figure 182 Backup Recovery Screen I Backup Restore Database Eee a
76. P 587 shuts Pe PP Establishment Type Code Establishment Type Name Country Name EAN Code InActive a Communication Details Comments Copied record using establisment NPEANP 584 User Manual 71 Note You may turn the site management section on or off in nds ini file Just check the parameter of SHOWSITES string in NDS section of nds ini file If SHOWSITES Y the site management section will be displayed if not concealed If the establishment is the headquarter for one or more other establishments just leave the HQCode and HQName blank If it is a site just indicate the code name of its headquarters and then save the record 3 6 4 Establishment Type Master In some cases when you cannot find the necessary Establishment Type you may define it by yourself e Double click on the EstablishmentTypeCode field The Establishment Type Master window will open e Enter the necessary Code and EstablishmentTypeName e Define if the establishment will be or will not be allowed to keep stocks AllowedToKeepStocks Save the record Figure 79 Establishment Type Master Establishment Type Code Establishment Type Name MANUFACTURER Comments Allowed To Keep Stocks es l According to the 1961 Convention the stock of manufacturing and wholesale trading companies must be reported as Stocks on FORM C however retailers stocks must be reported as Consumed on FORM C NDS is flexible in naming establishment t
77. Preparations Substances Quantity Qty in stocks i domestic medical and utilized for in Schedulelll not covered to be at 31 Dec of scientific purp manufacture of the by the added to year to of Other 1961 1961 special which the Drugs Convention Convention stocks estimates icone Cannabis ow 10 00 G INCOO4 Cocaine tsi 1 00 G INcOOS v codine v 700 00 G INFOO1 renan ow 120 00 G NHoD Heroin v 50 G INMOO2 sw Methadone sw 50 G INMOO9 w Morphine v 10 600 00 G oop opum 5 00 G INPO13 v Prtramde 694 00 G INROOS sw Remifertanl 50 00 G INSOO1 v sufenan 75 00 G INTOO2 sw Thebaine sw 54 00 G INTOO4 ww Trimeperidine 50 000 00 G DB e ars gt oF A Alkaloid Code Alkaloid Name Bib ie meses eir Not Covered Special Stocks Held in Stocks UOM and possible purposes of their utilization in case the respective substance in the upper part is a Q Note The lower part of this tab is dedicated to the indication of proposed quantities of alkaloids CPS 6 1 2 3 How to indicate the information on annual requirements of manufacture of synthetic drugs In order to indicate the requirements of manufacture of synthetic drugs go to Synthetic Estimates tab Here you may enter not only the quantities to be manufactured but also the establishments that plan to manufacture such synthetic drugs Note Only the countrie
78. Quarterly report Psychotropic Form A P cccccccssseececceeeececcceeeeececeeeseeeeeeeaeeeeessaaeeeesssaaeeeeesesaaeeeeesaaaass 124 o 2M OWEN mA CEPR TREE TU s xm 127 02 MU ici CHOIMODIC moll ute LECT 128 6 3 Form D Precursors Annual Statistics 1 eeeeeeeeeee LLL eeeeee ce lieee eene anna anna ananas 132 6 3 1 How to indicate seizures of quantities included in Tables or ll seeeeseeeeseeeesesse 132 6 3 2 How to indicate seizures of substances not included in tables or ll identified as having been used in illicit MAMU ACUTE ERR Oo S 134 6 3 3 How to indicate the information on methods of diversion and illicit manufacture 135 6 3 4 How to indicate data on stopped SNIPMENEHS ccceccccccsseeeeeeceeeeeeeeeeeeeceeeseeeseeesseaeeeeesuaceeeessaaeeeeessaeees 137 6 3 5 How to indicate the information on licit trade in and use of precursors cccseeceeeceeeeeeeeeeeeeeeeeeeseeeeeeaes 138 CHAPTER 7 ESTABLISHMENT MANAGEMENT MODULE ecce eeeee enne nenne nnn n nhan nean nhan nnn nn nnn 141 TAS Stock data management eiie aro os ae oc in oa E xp e Ee E ENSE EE Uses R VE cc ue ese ceca deu iE 141 7 T1 o60pernind9tocks and Stock AGJUSITI GRE ee oett a bo eut ea unco Eee aa rotos Eee otto EE uL oe pea EA Den 142 7 1 2 How to indicate the inspections and their results c cccecccccccsseececcceeeec
79. TE Ie Pasian cc ee urs n TR ER ET Eras 18 12 2003 12 2003 emus emus 77 e peus e fo 0 00 ase pea 80 000 00 1 0 2000 RRRS v B v 80 000 00 03 03 2003 RRRRRUS RRRRS f 0 00 11 09 2003 p 250 95 N o6502RUS w 5 250 95 N o6502RU5S wf 0 00 30 07 2003 w IB 250 95 N 078965WI 5 250 95 N078965W1 ww 0 00 28 04 2003 M 2 1 92 N o2895AUL w M 2 1 92 N o2895AUL 0 00 28 03 2003 M 8 242N001705WI r amp 242No01705W ww 0 00 02 09 2003 M 8 242 N 001725W1I v r amp 242N001722W eft 0 00 fsojo7jz003 M 8 242 N007515WI r amp 242N00731SW xipo 0 00 27 10 2003 nen 3 MPEN 11 yf 0 00 ccc CS E 0 00 fsojovjzo03 nen 4 ww IPET 14 ft 0 00 o10 2005 nenzs mensc E 0 00 puis ves wm zb z 0 00 sux enm enm x 9 3 0 00 qae cre gt ai 4 4 Afaa 4 4 4 40 4 4 4 4 ela ol ol ol 9 9 9 ol 9 9 4 4 User Manual 142 7 1 1 Opening Stocks and Stock Adjustment Opening stocks are the stocks of controlled substances kept by manufacturers or retail traders as at the 1 January of the reporting year If no data are available for the previous year and all transactions with controlled substances have been carried out during the year in question the system automatically sets the opening stocks of all reported substances to zero If some transactions have been ent
80. When you have saved the endorsement you are not able to change the EndorsementDate f you try to do it the following warning message will be shown National Database System Error Message Reason Action New endorsments date is not equal to old one Delete this record and create it again with a new date This feature prevents the occurrence of errors in the INCB reports related to change of endorsement dates However if you do need to change the date delete the endorsement record and create a new record with proper date When the respective authorization certificate is endorsed the substances indicated in it are considered exported or imported and respective changes are being made by the system in the following modules and reports depending upon whether the endorsed substance is a narcotic psychotropic or precursor Substance Updated modules Narcotic EMM Form A Form C Psychotropic EMM Form A P Form P a a Precursor EMM Form D User Manual 93 4 4 Additional information on import export transaction Unlike previous versions NDS 6 0 provides an opportunity to record more information about particular import export transaction Thus import export module contains two more tabs called Remarks and Additional Establishments In the Remarks tab there can be indicated the proposed date of export remarks on the transaction conditions of transaction as well as several comments by the customs Thes
81. ZB 7676757LAT UZB 8888ROK UZB_89898ROK UZB_ARG_C1ARG UZB ARG C2ARG User Manual 54 3 3 Competent Authorities 3 3 1 Competent Authority Master The Competent Authorities are special bodies authorized by governments of member states to implement certain functions in relation to controlled substances Competent Authority Master helps to enter store and otherwise manage the data on various competent authorities pertaining to different member states Competent Authority Master is invoked as follows Masters gt Competent Authority gt Competent Authority Master Figure 55 Competent Authority Master CA Code EAN Code Department Code Department Name SE ee SS ev SYSTEM Communication Address List Of Forms to be Mailed Country Code Country Name Phone Area Cd omm Address fi fnkNown S Contact Person Designation Communication EN Administrative Signatory Communication Code Communication Name SYSTEM GENERATED M Qr m gt Language Code Communication Details ENG meme eae 0 j gt The Competent Authority Master screen consists of a header section and four tabs Communication Function Administrative Signatory In the header section you should fill in the following fields Field Description CA Code Unique code that will represent this competent authority throughout the system ERN Cade BE 13 digit code assigned by EAN International bebarme
82. a valdFrom EINST ZEEESINT su NN RR grep 301 01 1960 H 61 12 2016 g Not Endorsed Base Quantity C Actual Trade C Both Country Quantity Quantity Quantity Az 3 4 Methylenedioxyphenyl 2 pi 00 liters etat Acetic anhydride 13 01 13 01 13 01 liters p 0001 41 BK 4 352 200 CTI YHusepcan apw GERMANY SIGMA ALDRICH CHEt Acetic anhydride 10 00 10 00 10 00 liters loce 01 BK 4 312 2004CTI Pharm Dr Abidi IRAN Dr Abidi Pharmaceuti amp cetic anhydride 2 00 2 00 2 00 liters 09 BK 4 520 2004 l ocynapcTBeH UeHTpGERMANY Sigma Aldrich chemie Acetic anhydride 1 00 1 00 1 00 liters BP coocse BK 4 297 2002Pec Hayy acc Kopin AUSTRIA Scientif Sec Division 1 amp cetic anhydride 01 01 01 liters Total Acetone 27159946 17 27159 946 17 4 518 544 61 liters Total Acetyldihydrocodeine 50 50 10g This report is used to briskly retrieve the data on the completed Import transactions i e the transactions on which the endorsements are already made and the substances that are accounted for as imported When the query is done the results are shown first as a list of substances So you should click on the sign of the right side to view the details User Manual 96 4 5 4 Certificates Report Import Export gt Certificates Report P9 Figure 110 Certificates Report Schedule Ind EOF YEE Cr C II C nl Cw or E MENT RR ex CI C301 01 1960 amp 51 12 2016 E Not Authorize
83. ain Import Certificates Although INCB does not recommend such practice a need occurs from time to time That is why in the next two sections we will describe how to prepare the Import Certificate Request and issue Import Certificate s using NDS 4 1 3 Import Certificate Request You may create an import certificate request instantly by going to the Import Certificate Request tab right after saving import authorization Otherwise you may first query the necessary import authorization record see Chapter 2 General functionality Queries and then open the Import Certificate Request tab The fields in this tab are nearly the same as in previously reviewed tabs so are the rules of working with such fields Only one field is added which is Imp Auth indicating that this particular certificate is issued as a Supplement to some already issued Import Authorization However unlike the import authorization related tabs the SubstanceCode drop down contains only the substances and or preparations indicated in the import authorization Thus in our example the import authorization was issued only for morphine hence only morphine is shown in the drop down box Figure 96 Choosing the Authorized Substances for Import Certificate Substance Code Substance Name H id aS oos Auges iC NOD2 Methyl ethyl ketone The example of the import certificate request is shown in the figure below Figure 97 Import Certifi
84. al tab Lon ention User Manual 76 The following data should be indicated Field Value Year The year to which the below mentioned statistics for the Country relates No of inhabitemis 2 Number of inhabitants as of the year in question come BEN GDP per capita as of the year in question NS hector Number of practicing doctors No of Dentists MM Number of practicing dentists No Bn EM Number of practicing veterinarians NS ofPhanmaciss ME Number of registered pharmacies involved in retail trade of medicines No inoi mM Number of registered hospitals No si beds BEEN Number of hospital beds in the country Any relevant comments on the above mentioned statistics sources relevance possible Comments l discrepancies etc 3 7 2 City Master The City Master is used to indicate the names of various cities in various countries City Master may be invoked in two ways 1 from the main menu Masters gt Demographics gt City Master 2 by double clicking the City drop downs in Customs Point Master Figure 85 City Master Country usa v LIMITED STATES OF AMERICA Mus 7 Code MENNN ene copied From IDS Austin copied Fram IDS Qm i User Manual 77 You will need to enter the following data Field Description Header section Country Code or name of the country the city is located in Details section en em m CityName Name of the city The contents of thi
85. alog window below will appear Figure 93 Open Requests dialog window Establishment Code EH ablahanens Name From CNCNMC Soe Reference pic Exp Request Number Request Imp Country Imp CA Exp Country Exp CA Exp Establishment Flag Date Name Department Name COL AERIS Name Department Name AOK 3235 Import 1732 BKNKHK 1732 201 20 06 2006 Uzbekistan Ministry of Health Focyaapcteen LlenriSwitzerland ESTNE l F Hoffmann La Roche LT La Roche L AOK 3148 Export 110 BKTIKHK 110 2006 16 06 2006 AFGHANISTAN CHIEF OF PHARMACELHaji Ahmad Traders Uzbekistan Ministry Health TawkKeHT rop FAO NEED AOK C 00076 Import 000158 BK 4 369 2006 10 04 2006 Uzbekistan Ministry of Health ViHcTHTyT 6GHoopraHH GERMANY THE FEDERAL INSTITISIGMA ALDRICH CHEMIE AOK N 5 Import 398 09 07 2003 Uzbekistan Ministry of Health l ocy AaapcrBeH Lienr INDIA NARCOTICS COMMIS Rusan Pharma PVT Ltd 12 This option is more convenient when you have a number of entered Requests pending authorization User Manual 86 In the first case after querying click on the Import Authorization tab In the second case just double click on the RequestNumber field the request will be opened in the Import Authorization tab Figure 94 Example of Import Authorization Import Authorization Request Import Authorization 7 774 7 1 3 1 5 Import Certificate Endorsements Additional Establishments Request Number Request Date 000158 BK 4 369 2006 L0
86. an with the mouse An underlined character in the menu item s name or label tells the user what key to press The user presses it in combination with the ALT key For instance to access the Help menu the key provided is lt ALT gt lt H gt 2 4 4 Common Toolbar Buttons The toolbar buttons that are common across the entire system are shown in the table below Button Description Application toolbar 9 Help Shows the list of help topics for NDS c3 lt UserDetails gt shows the details of the current user uF lt CloseApplication gt Closes all NDS windows and screens open at the moment Zz lt CancelQuery gt Discards the results of the current Query and switches the oC Sorento Edit mode 0L ks lt EnterQuery gt Switches the screen to Query mode so that you can enter the aaao Wery criteria oL Y lt ExecuteQuery gt Executes the Query according to the entered criteria 2 lt AddRecord gt Adds new record to the current Screen or Section of a Screen e lt DeleteRecord gt Deletes the current active record r p Saves Saves the changes matde to the records of the Screen EM 0 0 0 PrintALLs prints all data in current sereen E Prind Prints the viewed data of the current Screen r M Excel Exports the data of the current record into Excel format lt ExceByRow Export unformatted data to Excel F S lt ExcelPivot gt Exports the data into pivot tab
87. ance Master Maintenance form Masters gt Substances gt Permitted Restricted Substance Figure 63 Permitted Restricted Substance Master Country Code Country Name Year Ki Kimo 0 Substance Code Substance Name Schedule Import Limit Export Limit Preparation Code Preparation Name Table pe Pcoos PCOO3 e Chlordiazepoxide 60000 00 60 000 oof 0 00 g E e 23 4 Lone a 0 o eJ d 17 5 p 2s In the Header section of this Master form you are supposed to enter the Country and the Year for which the Estimated Assessed quantities will be entered If you enter the Estimates Assessments for this country for the first time you will have to enter all values in the detail section manually Field Substance Code Preparation Code Value Code of a Substance Preparation for which the Estimated Assessed quantity is entered Preparation Name Schedule Table Indicator Name tag for SubstanceCode Number of Schedule or Table this substance is listed at You cannot modify this value from this Master as it is fixed in the Substance Master
88. and e To ensure that countries obtain the quantities they need for medical scientific and other licit purposes Monitoring and managing movements of controlled substances is a complex process involving numerous partners Typically information needs to be exchanged between commercial companies national drug control administrations customs officials and the International Narcotics Control Board INCB Member states are also obliged to report an annual review of legislative and administrative measures trends in indicators of drug demand and supply and information on the implementation of the drug control treaties A computer based system NDS is intended for facilitation of daily management of licit movements and drug controls measures Being an electronic repository of data on national drug control measures drug abuse and trafficking it enhances timeliness of information exchange at the national and international levels The system enables national administrations to keep track of all individual transactions and data from issuance of domestic licenses import export authorizations certificates and pre notifications for international licit trade to domestic distribution It facilitates national monitoring and management of companies in relation to production manufacture consumption stocks confiscation or seizures information It offers electronic data interchange EDI within and among countries as well as to and from INCB UNODC Hard copies
89. and usually are titled as Comments Remarks or Notes Figure 8 Example of Comment field Comments 2 6 3 Date Field This is the field specially intended for entering dates Date fields are equipped with drop down calendars that facilitate the date entering and decrease the possibility of mistakes and errors Figure 9 Drop down Calendar Imp Auth Cert 23 Jan 2006 amp January 2006 EREIERSEHRERSEASEH 1 2 3 4 5 B 7 8 9 10 11 12 13 14 15 1B 1 18 13 20 1 22 23 24 25 26 27 28 2g 30 3i Empty Date make a double click for the calendar to roll up If you make a single click the date will be Note When entering the date using the drop down calendar point to the desired date and selected but the calendar will stay open on the screen 2 6 4 Checkbox This field is the easiest to fill In fact it has only two options checked Yes and unchecked No Figure 10 Examples of checkboxes Check Estimates Check licences Check Import Lirit Check Export Limit L L Queries on checkboxes are possible 2 6 5 Drop down boxes Drop down boxes are very widely utilized in NDS because of their simplicity and usability A drop down box can be easily recognized by the down arrow on the right of the value field Drop down boxes drop downs make data entering faster and more convenient simultaneously reducing the number of possible errors as the user should only select some value from a list
90. andle controlled substances or deal with them The process of issuing a license alike with import export authorizations is divided into two stages request of license and authorization of such a request 5 1 How to create a License Request License gt License Request Figure 113 License Request Form Request Number Previous License Number Contact Person Establishment Code Establishment Name 00010 v l ocyAapcrBeH LleHTp 3KCNEpTH3bl H CTaH NeKap cpeA m ooo Request Date alid From alid To Signature Fax D8 JUN 2006 amp M os 3uw 2006 os IUN 2007 E Conditions Remarks ro d 14 Ei BE we b n Clearance Information Substance Details Licence Types Linking Substance Details Type Subst Prep Group subst Prep Group Name No Of Units UOM Requested Qty IC Substances Preparation C Groups INPEN 414 MORPHINE HYDROCHLORIDE 3ML SMG ML ai 10 Boxes Qa sr 0 gt Most of the fields are already familiar to you as they have been described in sections dedicated to Import Export module and Establishment Master Field Value Request Number The number of request Can be assigned automatically depending upon system Nuno settings Request Date Date the request has been filed AvndTo BEEN Date when the license is supposed to expire Se CA Code Code of respective competent authority User Manual 100 Field Value GA Department Name _License issuing department of th
91. asters gt Establishment gt Establishment Master Fill in the necessary header and detail fields Save the new record From now on it will be available in all Establishments related drop downs In the figure below you can see the example of the newly entered Establishment Figure 74 New Establishment Record Country Code Country Name Street Name City E oo mmmmm Establishment Code Establishment Name State Zip Code andorra Exports Pe Establishment Type Code Establishment Type Name Country Name aon wPTRADING COMPANY qon meo gw EAN Code InActive HQ Name Communication Details Comments m mmu 0 Language Eam x 4 8 5 1 Code ENG gm Exports pens Exports poner ea m gt a When entering the data please take into consideration the following information on the fields Field Value Country Code Code of the country the establishment is located in Name of the country the establishment is located in This field is filled in automatically Country Name when you enter the CountryCode Se Street Name Street and house number City Name of the city where the establishment is located Establishment Code Unique combination of letters and figures alphanumeric combination Depending upon the system settings it may be assigned to an Establishment automatically or manually 7 Establishment Name Official name of the establishment State State
92. ation Type Code Mame pias E de i j j i P a SwI MP4S5wI M Y PURE PURE g MPEN 48 M Y PURE PURE a g JF IPETI SU N Y PURE PURE a g However you may only view data not edit or otherwise change them To be able to edit the data you should use the lt Ctrl gt lt Shift gt lt F10 gt combination User Manual 35 Figure 31 Grid Edit view Preparation Code Exempted Active Preparation Type Code Preparation Type Name aja Preparation Preparation 3434RUS N Y TAB tabl P 45454545WI N Y TAB tabl P l Note In grid view you may double click any necessary record and it will be opened for editing if such is allowed in the normal view 2 13 Audit Trail The system provides a facility for recording the brief information of the use of particular record This facility is called the Audit Trail E It shows who created the selected record and when he she created it Moreover AuditTrail provides the information which user last modified the data and the date of the last modification A sample audit trail detail screen is shown below Figure 32 Audit Trail 42 Audit Trail CreatedBy ND532 Created On 24 04 2006 Modified By Modified On 2 14 Error log NDS 6 0 provides a user with an opportunity to record and view the errors made by particular users Note By an error here is understood the action making the system respond with an information message error message warning message
93. ation Type Code Niicioue e lof Preparation Type Shows the name of preparation type Filled in automatically UOM Code of unit of measurement of preparation type See explanations below UOM Description Shows the name of the unit of measurement Filled in automatically What is preparation type This term in NDS denotes primary dosage of preparation That may be tablet capsule ampoule etc You may define your own preparation types using the Preparation Type Master which may be invoked by double clicking on the PreparationTypeCode field See also Preparation Type Master The UOM unit of measurement represents the package in which the preparation is presented for customs clearance See also How to define units of measurement Unit of Measurement Master Thus if the preparation has a form of tablets and these tablets are packed in blisters then Preparation Type will be tablet and UOM blister Depending upon settings in Parameters section this field may be filled in automatically According to the 1961 Convention and the 1971 Convention if a preparation containing controlled substances is compounded in such a way that it cannot produce any ill effects or presents low or no risk of abuse and if the substances contained in such preparation cannot be readily recovered from it such preparation can be exempted from some control measures In NDS such preparations do not affect the statistics in INCB forms User Manua
94. ay be expedient to enter a string in your native language into the SortDescription field User Manual 41 3 1 3 How to indicate the type of a substance The data on particular substance are managed depending on whether the substance is a narcotic drug a psychotropic substance or a precursor Type of entered substance is indicated in the Substance Type tab of Substance Master form The Figure below shows the appearance of Substance Type tab Figure 37 Substance Type tab Language Special Conditions This tab includes seven checkboxes Field Value Narcotic Indicator The substance is a narcotic drug included in the Yellow List Psychotropic Indicator The substance is a psychotropic substance included in the Green List Precursor Indicator The substance is a precursor included in the Red List Others The substance is not included in either of the above mentioned Lists but can be possibly used in illicit manufacture of narcotic drugs or psychotropic substances Synthetic Ind The substance is synthetic i e manufactured from other substances Variation Ind The substance is a variation INCB Ind The substance is controlled by INCB 3 1 4 How to indicate the special conditions of transactions with a substance Different substances require different measures of control Using the Special Conditions tab you may easily specify which restrictions will be applied to particular substance Figure 38 Special Con
95. bstance Code Substance Name Total Imports Total Exports ik Schedule Confidential Indicator 0 00 0 00 0 00 0 00 63 693 90 qp o2 ja 139 EL ec natci d 1111 g Dest Country Code Country Name Export Quantity v KYRGYZSTAN _y Republic of Tadjikistan 32 037 00 31 656 90 677 168 719 00 substances having been used in illicit manufacture The code of a seized substance included into Table or Table II of the Red List or of the Substance Name Name tag for the SubstanceCode VOTO ports the year in question Total quantity of the Substance brought to the territory of the reporting Country during ee Total Exports during the year in question Total quantity of the Substance exported from the territory of the reporting country Number of Table the substance is included into Although the Table term is usually Schedule applicable to precursors the word schedule is used throughout NDS as the essence of ee Tables and Schedules is naturally the same UOM Unit of measurement in which the substance should be reported on Form D Confidential The checkbox showing if the entered information should be treated by INCB confidentially checked or not unchecked In the Imports and Exports Details Section Origin Country Code Destination Country Code Import Export Quantity Imported or exported quantities of the Substance Code of the country from which this
96. c Substances the Governments shall report the quantities of controlled substances that were added procured or withdrawn from special stocks At the same time the governments shall not be obliged to report the actual quantities of controlled substances kept in special stocks There is a special tab in NDS responsible for entering data on transactions with special stocks All you will have to do in order to enter new transactions is to define TransactionDate Subst Prep Code code of the substance or preparation and the Quantity of the substance or preparation which was procured for special stocks positive Quantity value or withdrawn from special stocks negative value User Manual 144 Figure 156 Procured Withdrawn tab Opening Stocks Inventory Adjustments Inspection Results eene Closing Stocks 12 07 2006 v cEo01 v EPHEDRINE P xl SDa 3 7 1 4 How to indicate the closing stocks This tab allows a user to indicate the stocks of controlled substances at the warehouses of manufacturers and wholesalers as of December 31 of the reporting year Figure 157 Closing Stocks TIT Ends 23 POsee oa B urixubiccA Lunis A uELIB Closing Stocks SEE a Ra Transaction Date Subst Prep Code Subst Prep Name es Closing Balance Closing Quantity aae Seto 12 07 2006 czo1 EPHEDRINE EPHEDRINE v rj 5 0 aae 0 Similarly to the
97. c atis bte a ex dota nec ne AR ER aAA EE ATAA EEEa 102 5 2 How to Approve a License Request eeecleeeeeeieeeee ee eeee nnne nnne nn nnne n nnnm n nnns 102 5 3 How to revoke ING LICENSE mee IEEE 103 DA HOW to Suspend a LICENSE coo acce east ou tenes eet Deco one e eee eroi a aaO aa KaSS AN 104 5 5 How to Re aclivate a Suspended License ecce cerae reir re cree resa ou aeo rhe e Rye ee EecpUEUS 105 5 6 How to RENEW a LICENSE ordeo a eio tede a Poen a ue osa E ca Ee Se ae uua cU Sa eoe eu elena 105 S b LoExIensionror validi LICENSE oeer e fates sae eas todo oum ed due tte ca dios ot eee coe eens eeecnes sie 106 5 5 2 Heriewal oEExbIFed LICENSE abdsdsdaissadeasootsos iuis ede na coa eduiispema cv idus tasted ian a A 106 5 How To amend a Licens osi uas tedio oe onore e eee u dicas a ceciu du ue Od ves as a edu i Dd Ue Pda aia 107 SEM MICE Me DOM eR 107 9 9 Eicence Type Masten e 108 CHAPTER 6 INCB REPORTING FORMS ccseccseceeccuecneecuecceeeuseneueuseneeeuseueeeuseneueueeueeeuseneueuseueeueseuseeseuenessnens 109 Giz Narco lG S aoine EE 109 6 1 1 Quarterly statistical report T OPFIA asia to nte iere aa anced eae atu ys den ttes eden eR es asain aoe dees 109 6 1 2 F OFM Be Annal ESTE Sodio iier estet e ti ites atouts abii A S 113 64 9 Form Annual Slat SCS x em uoto E NE TAI Mace ax thai quisi iugis t solida ive icti Petepde tror Mae PS 119 6 2 i elrrejigojo let fae e eee EL 124 6 2 1
98. cate Request Import Authorization Request Import Authorization Import Certificate Request Burzi MB Fn Additional Establishments Request Number Imp Auth Request Date 422 00158 BK 4 369 2006 L0 APR 2006 x Valid From alid To Signature Itinerary L9 APR 2006 E L9 APR 2007 x AK A3M3OB I K AZIZOV QBs 32 gt Substance Code Substance Name Preparation Type md Auth App Qty Requested Qty E 10 cwo02 Methyl ethyl ketone X 0 7 liters e ia if arn gt pi Fitered Point of Entry Point of Exit Mode of Transport ei i r3 gt gt In some countries the import certificates are not acceptable Thus depending upon the settings of NDS for such particular countries the Import Certificate Request and Import Certificate tabs may be unavailable User Manual 88 4 1 4 Import Certificate To issue an import certificate as in case with the import authorization it is enough to enter the approval date and quantity to be approved in the proper fields ApprovalDate and ApprovedQty respectively Figure 98 Import Certificate Import Authorization Request Import Authorization Import Certificate Request Import Certificate 1272771 x Additional Establishments Request Number Imp Auth Request Date Approval Date 422 00158 BK 4 369 2006 10 APR 2006 x L9 APR 2006 x Valid From Valid To Signature Itinerary L9 APR 2006 E L9 APR 2007 E M K A3M3OBJ I K AZIZOV e i if 172 g
99. cate its quantity Mu Note For each record in the upper section there may be two or more lines in the lower section of the tab as one drug may be user for manufacture of two or more other drugs 6 1 3 4 How to indicate the data on cultivation of opium poppy coca bush and cannabis plant This statistical data should be indicated only by the countries where cultivation of opium poppy coca bush or cannabis plant is authorized The tab is intended for entering the data indicated in parts Ill a and Ill b of the paper based Form C Thus in the upper part you are supposed to enter the data concerning the purposes and scope of opium poppy cultivation whereas in the lower part you are supposed to enter the figures concerning the quantities of obtained cannabis and coca leaf There are four purposes of cultivation of opium poppy e Production of opium Production of poppy straw M for manufacture of narcotic drugs Production of poppy straw T for manufacture of narcotic drugs Purposes other than production or manufacture of narcotic drugs Thus you should select one of these purposes in the Purpose drop down and then indicate the area where the poppy was sown for this purpose area from where the poppy was harvested and the produced quantity of opium poppy for above mentioned purpose of course The tab is titled Manufactured Opiates although the data on utilization of coca leaf coca paste and ecgonine which are not opiat
100. ce screen 2 By means of Users Roles Management screen 8 1 3 1 Granting roles with User Roles tab The User Roles tab of User Maintenance screen looks as follows Figure 175 User roles tab Grant RoleTo User Revoke User From Bole Reset Password All you have to do is press the lt Grant Role to User gt button and then select proper Role from the drop down list After that press the lt Save gt button to save the record To revoke the role from user place the mouse cursor on the necessary role and press the lt Revoke User From Role gt button Then save the record 8 1 3 2 Granting roles with Users Roles Management screen To Grant a role to a User by means of Users Roles Management Screen 1 Click in the User Name in the left pane 2 Hold the mouse button and drag the user name to the necessary Role 3 When the Role is highlighted release the button 4 Save the record a ta All Holes um ne GSTUSR GUESTUSER J ALL_ROLE m Er HD532 ND532 iiia E STAS NDS ADMIN NDS_ADMIN ZEE ne YLADIMIA a STAS STAS b 5 GST i VLADIMIR VLADIMIR m E Inactive Users User Manual 160 To Revoke the Role from a User 1 Click on the necessary User under some Role 2 Hold the mouse button and drag the User name to left pane 3 Release the mouse button 4 Save the record All Users ALL_ROLE ol STAS VLADIMIR W GST E GSTUSR cH NDS_ADMIN_ROLE 8
101. cense menu License gt License Reactivation S Figure 122 License Reactivation form License Number Previous License Number Signature Establishment Code Establishment Name Contact Person boog Dori Darmon shareholding company Approval Date alid From alid To E_mail Address 28 JUN 2006 Mio5 JUN 2006 MEMos JUN 2007 Reactivate Date Reactivate Reason Phone Number m i Suspension Date Suspension Reason 12 JUL 2006 iolation of narcotics related legislation ni Re oo Substance Details License Types Linking Substance Details Subst Prep Group Code Subst Prep Group Name No Of Units UOM Requested Qty Approved Qty Substances Preparation Groups NFOO1 Fentanyl b 10 10 00 amp Two fields should be filled in order to re activate the license ReactivateDate and ReactivateReason 5 6 How to Renew a License There is a difference between renewal and reactivation of licenses M Note Henewal means extension of action period of a valid or expired license Thus you may not renew the revoked or suspended license There are two renewal forms provided in NDS one for renewal of the already expired licenses and another one for renewal of licenses that are still active User Manual 106 5 6 1 Extension of Valid License License gt License Renewal gt Extend Valid Licenses In the displayed form you should fill in the following fields Field Value LicenseNumber This drop down
102. cessary Group in the left pane The same rules apply to the Preparations section as well though the information shown upon the click on Li button is slightly different Figure 72 Preparations Section of the Group Master arphine Hydrochloride 3ml Srmaml Promedol Smatnl Promedol 1mgtnl Figure 73 Preparation Attributes pop up m 5 7 o o ooo wii 22 H D AMPHETAMINES APHETAMIMES CD OPIATES Opiates HH CD cPs Concentrates of Puppy Straw C007 ONC OF POPPY STRAVY S095MORPHINE COO7N A ONC OF POPPY STRAVYNEITHER ACID NOR BASE C0189 ONC OF POPPY STRAW 50 THEBAINE f of arcotic 100 i arcotic 100 i arcotic 100 i QM onm o rjr PET1 414 orphine Hydrochloride 3ml Smal i Substance Code Substance Name UOM Conversion Factor Quantity Volume NMOOSHCL MORPHINEHYDROCHLORIDE lo 89 AMPHETAMINES APHET AMINES OPIATES Opiates Qs d 2 gt Qe 3 n M Note A group may contain Substance s Preparation s and other Group s After you have finished forming the necessary Group save the record Starting from that moment the newly created Group becomes available in the Licenses Module User Manual 67 3 6 Establishments Establishment is a generic term used in NDS to indicate an entity or an individual licensed or otherwise legally empowered for operations with controlled substances 3 6 1 How to create an Establishment Open the Establishment Master M
103. d LI Base Quantity C Actual Trade C Both EE RN NN NUN UN UN UN Country Quantity Quantity Quantity BT Acetone 4 614 403 79 4 614 403 79 4 360 503 79 liters Total Alfentanil 20 00 20 00 20 00 g Total Codeine 84 60 84 60 84 60 g rotat Fentanyl 9 62 9 62 9 60g 000087 HK 4 96 2005 Dori Darmon sharehoRussian Federatio Or Yn Mockosckui 3x Fentanyl 9 60 9 60 9 60g EA HK 480 2003 FocygapcTeeH UeHTpINDIA Rusan Pharma PT L Fentanyl 02 02 00g Total Methyl ethyl ketone 7 00 7 00 00 liters This report is intended for retrieving information on the import certificates issued in the user s default country for import of controlled substances from TradingCountry When the query is done the results are shown first as a list of substances So you should click on the sign of the right side to view the details 4 5 5 Export Report Import Export gt Export Report P9 Figure 111 Export Report Export Authorisation SETTE T 01 01 1960 885122016 MEER 07 01 1060 E 31 122016 SAM sl Approval Date 01 01 1960 amp 31 122016 amp valid To 01 01 1950 amp Base Quantity C Actual Trade C Both ZI PSN e e eee E intty RENI Country Quantity Quantity Quantity BI Hydrochloric acid 149 940 00 149 940 00 141 193 50 liters 000021 OAO Navoiazot Republic of Tadjiki CTBI1 3epasuanH Hydrochloric acid 49 980 00 49 980 00 49 646 80 liters PB oo0023 O40 Navoiazot Republic of Tadjiki CTK OOO AnpeneskaHyd
104. d first create the new Form C Narcotics gt Form C 5S Figure 137 Form C Annual Statistics Country Code Country Name Year ESSE MEL 3 5 Ii REMARKS Statistics Manufactured Raw Material Material Manufactured Opiates Cultivation Seizures Substance Code Substance Name Quantity Quantity Quantity Quantity Quantity Oty Lost Manufactured Consumed Used for the held in procured P for During 3 manufacture Stock special purposes Manufacturing of ScheduleIII on 31st or withdrawn W Process d Mio gpeoaeeos 8 m G INcOOI canmabs ow 10 197 10 197 G Rica feste 3 43 285 211 372 G NCO11 v Cannabis resin non medicaluse w 5 0 5 0 G NDO08 w Dihydrocodeine ow 4 G NE006 v Etontazene 046 G NF001 Fetav ow 7 526 1 964 G INHOO1 v Hei vj 087 d G INMOO2 v Methadoe ow 045 G INM009 v Mophine ow 1 807 985 1 135 556 Noo opm ow 5 0 5 0 G E INTOO2 Thebaine ow 3 129 7 439 G DDJA oi Alkaloid Code Alkaloid Name Quantity Quantity Quantity Quantity Quantity Qty Lost UOM Manufactured Consumed Used for the held in procured P for During manufacture Stock special purposes anufacturing of SchedulellII on 31st or withdrawn W In the Header section please be careful when entering the year Note The country year combination must be unique i e it must not repeat throughout NDS If M you try to create a Form
105. de Change Master Figure 180 UDF Code Change Master Pure Substance Variation UDF Code Substance Name Unit Of New UDF Code Narcotic sychotropiPrecursor Schedule i Code Code Measurement Indicator Indicator Indicator Ind Aminorex Barbital Barbital Benzfetamine Benzf tamine Bromazepam BromazHpam Butalbital Butalbital Butobarbital Butobarbital Buprenorphine Buprhinorphine Brotizolam Cyclobarbital Cyclobarbital Camazepam CamazHhpam Chlordiazepoxide Chlordiazripoxide Clobazam Clobazam Hydromorphinol Hydromorphinol Hydromorphone Hydromorphone g GRAMME S g GRAMME S g GRAMME S g GRAMME S g GRAMME S g g GRAMME S g GRAMME S g GRAMME S g GRAMME S g GRAMME S g GRAMME S lt lt lt lt Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z 2 2 223s LLELLE 2 Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z SF 4 A A A A UU U A amp A UUA A YW WwW fF A A A AA Just find the necessary substance enter the new UDF code and then save the record 8 2 6 Pre defined Substances These NDS functionality provides an opportunity to define the substances indicated in paper based INCB reporting forms Form A Form A P Form C etc The substances indicated in this section will be printed when a user selects an INCB printing option Figure 181 Pre defined Substances for Form A Predefined Substances Extra Substances mos Apea
106. displayed on the screen or in printed forms every time the Unit of Measurement respective Language is set ee The content of this field defines the place of the substance in the SubstanceCode drop por Desctipuen downs throughout the system Comments Optional comments concerning the unit of measurement By using the Advanced tab of Units of Measurement Master you may define the conversion factors to easily calculate the number of other UOMs in the current UOM User Manual 45 Figure 42 Unit of Measurement Master with Languages tab active UOM Code AMP OO 3726 ofo Unit Of Measurement Sort Description Comments ENG ze Ampules FRE v AMPOUILE S AMPOULE S RUS Any nel Amnynbl ea 103 Pj Figure 43 Advanced tab of Unit of Measurement Master ET Advanced UOM Code Unit Of Measurement Conversion Factor Comments pp 1 00 System Generated eooo i i r L MG MILIGRAMS v 1 00 System Generated PORRETTA 3 1 9 How to indicate the conditions of import or export of a substance General Conditions Master This maintenance screen is intended for entering frequently used conditions of import export The Conditions Master may be invoked either from Import Export module or from the Masters menu Masters gt Substances gt Conditions Master User Manual 46 Figure 44 General Conditions Master Code Condition No 7 Conditions stimated import limit cannot be exceeded All you ne
107. ditions tab a peek III ES RES mE H a peek EEES EEE ES RES mE if a peuk EEEE FH mE User Manual 42 Field Value If the imported quantity exceeds the quantity of Estimates Assessments for this ence a substance NDS will produce a warning message Gracie Vicanene lf a License is not available for transaction with this substance NDS will produce a warning message Check Import Export The NDS will check if the quantity of transaction exceeds the Import Export limit and Limit if does will warn you with special message a 1 i Not only availability of a license for particular transaction with particular substance will MISCtEIGonseisauanuy be checked but also the licensed quantity import Conditions Certain conditions regulating the import of this substance the text entered in this field p may later be inserted into the Notes field of Import Documents of Import Export Module m Certain conditions regulating the export of this substance the text entered in this field Export Conditions may later be inserted into the Notes field of Export Documents of Import Export Module Certain conditions of issuing and revoking a license for transactions with this substance License Conditions the text entered in this field may be later inserted into the Conditions field of License Documents of Licenses Module 3 1 5 How to define a pure substance
108. dministrative tab of Competent Authority master Figure 58 Administrative tab Requested By ICPO GMT Time Difference YES v Office Hrs Start Time Office Hrs End Time 09 00 17 00 Office Hrs Breakfast Start Time Office Hrs Breakfast End Time 11 00 15 00 Language Proficiency Comments NGLISH Qa e 0 eC User Manual 57 Here you should fill in the following fields Field Description Requested by ICPO This flag shows if the information can be requested by International Criminal Police Organization Interpol GMT Time Difference Difference of time between the location of the CA and the Greenwich Mean Time Office Hrs Start Time Local time that CA starts functioning Office Hrs End Time Local time that CA end functioning Office Hrs Breakfast Start Time Office Hrs Breakfast End Time End of lunchtime Start of lunchtime Comments Necessary comments concerning this CA 3 3 1 4 How to indicate the countries for which this CA Is a signatory To indicate such countries use the Signatory tab in the Competent Authority Master Figure 59 Signatory tab Communication Administrative Signatory BEL _y BELGIUM AMS AMERICAN SAMAR w BAR _y BARBADOS ear vs gt Just enter code s or name s of appropriate country together with necessary comments and save the record 3 3 2 CA Communication Master The C A Communication Master is used to indicate the means of commun
109. e To make it possible for NDS users to do these kinds of analysis without knowing a lot of technical things we added a smart tool in NDS called Excel Pivot User Manual 30 2 11 2 Excel Pivots Excel Pivots has four basic kinds of field orientations 1 Row Fields 2 Column Fields 3 Data Fields 4 Page Fields Figure 24 Structure of Pivot Table COLUMN Row Fields are the fields that are distributed in rows e g Trading Country in our case Column Fields are the fields shown in columns of the Pivot Table in this case Transaction Type Imports Exports Data Fields are the data items themselves on which you want to base your analysis and calculations e g Approved quantity in our case Page Field is the field use to filter a restrict filter the data shown at any particular time in Pivot Table In our case Substance Preparation is the page field which by defaults shows no restriction but results can be restricted for any substance or preparation in the list We just need to identify these dimensions fields in our data and start building our Pivot Table 2 11 3 Exporting data using NDS Excel Pivot Open any report retrieve some data go to menu System Excel Pivot User Manual Figure 25 Screen dialog for Excel Pivot Sabet Prep mnt SCTE dEDO eS CONPE SE JV IEEPUOCESE PR TAH ALTA 12000 CONPSIM AV DISPOSITE PR TH ACTS EDU COMPRISE v CEST FRE UEPPLIC Tn I3 2004 BETO DOUG CONPRIME AV es F
110. e RequestNumber field to open the request authorization window with the request data Figure 119 License Authorization Form Request Number License Number Previous License Number Signature Establishment Code Establishment Name Contact Person alid From alid To Approval Date Revoke Date E mail Address beouzoe fioe un 2007 e uz eo oo e Revoke Reason Phone Number Conditions Remarks ET KEETE D O Substance Details License Types Linking Substance Details Type Subst Prep Group Code Subst Prep Group Name No Of Units UOM Requested Qty Approved Qty Substances Preparation Groups IPEn 414 Morphine Hydrochloride 3ml 5mg ml 10 Boxes 50 i D a aa e All you have to do in order to authorize the request is to enter necessary quantities into the ApprovedQty field on the Substance Details tab M Note The RequestedQty may be left blank in case the establishment requests an unlimited license However you may specify some fixed quantity in the ApprovedQty field Q Note The ValidFrom date cannot be less than ApprovalDate When you save the request authorization you issue the license and from this point on it will be considered by NDS in all transactions carried out by the licensed establishment 5 3 How to revoke the License In practice there are cases when the issued licenses must be revoked i e their action should be terminated due to whatever reason before the designated term of ex
111. e and the Name of the Role and press the lt Save gt button The Role Grants tab opens Figure 172 Role Grants tab Window Emit IMPORT_EXPORT EMM Domestic Purchases Sales LICENCES MASTERS NARCOTICS EMM Domestic Purchases Sales Missing Entries EMM Domestic Purchases Sales Discrepancy PARAMETERS EMM Domestic Trade PRECURSORS EMM Import Export Report PSYCOTROPICS SECURIT EMM Manufactured JOUJOU QU D D EMM Seizures EMM Stock movement EMM Stock Ledger Establishment Stock Movements 71 71 1 01 71 Ty Ty ay ay aadd 71 71 1 71 71 Ty Ty ay ay a Attachments User Manual 157 In the left pane you are supposed to select the module you want to assign the user rights to If you select the All Modules option all modules and screens will be displayed in right pane In the right pane there are checkboxes showing if a user of this role will have a right to view insert update delete records in some screen checked or not unchecked Our task is to create a role giving user rights to view records only Thus we should check all boxes in View column see Figure below To facilitate the selection process use the following buttons in column headers Ca check all selects all checkboxes in the current column x uncheck all unselects all checkboxes in the current column Grant all s crant al selects all checkboxes in all columns X Revoke AI unselects all checkboxes in all
112. e competent authori filed in automaticaly Establishment Code The code of establishment applying ae Establishment Name Name tag of EstablishmentCode led in automatically Conditions 0 The special conditions to be included into the license s wording Contact Person An employee of he establishment responsible for license management Email Exmaladdressoftheestabishmentorcontacisconceminglicensg Phone Number Phonerumber ofthe establishment Fax 5 Faxnmberofheestibihmen Remarks ariana S 5 1 1 Defining substances to be licensed After that you should indicate the substances for which the license is issued This can be done in SubstanceDetails tab Figure 114 Substance Details tab Substance Details Licence Types Linking Substance Details ins Subst Prep Group Subst Prep Group Name No Of Units UOM Requested Qty Substances Preparation Groups __ 414 MORPHINE HYDROCHLORIDE 3ML SMG ML eee 10 Boxes i fe Substances Preparation Groups o HEXANENEITHER ACID NOR BASE HYDROGEN HYDROGENNEITHER ACID NOR BASE HYDROGEN CHLORIDE HYDROGEN CHLORIDENEITHER ACID NOR BASE wo Bi iT 2 2 gt al We would like to draw your attention to the Type selector in the right part of the tab This selector is used to choose the category of substances either pure substances and salts or preparations or groups to be displayed in the Subst Prep Gro
113. e fields also may be used for additional information in case the legal requirements of some particular country are not fully covered by the standard fields of Import Export module Figure 104 Remarks tab Remarks ires lg getters Import Authorization Import Certificate Request Import Certificate Endorsements Additional Establishments Proposed Date OF Export po 0000 Attachments siiis Conditions Custom Remarks il Custom Remarks 2 Custom Remarks 3 nnn Custom Remarks 4 n Custom Remarks 5 Custom Remarks 6 Also you may attach files which may be useful for processing of particular transaction Just click the lt Attachment gt button and choose necessary MSWord document or scanned document to be attached Figure 105 Attachments pop up us Attachments Ed Attachment Number Word Document Scanned document adil D ae Another tab which has appeared in NDS 6 0 is the Additional Establishments tab Here you can indicate various establishments see the definition in Establishment Master that are involved in this particular import export transaction such as carrier ultimate consignee broker etc This piece of information is very useful for further analysis and detection of establishments potentially involved in illegal trafficking of narcotic drugs psychotropic substances and precursors User Ma
114. e of the substance assigned by Chemical Abstracts Services PureSubstanceCode A codes of narcotic drugs start from N codes of psychotropic Q Note You may easily recognize if a pure substance is a narcotic psychotropic of precursor by a substances start from P and codes of precursors and other substances start from C 3 1 2 How to indicate the name of a substance When you have defined the code of the substance you should indicate its name This name will be displayed throughout the system as well as in printed reports and data files The names of substances are entered in the Languages tab Languages tab contains the following fields Field Value Language Code Code of one of the languages recognized by the system The name which will be displayed on the screen or in printed forms every time the respective language is set The content of this field defines the place of the substance in the Substance Code drop downs throughout the system Comments Optional comments on the substance name n some INCB forms the substances should be reported in alphabetical order If you use the language other than English it m
115. ea etc Place of Seizure Name of Substance the name of the narcotic drug or psychotropic substance that was intended to be illicitly Intended manufactured d using the substance seized Intended Illicit Remark confirming that the seized substance was really intended for illicit manufacture Manufacture not for some legal purposes volume and extent of the illicit manufacture of the above narcotic drug or psychotropic substance Volume and Extents M M Licit Uses licit use of the substance seized including extent importance etc 6 3 3 How to indicate the information on methods of diversion and illicit manufacture To report to INCB the data indicated on pages 7 and 8 of paper based Form D user the Methods of Diversion tab vl a a vl Figure 150 Methods of EE tab Substance Code L Name Seized Quantity Schedule Comments Indicator pico se Boricaid rm acid 50000 500 00 O WETET aa 3 Transit Country Code Country Name Destination Country Country Name of Seizures Code OM 0000 5m Place of Seizure Name of Substance Intended Intended illicit Manufacture Volume and Extents Licit Uses e lt A gt I User Manual 136 The tab consists of two sections e Substance details section where you should also indicate the name of substance intended to be
116. ed to do is enter the Code Conditions and then save the record 3 1 10 How to indicate types of transactions with controlled substances Transaction Type Master The Transaction Type Master is used to indicate the types of transactions carried out by establishments It may be invoked from the main menu Masters gt Establishment gt Transaction Type Master P9 Figure 45 Transaction Type Master Transaction Type Code DOMESTIC Jk C DOD 2 fofr ENG v Domestic Sales Domestic Sales RUS v BHyTpeHHHe npoAaxH BHyTpeHHHe npoAaxH Da az a User Manual 47 You will need to enter the following data Field Description TransactionTypeCode Unique code that will represent this transaction type in the system OOOO E The contents of this field defines the place of transaction type name in the appropriate drop downs of EMM Comments Necessary comments concerning the transaction type 3 2 Preparations The Single Convention of 1961 defines a preparation as a mixture solid or liquid containing a drug The Convention on Psychotropic Substances of 1972 gives another definition any solution or mixture in whatever physical state containing one or more psychotropic substances or one or more psychotropic substances in dosage form For the purposes of NDS the definition of the term preparation sounds as Any mixture or solution in whatever physical state containing controlled s
117. eeceeeeeceeceeeeeeeeseeeeeeeesssaaeeesssaaess 142 7 1 3 How to indicate the information concerning the Government s Special Stocks sssse 143 1 1 4 How to4ndicate the closing SIOCKS iunio tenes ote aee qute edo das estet ueg i les ya socia eie eas sv sosen ta denn leone uM pde s 144 1 5 HowTo VICW a LOC EOOCIBE cs coctis petat etedenietb a C risen eee Tura tci e Lu RETE 145 7 1 6 How to view a Stock Ledger Actual Trade sssssesssssssssssseeeeeennen nennen nennen nene nnns 146 7 2 How to indicate the manufacture related data e eeeee eere 147 7 2 1 How to indicate data on losses occurred during manufacture seeesseseeesseeeeeeeneeeennnn 147 7 2 2 How to record the manufacturing of narcotic drugs and psychotropic substances 148 7 2 3 How to record manufacturing of Schedule III preparations exempted preparations and non psychotropic SUS AC SS stu oit ua aei tat ascent ts ic mapu up Sees E sica ED Lo ieee oue ode cesa nu Rotae ues 148 7 3 Domesuc Iransacll lS suecense edax oy o EXe ra naxtuUu a dieto dMnuiss Un eds hau xu ste usura Kd debe Mivvqs v veM Ee Rd RE NE CE 150 7 3 1 How to account for domestic trade in controlled substances seeeeessseeeeeeeeeeeenne 150 7 3 2 How to Compare Domestic Sales and Domestic Purchases sssseeeess
118. eeeaeeeeeeeeaeeeeeeeesaeeeeessaeeees 39 3 1 2 How to indicate the name Of a SUDStANCE cc eecccceeececceececeeceeceeeeeeseeececeuecesseuecesseeeeessaceesaeaeeessaeeeesaaes 40 3 1 3 How to indicate the type Of a substance sssesssssssssssssssseeee eene nennen nnne nnne nnn nnns rns 41 3 1 4 How to indicate the special conditions of transactions with a SUDStANCE cccccsseeeecseeeeeeeeeeeeseeeeeeneees 41 3 1 5 How to define a pure substance Pure Substance Master ceceeeeeeeeeeeeeeeeeeaaeeeeeeeeeeeeeeeeeeeeeeeeaaeeaes 42 3 1 6 How to specify a Variation Variation Master cccccccccsseeeccsseeeeceeeeeceeeeeeeaeseeeseeeeeseeeeesaeeeessuseeessneeesaess 43 User Manual 3 1 7 How to import pure substance list Import Pure Substance List ccccceeeecceeseeeeeeeeseeeeeeeeseeeeeeseeaaeseees 43 3 1 8 How to define units of measurement Unit of Measurement Master ceccceeeeeeeeeeeeeeeeeeeeeeeeeeeaeeeeees 44 3 1 9 How to indicate the conditions of import or export of a substance General Conditions Master 45 3 1 10 How to indicate types of transactions with controlled substances Transaction Type Master 46 3 2 Preparations uci boc ede eese era teu caca Pu cueva cus eu rt uve Dos vo desta aaaea EA aSa 47 9 T HOW O create PreDal atio iioii iae e ct a Ee DE Su ME TE D Ecor E panes ea RM Si sU Mme Di SU D diee 47 3 2 2 How to specify the
119. en endorsements on export authorizations or on import authorizations certificates because any endorsement must contain the date of import export and the actual quantity of imported exported substances That is why there is only one Endorsement tab in NDS which is used for creating endorsements for both import and export transactions To endorse the import export document find the necessary one by means of querying and click on the Endorsement tab Choose the proper number of export authorization import authorization or import certificate from the Authorization Certificate drop down Authorization Certificate 110 BENKHE 110 2006 110 BKTIKHE 110 200B The system automatically detects whether one or more Import Certificates have already been issued and displays their numbers in the Authorization Certificate drop down box Note If there are several import certificates the endorsements should be made on each of them That means that you should create endorsements in the system for each of them as well M Thus when you finish and save the first endorsement create a new record and fill in necessary fields The system will warn you if you try to make more than one endorsement for one certificate After that most fields of this tab will be filled in automatically with data already contained in respective authorization certificate Figure 103 Example of Export Authorization Endorsement Export Authorization Reques
120. enced by NDS when you create an Import Authorization or Export Authorization see also Import Export Transactions 3 4 2 How to import the Estimated Assessed quantities As the Countries from time to time change the initial Estimates and Assessments by furnishing respective Supplements and Modifications to INCB the latter regularly publishes new figures on its web site from which they may be downloaded in the form of txt file To import the text format data in an easier manner special Load Estimates Assessment Publication form is provided in NDS 6 0 User Manual 63 Figure 66 Load Estimates Assessments Publication form 4 NDS United Nations Office on Drugs and Crime System Masters Import Export Licenses EMM Narcotics Psychotropics Precursors Parameters Window Help a F Load Estimates Assessments publication Year to which Estimates Assessments apply File Imported File Undefined Substances Substance Name Quantity eer Substance Code Missing in Details Substance Name To load the updated estimates assessments enter the year to which the data relate and browse the necessary txt file from your hard disk Figure 67 Load Estimates Assessments publication screen in action F Load Estimates Assessments publication Year to which Estimates Assessments apply 2005 File EstSep05 txt Imported File Undefined Substances Substance Name Quantity no Substance Code AFGHANISTAN Codeine 20
121. er Manual 126 Figure 143 Imports tab Remarks Imports SURSEANCE Code Substance Name Schedule Total Imports Indicator 900 00 PB003 v PB003 v Bemaepm gh pos X Diazepam o 15 197 70 G PPOOS8 v Phenobarbital 4 30 07 G Ai wD l 2 55 j Basin a a AUSTRIA 2 187 70 v Russian Federation 510 00 _y Switzerland 12 500 00 a E Total Imports 15 197 700 eau I 1 jv Both Imports and Exports tabs consist of two logical parts e Substance Data section upper e Country Breakdown section lower The following fields should be filled in the Substance Data section Field Value Substance Code Code of the imported exported substance UOM Unit of measurement in which the substance is reported Note The aggregated quantities are obtained by summing up all endorsed quantities in Import Export module You may also enter some quantities manually but without the underlying M Import Export transactions they will appear in red In the figure above you may see that the quantity for Secobarbital is calculated by the system while the one for Alprazolam is entered manually User Manual 127 The following fields should be filled in the Country Breakdown section Field Value Country Code Code on the country where the substance was imported from or exported to Country Name Name of the importing exporting country corresponding to a CountryCode Se Comments Any rel
122. ered into the system during the previous year NDS will show the balances of stocks of controlled substances at each of stock keeping establishments However in practice it may happen that some transactions affecting the value of opening stocks may become known to the competent authority after the initial EMM form has been created In this case the opening stocks should be corrected in accounting jargon adjusted For this purpose special tab is envisaged in NDS the Inventory Adjustment tab Figure 154 Inventory Adjustment tab Doan oa Inventory Adjustments Oea a E em uz 12 108 ERIT Bette E E Transaction Date Subst Prep Code Subst Prep Name eer Quantity ee pnis A 10 00 BOX 12 07 2006 y nPen 414 _y MORPHINE HYDROCHLORIDE 3ML SMG ML o Qa an gt M Note Please keep in mind that you should enter positive value into Quantity field to increase the initial value and negative value to decrease the initial one 7 1 2 How to indicate the inspections and their results The competent authority may inspect the stocks of the wholesalers and or manufacturers with the purpose of monitoring the actual quantity of controlled substances held therein NDS provides a simple but powerful instrument for recording the general information of such inspections as well as their results In order to record the above mentioned information the Inspection Results tab is provided in EMM Module The tab is div
123. ered to be at 31 Dec of scientific purp manufacture of the by the added to year to 4 3 Note The quantities you indicate in the supplementary estimates increase the ones in the M original estimates So if the final need in some narcotic drug is 480 grams and in original estimate you have indicated 400 grams then in supplementary estimate you should indicate Just 80 grams 6 1 3 Form C Annual Statistics The annual statistics of production manufacture consumption stocks and seizure of narcotic drugs must be furnished to INCB not later than June 30 of the year following the year on which the data are gathered Form C should be furnished even if the country has not produced manufactured consumed stocked or seized any drug during the year to which the form relates Only a Form C mentioning no movement of drugs constitutes a definite declaration on that subject The paper based Form C submitted to INCB consists of four parts Part I statistical data on manufacture consumption utilization and stocks of narcotic drugs Part Il statistical data on the manufacture of narcotic drugs Part Ill statistical data on the licit cultivation of the opium poppy and the licit production of cannabis coca leaf and opium Part IV statistical data on seizures of narcotic drugs User Manual 120 6 1 3 1 How to indicate information on manufacture consumption utilization and stocks To indicate this piece of information you shoul
124. es by nature should also be indicated here User Manual 123 Figure 140 Cultivation tab Cultivation a e iJ 171 b h Quantity of Coca Leaf used UOM We Quantity of Cannabis used UOM KG Note If the country does not authorize the cultivation of opium poppy for the purposes of M production of opium or poppy straw or the cultivation of coca bush or cannabis plant such a country should not provide any information on licit cultivation and the respective fields of database should be left blank 6 1 3 5 How to enter information on seized quantities of narcotic drugs In this tab you should enter the data contained in the Part IV of the paper based Form C These data is to be provided by all governments whenever narcotic drugs have been seized destroyed used for licit purposes and or taken over by governments for special purposes during the year in question Quantities pending disposal should also be indicated The view of the tab is given below Figure 141 Seizures tab Seizures cis 3 methylFentany cis beta hydroxy 3 m Fenta 3 Methyl thiofentanyl 3 MethylFentany Acetorphine e 0T gt gt User Manual 124 The following data should be provided Field Value Substance Code Code of substance being reported Drug Name Name tag for SubstanceCode Quantity Seized The quantity of seized substance Gross weight should be indicated The quantities
125. es of the period you want to review the actions for 2 Indicate a user whose actions you want to review 3 Indicate type and subtype of event if the EventType and EventSubtype fields are left blank all events will be displayed 4 Indicate name of the NDS object module or separate form which you want to review 5 Press the lt Execute Query gt button on the toolbar or press the lt F12 gt key on keyboard the summary information on the events will be displayed in the details part of the Event Log screen 8 2 Parameters 8 2 1 Form Fields Master The Form Fields Master gives you an opportunity to change the names of the fields in NDS forms It is very useful if one needs to translate the whole system to some local language This Master embraces all field labels throughout the system so it is possible to change field labels in all modules and screens besides the INCB printed reporting forms User Manual 161 The Form Fields Master is started as follows Parameters gt Form Fields Master Figure 176 Form Fields Master F NDS United Nations Office on Drugs and Crime System Security Masters Import Export Licenses EMM Narcotics Precursors Parameters Window Help amp 2 by X Re Form Fields Maintenance B NDS Lanquage Code Field Name Field Help Text Comments ENG FRE M To change a field name do the following 1 Choose the necessary field name in left pane 2 Choose the record
126. etc This functionality may be invoked from the main menu System gt Error Log User Manual 36 Figure 33 Error Log Criteria Error Log Criteria User oT AS v Error Type I Warnings I System I Questions Iw Delete x Cancel The Error Log Criteria screen will be opened Here you should indicate a user whose errors you want to trace and the type or several types of errors to be traced w OK When you have selected the criteria press the OK button to view the information on the errors Figure 34 Error Log Report s Error Log Maintenance Machine Name Error Code Error Type Created On Pie STANISLAY 2043 Ww OoOfOOf0000 00 00 00 HenpaeHnbeHerH Ko seiKa STANISLAY 2000 oofoofo000 00 00 00 O STANISLAV 2000 oofoof0000 00 00 00 O Reason Action BEeaHTe NPaBHAbHbIA Mog Asbika MISMEHEHMA HE coxpaHeHell O MOTIBbIDEpHTe O Aa uTODbI caxpaHr MISMEHEHHA HE caxpaHneHelil O amp oTiBeibepHTe L Aa 4TOObI caxpaHrk 1 STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV STANISLAV 2041 9901 9901 2000 2007 2000 2000 9901 2000 9901 200 2000 2043 2043 2000 e042 e042 Z 0 E E 0 S EO 2 oO 0o zo oo o0 00 0000 00 00 00 o0 00 0000 00 00 00 00 00 0000 00 00 00 00 00 0000 00 00 00 00 00 0000 00 00 00 oo 00 0000 00 00 00 oo 0o0 0000 00 00 00 o0
127. ether with World Health Organization make additions to the Schedules and Tables of 1961 1971 and 1988 Conventions The lists of pure substances are published on INCB web site and may be downloaded by interested parties Import Pure Substance List feature of NDS 6 0 facilitates data import process It may be invoked as follows Masters gt Substances gt Import Pure Substance List e browse the necessary txt file by means of Select file dialog box e select the substances you intend to add to NDS database e click lt Save gt button to save changes or lt Cancel gt to abort the procedure User Manual 44 Figure 41 Import Pure Substance List pom File name Open Files of type Test Files TT Cancel 3 1 8 How to define units of measurement Unit of Measurement Master In practice the Unit of Measurements Master is mainly used for defining new measurement units for substances and preparations as well as for entering alteration of language related information on the UOMs existing in the system Also it provides an opportunity to define new conversion factors in order to make data management more flexible and convenient At the Header section you should enter choose the code of appropriate UOM M Note Before entering new UOM Code make sure there is no same code already existing in the system Field Value Language Code Code of one of the Languages recognized by the system The name which will be
128. evant comments on the trading country As mentioned above the Exports tab is identical to the Imports tab 6 2 2 Form B P Form B P is to be submitted to INCB at least once every three years Assessments should reflect the total medical and scientific requirements for one year INCB will use reported assessments for reference during a three year period unless a modification to previously submitted assessments is received 6 2 2 1 How to create an Annual Assessment and or Modification Psychotropic gt Form B P The fields in the Header section are nearly identical to the ones of Narcotics Form B The only difference is Modifications field which replaces the SupplementNumber fields in Form B However the functions of these fields are the same they indicate whether this form is an original assessment estimate or a modification supplement If no assessments have yet been created for the specific country for specific year then the Modifications field value becomes 0 If not it accepts values from 1 upwards depending on the number of already submitted modifications Figure 144 Form B P Annual Assessments Country Code Country Name Assessment Date Modifications NN NN EXE T T mmn OO Assessments YS Te B Substance Code Substance Name Entered Quantity Schedule EIL aed Ind Wepaoz amobarbital o vf 7 650 000 3 G paon v Apaslm ss 3 600 0
129. f the new Group in the language section by entering the LanguageCode GroupName and if necessary correct SortDescription Under the language section there are three more sections Substances Preparations and Groups ones In each section there is an upper blank row which may be used for express querying of data In our example in the Figure below all variations of CPS are queried Figure 70 Substance section of Group master The Li button shows the substance attributes entered in the Substance Master Figure 71 Substance Attributes pop up OD AMPHETAMINES APHETAMINES ENG xl Concentrates of Puppy Straw H D OPIATES Opiates D CPS Concentrates of Pu Straw o E NENNEN we 22 gt NcO ONC OF POPPY STRAW 50 MORPHINE Schedule Table Indicator Narcotic Psychotropic Precursor Others E E E apap ie a bl ot AMPHETAMINES APHETAMINES OPIATES Opiates Qux ma rm User Manual 66 When you select the necessary Substance do the following In case of single Substance 1 click on the selected Substance 2 hold the mouse button 3 drag move the mouse cursor to the necessary Group in the left pane In case of multiple Substances 1 select a range of Substances click on the first Substance hold the lt shift gt key and click on the last Substance 2 not releasing the lt shift gt key click on the selection and hold the mouse button 3 drag the selection to the ne
130. ficiency To prevent this problem the InActive field was introduced in the system When you check the InActive field specify the date it stopped its activity from and the code of establishment that will take over the activities of the latter InActive Closing Date Mew Establishment Code u IL O J See also Establishment Type Master section 3 6 2 How to copy the Establishment Details In practice sometimes you may have to enter several Establishments that are similar to each other In this case it is better to use the lt CopyDetails gt button of Establishment Master For example a given establishment is registered for Uzbekistan and we need to enter several other establishments registered in the same country and city Figure 76 Copying Establishment Detail Country Code Country Name Street Name City Establishment Code Establishment Name State Zip Code PEANP 584 aut ee Establishment Type Code Establishment Type Name Country Name es ERROA EAN Code InActive HQ Name Communication Details Comments wf e m Irure O p User Manual 70 For this purpose we need to find the proper record in establishment master by means of navigation bar or querying After that press the lt CopyDetails gt button The following dialog box will appear Co py Details Copying Establishment Details From Establishment Master window Current Primary Key New Primary Key i IPEHTIP 584 PEATIP 587 Cancel The
131. for transactions with the substances stated in the authorization as well as the M estimates assessments license quantities import limit and export limit The necessity of such check is stated in the Special Conditions tab of Substance Master for any particular substance Figure 102 Example of Export Authorization Export Authorization Request Export Authorization J Endorsements Additional Establishments Imp Doc Ref Imp Auth Cert Request Number Request Date Approval Date Valid From Valid To 548293NK30 14 Jun 2006 x n 10 BKNKHK 110 2006 L6 JuN 2006 16 JUN 2006 X L6 JUN 2006 g 16 3uN 2007 x Signature Itinerary AzIZOV Substance Code Substance Name Preparation Type Eu Requested Qty Approved Qty Eug 10 MPEN 414 MORPHINE HYDROCHLORIDE 3ML SMG ML jane 20 10 Boxes ee 15 gt bl Fitered Notes Jn gt gt ICT Ec j gt At the moment of crossing the customs border of exporting country the export authorization must be endorsed by the customs body and the endorsement must indicate the actual quantity of exported substances User Manual 91 4 3 Endorsements As mentioned above the authorizations for export or import of controlled substances are endorsed upon exit from an exporting country or upon entry to an importing country The endorsements themselves serve as indication of completion of export or import transaction Technically there are nearly no differences betwe
132. g thebaine as the main alkaloid is referred to as concentrate of poppy straw T Concentrate of poppy straw containing oripavine as the main alkaloid is referred to as concentrate of poppy straw O Each of above mentioned types contains various quantities of anhydrous alkaloids AMA anhydrous morphine alkaloid AOA anhydrous oripavine alkaloid ATA anhydrous thebaine alkaloid ACA anhydrous codeine alkaloid The data on the concentrates and contained alkaloids may be either calculated automatically from the quantities of endorsements of import export transactions or entered manually If the data are calculated by the system i e aggregated then the figures will appear in black Otherwise if the data are entered manually and do not correspond to the system calculations they will appear in red In the Figure below the data are entered manually the field press lt Tab gt key or click other field and the system will display the aggregated value Note If you want to know the results of system s calculations just delete the value and leave instead User Manual 112 Z L L Figure 130 Imports CPS tab Code pe vco20 _y CONC OF POPPY STRAW M GW 50 00 G As We hco21 Conc Of Poppy Straw M AMA NC022 CONC OF POPPY STRAW M z NcO23 CONC OF POPPA amp TRAW IM ATA D0 e e m eje Country Code Country name Quantity Comments pra 0 A 30 00 ul Bw xpemead s 20 00 ul
133. gion Master As other Masters Region Master may be invoked in two ways 1 From the Main Menu Masters gt Demographics gt Region Master 2 By double clicking on any RegionCode or RegionName drop down throughout the system Figure 87 Region Master Region Code ENG v AFRICA AFRICA Qa 4 I 30 eje a User Manual 79 The following fields should be filled in Field Value Header section Unique code for this region It shall not be repeated in the system However if you try to Region Code enter the code which is already assigned to some other region the system will issue a warning message Code of the language for which the current RegionName will be displayed in respective drop downs records reports eee Name that will be displayed in drop downs records reports when the language Region Name corresponding to the LanguageCode is selected by a user Defines the order in which the region name will be displayed in related drop Sort Description downs records reports Comments Any relevant comments and or remarks 3 7 4 2 Indication of the Countries constituting the Region Region Country Relation Master The Master may be started as follows Masters gt Demographics gt Region Country Relation Master Figure 88 Region Country Relation Master Region Code Region Name AFRICA v Country Code Country Name ANGOLA v Relation Code Relation Name GENERATED BY SYSTEM E 4 105 O p
134. he above mentioned kind of poppy straw is planned to be produced and the area where the poppy is to be cultivated If the poppy straw is produced for further manufacture of narcotic drugs then the country should indicate on Form B the estimated quantities of anhydrous alkaloids AMA ACA and or ATA These quantities should be entered in the respective fields of Alkaloid Details section of Other Estimates tab The following fields should be filled Field Value Drug Details Section Drug Code Code of the substance proper type of poppy straw pein Naneta csirespoddho ie Driacsde oi o Quantity 000007 E eh papi dini ta be podio eek te Wines eal Gene UM Uniofmeasuemeninwhchthedrgshalberepoed Comments arianen i en Area Under Cultivation hectares
135. he current CountryName will be displayed Country Name Name of the country as displayed according to LanguageCode Se Defines the order in which the country name will be displayed in CountryCode and Sort Description CountryName drop downs Comments Any relevant remarks concerning the country name 3 7 1 2 Indication of Conventions the Country is a member to Convention tab This tab is used in order to indicate whether the country is a member to certain drug control Conventions i e whether it shall or shall not observe certain control regulations as well as for certain statistical purposes User Manual 75 Figure 83 Convention tab System Generated System Generated wD MEET rn The following data should be indicated Field Value Header section Convention Code Code of the Convention the country is a member to Details section Code of the language for which the current ConventionName will be displayed in Language Code country related records reports Convention Name Name of the Convention corresponding to the ConventionCode Sort Description Defines the order in which the ConventionName will be displayed in drop downs Comments Any relevant remarks concerning the Convention 3 7 1 3 Indication of annual statistics for the Country Annual tab In this tab you are supposed to indicate the data required by INCB to be reported annually on Form B See also Narcotics Form B Figure 84 Annu
136. i v 20 00 MILILITERS T j2003 P 1314 ng NORMEPERIDINE LOO GIL E PL ae AMPOLLE S ng 6 OO MOLILITERS n Note The red arrow directed downwards shows that the data are sorted in ascending order i On the contrary the arrow directed upwards shows that the data are sorted in descending order One more click on the field s header changes the sorting order Thus if you click one more time on the SubstanceName header the data will look as follows Figure 18 Data sorted by SubstanceName in descending order ENENNET TT ance C m Substance Marne Preparation pm y Bo ol urns B Requested iy 203 P 1314 cw NORMEPDRIDIME 100 p H 1 HL ye AMPULES L 6 00 MOLILITERS r7 003 P 1475 s MORPEONE S BETA D GLUCURONIDE D3 100 pGJML 1 MI AMPOLLE S i 20 00 MILILITERS a z003 P L30 w METHAQUALONE L MG ML L ML wo AMPOLLEIS l v TOETER ITS o PINE B 018 v METHAHPHETAMIHE D5 100 pa FL LAL wo AMPCUAECS l v 5 00 MELILITERS o z003 P 137 y MORA L MGIML HL wv AMPOULE S s 10 00 FAILITERS io To quit the sorting mode make a mouse click right on the red arrow It will disappear but the data will stay sorted Figure 19 Data after sorting mode is off ge ar i Code i Subbstance Hi Preparation Type hoof units Requested Ot ET P S O MILILITERS SUF 1314 x HORMEPERIDINE 100 psl 1 ML e AMPOULE S i w 0 DOC 1476 x MORPHIME 3 EETA D GLUCURONTDE DG LOO paf 1 ML v AMPOLLE S H 20 0 MILILITER S a 2003 119000 C
137. icate data on stopped shipments Parties are obliged under article 12 paragraph 9 c to notify as soon as possible the competent authorities and services of the Parties concerned if there is reason to believe that the import export or transit of a substance in Table or Table Il is destined for the illicit manufacture of narcotic drugs or psychotropic substances Information on shipments that have been stopped because of sufficient evidence that the substance may be diverted into illicit channels is essential to overview trafficking trends and to prevent attempts to divert the substances from other sources Countries are therefore requested to provide detailed information on stopped shipments of substances scheduled in Tables and II and of non scheduled substances For these purposes the Stopped Shipments tab is envisaged in NDS 6 0 Figure 151 Stopped Shipments tab Remarks Seizures Licit Uses and Trade 1icit Manufacture Methods of Diversion Substance Code Substance Name Seized Quantity Schedule Comments Indicator p cA002 v Acetone 10 000 00 L 2 ep e sr gt Transit Country Code Country Name Destination Country Country Name of Seizures Code Circumstances l Informed Countries Results wD i aa gt The tab consists of two sections Substance shipment details section upper and Transit and seizure details section lower User Manual 138 You may indicate the following data F
138. ication used with competent authorities It may be invoked in two ways 1 from the main menu Masters gt Competent Authority gt C A Communication Master 2 by double clicking the CommunicationCode or CommunicationName drop downs in Competent Authority Master window User Manual 58 Figure 60 CA Communication Master Communication Code KR mer O O ENG PHONE PHONE RUS TENE OH TENE OH OD lt j I 372 vj s Here you should enter the following data Field Description CommunicationCode Unique code that will represent this way of communication in the system LanguageCode Code of a language in which the communication name will be displayed CommunicationName Name for this way of communication with competent authority MEM The contents of this field defines the place of CommunicationName in the SortDescription CommunicationCode and CommunicationName drop downs of Competent Authority Comments Necessary comments concerning communication name 3 3 3 C A Function Master The C A Function Master is used to indicate the functions of competent authorities It may be invoked in two ways 1 from the main menu Masters gt Competent Authority gt C A Function Master 2 by double clicking the FunctionCode or FunctionName drop downs in Competent Authority Master window User Manual 59 Figure 61 CA Function Master Function Code K Ki Oo S C s z Code ene C
139. icit manufacture GO eee OG 0 eee ee Number of Table the substance is included into Although the Table term is usually Schedule applicable to precursors the word schedule is used throughout NDS as the essence of The checkbox showing if the entered information should be treated by INCB confidentially checked or not unchecked In the Country breakdown lower part OO OOOO Country of Origin Code of the country from which the reported substance has been brought in Country Name Name tag for Country of Origin of Seizures Number of seizures which took place during the year in question filled in automatically Quantity Seized Quantities of seized substances illegally brought in from particular country Comments Any relevant comments on the origin country The checkbox showing if the entered information should be treated by INCB Confidential confidentially checked or not unchecked After you have finished entering the data save the record User Manual 134 6 3 2 How to indicate seizures of substances not included in tables or Il identified as having been used in illicit manufacture For this purpose use the Illicit
140. ided into three logical parts e Inspection Details Section upper e Substance Details Section middle e CPS Details Section lower M J Note The lower section is used only when the substance in question is a CPS User Manual 143 Please pay attention to the following fields Field Value Declared Quantity The quantity declared by the stockowner as held in stocks The quantity of the controlled substance or preparation which was actually considered Inspected Quantity by the Inspector s In fact the inspection may be carried out on a sample rather than on The actual quantity of controlled substance preparation revealed in Actual Quantity InspectedQuantity figures indicated in the Inspection Results tab anyhow affects the totals in the other tabs of Q Note Although the results of inspections are important for competent authorities neither of EMM or in the report forms Figure 155 Inspection Results tab Opening Stocks az eEA uiu Inspection Results 777217 54 7 15 2 5 18 E81 Blas E 18 12 07 2006 John B Dow dp 1o n Subst Prep Code Subst Prep Name Declared Inspected Actual Quantity Quantity Quantity i NPEN 414 v MORPHINE HYDROCHLORIDE 3ML 5 fio 10 00 10 00 9 00 BOX SDa aa 7 1 3 How to indicate the information concerning the Government s Special Stocks Due to provisions of 1961 Convention on Narcotic Drugs and 1972 Convention on Psychotropi
141. ield Value In the Substance details upper section QQ E The quantity of the substance pure anhydrous content that was seized during the reporting year GG ee Number of Table the substance is included into Although the Table term is usually Schedule Indicator applicable to precursors the word schedule is used throughout NDS as the essence of ee eee In the transit seizure details lower section Se Code of the country through the territory of which the seized substance was brought into the territory of reporting country if different from reporting country Destination Country Code of the country where the seized substance was to be delivered to if different from Code reporting country of Seizures Number of seizures which took place during the year in question place where the seizure was conducted e g in illicit laboratories commercial warehouses or customs area etc OO eee o ee ee ee ee ee ee ee ee eee ee ee eee ee ee eee ee ee ee eee ee ee ee ee eee eee eee eee eee eee eee esses ese seee Se results of further investigations whether the shipments was confiscated nE US destroyed released taken over by government for further licit use etc 6 3 5 How to indicate the information on licit trade in and use of precursors To indicate the information furnished to INCB on pages 11 20 of paper based Form D use the Licit Uses and Trade tab see the Figure below
142. import certificate requests unless you first delete the import certificate itself 4 2 Export Transaction Documents 4 2 1 Export Authorization Request To create an export authorization request we should first create an export document Import Export gt Import Export Document amp Choose Export option in Imp Exp Flag drop down The window is nearly the same as in case of import document but the fields related to the exporting country are located on the left side and the ones related to the importing country on the right side Figure 100 Export Document Header Imp Exp Flag Reference pect ok ce 007 Export as XML PEN Export Details M Import Details Exp Country Code Exp Country Name Imp Country Code Imp Country Name uz 7 B Uzbekist TA gf Republic of Tadjikistan Ministry oF Health Exp CA Code EN Exp CA Department Name Imp CA Code 2E Imp CA Department Name Exp Establishment Exp Establishment Name Imp Establishment ar Esta See Hane Aull s bri Here Fill in the header fields related to exporting and importing countries establishments and competent authorities as we have described in mport Authorization Request section of this Manual and then go to the Export Authorization Request tab Note Please pay attention to correct indication of the RequestNumber as this number will be Mu later used to issue export authorizations Depending upon settings in User Preferences this field may be
143. in the controlled substances 5 1 3 Linking substances to correspondent types of activity Sometimes one license allows an establishment to carry out several activities with different substances but simultaneously some activities are allowed only with particular substances Q Note If a license is given for a pure substance it automatically extends to all its salts On the contrary license issued for a particular salt is valid for this salt only Figure 116 sion Substance Details tab Substance Details cenc Site Code Site Name License Type License Type Name UDF Code UDF NAME No Of Code Units 00010 Focraapcreen LleHTp SKCNEpTH3 w LsaLEs pas v nPEn 414 v MORPHINE HYDROCHLORIDE 3ML SMG ML 10 00010 m Focvaapcreen LleHTp 3KCNEpTH3I vw MANUF Manufacture neen 414 MORPHINE HYDROCHLORIDE 3ML SMG ML EM To link a substance or a preparation to the necessary LicenseType e indicate the site if the license is given for HQ of single establishment being licensed in the SiteCode SiteName fields e indicate the type of license granted to this particular site LicenseType field User Manual 102 As you may have already noticed the icons representing substances and preparations are different in order to facilitate their visual recognition 5 1 4 Attaching clearance information Additional information necessary to be provided to the competent authority for obtaining a license may be recorded in the Cleara
144. in the necessary language in the right pane or add a record in a new language 3 Change the field name or enter a new one in FieldName field 4 Change or enter the text of context help in FieldHelpText field This text will be displayed in the context help mode when a mouse cursors hovers over the field name 5 Change or enter necessary comments in Comments field This field is not mandatory 6 Save the record From now on the new name of the field will be displayed in the respective modules of NDS when the respective language is selected by a user User Manual 162 8 2 2 Error Master The Error Master provides an opportunity to edit the error and information messages displayed by the system to users The Error Master is invoked as follows Parameters gt Error Master 9 Figure 177 Error Master Error Code 998 Boo oo Language Code Error Type ENG Reason this Substance From this License Type Action OK to Delete this Record Comments In Qr iz gt a All error warning messages are bound to the error codes generated by the system in case of some events When the pre set event occurs the system checks which language the user has selected and displays the error warning message in that language To modify the existing error warning message or to enter a message in a new language for existing error code you should enter or modify the following fields Field Value Error C
145. ineu Substance Name Quantity Obtained si a ie i oo ANNE we lt i oro vi In the upper part you are supposed to indicate the quantity of substance USED for manufacture of other psychotropic substances whilst in the lower part the OBTAINED substances are to be indicated M Note For each record in the upper section there may be two or more lines in the lower section of the tab as one substance may be used for manufacture of two or more drugs User Manual 132 6 3 Form D Precursors Annual Statistics According to art 12 of paragraph 12 of the 1988 Convention against Illicit Traffic in Narcotic Drugs and Psychotropic Substances the parties of the Convention shall furnish to INCB in the form and manner provided for by it and on the forms made available by it the information on e he amounts seized of substances in Table and Table Il and when known their origin e Any substance not included in Table or Table Il which is identified as having been used in illicit manufacture of narcotic drugs or psychotropic substances and which is deemed by the Party to be sufficiently significant to be brought to attention of the Board e Methods of diversion and illicit manufacture The electronic Form D is built upon the paper based Form D which is being presented by the countries to INCB annually Precursors gt Form D WS Mu Note Please pay attention to the proper indication of country year combination which should be
146. iolation with an error message Upon saving NDS also may check if the license for the operations with controlled substance is available If not the system will inform you about lack of license with proper error message The necessity for checking of estimates assessments licenses license quantities as well as of export and import limits is defined for any particular substance in the Special Conditions tab of the Substance Master Figure 95 Substance related record in Substance Master Pure Substai Pure Substance Name Variation Code Variation Name UDF Code Methyl ethyl ketone I i PURE z Doses Limit Of Tolerance Schedule Ind Conversion Factor Alkaloid Name 100 00 f HS Code CAS Code EAN Code UOM ZILLINNNNNE ZNNCD BEEN Rupee orm fni TTE EE Special Conditions adua Check Estimates Check licences Check Import Limit Check Export Limit Track Licence Quantity iv LI User Manual 87 Once the Import authorization is issued it may be sent to the competent authority of exporting country in printed version or digitally so that the respective export authorization will be issued The last stage of importing cycle is the endorsement which is to be made on the import authorization when it actually arrives together with the controlled substances However sometimes the importing establishment may need to import the substances part by part in several shipments In this case it should also request for and obt
147. ions Field Value Substance Section GQ E OOO eee Total quantity of the substance imported to exported from the country during the quarter in question ee eee Country Breakdown OT o Country Code Code of the country which is a counterpart on particular transaction Country Name Name tag for CountryCode 000000 Quantity Entered Quantity of controlled substance entered manually 0000 Jed eaen Tol 000000000 Grand total of quantities by countries Calculated automatically need not be entered Mu J Note Imports and Exports tabs are identical in terms of fields and rules of data entering 6 1 1 2 Entering data on imports and exports of Concentrate of Poppy Straw CPS The Imports CPS and Exports CPS tabs were introduced into NDS specially to improve the accounting for and reporting of transactions with concentrates of poppy straw and the alkaloids contained in them The poppy straw and its concentrates require special attention due to their natural origin which means that the proportions of alkaloids may vary considerably from shipment to shipment Therefore the gross weight of CPS and approximate net weight of imported exported alkaloids should be indicated and reported to INCB In practice there are three types of poppy straw concentrates Concentrate of poppy straw containing morphine as the main alkaloid is referred to as concentrate of poppy straw M Concentrate of poppy straw containin
148. irada dipped MMEEEME Use the same procedure to enter a Modification Note When entering the modified quantity please bear in mind that not the additional quantities but the revised total assessments should be indicated The new total assessments Q will be substituted for the quantities indicated in previous submissions of form B P and any subsequent modifications to those submissions So if in initial assessment you have indicated 500 grams of some psychotropic substance and then the necessity for it increased by 150 grams in modification you should indicate all 650 grams 6 2 3 Psychotropic Form P The Annual Statistical Report on Substances indicated in Schedules I Il Ill and IV of the1971 Convention on psychotropic substances the so called Form P is provided to INCB once a year not later than June 30 of the year following the year in question The paper based Form P consists of the following parts Part l Statistical data on the manufacture utilization stocks imports and exports of substances in Schedules I Il Ill and IV of the 1971 Convention and their salts Part Il Trade details statistical data on imports and exports of substances in Schedules l Il II and IV of the 1971 Convention Part III Statistical data on the use of substances in Schedules l Il Ill and IV of the 1971 Convention for the manufacture of other psychotropic substances Note The difference between the import export section of Par
149. ity The internationally controlled narcotic drugs psychotropic substances and precursors are provided in the appropriate Schedules and Tables to Yellow Green and Red Lists respectively However local competent authorities may assign additional substances to be controlled within their country or territory INCB assigns the codes of the controlled substances their variations and salts These codes are given in the Yellow Green and Red Lists together with alternative codes such as e EAN International code a 13 digit code also known as bar code e HS Harmonized System code a uniform code of Customs Cooperation Council e CAS Chemical Abstracts Services code The Substance Master also enables the user to read the substance attributes in various languages and also set special conditions that designate how NDS will apply control measures on that particular substance Substance Master consists of the header section three tabs and three underlying sub masters e Pure Substance master e Variation master and e Unit of Measurement master 3 1 1 How to enter a new substance and define alter its attributes To enter a new substance into the system or edit the substance information you should do the following Masters gt Substances gt Substance Master Figure 36 Substance Master with Languages tab Pure Substai Pure Substance Name Variation Code Variation Name UDF Code Doses Limit Of Tolerance Schedule Ind Conversion Facto
150. ity of the establishment corresponding to the LanguageCode It will be used City throughout the system when the respective Language is selected by a user for NDS State Name of state or province corresponding to the LanguageCode It will be used throughout the system when the respective language is selected by a user for NDS Alternative name of the establishment country corresponding to the LanguageCode It Country Name will be used throughout the system when the respective language is selected by a user SNC fOr NDS RR PRENNE Comment Details of communication phone telex numbers e mail etc You may use the Communication Details tab to enter the data on the communications with the establishment User Manual 69 Figure 75 Communication Details tab Communication Details Communication Code Comments kv v Estabishment City En x Tashkent 700097 STREET fEstablishment Street Eng 46 Drujby narodov str EST NAME Establishment Name Eng The Republican sanitary epydemiological control Centre State ew r3 n Field Value Communication Code Code of particular way of communication Communication Name Way of communication phone fax telex etc Comment Details of communication phone telex numbers e mail etc If the Establishment stops its activity NEVER DELETE IT Note Deletion of an establishment that was involved in one or several transactions may cause Mu serious data insuf
151. l 49 The number of preparation units in a package UOM is indicated in the Package Size tab see details below in Package Size Tab section 3 2 2 How to specify the Type of Preparation Preparation Type Master The Preparation Type Master is used to indicate new types of Preparations as well as to enter additional language information for the existing ones You can start the Master in using one of the following ways 1 From the Main Menu Masters gt Substances gt Preparation Type Master P9 2 By double clicking on the PreparationTypeCode or PreparationTypeName drop down tab in the Preparation Master To assign a new Preparation Type the following fields should be filled in Field Value Header Section 6 symbol code which will be used to represent this preparation type throughout the Preparation Type Code system Details Section Language Code Code of the Language for which the PreparationTypeName will be displayed ee Defines the order in which the preparation type code and preparation type name will be Sort Description displayed in respective drop downs Comments Any relevant comments and or remarks on the preparation type Figure 47 Preparation Type Master Preparation Type Code KRKINE DO D anny Tibi amn v FRE PREP FRE SORT FRE COMM lamp AMPULES ENG COMM User Manual 50 3 2 3 How to indicate the name of the preparation Here you should indicate the name of the preparatio
152. lates Form A P consists of a header section and 3 tabs e Remarks e Import e Export The Import and Export tabs show the aggregated information i e the information on the whole country or territory and also provide the breakdown of imported or exported quantities on counterpart countries The Form A P uses the data from Import Export module of NDS automatically calculating the quantities and capturing the countries the transactions were carried out with However you may as well enter the data on transactions manually To create a new quarterly report do the following Psychotropic gt Form A P N User Manual 125 Figure 142 Form A P Country Code Country Name Quarter In the Header section you should fill in the following fields Field Value Country Code The code of the country for this the statistics is being provided einem EM The tag showing the name for the CountryCode pu BEEN The year for which the information is being provided Gute MEM Quarter for which the information is being provided The Form A P opens with the Remarks tab being active In this tab you may indicate any information that you think will be useful for consideration by INCB 6 2 1 1 How to enter the import and export data on psychotropic substances The data on quantities of psychotropic substances imported to and exported from the country are indicated in Imports and Exports tabs respectively Us
153. le of Excel r eT i Shows the AuditTrail data tor the current record lt Close gt Closes the current Screen User Manual 18 In some modules there are also additional toolbar buttons which will be reviewed separately in the respective sections 2 5 Navigation Navigation between screens can be done using the menu options Navigation between records can be done by clicking on the respective buttons that are attached to that particular screen as shown below Figure 6 Navigation bar 0D El 3727 feie Cro to Previous record Insert E to Eo Picari Ho of ecord Current Record Go to Delete Hexzt Current Record Recordi Co to Last Total Humber Record Oft Records 2 6 Types of Fields Fields are primary elements of any database They are used for the actual entering and storage of information In NDS the following types of fields are used Editable Text Number field Comment field Date field Check box Drop down box Attached text field All these types are described below one by one 2 6 1 Editable Text Number field This is the most simple field type All you have to do is enter the necessary value i e figure or text Figure 7 Example of Editable Text Number fields 5 000 00 You may make queries over fields of this type See Queries section for more details User Manual 19 2 6 2 Comment field The Comment fields are intended for entering large quantities of text
154. le the substance is included into Although the Table term is usually Seized Quantity Schedule Indicator applicable to precursors the word schedule is used throughout NDS as the essence of LLL Tables and Schedules is naturally the same UOM Unit of measurement in which the substance should be reported on Form D Comments Comments regarding the quantities of seized substances In the country breakdown middle pat Country of Origin Code of the country from which the reported substance has been brought in Country Name Name tag for Country of Origin ee of Seizures Number of seizures which took place during the year in question User Manual 135 Field Value Quantity Seized Quantities of seized substances illegally brought in from particular country Comments Comments concerning seizures by this country In the transit destination countries lower section a a Code of the country through the territory of which the seized substance was brought Transit Country Code into the territory of reporting country If different from reporting country Destination Country Code of the country where the seized substance was to be delivered to If different from Code reporting country of Seizures Number of seizures which took place during the year in question Circumstances circumstances of seizure place where the seizure was conducted e g in illicit laboratories commercial warehouses Orc customs ar
155. license suspension form in NDS License gt License Suspension Upon opening this form enter the number of license to be suspended into the LicenseNumber field or query the license data You may also choose the necessary license number from the LicenseNumber drop down box though it is not very convenient if the system already contains data on lots of licenses When the LicenseNumber is entered by either of two above mentioned ways the other data on this license will be browsed automatically Figure 121 License Suspension Form License Number Suspension Date Previous License Number Signature i220 s Establishment Code Establishment Name Contact Person E mail Address poo Dori Darmon shareholding company Approval Date Yalid From alid To Phone Sumber 28 JLIN 2006 28 JUN 2006 28 JLIN 2007 Suspension Reason Remarks iolation oF narcatics related legislation User Manual 105 As in case with the license revoke all you need to do is enter the necessary SuspensionDate and Suspension Reason Q Note SuspensionReason field is mandatory The NDS will not suspend a License until the reason has been specified When the license is suspended the system will warn you about it any time the establishment will be involved in import export transactions with controlled substances specified in the license 5 5 How to Re activate a Suspended License For re activation of suspended licenses there is a special form in Li
156. llowing 1 Scan the real signature 2 Save it in Windows Bitmap bmp format 3 Add new record with the Signature Master 4 Enter UserID two letter code in most cases the person s initials 5 Enter the person s Name and or Position Title into UserName field 6 7 EDO T Press the button and browse the bmp file containing the person s signature Save the record M Note Steps 1 2 and 6 are optional In fact the scanned images of signatures are not widely used due to sensitivity of the issue 3 7 6 Indication of Customs Points of the Country Customs Point Master The Customs Point Master is used to manage data displayed in PointOfEntry and PointOfExit drop downs of the Import Export module The Master may be invoked in two possible ways 1 From the Main Menu Masters gt Demographics gt Customs Point Master 2 By double clicking on the PointOfExit or PointOfEntry drop downs Figure 90 Customs Point Master Switzerland rrr Mere E C a RUS sponopT MKEHEBbl ENG Geneva Airport Qa 37 rji a User Manual 82 The following data should be indicated Field Value Header section9 Code of the country to which the customs point belongs as well as the name corresponding to the code NN
157. m Masters Security Management Import Export Licenses EMM Narcotics Psychotropics Precursors Parameters INDSEZ Window Help aw Transaction amp Countries Establishment Transaction Type Country X v Establishment m Y Trading Country Y v Trading Establish Zj IMP 4499665 AJS 8 2004 4031FRANCE CEPHALON UNITED iib OF CEPHALON INC 01 09 2004 amp CTIG 1600yuG COMPRIM AY DISPOSITIF PR Reference pagent Country Establishment Trading Trading Establish Request Subst Prep Request UOM E Number Date Quantity L NOT SPECIFIED IMP 4499664 AJS 8 2004 403 FRANCE CEPHALON UNITED STATES OF CEPHALON INC 01 09 2004 ACTIG 12001 G COMPRIM 7 000 00 NOT AMERICA AWV DISPOSITIF PR SPECIFIED IMP A499663 AlS 9 2004 403 FRANCE CEPHALON UNITED STATES OF CEPHALON INC 01 09 2004 ACTIQ 800UG COMPRIM A 12 500 00 NOT AMERICA DISPOSITIF PR APPLICATION SPECIFIED IMP 439652 AJS 8 2004 403 FRANCE CEPHALON UNITED STATES OF CEPHALON INC 01 09 2004 ACTIG 600G COMPRIM AY 1 500 00 NOT AMERICA DISPOSITIF PR APPLICATION SPECIFIED IMP 4499661 AlS 9 2004 403 FRANCE CEPHALON UNITED STATES OF CEPHALON INC 01 09 2004 ACTIG 4001G COMPRIM AY 15 000 00 NOT AMERICA DISPOSITIF PR APPLICATION SPECIFIED IMP 44938660 AJS 8 2004 403 FRANCE CEPHALON UNITED STATES OF CEPHALON INC 01 09 2004 ACTIG 2001 G COMPRIM A 25 000 00 NOT AMERICA DISPOSITIF PR APPLICATION SPECIFIED EXP 4499
158. may view the information export it to Excel or delete from the database If you want to clear the list completely use the Delete All button 7 User Manual 37 2 15 Substance Preparation Calculator This useful window will help the users to calculate on the fly how will be affected the quantities for the base substances contained This special window will pop up after pressing Ctrl F7 on any window Then after selecting any substance or preparation and entering its quantity you should press the button Calculate in order to see the list of base quantities equivalences Imp Exp Flag Reference REF 9999 2005 Import Details Export Details Imp Country Code Imp Country Name Exp Country Code Exp Country Name Imp CA Code Imp CA Department Name Exp CA Code Exp CA Department Name Imp Establishment Imp Establishment Name Exp Establishment Exp Establishment Name Eea 16529716529 f gt Import Authorization Request 57 73 1 5 e Import Certificate Request Import Certificate Endorsements Additional Establishments Request Date Type of Permit MP 242 20fi5 Rims S 3INGI F PFRMIT Valid For one shipment only 2 d substance Preparation Calculator v Bi pstance Prepara Substance Preparation Name No of units UOM Quantity z BROMOCOD N 10 MG 30 package s 7 1 500 00 v ation Type No of units Requested Qty UOM NJ Substance
159. me aa aa a aa aa aa User Manual 43 3 1 6 How to specify a Variation Variation Master The Variation Master similar to Pure Substance Master is used when it is necessary to enter new Variation Code or add change the language information on particular VariationCode It may be opened either by double clicking on the VariationCode field of Substance Master or from the Masters menu Masters gt Substances gt Variation Master Figure 40 Variation Master form Yariation Code ELT b ENG Citrate 3 mol of drug Citrate 3 mol oF drug Rus Llwrpar 3 mol of drug LiMTpar 3 mol of drug 5PA Citrato Base de 3 moles Citrato Base de 3 moles In the Header section you should indicate a code of new variation Note Before entering new VariationCode make sure the code you are about to use does not exist in the system In the Details section of this form you may enter the name of the Variation in any language you wish to use Field Value Language Code Code of one of the Languages recognized by the system The name which will be displayed on the screen or in printed forms every time the respective Language is set ee The content of this field defines the place of the substance in the VariationCode drop down in the Substance Master form Comments Optional comments concerning the VariationName 3 1 7 How to import pure substance list Import Pure Substance List Sometime INCB tog
160. mple all transactions made by an establishment during the previous year In this case it is more convenient for a user not to scroll through all records but to use queries which are a simple and quick search instrument First you should create the query e Click on the lt EnterQuery gt tool button e Or Press lt F11 gt e Or Select the Enter Query option from the System menu e Or choose the Enter Query option from the menu displayed when the right mouse button is clicked After the query is created the screen you are working with is set to Query mode which will be shown in the lower right corner M Note When in Query mode you will not be able to edit data or add new records In the table below you will find some rules of query making so that you will be able to work more efficiently and effectively Once the criteria are entered you should execute the query To execute the query e Click on the ExecuteQuery tool button Y e OrPress lt F12 gt e Or Select the Execute Query option from the System menu e Or Choose the Execute Query option from the menu displayed when the right side mouse button is clicked After the above message the application goes into the Add mode However there are certain limitations to the Query model of this system Thus you cannot search on multi line comments in this system and if you try no results will be obtained 2 10 Data Sorting Sometimes in multiple
161. mporting country When the controlled substance s actually cross the border of the importing country the customs body makes its endorsement on the export 8 authorization stating the actual quantity of the User Manual 10 This is the process that the Conventions of 1961 1971 and 1988 require the governments to implement The National Drug Control System provides the automation of all the processes listed above In addition it gives the customs bodies and competent authorities of both exporting and importing countries almost instant access to the data on the substances being imported exported With NDS it is very easy to trace the quantities that are already imported and the quantities that are authorized for import export but are not actually imported exported yet Getting all necessary data takes no longer than a mouse click 1 2 Transactions on national domestic level Another module of NDS the EMM Establishment Management Module is responsible for management of data on controlled substances at the national level i e accounting for manufacture and distribution of controlled substances This module enables users to enter view and manage the data in the context of establishments i e entities or individuals licensed or otherwise legally empowered to deal with controlled substances The establishments are acting on the basis of licenses issued by competent authorities To make the license management easier and m
162. n in any desired languages Figure 48 Language tab Language Contents Package Size Additional Comments epee uud Rus Rus v Mopdwsarmapoxnopua 3wy Swren 00 rHApoxnopHA 3 Mn Smrjmn MopdWHarWapoxnopua 3wn Swr an 0 rHApoxnopHA 3 mn Surin ENG Morphine Hydrochloride 3ml 5mag ml Morphine Hydrochloride 3ml Sma ml D if 122 gt pil Fitered The indicated PreparationName should include its name on the package international unregistered name and if possible the content of controlled drug in one unit regarded by the system for calculation of quantity of the controlled substance So make sure Q Note Whatever quantity is indicated in the PreparationName field it will not be anyhow you have filled in all necessary fields in Contents tab as well 3 2 4 How to indicate the substances the preparation contains The Contents tab is designed for indication of substances contained in the preparation as well as for calculation of pure anhydrous content of the controlled substances First enter the necessary SubstanceCode see the drop down boxes section for details Please note that you should indicate the code for the substance that is actually contained in the preparation Thus if the preparation contains Codeine Hydrochloride you should indicate the Codeine Hydrochloride not pure Codeine Upon entering the ConversionFactor SubstanceName and UOMDescription fields will be filled in automatically
163. nce Information pop up window which is invoked by pressing a lt Clearance Information gt button Figure 117 Clearance Information pop up window Es Clearance Information m Document Information Word Document Scanned document Additional Information Internal Measures Police Certificate T7 3 Proposed Security The information may be attached in form of MS Word documents or in form of scanned paper documents in bmp format Note Double click respective WordDocument or ScannedDocument field to browse a proper file from your hard disk 5 2 How to Approve a License Request The mechanism of approving a license request is similar to that of authorizing an import authorization request License gt Open Requests Figure 118 Open Requests window Establishment Code Establishment Name From To po coco fan acco Ts Request Number Request Date bun Valid To Country Name CA Department Name Establishment Name NARCI 08 06 2006 08 06 2006 08 06 2007 Uzbekistan Ministry of Health l ocyAapcrBeH LIEHTp 3KCNEpTH3bl H Note If there are a substantial number of open requests you may use the RequestDateFrom M and RequestDateTo fields to swiftly make a query on the known dates of the necessary Request You may also use a sorting functionality to sort the request records in either ascending or descending order see Sorting section of Chapter 2 General Functionality User Manual 103 Double click on th
164. niC ode m Code of the name that will be used together with CA Code to represent this CA Count Eod NN Code of country to which the CA relates Phone Area International phone code of the country User Manual 55 Field Description Contact Person Name of a contact person Designation Communication k MEM Address Full postal address of the competent authority List of Forms to be Mailed List of forms to be mailed by this CA ee a 3 3 1 1 How to indicate the ways of communication to Competent Authority The Communication tab is used to enter data on means of communication with this CA Figure 56 Communication tab Communication Function Administrative Signatory Communication Code Communication Name S Bia aif aes gt bi Fittered Language Code Communication Details ENG v secretariat incb org p if 101 gt pil Fitered To enter the necessary means of communication do the following e add new record in the upper part of the tab e Select the code of communication from the drop down If there is no necessary code double click the CommunicationCode drop down and use the C A Communication Master see C A Communication Master sub section e select the LanguageCode e enter CommunicationDetails and Comments if necessary Thus if a CA has such an E mail address info ca_name org then the following data should be entered CommunicationCode 4 CommunicationName E MAIL Lang
165. ntries Figure 13 Multiple Record Entry Screen gt T iz Er T E e 3 a 4 I e T a E a a ps gt a J m 4 D m a a Es m 3 m 1 a zb r a F a E ES E E 3 3 5 8 2 S 4 a al al J 2 ma a EE Eog f T oo p 7 S m TE EE 2 m m 4p O S sa ps4 pa psa pla psa 3 al 4 4 onl al ul a r a fl al gt 3 e 3 3 2 3 5 a ala 2 3 7 9 1d El El E H E J 3 JEEE AAJA JA Aaa l 2 7 3 Header Detail Screen This type of screen is used in cases where for a header information there are multiple details existing The snapshot shown below is an example of a Header Detail screen Please note the presence of two record navigators in any header detail screen They are provided because each header record may contain several detail records For instance in the Establishment Master you may enter several contacts for one establishment The section where the last mouse click has been done is considered by the system as current or active one All the operations which will be described later are executed only on the active sections and records A very common example of detail records is the language records As we have mentioned before NDS may be adjusted to almost any language all the users have to do is enter the proper language record where needed see the example in Preparations section of Chapter 3 of this manual User Manual 23
166. nual 94 Figure 106 Additional Establishments tab Import Authorization Request Import Authorization Import Certificate Request Import Certificate Endorsements Additional Establishments Ultimate Consignee Code Name Broker Country Code Name Broker Code Name Carrier Country Code Name Carrier Code Name 8 sME S 5 Manufacture Country Code Name Manufacture Code Name 1 Other Manufacture Country Code Name 1 Other Manufacture Code Name wr 2 Other Manufacture Country Code Name 2 Other Manufacture Code Name v2 Ee Additional Remarks 4 5 Import Export Reports The Report Queries in Import Export module are intended for rapid querying and processing of data You may select data easily by means of various criteria which embrace all aspects of work with import and export transactions The logic of work with all reports is the same the only thing you should do is select necessary criteria and press the Y ExecuteQuery button The system will browse the corresponding records and display them in table view in the lower part of the screen 4 5 1 Import Export Report The most comprehensive form is Import Export Report Import Export gt Import Export Report P9 Figure 107 Import Export Report Transaction amp Countries Establishment Transaction Type Trading Country Establishment E ENNC ENNNNNNNNSNSNSNSSSEEEER lx d o d nport authorization E e e e Ahi s P
167. nufactured Raw Material tab Lu EL Nco19 v e OF POPPY STRAW 50 THEBA 0 00 Ncoz1 NC021 50 00 pe Nco20 conc OF POPPY STRAW M GW 2 000 00 Nco22 NCO022 We hcozs NC023 We umaos Morphine 20 00 G n 5 5 5J n eap 109 o In the upper part you are supposed to indicate the quantity of substance USED for manufacture of other narcotic drugs whilst in the lower part the OBTAINED substances are to be indicated M Note For each record in the upper section there may be two or more lines in the lower section of the tab as one drug may be used for manufacture of two or more drugs User Manual 122 6 1 3 3 How to enter data on utilization of opiates for manufacture of other substances On the Manufactured Opiates tab you should enter the data contained on the second page of the Part Il page 7 of paper based Form C Below you will see the general view of this tab Figure 139 Manufactured Opiates tab Substance Name Apomorphine Benzethidine Benzylmorphine Betacetylmethadol Betameprodine 34 150 BELLIS Substance Name Quantity Obtained The usage logic is very simple and easily understandable 1 Inthe upper part you should select the code of a drug used in manufacture process and indicate its quantity 2 In the lower part you should select code of drug which is the outcome of the manufacture process and once again indi
168. obtained as a result of illicit manufacture extent of illicit manufacture etc upper e Transit and destination countries details section lower You should fill in the following fields if appropriate Field Value In the Substance details upper section eee ee ee ee ee ee ee ee ee ee ee ee ee ee eee ee ee eee ee ee ee ee ee ee ee ee ee ee ee eee ee ee eee ee ee ee ee ee ee ee ee ee eee eee eee ee eee eee eee eee eee eee ee eeeeese OO eee eee The quantity of the substance pure anhydrous content that was seized during the reporting year eee eee Number of Table the substance is included into Although the Table term is usually applicable to precursors the word schedule is used throughout NDS as the essence of In the transit destination countries lower section ee EEE eee Code of the country through the territory of which the seized substance was brought into the territory of reporting country if different from reporting country Code of the country where the seized substance was to be delivered to if different from Code reporting country OO M
169. ode ENG v SIGNATORY FUNCTION FOR FORM 4 SIGNATORY FUNCTION FOR FORM A RUS NOANMCHIBAET DOPMY A NOANMCHIBAET DOPMY A gt Oo I2 pm a You will need to enter the following data Field Description FunctionCode Unique code that will represent this function in the system enauaneeds mE Code of a language in which the function name will be displayed The contents of this field defines the place of FunctionName in the FunctionCode and FunctionName drop downs of Competent Authority Master Se SortDescription Comments Necessary comments concerning function 3 3 4 CA Department Master The C A Department Master is used to indicate the names of the competent authorities Note Sometimes the names of various competent authorities are very similar or the same That is why NDS provides an opportunity to enter names such as Ministry of Public Health once and then use them for several countries CA Department Master may be invoked in two ways 1 from the main menu Masters gt Competent Authority gt C A Department Master 2 by double clicking the DepartmentCode or DepartmentName drop downs in Competent Authority Master window User Manual 60 Figure 62 CA Department Master Department Code KK 10217102 gt 0I Code epus ratem Code ENG v INTERNATIONAL NARCOTICS CONTROL BOARD INTERNATIONAL NARCOTICS CONTROL BOARD You will need to enter the following data Field Descri
170. ode Code of event when the system is supposed to display this message Language Code Code of language for which the system will display this message Type of error or warning message Choose one of the following e S stop error message with stop sign Equipped with only Ok button Only the action indicated in this message will be executed upon pressing of the button e Q question warning message equipped with three buttons It gives a user SOR TIPS an alternative whether to agree with the proposed action OK disagree and continue the started operation NO or abort the operation as a whole CANCEL e W warning warning message with only one OK button Warns the user of the consequences of the started operation Besson Brief description of operation which lead to the occurrence of event corresponding to ErrorCode Action Proposed action with which a user may agree or disagree Comments Necessary comments on the error warning message User Manual 163 After you have entered modified the data save the record From now on this message will be displayed by the system when the ErrorCode occurs in case the user has selected the proper language 8 2 3 Language Master Language Master is used to manage the list of languages supported by the system By means of this master you may enter into the system for example your local language if you intend to use it for working with NDS Language Master is started
171. ode3type Code4type oe gt Precursors Text PREC 1 Narcotics Text MARC 1 Others ext OTHER 1 1 Psychotropics PSYC First select a section that you are going to define custom numbers for Then think over the format of custom number In our example the newly added import authorization will have the following number IM P 44 2006 01 ode 1 Code 2 Code 3 lode 4 D elim iter So you will define the four logical parts of the number and then define the proper codes and delimiters for each part Each Code field may have the following types e Text plain text e Sequence No Number which increases by one point each time the new form document is created You will not be able to undo the numbering so that the numbers will not repeat and will stay unique e Year current year e Number any number The number in this field is not changing with opening of new documents e Month current month e blank space You may define the numbering policy for the whole section as well as for individual substance group If you check the DefaultSubstanceType checkbox the defined numbering policy will be applied to all Substances in the current section User Manual 165 8 2 5 Changing user defined codes of substances Substance Change This master is used in order to facilitate the process of changing the User Defined Codes UDF Codes of substances already in the system Parameters gt User Defined Co
172. of manufacture related data there is a special EMM Manufactured form in NDS EMM gt EMM Manufactured 7 2 1 How to indicate data on losses occurred during manufacture Unlike the data on Substances destroyed intentionally following some decision of a court or Competent Authority the term Losses applies to the quantities of controlled Substances lost during manufacturing process due to technological or other reasons See also Narcotics Form C These quantities do not include the quantities of expired and obsolete substances and preparations held at the stocks of wholesalers or manufacturers later disposed of because such quantities should be recorded as destroyed in the Destroyed tab of EMM Seizures form The quantities indicated in this tab affect the figures in the Form C Figure 160 EMM Manufactured form Losses tab Country Code Country Name Year Estab Code Establishment Name ZB zbekistan 2004 02157438 PEN v3seAskcnopr Qa Gow BE Losses Used for Schedule III Manufactured Exempted Preparation MFG MFG Non Psychotropic 0 00 12 07 2006 Code Substance Name TIU UNKNOWN AMP DUMMY DUMMYNEITHER ACID NOR BASE ACETIC ANHYDRIDE eae an gt User Manual 148 7 2 2 How to record the manufacturing of narcotic drugs and psychotropic substances Figure 161 Manufactured tab Pe izio7 2006 v Ncoo ee ICONC OFPOPPYSTRAW M GW v B Be
173. of the country if any if you try to enter one the same code for two different Establishments the system will warn you User Manual 68 Field Value Zip Code ZIP of other postal code D Benen Ly Pe Code of establishment type Manufacturer Retailer Doctor etc em Type Filled in automatically according to EstablishmentTypeCode See also Establishment Type Master section Country Name Alternative name of the country For example United Kingdom of Great Britain and Northern Ireland instead of United Kingdom in the System EAN Code 13 digit code also Known as bar code given to organizations by EAN International InActive The indicator showing if the establishment is still functioning or not As the establishments sometimes need to be contacted not only in English but also in other languages for example in the official language of the country of residence or official language of the country of NDS user it is necessary to enter the contact information in various languages For this purpose the Language tab is provided in Establishment Master see the Figure above Field Value Language Code Code of language Name of the Establishment corresponding to the LanguageCode It will be used throughout the system when the respective Language is selected by a user for NDS Name of street corresponding to the LanguageCode It will be used throughout the system when the respective Language is selected by a user for NDS C
174. on Data in Import Export Module nPEn 414 v MORPHINE HYDROCHLORIDE 3ML SMG ML v amp Boxes i 10 20 40 3 2 6 How to indicate relevant comments In the Additional Comments tab you may leave comments that you think will be useful for future reference Figure 52 Additional Comments tab Package Size User Manual 53 3 2 7 How to export the data on Preparations To run the special form dedicated to export the data on preparations in XML format do the following Masters gt Substances gt Preparation Export F5 Figure 53 Preparation Export Preparation Code Type Code xus Exempted Preparation UZB 4545454 5M P LIZB 545454C YP LIZB 555558DEN UZB_S65656LIT LIZB 571 8 242 N 01515BEL LIZB B DOBBOSVM UZB 71 27 3 46LKR LIZB T1 509 54LIKR LIZB TB7B7B7LAT LIZB 8888ROK LIZB 88888ROK LIEB ARG C1ARG LIEB ARG C2ARG UZB_ARG P1OARG M M M M N N M M M N N M M M When you press the Export button the data on selected preparations will be exported in XML format to the folder indicated in your nds ini file 3 2 8 How to import the data on Preparations In order to import data on preparations in XML format you should use the Export Preparation List form Masters gt Substances gt Preparation Import 5 Figure 54 Preparation Import UZB 4545454SVMl UZB 545454CYP UZB_565558DEN UZB_S565656L1T UZB_5N 8 242 N 01515BEL UzB 850005650SvMl UZB 71 273 48UKR UZB 71 608 54UKR U
175. ore precise special License menu section is provided in NDS 6 0 The minute details of working with these two modules will be described later in the respective sections of this manual 1 3 Masters Service Modules These modules are intended to facilitate a more convenient and effective organization of basic data So if a user needs to enter a new substance preparation establishment or any other records in a new language then he she will use the Masters module 1 4 Reports The NDS makes the preparation of all 7 main reports presented to INCB easier and more accurate Also the users who have proper access rights may view the data not only in aggregated form as it appears in the paper reports but also as a breakdown of separate transactions by establishments There are three report modules in NDS dealing with Narcotics Psychotropics and Precursors respectively Report Name Narcotic drugs Form A Quarterly Statistics Form B Annual Estimates Form C Annual Statistics Psychotropic substances Form A P Quarterly Statistics Form B P Annual Assessments Form P Annual Statistics Precursors Form D Annual Statistics UserMamal 0000000000000 ff 1 5 Parameters amp Security This component is used for tuning the whole system and thus is not accessible for each and every user The access rights to this module are usually granted for system administrators that is why in this manual we
176. ort option then you will only be able to create an export authorization request export authorization and proper endorsement After you have filled in the Imp Exp Flag field please fill other Header fields as well If you cannot find the necessary value in a drop down list for example in CountryCode or Exp Imp EstablishmentCode just double click the Code field and make the proper additions or changes in the correspondent Master form M Note The fields which are mandatory are marked with a red dot In case of partial shipment only See Chapter 2 Types of Fields section for more details User Manual 84 After filing in the general information on particular transaction header section you will be able to create an Import authorization request Just click on the proper tab Figure 91 Example of Import Authorization Request Imp Exp Flag Reference NOK 3148 Export as XML PEN Export Details Import Details Exp Country Code Exp Country Name Imp Country Code Imp Country Name S oo E oo proven Exp CA Code Exp CA Department Name Imp CA Code Imp CA Department Name 41431 v Ministry of Health Y 77471 CHIEF OF PHARMACEUTICAL AFFAIRS v Exp Establishment Exp Establishment Name Imp Establishment Imp Establishment Name TawkenT rop TAO Aopr aapmoh S456 x Haji Ahmad Traders TORO o Al rac Export Authorization Request 1277773 Winns een Endorsements Additional Establishments Imp Doc Ref Imp Auth
177. piration You may revoke a license using the same form as for license approval License gt License Approval Here you should just enter a date starting from which the license will be revoked RevokeDate and enter the RevokeReason in the adjacent field When you revoke the license it will not be considered by NDS and the latter will warn of the absence of proper license unless another license is issued User Manual 104 Figure 120 Revoke of the License Request Number License Number Previous License Number Signature Establishment Code Establishment Name Contact Person IINEEEEEENNNN LTLLLILUIILCLILID NENENMNMNMMMMMMMMMMMZZsessd alid From alid To Approval Date Revoke Date E_mail Address nn a E ee Revoke Re Phone Number Co itions Remarks ru e 1 EI ae E vil Clearance Information When you save the record i e revoke a license the system issues a warning message as follows National Database System Error Message re vau sure of Revaking this Authorization Select YES to Revoke the Authorization NO to UNDO Ehe operation and CANCEL to CANCEL the operation Ajcancel Once revoked a license cannot be re activated unless you delete the approved revoked license and create a new license authorization on the basis of license request 5 4 How to Suspend a License The action of a license can be interrupted by the competent authority on an interim basis There is a special
178. ption DepartmentCode Unique code that will represent this name in the system DepartmentName Name for this competent authority The contents of this field defines the place of the competent authority name in the SortDescription DepartmentCode and DepartmentName drop downs of Competent Authority Master Comments Necessary comments concerning the competent authority name 3 4 Permitted Restricted Substances According to the 1961 Convention and the 1971 Convention the Governments Countries shall submit their Estimates on Narcotic Drugs and Assessments on Psychotropic Substances to INCB After the revision the INCB publishes the Estimates and Assessments and disseminates it to the Governments The competent authorities should take measures to keep the import and export of controlled substances within the set limits Therefore such limits should be checked before any Import or Export Authorization is issued see Chapter 4 Import and Export Transactions for more details NDS is greatly helpful in such checks The Permitted Restricted Substance Master is intended for indication of Estimates Assessments as well as the import and export limits for controlled substances dealt with in the particular country during for a particular year User Manual 67 3 4 1 How to indicate the Estimated Assessed quantities of Controlled Substances To indicate the estimates on controlled substances you should open the Permitted Restricted Subst
179. pu apwoH IMP JOK P 35 Uzbekistan Dori Darmon Russian Federation Novosibhimfarm 04 11 2003 3434RUS 9 360 00 pack 4 3589 2003 shareholding company IMP JOK P05 12 The screens of this type consist of two logical parts e Criteria section upper and e Result section lower As you can see with the report query form it is much easier to search for necessary data on specific transactions Otherwise you would have had to make several step by step queries in several tabs To use the screen you just need to enter the necessary criteria in the Criteria section and then press the il lt ExecuteQuery gt toolbar button Mu Note The more criteria you enter the less records you will obtain in the result section User Manual 24 The records matching all entered criteria will be shown in the Result part of the report query screen You may print the selected data or export them to Excel for further analysis and or formatting You may also edit the data by means of double mouse click upon the necessary record the Import Export Document screen will open where you will be able to proceed with editing 2 8 Operations with Records 2 8 1 Adding New Record You may add a new record in various ways a upon what is more convenient for you e Click on the New toolbar button e Or Press F2 e OrSelectthe Add a New Record menu item from the System menu option e Or choose the Add a New Record option from the menu
180. r Alkaloid Name E HS Code CAS Code EAN Code 309999075092 es Language Substance Type Special Conditions Code Y AHTMADMA YKCYCHOM KACNOTBI 0000 yKCyCHOH AHTMADMA YKCYCHORKWCROTE 0000 AHTMADMA YKCYCHORKHCROTE 0000 yKCyCHOH AHTMADMA YKCYCHORKHCROTE 0000 Anhidrido Acetico Anhidrido Acetico Acetic anhydride Acetic anhydride a T User Manual 40 In the header section of the main Substance Master form you should fill in the following fields Field Value Pure Substance Code Code of the pure substance which is a base for the entered substance Variation Code Code of the variation radical comprising the entered substance UDF Code 0 Composite of PureSubstanceCode and VariationCode caeno Pcatgpohpueartiyromcriatettewunins Schedule Ind NumberofSchedueorTabletheenteredsubstanceisistedin Doses Dalydossoffhesubsane ntmandao Limit of Tolerance Theminimumdoseofthesubstancecausgdealh notmandao Unit of Measurement in which the substance is being accounted for and reported to INCB OQ M X S Code and name tag for the Unit of Measurement used for indication of quantities of the entered substance EAN Code 13 digit Code of European Article Numbering International bar code Uniform code of the substance in Harmonized System of the Customs Cooperation HS Code Council CAS Code Cod
181. r of the required menu item on the list or navigate to that item using the arrow keys After reaching the required sub menu item the corresponding screen may be invoked by pressing the ENTER Key 2 4 3 Special Keys amp Shortcut Keys Special keys are also known as shortcut keys These are defined key combinations that provide a quick way to accomplish certain tasks e g to enter in the Query mode in the screen the key provided is lt F11 gt to add a new record F2 A list of the special keys and their corresponding functions is listed in the table below Special Function Keys Key Function lt F1 gt Lists the help contents a Addanewrecodlneinocumentsceen able F o Deetelhecurented Fh Botrwe feld 00 lt F amp Exporthedaa aschoenbytheuserinoExel Fs Display Audit Trall information window Fi Etere 00 F0 BenleQuy 000 Enter Query Switches the screen mode from Edit mode to Query mode The user enters the required conditions of the query Print the existing form or screen There will be printing options to print the data in Ctrl p different formats layouts For example forms A P D etc will have 2 printing options User Manual 17 Key Function lt Ctrl gt lt w gt Close the current active window screen Ctrl lt F10 gt Grid view Ctrl Shift lt F10 gt Grid Edit view Accelerator keys enable users to select a menu item with a keystroke rather th
182. ra E educi iud occupa ACH Seer und dace tuU Sei lr MR RN 165 82 7 Bbackup Restore fonctionalty uuu teucuetur dest ae aE ERAT Urb uuu d tupaU edad suu a andae Cu M ue EpQUE 166 Foreword During the last two centuries narcotics and other psychoactive drugs once a relief turned into a disastrous threat to wealth and health of nations With the development and strengthening of illicit trade in such substances this threat was getting more and more serious Unfortunately it still is Over the 20 th century a worldwide system for control of drugs of abuse has developed gradually through the adoption of a series of international treaties The important multilateral conventions currently in force are the Single Convention on Narcotic Drugs of 1961 as amended by the 1972 Protocol the Convention on Psychotropic Substances of 1971 and adopted in 1988 the United Nations Convention against Illicit Traffic in Narcotic Drugs and Psychotropic Substances Each successive treaty brought complementary regulations and advances in international law From the beginning the basic aim of the international drug control treaties has been to limit the use of drugs to medical and scientific purposes only Nowadays production manufacture of and trade in psychoactive drugs and the chemicals needed for their illicit manufacture are controlled nationally and internationally The purpose of control is twofold e To prevent diversion of substances into illicit channels
183. rochloric acid 49 980 00 49 980 00 46 897 90 liters BB c00020 OAO Navoiazot Republic of Tadjiki OGujgecTBenHoe of beaHydrochloric acid 49 980 00 49 980 00 44 648 80 liters Total Morphine 2 67 2 67 2 679 This report shows the quantities on other related data on export of substances to a country indicated in the TradingCountry field When the query is done the results are shown first as a list of substances So you should click on the sign of the right side to view the details Please note that the transactions retrieved by this report are not necessarily completed i e there can be no endorsements made on these transactions To view the completed transactions i e the ones on which the endorsements are made use the Endorsement Report Export Transactions User Manual 97 4 5 6 Endorsement Report Exports Import Export gt Endorsement Report Export Transactions F5 Figure 112 Endorsement Report Export Transactions Endorsement Dates vod From SEINE SER Fs sro NT REN EI ae01 01 1950 81 12 2016 z Not Endorsed M Base Quantity C Actual Trade C Both Authorization No Establishment Trading Trading Establish A Name Request Approved Endorsed Country Quantity Quantity Quantity AZT Hydrochloric acid 149 940 00 149 940 00 141 193 50 liters Total Morphine 2 67 2 67 2 67g rotat Sulphuric acid 222 690 00 222 690 00 188 633 90 liters 000024 OAO Anmanbikekuh nRepublic of Tadjiki CTBN 3epas wan
184. s Establishment si Schedule Ind ALL C I CI C IH C Iv TE Trading l establish 8 E o Sl Subst Prep MEZ EE Substance Substance Name Establishment Trading Establish Authorization F Purchase Quantity Sale Quantity Code No M 3 Note When querying do not forget to specify the criteria in the fields marked with red circle 7 4 How to indicate the data on disposal of controlled substances The EMM also provides an opportunity to briskly record the data concerning the disposal of controlled substances Disposals happen from time to time if for example substances or preparations in stock exceed their expiration date EMM gt Disposal P9 Figure 169 Disposal tab Country Code Country Name Year Estab Code Establishment Name 2002 0009 Dori Darmon shareholding company Disposal 0 00 12 07 2006 0 UNKNOWN DUMMY DUMMYNEITHER ACID NOR BASE ACETIC ANHYDRIDE O 1 gt a Mkndime D owner uon Do mme The tab consists of two parts Substance Details Section upper and Alkaloid Details Section lower As in other NDS forms the Alkaloid Details Section is used only when the respective record in the Substance Details section contains data on Concentrate of Poppy Straw Chapter 8 System Security and Parameters 8 1 Security The Security module is used only by system Administrator i e the person specially assigned to ensure the functionality of the whole NDS system There are
185. s and Crime Group Master 4b System Masters Import Export Licenses EMM Narcotics Psychotropics Precursors Parameters Window Help A x APZ H E X R H D AMPHETAMINES APHETAMINES QD OPIATES Opiates ei os gt NENON A Other 1 i 000 Dummy Precursor 100 i O00N A DUMMY NEITHER ACID NOR BASE Precursor 100 i a b irm il aue a bY i AMPHETAMINES APHETAMINES OPIATES Opiates DPA 12 pja oo ooo SS gg o SO p oo ooo OUNODC STAS ndsus The Group Master screen consists of two logical parts In the left part there is a pane showing all already created Groups Mouse click on the sign unrolls the list of substances preparations and groups comprising this Group Figure 69 Group pane lt C gt AMPHETAMINES APHET AMINES m s OPIATES Opiates NAO06 ACETYLMORPHINE 5 MNAO13 AcebyImorphine NAO19 a pomoaorphine For more detailed information on rules of managing Licenses in NDS see the Chapter 5 Licenses User Manual 65 To make the visual perception easier the Substances and Preparations are represented with two different signs in Group Master e represents Substances o represents Preparations aD represents Groups To enter new Group you should create a new Group record in the left pane of the Master screen Here you should enter the GroupCode HeD AMPHETAMINES APHETAMINES H E OPIATES Opiates Then specify the name o
186. s and or territories authorized for manufacturing of synthetic narcotic drugs shall indicate their requirements for manufacture of such substances Other countries or territories shall not User Manual 116 a vl a a vl Figure 133 Synthetic Estimates tab Bs E Ba Emir loved ball EE 30 00 pp oo0s4s SuperPharm v NFo01 Fentanyl Qa e I v0 eje The following fields should be filled in Field Value Establishment Code Code of the establishment authorized for manufacture of synthetic narcotic drugs Eeiseilehmentame Name corresponding to EstablishmentCode Substance Name NamecomespondrgloSubstaneCode 00 Gay Quantity of synthetic narcotic drug to be manufactured oM i of measurement in which the substance is reported 6 1 2 4 How to indicate the information on estimates of opium production To enter the estimates on opium production you should use the Opium Estimates tab Figure 134 Opium Estimates tab Remarks Opium Estimates Area Code Area Name Area Under Quantity Produced ae a a tdi G Se ae np eae 00 00 PCC 1 User Manual 117 If the country for which the estimates are prepared is subdivided into several territories then you should indicate the estimates for each of them Note Only countries and territories authorized for cultivation of opium poppy for the purpose of opium production are supposed to provide this kind of information This tab include
187. s field defines the place of the city name in the City drop downs of SOMDESCHPUGH Customs Point Master Comments Necessary comments concerning the city name See also Customs Point Master 3 7 3 Area Master The Area Master is used to manage the data related to various areas of various countries In NDS the term area means the same as terms territory of the Single Convention and the term region of the 1971 convention and represents a part of the Country treated as a single entity for certain including but not limited to Statistical purposes The Master may be started from the Main Menu Masters gt Demographics gt Area Master P Alternatively it may be started by double clicking on any AreaCode or AreaName drop down box in the system Figure 86 Area Master Country Code Country Name Area Code Area Size MIEDO O a ENG eas Ir m gt gt I si User Manual 78 The following data shall be indicated Field Value Header section Country Code Code of the country the area is a part of Country Name Name corresponding to the CountryCode Area Code Unique code for the area It should not repeat throughout the system If you indicate the code already present in NDS the system will warn you with relevant message
188. s issued to carries out an export transaction A special suffix automatically added to the numbers of licenses of this type You may fill it in or leave blank Code of a language in which the license type name will be displayed Name for this license type The content of this field defines the place of license type name respective drop downs of NDS Comments Necessary comments concerning license type Chapter 6 INCB Reporting Forms 6 1 Narcotics 6 1 1 Quarterly statistical report Form A According to the 1961 Convention the member states are required to prepare statistical data on trade in narcotic drugs on a quarterly basis and furnish it to INCB within one month after the end of the quarter to which the statistical data relates Form A consists of a header section and 5 tabs e Remarks Imports Exports Imports CPS Exports CPS The Form A may be invoked from the main menu Narcotics gt Form A 9 Figure 128 Form A Country Code Country Name Year Quarter onn 2s Ito Remarks EOD AA zie Brice Geese Remarks Remarks Field Value Country Code The code of the country for this the statistics is being provided po MEME The tag showing the name for the CountryCode Quarter Quarter for which the information is being provided User Manual 110 The Remarks tab is intended for indication of data usually stated on the remarks page of paper based
189. s the following fields Field Value Area Code Code of a region of a country Area Name Name tag for respective AreaCode ee a a a a a a a a a aa a a a aa a Area Under Cultivation The size of territory allocated for opium poppy cultivation in hectares Quantity to be Approximate quantity of opium expected to be produced from the harvested poppy in Produced kg kilograms Moisture Average moisture content in the mass of obtained opium Comments Any relevant comments remarks on the opium cultivation Note Please do not be confused with the word area in the field names In the case of M AreaCode and AreaName it means part of the country treated as single entity In case of AreaUnderCultivation it represents a Lot size of a lana 6 1 2 5 How to indicate the estimates on cultivation of opium poppy for purposes other than opium production To do this you should open the Other Estimates tab Figure 135 Other Estimates tab tele Pusat eee EPI ERI EZ tiem Cuties Other Estimates Eyton mnie gt a ep if oro j OI H Area Code Area Name Area Under Cultivation Comments DP 4 070 eji This tab consists of three parts e Drug Details section e Area Details section e Alkaloid Details section User Manual 118 In the Drug Details section you should enter the quantities of poppy straw to be produced from harvested poppy In the Area Details Section you should indicate the territory where t
190. see Language tab Country Name Independence Date Date of Countries Independence CountySie Areaf the country insquareklomeres Timezone Timedfferencefom GMT 00000 Phone Number Countysiematonaphoneodde Telex Number sInternationaltelextagforthiscounty Two letter country domain e g us for USA ru for Russian Federation ge for Germany Internet Domain a ZUUn CCC Code Code of the Customs Cooperation Council ICPO Code Code for the Country assigned by International Criminal Police Organization Interpol ISO Number Code for the Country assigned by International Standardization Organization ISO User Manual 74 Figure 82 Country Master Independence Country Code Date Country Size Time Zone Phone Number Telex Number Country Name Internet Domain CCC Code ICPO Code ISO Number SS NNNM T E oso Language FETT Coco ENG UNKNOWN UNKNOWN UNKNOWN FRE UNKNOWN UNKNOWN SPA v UNKNOWN UNKNOWN RUS UNKNOWN UNKNOWN UNKNOWN EFS v UNKNOWN UNKNOWN DDJA s pj al 3 7 1 1 Indication of Country Name Language tab The Language tab is intended for indication of CountryName in various languages supported by the system If some language is selected in system Language Settings menu the respective CountryName will be displayed in all drop downs The following fields should be filled in the Language tab Field Value Language Code Code of the language for which t
191. ses of the counterpart company in order to balance the quantities throughout the Country However due to various reasons this does not always happen In order to reveal the missing records the special report query is provided in EMM Module see also Report Queries section EMM gt Domestic Purchases Sales Missing Entries User Manual 152 Figure 166 Domestic Purchases vs Domestic Sales Missing Entries report Year 2006 Narcotics Precursors Country Establishment Schedule Ind e ALL CI Cn C TI Cw on Trading Substance Substance Name Establishment Trading Establish Authorization Purchase Quantity Sale Quantity Code No Units CA001 Acetic anhydride SuperPharm AN Y35EKHCTOH E 10 000 00 0 00 NPEN 414 Morphine Hydrochloride 3ml 5mg ml Tawukenr rop TAO Aoph aap TawkenT rop 40 Aoph aap IMPOOO1 10 0 00 10 00 FIPETI 414 Morphine Hydrochloride 3ml 5mg ml Tawukenr rop FAO Jopn aapPBSn v3sueaskcnopr IMPODO1 10 0 00 15 00 As you can see the PurchaseQuantity fields are empty which reveals the missing data M Note When querying do not forget to specify the criteria in the fields marked with red circle 7 3 3 How to record transactions between wholesalers manufacturers For the purpose of rapid querying and displaying of information on the transactions that do not change the quantities accounted for as stocks special report query form is provided in NDS 6 0 See also Heport Queries
192. so Subst Prep Code Subst Prep Name Esse iniri Quantity Obtained xp Heec Alkaloid Code Quantity Obtained DJa am gt The data on transactions of manufacturing of one controlled substance from another controlled substance are recorded using the Manufactured tab of EMM Manufactured form The appearance of this tab is given in the figure below At the upper part of details section you will need to enter the substance s and alkaloids that were used for the manufacture and in the lower part the substance s and alkaloids obtained as a result of manufacturing process The transactions entered in this tab affect the figures in the Reports 7 2 3 How to record manufacturing of Schedule Ill preparations exempted preparations and non psychotropic substances According to he 1961 Convention and 1972 Convention the statistical data provided by Countries Governments to INCB include the data on the quantities of controlled Substances used for manufacture of preparations from which the narcotic drugs or psychotropic substances cannot be readily recovered In case of narcotics such preparations are called Schedule III Preparations as they are listed in Schedule Ill of Yellow List and in case of psychotropic substances they are called Exempted Preparations Also the countries are requested to report the quantities of psychotropic substances used for manufacture of non psychotropic substances Note You should indicate only
193. sseeseeeeeennnnnennnnnn 151 7 3 3 How to record transactions between wholesalers manufacturers ccccseeeeeceeeeeeeeeeeeeeeeeeeaeeeeseneeeeas 152 7 3 4 How to detect discrepancies in domestic trade data cccccccsseeecccceeeeeeeeeeeeeeeeseeeeeeceeeaeeeeeeseeeeeeeeeesaeess 153 7 4 How to indicate the data on disposal of controlled substances 153 CHAPTER 8 SYSTEM SECURITY AND PARAMETERS eere nane enne naa aaa u na nasus sna c Ioas as Rar mnnn 155 MICI esce 155 9d 1 Howto define TO G iiia a idest sti ee a OE eu axtan er de baincire ant 155 SPI INA AM HOw to delinea UIT TRO T 158 8 1 3 How to grant revoke a role to from user s coiere ert ERES nete eee e obe uo ote ge ee E Iia en S D te LUE M repre E DRIaS 159 Oot A EVON EO II ed 160 22x Parameler S aha a a E a wets aa aa e aea acces ub oiu u oed erue Persei A 160 92 la FomF eds Master uosdumcods o diusiicu e ette eed Balti sean deta Aa ber oci de asain ume dd eai bcd uas 160 9 2 2 Enor MISIE Suec s Gu iieoms oO EROR e diede ea aed temque PS nua Du IN Ee aD DI DIM DI EMI MEE 162 92 Se E ISeIUie MICI METRE UTI E ET 163 User Manual 9 2 4 Gusto INUMBOIIING suus brs poiciaead stulti eL dpide a a eduaieiaasdeieidvannisawciet deouaswiunatetet 164 8 2 5 Changing user defined codes of substances Substance Change ssesssssss 165 82 6 Presdenined SUDSIANCES seru
194. t and the Part Il is the following the import export section of Part gives the overall figures of import and export of psychotropic i substances and Part Il gives the country breakdown of the trade of psychotropic substances i e gives the information in which quantities and where such substances were imported from or exported to First open the Psychotropic Form P Psychotropic gt Form P 5 Add a new record with new country year combination or find the proper record by means of querying User Manual 129 Figure 145 Form P Statistics tab Country Code Country Name Year umm T L5 NM IA Remarks Statistics imports Exports Manufactured Sulistance Code Substance Name Quantity Quantity Quantity Manufacturers Manufactured Used for Used for Stocks at Manufacture of Manufacture of 31st December ___ non Psychotropic l _ preparations gt Ppoos Diazepam 2 000 00 PM016 Midazolam wf 3 000 00 Px0014 ketamine 7 500 00 4 quee 15 gt 6 2 3 1 How to indicate the statistical data required in Part of Form P manufacture stocks import and export The general data on manufacture utilization stocks imports and exports of psychotropic substances listen in Schedules I Il Ill and IV of the 1971 Convention is contained in the Statistics tab of electronic Form P The following data should be provided Field Value Total quantity manufactured domestically between
195. t nl cm002 Methyl ethyl ketone v 0 Fi 7 liters e e e Il 171 gt hij Fitered Notes we I se gt I When these values are entered the automatically generated RequestNumber turns red Note The system automatically sums up the quantities of all substances in all certificate requests being approved If such sum exceeds the quantities approved in import authorization the system will display a warning error message In our example the import authorization was issued for 10 litres of methyl ethyl ketone Let us try to file two import certificate requests for 7 litres and 6 litres so that we will try to intentionally exceed the already authorized limit When we try to approve the first certificate for 7 litres no problem occurs because we still are within the authorized limit However when we try to approve the second certificate for 6 litres the system will respond with the following message Figure 99 Warning Message National Database System Error Message Reason Action Approved quantity exceeds available quantity Check the quantity available that is displayed in the approved quantity Field User Manual 89 Now if you click on the lt OK gt button the authorized limit balance will be shown automatically in the Approved Qty field Requested Oty Approved Oty 3 Now you may save the import certificate Upon saving you will be able to make NO changes in original
196. t Export Authorization Endorsements EE Eze eens Authorization Certificate Endorsement Date P1 10 BKTIKHK 110 2006 v 16 JUN 2006 l Endorsement Req Import Export Reference 1660 Qa anm gt oF Substance Code Substance Name Preparation Type Request Approved Endorsed Qty er iini PET H4 414 PET H4 MORPHINE HYDROCHLORIDE 3ML MORPHINE HYDROCHLORIDE 3ML 5MG ML wy v MORPHINE HYDROCHLORIDE 3ML 5MG ML lamp 0 10 Boxes ear a ejh 14 In case of Certificates only the Numbers of Certificates not Authorizations will be shown in the Authorization Certificate drop down box User Manual 92 What you Will need to pay attention to are the following fields Field Value Endorsement Date Actual date of export import Import Export Number of the corresponding document import authorization or import certificate when Reference exporting or export authorization when importing Preparation Type Type of exported preparations see Preparations section for details Number of actually exported preparation units i e packs boxes etc see Preparations section for details Se Endorsed Qty The actually imported exported quantity of controlled substance Note The EndorsedQuantity should not exceed the quantity stated in the respective M authorization i e it should be less or equal than the authorized quantity If not the system will notify you about the violation with a warning message Note
197. t data on establishments Establishment Import NDS 6 0 enables the user not only to export but also to import the establishment related data in XML format Special Import Establishment List screen may be started as follows Masters gt Establishment gt Establishment Import Figure 81 Establishment Import TRADING vn YCWAHXOKSeBa npaesa Kr TAWKEHT EN 700021 r Taukenr LLaltxoHTa Import UB 00021 TaWKEHT rap C amp O Hopi gapmoH TRADING UZB_o0045 LZB nouos LIZB n2018458 LIZB 02157438 LIZB D5022664 LIZB 07621385 LUzB 123 LIZB 15210987 LIZB 15341283 LIZB 15387262 UZB 21212121 LIZB 890 8 AIT vsbekacToH Hopa ragManaTIP TRACING Dori Darmon shareholding compar TRADING CbIPQapHHCKHE abn Jopu gqapnor TRADING TRADING TRADING HaBOMMCKHE ropho metTannyp mel TROSMPG Taw keHTcKHn on FAO Jopw gap TRADING TRADING YacTHad npaWunssogcTse Toproeaa TTRDA amp MFU tipa Ack nent TRADING sGercko AmieprKanckoe CM Kamp TRADING HOSPITAL TRADING PE Sn smegskcnopt Gora Gamich Darixonalari oc HdacTHaa anreka HE ypaber Getcha gom Mypye eat Het UZB NPEQNP 104 CO s Dourky MaMHT Konanraner UFB NPEQNP 124 CO 4Smantatitay Fongdiangc 34 ITRD amp MFG FOO069 FOO021 T 7002 vn M Miapnynaraoga n 1 a r TaukeHT ChIP AapMHCKHE aBnacTb DIEI T r TaukenT M Yny rDekckah par TOOO9S r TaukenT vn Ypasba TORSO r Hason y n Ha amp oM p vn Wey Xoc Moo 2 r TAWKEHT POOO0S yn
198. t typing any set of characters and the system will jump each time to the first row on the clicked column that matches the typed value there are 2 navigation buttons Up and Down that enable the user to jump to the Next or Previous matching row respectively Figure 29 Grid view with Go To feature E Equos ruLnmnanakium Toms Coda jar Preparation Type Code Search in Preparation Type Cod I I S U Oe mom In0 CO wa i reparatio E serum izpe Hale Match Case AnyWhere M TAB AMP amp AMF amp tabl P pack The window has the possibilty to work as case sensitive insensitive by checking unchecking the Match Case checkbox Also to it s possible to search the requested value within the contents of the different rows or only as start with by checking the AnyWhere checkbox e Quick Filter By Right Click on any Cell in the Grid and choosing Quick Filter option from the pop up menu the system will recognize automatically the value in that cell and apply a filter as following Clicked Column Cell Value Repeating the Quick Filter activity on another column will join the two conditions and so on e Reset Quick Filter Will remove any set of conditions applied by QuickFilter and retrieve the original record set of the Grid Figure 30 Grid view after applying Quick Filter feature SET paration Master Preparation Code Exempted Active reparatin Preparation Type UOM Description Preparation repar
199. the information will be entered by and displayed to this particular Default Language User Import Export Validity Period Months License Validity Period The period for which the User will be able to issue Export Import authorizations The period for which the User will be able to issue Licenses Months Active Use This drop down box shows if the User is an active or inactive one In case of inactivity he she will not be able to work with the system Ignore warning in the The User will be able to override the warnings in Import Export module i e issue file for Import Export module and issue Import or Export Authorizations when they exceed the specified limit Ignore warning for User will be able to override the warnings concerning excess of Estimates Estimates nore War ng tor User will be able to override the warnings concerning the Export Limits Export Limit Ignore warning for User will be able to override warnings when license for some particular Substance of available License transaction is unavailable ignore warning for Licerise Quota User will be able to override warnings when the Licensed quota is exceeded When you enter the user related information you may proceed with assigning granting a role to him her User Manual 159 8 1 3 How to grant revoke a role to from user s A role may be granted to or revoked from a User in two possible ways 1 By means of User Roles tab in User Maintenan
200. the quantities of obtained preparations User Manual 121 Field Value Quantity held in stock on 31st December Should be used to enter data on stocks held as at 31 December of the year in question Should be used to indicate the amounts procured for and or withdrawn from special stocks If you enter the positive value NDS will recognize it as procured and will mark it with letter P when printing the report Vice versa if you enter the negative value with sign preceding it it will be recognized as withdrawn and marked with letter W in aper report Should be used to enter data on losses occurred during the manufacturing process Data referring to the destruction of obsolete materials should be entered on the Remarks tab Quantity procured P for special purposes or withdrawn W from special stocks Qty Lost During Manufacturing Process M Note The fields of the Alkaloid Details Section although identical to those of Drug Details Section are filled only in case the substance they relate to is a CPS 6 1 3 2 How to indicate the statistical data on manufacture of narcotic drugs According to the 1961 Convention the term manufacture represents any process other than production by which drugs may be obtained including the refining and transformation of one drug into another drug To indicate the manufacturing information you should use the Manufactured tab Figure 138 Ma
201. the substance is reported Schedule Number of Schedule of 1971 Convention in which the substance is listed Country Breakdown Section Country Code Code of the country the substance was imported from exported to Country Name Name of the country corresponding to CountryCode Quantity Imported Quantity of the substance which was imported from exported to the country Exported corresponding to CountryCode User Manual 131 6 2 3 3 How to indicate the data required for Part Ill of Form P use of psychotropic substances for manufacture of other pshychotropic substances As it is stipulated in the 1971 Convention on Psychotropic Substances the countries and territories signatories to the Convention are requested to provide information on the use of psychotropic substances listed in Schedules Il Ill and IV for the manufacture of other psychotropic substances indicating the name of the source substance the quantity used in the manufacturing process the name of the other psychotropic substance derived from the manufacturing process and the quantity of that substance derived from the manufacturing process Such data is provided using the Manufactured tab of Form P Figure 147 Manufactured tab B Substance Code Used Substance Name Quantity Used Schedule Indicator al 0 00 UDF Code Substance Name Droperidol Dextropropoxyphene Diphenoxylate Methadone Pethidine ei e I tet gt I H Substance Code Obta
202. tity 12 07 2006 47 AMFETAMINEBITARTRATE G AMFETAMINEHYDROCHLORIDE G 79 AMFETAMINEPARA AMINOPHENYLACETATE G 47 AMFETAMINMEPARACHLOROPHENOXYACETATE G 42 wi o lvl As you can see the differences between the above mentioned tabs are quite small The main difference is that in narcotics related tab Used for Schedule III only narcotic drugs are shown in the SubstanceCode drop down whereas Psychotropic Substances are shown in the SubstanceCode drop downs of two Psychotropic related tabs All three tabs consist of Substance Details upper and Alkaloid Details lower section As in other NDS forms the Alkaloid Details Section is used only when the respective record in the Substance Details section contains data on Concentrate of Poppy Straw 7 3 Domestic transactions 7 3 1 How to account for domestic trade in controlled substances The quantities of controlled substances imported by wholesalers and manufacturers are considered as kept in stocks on the INCB forms as well as the quantities manufactured The quantities of substances transferred to the retailing establishments and quantities imported by retailing establishments are considered consumed according to 1961 Convention The transactions which lead to the transfer of controlled substances between wholesalers between wholesalers and manufacturers as well as from wholesalers and manufacturers to retailers are being accounted for using the EMM
203. uageCode Eng or any other CommunicationDetails info ca_name org If you cannot find proper means of communication in the Communication Code drop down you may use the C A Communication Master J See also C A Communication Master User Manual 56 3 3 1 2 How to indicate functions of competent authority To indicate the functions of a given competent authority use the Function tab Figure 57 Function tab Function Irure Signatory Function Code Function Name esos ies Correct CA For Article 12 IGNATORY FUNCTION FOR FORM A IGNATORY FUNCTION FOR FORM AP IGNATORY FUNCTION FOR FORM B SIGNATORY FUNCTION FOR FORM BP e e 1712 gt pil Filtered 4 4 m SI SI SI 71 I SISISI CI 4 SPA v e e I 173 b bl Fitered e Select the code or name of proper function s from FunctionCode or FunctionName drop downs e check up the Signatory checkbox if the present competent authority is an authorized signatory for this function e check the Correspondence box if the correspondence concerning this function should be mailed to the present competent authority e enter comments in one or several languages optional If you cannot find proper function in the respective drop down use the CA Function Master to enter it into the system See also C A Function Master 3 3 1 3 How to indicate administrative details of the competent authority For this purpose use the A
204. ubstance s in dosage form The addition in dosage form is very important as although the import and export of controlled substances is reported in metric units as grams kilograms and litres in practice Establishments are dealing with tablets ampoules packages etc 3 2 1 How to create a Preparation First open the Preparation Master Masters gt Substances gt Preparation Master User Manual 48 Figure 46 Preparation Master Preparation Code Exempted Preparation Active Preparation PIPEN L Dx Preparation Type Code Preparation Type Name UOM UOM Description OR 1537183 ooi Package Size Additional Comments hend NECEM Se ENG Morphine Hydrochloride 3ml 5mgjrnl Morphine Hydrochloride 3ml 5ma ml RUS MopdnHa rHApoxnopHA 3 mn Serin MopprHa rHapoxnopHa 3 mn Smrfmn dp l 172 Then fill in the PreparationCode field In this field you are supposed to enter the combination of letters and figures so called alohanumeric combination that will represent the new preparation throughout NDS database This code should be unique i e it should not repeat in NDS Other header fields are Field Value EAN Code 13 digit code also known as bar code assigned by EAN International A checkbox showing if the preparation is exempted from under some measures of international control Se Code of preparation type See the explanations below See also Preparation Type Prepar
205. unique As in other INCB forms there is a special Remarks tab which is intended for indication of additional information that the reporting country believes will be essential and important for INCB 6 3 1 How to indicate seizures of quantities included in Tables l or Il To enter data on seized quantities of Substances listed in Tables and II of the Red List you should use the Seizures tab of Form D Figure 148 Form D Seizures tab Country Code Country Name Year Qa HE s Ib Seizures Licit Uses and Trade Illicit Manufacture Methods of Diversion Stopped Shipments SASS ance Code Substance Name Seized Quantity Schedule Confidential Indicator CAO02 Acetone 21 000 00 gt zl wa i il gt gt i W Country Of Origin Country Name Quantity Seized Confidential kez KAZAKSTAN l 1 000 00 E 3 Russian ag 20 000 00 This tab consists of two logical parts e Substance Details upper e Country breakdown lower First you should indicate the substance which was seized one or more times in this country during a reporting year Second you should indicate the countries from which this substance was brought as well as quantities by each country User Manual 133 The following data should be indicated Field Value In the Substance upper part The code of a seized substance included into Table or Table Il of the Red List or of the substances having been used in ill
206. up substance preparation group drop down box So ifa Preparation option is selected then only preparations will be displayed This feature enables you to enter the substance and preparation related information even faster The Subst Prep Group Name displays the text tag for the code shown in the Subst Prep Group drop down menu M Note The RequestedQty may be left blank That will mean that the establishment is entitled to deal with unlimited quantity of the specified substance The rules of work with other fields of this tab are the same as the rules of work with fields in tabs of Import Export module User Manual 101 5 1 2 Setting a type of License After you have completed filling in the header of the request you should define the type of license being issued To do this click on the LicenseTypes tab and choose necessary value from the LicenseTypeCode drop down menu M Note You should select at least one license type If you do not choose any the system will warn you with appropriate message If you need to create new License type double click on the LicenseTypeCode drop down tab to get access to the License Type Master see License Type Master section for more information iL 115 License Types tab Linking Substance Details SALES SALES One license may include several types of activity As you can see on the figure above an establishment is requesting a license for manufacturing and retail trade
207. y the volume of ampoule 8 ml and then divided the product by the number of milligrams in one gram 1000 Thus we obtained that there is 0 015 gram of Morphine Hydrochloride in one ampoule of our sample preparation Now you should enter this value into the Quantity Volume field on the Contents tab and NDS will generate the quantity of pure anhydrous Morphine It will be 0 0089 gram Figure 49 Contents tab ET Contents DIRE Additional Comments Substance Code Substance Name Conversion UOM Quantity Pure Comments Factor Description Volume Substance NmoosHCL v NwoO9HCL v MORPHINEHYDROCHLORIDE 0 015 01 355 00 ei I 171 b bl Filtered The screenshot above shows the correct entering of data for our example in the Contents tab 3 2 5 How to indicate the size of a package Sometimes imported exported preparations differ only in number of ampoules tablets etc in one package In this case you can enter several options for the package size If we come back to our example of import of Morphine Hydrochloride the properly entered data in Package Size tab will look as follows User Manual 52 Figure 50 Package Size tab Language Contents Additional Comments Qu vs gt Upon entering the data on the package size becomes available in Import Authorization Request form of Import Export module see mport Transaction Documents section for more details Figure 51 Preparati
208. ypes To distinguish between manufacturers wholesalers and retailers NDS has an AllowedToKeepStocks YES or NO drop down in the Establishment Type Master If the drop down is set to YES the system will calculate any substances on the stock of any establishment of that type as kept in stocks in the EMM and on FORMS C and D otherwise the system will calculate it as consumed 3 6 5 How to export data on establishments Establishment Export Unlike previous versions NDS 6 0 gives its users an opportunity to export establishments related data in XML format For this purpose you are supposed to use the Export Establishment List screen It may be invoked as follows Masters gt Establishment gt Establishment Export 5 To export the establishments related data e Select the country you are going to fetch the data upon e select the establishments you need e press Export button to start generation of XML file The proper XML file will be generated and saved in a folder indicated in nds ini file In fact this flag does not mean that it is prohibited for hospitals or other retailers have controlled substances in stocks User Manual 72 Figure 80 Establishment Export pzB Uzbekistan UzB ODDO ocynapcTBeH LEHTE 3sikcnieprWsber M c1 ZB ESTB yn YcwaHxomxaeba npaesa K Vwapgr TAWKEHT SS Uza nn Taukenr rap AO Ilopim gapmoH UZB ESTB 700021 r Taukenr LLaltxo nTaypckii UZB 00045 UZB_ESTE

Download Pdf Manuals

Related Search

Related Contents

TLS1-VOL 取扱説明書  Hypertec N13419LHY User's Manual  MANUEL D`INSTRUCTIONS  DSW98D Smoke Alarm User`s Manual  LAN9303M EVB User Manual Rev. 1.0 - SMSC  Tristar Fondue/Deep fryer  Descargar Documento  Omnitron Systems Technology 564 SS User's Manual  Toutes les opérations  MS4/6-LOE  

Copyright © All rights reserved. Failed to retrieve file