<?xml version="1.0" encoding="UTF-8"?>
<transformation>
  <info>
    <name>Patient - Reminders</name>
    <directory>&#47;</directory>
    <log>
      <read/>
      <write/>
      <input/>
      <output/>
      <update/>
      <connection/>
      <table/>
      <use_batchid>Y</use_batchid>
      <use_logfield>N</use_logfield>
      </log>
    <maxdate>
      <connection/>
      <table/>
      <field/>
      <offset>0.0</offset>
      <maxdiff>0.0</maxdiff>
      </maxdate>
    <size_rowset>1000</size_rowset>
    <sleep_time_empty>1</sleep_time_empty>
    <sleep_time_full>1</sleep_time_full>
    <unique_connections>N</unique_connections>
    <feedback_shown>Y</feedback_shown>
    <feedback_size>5000</feedback_size>
    <using_thread_priorities>Y</using_thread_priorities>
    <shared_objects_file/>
    <dependencies>
      </dependencies>
    <partitionschemas>
      </partitionschemas>
    <slaveservers>
      </slaveservers>
    <clusterschemas>
      </clusterschemas>
  <modified_user>-</modified_user>
  <modified_date>2007&#47;05&#47;29 10:46:03.315</modified_date>
    </info>
  <notepads>
    </notepads>
  <connection>
    <name>RxWorks</name>
    <server/>
    <type>MSACCESS</type>
    <access>ODBC</access>
    <database>RxWorks</database>
    <port>-1</port>
    <username/>
    <password>Encrypted </password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
      <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
      <attribute><code>MAXIMUM_POOL_SIZE</code><attribute>10</attribute></attribute>
      <attribute><code>PORT_NUMBER</code><attribute>-1</attribute></attribute>
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
    </attributes>
  </connection>
  <order>
  <hop> <from>Select values</from><to>Transform Values</to><enabled>Y</enabled> </hop>  <hop> <from>Transform Values</from><to>Add sequence</to><enabled>Y</enabled> </hop>  <hop> <from>Table input</from><to>Select values</to><enabled>Y</enabled> </hop>  <hop> <from>Add sequence</from><to>Filter rows</to><enabled>Y</enabled> </hop>  <hop> <from>Filter rows</from><to>Reminder Output</to><enabled>Y</enabled> </hop>  <hop> <from>Filter rows</from><to>Reminder Output No product</to><enabled>Y</enabled> </hop>  </order>

  <step>
    <name>Add sequence</name>
    <type>Sequence</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
      <valuename>REMINDERNO</valuename>
      <use_database>N</use_database>
      <connection/>
      <schema/>
      <seqname>SEQ_</seqname>
      <use_counter>Y</use_counter>
      <counter_name/>
      <start_at>1</start_at>
      <increment_by>1</increment_by>
      <max_value>9999999</max_value>
     <cluster_schema/>
    <GUI>
      <xloc>465</xloc>
      <yloc>130</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Filter rows</name>
    <type>FilterRows</type>
    <description/>
    <distribute>N</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
<send_true_to>Reminder Output</send_true_to>
<send_false_to>Reminder Output No product</send_false_to>
    <compare>
<condition>
 <negated>N</negated>
 <conditions>
  <condition>
   <negated>N</negated>
   <leftvalue>PRODUCT</leftvalue>
   <function>IS NOT NULL</function>
   <rightvalue/>
   </condition>
  <condition>
   <negated>N</negated>
   <operator>AND</operator>
   <leftvalue>PRODUCT</leftvalue>
   <function>&lt;&gt;</function>
   <rightvalue/>
   <value><name>constant</name><type>Integer</type><text> 0</text><length>-1</length><precision>0</precision><isnull>N</isnull></value>   </condition>
  </conditions>
 </condition>
    </compare>
     <cluster_schema/>
    <GUI>
      <xloc>592</xloc>
      <yloc>131</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Reminder Output</name>
    <type>OpenVPMSLoaderPlugin</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
