Patient - Visit Weight
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 12:20:17.563
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Transform Visit FieldsVisit WeightY 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
N
PATIENTID
IS NOT NULL
N
AND
VISITID
IS NOT NULL
N
AND
PATIENTID
<>
constantNumber0.0-1-1N
N
AND
ACCOUNTID
IS NOT NULL
339
136
Y
Select Visit Fields
SelectValues
Y
1
none
Visit Number
VISITID
-2
-2
Weight
WEIGHT
-2
-2
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
Arrival Date
STARTDATE
-2
-2
Depart Date
ENDDATE
-2
-2
226
135
Y
Table input
TableInput
Y
1
none
Quickvet
select * from visit
0
N
N
110
135
Y
Transform Visit Fields
ScriptValueMod
Y
1
none
0
Script 1
var WEIGHTUOM = "KILOGRAMS"
var ID = num2str(ACCOUNTID.getNumber()) + "." + num2str(PATIENTID.getNumber())
if (STARTDATE.getDate() == null) {
STARTDATE.setDate(ENDDATE.getDate());
}
WEIGHTUOM
WEIGHTUOM
String
-1
-1
ID
ID
String
-1
-1
441
134
Y
Visit Weight
OpenVPMSLoaderPlugin
N
1
none
openvpmsVISITID<act.patientWeight>startTimetruefalse<act.patientWeight>weighttruefalse<act.patientWeight>unitstruefalse<act.patientWeight>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalse<act.patientWeight>patient[0]<participation.patient>acttrue<act.patientWeight>$valuefalse<actRelationship.patientClinicalEventItem>sourcetrue<act.patientClinicalEvent>$valuefalse<actRelationship.patientClinicalEventItem>targettrue<act.patientWeight>$valuefalsetruetrue1000
590
135
Y