Ì i 2
mri.subscriber.duplicates (duplicates)
:ESBU
Field Name Len Dat Typ J DPM Offset/Local/VAL
dup.birthdate.range 4 PINT R :ESBU|5
dup.compile.mode 4 CHOICE L :ESBU|11
dup.date 8 DATE L :ESBU|0
dup.end.date 8 DATE L :ESBU|15
dup.end.time 4 HHMM L :ESBU|16
dup.first.name.sel 18 CHOICE L :ESBU|8
dup.last.name.sel 18 CHOICE L :ESBU|7
dup.nrecs 5 PINT R :ESBU|17
dup.polno.sel 18 CHOICE L :ESBU|18
dup.possible.count 7 PINT R :ESBU|10
dup.process.count 7 PINT R :ESBU|4
dup.select.count 7 PINT R :ESBU|12
dup.select.end.date 8 DATE L :ESBU|13
dup.select.end.time 4 HHMM L :ESBU|14
dup.ssn.sel 18 CHOICE L :ESBU|9
dup.start.at.date 8 DATE L :ESBU|6
dup.status 9 FREE L :ESBU|3
dup.status.display 18 FREE L VAL=IF{@dup.status="SELECTING" @dup.status_" "_@dup.s
VAL=elect.count;@dup.status}
dup.time 4 HHMM L :ESBU|1
dup.user 10 FREE L :ESBU|2
Ì i 2
mri.pat.duplicate.index (duplicate.index)
[dup.last.name,dup.first.name,dup.soc.sec.number,dup.polno,dup.birthdate,dup.urn]
:ESBU["D",esbLN,esbFN,esbSS,esbPN,esbBD,eaSB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dup.last.name 25 FREE L esbLN
dup.first.name 25 FREE L esbFN
dup.soc.sec.number 12 FREE L esbSS
dup.polno 30 FREE L esbPN
dup.birthdate 8 BDATE L esbBD
dup.urn 30 URN L MRI.SUBSCRIBER eaSB
dup.before.sndx.name 25 FREE L :ESBU["D",esbLN,esbFN,esbSS,esbPN,esbBD,eaSB]
Ì 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 30 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 30 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 30 URN L eaSB
active 1 YN L ?ESB[eaSB]|0
id 30 URN L MRI.SUBSCRIBER
new.id 30 URN L
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.create.date 8 DATE L ?ESB[eaSB]C|0
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.sndx.first.name 25 FREE L
subs.sndx.last.name 25 FREE L
subs.soc.sec 15 FREE L ?ESB[eaSB]|13
subs.state 2 FREE L ?ESB[eaSB]|5
subs.switched.to 30 URN L MRI.SUBSCRIBER ?ESB[eaSB]|15
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
subs.master.policy.number 30 FREE L ?ESB[eaSB]I[ggm]|7
Ì € 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.subscriber.switched.from (switched.from)
[urn, subs.switched.number]
?ESB[eaSB]SF[swf]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subs.switched.number 2 PINT R swf
subs.prefix 2 FREE L
subs.switched.date 8 DATE L ?ESB[eaSB]SF[swf]|1
subs.switched.time 4 HHMM L ?ESB[eaSB]SF[swf]|3
subs.switched.urn 35 URN L ?ESB[eaSB]SF[swf]|0
subs.switched.user 10 FREE L MIS.USER ?ESB[eaSB]SF[swf]|2
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mri.subs.create.date.x [subs.create.date,urn]
create.date.x ?ESBCX[esbCD,eaSB]
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]
mri.subs.soundexed.name.index [subs.sndx.last.name,subs.sndx.first.name,subs.gender,subs.birthdate,urn]
soundex.name.x ?ESBSNX[snx1,snx2,esbG,esbBD,eaSB]
mri.subs.switched.date.x [subs.prefix,subs.switched.date,urn,subs.switched.number]
switched.date.x ?ESBSWX[esbPX,esbSW,eaSB,swf]
|
|
| | | | | | | |