SDES2QRYAPREQS ;ALB/BWF - QUERY APPOINTMENT REQUESTS; JAN 4,2023
Source file <SDES2QRYAPREQS.m>
Name | Comments | DBIA/ICR reference |
---|---|---|
QUERY(JSONRETURN,SDCONTEXT,SDINPUT) | ;
|
|
VALIDATE(ERRORS,SDINPUT,FLTRORIGDATE,FLTRPIDDATE,STARTDT,ENDDT) | ;
|
|
FINDBYPAT(ERRORS,SDINPUT,FLTRORIGDATE,FLTRPIDDATE,STARTDT,ENDDT) | ;
; get consults for this patient |
|
BUILDXREF(SORT) | ;
|
|
BUILDRESULTS(RETURNNUMREC,REQUESTS,SDDUZ) | ;
|
|
BUILDBYLASTREC(LASTRECORD,NUMRECORDS,REQUESTS,SDDUZ) | ;
|
|
VALREQTYPE(ERRORS,SDINPUT) | ;
|
|
VALWAITTIME(ERRORS,WAITTIME) | ;
|
|
VALPRIOGROUP(ERRORS,SDINPUT) | ;
|
|
VALSORT(ERRORS,SORT) | ;
|
Name | Field # of Occurrence |
---|---|
$$GET1^DIQ | FINDBYPAT+15, BUILDRESULTS+9, BUILDBYLASTREC+9 |
GETREQUEST^SDES2GETAPPTREQ | BUILDRESULTS+7, BUILDBYLASTREC+7 |
GETCONSULT^SDES2GETCONSULTS | BUILDRESULTS+8, BUILDBYLASTREC+8 |
GETRECALL^SDES2GETRECALL | BUILDRESULTS+9, BUILDBYLASTREC+9 |
BUILDJSON^SDES2JSON | QUERY+7, QUERY+11 |
ERRLOG^SDES2JSON | VALREQTYPE+6, VALWAITTIME+2, VALSORT+1 |
$$REQCHK^SDES2QRYAPREQSA | FINDBYPAT+34, FINDBYPAT+43 |
FINDBYREQ^SDES2QRYAPREQSA | QUERY+34 |
GETSVC^SDES2QRYAPREQSA | FINDBYPAT+25 |
FLTRAPPTREQ^SDES2QRYAPREQSB | FINDBYPAT+16 |
FLTRCONSULT^SDES2QRYAPREQSB | FINDBYPAT+36, FINDBYPAT+44 |
FLTRRECALL^SDES2QRYAPREQSB | FINDBYPAT+51 |
GETPATENR^SDES2QRYAPREQSB | FINDBYPAT+7, FINDBYPAT+35 |
VALCONTEXT^SDES2VALCONTEXT | QUERY+6 |
$$VALISODTTM^SDES2VALISODTTM | VALIDATE+22, VALIDATE+25 |
VALFIELD^SDES2VALUTIL | VALPRIOGROUP+5 |
VALFILEIEN^SDES2VALUTIL | VALIDATE+4, VALIDATE+9, VALIDATE+12, VALIDATE+27 |
VALNUMBERRNG^SDES2VALUTIL | VALIDATE+33, VALIDATE+39 |
$$FMADD^XLFDT | VALWAITTIME+5, VALWAITTIME+7 |
ENCODE^XLFJSON | QUERY+18, QUERY+30, QUERY+42 |
RPC Name | Call Tags |
---|---|
SDES2 QUERY APPT REQUESTS | QUERY |
FileNo | Call Tags |
---|---|
^SD(403.5 - [#403.5] | GET1^DIQ |
^SDEC(409.85 - [#409.85] | GET1^DIQ |
Name | Line Occurrences (* Changed, ! Killed) |
---|---|
^GMR(123 - [#123] | FINDBYPAT+32, FINDBYPAT+33, FINDBYPAT+40, FINDBYPAT+42 |
^ORD(100.01 - [#100.01] | FINDBYPAT+26, FINDBYPAT+27 |
^SD(403.5 - [#403.5] | FINDBYPAT+50 |
^SDEC(409.85 - [#409.85] | FINDBYPAT+14 |
^TMP("SDES2QUERY" | QUERY+3!, QUERY+5, BUILDXREF+4, BUILDXREF+5, BUILDXREF+6, BUILDXREF+7, BUILDXREF+8, BUILDXREF+9, BUILDXREF+11*, BUILDXREF+12 , BUILDXREF+13, BUILDXREF+14, BUILDXREF+16*, BUILDRESULTS+3, BUILDRESULTS+4, BUILDRESULTS+5, BUILDBYLASTREC+4, BUILDBYLASTREC+5, BUILDBYLASTREC+6 |
Name | Line Occurrences |
---|---|
$$BUILDBYLASTREC | QUERY+15 |
$$BUILDRESULTS | QUERY+24, QUERY+36 |
$$BUILDXREF | QUERY+23, QUERY+35 |
$$VALWAITTIME | VALIDATE+15 |
FINDBYPAT | QUERY+22 |
VALIDATE | QUERY+10 |
VALPRIOGROUP | VALIDATE+19 |
VALREQTYPE | VALIDATE+6 |
VALSORT | VALIDATE+30 |
>> | Not killed explicitly |
* | Changed |
! | Killed |
~ | Newed |
Name | Field # of Occurrence |
---|---|
CONEND | FINDBYPAT+2~, FINDBYPAT+38*, FINDBYPAT+39 |
CONSIEN | FINDBYPAT+2~, FINDBYPAT+33*, FINDBYPAT+34, FINDBYPAT+36, FINDBYPAT+41*, FINDBYPAT+42*, FINDBYPAT+43, FINDBYPAT+44 |
CONSTART | FINDBYPAT+2~, FINDBYPAT+38*, FINDBYPAT+40 |
CONSTAT | FINDBYPAT+2~ |
COUNT | FINDBYPAT+2~, FINDBYPAT+4*, FINDBYPAT+16, FINDBYPAT+36, FINDBYPAT+44, FINDBYPAT+51, BUILDXREF+1~, BUILDBYLASTREC+1~, BUILDBYLASTREC+2*, BUILDBYLASTREC+4 , BUILDBYLASTREC+11* |
CURRENTENR | FINDBYPAT+2~, FINDBYPAT+7, FINDBYPAT+35 |
DESDATE | BUILDXREF+1~, BUILDXREF+6*, BUILDXREF+7, BUILDXREF+8, BUILDXREF+9 |
DFN | FINDBYPAT+2~, FINDBYPAT+5*, FINDBYPAT+7, FINDBYPAT+14, FINDBYPAT+35, FINDBYPAT+40, FINDBYPAT+42, FINDBYPAT+50, BUILDRESULTS+1~, BUILDRESULTS+9* , BUILDBYLASTREC+1~, BUILDBYLASTREC+9* |
DT | VALWAITTIME+5, VALWAITTIME+7 |
DUZ | QUERY+9 |
ENDDDT | QUERY+1~ |
ENDDT | QUERY+10, QUERY+22, QUERY+34, VALIDATE~, VALIDATE+2*, VALIDATE+17*, FINDBYPAT~, FINDBYPAT+16, FINDBYPAT+31, FINDBYPAT+36 , FINDBYPAT+38, FINDBYPAT+44, FINDBYPAT+51 |
ENRRET | FINDBYPAT+2~ |
ERRORS | QUERY+1~, QUERY+6, QUERY+7, QUERY+10, QUERY+11, QUERY+22, QUERY+34, VALIDATE~, VALIDATE+4, VALIDATE+6 , VALIDATE+9, VALIDATE+12, VALIDATE+15, VALIDATE+19, VALIDATE+22, VALIDATE+25, VALIDATE+27, VALIDATE+30, VALIDATE+33, VALIDATE+39 , FINDBYPAT~, VALREQTYPE~, VALREQTYPE+6, VALWAITTIME~, VALWAITTIME+2, VALPRIOGROUP~, VALPRIOGROUP+5, VALSORT~, VALSORT+1 |
ERRORS("QueryResults" | QUERY+7*, QUERY+11* |
FLTRORIGDATE | QUERY+1~, QUERY+10, QUERY+22, QUERY+34, VALIDATE~, VALIDATE+2*, VALIDATE+22*, FINDBYPAT~, FINDBYPAT+16, FINDBYPAT+36 , FINDBYPAT+44, FINDBYPAT+51 |
FLTRPIDDATE | QUERY+1~, QUERY+10, QUERY+22, QUERY+34, VALIDATE~, VALIDATE+2*, VALIDATE+25*, FINDBYPAT~, FINDBYPAT+16, FINDBYPAT+36 , FINDBYPAT+44, FINDBYPAT+51 |
GMRSERVICE | FINDBYPAT+3~, FINDBYPAT+28*, FINDBYPAT+32, FINDBYPAT+33 |
GMRSVC | FINDBYPAT+3~, FINDBYPAT+25 |
GMRSVC( | FINDBYPAT+28 |
GRP | VALPRIOGROUP+1~, VALPRIOGROUP+4* |
INVDTTM | FINDBYPAT+2~, FINDBYPAT+39*, FINDBYPAT+40*, FINDBYPAT+42 |
INVSTART | FINDBYPAT+3~, FINDBYPAT+31*, FINDBYPAT+32*, FINDBYPAT+33 |
JSONRETURN | QUERY~, QUERY+5*, QUERY+7, QUERY+11, QUERY+18, QUERY+30, QUERY+42 |
LASTREC | QUERY+1~, QUERY+24*, QUERY+29, QUERY+36*, QUERY+41, BUILDRESULTS+1~, BUILDRESULTS+2*, BUILDRESULTS+6*, BUILDRESULTS+10 |
LASTRECORD | BUILDBYLASTREC~, BUILDBYLASTREC+3 |
NEWLASTREC | QUERY+1~, QUERY+15*, QUERY+17 |
NEWLASTRECORD | BUILDBYLASTREC+1~, BUILDBYLASTREC+2*, BUILDBYLASTREC+10*, BUILDBYLASTREC+12 |
NUMRECORDS | VALIDATE+1~, VALIDATE+32*, VALIDATE+33, VALIDATE+34, VALIDATE+36, BUILDBYLASTREC~, BUILDBYLASTREC+4 |
ORIGDT | BUILDXREF+1~, BUILDXREF+7*, BUILDXREF+8, BUILDXREF+9 |
OSACT | FINDBYPAT+3~, FINDBYPAT+26*, FINDBYPAT+29 |
OSPEND | FINDBYPAT+3~, FINDBYPAT+27*, FINDBYPAT+29 |
PATIENT | FINDBYPAT+2~ |
PATSCPERCENT | FINDBYPAT+2~, FINDBYPAT+7, FINDBYPAT+16, FINDBYPAT+35, FINDBYPAT+36, FINDBYPAT+44, FINDBYPAT+51 |
PATSVCCONN | FINDBYPAT+2~, FINDBYPAT+7, FINDBYPAT+16, FINDBYPAT+35, FINDBYPAT+36, FINDBYPAT+44, FINDBYPAT+51 |
PCE | FINDBYPAT+2~ |
PGROUP | VALPRIOGROUP+1~, VALPRIOGROUP+2*, VALPRIOGROUP+3, VALPRIOGROUP+5 |
PRIOGRP | BUILDXREF+1~, BUILDXREF+4*, BUILDXREF+5, BUILDXREF+6, BUILDXREF+7, BUILDXREF+8, BUILDXREF+9 |
PRIORITYGROUP | FINDBYPAT+2~, FINDBYPAT+7, FINDBYPAT+8, FINDBYPAT+16, FINDBYPAT+35, FINDBYPAT+36, FINDBYPAT+44, FINDBYPAT+51 |
RECALLIEN | FINDBYPAT+3~, FINDBYPAT+50*, FINDBYPAT+51 |
RECORDER | BUILDXREF+2*, BUILDXREF+3, BUILDXREF+10*, BUILDXREF+11, BUILDXREF+15*, BUILDXREF+16, BUILDXREF+17, BUILDRESULTS+1~, BUILDRESULTS+3*, BUILDRESULTS+4 , BUILDRESULTS+5, BUILDRESULTS+6, BUILDBYLASTREC+1~, BUILDBYLASTREC+3*, BUILDBYLASTREC+4*, BUILDBYLASTREC+5, BUILDBYLASTREC+6, BUILDBYLASTREC+10 |
REQCNT | FINDBYPAT+2~, FINDBYPAT+13*, FINDBYPAT+14, FINDBYPAT+16, FINDBYPAT+20*, FINDBYPAT+29, FINDBYPAT+32, FINDBYPAT+33, FINDBYPAT+36, FINDBYPAT+40 , FINDBYPAT+42, FINDBYPAT+44, FINDBYPAT+49*, FINDBYPAT+50, FINDBYPAT+51 |
REQIEN | FINDBYPAT+2~, FINDBYPAT+14*, FINDBYPAT+15, FINDBYPAT+16, BUILDXREF+1~, BUILDXREF+8*, BUILDXREF+9, BUILDXREF+11, BUILDXREF+13*, BUILDXREF+14 , BUILDXREF+16, BUILDRESULTS+1~, BUILDRESULTS+4*, BUILDRESULTS+5, BUILDRESULTS+7, BUILDRESULTS+8, BUILDRESULTS+9, BUILDBYLASTREC+1~, BUILDBYLASTREC+5*, BUILDBYLASTREC+6 , BUILDBYLASTREC+7, BUILDBYLASTREC+8, BUILDBYLASTREC+9 |
REQTYPE | BUILDXREF+1~, BUILDXREF+9*, BUILDXREF+11, BUILDXREF+14*, BUILDXREF+16, BUILDRESULTS+1~, BUILDRESULTS+5*, BUILDRESULTS+7, BUILDRESULTS+8, BUILDRESULTS+9 , BUILDBYLASTREC+1~, BUILDBYLASTREC+6*, BUILDBYLASTREC+7, BUILDBYLASTREC+8, BUILDBYLASTREC+9 |
REQUESTS | QUERY+1~, QUERY+15, QUERY+16, QUERY+24, QUERY+25, QUERY+36, QUERY+37, BUILDRESULTS~, BUILDRESULTS+7, BUILDRESULTS+8 , BUILDRESULTS+9, BUILDBYLASTREC~, BUILDBYLASTREC+7, BUILDBYLASTREC+8, BUILDBYLASTREC+9 |
REQUESTS("LastRecord" | QUERY+17* |
REQUESTS("QueryResults" | QUERY+16*, QUERY+26*, QUERY+27*, QUERY+28*, QUERY+29*, QUERY+38*, QUERY+39*, QUERY+40*, QUERY+41* |
RETURNNUMREC | BUILDRESULTS~, BUILDRESULTS+3, BUILDRESULTS+4 |
RETURNRECORDCNT | VALIDATE+1~, VALIDATE+38*, VALIDATE+39, VALIDATE+40 |
SDBEG | VALWAITTIME+1~, VALWAITTIME+3*, VALWAITTIME+5*, VALWAITTIME+6*, VALWAITTIME+9 |
SDCONTEXT | QUERY~, QUERY+6 |
SDCONTEXT("US | ER DUZ" , QUERY+9 |
SDDUZ | QUERY+1~, QUERY+9*, QUERY+15, QUERY+24, QUERY+36, BUILDRESULTS~, BUILDRESULTS+7, BUILDRESULTS+8, BUILDRESULTS+9, BUILDBYLASTREC~ , BUILDBYLASTREC+7, BUILDBYLASTREC+8, BUILDBYLASTREC+9 |
SDEND | VALWAITTIME+1~, VALWAITTIME+4*, VALWAITTIME+7*, VALWAITTIME+8*, VALWAITTIME+9 |
SDINPUT | QUERY~, QUERY+10, QUERY+22, QUERY+34, VALIDATE~, VALIDATE+6, VALIDATE+19, FINDBYPAT~, FINDBYPAT+16, FINDBYPAT+36 , FINDBYPAT+44, FINDBYPAT+51, VALREQTYPE~, VALPRIOGROUP~ |
SDINPUT("FILTER" | QUERY+21, QUERY+33, VALIDATE+3, VALIDATE+8, VALIDATE+11, VALIDATE+14*, VALIDATE+15, VALIDATE+21, VALIDATE+22, VALIDATE+24 , VALIDATE+25, VALIDATE+27, FINDBYPAT+5, FINDBYPAT+8, FINDBYPAT+11, FINDBYPAT+12, FINDBYPAT+19, FINDBYPAT+22, FINDBYPAT+23, FINDBYPAT+47 , FINDBYPAT+48, VALREQTYPE+3*, VALREQTYPE+5, VALPRIOGROUP+2, VALPRIOGROUP+4*, VALPRIOGROUP+6* |
SDINPUT("LAST | RECORD" , QUERY+3, QUERY+14, QUERY+15, VALIDATE+34 |
SDINPUT("MAX | NUMBER OF RECORDS" , QUERY+15, VALIDATE+32, VALIDATE+34*, VALIDATE+36*, FINDBYPAT+14, FINDBYPAT+29, FINDBYPAT+32, FINDBYPAT+33, FINDBYPAT+40 , FINDBYPAT+42, FINDBYPAT+50 |
SDINPUT("RETU | RN NUMBER OF RECORDS" , QUERY+24, QUERY+36, VALIDATE+38, VALIDATE+40* |
SDINPUT("SORT" | QUERY+23, QUERY+35, VALIDATE+29*, VALIDATE+30 |
SERVICE | FINDBYPAT+3~, FINDBYPAT+23*, FINDBYPAT+24 |
SERVICELIST | FINDBYPAT+3~, FINDBYPAT+25 |
SERVICELIST( | FINDBYPAT+24* |
SERVICEREL | BUILDXREF+1~, BUILDXREF+5*, BUILDXREF+6, BUILDXREF+7, BUILDXREF+8, BUILDXREF+9 |
SORT | BUILDXREF~, BUILDXREF+3, VALSORT~, VALSORT+1 |
SORTBY | BUILDXREF+1~, BUILDXREF+12*, BUILDXREF+13, BUILDXREF+14 |
STARTDT | QUERY+1~, QUERY+10, QUERY+22, QUERY+34, VALIDATE~, VALIDATE+2*, VALIDATE+16*, FINDBYPAT~, FINDBYPAT+16, FINDBYPAT+32 , FINDBYPAT+36, FINDBYPAT+38, FINDBYPAT+44, FINDBYPAT+51 |
STAT | FINDBYPAT+3~, FINDBYPAT+29*, FINDBYPAT+30, FINDBYPAT+32, FINDBYPAT+33 |
STRTENDDATES | VALIDATE+1~, VALIDATE+15*, VALIDATE+16, VALIDATE+17 |
TOTALRECORDS | QUERY+1~, QUERY+23*, QUERY+28, QUERY+35*, QUERY+40 |
TYPE | VALREQTYPE+1~, VALREQTYPE+5*, VALREQTYPE+6 |
U | VALIDATE+16, VALIDATE+17, VALWAITTIME+9 |
VALSTAT | VALIDATE+1~, VALIDATE+33, VALIDATE+39 |
VCLIN | VALIDATE+1~, VALIDATE+8*, VALIDATE+9 |
VPAT | VALIDATE+1~, VALIDATE+3*, VALIDATE+4 |
VRET | VALIDATE+1~, VALIDATE+4, VALIDATE+9, VALIDATE+12, VALIDATE+27, VALPRIOGROUP+5 |
VRET( | VALPRIOGROUP+6 |
VSRV | VALIDATE+1~, VALIDATE+11*, VALIDATE+12 |
WAITTIME | VALWAITTIME~, VALWAITTIME+2, VALWAITTIME+3, VALWAITTIME+4 |