Ì i 2
merge.history
[merge.seconds,merge.type]
*(HH)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 *(HH)HHPMXQ[hhpMX,hhpMT]|2
merge.from.mpi 25 URN L MRI.PAT *(HH)HHPMXQ[hhpMX,hhpMT]|3
merge.from.or.to 4 CHOICE L
merge.from.unit.num 10 FREE L *(HH)HHPMXQ[hhpMX,hhpMT]|5
merge.from.urn 25 URN L ARM.PAT *(HH)HHPMXQ[hhpMX,hhpMT]|0
merge.to.mpi 25 URN L MRI.PAT *(HH)HHPMXQ[hhpMX,hhpMT]|4
merge.to.unit.num 10 FREE L *(HH)HHPMXQ[hhpMX,hhpMT]|6
merge.to.urn 25 URN L ARM.PAT *(HH)HHPMXQ[hhpMX,hhpMT]|1
Ì € i 2
merge.errors
[merge.seconds,merge.type, merge.error.queue]
*(HH)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 *(HH)HHPMXQ[hhpMX,hhpMT]ERR[hhpME]|0
Ì € i 2
merge.log
[merge.seconds,merge.type, merge.log.queue]
*(HH)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 *(HH)HHPMXQ[hhpMX,hhpMT]LOG[hhpML]|0
Ì i 2
top
[urn]
$(HHP)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.DB
alt.mri.urn 25 URN L MRI.PAT
aud.birthdate 10 BDATE L $(HHP)HHP[hhp]A|4
aud.sex 1 CHOICE L $(HHP)HHP[hhp]A|5
city 20 FREE L $(HHP)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}
disp.birthdate 10 BDATE L VAL=@Temp.record(EA,@MRI.PAT.birthdate)
disp.city 20 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.city)
disp.current.age 7 FREE L VAL=%Z.age(@disp.birthdate)
disp.emp.status 10 FREE L MIS.EMP.STATUS VAL=@Temp.record(AA,@MRI.DRC.emp.status)
disp.employer 30 FREE L MIS.EMPLR VAL=@Temp.record(AA,@MRI.DRC.employer)
disp.home.phone 18 PHONE L VAL=@Temp.record(AA,@MRI.DRC.pat.home.phone)
disp.marital.status 10 FREE L MIS.MAR.STATUS VAL=@Temp.record(AA,@MRI.DRC.marital.status)
disp.other.maid.name 30 FREE L VAL=@Temp.record(EA,@MRI.PAT.maiden.other.name)
disp.sex 1 CHOICE L VAL=@Temp.record(EA,@MRI.PAT.sex)
disp.soc.sec.num 12 FREE L VAL=@Temp.record(HP,@soc.sec.num)
disp.state 2 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.state)
disp.street 30 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.street)
disp.street2 30 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.street2)
disp.work.phone 18 PHONE L VAL=@Temp.record(AA,@MRI.DRC.emp.phone)
disp.zip 10 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.zip)
emp.phone 18 PHONE L $(HHP)HHP[hhp]A["E"]|1
emp.status 10 FREE L MIS.EMP.STATUS $(HHP)HHP[hhp]A["E"]|2
employer 10 FREE L MIS.EMPLR $(HHP)HHP[hhp]A["E"]|0
home.phone 18 PHONE L $(HHP)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[hhp]A|6
last.arm.edit 8 DATE L $(HHP)HHP[hhp]A|7
last.arm.ins.edit 8 DATE L $(HHP)HHP[hhp]A|8
marital.status 10 FREE L MIS.MAR.STATUS $(HHP)HHP[hhp]A|11
merged.to 25 URN L ARM.PAT $(HHP)HHP[hhp]A|3
mpi 25 URN L MRI.PAT $(HHP)HHP[hhp]A|0
mri.birthdate 10 BDATE L VAL=@MRI.PAT.birthdate[@mpi]
mri.current.age 7 FREE L VAL=%Z.age(@MRI.PAT.birthdate[@mpi])
mri.other.maid.name 30 FREE L VAL=@MRI.PAT.maiden.other.name[@mpi]
mri.sex 1 CHOICE L VAL=@MRI.PAT.sex[@mpi]
mri.subscriber 30 URN L MRI.SUBSCRIBER $(HHP)HHP[hhp]A|9
mri.subscriber.db 12 FREE L MIS.APPL.DB $(HHP)HHP[hhp]A|10
name 30 NAME L $(HHP)HHP[hhp]A|1
new.patient 25 URN L
patient 25 URN L
patient.cd.screen 15 FREE L MIS.SCREEN VAL=@ARM.PARAM.pat.cd.screen
soc.sec.num 12 FREE L $(HHP)HHP[hhp]A|2
state 2 FREE L $(HHP)HHP[hhp]A["AD"]|3
street 30 FREE L $(HHP)HHP[hhp]A["AD"]|0
street2 30 FREE L $(HHP)HHP[hhp]A["AD"]|1
subscriber 30 URN L
urn.main 25 URN L
zip 10 ZIP.POST L $(HHP)HHP[hhp]A["AD"]|4
Ì € i 2
comments
[urn, comment.number]
$(HHP)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[hhp]C[hhpCN]|4
com.last.edit.time 4 HHMM L $(HHP)HHP[hhp]C[hhpCN]|5
com.last.edit.txn.queue 3 PINT R $(HHP)HHP[hhp]C[hhpCN]|6
com.txn.date 8 DATE L $(HHP)HHP[hhp]C[hhpCN]|0
com.txn.queue 3 PINT R $(HHP)HHP[hhp]C[hhpCN]|2
com.txn.time 4 HHMM L $(HHP)HHP[hhp]C[hhpCN]|1
comment.subject 35 FREE L $(HHP)HHP[hhp]C[hhpCN]|3
Ì € i 2
key.field.audit
[urn, kf.aud.edit.date,kf.aud.seq.n]
$(HHP)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 BDATE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|4
kf.ed.bdate.old 10 BDATE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|5
kf.ed.name.new 30 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|0
kf.ed.name.old 30 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|1
kf.ed.sex.new 1 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|6
kf.ed.sex.old 1 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|7
kf.ed.soc.sec.new 12 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|2
kf.ed.soc.sec.old 12 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]D|3
kf.edit.bdate 1 YN L $(HHP)HHP[hhp]AU[hhped,hhpsn]|4
kf.edit.name 1 YN L $(HHP)HHP[hhp]AU[hhped,hhpsn]|2
kf.edit.sex 1 YN L $(HHP)HHP[hhp]AU[hhped,hhpsn]|5
kf.edit.soc.sec 1 YN L $(HHP)HHP[hhp]AU[hhped,hhpsn]|3
kf.edit.source 50 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]|0
kf.edit.user 10 FREE L $(HHP)HHP[hhp]AU[hhped,hhpsn]|1
Ì € i 2
additional.mpi
[urn, other.mpi]
$(HHP)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
insurance
[urn, ins]
$(HHP)HHP[hhp]A["I",ggm]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins 10 FREE L MIS.INS ggm
ins.cds 15 FREE L MIS.SCREEN VAL=@ARM.PAT.insurance.cds
ins.cov.number 20 FREE L $(HHP)HHP[hhp]A["I",ggm]|10
ins.eff.date 8 DATE L $(HHP)HHP[hhp]A["I",ggm]|6
ins.emp.status 10 FREE L MIS.EMP.STATUS $(HHP)HHP[hhp]A["I",ggm]I2|1
ins.employer 10 FREE L MIS.EMPLR $(HHP)HHP[hhp]A["I",ggm]I2|0
ins.exp.date 8 DATE L $(HHP)HHP[hhp]A["I",ggm]|7
ins.group.name 30 FREE L $(HHP)HHP[hhp]A["I",ggm]|11
ins.group.number 15 FREE L $(HHP)HHP[hhp]A["I",ggm]|8
ins.mri.subs.urn 30 URN L MRI.SUBSCRIBER $(HHP)HHP[hhp]A["I",ggm]|5
ins.policy.number 30 FREE L $(HHP)HHP[hhp]A["I",ggm]|4
ins.status 9 CHOICE L $(HHP)HHP[hhp]A["I",ggm]|2
ins.status.date 8 DATE L $(HHP)HHP[hhp]A["I",ggm]|9
ins.status.last.verif 8 DATE L $(HHP)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],ins];@MRI.SUBSCRIBE
VAL=R.subs.insurance.cov.no[@ins.mri.subs.urn[@ins.sub
VAL=scriber.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.emp.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 10 FREE L MIS.EMPLR 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 NAME 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 $(HHP)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[hhp]A["I",ggm]|0
patient.id 25 FREE L
Ì € i 2
insurance.cds.queries
[urn,ins, ins.cds.query]
$(HHP)HHP[hhp]A["I",ggm]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins.cds.query 10 FREE L MIS.QUERY ggv
ins.cds.display 90 FREE L VAL=@MIS.QUERY.text_" "_@ins.cds.response
ins.cds.response 75 QRY.RESP L $(HHP)HHP[hhp]A["I",ggm]CD[ggv]|0
Ì € i 2
merged.from.mri
[urn, mri.mf.seq.n]
$(HHP)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[hhp]A["XM",hhmfs]|0
mri.mf.patient 25 URN L ARM.PAT $(HHP)HHP[hhp]A["XM",hhmfs]|1
Ì € i 2
merged.from.patients
[urn, merged.from.urn]
$(HHP)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[hhp]A["XP",hhpXP]|0
Ì € i 2
merged.transactions.det
[urn,merge.txn.type,merge.txn.urn.ptr,
$(HHP)HHP[hhp]A["MERGE",hhpX1,hhpX2]D
Field Name Len Dat Typ J DPM Offset/Local/VAL
merged.txn.detail 100 FREE L $(HHP)HHP[hhp]A["MERGE",hhpX1,hhpX2]D
Ì € i 2
pat.cd.screen.queries
[urn, pat.cd.query]
$(HHP)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[hhp]A["CD",ggv]|0
Ì € i 2
reminders
[urn, reminder.number]
$(HHP)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[hhp]R[hhpRN]|4
rem.entered.time 4 HHMM L $(HHP)HHP[hhp]R[hhpRN]|5
rem.entered.user 10 FREE L MIS.USER $(HHP)HHP[hhp]R[hhpRN]|6
rem.resolved.date 8 DATE L $(HHP)HHP[hhp]R[hhpRN]|7
rem.resolved.time 4 HHMM L $(HHP)HHP[hhp]R[hhpRN]|8
rem.resolved.user 10 FREE L MIS.USER $(HHP)HHP[hhp]R[hhpRN]|9
reminder.category 10 FREE L ARM.REM.CAT $(HHP)HHP[hhp]R[hhpRN]|10
reminder.date 8 DATE L $(HHP)HHP[hhp]R[hhpRN]|0
reminder.insurance 10 FREE L MIS.INS $(HHP)HHP[hhp]R[hhpRN]|2
reminder.status 10 CHOICE L $(HHP)HHP[hhp]R[hhpRN]|3
reminder.time 4 HHMM L $(HHP)HHP[hhp]R[hhpRN]|1
Ì € i 2
reminder.text
[urn,reminder.number, rem.text.urn]
$(HHP)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 TEXT L $(HHP)HHP[hhp]R[hhpRN]T[hhpTX]
Ì € i 2
transactions
[urn, txn.date,txn.time,txn.queue]
$(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.date 8 DATE L hhpTD
txn.time 4 HHMM L hhpTT
txn.queue 2 PINT R hhpTQ
txn.effective.date 8 DATE L $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|6
txn.ins 10 FREE L MIS.INS $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|4
txn.new.value 45 FREE L $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|2
txn.old.value 45 FREE L $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|1
txn.pointer 10 PINT R $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|5
txn.type 10 FREE L ARM.TXN.TYPE $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|0
txn.user 10 FREE L MIS.USER $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]|3
Ì € i 2
transaction.text
[urn,txn.date,txn.time,txn.queue, txn.text.urn]
$(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]T[hhpTX]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.text.urn 3 URN L hhpTX
txn.text 79 TEXT L $(HHP)HHP[hhp]T[hhpTD,hhpTT,hhpTQ]T[hhpTX]
Index Files Subscripts/Physical Base
alt.database.mpi.x [alt.mri.database,alt.mri.urn] = urn
?(HHP)HHPEA[gn,ea]
ins.exp.date.x [ins,ins.exp.date,ins.subscriber.urn,urn]
?(HHP)HHPIED[ggm,hhpXD,hhps,hhp]
ins.pol.num.x [ins.policy.number,ins,urn]
?(HHP)HHPIPN[hhpPN,ggm,hhp]
ins.subs.pol.num.x [ins.subs.pol.number,urn]
?(HHP)HHPSPN[hpSPN,hhp]
ins.x [ins,urn]
?(HHP)HHPI[ggm,hhp]
merge.history.x [merge.from.urn,merge.seconds,merge.type,merge.from.or.to] = merge.to.urn
?(HHP)HHPMHX[hhp,hhpMX,hhpMT,hhpMF]
merged.id.x [patient.id,urn]
?(HHP)HHPMID[hhpID,hhp]
merged.name.x [name,urn]
?(HHP)HHPMIDN[hhpN,hhp]
mri.sub.x [mri.subscriber,mri.subscriber.db] = urn
?(HHP)HHPMS[eaSB,gn]
mri.urn.x [mpi] = urn
?(HHP)HHPMU[ea]
name.x [name,urn]
?(HHP)HHPN[hhpN,hhp]
pat.audit.date.x [last.arm.edit,urn]
?(HHP)HHPAD[hhpED,hhp]
pat.audit.x [txn.date,txn.time,txn.queue,ins.edit.type,urn]
?(HHP)HHPAT[hhpTD,hhpTT,hhpTQ,hhpT,hhp]
pat.ins.audit.date.x [last.arm.ins.edit,urn]
?(HHP)HHPIAD[hhpEI,hhp]
reminder.category.x [reminder.category,reminder.date,urn,reminder.number]
?(HHP)HHPRC[hhrm,hhpRD,hhp,hhpRN]
reminder.open.x [reminder.date,reminder.time,urn,reminder.number]
?(HHP)HHPRO[hhpRD,hhpRT,hhp,hhpRN]
reminder.x [reminder.date,reminder.time,urn,reminder.number]
?(HHP)HHPR[hhpRD,hhpRT,hhp,hhpRN]
soc.sec.x [soc.sec.num,urn]
?(HHP)HHPSS[hhpSS,hhp]
subscriber.x [subscriber,urn]
?(HHP)HHPSX[hhpS,hhp]
urn.x [urn]
?(HHP)HHPU[hhp]
|
|
| | | | | | | | | | | | | | | |