Patient - Medication /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 11:52:22.354 archetypes MYSQL Native openvpms 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN Merge JoinAdd sequenceY Add sequenceSelect valuesY Invoices inputSelect Invoice FieldsY Select Invoice FieldsFilter rowsY Transform Drug ItemsMerge JoinY Filter rowsMerge JoinY Filter rowsDummy (do nothing)Y Drug Label InputFilter zero productsY Select Drug Label FieldsGroup byY Group byTransform Drug ItemsY Select valuesModified Java Script ValueY Lookup Product NameSelect Drug Label FieldsY Product InputLookup Product NameY Filter zero productsLookup Product NameY Filter zero productsDummy (do nothing) 2Y Modified Java Script ValuePatient Visit Medication OutputY Add sequence Sequence Y 1 none VISITITEMID N archetypes SEQ_ Y 1 1 9999999 646 215 Y Drug Label Input XBaseInput Y 1 none F:\VETAID\INVLABEL.DBF 0 N N N 49 367 Y Dummy (do nothing) Dummy Y 1 none 332 110 Y Dummy (do nothing) 2 Dummy Y 1 none 161 483 Y Filter rows FilterRows Y 1 none Merge Join Dummy (do nothing) N N CLNUMBER <> constantString0.0-1-1N N AND PETNUMBER <> constantString0.0-1-1N N AND TREATNO IS NOT NULL 333 216 Y Filter zero products FilterRows Y 1 none Lookup Product Name Dummy (do nothing) 2 N INVENTNO <> constantNumber0.0-1-1N 163 367 Y Group by GroupBy Y 1 none N N %%java.io.tmpdir%% grp N INVOICENO PRODUCTID INVENTNAME LABELTEXT LABELTEXT CONCAT_COMMA 475 366 Y Invoices input XBaseInput N 1 none F:\VETAID\INVOICES.DBF 0 N N N 55 216 Y Lookup Product Name StreamLookup Y 1 none Product Input N N Y N INVENTNO INVENTNO INVENTNAME INVENTNAME String 276 368 Y Merge Join MergeJoin N 1 none INNER Filter rows Transform Drug Items INVOICENO INVOICENO 568 216 Y Modified Java Script Value ScriptValueMod Y 1 none