Database of Scriptum

Cosmetic surgeons said procedures should not be sold as "a commodity".

For more information visit this link http://www.bbc.co.uk/news/uk-20850284

APP	Description	Cost
ACC Pocket Guidelines	ACC Pocket Guidelines is a clinical practice support tool set from the American College of Cardiology Foundation that provides concise, portable reference tools for clinicians.	Free
Antibiotic Pharmacology	Antibiotic Pharmacology is a fully featured flash card app that helps you learn about antibiotic pharmacology. Included in this app are: + Main Deck + Faves Deck + Ignore Feature + Shuffle Ability + Choice of Primary Side + Search Feature + Index + Beautiful, Easy-to-Use Interface	2.99
Davis’s Drug Guide	Davis’s Drug Guide for Mobile and Web delivers up‐to‐date, comprehensive, and practical information on over 5,000 trade name and generic drugs. PLEASE NOTE: Application requires a paid subscription to the online Davis’s Drug Guide service. Davis’s Drug Guide for Mobile + Web includes: • Over 5,000 trade name and generic drug listings • High-alert notices • Risk Evaluation and Mitigation Strategies (REMS), highlighted by an icon • Drug-drug, drug-natural, and drug-food interactions • Discontinued drug list • Unique optimization for iPad, iPhone, and iPod touch interfaces • Universal Index Search – find terms across all indexes • “Favorites” for bookmarking important entries • Regular updates and Web access for one year	Free
Drugs and Meds: Pill and Drug Identification	Drugs and Meds: Pill and Drug Identification is a glossary of the most common prescription drugs (USA‐based), with images of many of the drugs (in pill form mostly) to help you identify them based on image.	0.99
Epocrates	ePocrates is a mobile drug reference used by healthcare providers at the point of care.	0.99

• Linux kernel — This is the kernel on which Android is based. This layer contains all the lowlevel device drivers for the various hardware components of an Android device. Android uses Linux for its device drivers, memory management, process management, and networking. However you will never be programming to this layer directly.
• Libraries — These contain all the code that provides the main features of an Android OS. Forexample, the SQLite library provides database support so that an application can use it fordata storage. The WebKit library provides functionalities for web browsing. They are all written in C/C++ internally, but you'll be calling them through Java interfaces.
• Android runtime — At the same layer as the libraries, the Android runtime provides a set of corelibraries that enable developers to write Android apps using the Java programming language. The Android runtime also includes the Dalvik virtual machine, which enables every Android application to run in its own process, with its own instance of the Dalvik virtual machine (Android applications are compiled into the Dalvik executables). Dalvik is a specialized virtual machine designed specifically for Android and optimized for battery-powered mobile devices with limited memory and CPU.
• Application framework — Exposes the various capabilities of the Android OS to application developers so that they can make use of them in their applications.
• Applications — At this top layer, you will find applications that ship with the Android device (such as Phone, Contacts, Browser, etc.), as well as applications that you download and installfrom the Android Market. Any applications that you write are located at this layer.

• Smartphones
• Tablets
• E-reader devices
• Netbooks
• MP4 players
• Internet TVs

This time we will discuss about the computerization of inventory in the warehouse (location) is done automatically at the time the transaction is entered into a purchase transaction table, into the sales transaction table, as well as mutations in the transaction table movement of goods between warehouses (locations). The assumption of this discussion is about the stock of drugs in the hospital pharmacy, the location of the drug in some places.
For the above, the following is the syntax of SQL that is run on Microsoft SQL Server 2000 Personal Edition.
CREATE TABLE [dbo].[Master_Obat] (
    [Kode_Kelompok] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Kode_Obat] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [Nama_Obat] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Satuan] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Harga_beli] [money] NULL ,
    [Harga_Jual] [money] NULL ,
    [Kode_Pabrik] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Master_Obat] ADD
    CONSTRAINT [PK_Master_Obat] PRIMARY KEY  CLUSTERED
    (
        [Kode_Obat]
    )  ON [PRIMARY]
GO
---------------------------------------------------
Master_obat tables are used to store master data medicine overall. In this table has a field that is drug code, drug name, unit, purchase price, sales price, and several other fields as needed.
---------------------------------------------------

