Patient - Visit Medication /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:20:22.718 Quickvet MSACCESS ODBC Quickvet -1 Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER-1 STREAM_RESULTSY USE_POOLINGN Table inputSelect valuesY Select valuesAdd sequenceY Transform FieldsPatient MedicationY Filter rowsDummy (do nothing)Y Add sequenceFilter rowsY Filter rowsTransform FieldsY Add sequence Sequence Y 1 none MEDICATIONID N SEQ_ Y 1 1 9999999 303 74 Y Dummy (do nothing) Dummy Y 1 none 391 221 Y Filter rows FilterRows Y 1 none Transform Fields Dummy (do nothing) N N PATIENTID IS NOT NULL N AND PATIENTID <> constantNumber0.0-1-1N N AND VISITID IS NOT NULL N AND ACCOUNTID IS NOT NULL N AND CODE IS NOT NULL 390 75 Y Patient Medication OpenVPMSLoaderPlugin N 1 none openvpmsMEDICATIONIDDATE<act.patientMedication>startTimetruefalseLABEL<act.patientMedication>labelfalsefalseQTY<act.patientMedication>quantitytruefalseID<act.patientMedication>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseMEDICATIONID<act.patientMedication>patient[0]<participation.patient>acttrue<act.patientMedication>$valuefalseCODE<act.patientMedication>product[0]<participation.product>entitytrue<product.*>$valuefalseMEDICATIONID<act.patientMedication>product[0]<participation.product>acttrue<act.patientMedication>$valuefalseVISITID<actRelationship.patientClinicalEventItem>sourcetrue<act.patientClinicalEvent>$valuefalseMEDICATIONID<actRelationship.patientClinicalEventItem>targettrue<act.patientMedication>$valuefalsetruetrue1000 618 77 Y Select values SelectValues Y 1 none Visit Number VISITID -2 -2 Drug Code CODE -2 -2 Date DATE -2 -2 Med Comment LABEL -2 -2 Tablets QTY -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 198 74 Y Table input TableInput Y 1 none Quickvet select * from visitmed m inner join visit v on m.[visit number] = v.[visit number] 0 N N 87 73 Y Transform Fields ScriptValueMod Y 1 none