Front Office

Reservation

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Reservation Person ( in Case have reservation) from TB Populate

  SELECT Populate.Prefix + Populate.FirstName + Populate.MiddleName + Populate.LastName + Populate.Suffix, People.Address FROM Populate

• VIEW & GET: LAB, X-Ray, Payment Type TB Library or Inventory

  SELECT Library, SerialNo FROM Library, Inventory

• VIEW & GET: SourceCompany, ReferSource  from TB Corporate
• VIEW & GET: Promotion from TB Privilege
• VIEW & GET: RoomNo  from TB Department
• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Register.GroupType, Register.SourceType, Register.SourceCompany, Register.Promotion, Register.PaymentType, Register.DepositAmount, Register.DoctorCode, Register.AdultQuantity, Register.ChildQuantity, Register.FlightNo, Register.ArrivalDate, Register.ArrivalTime, Register.ExpectedDeparture, Register.DepartureDate, Register.ReferSource, Register.ReferPeople, Register.RoomNo, Register.Status FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Register

Check-In

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Reservation Person ( in Case have reservation) and Status = Reserve from TB Register

  SELECT GroupType, SourceType, SourceCompany, Promotion, PaymentType, DepositAmount, DoctorCode, AdultQuantity, ChildQuantity, FlightNo, ArrivalDate, ArrivalTime, ExpectedDeparture, DepartureDate, ReferSource, ReferPeople, RoomNo, Status FROM Register

  Case appointment for LAB, X-Ray, system will be create Transaction and queue.

• VIEW & GET: Register person, People Contract in case emergency, Group Type, Source Type Doctor from TB Populate

  SELECT Populate.Prefix + Populate.FirstName + Populate.MiddleName + Populate.LastName + Populate.Suffix, People.Address FROM Populate

• VIEW & GET: LAB, X-Ray, Payment Type from TB Library or Inventory

  SELECT Library, SerialNo FROM Library, Inventory

• VIEW & GET: SourceCompany, ReferSource from TB Corporate
• VIEW & GET: Promotion from TB Privilege
• VIEW & GET: RoomNo from TB Department
• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Register.GroupType, Register.SourceType, Register.SourceCompany, Register.Promotion, Register.PaymentType, Register.DepositAmount, Register.DoctorCode, Register.AdultQuantity, Register.ChildQuantity, Register.FlightNo, Register.ArrivalDate, Register.ArrivalTime, Register.ExpectedDeparture, Register.DepartureDate, Register.ReferSource, Register.ReferPeople, Register.RoomNo, Register.Status, Allergy.AllergyCode, Allergy.Action, Immunization.Immunizecode, Immunization.Dose1_Date, Immunization.Dose2_Date, Immunization.Dose3_Date, Immunization.Boost1_Date, Immunization.Boost2_Date FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Register, Allergy, Immunization

  UPDATE ResponsePerson, Place FROM DocumentControl

Transfer Register / Change Room

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT GroupType, SourceType, SourceCompany, Promotion, PaymentType, DepositAmount, DoctorCode, AdultQuantity, ChildQuantity, FlightNo, ArrivalDate, ArrivalTime, ExpectedDeparture, DepartureDate, ReferSource, ReferPeople, RoomNo, Status FROM Register

• VIEW & GET: RoomNo from TB Department
• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Register.GroupType, Register.SourceType, Register.SourceCompany, Register.Promotion, Register.PaymentType, Register.DepositAmount, Register.DoctorCode, Register.AdultQuantity, Register.ChildQuantity, Register.FlightNo, Register.ArrivalDate, Register.ArrivalTime, Register.ExpectedDeparture, Register.DepartureDate, Register.ReferSource, Register.ReferPeople, Register.RoomNo, Register.Status FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Register

  UPDATE Register SET Status = Finish of previous register

Nurse Station

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT GroupType, SourceType, SourceCompany, Promotion, PaymentType, DepositAmount, DoctorCode, AdultQuantity, ChildQuantity, FlightNo, ArrivalDate, ArrivalTime, ExpectedDeparture, DepartureDate, ReferSource, ReferPeople, RoomNo, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, NurseStation.Weight, NurseStation.Height, NurseStation.Temperature, NurseStation.PulseRate, NurseStation.Respiratory, NurseStation.BloodPressure FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, NurseStation

Folio / Order Entry

like a financial management system

Dispensing Pharmacy

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT GroupType, SourceType, SourceCompany, Promotion, PaymentType, DepositAmount, DoctorCode, AdultQuantity, ChildQuantity, FlightNo, ArrivalDate, ArrivalTime, ExpectedDeparture, DepartureDate, ReferSource, ReferPeople, RoomNo, Status FROM Register

• VIEW & GET: Order No from TB OrderHdr -> OrderDtl 

  SELECT OrderHdr.Populate, Populate.Prefix + Populate.FirstName + Populate.MiddleName + Populate.LastName + Populate.Suffix, PopulateContract.ContractName, PopulateContract.Address, OrderHdr.Saleman, OrderDtl.Library -> Inventory, Inventory.Name, OrderDtl.Quantity, OrderDtl.Unit FROM Populate, PopulateContract, OrderHdr, OrderDtl

• VIEW & GET: Verify a substitute drug from LibraryReference

  SELECT Code, RelationShip, Relative, Unit, Rate, Amount FROM LibraryReference

