0.00.0100011NY5000Yadmin2007/04/09 12:20:17.563RxWorksMSACCESSODBCRxWorks-1Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500EXTRA_OPTION_MYSQL.useCursorFetchtrueIS_CLUSTEREDNMAXIMUM_POOL_SIZE10PORT_NUMBER-1STREAM_RESULTSYUSE_POOLINGNTransform Visit FieldsVisit NotesYSelect Visit FieldsFilter rowsYFilter rowsDummy (do nothing)YFilter rowsTransform Visit FieldsYTable inputSelect Visit FieldsYDummy (do nothing)DummyY1none342242YFilter rowsFilterRowsY1noneTransform Visit FieldsDummy (do nothing)NNANDPATIENT<>constantInteger-1-10NNANDTEXTIS NOT NULL338136YSelect Visit FieldsSelectValuesY1noneConsultation NumberVISITNO-2-2Consultation DateSTARTTIME-2-2Consultation WeightWEIGHT-2-2Patient NumberPATIENT-2-2Examination TextTEXT-2-2Consulting VetCLINICIAN-2-2Special InstructionsINSTRUCTIONS-2-2VISITNOString-2-2229135YTable inputTableInputY1noneRxWorksSELECT *
FROM Consultation c inner join visit v on c.[Visit Number] = v.[Visit Number]
0NN97138YTransform Visit FieldsScriptValueModY1none0Script 1
var VISITITEMID = "NOTES" + VISITNO.getString();
-1num2str_Sample// Converts a numeric Value to a String with the
// given format.
//
// Usage:
// num2str(var);
// 1. String - The String to convert.
// The converstation uses the standard localized format.
//
// num2str(var,var);
// 1. String - The String to convert.
// 2. String - The Format
//
// num2str(var,var,var);
// 1. String - The String to convert.
// 2. String - The Format
// 3: String - The Locale Parameter
// An valid ISO Language Code. (DE = German, EN = English, FR = France, ...)
//
// 2006-11-15
//
var d1 = 123.40;
var d2 = -123.40;
Alert(num2str(d1));
Alert(num2str(d1, "0.00"));
Alert(num2str(d1, "0.00", "EN"));
Alert(num2str(d2, "0.00;(0.00)", "EN"));
VISITITEMIDVISITITEMIDString-1-1442134YVisit NotesOpenVPMSLoaderPluginN1noneopenvpmsVISITITEMIDSTARTTIME<act.patientClinicalNote>startTimetruefalseTEXT<act.patientClinicalNote>notetruefalsePATIENT<act.patientClinicalNote>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseVISITITEMID<act.patientClinicalNote>patient[0]<participation.patient>acttrue<act.patientClinicalNote>$valuefalseCLINICIAN<act.patientClinicalNote>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseVISITITEMID<act.patientClinicalNote>clinician[0]<participation.clinician>acttrue<act.patientClinicalNote>$valuefalseVISITNO<actRelationship.patientClinicalEventItem>sourcetrue<act.patientClinicalEvent>$valuefalseVISITITEMID<actRelationship.patientClinicalEventItem>targettrue<act.patientClinicalNote>$valuefalsetruetrue1000590135Y