Patient - Medication /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:20:22.718 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 Add sequenceTransform FieldsY Transform FieldsFilter MedicationY Table inputSelect valuesY Select valuesAdd sequenceY Filter MedicationDummy (do nothing)Y Filter MedicationPatient MedicationY Add sequence Sequence Y 1 none MEDICATIONID N SEQ_ Y 1 1 9999999 186 73 Y Filter Medication FilterRows N 1 none Patient Medication Dummy (do nothing) N COMPONENTGROUP STARTS WITH constantStringDrug-1-1N 371 76 Y Select values SelectValues Y 1 none Consultation Number VISITID -2 -2 Consultation Date DATE -2 -2 Item Code PRODUCTID -2 -2 Item Label LABEL -2 -2 Consulting Vet VET -2 -2 Item Component Fee Group COMPONENTGROUP -2 -2 Patient Number PATIENT -2 -2 Item Component Number QTY -2 -2 103 73 Y Table input TableInput Y 1 none RxWorks SELECT * FROM Visit INNER JOIN ((Consultation INNER JOIN [Consultation Item] ON Consultation.[Consultation Number] = [Consultation Item].[Consultation Number]) INNER JOIN Item ON [Consultation Item].[Item Code] = Item.[Item Code]) ON Visit.[Visit Number] = Consultation.[Visit Number]; 0 N N 32 73 Y Transform Fields ScriptValueMod Y 1 none