Patient - Relationships / YN
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
Y
1
N
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
Y
1
N
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 openvpmsPATIENTIDPATIENTID<entityRelationship.patientLocation>targettrue<party.patientpet>$valuefalseCLIENTID<entityRelationship.patientLocation>sourcetrue<party.customerperson>$valuefalsefalsetrue1000 660 305 Y Patient Owner Output OpenVPMSLoaderPlugin Y 1 none openvpmsPATIENTIDPATIENTID<entityRelationship.patientOwner>targettrue<party.patientpet>$valuefalseACCOUNTID<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