lysdyt / isante Goto Github PK

when looking at the patient forms view with data clerk credentials the 
toolbar disappears in google 
chrome only.

The drug group labels in the timeline on the cover page are always
displayed in English, even if the language is set to French. The dates
in the pop-up bubbles are also always in English format, i.e. Thu, 28
Jan 2010 08:00:00 GMT. Also, perhaps the time part "08:00:00 GMT"
should be omitted?

Creation of a new report which could determine the desaggregation of
the number of Discontinued patient by reason of discontinuation.

Investigating VPN for a more reliable connection to servers in Haiti

Outcome - a clear direction in how we are going to try installing VPN.

The tab indices on several forms are not ordered properly making it
difficult/impossible to complete a form using only the keyboard.

This probably isn't high priority, but should be fixed eventually.

What steps will reproduce the problem?
1. Navigate to any registration form.
2. Click on the drop-down list of communes.
3. See "erehwon (erehwon)" as an available option.

What is the expected output? What do you see instead?

That option should not be shown.

Please use labels and text to provide additional information.

In "'VISITE ASSOCIÉE"section, the Date d'initiation ARV accepts date 
beyond today's date. Not sure this is a bug or intentional.

Fedner requested that new reports and Changes in the HIVQual report be added in 
the report definitions document. Reports section in the Change documents for 
the releases has all necessary details and changes. 

Since the earthquake, we have a lot of requests from the sites for particular 
reports. I'm preparing 
a document with all those requests to submit to you. Last weeek, we sat with 
GHESKIO partner 
and they urgently asked for the following. While waiting to have them 
incorporated into the 
system, can I have the queries for them. Those reports will be used at both 
sites and network 
level

1- Could you modify the existing "Clinic Visiting during Given Period" report  
to look like that

Clinic Visiting during Given Period

ST code (With a link on it),Patient’s name,Age,Sexe, Regimen/ARV,Visit date 
scheduled,Effective 
date show-up,Difference days

I've developed a prototype query to satisfy this request. See below:

This query runs only on the Linux version. It can be used on the National 
Server <https://isante-
consolidated.cirg.washington.edu/isante> or on in-country servers running Linux.

It returns the patient's most recent regimen (if any), the most future next 
visit, the most recent 
visit, and the difference in days between the next visit and the most recent 
visit. You must insert 
the desired sitecode in two places:

select q.clinicPatientID, q.patientID, q.fName, q.lName, q.age, q.sex, 
q.regimen, 
max(dbo.ymdtodate(e.nxtVisitYy, e.nxtVisitMm, e.nxtVisitDd)) as 'nxtVisitDate', 
max(e.visitdate) 
as 'lastVisitDate',
datediff(day, max(e.visitdate), max(dbo.ymdtodate(e.nxtVisitYy, e.nxtVisitMm, 
e.nxtVisitDd))) as 
diff from (
    select i.clinicPatientID, i.patientID, i.fName, i.lName, i.age, i.sex, s.regimen from (
        select ltrim(rtrim(p.clinicPatientID)) as clinicPatientID, p.patientID, ltrim(rtrim(p.fname)) as 
fName, ltrim(rtrim(p.lname)) as lName, datediff(year, 
dbo.ymdtodate(p.dobyy,p.dobmm,p.dobdd), 
getDate()) as 'age', CASE WHEN p.sex = 1 THEN 'F' WHEN p.sex = 2 THEN 'H' ELSE 
'I' END as 'sex', 
max(r.visitdate) as rvisitdate
        from patient p left join pepfarTable r on p.patientid = r.patientid
        where left(p.patientid,5) = '<currentSitecode>'
        group by p.clinicpatientid, p.patientID, p.fname, p.lname, p.dobyy, p.dobmm, p.dobdd, p.sex
    ) i
    left join pepfarTable s on s.patientid = i.patientid and s.visitdate = i.rvisitdate
) q,
encValidAll e
where q.patientid = e.patientid and e.siteCode = '<currentSitecode>'
group by q.clinicpatientid, q.patientID, q.fname, q.lname, q.age, q.sex, 
q.regimen
order by q.clinicPatientID

