We've just started using Health Connect and I've found that a lot of the messages we get from our patient admin system (System C's CareFlow EPR) don't match the standard 2.3.1 schema (eg 2.3.1 ADT A02 message spec doesn't include NK1 segments, but the ones we receive do)

Does anyone have a custom schema they use for messages from CareFlow EPR that they'd be willing to share?

0 0
0 30

I have an SQL table as below (columns - ID and Value)

I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID

as -

if ID = 11 ; QRY output = aaa,bbb

if ID = 22 ; QRY output = xxx,yyy,zzz

can someone help me with query

ID Value
----------
11 aaa
22 xxx
22 yyy
11 bbb
22 zzz
-----------

0 1
0 18

Hi, I'm working on a large extraction from a database and need to parallelize the processes during the extraction.

Here's what happens:

  1. The user starts the extraction from.
  2. Several jobs are started using the Job <Method> instruction.

At the end, the user expects to find a document containing the results of all the extractions. What I'd like to do is start a new job that checks whether the previously started jobs have finished or are still working and consequently produce the document.

0 0
0 7