Introduction and
System Administrator’s Guide
RW CAREWare 4.0
Release date: Fall/Winter 2004
From stand-alone to wide area
network: A scalable software application for managing and monitoring HIV Care
|
Section
1 Overview |
NOTE: A FEW UPDATES HAVE BEEN MADE TO THIS MANUAL. FOR THE MOST RECENT VERSION, DOWNLOAD THE PDF FILE.
RW CAREWare is undergoing a major transformation. The current version of CAREWare is built in Microsoft Access 2000 and runs as a stand-alone application (on one PC) or on a local area network or LAN (a handful of users in one building, for example). In version 4.0, CAREWare will be re-created in an entirely different format called .NET (dotNet) and will be designed to run on a wide area network or WAN or over the internet, although it will not run through your browser (such as Internet Explorer or Netscape, see below). You will still be able to run version 4.0 on a single, standalone PC, as many users do now in version 3.x. In addition, there will be a “store and forward” option that will allow providers to remain disconnected from the network but send data in batch to the central administrator on a regular basis.
But the major new feature of version 4.0 of CAREWare is that it will run on a wide area network or over the internet, thus enabling the real-time connection of providers within a grantee. Such a connection will clearly facilitate the sharing of important treatment and service data, allow for referral messages to be sent directly to network provider participants, and eliminate the need to re-register clients each time they enroll at a new provider on the network. For the grantee, the centralized database will be a rich source of unduplicated client information for immediate analyses of the quality of care, needs assessment, and the rapid creation of aggregate reports such as the CADR.
Providers that currently run CAREWare version 3.x on a LAN and who experience data corruption problems will also benefit from version 4.0, which will be infinitely more stable. Part of this increased stability is due to the fact that the database in Version 4.0 will be built in Microsoft SQL server and not in MS Access. SQL Server is designed to serve many simultaneous users.
IMPORTANT NOTE: As with current upgrades, your CAREWare database will be automatically converted to the appropriate format when you apply version 4.0. However, version 4.0 will not convert CAREWare databases from any version prior to 3.6, so please upgrade to the latest version now!
Changes introduced by Version 4.0 obviously affect the HIV data collection world
a great deal, introducing a number of data sharing and reporting features that
will be of benefit to clients as well as the many reporting and quality management
needs of providers and grantees. However, because sensitive, personally identifiable
health information will now be stored centrally on one computer or server -
likely to be managed by the grantee - a number of new security and confidentiality
issues also arise that must be managed properly and carefully.
Below we discuss briefly the implications of HIPAA for the network version
of CAREWare.
Main Features / Requirements
CAREWare version 4.0 will look and “feel” like the current version, but the new data sharing arrangement will, as noted, alter things considerably, and will likely require greater coordination and communication among participating providers; Grantees’ roles will expand as they will now also serve as central database administrators.
Sharing Data and Granting Access
Rights
First, let’s review how data will be shared in the new version, and how access rights to the system and to specific data will be granted and administered. As an example, we’ll consider an (imaginary) Title II grantee that funds 30 providers across their state; these providers offer the full range of services funded by the CARE Act. In the part of the state with a higher prevalence of people living with HIV, there are multiple primary care providers, substance abuse and mental health agencies funded by the CARE Act. There are also likely a handful of providers in this state that do not want to join the network, perhaps because they already have a well-established health information system in their hospital or clinic.
NEED-TO-KNOW: Version 4.0 will have a great deal of flexibility with regard to granting and denying access to which users can view and/or edit data. Users on the network access client data on a “need-to-know basis”-that is, they can see and share client data when it is necessary, and be denied access to client data when it is unnecessary. This arrangement is obviously a critical data privacy feature of version 4.0.
In this section we refer to two domains: the central domain, typically the grantee - and the provider domain. In conjunction with providers, the grantee administrator will create users ids and passwords at the provider level, but it is the grantee administrator that ultimately has the authority to create (and revoke) user IDs, and expand or limit how an individual user at a provider may access data.
Providers will designate their own administrator; the provider administrator will have full read/write access to the data entered at their agency only while the grantee administrator will manage the full central database contributed to by all providers on the network. The provider administrator will, in turn, assign users and determine access rights at their own agency, but all rights at the provider level are ultimately controlled by the grantee administrator.
In version 4.0, there will be a great deal of flexibility in creating user accounts. Certain users may have full read/write access to their agencies’ data, while access rights of other users may be more restricted to entering or viewing only certain parts of the data such as demographic and service screens or case notes only. (Note that read access means that you can only view the data and cannot edit it; write access means that you can change or edit the data.)
Grantees will obviously play a number of important roles overseeing the daily technical functioning of the network; they will also be charged with overseeing the proper use of the system, examining audit trails of how the system is being used and who is using it. Provider administrators also play a critical role in overseeing the daily functioning of their agency’s database operations and use of the system.
Important rules and security
Before we move on, it is important to clarify some important features of
data sharing in version 4.0.
n
If you elect to share data with another
provider, you share data ONLY on the clients that you have in common with that
other provider; in short, I can never see information on clients served at
your agency that I don’t also serve; that would clearly not meet the need
to know criteria.
n
Providers can never edit another provider’s
service (and most other) data for shared or common clients; this information is
“owned” by the provider that rendered the service. Some data, though, are
shared. (See below for an outline of common/shared data.)
n
In network configurations, all data, including
personal identifying information such as names, dates of birth, addresses,
etc. are stored centrally on the grantee administrator’s database server (the
data tier). Of course, as we will outline below, all data transmitted in
version 4.0 will be encrypted and will require a public/private key to decrypt
this information. Client-identifying
data will also be further encrypted on the central data tier as well. Please refer to the accompanying
system-administrator document for technical information on encryption of data
in CAREWare4.0.
n TO SHARE OR NOT TO SHARE: Upon setup of the network version 4.0, each provider must determine which (and whether) other providers, or provider types, can view their own service data when they share a client. In addition, there are some important differences in how service and demographic/clinical information and case notes are handled. These features are outlined below.
For
service records,
there are 3 levels or data-sharing configurations available to the individual
provider:
n
Level I: All other providers can
view your own agency’s service records; this is obviously the most open
setting.
n
Level II: A provider shares service records only with other providers
that offer the same service type;
for example, a primary medical care provider would share service records with
other medical providers (a service “need to know” basis) on the network. However, if a primary care clinic also offers
mental health services, a second primary care provider that does not offer
mental health services would only be able to view medical care services and not
the mental health service records from the other agency for the clients they
share.
n Level III: Do not share service records with any other providers.
Client-by-client option
To accommodate
special client requests, providers using either Level I or II may also share
services on a client-by-client basis.
Providers who choose this option will grant specific providers
permission to see specific clients’ service records. Other providers may request to view a
particular client’s service records, and the original provider, in conjunction
with the client, may grant or deny permission.
n Requests made of other providers on the network - for example to view data or make a referral - can be made through a convenient internal messaging system.
Unlike service records, which are “owned” by each
provider that renders services to a given client, demographic and certain clinical
data will have common ownership.
Demographic Data
By definition, each unique client appears only once in the central network database; there is no duplication. Furthermore, there is only one demographic record per client; even if a client is served by multiple providers in the network, there is only one demographic record for that individual. If a provider with appropriate access rights changes a client’s name or address, those changes will be seen by another provider when that client’s record is brought up the next time. There are 2 exceptions here: the client ID field, which is customizable and often used by providers to store their own unique client identifier, and enrollment status. These two fields are not “common” and may differ, of course, across providers. It is quite likely, for example, that a client is active at one provider and inactive at others in the network.
The obvious benefit of having common demographic data is that once a client is registered in the system, this information does not need to be re-entered.
Common Clinical Data
Like
demographic data, the following clinical information is common to all providers
who have rights to view and
edit that data:
n Medications
n Diagnosis history
n Immunizations
n Pregnancy history
n Annual data in the Clinical Review section of CAREWare
Again, by common data, we mean that the information in these clinical fields is not “owned” by specific medical providers. For example, there would not be ten medication records for a given client, each for the ten medical providers that might have prescribed antiretrovirals to a given client in the network. Rather, there will be one medication file. The clear benefit of this is that duplicate or contradictory information on medication history (or history of diagnoses, or pregnancies) across different providers is avoided; the client’s complete record capturing this info is stored in one location, and the client would not need to recall his/her medication history each time they were seen by a new clinician in the network. It is also important, of course, that only specific users at a provider are granted the right to view and/or edit these common clinical data types.
Provider-specific Data Types
Unlike the common data outlined above, the following data do maintain a unique relation to the provider that entered the information, and version 4.0 restricts other providers’ access to these data:
n Service Data (described above)
n Enrollment Status, Client ID, provider eligibility (described above)
n Vital signs
n Labs
n Screening Labs
n Screenings
n Case notes (see below)
n Referrals
The
example of John Doe
Let’s say Provider #1 in the network first sees a client named John Doe in 2002. Provider #1 offers primary care and mental health services. In the next year, Mr. Doe enrolls at primary care Provider #2 across town, but also in the network. Let’s also say that these 2 providers were already set up to share service information (Level II described above). (If they hadn’t been, provider #2 may have requested from provider #1 the right to view but not edit this data—you can never edit another provider’s service data!)
Now, when the data administrator at provider #2
with read/write access to John Doe’s record finds his record following a
database search, a couple things occur. First, Mr. Doe’s demographic data are
completed, but could be changed if this were deemed necessary. For example,
maybe his address had changed, or his race was entered incorrectly. Remember,
these edits are possible at provider #2 because a) demographic data are common
fields and 2) the user accessing the system has been granted the appropriate
rights to edit these fields. Note that
through an audit trail, the central administrator can track how often specific
fields are modified; this is an important way of overseeing the integrity of
the database and ensuring that records
are not being unnecessarily changed or modified.
Now say that provider #2 goes to the service tab. Because service records are not common, but owned by the provider, provider #2 may add services and view the services Mr. Doe received at the Provider #1, but cannot edit any of the services entered by another provider.
Case
Notes
Because of the additional sensitive nature of case notes, the
network version of CAREWare will allow the following sharing arrangements:
n Rule-based sharing: users at other providers will be able to view case notes if they are granted sufficient permissions
n No sharing: no other providers can view the case notes entered by a specific provider
Store and Forwarding
For
agencies electing not to join the real-time network, version 4.0 will allow
for store and forwarding of data. Store
and forwarding simply means that the agency will export all or part of their
database to the central domain on a regular basis. This will ensure that the main database stored
on the grantee’s server will contain the client level data from all providers,
whether or not they are joined to the network. However, the provider electing to store and
forward their data will not, of course, have access to other providers data
in real time as they are not connected to the CAREWare network. Grantee administrators will be able to establish
read only access accounts for store and forward providers.
Table 1. Summary of version 4.0 Roles, User types, Rights and Permissions
|
Role in RW
CAREWare 4.0 |
User Types |
Possible
Rights and Permissions |
|
Real-Time Central Administrator |
Grantees, Data Directors, Computer Administrators |
Read/Write access to all domain contact information in system Create/Edit central and provider domain user accounts |
|
Store and Forward Central Administrator |
Grantees, Data Directors, Computer Administrators |
Read/Write access to current Grantee contact information |
|
Real-Time Provider Administrator |
Provider, Data Directors, Computer Administrators |
Read/Write access to provider domain contact information Create/Edit provider domain user accounts |
|
Store and Forward Provider Administrator |
Provider, Data Directors, Computer Administrators |
Read/Write access to current provider contact information Create/Edit provider domain user accounts |
|
Central User |
Data Entry, Data Monitor, Care Givers |
Read/Write access to certain client data modules of assigned domain(s) client data |
|
Provider User |
Data Entry, Data Monitor, Care Givers |
Read/Write access to certain client data modules of current domain client data |
|
Installation/Maintenance personnel |
System Administrators, Network Administrators, Applications Administrators, |
|
n An internal network messaging system that will enable providers to send referrals and other messages such as system updates to contributing network members. A bulletin board will also allow the grantee administrator to send messages across the network.
n
Controlling Contract expenditures for each
service: Grantees will have the ability (from the central domain) to create
contracts that limit spending by service type.
The following options will be available:
Subservice cut-off: Grantees can
decide that providers who reach the annual expenditure limit for a subservice
will no longer be able to enter data for that subservice.
Nag screen: Some grantees may not
want to prevent data entry. They will,
though, be able to implement a warning message that appears evrry time the
provider enters a record for a service whose annual limit has been reached.
HIPAA Compliance
The network version of CAREWare has a number of features that will ensure compliance with HIPAA in a variety of ways. But it is important to remember that the data privacy and security requirements of HIPAA require the trust of the individuals running and managing and using the system at the provider and grantee level; it’s not ONLY the responsibility of the computer hardware and software!
Nevertheless, there are many features of version 4.0 that are critical to maintain the security of the data, and ensure that only authorized individuals see only the information they need to see to provide services.
n Passwords which limit access to view or edit data
n No access after three failed logon attempts
n Grantee can set a number of days after which passwords must be changed
n Role-based and need-to-know access: Very flexible data sharing system to restrict user access to and ability to view only specific parts of the database
n Full data encryption over the network through the .NET system
n Client identifying information-name, date of birth- is encrypted in a string when it is stored in the database
n Audit trails that enable the grantee administrator to oversee who was logged in and made specific changes to the database
|
Section
2 System Administrators |
Background
This section is designed to provide System Administrators the information they will need to design and manage a computer system on which to run RW Careware 4.0. It will:
n Give system requirements, both hardware and software.
n Provide and overview of the 3-tier architecture used in RW Careware.
n Discuss security of client information, including encryption techniques used in storing and transmitting data.
n