The network version of this query is:

select q.clinicPatientID, q.patientID, q.fName, q.lName, q.age, q.sex, 
q.regimen, 
max(dbo.ymdtodate(e.nxtVisitYy, e.nxtVisitMm, e.nxtVisitDd)) as 'nxtVisitDate', 
max(e.visitdate) 
as 'lastVisitDate', datediff(day, max(e.visitdate), 
max(dbo.ymdtodate(e.nxtVisitYy, e.nxtVisitMm, 
e.nxtVisitDd))) as diff from ( select i.clinicPatientID, i.patientID, i.fName, 
i.lName, i.age, i.sex, 
s.regimen from ( select ltrim(rtrim(p.clinicPatientID)) as clinicPatientID, 
p.patientID, 
ltrim(rtrim(p.fname)) as fName, ltrim(rtrim(p.lname)) as lName, datediff(year, 
dbo.ymdtodate(p.dobyy,p.dobmm,p.dobdd), getDate()) as 'age', CASE WHEN p.sex = 
1 THEN 'F' 
WHEN p.sex = 2 THEN 'H' ELSE 'I' END as 'sex', max(r.visitdate) as rvisitdate 
from patient p left 
join pepfarTable r on p.patientid = r.patientid group by p.clinicpatientid, 
p.patientID, p.fname, 
p.lname, p.dobyy, p.dobmm, p.dobdd, p.sex ) i left join pepfarTable s on 
s.patientid = i.patientid 
and s.visitdate = i.rvisitdate ) q, encValidAll e, clinicLookup c where 
q.patientid = e.patientid and 
e.siteCode = c.sitecode and c.network = '<desiredNetworkCode>' group by 
q.clinicpatientid, 
q.patientID, q.fname, q.lname, q.age, q.sex, q.regimen order by 
q.clinicPatientID

This network query is especially slow. After we finalize the query format, we 
can speed it up.



Who should be able to access/use this new feature?


Please list any partners outside of Itech that you believe will be
involved.

The pdf button in some of the reports generates an error message. They 
need to be diabled until any solution is found.

In the cover page the reason for discontinuation of meds should include 
the whole description or a key 
not just the abbreviation...

Atwood gave a list of normal ranges for certain fields. This is a future 
feature where an alert will show up if the value of the fields is beyond 
the normal range.

See document "ObGyn__LD_forms_validations_By_Atwood.docx" in the download 
section for details

The counseling intake form has no validations. The counseling f/u form
only validates the date fields. There are other rules that could
probably be added.

This probably isn't high priority, but should be fixed eventually.

In the section "REASONS AND SOURCE FOR REFERS" multiple radios can be 
selected.
      1. For "Patient seen for consultation" select  "Obstetrical" and
      "Other" at the same time or "Gynecological" and "Other"
      2. For "Blood group" - I can select A+, O+ and O- at the same
      time, and also other combinations.

This is a problem reported by Fedner from Hopital Fort ST Michel dated 
7.12.09. Here is what he wrote - 

"In the Inactive Patients, the system gives us some patients on
Palliative Care that didn't have yet six months since the last
visit. By example: ST00423, ST00419, ST00427 (status displays:
 active at opening) and  ST00429 ( status displays :
At risk of discontinuation at opening)    {[I think the
problem is the system doesn't take in account the day in the visit
date because for the Palliative Care & ART, the problem occurred
for patients who had at least 5 months and 2 months repectively]}"

Of highest Priority according to Jim

No units are displayed on the new CD4 and weight graphs on the cover page.

