Ì € i 2
mri.erx.audit.trail.events (audit.trail.events)
[audit.urn, audit.seconds]
?ERX.AU[ea]EV[auSEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.seconds 10 PINT R auSEC
au.device 10 FREE L ?ERX.AU[ea]EV[auSEC]|0
au.user 10 FREE L MIS.USER ?ERX.AU[ea]EV[auSEC]|1
Ì € i 2
mri.erx.audit.trail.events.ins (audit.trail.events.ins)
[audit.urn,audit.seconds, au.ins.seq.no]
?ERX.AU[ea]EV[auSEC]I[auI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
au.ins.seq.no 2 PINT R auI
Ì € i 2
mri.erx.audit.trail.trace.elig (audit.trail.trace.elig)
[audit.urn, elig.trace]
?ERX.AU[ea]T["L",erxTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
elig.trace 30 FREE L erxTN
elig.trace.device 10 FREE L ?ERX.AU[ea]T["L",erxTN]|4
elig.trace.ear.enc.num 12 FREE L ?ERX.AU[ea]T["L",erxTN]|9
elig.trace.edi.pgm 15 FREE L MIS.EDI.PGM ?ERX.AU[ea]T["L",erxTN]|10
elig.trace.rcv.time 10 PINT R ?ERX.AU[ea]T["L",erxTN]|1
elig.trace.req.time 10 PINT R ?ERX.AU[ea]T["L",erxTN]|0
elig.trace.status 10 FREE L ?ERX.AU[ea]T["L",erxTN]|2
elig.trace.user 10 FREE L MIS.USER ?ERX.AU[ea]T["L",erxTN]|3
elig.trace.visit 30 URN L ADM.PAT ?ERX.AU[ea]T["L",erxTN]|5
elig.trace.visit.locn 10 FREE L MIS.LOCN.DICT ?ERX.AU[ea]T["L",erxTN]|7
elig.trace.visit.prov 10 FREE L MIS.DOC.DICT ?ERX.AU[ea]T["L",erxTN]|8
elig.trace.visit.status 8 FREE L ?ERX.AU[ea]T["L",erxTN]|6
Ì € i 2
mri.erx.audit.trail.trace.medh (audit.trail.trace.medh)
[audit.urn, medh.trace]
?ERX.AU[ea]T["M",auTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
medh.trace 30 FREE L auTN
medh.trace.begin.date 8 DATE L ?ERX.AU[ea]T["M",auTN]|10
medh.trace.device 10 FREE L ?ERX.AU[ea]T["M",auTN]|4
medh.trace.edi.pgm 15 FREE L MIS.EDI.PGM ?ERX.AU[ea]T["M",auTN]|12
medh.trace.elig.ptr 30 FREE L ?ERX.AU[ea]T["M",auTN]|5
medh.trace.end.date 8 DATE L ?ERX.AU[ea]T["M",auTN]|11
medh.trace.ins.seq.no 2 PINT R ?ERX.AU[ea]T["M",auTN]|6
medh.trace.member.id 15 FREE L ?ERX.AU[ea]T["M",auTN]|8
medh.trace.payer.id 15 FREE L ?ERX.AU[ea]T["M",auTN]|7
medh.trace.provider 10 FREE L MIS.DOC.DICT ?ERX.AU[ea]T["M",auTN]|9
medh.trace.rcv.time 10 PINT R ?ERX.AU[ea]T["M",auTN]|1
medh.trace.req.time 10 PINT R ?ERX.AU[ea]T["M",auTN]|0
medh.trace.status 10 FREE L ?ERX.AU[ea]T["M",auTN]|2
medh.trace.user 10 FREE L MIS.USER ?ERX.AU[ea]T["M",auTN]|3
Ì € i 2
mri.erx.audit.trail.visits (audit.trail.visits)
[audit.urn, vis.urn]
?ERX.AU[ea]VS[aa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vis.urn 30 URN L ADM.PAT aa
vis.elig.last.checked 8 DATE L ?ERX.AU[ea]VS[aa]|1
vis.elig.last.trace 20 FREE L ?ERX.AU[ea]VS[aa]|0
vis.event.ins.audit.secs 10 PINT R ?ERX.AU[ea]VS[aa]|2
Ì € i 2
audit.trail.visit.ins.updates (audit.trail.visits.ins.tm)
[audit.urn,vis.urn, vis.ins.audit.secs]
?ERX.AU[ea]VS[aa]IS[auSEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vis.ins.audit.secs 10 PINT R auSEC
Ì € i 2
mri.erx.audit.trail.visits.ppr (audit.trail.visits.ppr)
[audit.urn,vis.urn, vis.ppr.enc.seq]
?ERX.AU[ea]VS[aa]PPR[vsPPR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vis.ppr.enc.seq 4 PINT R vsPPR
vis.ppr.elig.last.checked 8 DATE L ?ERX.AU[ea]VS[aa]PPR[vsPPR]|1
vis.ppr.elig.last.trace 20 FREE L ?ERX.AU[ea]VS[aa]PPR[vsPPR]|0
Ì € i 2
mri.erx.audit.trail.visits.rcr (audit.trail.visits.rcr)
[audit.urn,vis.urn, vis.rcr.date.time]
?ERX.AU[ea]VS[aa]RCR[vsRCR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vis.rcr.date.time 13 FREE L vsRCR
vis.rcr.elig.last.checked 8 DATE L ?ERX.AU[ea]VS[aa]RCR[vsRCR]|1
vis.rcr.elig.last.trace 20 FREE L ?ERX.AU[ea]VS[aa]RCR[vsRCR]|0
Ì i 2
mri.erx.main (main)
[urn]
?ERX[ea]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 25 URN L MRI.PAT ea
ins.elig.ear.enc.num 12 FREE L ?ERX[ea]XL|14
ins.elig.ear.enc.urn 5 FREE L ?ERX[ea]XL|13
ins.elig.edi.pgm 15 FREE L MIS.EDI.PGM ?ERX[ea]XL|15
ins.elig.last.user 10 FREE L MIS.USER ?ERX[ea]XL|3
ins.elig.msg 50 FREE L ?ERX[ea]XL["MSG"]
ins.elig.process 10 FREE L VAL="ELIG"
ins.elig.status 8 CHOICE L ?ERX[ea]XL|0
ins.elig.status.date 8 DATE L ?ERX[ea]XL|1
ins.elig.status.time 4 HHMM L ?ERX[ea]XL|2
ins.elig.trace.num 30 FREE L ?ERX[ea]XL|4
ins.elig.vis.ppr.enc.seq 10 PINT R ?ERX[ea]XL|11
ins.elig.vis.rcr.date.tm 13 FREE L ?ERX[ea]XL|12
ins.elig.visit 30 URN L ADM.PAT ?ERX[ea]XL|5
ins.elig.visit.date 8 DATE L ?ERX[ea]XL|9
ins.elig.visit.location 10 FREE L MIS.LOCN.DICT ?ERX[ea]XL|8
ins.elig.visit.number 12 FREE L ?ERX[ea]XL|6
ins.elig.visit.provider 10 FREE L MIS.DOC.DICT ?ERX[ea]XL|10
ins.elig.visit.status 8 FREE L ?ERX[ea]XL|7
last.activity.date 8 DATE L ?ERX[ea]|0
last.ins.update 10 PINT R ?ERX[ea]|1
last.ins.update.date 8 DATE L VAL=%Z.date.in.magic(@last.ins.update)
last.ins.update.time 4 HHMM L VAL=%Z.time.out(@last.ins.update)
last.medh.update 10 PINT R ?ERX[ea]|2
last.medh.update.date 8 DATE L VAL=%Z.date.in.magic(@last.medh.update)
last.medh.update.time 4 HHMM L VAL=%Z.time.out(@last.medh.update)
merged.time 10 PINT R ?ERX[ea]|3
patient 30 FREE L
suspend.elig 1 YN L ?ERX[ea]|4
suspend.elig.disp.dtm 14 FREE L VAL=%Z.date.out(%Z.date.in.magic(@suspend.elig.time))_
VAL=" "_%Z.time.out(@suspend.elig.time)
suspend.elig.time 10 PINT R ?ERX[ea]|6
suspend.elig.user 10 FREE L MIS.USER ?ERX[ea]|5
unsuspend.elig.time 10 PINT R ?ERX[ea]|8
unsuspend.elig.user 10 FREE L MIS.USER ?ERX[ea]|7
Ì € i 2
mri.erx.insurance.payers (insurance.payers)
[urn, payer.id]
?ERX[ea]IP[erxPI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
payer.id 15 FREE L erxPI
payer.ins 3 PINT R ?ERX[ea]IP[erxPI]|0
Ì € i 2
mri.erx.insurances (insurances)
[urn, ins.seq.no]
?ERX[ea]I[erxI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins.seq.no 1 PINT R erxI
ins.bin.no 20 FREE L ?ERX[ea]I[erxI]|4
ins.medh.begin.date 8 DATE L ?ERX[ea]I[erxI]XM|10
ins.medh.elig.trace.num 30 FREE L ?ERX[ea]I[erxI]XM|5
ins.medh.end.date 8 DATE L ?ERX[ea]I[erxI]XM|11
ins.medh.last.user 10 FREE L MIS.USER ?ERX[ea]I[erxI]XM|3
ins.medh.msg 50 FREE L ?ERX[ea]I[erxI]XM["MSG"]
ins.medh.process 10 FREE L VAL="MED HIST"
ins.medh.provider 10 FREE L MIS.DOC.DICT ?ERX[ea]I[erxI]XM|9
ins.medh.status 8 CHOICE L ?ERX[ea]I[erxI]XM|0
ins.medh.status.date 8 DATE L ?ERX[ea]I[erxI]XM|1
ins.medh.status.time 4 HHMM L ?ERX[ea]I[erxI]XM|2
ins.medh.trace.num 30 FREE L ?ERX[ea]I[erxI]XM|4
ins.medh.visit.date 8 DATE L ?ERX[ea]I[erxI]XM|8
ins.medh.visit.location 10 FREE L MIS.LOCN.DICT ?ERX[ea]I[erxI]XM|6
ins.medh.visit.number 12 FREE L ?ERX[ea]I[erxI]XM|7
ins.payer.id 15 FREE L ?ERX[ea]I[erxI]|0
ins.payer.name 30 FREE L ?ERX[ea]I[erxI]|1
ins.plan.id 15 FREE L ?ERX[ea]I[erxI]|2
ins.plan.name 30 FREE L ?ERX[ea]I[erxI]|3
insured.alternatives.id 15 FREE L ?ERX[ea]I[erxI]P|7
insured.cardholder.id 15 FREE L ?ERX[ea]I[erxI]P|12
insured.cardholder.name 30 FREE L ?ERX[ea]I[erxI]P|13
insured.copay.id 15 FREE L ?ERX[ea]I[erxI]P|9
insured.coverage.id 15 FREE L ?ERX[ea]I[erxI]P|8
insured.formulary.id 15 FREE L ?ERX[ea]I[erxI]P|6
insured.group.name 30 FREE L ?ERX[ea]I[erxI]P|5
insured.group.number 15 FREE L ?ERX[ea]I[erxI]P|4
insured.mail.order.cov 1 YN L ?ERX[ea]I[erxI]P|11
insured.member.id 20 FREE L ?ERX[ea]I[erxI]P|0
insured.member.name 30 FREE L ?ERX[ea]I[erxI]P|2
insured.member.suf 3 FREE L ?ERX[ea]I[erxI]P|1
insured.relat.desc 30 FREE L VAL=%MRI.ERX.disp.fields(@t.urn,"REL",{@insured.relati
VAL=onship})
insured.relationship 10 FREE L ?ERX[ea]I[erxI]P|3
insured.retail.pha.cov 1 YN L ?ERX[ea]I[erxI]P|10
insured.subscriber 30 URN L MRI.SUBSCRIBER ?ERX[ea]I[erxI]P|14
subs.addr1 30 FREE L ?ERX[ea]I[erxI]S|2
subs.addr2 30 FREE L ?ERX[ea]I[erxI]S|3
subs.alternatives.id 15 FREE L ?ERX[ea]I[erxI]S["SC"]|6
subs.birthdate 10 BDATE L ?ERX[ea]I[erxI]S|8
subs.city 20 FREE L ?ERX[ea]I[erxI]S|4
subs.copay.id 15 FREE L ?ERX[ea]I[erxI]S["SC"]|8
subs.country 20 FREE L ?ERX[ea]I[erxI]S|7
subs.coverage.id 15 FREE L ?ERX[ea]I[erxI]S["SC"]|7
subs.formulary.id 15 FREE L ?ERX[ea]I[erxI]S["SC"]|5
subs.gender 1 FREE L ?ERX[ea]I[erxI]S|9
subs.group.name 30 FREE L ?ERX[ea]I[erxI]S["SC"]|4
subs.group.number 15 FREE L ?ERX[ea]I[erxI]S["SC"]|3
subs.ins.bin.no 15 FREE L ?ERX[ea]I[erxI]S["SC"]|2
subs.ins.plan.id 15 FREE L ?ERX[ea]I[erxI]S["SC"]|0
subs.ins.plan.name 30 FREE L ?ERX[ea]I[erxI]S["SC"]|1
subs.mar.status 10 FREE L MIS.MAR.STATUS ?ERX[ea]I[erxI]S|10
subs.member.id 15 FREE L ?ERX[ea]I[erxI]S|0
subs.name 30 FREE L ?ERX[ea]I[erxI]S|1
subs.phone 20 PHONE L ?ERX[ea]I[erxI]S|12
subs.soc.sec 15 FREE L ?ERX[ea]I[erxI]S|11
subs.state 2 FREE L ?ERX[ea]I[erxI]S|5
subs.zip 10 ZIP.POST L ?ERX[ea]I[erxI]S|6
Ì € i 2
mri.erx.payer.med.hist (payer.med.hist)
[urn, payer.mh.id]
?ERX[ea]M[erxPI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
payer.mh.id 15 FREE L erxPI
payer.mh.name 30 FREE L ?ERX[ea]M[erxPI]|2
payer.mh.upd.time 10 PINT R ?ERX[ea]M[erxPI]|0
payer.mh.upd.user 10 FREE L MIS.USER ?ERX[ea]M[erxPI]|1
pmh.begin.date 8 DATE L ?ERX[ea]M[erxPI]A|4
pmh.cardholder.id 20 FREE L ?ERX[ea]M[erxPI]A|0
pmh.cardholder.name 30 FREE L ?ERX[ea]M[erxPI]A|1
pmh.end.date 8 DATE L ?ERX[ea]M[erxPI]A|5
pmh.group.name 30 FREE L ?ERX[ea]M[erxPI]A|3
pmh.group.number 20 FREE L ?ERX[ea]M[erxPI]A|2
pmh.member.id 20 FREE L ?ERX[ea]M[erxPI]A|7
pmh.pt.address 30 FREE L ?ERX[ea]M[erxPI]B|5
pmh.pt.birthdate 10 BDATE L ?ERX[ea]M[erxPI]B|1
pmh.pt.city 20 FREE L ?ERX[ea]M[erxPI]B|6
pmh.pt.consent 1 YN L ?ERX[ea]M[erxPI]A|6
pmh.pt.name 30 FREE L ?ERX[ea]M[erxPI]B|2
pmh.pt.phone 18 FREE L ?ERX[ea]M[erxPI]B|9
pmh.pt.relat.code 3 FREE L ?ERX[ea]M[erxPI]B|0
pmh.pt.sex 1 FREE L ?ERX[ea]M[erxPI]B|3
pmh.pt.soc.sec.num 9 PINT R ?ERX[ea]M[erxPI]B|4
pmh.pt.state 2 FREE L ?ERX[ea]M[erxPI]B|7
pmh.pt.zip 10 ZIP.POST L ?ERX[ea]M[erxPI]B|8
Ì € i 2
mri.erx.payer.med.hist.rxs (payer.med.hist.rxs)
[urn,payer.mh.id, pmh.drug.seq.no]
?ERX[ea]M[erxPI]H[erxMH]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pmh.drug.seq.no 3 PINT R erxMH
pmh.drug.date.end 8 DATE L ?ERX[ea]M[erxPI]H[erxMH]|15
pmh.drug.date.expire 8 DATE L ?ERX[ea]M[erxPI]H[erxMH]|13
pmh.drug.date.filled 8 DATE L ?ERX[ea]M[erxPI]H[erxMH]|11
pmh.drug.date.start 8 DATE L ?ERX[ea]M[erxPI]H[erxMH]|14
pmh.drug.date.written 8 DATE L ?ERX[ea]M[erxPI]H[erxMH]|12
pmh.drug.days 3 PINT R ?ERX[ea]M[erxPI]H[erxMH]|16
pmh.drug.desc 35 FREE L ?ERX[ea]M[erxPI]H[erxMH]|1
pmh.drug.desc.long 60 FREE L ?ERX[ea]M[erxPI]H[erxMH]|18
pmh.drug.form 3 FREE L ?ERX[ea]M[erxPI]H[erxMH]|2
pmh.drug.fsv.id 3 FREE L ?ERX[ea]M[erxPI]H[erxMH]|5
pmh.drug.fsv.number 25 FREE L ?ERX[ea]M[erxPI]H[erxMH]|6
pmh.drug.ndc 11 FREE L ?ERX[ea]M[erxPI]H[erxMH]|0
pmh.drug.qty 4 PINT R VAL=IF{@pmh.drug.qty.received;@pmh.drug.qty.orig}
pmh.drug.qty.orig 4 PINT R ?ERX[ea]M[erxPI]H[erxMH]|7
pmh.drug.qty.received 4 PINT R ?ERX[ea]M[erxPI]H[erxMH]|9
pmh.drug.qty.remain 4 PINT R ?ERX[ea]M[erxPI]H[erxMH]|8
pmh.drug.rxm 20 FREE L RXM.DRUG ?ERX[ea]M[erxPI]H[erxMH]|19
pmh.drug.sig 10 FREE L ?ERX[ea]M[erxPI]H[erxMH]|10
pmh.drug.strength 20 FREE L ?ERX[ea]M[erxPI]H[erxMH]|3
pmh.drug.substitution 1 FREE L ?ERX[ea]M[erxPI]H[erxMH]|17
pmh.drug.unit 3 FREE L ?ERX[ea]M[erxPI]H[erxMH]|4
pmh.pha.address 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|4
pmh.pha.city 20 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|5
pmh.pha.fax 18 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|9
pmh.pha.location 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|1
pmh.pha.name 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|3
pmh.pha.name.phone 51 FREE L VAL=@pmh.pha.name_" "_@pmh.pha.phone
pmh.pha.ncpdp 15 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|0
pmh.pha.pharmacist.name 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|2
pmh.pha.phone 18 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|8
pmh.pha.state 2 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|6
pmh.pha.zip 11 FREE L ?ERX[ea]M[erxPI]H[erxMH]P|7
pmh.prov.address 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|3
pmh.prov.city 20 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|4
pmh.prov.dea.number 20 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|0
pmh.prov.fax 18 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|8
pmh.prov.location 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|1
pmh.prov.name 30 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|2
pmh.prov.name.phone 51 FREE L VAL=@pmh.prov.name_" "_@pmh.prov.phone
pmh.prov.phone 18 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|7
pmh.prov.state 2 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|5
pmh.prov.zip 11 FREE L ?ERX[ea]M[erxPI]H[erxMH]D|6
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mri.erx.trace.x [trace.number] = urn
trace.x ?ERXT[erxTN]
mri.erx.worklist.loc.x [location,ins.v.status,MIS.ERX.process,urn]
worklist.loc.x ?ERXWKL[ggn,erxIS,gerT,ea]
|
|
| | | | | | | | | | | |