/ YN
0.0 0.0 1000 1 1 N Y 5000 Y - 2007/04/20 14:09:23.197 RxWorks MSACCESS ODBC RxWorks -1 Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER-1 STREAM_RESULTSY USE_POOLINGN Transform Clinic FieldsLocationY Select Clinic FieldsTransform Clinic FieldsY Table inputSelect Clinic FieldsY Location OpenVPMSLoaderPlugin Y 1 none OpenVPMSCODENAME<party.organisationLocation>namefalsefalseNAME<party.organisationLocation>currencyfalseAUDfalseADDRESS<party.organisationLocation>contacts[0]<contact.location>addressfalsefalsePHONENO<party.organisationLocation>contacts[0]<contact.phoneNumber>telephoneNumbertruefalseEMAIL<party.organisationLocation>contacts[0]<contact.email>emailAddressfalsefalseCODE<entityRelationship.practiceLocation>targettrue<party.organisationLocation>$valuefalseCODE<entityRelationship.practiceLocation>sourcetrue<party.organisationPractice>1falsetruetrue1000 674 243 Y Select Clinic Fields SelectValues Y 1 none Clinic Code CODE -2 -2 Clinic Name NAME -2 -2 Clinic Address ADDRESS -2 -2 Clinic Phone Number PHONENO -2 -2 Clinic Fax Number FAXNO -2 -2 Clinic Email Address EMAIL -2 -2 256 247 Y Table input TableInput Y 1 none RxWorks SELECT * FROM Clinic 0 N N 119 250 Y Transform Clinic Fields ScriptValueMod Y 1 none