What steps will reproduce the problem?
1. For CD4 and all fields with value and % , if I add a value beyond 
accepted range, an error message appears.
2. Then if I add a number greater than 100 for the % field, anothet error 
appears beside the %.
3. If now I correct the % field then both the errors disappear.
4. So the field is saved with a 
value beyond the acceptable limit without an error.

What is the expected output? What do you see instead?
The error message should still be visible beside the value fields.


Please use labels and text to provide additional information.

Request for presenting adult and pediatric patients separately in a report.

Insert in the prescription form two others rows in the `'other 
medications''

What steps will reproduce the problem?
1. click on admistration-->user management
2. edit LDAP attributes
3. change password and hit Submit

What is the expected output? What do you see instead?
Message confirming changes should be displayed
An error screen is displayed instead (refer attachment)

Please provide any additional information below.

environment: cloud
browser: IE 8, Firefox 3.6

Reformating of the report "Patient eligible for ART but non enrolled". 
They would like to have the "Number of distinct patient eligible
for ART but non enrolled"

In the "OBSTETRICAL AND GYNAECOLOGICAL ANTECEDENTS" section, the 
field "Live Children" is accepting negative numbers without errors.

Insert BMI according to an automatic calculus in the cover page

1. While the patient fallowed up on the site it
becomes pregnant, as you know we will not make HIV
diagnoses again for this patient then it's necessary to
deactivated the ''referal Sources, probable mode of
transmission and other risk factors.

2. When the Status is negative or unknown, I think
the system must jump to the previous TB instead of
section Drugs Allergies. 

Pre- arv and arv registries should give some message if returning an empty 
list. Otherwise it is hard to understand whether there is no patient or 
the application is malfunctioning.

Some validation rules cause certain text boxes and checkboxes to be
cleared when they shouldn't. Examples found so far:

1. Adult intake form: in the conditions section, any of the "Other" text
boxes get wiped when the javascript for one of the date fields causes a
validation error.

2. Adult f/u/ form: the "Type 1" and "Type 2" checkboxes get cleared
when javascript validations are run on date fields.

This probably isn't high priority, but should be fixed eventually.

Hello,

Attached is a list of proposed indicators and ‘reports’ for OB and 
Gynecologic care documented in iSante. They are not currently in as detailed 
format as will be necessary for programming. I look forward to your feedback 
regarding needed additions or changes, and feasibility of collecting the 
necessary data.


Thank you,

Mary



Potential epidemiologic and quality of care reports for OB/Gyn ISante data:
These are in addition to standard demographic data, such as age, marital 
status, etc

1.  Presenting complaint (Pregnancy, specific gyn problems)
2.  Pregnancy history (how many prior pregnancies)
3.  Comorbidities (number of women with)
• TB- history, current 
• Hypertension- current
• Heart disease- current
• Syphilis -history and current
• Diagnosis of other STIs (IST) at time of presentation, and during care
• Malaria- history and current
• Cervical cancer- history and current
• Other gyn cancer- history and current
• Sickle cell disease
• Anemia- current 
• Malnutrition (BMI < 18.5, or other?)- current
(current includes new diagnosis at time of visit)
4.  HIV Test
• Number/proportion of women on initial presentation who report never had test
• Number/proportion who get test at first visit (within 3 visits? Within 3 
months? Other?)
5.  Gestational age at time of initial presentation
6.  Loss to follow up numbers (“at risk”)
7.  Number (or proportion) of births in hospitals vs at home
8.  Number (or prop) of pregnant women using attendants
9.  Number-prop of women who have cesarean section
10. Number/prop who receive prenatal vitamins for X period of time (or number 
of prescriptions); other supplements?
11. Birth outcomes- complications
12. Smoking history- need to define- current only? Length of time considered 
significant?
13. Number/prop received child nutrition/breast feeding counseling
14. Number/prop who received family planning counseling


For HIV-positive pregnant patients: all of above, and:
1.  First CD4 ct
2.  OMS stage at presentation
3.  Number of women (proportion) who have not received prior HIV care 
4.  Duration of known HIV status 
5.  HIV-related diagnoses (from HIV form)
6.  Number/prop who receive ART for X period of time 
7.  HIV status of child

Find a way to avoid error in fulfilling the intake or follow-up forms for 
the field `'next visit date'' when the patient will be transferred.

