link to home page
link to about PacInfo page
link to services page
link to seminars
link to clients page
link to products page
link to case studies page
link to projects page
link to news page
link to careers page
link to contact page
menu 10
link to site map page

The Santa Barbara Regional Health Authority needed to implement a system for all MediCal providers (clinics, physicians, pharmacies) to determine the eligibility of patients. The state furnishes an ID card to all patients, but the specific eligibility information changes often for many patients. Full and up-to-date eligibility information is available from the state via an SNA 3270 link.

The local agency needed to furnish all providers a PC software application (also implemented by PacInfo) that can read the magnetic information on the ID cards, and connect to the system.

The system consists of several client-server applications. Servers provide overall control of the process, access to the Oracle database through SQL queries, access to the state master eligibility information via the SNA 3270 link, and communications control for the provider connection.

The system accepts modem connections via RS-232 ports, or network connections via TCP/IP sockets through a communications server. When a provider connects to the system, the main server receives the request, converts it to a SQL query, and submits the query to a database server for determination of eligibility. Should the query be unable to be resolved through the local database,

 

Toolbox
Language: C++
Compiler: HP-UX C++
System: UNIX RCS system and HP SoftBench™
Duration: 15 months
Location: Customer 100%

Project Organization
Communication: On-site Specifications: Customer
Software Design: Customer
Software Implementation: PacInfo
Test: PacInfo
Verification: PacInfo/Customer

Home Page Link
the information is submitted to the state master database via the SNA 3270 link using another server. The resulting response from this process is returned to the provider via the communications server.

PacInfo implemented and maintained a group of client/server applications, utilizing RS-232 serial communications, TCP/IP socket communications, SNA communications, and SQL queries to an Oracle database.

Development of both the SNA interface and the TCP/IP socket interface required extensive UNIX system administration work in setting up and automating the access and support applications needed.