Intalling Lytec and first set of queries

Download the Lytec Medical Database product at: http://www.lytec.com/product/2006/pm2_professional.asp. Click "try it" to get a free download. You will need to enter something, but you can put in anything. Use a real email (one that can be spammed) so they can send you a registration key.

When installing:

• Be sure to have the "Install Tutorial Files" checked (and it is the default).
• Allow it to use the default c:\lytecdata. It will have trouble if you pick another.
• Go ahead and install crystal reports and the sql server. If you don't have much space though, skip crystal reports.
• Make sure you select the server install if you get the option between server or client. I don't think that is a choice though.

To get the server password, you will need to open the Lytec program after you install it:

• Start / program / Lytec
• When you open lytec, it will ask you for a database name. Choose the Lytec_sql database it created as the server.
• Then choose ok.
• When it opens, it will open to a blank practice list.
• Choose the "add tutorial" button and then double click on the tutorial.
• Then choose settings / server logins
• Copy the Admin password to use when you access the database.

Connect to Lytec from MS SQL:

• Open MS SQL (start / program/ ms sql / server management )
• you are given an option to connect to a database. Down arrow, and the Lytec database should be available. (This will only be available after you open Lytec and go through creating the database and adding the tutorial as described above.)
• Instead of windows authentication, use SQL server authentication. Enter the Admin login and password from Lytec's setting / server logins option.
• Once you are connected, you want the Lytec Tutorial database, and particulary the Billing Detail, Billing Header, Patient Type, Patient, and Transaction Code tables.

In Lytec, their help text might help you. Go to Help / help topics / Search "patient mapping" and it will tell you all the fields in the patient file.

Let me know if you get stuck. This will take a while to load.

Once it is open, please create the following queries:

1. List all billing headers with the bill number, patient chart number, provider number, primary insurance code, secondary insurance code, creation date, location
2. add some patient info to the query above: patient name, birth date, patient type
3. Create a new query on the bill detail, with the patient chart, bill number, line number, transaction code, amount, service date, charge
4. Add the bill header info the the query above (patient chart number, provider number, primary insurance code, secondary insurance code, creation date, location)
5. Add the patient info to the query above (patient name, birth date, patient type)
6. List the total charged for each order.
7. List the total charged for each patient, including the patient even when the total is 0.