What steps will reproduce the problem?
1. Run any report that deals with pregnancy

What is the expected output? What do you see instead?

Results will not be as accurate as possible since data from the new ob/gyn 
forms is not considered in the report calculations.  Expect more accurate 
results.

What steps will reproduce the problem?
1. Open the demographics tab for any adult patient
2. Notice just a Y beside date of visit date-picker and no dd/mm/yy bedise 
date of birth date-picker
3. Switch back and forth between the adult and pediatric radios
4. Problem gets fixed

What is the expected output? What do you see instead?
Ideally we should see dd/mm/yy beside both visit date and birth date

Please use labels and text to provide additional information.

Insert the Widal test and in the Laboratory forms

If you enter an incorrect date in the date picker it automatically 
calculates forward again... we will 
need to change the config ext file to turn this off as we did with the 
last release-- low priority

Haven't received any specification for this report. 

What steps will reproduce the problem?
1. Login to any 8.0 RC2 installation.
2. Change your user interface to either of the "Data Clerk" options.
3. Search for and select a patient.

What is the expected output? What do you see instead?

Expect to see the patient's list of encounters taking up the full browser
window.  Instead, the list of encounters is in a tiny compressed area and
you have to scroll to view the list.  Selecting an encounter does not fix
the problem and the entire form is displayed in the tiny compressed frame
requiring lots of scrolling and hindering usability of the system.

Happens in IE7, IE8, FF on both Linux and Windows.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?

Expect the drugSummary to contain all start and stop dates for all drugs
for a patient.  It currently only stores the earliest start date and one
randomly-chosen stop date for each drug.

Please use labels and text to provide additional information.

The only code that is currently using the drugSummary table are the
clinical summary report and the 'Treatment History' tab of patienttabs.php.
 Until the drugSummary table is repaired, these pieces of code will not be
displaying accurate drug start/stop information.

Some forms have a problem with clearing validation errors. Even if you
fix all the errors, after you save the form, you receive the "Form saved
with errors" message and the form is marked red in the encounter list. 
Opening the form again shows no errors and if you save again, it saves
without errors. This is due to validation rules not clearing errors
properly for certain fields on certain forms. Here are fields/forms
I've found so far that have this problem:

1. 'pedMotherHistHivArvPregStartDt' & 'pedMotherHistHivArvPregStopDt' on
the ped. intake form.

2. unspecified fields on the adult f/u form.

This probably isn't high priority, but should be fixed eventually.

What steps will reproduce the problem?
1. click pre-arv registry in the registry toolbar
2. view the 'loading' toolbar

What is the expected output? What do you see instead?

While loading the pre-ARV and ARV registry list, the "Loading - please 
wait" message box has shifted 
way to the right and is not visible until we scroll to the right. It will 
be good if the message 
appears on the initial screen otherwise it is difficult to say whether the 
list is loading or their is 
an error.

Please use labels and text to provide additional information.

There should probably be some sort of limit put on the number of
allergies displayed in the "Allergies" panel on the cover page. Right
now, there's no limit, so if the patient has many allergies, the page
becomes very long and requires excessive scrolling.

Request for a new report which will give all the next visit dates for one month 
ahead. Currently we have two reports in "Appointment reminders" section - 
 - Visit scheduled next 7 days 
 - Visit scheduled next 14 days 

stcode(withlink), patient's name, age, sex,  visitdate, regimen, I/0s dispensed 
(non-ARV drugs), 
quantity.

As an initial query, I wrote:

