Patient - Relationships
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:10.000
Patient InputSelect Owner fieldsY Select Owner fieldsFilter nullsY Filter nullsDummy (do nothing)Y Filter nullsPatient Owner OutputY Patient Input 2Select Location fieldsY Select Location fieldsFilter nulls and sameY Filter nulls and sameDummy (do nothing) 2Y Filter nulls and samePatient Location OutputY
Dummy (do nothing)
Dummy
Y
1
none
380
62
Y
Dummy (do nothing) 2
Dummy
Y
1
none
383
407
Y
Filter nulls
FilterRows
Y
1
none
Patient Owner Output
Dummy (do nothing)
N
N
PATIENTID
<>
constantNumber0.0-1-1N
N
AND
PATIENTID
IS NOT NULL
N
AND
ACCOUNTID
<>
constantInteger 0-10N
N
AND
ACCOUNTID
IS NOT NULL
382
149
Y
Filter nulls and same
FilterRows
Y
1
none
Patient Location Output
Dummy (do nothing) 2
N
N
PATIENTID
<>
constantNumber0.0-1-1N
N
AND
PATIENTID
IS NOT NULL
N
AND
CLIENTID
<>
constantInteger 0-10N
N
AND
CLIENTID
IS NOT NULL
N
AND
CLIENTID
<>
ACCOUNTID
383
306
Y
Patient Input
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}\patient.txt
CSV
None
PATIENTID
Integer
$
.
,
-
-1
2
0
none
N
CLIENTID
Integer
$
.
,
-
-1
2
0
none
N
ACCOUNTID
Integer
$
.
,
-
-1
2
0
none
N
NAME
String
-
-1
30
-1
none
N
SPECIES
String
-
-1
15
-1
none
N
BREED
String
-
-1
30
-1
none
N
COLOUR
String
-
-1
30
-1
none
N
SEX
String
-
-1
10
-1
none
N
DOB
String
-
-1
10
-1
both
N
NOTES
String
-
-1
50
-1
none
N
DESEXED
String
-
-1
5
-1
none
N
INACTIVE
String
-
-1
5
-1
none
N
DECEASED
String
-
-1
5
-1
none
N
TAG
Integer
$
.
,
-
-1
30
0
none
N
MICROCHIP
String
$
.
,
-
-1
30
0
none
N
0
Y
Y
warning
error
line
Y
en_au
61
146
Y
Patient Input 2
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}\patient.txt
CSV
None
PATIENTID
Integer
$
.
,
-
-1
2
0
none
N
CLIENTID
Integer
$
.
,
-
-1
2
0
none
N
ACCOUNTID
Integer
$
.
,
-
-1
2
0
none
N
NAME
String
-
-1
30
-1
none
N
SPECIES
String
-
-1
15
-1
none
N
BREED
String
-
-1
30
-1
none
N
COLOUR
String
-
-1
30
-1
none
N
SEX
String
-
-1
10
-1
none
N
DOB
String
-
-1
10
-1
both
N
NOTES
String
-
-1
50
-1
none
N
DESEXED
String
-
-1
5
-1
none
N
INACTIVE
String
-
-1
5
-1
none
N
DECEASED
String
-
-1
5
-1
none
N
TAG
Integer
$
.
,
-
-1
30
0
none
N
MICROCHIP
String
$
.
,
-
-1
30
0
none
N
0
Y
Y
warning
error
line
Y
en_au
64
305
Y
Patient Location Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsPATIENTID<entityRelationship.patientLocation>targettrue<party.patientpet>$valuefalse<entityRelationship.patientLocation>sourcetrue<party.customerperson>$valuefalsefalsetrue1000
660
305
Y
Patient Owner Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsPATIENTID<entityRelationship.patientOwner>targettrue<party.patientpet>$valuefalse<entityRelationship.patientOwner>sourcetrue<party.customerperson>$valuefalsefalsetrue1000
660
150
Y
Select Location fields
SelectValues
Y
1
none
PATIENTID
-2
-2
CLIENTID
-2
-2
ACCOUNTID
-2
-2
179
306
Y
Select Owner fields
SelectValues
Y
1
none
PATIENTID
-2
-2
ACCOUNTID
-2
-2
185
145
Y