dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi Marko and Rodolfo,

We have a comment field available for the programinstance object. This is
for general comments about a person in a program, a bit like a whiteboard
that you can always see on top of the data entry form in Person Dashboard.
This field is also limited to 255 characters, but we can extend it. We have
a patientcomment object that is referenced in programinstance.

Would this meet your needs or you need to have a comment per program stage
instance (encounter/visit)?

I guess we could link to a patientcomment from programstageinstance as
well, and this way make comments available per stage instance?

Ola
--------

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>


On 29 April 2013 21:02, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:

> Hi - just to echo on Marko's comment: PSI is also considering the use of a
> large, free text field, for doctor/ nurse to write free text observations
> that we don't need to quantify, but we want to capture, so DHIS can work as
> a light electronic health record. We will try Knut's suggestion on the mean
> time.
>
>
> On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>
>> Hi Marko,
>>
>> we could consider it - the only problem is that we have chosen the
>> approach of using one column for all types of values. Most values are short
>> numbers and using text as column type over varchar with fixed length
>> implies a performance penalty. I am not sure how significant that overhead
>> is with latest versions of postgresql/mysql. We could check it out. I guess
>> you could do like Knut suggests for now and change the column type manually.
>>
>> cheers
>>
>> Lars
>>
>>
>>
>> On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia <
>> markodavidgm@xxxxxxxxx> wrote:
>>
>>> Hi friends, in the table patientdatavalue the field value is
>>> varchar(255).
>>>
>>> Is possible change this field to a bigger type?
>>>
>>> We need insert long descriptions in this field.
>>>
>>> Thank you very much.
>>>
>>> --
>>> Cordialmente,
>>>
>>>
>>> *Ing. Marko David Garcia M.
>>> *
>>> *Área de Sistemas integrados de Información
>>> Secretaría de Salud Departamental del Cauca
>>>
>>> *
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> *Rodolfo Meliá*
> *Principal*
> rmelia@xxxxxxxxxxxx
> www.knowming.com
> +1 708 872 7636
> +44 777 576 4090
> Skype: rod.melia
> Twitter: @RodolfoMelia <https://twitter.com/RodolfoMelia>
>
> Note: Please note my new email address, which I will be using for PSI
> related work: rmelia@xxxxxxxxxxxx
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>