Customer - Appointments /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:32:03.666 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 Filter ClientsDummy (do nothing)Y Transform AppointmentsAppointmentsY Table inputSelect valuesY Select valuesAdd sequenceY Add sequenceFilter ClientsY Filter ClientsFilter AppointmentsY Filter AppointmentsTransform AppointmentsY Filter AppointmentsTransform TasksY Transform TasksTasksY Add sequence Sequence Y 1 none APPOINTID N SEQ_ Y 1 1 9999999 284 114 Y Appointments OpenVPMSLoaderPlugin Y 1 none openvpmsAPPOINTIDSTARTTIME<act.customerAppointment>startTimetruefalseENDTIME<act.customerAppointment>endTimetruefalseREASON<act.customerAppointment>reasontruefalseNOTES<act.customerAppointment>descriptiontruefalseSTATUS<act.customerAppointment>statustruefalseSCHEDULE<act.customerAppointment>schedule[0]<participation.schedule>entitytrue<party.organisationSchedule>$valuefalseAPPOINTID<act.customerAppointment>schedule[0]<participation.schedule>acttrue<act.customerAppointment>$valuefalseAPPTYPE<act.customerAppointment>appointmentType[0]<participation.appointmentType>entitytrue<entity.appointmentType>$valuefalseAPPOINTID<act.customerAppointment>appointmentType[0]<participation.appointmentType>acttrue<act.customerAppointment>$valuefalseCLIENTID<act.customerAppointment>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseAPPOINTID<act.customerAppointment>customer[0]<participation.customer>acttrue<act.customerAppointment>$valuefalsePATIENTID<act.customerAppointment>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseAPPOINTID<act.customerAppointment>patient[0]<participation.patient>acttrue<act.customerAppointment>$valuefalsetruetrue1000 746 114 Y Dummy (do nothing) Dummy Y 1 none 385 236 Y Filter Appointments FilterRows N 1 none Transform Appointments Transform Tasks N STARTTIME IS NOT NULL 495 116 Y Filter Clients FilterRows N 1 none Filter Appointments Dummy (do nothing) N N N AND CLIENTID IS NOT NULL N AND PATIENTID IS NOT NULL N AND CLIENTID <> constantInteger-1-10N N AND PATIENTID <> constantInteger-1-10N N AND CLIENTID <> constantInteger 0-10N N AND PATIENTID <> constantInteger 0-10N 386 113 Y Select values SelectValues Y 1 none Clipboard Code SCHEDULE -2 -2 Client Number CLIENTID -2 -2 Patient Number PATIENTID -2 -2 Notes NOTES -2 -2 Appointment Date STARTTIME -2 -2 Appointment Type APPTYPE -2 -2 Appointment Duration DURATION -2 -2 In Date INDATE -2 -2 Out Date OUTDATE -2 -2 Consulting Vet ID CLINICIAN -2 -2 171 115 Y Table input TableInput Y 1 none RxWorks SELECT * FROM [Clipboard Data] 0 N N 65 112 Y Tasks OpenVPMSLoaderPlugin Y 1 none openvpmsAPPOINTIDSTARTTIME<act.customerTask>startTimetruefalseNOTES<act.customerTask>descriptiontruefalseSTATUS<act.customerTask>statustruefalseSCHEDULE<act.customerTask>worklist[0]<participation.worklist>entitytrue<party.organisationWorkList>$valuefalseAPPOINTID<act.customerTask>worklist[0]<participation.worklist>acttrue<act.customerTask>$valuefalseTASKTYPE<act.customerTask>taskType[0]<participation.taskType>entitytrue<entity.taskType>$valuefalseAPPOINTID<act.customerTask>taskType[0]<participation.taskType>acttrue<act.customerTask>$valuefalseCLIENTID<act.customerTask>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseAPPOINTID<act.customerTask>customer[0]<participation.customer>acttrue<act.customerTask>$valuefalsePATIENTID<act.customerTask>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseAPPOINTID<act.customerTask>patient[0]<participation.patient>acttrue<act.customerTask>$valuefalsefalsetrue1000 746 254 Y Transform Appointments ScriptValueMod Y 1 none