Patient - 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.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Patient AttachmentsSelect valuesY Transform FilenamePatient Attachment OutputY Select valuesTransform FilenameY
Patient Attachment Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsID<act.patientDocumentAttachment>startTimefalsefalse<act.patientDocumentAttachment>descriptionfalsefalse<act.patientDocumentAttachment>fileNamefalsefalse<act.patientDocumentAttachment>statusfalseCOMPLETEDfalse<act.patientDocumentAttachment>patient[0]<participation.patient>entityfalse<party.patientpet>$valuefalse<act.patientDocumentAttachment>patient[0]<participation.patient>actfalse<act.patientDocumentAttachment>$valuefalsefalsetrue1000
488
151
Y
Patient Attachments
TableInput
Y
1
none
RxWorks
SELECT *
FROM Attachment WHERE (((Attachment.[Object Type])=2));
0
N
N
86
152
Y
Select values
SelectValues
Y
1
none
Attachment Code
ID
-2
-2
Object Number
PATIENTID
-2
-2
Path
FILENAME
-2
-2
Notes
DESCRIPTION
-2
-2
Created Date
DATE
-2
-2
207
151
Y
Transform Filename
ScriptValueMod
Y
1
none
0
Script 1
//Script here
328
151
Y