Patient - Information / YN
0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 10:47:10.000 Text file inputSelect FieldsY Select FieldsFilter rowsY Transform FieldsPatient OutputY Filter rowsTransform FieldsY Filter rowsDummy (do nothing)Y Dummy (do nothing) Dummy Y 1 none 293 243 Y Filter rows FilterRows Y 1 none Transform Fields Dummy (do nothing) N N PATIENTID <> constantNumber0.0-1-1N N AND PATIENTID IS NOT NULL 296 145 Y Patient Output OpenVPMSLoaderPlugin Y 1 none openvpmsPATIENTIDNAME<party.patientpet>namefalsefalseSPECIES<party.patientpet>speciesfalsefalseBREED<party.patientpet>breedfalsefalseCOLOUR<party.patientpet>colourfalsefalseDOB<party.patientpet>dateOfBirthtruefalseSEX<party.patientpet>sexfalsefalseDESEXFLAG<party.patientpet>desexedfalsefalseDECEASEDFLAG<party.patientpet>deceasedfalsefalseACTIVE<party.patientpet>activefalsefalseTAG<party.patientpet>identities[0]<entityIdentity.petTag>petTagtruefalseMICROCHIP<party.patientpet>identities[1]<entityIdentity.microchip>microchiptruefalsetruetrue1000 530 145 Y Select Fields SelectValues Y 1 none PATIENTID -2 -2 CLIENTID -2 -2 ACCOUNTID -2 -2 NAME -2 -2 SPECIES -2 -2 BREED -2 -2 COLOUR -2 -2 SEX -2 -2 DOB -2 -2 NOTES -2 -2 DESEXED -2 -2 INACTIVE -2 -2 DECEASED -2 -2 TAG -2 -2 MICROCHIP -2 -2 185 145 Y Text file 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 Date dd/MM/yyyy -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 N warning error line Y en_au 60 146 Y
Transform Fields ScriptValueMod Y 1 none