Home iWeb About Us Contact Us Press
Search 
 
NPR Select Fields Lookups
Information & Resources>  NPR Lookup Reference  
NPR Lookups


NPR select fields that provide a lookup of records

Client/Server Lookups

The technique to select one, or a list of records from a DPM and detail segment via selection on a field that allows the user to use "lookups" varies from module to module. In some modules, you should use NO index and a selection on URN. In others, you must use an index and a selection on a subscript of the index file. Here is a table with the values to use for several DPMs to save you time and trouble.

DPM Detail Segment Index Field and Comments

ABS.PAT

main

abs.pat.number.x

account.number

ADM.PAT

main

do not use one

urn

BAR.PAT

top

bar.acct.number.x

number

BAR.PAT

top

bar.acct.guar.index

select on guar.id with IG then set up select
as below:

LAB.L.SPEC

various

do not use one

urn

LAB.B.SPEC

various

do not use one

urn

LAB.M.SPEC

various

do not use one

urn

PHA.RX

main

pha.rx.number.x

number

PHA.RX

main

pha.rx.patient.index

PHA.PAT.patient IG
then
patient    EQ
(/[“aa”])
does not work for LI

PHA.RX

main

pha.rx.number.x

urn
Select urn IG and
number  EQ
(c.urn)

NOTE:  Do not write a PHA.RX report with a select on urn.  Your value of c.urn will end up being the “number” field and you will therefore select the RX from a different patient if the urn of an rx matches the “number” of the patient’s RX you selected.  This is an unfortunate result of the ID code attached to the urn field, which returns the value of “number” to c.urn when the ID program runs.

PP.PER

main

pp.employee.name.index

sort.name

PP.PER

main

pp.employee.ss.si.index

ss.number


MAGIC Record Lookups


DPM Detail Segment Index Field and Comments

ABS.PAT

abs.pat

abs.pat.number.x

account.number

ADM.PAT

adm.patient.file

do not use one

urn

BAR.PAT

bar.acct

bar.acct.number.x

number

BAR.PAT

bar.acct

bar.acct.guar.index

select on guar.id with IG then set up select
as below:


 

BAR.RPT

 

do not use one

list.urn

ID=%Z.id.non.dict.rev.color(^?BRI[TYPE],A,"File#":12L_("Printed
ID=On":21L)_("By":10L),"CD:12L_(%Z.date.out(*BR[CD]|1):9L)_(*BR[CD]|2:12L)_*BR[CD]|3")
ID.ARG=BR
TYPE = GSTMTS, BD XFER, BILLS, CL BILLS, CPU, FORMS, LETTERS(TX) SEL.RPTS or STMTS

LAB.L.SPEC

Various

do not use one

urn

LAB.B.SPEC

various

do not use one

urn

LAB.M.SPEC

various

do not use one

urn

MRI.PAT

mri.patient.file

do not use one

mri.urn  EQ or IG
then medical.record EQ c.mri.urn

PHA.RX

pha.rx.file

pha.rx.number.x

number

PHA.RX

pha.rx.file

pha.rx.patient.index

PHA.PAT.patient IG
then
patient    EQ
(/[“aa”])
does not work for LI

PHA.RX

pha.rx.file

pha.rx.number.x

urn
Select urn IG
and
number  EQ
(c.urn)

NOTE:  Do not write a PHA.RX report with a select on urn.  Your value of c.urn will end up being the “number” field and you will therefore select the RX from a different patient if the urn of an rx matches the “number” of the patient’s RX you selected.  This is an unfortunate result of the ID code attached to the urn field, which returns the value of “number” to c.urn when the ID program runs.

PP.PER

pp.employee.file

pp.employee.name.index

sort.name

PP.PER

pp.employee.file

pp.employee.ss.si.index

ss.number

RADRW.EXAM

radiology.exam.information

do not use one

rad

SCH.APPT

sch.appointment

do not need one

patient      IG and
mri.urn     EQ
/[“ea”]

PC File ID

   

%Z.dos.link.long(1)


Event Schedule
Please find below a list of upcoming events that Iatric Systems will be attending and/or sponsoring.

For more information about our upcoming events or any other aspect of Iatric Systems, please contact us via e-mail at info@iatric.com.

DateDescription
10/28/14 - 10/31/14CHIME 2014 Fall CIO Forum - San Antonio, TX

Webcast Schedule
Please find our list of free upcoming Webcasts below which are open to all hospitals.

To register, simply click the appropriate Webcast Date which will redirect you to our registration web site. After you have submitted your registration request via this site, we will promptly send you a confirmation and instructions on how to participate. If you have any questions or need assistance with the registration process, please contact us via e-mail at webcasts@iatric.com.

Please Note: All webcast times listed are Eastern Time and most webcasts are approximately one hour in duration.

DateDescription
10/23/2014 2:00 PMMeaningful Use Stage 2 - Are you ready?
10/28/2014 2:00 PMEpic Reporting Tools for MEDITECH NPR Developers
10/30/2014 12:00 PMEpic Reporting Tools for MEDITECH NPR Developers
11/04/2014 2:00 PMCost Justify Vital Signs and Smart Pump Integration with Your EHR
11/06/2014 12:00 PMSQL Performance Patterns with Epic Data
11/11/2014 2:00 PMSQL Performance Patterns with Epic Data
11/12/2014 2:00 PMCost Justify Vital Signs and Smart Pump Integration with Your EHR
11/18/2014 2:00 PMAutomate Patient Privacy Monitoring
12/10/2014 1:00 PMHow to Optimize Your Privacy Program

NPR Lookup Reference


NPR select fields that provide a lookup of records to help save you time and trouble when working with NPR Reports.


LinkedIn


Facebook Google+ Twitter YouTube
© 1996 - 2014 Iatric Systems, Inc. All Rights Reserved | (978) 805-4100 | info@iatric.com | Terms of Use | Privacy Policy | Site Map