CREATE TABLE [dbo].[Gudang] (
    [kode_gudang] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [Nama_gudang] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Is_GudangUtama] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Master_Obat] ADD
    CONSTRAINT [PK_Master_Obat] PRIMARY KEY  CLUSTERED
    (
        [Kode_gudang]
    )  ON [PRIMARY]
GO
---------------------------------------------------

CREATE TABLE [dbo].[StokGudang] (
    [kode_gudang] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [kode_obat] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [stok] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Master_Obat] ADD
    CONSTRAINT [PK_Master_Obat] PRIMARY KEY  CLUSTERED
    (
        [Kode_gudang]
        [Kode_obat]
    )  ON [PRIMARY]
GO
----------------------------------------------
Both of the above table is used to store information drug stocks at each location.
----------------------------------------------

Next is a purchase transaction table as shown below. At the time of the purchase transaction information is stored in two tables, namely, purchase table and table purchase details.

CREATE TABLE [dbo].[Pembelian] (
    [Nomor_Pembelian] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [Nomor_Faktur] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Tanggal_Pembelian] [datetime] NULL ,
    [pemasok] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Master_Obat] ADD
    CONSTRAINT [PK_Master_Obat] PRIMARY KEY  CLUSTERED
    (
        [Nomor_Pembelian]
    )  ON [PRIMARY]
GO

-------------------------------------------------------
CREATE TABLE [dbo].[Pembelian_Detail] (
    [Nomor_Pembelian] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [Kode_Obat] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [quantity] [int] NOT NULL ,
    [Harga_beli] [money] NULL ,
    [harga_jual] [money] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Pembelian_Detail] ADD
    CONSTRAINT [PK_Pembelian_Detail] PRIMARY KEY  CLUSTERED
    (
        [Nomor_Pembelian],
        [Kode_Obat]
    )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[Pembelian_Detail] ADD
    CONSTRAINT [FK_Pembelian_Detail_Pembelian] FOREIGN KEY
    (
        [Nomor_Pembelian]
    ) REFERENCES [dbo].[Pembelian] (
        [Nomor_Pembelian]
    )
GO

Drug stocks counting mechanism through trigger on the table purchase details, as described below. Trigger occurs when the INSERT, DELETE, and UPDATE.

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE TRIGGER tbl_PembelianDetail_Trigger1
ON dbo.Pembelian_Detail
FOR INSERT
AS
    declare @no_beli     varchar(12)
    declare @kod_obt     nvarchar(8)
      declare @qty     int
    declare @stk     int
    declare @hrg_beli    money
    declare @hrg_jual    money

    SELECT     @no_beli  = ins. nomor_pembelian,
        @kod_obt = ins.kode_obat,
        @qty = ins.quantity,
        @hrg_beli = ins.harga_beli,
        @hrg_jual = ins.harga_jual
    FROM inserted ins

    SELECT @stk = Stok
    FROM StokGudang
    WHERE (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obt)

    UPDATE StokGudang
    SET stok = @stk + @qty
    WHERE  (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obt)

    UPDATE master_obat
    SET harga_beli = @hrg_beli, harga_jual = @hrg_jual
    WHERE kode_obat = @kod_obt


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE TRIGGER tbl_PembelianDetail_Trigger2
ON dbo.Pembelian_Detail
FOR DELETE
AS
    declare @no_beli     varchar(12)
    declare @kod_obt     nvarchar(8)
      declare @qty     int
    declare @stk     int

    SELECT     @no_beli  = del. nomor_pembelian,
        @kod_obt = del.kode_obat,
        @qty = del.quantity
    FROM deleted del

    SELECT @stk = Stok
    FROM StokGudang
    WHERE  (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obt)

    UPDATE StokGudang
    SET stok = @stk - @qty
    WHERE  (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obt)

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE TRIGGER tbl_PembelianDetail_Trigger3
ON dbo.Pembelian_Detail
FOR UPDATE
AS
    declare @no_beli     varchar(12)
    declare @kod_obtIns     nvarchar(8)
    declare @kod_obtDel     nvarchar(8)
      declare @qtyIns     int
    declare @qtyDel     int
    declare @stk     int
    declare @hrg_beliIns    money
    declare @hrg_jualIns    money
    declare @hrg_beliDel    money
    declare @hrg_jualDel    money

     SELECT     @no_beli  = ins. nomor_pembelian,
        @kod_obtDel = del.kode_obat,
        @kod_obtIns = ins.kode_obat,
        @qtyDel = del.quantity,
        @qtyIns = ins.quantity,
        @hrg_beliDel = del.harga_beli,
        @hrg_beliIns = ins.harga_beli,
        @hrg_jualDel = del.harga_jual,
        @hrg_jualIns = ins.harga_jual
    FROM deleted del, inserted ins

    SELECT @stk = Stok
    FROM StokGudang
    WHERE (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obtDel)

    UPDATE StokGudang
    SET stok = @stk - @qtyDel
    WHERE (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obtDel)

    SELECT @stk = Stok
    FROM StokGudang
    WHERE (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obtIns)

    UPDATE StokGudang
    SET stok = @stk + @qtyIns
    WHERE (kode_gudang = (SELECT Kode_Gudang
                   FROM Gudang
                   WHERE Is_gudangUtama = 1))
         AND (kode_obat = @kod_obtIns)
   
    UPDATE master_obat
    SET harga_beli = @hrg_beliDel, harga_jual = @hrg_jualDel
    WHERE kode_obat = @kod_obtDel

    UPDATE master_obat
    SET harga_beli = @hrg_beliIns, harga_jual = @hrg_jualIns
    WHERE kode_obat = @kod_obtIns


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
-----------------------------------------------

