Patient - Relationships
/
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.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Select Owner fieldsFilter nullsY Filter nullsDummy (do nothing)Y Table inputSelect Owner fieldsY Filter nullsModified Java Script ValueY Modified Java Script ValuePatient OwnerY
Dummy (do nothing)
Dummy
Y
1
none
380
62
Y
Filter nulls
FilterRows
Y
1
none
Modified Java Script Value
Dummy (do nothing)
N
N
PATIENTID
<>
constantNumber0.0-1-1N
N
AND
PATIENTID
IS NOT NULL
N
AND
ACCOUNTID
<>
constantInteger 0-10N
N
AND
ACCOUNTID
IS NOT NULL
382
149
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
// Create a unique Patient ID
var ID = num2str(ACCOUNTID.getNumber()) + "." + num2str(PATIENTID.getNumber())
ID
ID
String
-1
-1
517
150
Y
Patient Owner
OpenVPMSLoaderPlugin
Y
1
none
openvpmsID<entityRelationship.patientOwner>targettrue<party.patientpet>$valuefalse<entityRelationship.patientOwner>sourcetrue<party.customerperson>$valuefalsefalsetrue1000
662
149
Y
Select Owner fields
SelectValues
Y
1
none
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
212
145
Y
Table input
TableInput
Y
1
none
Quickvet
SELECT
AccountNumber
, PetNumber
, [Rabies Tag Number]
, [License Number]
, LicenseDate
, EntryDate
, [First Visit]
, PetName
, [Fee Schedule]
, Species
, Breed
, Color
, DOB
, Sex
, Weight
, Personality
, Abnormalities
, Rabies
, [Rabies Period]
, DHLPPV
, DHLPP
, HW
, [HW Test]
, HWPV
, [HWPV Type]
, HWSupply
, FELV
, FVRCPRV
, FVRCP
, [FVRCP/FELV]
, [Fecal(O&P)]
, Bordatella
, Lymes
, FIP
, [Fel MCK]
, FERVAC
, Dental
, Comments
, Status
, [Send Reminder]
, [Adding User]
, [Adding Date]
, [Mod Date]
, FldTemp
, FldTemp1
, [Animal Number]
, [Microchip Number]
, Desexing
, [Next Dental]
, PI2
, [Next Shots]
, [5 in 1]
, Tetanus
, Strangles
, Vax10
, Vax11
, LastName
, FirstName
, Details
FROM PetRec
0
N
N
75
147
Y