Patient - Reminders
/
Y
N
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 Reminder FieldsPatient RemindersY Select Reminder FieldsAdd sequenceY Add sequenceTransform Reminder FieldsY Table inputSelect Reminder FieldsY
Add sequence
Sequence
Y
1
none
REMINDERNO
N
SEQ_
Y
1
1
9999999
334
137
Y
Patient Reminders
OpenVPMSLoaderPlugin
Y
1
none
openvpmsREMINDERNOREMINDER<act.patientReminder>reminderType[0]<participation.reminderType>entitytrue<entity.reminderType>$valuefalseREMINDERNO<act.patientReminder>reminderType[0]<participation.reminderType>acttrue<act.patientReminder>$valuefalseID<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>statustruefalseSENT<act.patientReminder>reminderCounttruefalseLASTSENT<act.patientReminder>lastSenttruefalsefalsetrue1000
567
136
Y
Select Reminder Fields
SelectValues
Y
1
none
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
Vax Number
PRODUCTID
-2
-2
Type
REMINDER
-2
-2
Date Done
DATE
-2
-2
Date Next
DUE
-2
-2
Date First Reminder
LASTSENT
-2
-2
Reminders Sent
SENT
-2
-2
226
133
Y
Table input
TableInput
Y
1
none
Quickvet
select * from petrsys
0
N
N
106
138
Y
Transform Reminder Fields
ScriptValueMod
Y
1
none
0
Script 1
REMINDER.setString(replace(upper(REMINDER.getString()),"[^A-Z0-9]+",'_'))
// Create a unique Patient ID
var ID = num2str(ACCOUNTID.getNumber()) + "." + num2str(PATIENTID.getNumber())
var STATUS = "IN_PROGRESS"
STATUS
STATUS
String
-1
-1
ID
ID
String
-1
-1
435
135
Y