Patient - Visit Note
/
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.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Transform Visit FieldsVisit NotesY Select Visit FieldsFilter rowsY Filter rowsDummy (do nothing)Y Filter rowsTransform Visit FieldsY Table inputSelect Visit FieldsY
Dummy (do nothing)
Dummy
Y
1
none
343
242
Y
Filter rows
FilterRows
Y
1
none
Transform Visit Fields
Dummy (do nothing)
N
N
AND
PATIENTID
<>
constantInteger 0-10N
N
AND
VISITID
IS NOT NULL
N
AND
PATIENTID
IS NOT NULL
N
AND
ACCOUNTID
IS NOT NULL
338
136
Y
Select Visit Fields
SelectValues
Y
1
none
Visit Number
VISITID
-2
-2
Arrival Date
STARTDATE
-2
-2
Depart Date
ENDDATE
-2
-2
Symptoms
SYMPTOMS
-2
-2
Summary
SUMMARY
-2
-2
Diagnosis
DIAGNOSIS
-2
-2
Treatment
TREATMENT
-2
-2
Vet
CLINICIAN
-2
-2
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
229
135
Y
Table input
TableInput
Y
1
none
Quickvet
SELECT * from visit
0
N
N
97
138
Y
Transform Visit Fields
ScriptValueMod
Y
1
none
0
Script 1
var ID = num2str(ACCOUNTID.getNumber()) + "." + num2str(PATIENTID.getNumber())
if (STARTDATE.getDate() == null) {
STARTDATE.setDate(ENDDATE.getDate());
}
var TEXT
if (SUMMARY.getString() != null && SUMMARY.getString() != "") {
TEXT = "Summary: " + SUMMARY.getString();
}
if (SYMPTOMS.getString() != null && SYMPTOMS.getString() != "") {
TEXT = TEXT + "\nSymptoms: " + SYMPTOMS.getString();
}
if (DIAGNOSIS.getString() != null && DIAGNOSIS.getString() != "") {
TEXT = TEXT + "\nDiagnosis: " + DIAGNOSIS.getString();
}
if (TREATMENT.getString() != null && TREATMENT.getString() != "") {
TEXT = TEXT + "\nTreatment: " + TREATMENT.getString();
}
ID
ID
String
-1
-1
TEXT
TEXT
String
-1
-1
442
135
Y
Visit Notes
OpenVPMSLoaderPlugin
N
1
none
openvpmsVISITID<act.patientClinicalNote>startTimetruefalse<act.patientClinicalNote>notetruefalse<act.patientClinicalNote>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalse<act.patientClinicalNote>patient[0]<participation.patient>acttrue<act.patientClinicalNote>$valuefalse<actRelationship.patientClinicalEventItem>sourcetrue<act.patientClinicalEvent>$valuefalse<actRelationship.patientClinicalEventItem>targettrue<act.patientClinicalNote>$valuefalsetruetrue1000
579
135
Y