It is sorted ST #, visitdate, drugname. Remember to substitute the sitecode in 
the two places 
below. Again, this must be run on the national server or on Linux servers in 
country. We don't 
exactly capture quantity. Instead i am providing standard dosage, number of 
days prescribed, and 
number of pills, each of which may provide quantity information.

select q.clinicPatientID, q.patientID, q.fName, q.lName, q.age, q.sex, 
q.regimen, v.visitdate, 
v.drugName as 'I/Os dispensed', v.altDosageSpecify as 'Posologie alternative 
dispensée', 
v.numDaysDesc as 'Nombre de jours', v.dispAltNumPills as 'Nombre de pillules 
distribuées' from (
    select i.clinicPatientID, i.patientID, i.fName, i.lName, i.age, i.sex, s.regimen from (
        select ltrim(rtrim(p.clinicPatientID)) as clinicPatientID, p.patientID, ltrim(rtrim(p.fname)) as 
fName, ltrim(rtrim(p.lname)) as lName, datediff(year, 
dbo.ymdtodate(p.dobyy,p.dobmm,p.dobdd), 
getDate()) as 'age', CASE WHEN p.sex = 1 THEN 'F' WHEN p.sex = 2 THEN 'H' ELSE 
'I' END as 'sex', 
max(r.visitdate) as rvisitdate
        from patient p left join pepfarTable r on p.patientid = r.patientid
        where left(p.patientid,5) = '<sitecode'
        group by p.clinicpatientid, p.patientID, p.fname, p.lname, p.dobyy, p.dobmm, p.dobdd, p.sex
    ) i
    left join pepfarTable s on s.patientid = i.patientid and s.visitdate = i.rvisitdate) q,
    v_medsDispensed v
where v.patientid = q.patientid and v.drugID in (select drugID from drugLookup 
where drugGroup 
not in ('NRTIs','NNRTIs','Pls')) and v.siteCode = '<sitecode>' 
order by q.clinicPatientID, v.visitdate, v.drugName

This is a problem reported by Fedner from Hopital Universitaire Justinien 
dated 7.12.09. Here is what he wrote -

"In the report, eligibility  medical but not enrolled (at
Hopital Universitaire Justinien) , the system displays patients
that already enrolled in ART."

Please describe the feature in as much detail as possible, and attach any
information that would be pertinent. For instance, if it is a report
request, please attach a mockup of the report.

Primary care forms will include: adult/pediatric intake/followup (4 forms). 
These are referred to also as "tertiary" care forms, since they will be used in 
the main hospitals, not in small clinics or infirmaries. There are currently no 
plans to automate the lower-level primary care forms for infirmaries.



Who should be able to access/use this new feature?

A wider range of clinicians than are currently supported by the HIV forms, 
though it is intended that the same registration form will be used for both.


Please list any partners outside of Itech that you believe will be
involved.

Nicasky requested this change on 17-Jul-2009, but it has not yet been 
implemented.

Insert in the prescription form '' Ibuprofene'' in the `'Other medications 
Analgesics''

1. Add a new report on data quality : Patient with duplicate ST code.

2.- On the program management, We would like to show the result of those
reports :
New Diagnoses Made,
Active Diagnoses
Laboratory Tests Ordered
Laboratory Tests Completed
Medications Ordered
Medications Dispensed

by months or let us enter the begining and the end date like the report
''Clinic Visiting during Given Period'' :

Let me(Piu) know if additional information is reqd .. 

The black header bars that separate the sections on the adult f/u form
are of varying lengths.

This probably isn't high priority, but should be fixed eventually

What steps will reproduce the problem?
1. go to quality of care reports
2. click 'Femmes enceintes qui sont au moins dans leur 28ème semaine 
d'aménorrhée'

What is the expected output? What do you see instead?
The default date range is 1-1-08 to 1-1-09... it should be 1-1-09 to 1-1-10

or better it should get the current year and default from that.

Please use labels and text to provide additional information.

Add a graph of a pediatric growth chart and plot data points