1 / 10

National Database System The Australian Experience

National Database System The Australian Experience. What system is in place now?. Runs on mainframe computer system which is being phased out Developed in ADABAS/NATURAL which is a legacy programming environment. Limitations of current system.

deckard
Download Presentation

National Database System The Australian Experience

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Database SystemThe Australian Experience

  2. What system is in place now? • Runs on mainframe computer system which is being phased out • Developed in ADABAS/NATURALwhich is a legacy programming environment

  3. Limitations of current system • Fixes needed to cope with increasing numbers of transactions • Does not use graphical user interface (mouse) • Manual manipulation of data for INCB Forms • Multiple opportunities for errors • Considerable time required to train new staff • Cannot run flexible enquiries or management reports

  4. Why do we need to change? • Changes in standard technology • Increasing administrativeworkloads • Stakeholder needs

  5. Anticipated benefits • reduced number of errors - better data • decrease in amount of manual keying (duplication of effort) • less manual manipulation and checking of data for inclusion in INCB reports • better service to clients • capacity for integrated systems with Customs Service and States/Territories • improved communication

  6. Changes required for internationally controlled substances • Link standard licence and permit conditions to particular substances or importers/exporters For example: • Goods must not be stored at the importer’s address but delivered directly to [address] • Goods on this permit are for use in laboratory analysis only. • The importer must notify Australian Customs Service of arrival time, flight number at least 12 hours prior to arrival of the goods [pseudoephedrine raw material]

  7. Changes required to internationally controlled substances (cont.) • View address on authorisation screen • Flag exports which require corresponding imports permits for Schedule III and IV psychotropic substances • Make competent authority an optional field in import screens • Permit authorities to choose if error messages can beover-ridden

  8. What changes do we need for substances not under international control? • capacity to print different permit types for different groups (eg anabolic steroids) • substance master file to include additional parameters which can be turned off (eg need for estimates, licences)

  9. Where to next? • establish master files • migrate existing data • customise licences/permits/letters/ reports • customise data input screens, terminology, error messages and help screens • setup security and access

  10. and then…... • VALIDATE • IMPLEMENT • OPERATE • ONGOING TRAINING & SUPPORT

More Related