Patient - Visit Attachments
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/06/01 09:16:32.498
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
Visit AttachmentsSelect valuesY Transform FilenameVisit Attachment OutputY Select valuesTransform FilenameY
Visit Attachment Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsIDDATE<act.patientDocumentAttachment>startTimefalsefalseDESCRIPTION<act.patientDocumentAttachment>descriptionfalsefalseFILENAME<act.patientDocumentAttachment>fileNamefalsefalseDESCRIPTION<act.patientDocumentAttachment>statusfalseCOMPLETEDfalsePATIENTID<act.patientDocumentAttachment>patient[0]<participation.patient>entityfalse<party.patientpet>$valuefalseID<act.patientDocumentAttachment>patient[0]<participation.patient>actfalse<act.patientDocumentAttachment>$valuefalseVISITID<actRelationship.patientClinicalEventItem>sourcefalse<act.patientClinicalEvent>$valuefalseID<actRelationship.patientClinicalEventItem>targetfalse<act.patientDocumentAttachment>$valuefalsefalsetrue1000
562
153
Y
Visit Attachments
TableInput
Y
1
none
RxWorks
SELECT *
FROM Attachment INNER JOIN (Consultation INNER JOIN Visit ON Visit.[Visit Number] = Consultation.[Visit Number]) ON Attachment.[Object Number] = Consultation.[Consultation Number]
WHERE (((Attachment.[Object Type])=3));
0
N
N
86
152
Y
Select values
SelectValues
Y
1
none
Attachment Code
ID
-2
-2
Object Number
VISITID
-2
-2
Path
FILENAME
-2
-2
Notes
DESCRIPTION
-2
-2
Created Date
DATE
-2
-2
Patient Number
PATIENTID
-2
-2
207
151
Y
Transform Filename
ScriptValueMod
Y
1
none
0
Script 1
//Script here
388
151
Y