<mappings><connection>openvpms</connection><idColumn>REMINDERNO</idColumn><mapping><source>REMINDER</source><target>&lt;act.patientReminder>reminderType[0]&lt;participation.reminderType>entity</target><excludeNull>true</excludeNull><value>&lt;entity.reminderType>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>REMINDERNO</source><target>&lt;act.patientReminder>reminderType[0]&lt;participation.reminderType>act</target><excludeNull>true</excludeNull><value>&lt;act.patientReminder>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>PATIENTID</source><target>&lt;act.patientReminder>patient[0]&lt;participation.patient>entity</target><excludeNull>true</excludeNull><value>&lt;party.patientpet>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>REMINDERNO</source><target>&lt;act.patientReminder>patient[0]&lt;participation.patient>act</target><excludeNull>true</excludeNull><value>&lt;act.patientReminder>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>PRODUCT</source><target>&lt;act.patientReminder>product[0]&lt;participation.product>entity</target><excludeNull>true</excludeNull><value>&lt;product.*>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>REMINDERNO</source><target>&lt;act.patientReminder>product[0]&lt;participation.product>act</target><excludeNull>true</excludeNull><value>&lt;act.patientReminder>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>DATE</source><target>&lt;act.patientReminder>startTime</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>DUE</source><target>&lt;act.patientReminder>endTime</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>STATUS</source><target>&lt;act.patientReminder>status</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>LASTSENT</source><target>&lt;act.patientReminder>reminderCount</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><generateLookups>false</generateLookups><skipProcessed>true</skipProcessed><batchSize>1000</batchSize></mappings>     <cluster_schema/>
    <GUI>
      <xloc>778</xloc>
      <yloc>129</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Reminder Output No product</name>
    <type>OpenVPMSLoaderPlugin</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
<mappings><connection>openvpms</connection><idColumn>REMINDERNO</idColumn><mapping><source>REMINDER</source><target>&lt;act.patientReminder>reminderType[0]&lt;participation.reminderType>entity</target><excludeNull>true</excludeNull><value>&lt;entity.reminderType>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>REMINDERNO</source><target>&lt;act.patientReminder>reminderType[0]&lt;participation.reminderType>act</target><excludeNull>true</excludeNull><value>&lt;act.patientReminder>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>PATIENTID</source><target>&lt;act.patientReminder>patient[0]&lt;participation.patient>entity</target><excludeNull>true</excludeNull><value>&lt;party.patientpet>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>REMINDERNO</source><target>&lt;act.patientReminder>patient[0]&lt;participation.patient>act</target><excludeNull>true</excludeNull><value>&lt;act.patientReminder>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>DATE</source><target>&lt;act.patientReminder>startTime</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>DUE</source><target>&lt;act.patientReminder>endTime</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>STATUS</source><target>&lt;act.patientReminder>status</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>LASTSENT</source><target>&lt;act.patientReminder>reminderCount</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><generateLookups>false</generateLookups><skipProcessed>true</skipProcessed><batchSize>1000</batchSize></mappings>     <cluster_schema/>
    <GUI>
      <xloc>779</xloc>
      <yloc>240</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Select values</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <fields>      <field>        <name>Patient Number</name>
        <rename>PATIENTID</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>Reminder Code</name>
        <rename>REMINDER</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>Reminder Next</name>
        <rename>DUE</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>Reminder Item</name>
        <rename>PRODUCT</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>Reminder Sent</name>
        <rename>LASTSENT</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>Created Date</name>
        <rename>DATE</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      </fields>     <cluster_schema/>
    <GUI>
      <xloc>241</xloc>
      <yloc>130</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Table input</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <connection>RxWorks</connection>
    <sql>SELECT *
FROM [Patient Reminder]
</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
     <cluster_schema/>
    <GUI>
      <xloc>133</xloc>
      <yloc>133</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Transform Values</name>
    <type>ScriptValueMod</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <script/>
    <jsScripts>      <jsScript>        <jsScript_type>0</jsScript_type>
        <jsScript_name>Script 1</jsScript_name>
        <jsScript_script>&#47;&#47;Script here
var now = new Date();
var STATUS = &quot;IN_PROGRESS&quot;
&#47;&#47;if (dateDiff(DUE.getDate(),now,&quot;m&quot;) &gt; 24)
	&#47;&#47;STATUS = &quot;CANCELLED&quot;</jsScript_script>
        </jsScript>     </jsScripts>    <fields>      <field>        <name>STATUS</name>
        <rename>STATUS</rename>
        <type>String</type>
        <length>-1</length>
        <precision>-1</precision>
        </field>      </fields>     <cluster_schema/>
    <GUI>
      <xloc>357</xloc>
      <yloc>130</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

</transformation>