Patient - Visit Conversion /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 12:20:17.563 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 Transform Visit FieldsPatient Visit OutputY 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 PATIENT IS NOT NULL N AND PATIENT <> constantNumber-1.0-1-1N N AND VISITNO IS NOT NULL 324 134 Y Patient Visit Output OpenVPMSLoaderPlugin N 1 none openvpmsVISITNOSTARTTIME<act.patientClinicalEvent>startTimefalsefalseENDTIME<act.patientClinicalEvent>endTimetruefalseSTATUS<act.patientClinicalEvent>statusfalsefalseREASON<act.patientClinicalEvent>reasontruefalsePATIENT<act.patientClinicalEvent>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseVISITNO<act.patientClinicalEvent>patient[0]<participation.patient>acttrue<act.patientClinicalEvent>$valuefalseCLINICIAN<act.patientClinicalEvent>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseVISITNO<act.patientClinicalEvent>clinician[0]<participation.clinician>acttrue<act.patientClinicalEvent>$valuefalsetruetrue1000 573 135 Y Select Visit Fields SelectValues Y 1 none Consultation Number VISITNO -2 -2 Consultation Date STARTTIME -2 -2 Consulting Vet CLINICIAN -2 -2 End Date ENDTIME -2 -2 Patient Number PATIENT -2 -2 Incomplete Status INCOMPLETE -2 -2 Invoice Text TEXT -2 -2 Summary REASON -2 -2 224 135 Y Table input TableInput Y 1 none RxWorks SELECT * FROM Consultation c inner join visit v on c.[Visit Number] = v.[Visit Number] 0 N N 99 135 Y Transform Visit Fields ScriptValueMod Y 1 none