Patient - Information /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 10:47:10.000 openvpms localhost MYSQL Native openvpms 3306 root Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN 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 Select FieldsFilter rowsY Transform FieldsPatient OutputY Filter rowsTransform FieldsY Filter rowsDummy (do nothing)Y Table inputSelect FieldsY Dummy (do nothing) Dummy Y 1 none 293 243 Y Filter rows FilterRows Y 1 none Transform Fields Dummy (do nothing) N N ID <> constantNumber0.0-1-1N N AND ID IS NOT NULL 296 145 Y Patient Output OpenVPMSLoaderPlugin Y 1 none openvpmsIDNAME<party.patientpet>namefalsefalseSPECIES<party.patientpet>speciesfalsefalseBREED<party.patientpet>breedfalsefalseCOLOUR<party.patientpet>colourfalsefalseDOB<party.patientpet>dateOfBirthfalsefalseSEX<party.patientpet>sexfalsefalseDESEXED<party.patientpet>desexedfalsefalseACTIVE<party.patientpet>activefalsefalsetruetrue1000 570 143 Y Select Fields SelectValues Y 1 none Patient Number ID -2 -2 Patient Name NAME -2 -2 Patient Species SPECIES -2 -2 Patient Breed BREED -2 -2 Patient Colour COLOUR -2 -2 Patient Sex SEX -2 -2 Patient Weight WEIGHT -2 -2 Patient Date of Birth DOB -2 -2 Patient Desexed DESEXED -2 -2 Deactivated Patient DEACTIVATED -2 -2 185 145 Y Table input TableInput Y 1 none RxWorks select * from patient 0 N N 67 145 Y Transform Fields ScriptValueMod Y 1 none