Patient - Reminders /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/05/29 10:46:03.315 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 Select valuesTransform ValuesY Transform ValuesAdd sequenceY Table inputSelect valuesY Add sequenceFilter rowsY Filter rowsReminder OutputY Filter rowsReminder Output No productY Add sequence Sequence Y 1 none REMINDERNO N SEQ_ Y 1 1 9999999 465 130 Y Filter rows FilterRows N 1 none Reminder Output Reminder Output No product N N PRODUCT IS NOT NULL N AND PRODUCT <> constantInteger 0-10N 592 131 Y Reminder Output OpenVPMSLoaderPlugin Y 1 none openvpmsREMINDERNOREMINDER<act.patientReminder>reminderType[0]<participation.reminderType>entitytrue<entity.reminderType>$valuefalseREMINDERNO<act.patientReminder>reminderType[0]<participation.reminderType>acttrue<act.patientReminder>$valuefalsePATIENTID<act.patientReminder>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseREMINDERNO<act.patientReminder>patient[0]<participation.patient>acttrue<act.patientReminder>$valuefalsePRODUCT<act.patientReminder>product[0]<participation.product>entitytrue<product.*>$valuefalseREMINDERNO<act.patientReminder>product[0]<participation.product>acttrue<act.patientReminder>$valuefalseDATE<act.patientReminder>startTimetruefalseDUE<act.patientReminder>endTimetruefalseSTATUS<act.patientReminder>statustruefalseLASTSENT<act.patientReminder>reminderCounttruefalsefalsetrue1000 778 129 Y Reminder Output No product OpenVPMSLoaderPlugin Y 1 none openvpmsREMINDERNOREMINDER<act.patientReminder>reminderType[0]<participation.reminderType>entitytrue<entity.reminderType>$valuefalseREMINDERNO<act.patientReminder>reminderType[0]<participation.reminderType>acttrue<act.patientReminder>$valuefalsePATIENTID<act.patientReminder>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseREMINDERNO<act.patientReminder>patient[0]<participation.patient>acttrue<act.patientReminder>$valuefalseDATE<act.patientReminder>startTimetruefalseDUE<act.patientReminder>endTimetruefalseSTATUS<act.patientReminder>statustruefalseLASTSENT<act.patientReminder>reminderCounttruefalsefalsetrue1000 779 240 Y Select values SelectValues Y 1 none Patient Number PATIENTID -2 -2 Reminder Code REMINDER -2 -2 Reminder Next DUE -2 -2 Reminder Item PRODUCT -2 -2 Reminder Sent LASTSENT -2 -2 Created Date DATE -2 -2 241 130 Y Table input TableInput Y 1 none RxWorks SELECT * FROM [Patient Reminder] 0 N N 133 133 Y Transform Values ScriptValueMod Y 1 none