• VIEW & GET: Verify a drug from  TB Drug (Extends Library)

  SELECT GenericName, BrandName, Unit, Frequency, Dosage, Instruction, Indication, Caution, SideEffect FROM Drug

• VIEW & GET: Dispense Person from TB Populate

  SELECT Prefix + FirstName + MiddleName + LastName + Suffix FROM Populate

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, PharmacyTrans.Date, PharmacyTrans.Drug, PharmacyTrans.DispensePeople, PharmacyTrans.Unit, PharmacyTrans.Quantity, PharmacyTrans.Frequency, PharmacyTrans.Dosge, PharmacyTrans.Instruction, PharmacyTrans.Indiction, PharmacyTrans.Cution, PharmacyTrans.SideEffect FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, PharmacyTrans

Check-out / Discharge

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT PaymentType, DepositAmount, DepartureDate, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Register.DepartureDate, Register.Status FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Register

  UPDATE DepartureDate, Status FROM Register

House Keeping

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Employee from TB Populate -> Populate -> Employee

  SELECT Prefix + FirstName + MiddleName + LastName + Suffix FROM Populate

• VIEW & GET: Supply from  TB Library or Inventory
• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, OrderHdr.PopulateAddress, OrderHdr.ReferQuotation, OrderHdr.PaymentTerm, OrderHdr.Credit, OrderHdr.Saleman, OrderHdr.Approval, OrderHdr.ShipVia, OrderHdr.ShipDate, OrderHdr.ShipAddress, OrderHdr.Promotion, OrderHdr.DueDate, OrderHdr.LCBank, OrderHdr.LCNo, OrderHdr.LGNo, OrderHdr.LGBank, OrderHdr.TotalAmount, OrderHdr.DiscountPercent, OrderHdr.DiscountAmount, OrderHdr.VatPercent, OrderHdr.VatAmount, OrderHdr.NetTotalAmount, OrderHdr.FreightType, OrderHdr.FreightCorporation, OrderHdr.FreightAmount, OrderHdr.InsuranceCorporation, OrderHdr.InsuranceAmount, OrderHdr.CurrencyCode FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, OrderHdr

  UPDATE Status FROM Department

Guest Request / Loss & Found

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT Original, People, RoomNo, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, GuestRequest.Date, GuestRequest.Department, GuestRequest.Library, GuestRequest.Quantity, GuestRequest.Duration, GuestRequest.Message, OrderHdr.PopulateAddress, OrderHdr.ReferQuotation, OrderHdr.PaymentTerm, OrderHdr.Credit, OrderHdr.Saleman, OrderHdr.Approval, OrderHdr.ShipVia, OrderHdr.ShipDate, OrderHdr.ShipAddress, OrderHdr.Promotion, OrderHdr.DueDate, OrderHdr.LCBank, OrderHdr.LCNo, OrderHdr.LGNo, OrderHdr.LGBank, OrderHdr.TotalAmount, OrderHdr.DiscountPercent, OrderHdr.DiscountAmount, OrderHdr.VatPercent, OrderHdr.VatAmount, OrderHdr.NetTotalAmount, OrderHdr.FreightType, OrderHdr.FreightCorporation, OrderHdr.FreightAmount, OrderHdr.InsuranceCorporation, OrderHdr.InsuranceAmount, OrderHdr.CurrencyCode FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, GuestRequest, OrderHdr, OrderDtl

Delivery / Newborn

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT Original, People, RoomNo, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Delivery.Gravida, Delivery.Parity, Delivery.BirthType, Delivery.Gestation, Delivery.BloodLose, Delivery.PPH_Flag, Delivery.Episio_Flag, Delivery.TearDegree, Delivery.Anaesthetic, Delivery.AnaesDoctor, Newborn.Weight, Newborn.Length, Newborn.Circle, Newborn.Apgar1, Newborn.Apgar5, Newborn.Doctor, Newborn.DeliveryDoctor, Newborn.DateOfBirth, Newborn.TimeOfBirth FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Delivery, Newborn

Enter Test Result (LAB and X-Ray)

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Registerx

  SELECT Original, People, RoomNo, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, TestResultTrans.Library, TestRewultTrans.SerialNo, TestResultTrans.ValueResult, TestResultTrans.Result FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, TestResultTrans

Diagnosis

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT Original, People, RoomNo, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, Diagnosis.Date, Diagnosis.Doctor, Diagnosis.ICDCode, Diagnosis.Symptom, Diagnosis.Action FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, Diagnosis

Medical Record

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: previous register and Status = Check-In from TB Register

  SELECT Original, People, RoomNo, Status FROM Register

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, DocumentMovement.ResponsePerson, DocumentMovement.Place, DocumentMovement.Reason FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, DocumentMovement

Statement / Invoice / Recieve

like a Financial Management System

Last update : Monday, 7 January 2002 07:00 ( Thailand )

Apple, Mac, iMac, iPhone and iPod are trademarks of Apple, Inc.

Jini, Java and all Java-based are trademarks of Oracle Corporation.

JiniSoft Corporation

Copyright @ 1990 - 2012   Mr. Roongroj Rojanapo ( )

89/1 Khao Lam Road, Saen Suk, Chon buri District, Chon buri 20130, Thailand

E-mail

:

roongroj @ jinisoft.com ( JiniSoft @ Facebook & Line )