(#217) – Moving SOS to a New Computer

The following instructions are for standalone installations, where the application software and the database are on one computer. For server migration, this article should be consulted.

Many practices are finding that their old hardware has become outdated. While those old machines have provided excellent service, they have become too slow, too limited in RAM, and […]

Emdeon- Electronic Claims Module

SOS Electronic Claims – ANSI Module for Emdeon tm

Filing claims electronically is designed to save you and your payers time and money. In order to make that happen, claims must meet certain standards. Paper filing is more forgiving than electronic filing can be; a human being is never involved in the electronic […]

Performance Tip: Match Server CPU and RAM to the Number of Users on Your System

RAM

If you call SOS with a complaint about software performance, the first thing a technician will check is the amount of RAM you have configured for the database to use for cache. The larger your cache, the more of your database that can be copied from the relatively slow hard drive to much […]

Mail Merge Labels in Word Using Query Results

This document presents a sample query that, when run using the SOS-supplied DBISQL utility, produces an EXCEL file that can be used as the data to produce a set of mailing labels in MS Word. There is a document on the SOS web site that describes how to run queries:

http://www.sosoft.com/queries/how2010/

Specifically, it selects from […]

Automatic Selection of Data Source When Starting DBISQL

Normally when you open the DBISQL query utility, you must provide your SOS User ID, your password, and select the data source:

Because of the potential security risk, you would not want to default values for your ID and password, but it would be a convenience if there were a way to automatically select […]

Creating and Maintaining a Custom Droplist in First Contact

The following is a further elaboration of the feature documented in the First Contact User Guide, in the FCConfig – Field Selection and Options section.

In that section there is a discussion about changing text entry fields to droplists that are populated with selections you maintain from the My Lists screen in First Contact. It mentions […]

How to Batch Claims Using Carrier Category

At times it is desirable to batch claims according to a particular payor or payors. Examples include:

Generating a batch of Medicare paper claims using the Medicare-specific formats. Generating electronic claim submission files for just selected payors.

The most efficient way to proceed is by using the Carrier Category setting on the Additional tab of […]

Copy and Paste of Treatment Planning Details

At times it is desirable to have the same detail description in several Treatment Plan classes. For example, let’s say that you have created a detail for the specific symptom "sleep difficulties" in the Problem class "Depression". This symptom is common to many problems, so SOS provides a quick way to copy the new detail […]

Emailing Reports From First Contact

While secure email systems are available to send documents containing Protected Health Information (PHI), most regular email transmissions can be intercepted and viewed by parties other than the intended recipient. For this reason, it is a best practice to send such documents as encrypted, password-protected, PDF files.

When viewing an intake form in First Contact, […]

Querying SOSDATA from within MS SQL Server

A Microsoft Linked Server can be created that uses the SQL Anywhere OLE DB provider to obtain access to a SQL Anywhere database. SQL queries can be issued using either Microsoft’s 4-part table referencing syntax or Microsoft’s OPENQUERY SQL function. An example of the 4-part syntax follows.

SELECT * FROM SOSDATA..SOS.Patients

In this example, SOSDATA […]