• Alerts - Alerts the user to various types of errors involved in the prescription of medications. 
• Counselor - on demand clinical advises related to drug therapy.
• CCMS - Brings in-house clinical content to the point of care.
• Tools - Provides tools for local adaptation, report generation, system configuration, etc.
• Interface - Interfaces the prescription application and provides the information to the users via the prescription/EHR applications.

1. An expert group must be organized to develop the computer based nursing process documentation system. The range of computerization was determined to support nursing care plan and nursing documentation, and to provide the statistical data of the nursing care plans.
2. The expert group analyzed the care planning process and nursing documentation process. The group also determined developmental principle, standard language, basic data.
3. Organization and arrangement of basic data, database construction, designing of the user interface system, code construction, program construction were accomplished. It is a huge database.
4. A users manual that focuses on usage instructions, standardized nursing language and nursing process was then developed.

We assume that you have read about personnel sub system in the hospital information system that presented before at http://databasescript.blogspot.com/2012/10/entity-relationship-model-of-hospital.html
In this article will take up about inserting a user id, password and other fields that related to tUser table in personnel sub system. This procedure of inserting a user will affect to the procedure of user login at the later. Here is the syntax of creating the routine.
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertuser`(
   IN p_user_id varchar(20),
   IN p_encrypted_pass varbinary(100),
   IN p_personID varchar(18))
BEGIN
 DECLARE vMidUserId varchar(3);
 DECLARE vMidIdPegawai varchar(6);
 SET vMidUserId = MID(p_user_id,1,3);
 SET vMidIdPegawai = CONCAT(RIGHT(p_personID,2),LEFT(p_personID,4));

 INSERT INTO tuser(user_id, kata_sandi,idPegawai)
 VALUES(p_user_id,
       AES_ENCRYPT (p_encrypted_pass ,CONCAT(vMidUserId,vMidIdPegawai)),
       p_personID);
END 

One important thing in this routine is the encryption of the user password. Of course you can modify the AES_ENCRYPT option with one you like. The AES_ENCRYPT also use in the login stored procedure, and we will talk about it in the later article.

MySQL Workbench provides three main areas of functionality:

1. Support of specific knowledge-based problem solving activities through the analysis of patients’ raw data collected in monitoring.
2. Discovery of new knowledge that can be extracted through the analysis ofrepresentative collections of example cases, described by symbolic or numericdescriptors.

1. Assembling the data.
2. The data warehouse.
3. Relational database and flat files.
4. Mining the data.
5. Interpreting the results.
6. Result application.

We will study each step in later articles.

The Complex Database Schema of Hospital Information System