| QRYDATE(ARRAY,START,END) |
This entry point provides a list of OBS record IDs
(FILE 704.117, Field .01) for the date range specified.
Output format:
ARRAY(0)=number of records returned
ARRAY(n)=record ID (FILE 704.117, Field .01)
n = sequential number starting with 1
Example:
>K RESULT
>D QRYDATE^MDCLIO1("RESULT",3070301,3070401)
>ZW RESULT
RESULT(0)=3
RESULT(1)="{FD0FEBBC-8EC1-42E4-9483-4BDBE6370728}"
RESULT(2)="{A7C7FFEB-0CD5-4D55-BB34-35B9620F4ECC}"
RESULT(3)="{D0CEA9D2-A519-41C2-A4AE-9C24C7498E56}"
|
| VARIABLES |
TYPE |
VARIABLES DESCRIPTION |
ARRAY |
Both |
This is the name of the array to return the data in.
It is a closed array and surrounded in quotes (e.g., "RESULT" or "^TMP($J)").
(required)
|
START |
Input |
This is the date/time to begin the search. It is in
FileMan internal date/time format. If it is not defined, all records before
the END date/time are returned.
|
END |
Input |
This is the end date of the search. It is in FileMan
internal date/time format. If it is not defined, no records will be returned.
|
|
QRYOBS(ARRAY,GUID) |
This entry point returns the OBS (704.117) file data
for the specified record.
Output format:
ARRAY("AUDIT_EXISTS","E")=Field .911 (external)
ARRAY("AUDIT_EXISTS","I")=Field .911 (internal)
ARRAY("CHILD_ORDER","E")=Field .27 (external)
ARRAY("CHILD_ORDER","I")=Field .27 (internal)
ARRAY("COMMENT","E")=Field .4 (external)
ARRAY("COMMENT","I")=Field .4 (internal)
ARRAY("CONTEXT",0)=Number of "CONTEXT" records (in this example: 2)
ARRAY("CONTEXT",1,"METHOD_ID","E")="CONTEXT" nodes are returned when the
ARRAY("CONTEXT",1,"METHOD_ID","I")=node 'ARRAY("TERM_ID","E")="SpO2%"'.
ARRAY("CONTEXT",1,"OBS_ID","E")=These "CONTEXT" nodes will contain any
ARRAY("CONTEXT",1,"OBS_ID","I")=records about SUPPLEMENTATL OXYGEN
ARRAY("CONTEXT",1,"SVALUE","E")=FLOW RATE and SUPPLEMENTAL OXYGEN
ARRAY("CONTEXT",1,"SVALUE","I")=CONCENTRATION which are related to the
ARRAY("CONTEXT",1,"TERM_ID","E")=SpO2% reading.
ARRAY("CONTEXT",1,"TERM_ID","I")=
ARRAY("CONTEXT",1,"UNIT_ID","E")=
ARRAY("CONTEXT",1,"UNIT_ID","I")=
ARRAY("CONTEXT",2,"OBS_ID","E")=
ARRAY("CONTEXT",2,"OBS_ID","I")=
ARRAY("CONTEXT",2,"SVALUE","E")=
ARRAY("CONTEXT",2,"SVALUE","I")=
ARRAY("CONTEXT",2,"TERM_ID","E")=
ARRAY("CONTEXT",2,"TERM_ID","I")=
ARRAY("CONTEXT",2,"UNIT_ID","E")=
ARRAY("CONTEXT",2,"UNIT_ID","I")=
ARRAY("CORRECTION_FOR_ID","E")=Field .912 (external)
ARRAY("CORRECTION_FOR_ID","I")=Field .912 (internal)
ARRAY("ENTERED_BY_ID","E")=Field .26 (external)
ARRAY("ENTERED_BY_ID","I")=Field .26 (internal)
ARRAY("ENTERED_DATE_TIME","E")=Field .25 (external)
ARRAY("ENTERED_DATE_TIME","I")=Field .25 (internal)
ARRAY("FACILITY_ID","E")=Field .03 (external)
ARRAY("FACILITY_ID","I")=Field .03 (internal)
ARRAY("HOSPITAL_LOCATION_ID","E")=Field .04 (external)
ARRAY("HOSPITAL_LOCATION_ID","I")=Field .04 (internal)
ARRAY("LOCATION_ID","E")=FILE 704.118, Field .02 (external)
ARRAY("LOCATION_ID","I")=FILE 704.118, Field .02 (internal)
ARRAY("METHOD_ID","E")=FILE 704.118, Field .02 (external)
ARRAY("METHOD_ID","I")=FILE 704.118, Field .02 (internal)
ARRAY("OBSERVED_BY_ID","E")=Field .06 (external)
ARRAY("OBSERVED_BY_ID","I")=Field .06 (internal)
ARRAY("OBSERVED_DATE_TIME","E")=Field .05 (external)
ARRAY("OBSERVED_DATE_TIME","I")=Field .05 (internal)
ARRAY("OBS_ID","E")=Field .01 (external)
ARRAY("OBS_ID","I")=Field .01 (internal)
ARRAY("PARENT_ID","E")=Field .02 (external)
ARRAY("PARENT_ID","I")=Field .02 (internal)
ARRAY("PATIENT_ID","E")=Field .08 (external)
ARRAY("PATIENT_ID","I")=Field .08 (internal)
ARRAY("POSITION_ID","E")=FILE 704.118, Field .02 (external)
ARRAY("POSITION_ID","I")=FILE 704.118, Field .02 (internal)
ARRAY("RANGE","E")=Field .28 (external)
ARRAY("RANGE","I")=Field .28 (internal)
ARRAY("SOURCE","E")=Field .21 (external)
ARRAY("SOURCE","I")=Field .21 (internal)
ARRAY("SOURCE_COMMENTS","E")=Field .22 (external)
ARRAY("SOURCE_COMMENTS","I")=Field .22 (internal)
ARRAY("SOURCE_DATA_ITEM_ID","E")=Field .23 (external)
ARRAY("SOURCE_DATA_ITEM_ID","I")=Field .23 (internal)
ARRAY("SOURCE_VERSION","E")=Field .24 (external)
ARRAY("SOURCE_VERSION","I")=Field .24 (internal)
ARRAY("STATUS","E")=Field .09 (external)
ARRAY("STATUS","I")=Field .09 (internal)
ARRAY("SVALUE","E")=Field .1 (external)
ARRAY("SVALUE","I")=Field .1 (internal)
ARRAY("TERM_ID","E")=Field .07 (external)
ARRAY("TERM_ID","I")=Field .07 (internal)
ARRAY("UNIT_ID","E")=FILE 704.118, Field .02 (external)
ARRAY("UNIT_ID","I")=FILE 704.118, Field .02 (internal)
Example:
>D QRYOBS^MDCLIO1("ARRAY","{E24715DE-3DCC-4A04-9F8B-0A7C6E8E64F4}")
>ZW ARRAY
ARRAY("AUDIT_EXISTS","E")=0
ARRAY("AUDIT_EXISTS","I")=0
ARRAY("CHILD_ORDER","E")=""
ARRAY("CHILD_ORDER","I")=""
ARRAY("COMMENT","E")=""
ARRAY("COMMENT","I")=""
ARRAY("CONTEXT",0)=2
ARRAY("CONTEXT",1,"METHOD_ID","E")="NASAL CANNULA"
ARRAY("CONTEXT",1,"METHOD_ID","I")=4688666
ARRAY("CONTEXT",1,"OBS_ID","E")="{792FD976-2C7B-4BC0-8B6F-E62A520ED9AA}"
ARRAY("CONTEXT",1,"OBS_ID","I")="{792FD976-2C7B-4BC0-8B6F-E62A520ED9AA}"
ARRAY("CONTEXT",1,"SVALUE","E")=1
ARRAY("CONTEXT",1,"SVALUE","I")=1
ARRAY("CONTEXT",1,"TERM_ID","E")="SUPPLEMENTAL OXYGEN FLOW RATE"
ARRAY("CONTEXT",1,"TERM_ID","I")=""
ARRAY("CONTEXT",1,"UNIT_ID","E")="LITERS PER MINUTE"
ARRAY("CONTEXT",1,"UNIT_ID","I")=""
ARRAY("CONTEXT",2,"OBS_ID","E")="{BED624B4-A519-4928-B6EB-65C92653938E}"
ARRAY("CONTEXT",2,"OBS_ID","I")="{BED624B4-A519-4928-B6EB-65C92653938E}"
ARRAY("CONTEXT",2,"SVALUE","E")=100
ARRAY("CONTEXT",2,"SVALUE","I")=100
ARRAY("CONTEXT",2,"TERM_ID","E")="SUPPLEMENTAL OXYGEN CONCENTRATION"
ARRAY("CONTEXT",2,"TERM_ID","I")=""
ARRAY("CONTEXT",2,"UNIT_ID","E")="PERCENTAGE"
ARRAY("CONTEXT",2,"UNIT_ID","I")=""
ARRAY("CORRECTION_FOR_ID","E")=""
ARRAY("CORRECTION_FOR_ID","I")=""
ARRAY("ENTERED_BY_ID","E")="CPPROVIDER,ONE"
ARRAY("ENTERED_BY_ID","I")=547
ARRAY("ENTERED_DATE_TIME","E")="AUG 13, 2009@10:23:50"
ARRAY("ENTERED_DATE_TIME","I")=3090813.10235
ARRAY("FACILITY_ID","E")=""
ARRAY("FACILITY_ID","I")=""
ARRAY("HOSPITAL_LOCATION_ID","E")="2-AS"
ARRAY("HOSPITAL_LOCATION_ID","I")=1
ARRAY("METHOD_ID","E")="MONITOR"
ARRAY("METHOD_ID","I")=4688665
ARRAY("OBSERVED_BY_ID","E")="CPPROVIDER,ONE"
ARRAY("OBSERVED_BY_ID","I")=547
ARRAY("OBSERVED_DATE_TIME","E")="AUG 13, 2009@10:20"
ARRAY("OBSERVED_DATE_TIME","I")=3090813.102
ARRAY("OBS_ID","E")="{E24715DE-3DCC-4A04-9F8B-0A7C6E8E64F4}"
ARRAY("OBS_ID","I")="{E24715DE-3DCC-4A04-9F8B-0A7C6E8E64F4}"
ARRAY("PARENT_ID","E")=""
ARRAY("PARENT_ID","I")=""
ARRAY("PATIENT_ID","E")="CPPATIENT,ONE"
ARRAY("PATIENT_ID","I")=136
ARRAY("RANGE","E")="Normal"
ARRAY("RANGE","I")=1
ARRAY("SOURCE","E")="CP Flowsheets"
ARRAY("SOURCE","I")="CP Flowsheets"
ARRAY("SOURCE_COMMENTS","E")=""
ARRAY("SOURCE_COMMENTS","I")=""
ARRAY("SOURCE_DATA_ITEM_ID","E")="CPFLOWSHEETS.EXE:6C6B9A01"
ARRAY("SOURCE_DATA_ITEM_ID","I")="CPFLOWSHEETS.EXE:6C6B9A01"
ARRAY("SOURCE_VERSION","E")="1.0.16.276"
ARRAY("SOURCE_VERSION","I")="1.0.16.276"
ARRAY("STATUS","E")="Verified"
ARRAY("STATUS","I")=1
ARRAY("SVALUE","E")=100
ARRAY("SVALUE","I")=100
ARRAY("TERM_ID","E")="SpO2%"
ARRAY("TERM_ID","I")=4500637
ARRAY("UNIT_ID","E")="PERCENTAGE"
ARRAY("UNIT_ID","I")=""
Example of record not found:
>D QRYOBS^MDCLIO1("ARRAY","")
>ZW ARRAY
ARRAY(0)="-1^No such observation ''"
|
| VARIABLES |
TYPE |
VARIABLES DESCRIPTION |
ARRAY |
Both |
This is the name of the array to return the data in.
It is a closed array and surronded in quotes (e.g., "RESULT" or "^TMP($J)").
(required)
|
GUID |
Input |
This is the Global Unique ID (aka GUID - FILE
704.117, Field .01) value that identifies a record. (required)
|
|