Patient - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:10.000
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
Select FieldsFilter rowsY Transform FieldsPatient OutputY Filter rowsTransform FieldsY Filter rowsDummy (do nothing)Y Table inputSelect FieldsY
Dummy (do nothing)
Dummy
Y
1
none
293
243
Y
Filter rows
FilterRows
Y
1
none
Transform Fields
Dummy (do nothing)
N
N
PATIENTID
<>
constantNumber0.0-1-1N
N
AND
PATIENTID
IS NOT NULL
295
145
Y
Patient Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsIDNAME<party.patientpet>namefalsefalseSPECIES<party.patientpet>speciesfalsefalseBREED<party.patientpet>breedfalsefalseCOLOUR<party.patientpet>colourfalsefalseDOB<party.patientpet>dateOfBirthtruefalseSEX<party.patientpet>sexfalsefalseDESEXFLAG<party.patientpet>desexedfalsefalseDECEASEDFLAG<party.patientpet>deceasedfalsefalseACTIVE<party.patientpet>activefalsefalseMICROCHIP<party.patientpet>identities[1]<entityIdentity.microchip>microchiptruefalsetruetrue1000
530
145
Y
Select Fields
SelectValues
Y
1
none
AccountNumber
CLIENTID
8
0
PetNumber
PATIENTID
8
0
PetName
NAME
-2
-2
Species
SPECIES
-2
-2
Breed
BREED
-2
-2
Color
COLOUR
-2
-2
Sex
SEX
-2
-2
Comments
NOTES
-2
-2
Status
STATUS
-2
-2
Animal Number
TAG
-2
-2
Microchip Number
MICROCHIP
-2
-2
DOB
-2
-2
183
145
Y
Table input
TableInput
Y
1
none
Quickvet
select * from petrec;
0
N
N
69
146
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
// Create a unique Patient ID
var ID = num2str(CLIENTID.getNumber()) + "." + num2str(PATIENTID.getNumber())
// Transform Name information
NAME.setString(wordUtils.capitalizeFully(trim(NAME.getString())))
if (NAME.getString() == "" || NAME.getString() == null) {
NAME.setString("No Name")
}
SPECIES.setString(wordUtils.capitalizeFully(trim(SPECIES.getString())))
if (SPECIES.getString() == "" || SPECIES.getString() == null) {
SPECIES.setString("Other")
}
BREED.setString(wordUtils.capitalizeFully(trim(BREED.getString())))
COLOUR.setString(wordUtils.capitalizeFully(trim(COLOUR.getString())))
// Transform Sex
var DESEXFLAG = false
if (SEX.getString() == "F") {
SEX.setString("FEMALE");
DESEXFLAG = false;
}
else if (SEX.getString() == "FN") {
SEX.setString("FEMALE");
DESEXFLAG = true;
}
else if (SEX.getString() == "M") {
SEX.setString("MALE");
DESEXFLAG = false;
}
else if (SEX.getString() == "MN") {
SEX.setString("MALE");
DESEXFLAG = true;
}
else if (SEX.getString() == "G") {
SEX.setString("MALE");
DESEXFLAG = true;
}
else {
SEX.setString("UNSPECIFIED")
}
var DECEASEDFLAG = false
var ACTIVE = false
if (STATUS.getString() == "ALIVE")
ACTIVE = true
if (STATUS.getString() == "DECEASED")
DECEASEDFLAG = true
DESEXFLAG
DESEXFLAG
Boolean
-1
-1
DECEASEDFLAG
DECEASEDFLAG
Boolean
-1
-1
ACTIVE
ACTIVE
Boolean
-1
-1
ID
ID
String
-1
-1
396
148
Y