Patient - Visit Weight Conversion
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 12:20:17.563
RxWorks
MSACCESS
ODBC
RxWorks
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Transform Visit FieldsVisit Weight Item OutputY Select Visit FieldsFilter rowsY Filter rowsDummy (do nothing)Y Filter rowsTransform Visit FieldsY Table inputSelect Visit FieldsY
Dummy (do nothing)
Dummy
Y
1
none
342
242
Y
Filter rows
FilterRows
Y
1
none
Transform Visit Fields
Dummy (do nothing)
N
N
WEIGHT
<>
constantNumber0.0-1-1N
N
AND
PATIENT
<>
constantInteger-1-10N
338
136
Y
Select Visit Fields
SelectValues
Y
1
none
Consultation Number
VISITNO
-2
-2
Consultation Date
STARTTIME
-2
-2
Consultation Weight
WEIGHT
-2
-2
Patient Number
PATIENT
-2
-2
VISITNO
String
-2
-2
229
135
Y
Table input
TableInput
Y
1
none
RxWorks
SELECT *
FROM Consultation c inner join visit v on c.[Visit Number] = v.[Visit Number]
0
N
N
97
138
Y
Transform Visit Fields
ScriptValueMod
Y
1
none
0
Script 1
var VISITITEMID = "WEIGHT" + VISITNO.getString();
var WEIGHTUOM = "KILOGRAMS"
VISITITEMID
VISITITEMID
String
-1
-1
WEIGHTUOM
WEIGHTUOM
String
-1
-1
442
134
Y
Visit Weight Item Output
OpenVPMSLoaderPlugin
N
1
none
openvpmsVISITITEMIDSTARTTIME<act.patientWeight>startTimetruefalseWEIGHT<act.patientWeight>weighttruefalseWEIGHTUOM<act.patientWeight>unitstruefalsePATIENT<act.patientWeight>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseVISITITEMID<act.patientWeight>patient[0]<participation.patient>acttrue<act.patientWeight>$valuefalseVISITNO<actRelationship.patientClinicalEventItem>sourcetrue<act.patientClinicalEvent>$valuefalseVISITITEMID<actRelationship.patientClinicalEventItem>targettrue<act.patientWeight>$valuefalsetruetrue1000
590
135
Y