Ì i 2
mri.subscriber.edit.log (edit.log)
[edit.date,edit.urn,edit.seq.no]
?ESBE[esbE,eaSB,esbS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
edit.date 8 DATE L esbE
edit.urn 35 URN L MRI.SUBSCRIBER eaSB
edit.seq.no 3 PINT R esbS
edit.item 20 FREE L MRI.AUDIT ?ESBE[esbE,eaSB,esbS]|0
edit.new.val 30 FREE L ?ESBE[esbE,eaSB,esbS]|3
edit.old.val 30 FREE L ?ESBE[esbE,eaSB,esbS]|2
edit.time 4 HHMM L ?ESBE[esbE,eaSB,esbS]|1
edit.user 10 FREE L MIS.USER ?ESBE[esbE,eaSB,esbS]|4
Ì i 2
mri.subscriber.edits.by.subs (edit.log.by.subs)
[edit.subs.urn,edit.subs.date,edit.subs.seq.no]
?ESBES[eaSB,esbD,esbSS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
edit.subs.urn 35 URN L MRI.SUBSCRIBER eaSB
edit.subs.date 8 DATE L esbD
edit.subs.seq.no 3 PINT R esbSS
edit.subs.item 20 FREE L MRI.AUDIT ?ESBES[eaSB,esbD,esbSS]|0
edit.subs.new.val 30 FREE L ?ESBES[eaSB,esbD,esbSS]|3
edit.subs.old.val 30 FREE L ?ESBES[eaSB,esbD,esbSS]|2
edit.subs.time 4 HHMM L ?ESBES[eaSB,esbD,esbSS]|1
edit.subs.user 10 FREE L MIS.USER ?ESBES[eaSB,esbD,esbSS]|4
Ì i 2
mri.subs (main)
[urn]
?ESB[eaSB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 35 URN L eaSB
active 1 YN L ?ESB[eaSB]|0
id 35 URN L MRI.SUBSCRIBER
subs.addr.line.1 30 FREE L ?ESB[eaSB]|2
subs.addr.line.2 30 FREE L ?ESB[eaSB]|3
subs.birthdate 8 BDATE L ?ESB[eaSB]|8
subs.citizenship 1 YN L ?ESB[eaSB]|12
subs.city 20 FREE L ?ESB[eaSB]|4
subs.country 20 FREE L ?ESB[eaSB]|7
subs.first.name 30 FREE L
subs.gender 1 CHOICE L ?ESB[eaSB]|9
subs.last.name 30 FREE L
subs.marital.status 10 FREE L MIS.MAR.STATUS ?ESB[eaSB]|10
subs.name 30 NAME L ?ESB[eaSB]|1
subs.phone 30 PHONE L ?ESB[eaSB]|14
subs.race 10 FREE L MIS.RACE.DICT ?ESB[eaSB]|11
subs.soc.sec 15 FREE L ?ESB[eaSB]|13
subs.state 2 FREE L ?ESB[eaSB]|5
subs.zip.code 10 ZIP.POST L ?ESB[eaSB]|6
Ì € i 2
mri.subs.ins (insurance)
[urn, subs.insurance]
?ESB[eaSB]I[ggm]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.insurance 10 FREE L MIS.INS.DICT ggm
subs.benefit.plan 8 FREE L ?ESB[eaSB]I[ggm]|3
subs.emp.location 30 FREE L ?ESB[eaSB]I[ggm]|6
subs.emp.name 10 FREE L MIS.EMPLR.DICT ?ESB[eaSB]I[ggm]|5
subs.emp.status 10 FREE L MIS.EMP.STATUS ?ESB[eaSB]I[ggm]|4
subs.group.name 30 FREE L ?ESB[eaSB]I[ggm]|1
subs.group.number 15 FREE L ?ESB[eaSB]I[ggm]|0
subs.insurance.cov.no 8 FREE L ?ESB[eaSB]I[ggm]|2
Ì € i 2
mri.subs.ins.policy.no (policy.number)
[urn,subs.insurance, subs.policy.number]
?ESB[eaSB]I[ggm]PN[spnSB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.policy.number 30 FREE L spnSB
subs.policy.visit.urn 30 FREE L ?ESB[eaSB]I[ggm]PN[spnSB]|0
Ì € i 2
mri.subs.email (subs.email.addresses)
[urn, subs.email.seq.no]
?ESB[eaSB]E[esbEM]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.email.seq.no 2 PINT R esbEM
subs.email.addr 40 FREE L ?ESB[eaSB]E[esbEM]|0
Ì i 2
mri.subs (main)
[urn]
?ESB[eaSB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 35 URN L eaSB
active 1 YN L ?ESB[eaSB]|0
id 35 URN L MRI.SUBSCRIBER
subs.addr.line.1 30 FREE L ?ESB[eaSB]|2
subs.addr.line.2 30 FREE L ?ESB[eaSB]|3
subs.birthdate 8 BDATE L ?ESB[eaSB]|8
subs.citizenship 1 YN L ?ESB[eaSB]|12
subs.city 20 FREE L ?ESB[eaSB]|4
subs.country 20 FREE L ?ESB[eaSB]|7
subs.first.name 30 FREE L
subs.gender 1 CHOICE L ?ESB[eaSB]|9
subs.last.name 30 FREE L
subs.marital.status 10 FREE L MIS.MAR.STATUS ?ESB[eaSB]|10
subs.name 30 NAME L ?ESB[eaSB]|1
subs.phone 30 PHONE L ?ESB[eaSB]|14
subs.race 10 FREE L MIS.RACE.DICT ?ESB[eaSB]|11
subs.soc.sec 15 FREE L ?ESB[eaSB]|13
subs.state 2 FREE L ?ESB[eaSB]|5
subs.zip.code 10 ZIP.POST L ?ESB[eaSB]|6
Ì € i 2
mri.subs.ins (insurance)
[urn, subs.insurance]
?ESB[eaSB]I[ggm]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.insurance 10 FREE L MIS.INS.DICT ggm
subs.benefit.plan 8 FREE L ?ESB[eaSB]I[ggm]|3
subs.emp.location 30 FREE L ?ESB[eaSB]I[ggm]|6
subs.emp.name 10 FREE L MIS.EMPLR.DICT ?ESB[eaSB]I[ggm]|5
subs.emp.status 10 FREE L MIS.EMP.STATUS ?ESB[eaSB]I[ggm]|4
subs.group.name 30 FREE L ?ESB[eaSB]I[ggm]|1
subs.group.number 15 FREE L ?ESB[eaSB]I[ggm]|0
subs.insurance.cov.no 8 FREE L ?ESB[eaSB]I[ggm]|2
Ì € i 2
mri.subs.ins.policy.no (policy.number)
[urn,subs.insurance, subs.policy.number]
?ESB[eaSB]I[ggm]PN[spnSB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.policy.number 30 FREE L spnSB
subs.policy.visit.urn 30 FREE L ?ESB[eaSB]I[ggm]PN[spnSB]|0
Ì € i 2
mri.subs.email (subs.email.addresses)
[urn, subs.email.seq.no]
?ESB[eaSB]E[esbEM]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.email.seq.no 2 PINT R esbEM
subs.email.addr 40 FREE L ?ESB[eaSB]E[esbEM]|0
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mri.ins.policy.x [subs.insurance,subs.policy.number,urn] = subs.policy.visit.urn
ins.policy.x ?ESBPIX[ggm,spnSB,eaSB]
mri.subs.name.x [subs.last.name,subs.first.name,urn]
name.x ?ESBNX[esbLN,sebFN,eaSB]
mri.subs.policy.x [subs.policy.number,urn,subs.insurance] = subs.policy.visit.urn
policy.x ?ESBPX[spnSB,eaSB,ggm]
mri.subs.soc.sec.x [subs.soc.sec,urn]
soc.x ?ESBSSX[esbSS,eaSB]
|
|
| | | | | | | | |