Patient - Visit /

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 FieldsPatient VisitY Select Visit FieldsFilter rowsY Filter rowsDummy (do nothing)Y Filter rowsTransform Visit FieldsY Table inputSelect Visit FieldsY Dummy (do nothing) Dummy Y 1 none 324 241 Y Filter rows FilterRows Y 1 none Transform Visit 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 325 134 Y Patient Visit OpenVPMSLoaderPlugin N 1 none openvpmsVISITIDSTARTDATE<act.patientClinicalEvent>startTimefalsefalseENDDATE<act.patientClinicalEvent>endTimefalsefalseSTATUS<act.patientClinicalEvent>statusfalsefalseREASON<act.patientClinicalEvent>reasonfalsefalseID<act.patientClinicalEvent>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseVISITID<act.patientClinicalEvent>patient[0]<participation.patient>acttrue<act.patientClinicalEvent>$valuefalsetruetrue1000 573 135 Y Select Visit Fields SelectValues Y 1 none Visit Number VISITID -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 Arrival Date STARTDATE -2 -2 Depart Date ENDDATE -2 -2 Vet CLINICIAN -2 -2 211 136 Y Table input TableInput Y 1 none Quickvet select * from visit 0 N N 86 136 Y Transform Visit Fields ScriptValueMod Y 1 none