Ì i 2
arm.pat.merge.history (merge.history)
[merge.seconds,merge.type]
:HHPMXQ[hhpMX,hhpMT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merge.seconds 10 FREE L hhpMX
merge.type 7 FREE L hhpMT
merge.adm.xfer.seq 50 FREE L :HHPMXQ[hhpMX,hhpMT]|2
merge.from.mpi 25 URN L MRI.PAT :HHPMXQ[hhpMX,hhpMT]|3
merge.from.or.to 5 CHOICE L
merge.from.unit.num 10 FREE L :HHPMXQ[hhpMX,hhpMT]|5
merge.from.urn 25 URN L ARM.PAT :HHPMXQ[hhpMX,hhpMT]|0
merge.to.mpi 25 URN L MRI.PAT :HHPMXQ[hhpMX,hhpMT]|4
merge.to.unit.num 10 FREE L :HHPMXQ[hhpMX,hhpMT]|6
merge.to.urn 25 URN L ARM.PAT :HHPMXQ[hhpMX,hhpMT]|1
Ì € i 2
arm.pat.merge.errors (merge.errors)
[merge.seconds,merge.type, merge.error.queue]
:HHPMXQ[hhpMX,hhpMT]ERR[hhpME]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merge.error.queue 5 INT R hhpME
merge.error.text 79 FREE L :HHPMXQ[hhpMX,hhpMT]ERR[hhpME]|0
Ì € i 2
arm.pat.merge.log (merge.log)
[merge.seconds,merge.type, merge.log.queue]
:HHPMXQ[hhpMX,hhpMT]LOG[hhpML]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merge.log.queue 5 INT R hhpML
merge.log.text 79 FREE L :HHPMXQ[hhpMX,hhpMT]LOG[hhpML]|0
Ì i 2
arm.pat.top (top)
[urn]
:HHP[hhp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 25 URN L hhp
alt.mri.database 12 FREE L MIS.APPL
alt.mri.urn 25 URN L MRI.PAT
aud.birthdate 10 BDATE L :HHP[hhp]A|4
aud.sex 1 CHOICE L :HHP[hhp]A|5
birthdate 10 BDATE L VAL=@MRI.PAT.birthdate[@mpi]
city 20 FREE L :HHP[hhp]A["AD"]|2
city.state.zip 32 FREE L VAL=IF{L(@city^ZMC)+L(IF{@zip^XX ", "_XX}_IF{@state^XX
VAL= " "_XX}^ZMSZ)>32 ZMC$(32-L(ZMSZ))_ZMSZ;ZMC_ZMS
VAL=Z}
current.age 7 FREE L VAL=%Z.age(@MRI.PAT.birthdate[@mpi])
drc.city 20 FREE L VAL=@MRI.DRC.pat.city[@mpi]
drc.city.state.zip 32 FREE L VAL=IF{L(@MRI.DRC.pat.city[@mpi]^ZMC)+L(IF{@MRI.DRC.pa
VAL=t.zip[@mpi]^XX ", "_XX}_IF{@MRI.DRC.pat.state[@mpi
VAL=]^XX " "_XX}^ZMSZ)>32 ZMC$(32-L(ZMSZ))_ZMSZ;ZMC
VAL=_ZMSZ}
drc.emp.status 10 FREE L MIS.EMP.STATUS VAL=@MRI.DRC.emp.status[@mpi]
drc.employer 30 FREE L MIS.EMPLR.DICT VAL=@MRI.DRC.employer[@mpi]
drc.home.phone 18 PHONE L VAL=@MRI.DRC.pat.home.phone[@mpi]
drc.marital.status 10 FREE L MIS.MAR.STATUS VAL=@MRI.DRC.marital.status[@mpi]
drc.state 2 FREE L VAL=@MRI.DRC.pat.state[@mpi]
drc.street 30 FREE L VAL=@MRI.DRC.pat.street[@mpi]
drc.street2 30 FREE L VAL=@MRI.DRC.pat.street2[@mpi]
drc.work.phone 18 PHONE L VAL=@MRI.DRC.emp.phone[@mpi]
drc.zip 10 ZIP.POST L MIS.ZIP VAL=@MRI.DRC.pat.zip[@mpi]
emp.phone 18 PHONE L :HHP[hhp]A["E"]|7
emp.status 10 FREE L MIS.EMP.STATUS :HHP[hhp]A["E"]|8
employer 10 FREE L MIS.EMPLR.DICT :HHP[hhp]A["E"]|0
home.phone 18 FREE L :HHP[hhp]A["AD"]|5
id 57 URN L VAL=(@ins.policy.number_" "_@name:0S)
id.name 30 URN L VAL=@name
last.arm.demo.edit 8 DATE L :HHP[hhp]A|6
last.arm.edit 8 DATE L :HHP[hhp]A|7
last.arm.ins.edit 8 DATE L :HHP[hhp]A|8
marital.status 10 FREE L MIS.MAR.STATUS :HHP[hhp]A|11
merged.to 25 URN L ARM.PAT :HHP[hhp]A|3
mpi 25 URN L MRI.PAT :HHP[hhp]A|0
mri.other.maid.name 30 FREE L VAL=@MRI.PAT.maiden.other.name[@mpi]
mri.subscriber 30 URN L MRI.SUBSCRIBER :HHP[hhp]A|9
mri.subscriber.db 12 FREE L MIS.APPL :HHP[hhp]A|10
mri.urn 25 URN L MRI.PAT
name 30 NAME L :HHP[hhp]A|1
new.patient 30 URN L
patient 30 URN L
patient.cd.screen 15 FREE L MIS.SCREEN VAL=@ARM.PARAM.pat.cd.screen
sex 1 CHOICE L VAL=@MRI.PAT.sex[@mpi]
soc.sec.num 12 FREE L :HHP[hhp]A|2
state 2 FREE L :HHP[hhp]A["AD"]|3
street 30 FREE L :HHP[hhp]A["AD"]|0
street2 30 FREE L :HHP[hhp]A["AD"]|1
subscriber 30 URN L
zip 10 FREE L :HHP[hhp]A["AD"]|4
Ì € i 2
arm.pat.comments (comments)
[urn, comment.number]
:HHP[hhp]C[hhpCN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
comment.number 3 PINT R hhpCN
com.last.edit.date 8 DATE L :HHP[hhp]C[hhpCN]|4
com.last.edit.time 4 HHMM L :HHP[hhp]C[hhpCN]|5
com.last.edit.txn.queue 3 PINT R :HHP[hhp]C[hhpCN]|6
com.txn.date 8 DATE L :HHP[hhp]C[hhpCN]|0
com.txn.queue 3 PINT R :HHP[hhp]C[hhpCN]|2
com.txn.time 4 HHMM L :HHP[hhp]C[hhpCN]|1
comment.subject 35 FREE L :HHP[hhp]C[hhpCN]|3
Ì € i 2
arm.pat.key.field.audit (key.field.audit)
[urn, kf.aud.edit.date,kf.aud.seq.n]
:HHP[hhp]AU[hhped,hhpsn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
kf.aud.edit.date 8 DATE L hhped
kf.aud.seq.n 4 PINT R hhpsn
kf.ed.bdate.new 10 FREE L :HHP[hhp]AU[hhped,hhpsn]D|4
kf.ed.bdate.old 10 FREE L :HHP[hhp]AU[hhped,hhpsn]D|5
kf.ed.name.new 30 FREE L :HHP[hhp]AU[hhped,hhpsn]D|0
kf.ed.name.old 30 FREE L :HHP[hhp]AU[hhped,hhpsn]D|1
kf.ed.sex.new 1 FREE L :HHP[hhp]AU[hhped,hhpsn]D|6
kf.ed.sex.old 1 FREE L :HHP[hhp]AU[hhped,hhpsn]D|7
kf.ed.soc.sec.new 12 FREE L :HHP[hhp]AU[hhped,hhpsn]D|2
kf.ed.soc.sec.old 12 FREE L :HHP[hhp]AU[hhped,hhpsn]D|3
kf.edit.bdate 1 YN L :HHP[hhp]AU[hhped,hhpsn]|4
kf.edit.name 1 YN L :HHP[hhp]AU[hhped,hhpsn]|2
kf.edit.sex 1 YN L :HHP[hhp]AU[hhped,hhpsn]|5
kf.edit.soc.sec 1 YN L :HHP[hhp]AU[hhped,hhpsn]|3
kf.edit.source 50 FREE L :HHP[hhp]AU[hhped,hhpsn]|0
kf.edit.user 10 FREE L :HHP[hhp]AU[hhped,hhpsn]|1
Ì € i 2
arm.pat.additional.mpi (additional.mpi)
[urn, other.mpi]
:HHP[hhp]A["MRI",ea]
Field Name Len Dat Typ J DPM Offset/Local/VAL
other.mpi 25 URN L MRI.PAT ea
Ì € i 2
arm.pat.insurance (insurance)
[urn, ins]
:HHP[hhp]A["I",ggm]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins 10 FREE L MIS.INS.DICT ggm
ins.cd.screen 15 FREE L MIS.SCREEN VAL=@ARM.PAT.insurance.cd.screen
ins.cov.number 20 FREE L :HHP[hhp]A["I",ggm]|12
ins.eff.date 8 DATE L :HHP[hhp]A["I",ggm]|8
ins.emp.status 10 FREE L MIS.EMP.STATUS :HHP[hhp]A["I",ggm]I2|1
ins.employer 10 FREE L MIS.EMPLR.DICT :HHP[hhp]A["I",ggm]I2|0
ins.exp.date 8 DATE L :HHP[hhp]A["I",ggm]|9
ins.group.name 30 FREE L :HHP[hhp]A["I",ggm]|13
ins.group.number 15 FREE L :HHP[hhp]A["I",ggm]|10
ins.mri.subs.urn 30 URN L MRI.SUBSCRIBER :HHP[hhp]A["I",ggm]|7
ins.policy.number 30 FREE L :HHP[hhp]A["I",ggm]|6
ins.practice 10 FREE L MIS.DOC.GRP :HHP[hhp]A["I",ggm]|5
ins.status 9 CHOICE L :HHP[hhp]A["I",ggm]|2
ins.status.date 8 DATE L :HHP[hhp]A["I",ggm]|11
ins.status.last.verif 8 DATE L :HHP[hhp]A["I",ggm]|3
ins.subs.cov.number 20 FREE L VAL=IF{@mpi[@ins.subscriber.urn] @MRI.DRC.insurance.co
VAL=v.no[@mpi[@ins.subscriber.urn]];@MRI.SUBSCRIBER.su
VAL=bs.insurance.cov.no[@ins.mri.subs.urn[@ins.subscri
VAL=ber.urn,ins],ins]}
ins.subs.eff.date 8 DATE L VAL=@ins.eff.date[@ins.subscriber.urn,ins]
ins.subs.emp.status 10 FREE L MIS.EMP.STATUS VAL=IF{@mpi[@ins.subscriber.urn] @MRI.DRC.eid.status[@
VAL=mpi[@ins.subscriber.urn]];@MRI.SUBSCRIBER.subs.emp
VAL=.status[@ins.mri.subs.urn[@ins.subscriber.urn,ins]
VAL=,ins]}
ins.subs.employer 30 FREE L MIS.EMPLR.DICT VAL=IF{@mpi[@ins.subscriber.urn] @MRI.DRC.employer[@mp
VAL=i[@ins.subscriber.urn]];@MRI.SUBSCRIBER.subs.emp.n
VAL=ame[@ins.mri.subs.urn[@ins.subscriber.urn,ins],ins
VAL=]}
ins.subs.exp.date 8 DATE L VAL=@ins.exp.date[@ins.subscriber.urn,ins]
ins.subs.group.name 30 FREE L VAL=@ins.group.name[@ins.subscriber.urn,ins]
ins.subs.group.number 15 FREE L VAL=@ins.group.number[@ins.subscriber.urn,ins]
ins.subs.name 30 FREE L VAL=@name[@ins.subscriber.urn]
ins.subs.pol.number 30 FREE L VAL=@ins.policy.number[@ins.subscriber.urn,ins]
ins.subs.relation 10 FREE L MIS.RELAT.DICT :HHP[hhp]A["I",ggm]|1
ins.subs.st.last.verif 8 DATE L VAL=@ins.status.last.verif[@ins.subscriber.urn,ins]
ins.subs.status 9 CHOICE L VAL=@ins.status[@ins.subscriber.urn,ins]
ins.subs.status.date 8 DATE L VAL=@ins.status.date[@ins.subscriber.urn,ins]
ins.subscriber.urn 25 URN L ARM.PAT :HHP[hhp]A["I",ggm]|0
patient.id 25 FREE L
Ì € i 2
arm.ins.cd.screen.queries (ins.cd.screen.queries)
[urn,ins, ins.cd.query]
:HHP[hhp]A["I",ggm]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins.cd.query 10 FREE L MIS.QUERY ggv
ins.cd.display 90 FREE L VAL=@MIS.QUERY.text_" "_@ins.cd.response
ins.cd.response 75 QRY.RESP L :HHP[hhp]A["I",ggm]CD[ggv]|0
ins.cd.yn.comment 75 QRY.RESP L :HHP[hhp]A["I",ggm]CD[ggv]|1
Ì € i 2
arm.pat.merged.from.mri (merged.from.mri)
[urn, mri.mf.seq.n]
:HHP[hhp]A["XM",hhmfs]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mri.mf.seq.n 2 PINT R hhmfs
mri.mf.mpi 20 FREE L :HHP[hhp]A["XM",hhmfs]|0
mri.mf.patient 25 URN L ARM.PAT :HHP[hhp]A["XM",hhmfs]|1
Ì € i 2
arm.pat.merged.from.patients (merged.from.patients)
[urn, merged.from.urn]
:HHP[hhp]A["XP",hhpXP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merged.from.urn 25 URN L ARM.PAT hhpXP
merged.time 10 INT R :HHP[hhp]A["XP",hhpXP]|0
Ì € i 2
arm.pat.cd.screen.queries (pat.cd.screen.queries)
[urn, pat.cd.query]
:HHP[hhp]A["CD",ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pat.cd.query 10 FREE L MIS.QUERY ggv
pat.cd.display 90 FREE L VAL=@MIS.QUERY.text_" "_@pat.cd.response
pat.cd.response 75 QRY.RESP L :HHP[hhp]A["CD",ggv]|0
pat.cd.yn.comment 70 QRY.RESP L :HHP[hhp]A["CD",ggv]|1
Ì € i 2
arm.pat.reminders (reminders)
[urn, reminder.number]
:HHP[hhp]R[hhpRN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
reminder.number 3 PINT R hhpRN
rem.entered.date 8 DATE L :HHP[hhp]R[hhpRN]|4
rem.entered.time 4 HHMM L :HHP[hhp]R[hhpRN]|5
rem.entered.user 10 FREE L MIS.USER :HHP[hhp]R[hhpRN]|6
rem.resolved.date 8 DATE L :HHP[hhp]R[hhpRN]|7
rem.resolved.time 4 HHMM L :HHP[hhp]R[hhpRN]|8
rem.resolved.user 10 FREE L MIS.USER :HHP[hhp]R[hhpRN]|9
reminder.category 10 FREE L ARM.REM.CAT :HHP[hhp]R[hhpRN]|10
reminder.date 8 DATE L :HHP[hhp]R[hhpRN]|0
reminder.insurance 10 FREE L MIS.INS.DICT :HHP[hhp]R[hhpRN]|2
reminder.status 10 CHOICE L :HHP[hhp]R[hhpRN]|3
reminder.time 4 HHMM L :HHP[hhp]R[hhpRN]|1
Ì € i 2
arm.pat.reminder.text (reminder.text)
[urn,reminder.number, rem.text.urn]
:HHP[hhp]R[hhpRN]T[hhpTX]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rem.text.urn 3 URN L hhpTX
rem.text 79 FREE L :HHP[hhp]R[hhpRN]T[hhpTX]
Ì € i 2
arm.pat.transactions (transactions)
[urn, txn.date,txn.time,txn.queue]
:HHP[hhp]T[hhpTD,hhpTM,hhpTQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.date 8 DATE L hhpTD
txn.time 4 HHMM L hhpTM
txn.queue 2 PINT R hhpTQ
txn.effective.date 8 DATE L :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|6
txn.ins 10 FREE L MIS.INS.DICT :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|4
txn.new.value 45 FREE L :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|2
txn.normal.reversing 2 FREE L :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|7
txn.old.value 45 FREE L :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|1
txn.pointer 10 PINT R :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|5
txn.type 10 FREE L ARM.TXN.TYPE :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|0
txn.user 10 FREE L MIS.USER :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]|3
Ì € i 2
arm.pat.trans.eff.dt.vector (transaction.eff.dt.vector)
[urn,txn.date,txn.time,txn.queue, txn.ins.eff.date]
:HHP[hhp]T[hhpTD,hhpTM,hhpTQ]EDT[hhpEQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.ins.eff.date 8 DATE L hhpEQ
txn.ins.benefit 10 FREE L MIS.INS.BENE :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]EDT[hhpEQ]|3
txn.ins.prac 10 FREE L MIS.DOC.GRP :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]EDT[hhpEQ]|1
txn.ins.status 10 CHOICE L :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]EDT[hhpEQ]|2
Ì € i 2
arm.pat.transaction.text (transaction.text)
[urn,txn.date,txn.time,txn.queue, txn.text.urn]
:HHP[hhp]T[hhpTD,hhpTM,hhpTQ]T[hhpTX]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.text.urn 3 URN L hhpTX
txn.text 79 FREE L :HHP[hhp]T[hhpTD,hhpTM,hhpTQ]T[hhpTX]
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
arm.pat.alt.database.mpi.index [alt.mri.database,alt.mri.urn] = urn
alt.database.mpi.x :HHPEA[iaD,ea]
arm.pat.ins.exp.date.index [ins,ins.exp.date,ins.subscriber.urn,urn]
ins.exp.date.x :HHPIEDX[ggm,hhpXD,hhps,hhp]
arm.pat.ins.pcp.index [ARM.AUTH.patient.pcp,ins,urn]
ins.pcp.x :HHPIPX[ggg,ggm,hhp]
arm.pat.ins.pol.num.index [ins.policy.number,ins,urn]
ins.pol.num.x :HHPIPNX[hhpPN,ggm,hhp]
arm.pat.ins.subs.pol.num.index [ins.subs.pol.number,urn]
ins.subs.pol.num.x :HHPSPNX[hpSPN,hhp]
arm.pat.insurance.index [ins,urn]
ins.x :HHPIX[ggm,hhp]
arm.pat.merge.history.x [merge.from.urn,merge.seconds,merge.type,merge.from.or.to] = merge.to.urn
merge.history.x :HHPMHX[hhp,hhpMX,hhpMT,hhpMF]
arm.pat.merged.id.index [patient.id,urn]
merged.id.x :HHPMID[hhpID,hhp]
arm.pat.merged.name.index [name,urn]
merged.name.x :HHPIDN[hhpN,hhp]
arm.pat.mri.subscriber.index [mri.subscriber,mri.subscriber.db] = urn
mri.sub.x :HHPMSX[eaSB,iaD]
arm.pat.mri.urn.index [mpi] = urn
mri.urn.x :HHPMUX[ea]
arm.pat.name.x [name,urn]
name.x :HHPNX[hhpN,hhp]
arm.pat.audit.date.index [last.arm.edit,urn]
pat.audit.date.x :HHPADX[hhpED,hhp]
arm.pat.audit.x [txn.date,txn.time,txn.queue,ins.edit.type,urn]
pat.audit.x :HHPAX[hhpTD,hhpTM,hhpTQ,hhpT,hhp]
arm.pat.ins.audit.date.index [last.arm.ins.edit,urn]
pat.ins.audit.date.x :HHPIADX[hhpEI,hhp]
arm.pat.pcp.name.index [ARM.AUTH.patient.pcp,name,urn]
pcp.name.x :HHPPNX[ggg,hhpN,hhp]
arm.pat.pcp.index [ARM.AUTH.patient.pcp,urn]
pcp.x :HHPPX[ggg,hhp]
arm.pat.reminder.category.indx [reminder.category,reminder.date,urn,reminder.number]
reminder.category.x :HHPRC[hhrm,hhpRD,hhp,hhpRN]
arm.pat.reminder.open.index [reminder.date,reminder.time,urn,reminder.number]
reminder.open.x :HHPRO[hhpRD,hhpRT,hhp,hhpRN]
arm.pat.reminder.index [reminder.date,reminder.time,urn,reminder.number]
reminder.x :HHPR[hhpRD,hhpRT,hhp,hhpRN]
arm.pat.soc.sec.index [soc.sec.num,urn]
soc.sec.x :HHPSSX[hhpSS,hhp]
arm.pat.subscriber.index [subscriber,urn]
subscriber.x :HHPSX[hhpS,hhp]
arm.pat.urn.index [urn]
urn.x :HHPUX[hhp]
|
|
| | | | | | | | | | | | | | | |