Patient - Visit Note / YN
0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 12:20:17.563 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 Transform Visit FieldsVisit NotesY Select Visit FieldsFilter rowsY Filter rowsDummy (do nothing)Y Filter rowsTransform Visit FieldsY Table inputSelect Visit FieldsY Dummy (do nothing) Dummy Y 1 none 343 242 Y Filter rows FilterRows Y 1 none Transform Visit Fields Dummy (do nothing) N N AND PATIENTID <> constantInteger 0-10N N AND VISITID IS NOT NULL N AND PATIENTID IS NOT NULL N AND ACCOUNTID IS NOT NULL 338 136 Y Select Visit Fields SelectValues Y 1 none Visit Number VISITID -2 -2 Arrival Date STARTDATE -2 -2 Depart Date ENDDATE -2 -2 Symptoms SYMPTOMS -2 -2 Summary SUMMARY -2 -2 Diagnosis DIAGNOSIS -2 -2 Treatment TREATMENT -2 -2 Vet CLINICIAN -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 229 135 Y Table input TableInput Y 1 none Quickvet SELECT * from visit 0 N N 97 138 Y Transform Visit Fields ScriptValueMod Y 1 none