Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
[...] All activated fields do not display on custom subform tabs All relation field selections generate error on custom reports All services are returned for a Regional User Annual Custom Review data entered on Custom Form not saving Annual Review data not saving when changing to custom tab 1, 2 or 3 Annual Review data not shared on 3rd provider domain instantly Appended case notes do not save Appointments check box in PDE setup has to be checked every export Appointment status [...]
The Data Translation Module (DTM) is a utility designed to parse flat text files in a CSV format, or Excel files, and create an Access database template file that can be easily imported into CAREWare through the Provider Data Import (PDI). You can download the latest version here. You can view the manual here . To review the specifications for the Provider Data Import tables click here . For instructions to setup CAREWare for automatic DTM imports click here . Click here for FIPS County and State reference [...]
[...] ADR 2017)
RSR updates to resolve timeout errors.
Update to the add attachment process to throw an error if the file doesn't exist.
Updated SQL PDI to process records with NULL values in the processed field.
954 ( ADR 2017)
Added a separate permission for editing common notes.
Made it so that mailing address fields could be viewed by users who do not have permission to edit address fields.
HL7 socket interface update.
953 ( ADR 2017)
ADR bug fixes.
PDI medication update.
952 ( ADR 2017)
ADR Schema update.
HL7 socket unmapped client unduplication. [...]
[...] field in CAREWare and drag and drop it on your own screen, in any location, just as you might create a data entry screen in MS-Access. The main impetus for building the Form Designer was that users found it cumbersome to have to click a number of buttons to get to different locations in the application—jumping back and forth between the Services screen, then maybe clinical encounters to enter vital signs or diagnoses, and then case notes, etc. The form designer largely eliminates the need to jump around by allowing the user to place all the critical fields for data [...]
CAREWare Tips for ADAPs: Key Areas That Impact ADR Data Quality CAREWare is a free, electronic health and social support services information system for HRSA HIV/AIDS Bureau Ryan White HIV/AIDS Program recipients and subrecipients. It produces a compliant xml file for the AIDS Drug Assistance Program (ADAP) Data Report (ADR) as well as the Ryan White Services Report (RSR). In order to ensure that you submit the highest quality data in the ADR, it is important to understand how different CAREWare features work, [...]
There are several good ways to import data into CAREWare, though these processes can be quite complicated for novice users. This wiki page summarizes the three most common methods and provides links to relevant documentation.
Provider Data Import (PDI) The Provider Data Import (PDI) allows users to import their clinical data from other electronic health record applications into CAREWare using a pre-defined Access or XML template. Once one or more files are ready for import, users [...]
We are getting the following error when running a custom report and selecting the New Clients option. Source: - An error occurred while attempting to run the custom report.
If the problem persists, please contact technical support.
Operand type clash: uniqueidentifier is incompatible with datetime
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, [...]
The Provider Data Export is used to export data from selected tables for a specified date span. Data exported from a single provider domain can be edited and re-imported. Data exported for multiple provider domains can be used for reporting purposes and cannot be re-imported. A Provider Data Export file can include provider setup information and metadata. To access the Provider Data Export: Click Administrative Options . [...]
This error occurs when the field selection, "Primary Provider" is selected, and "Group by Provider" is checked.
The multi-part identifier "srv_dmn.dmn_pk" could not be bound.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader [...]
Latest version: *The CAREWare build number that works with the Data Translation Module version is indicated near the Data Translation Module version number. Data Translation Module 2.3.1 (865 or newer) Added ability to map incoming values to a new value.
Previous versions: Data Translation Module 2.1.3 (865 or newer) Fixed bug with case notes Data Translation Module 2.1.1 (865 or later) CSV headers can now be more than one line A single CSV [...]
There are a number of ways to export data out of CAREWare available to users. These export processes can be quite complicated for novice users and we have gathered together all of the available documentation here for each export process. These documents allow users to export data in several formats. Each of the available export methods is described below in brief. Provider Data Export (PDE)
The Provider Data Export (PDE) allows users to export their clinical data [...]
[...] occurring errors in CAREWare. These are normally caused by configuration issues within the Business or Data tiers. Receiving error: Login failed for user 'cwbt' Receiving error “The application failed to initialize properly (0xc0000135)” when attempting to install RW CAREWare. Received Error: SQL Server does not exist or access is denied Receiving Error: Unable to connect to the remote server Receiving error: Invalid URI: [...]
When running a cross tab Custom Report with no From/Through dates an error is generated. If details supplied it works. Source: - An error occurred while attempting to run the custom report.
If the problem persists, please contact technical support.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime [...]
[...] @wdl_ts_enabled1
Parameter values were:
@wdl_ts_enabled1 = True
Verbose Stack Trace Information: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
[...]
The Provider Data Export (PDE) allows CAREWare users to export CAREWare data into an Access template file. This is similar to the Provider Data Import (PDI) and uses the same Access template file. The PDE includes the ability to export custom fields from CAREWare into the Access file. The steps below provide the necessary information to create a customized PDE template file. To export custom data you must be logged in to the Central Administration domain. From there you choose the [...]
[...] status field as a custom filter to the no test in X days or any other canned report the following SQL Error is generated. The is no way to edit these reports for enrollment status currently. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
at System.Data.SqlClient.MetaType.FromDateTime(DateTime [...]
[...] from Contracts and that funding source has been included in the WICY Report Funding section then the error below will be generated. In order to work around this error a user must remove the custom funding source from the WICY report funding section prior to deleting the funding source Source: - An error occurred while saving provider setup information to the database.
If the problem persists, please contact technical support.
The DELETE statement conflicted with the REFERENCE constraint "FK_wic_fn_fnd_sr_rpk". [...]
Deleting custom reports generates an error. When we add foreign keys to new tables, we forget to add the delete statement for that table when deleting the root table
a record off the root table rather that must be a new table. Error is:
Source: jProgBusiness - The DELETE statement conflicted with the REFERENCE constraint "FK_grp_srv_rpr_sp_fk". The conflict occurred in database "CW_Data", table "dbo.cw_group_service_report_map", column 'grp_srv_rp_rpr_sp_fk'.
The statement has been terminated.
at System.
[...] (Connect()).]SQL Server does not exist or access denied.
Invalid connection string attribute
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup
poolGroup)
[...]
The error "No matching client record found" can occur when users create a Provider Data Export when there is an orphaned client record. This can be resolved by using the Orphaned Record Cleanup tool by following the instructions here . If this tool is not available, upgrading to a newer build of CAREWare of 847 or newer (except 848) is recommended, as it includes this and several other new features. To review build changes, bug fixes, and new features added to CAREWare, click here . The cw_events error message [...]
Some users have reported a sporadic error message when entering or importing medications for clients or when running custom reports. The error message is: Event is on the wrong date. at jMultiTier.jMultiTier.jDrugEventDateGrouping.Add(jDrugEvent DrugEvent) at jMultiTier.jMultiTier.jDrugEventGrouper.Add(jDrugEvent DrugEvent) at jMultiTier.jMultiTier.jRegimineDecoder.AddDrugSpan(jDrugSpan DrugSpan) at jProgBusiness.jBusiness.RGM_BusinessSideOperations.clientRegimenManager(String sessionToken, String DomainPK, String clientPK, Boolean [...]
The Data Translation Module automatically processes import files and produces Provider Data Import files as long as the Data Translation Module service is started. The Destination Folder can be configured to match the PDIFiles folder, which is used for the automatic Provider Data Import process. Instructions to set up the automatic Provider Data Import process are here . Go to C:\Program Files (x86)\jProg\DTM. Right click Data [...]
[...] information:
The location of the issue; i.e. in CAREWare, on the server housing the business or data tiers, on the custom reports field selection screen, what feature are you using, etc. The Details of the error message that occurred, if any occurred Highlight the entire error message in the Details box and press Ctrl-C to copy the message, then go to your email account and in a new message press Ctrl-V to paste the details into the email. What CAREWare build are you using? You can email the CAREWare Help [...]
Providers on a real-time network have the option of sharing service and clinical data with other agencies. Sharing data with other providers who have a need to know specific information about clients they also serve has many advantages: Agencies can avoid duplication of services, save time spent tracking down clients’ services at other agencies, and get a more comprehensive picture of a client’s needs. Clinics can avoid expensive duplicate tests and potentially dangerous medication interactions if clinical data [...]
[...] custom report that has a deleted custom field or depreciated CAREWare object results in the following error being generated on the central administration domain Source: jProgBusiness - The DELETE statement conflicted with the REFERENCE constraint "rlt_fld_sl_slc_fl".
The conflict occurred in database "CW_Data", table "dbo.cw_select_field", column 'slc_fl_fld_sl_fk'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
[...]
Creating an 837p File will generate an error if the provider domain, insurance provider, or client record does not have a full nine-digit zip code, without any dashes or spaces. For example, 70003 would cause an error, as would 70003-4463, but 700034463 would be fine. If fewer than nine digits are entered, these error messages will appear: Error: Insurer Zip Code does not meet the 9 digit requirement. To resolve this error, update the zip code to [...]
An error occurred when creating a RDR report for multiple providers. This error has been resolved as of build 876. Click here for the business tier cw_events error [...]
ADR — 0.3%
[...] report being rejected upon upload to the EHB. Custom reports can be used to validate the ADR client data and verify if clients should be included in the ADR report. Click
here for a custom report to review ADR clients with and without Ryan White funded services. Here are instructions for uploading the custom report into CAREWare.
Note: In order for a client to be included in the ADR Client Report, the client must have an Enrollment History record of "receiving services," "on waiting list," or "services not requested." The client's last enrollment record remains [...]
[...] database must operate in multi-user mode in order for the cwbt and sa logins to have access to the cw_data database. The cw_data database can revert to single-user mode if an incorrect sa password is entered when restoring the database from a backup when following the instructions here . To set the cw_data database back to multi-user mode from single-user mode: Stop the CAREWare business tier by following the instructions here . Connect to the CAREWare SQL Server database instance using SQL Server Authentication [...]
Users processing custom fields using the Data Translation Module may experience the following error: Error on record 2: Column 'Custom Field Name Here' does not belong to table Table. This error can be reviewed in the log file in the Logs folder located at: C:\Program Files (x86)\jProg\DTM\Logs by default. The error occurs because the custom field was not a column in the PDI file. If the option Create Single File was checked, previously processed imports [...]