CODEWITHSUNDEEP
database
mbm29414
mbm29414

Reputation: 11598

Anybody recognize this script?

I've got a consulting IT request to examine a dataset for a court case. Suffice to say, I can't provide a whole lot of detail.

At the top of the dataset, there is what appears to be the query that generated the dataset, but it's in a format I've never seen. It seems fairly easy to figure out what the query is selecting, but I was wondering whether anyone here was able to identify what system is running this script.

Here's the script, de-identified:

SMSLIST OPTIONS PAGE LENGTH 055 MARGINS 001 00132 LIMIT 01000
 LINE SPACING 0
REQUEST TITLE 'TITLE'
COLUMNS "OBSV PERF DATE" HEADING 'DATE'
 , "OBSV PERF TIME" HEADING 'TIME'
 , "OBSV CD"
 , "OBSV CD NAME" HEADING 'OBSERVATION'
 , "OBSV DSPLY VAL" HEADING 'VALUE'
 , "OBSV VAL STS CD" HEADING 'STATUS'
ORDERED BY "OBSV CD" , "OBSV PERF DATE" , "OBSV PERF TIME"
WHERE (  "PT NO"  EQ (XXXXXXXX)  AND  "OBSV CD GRP NAME"  IN ('VITALS+WT','I/O'
) )

Upvotes: 1

Views: 67

Answers (2)

John Straka
John Straka

Reputation: 1914

I doubt you're still working on this a year later, but I believe it's for Siemens Medical Solutions.

Upvotes: 0

cjstehno
cjstehno

Reputation: 13994

I was had some time this morning and love a challenge so I tried to give you a hand. It looks like it is the query language for something called "AD HOC Wizard Report Builder", here is a link to a page from their manual where similar content is shown: Detail List Report Sample.

There were also a lot of hits on some UNC list server, but none of the pages were available.

Sorry, that's all I could find, but maybe that helps a bit.

Upvotes: 2

Related Questions