Ì i 2
emr.queue
[emr.q.seqn]
*(YD)YHBXQ[yHQsn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
emr.q.seqn 20 PINT R yHQsn
emr.q.fcn 50 FREE L *(YD)YHBXQ[yHQsn]|0
Ì i 2
main
[urn]
$(YA)YAA[yaa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 10 URN L yaa
auth.calc.ibnr 10 MONEY R $(YA)YAA[yaa]I|0
auth.cd.screen 15 FREE L MIS.SCREEN VAL=@MC.MEM.PLAN.auth.ins.cd.screen
auth.current.ibnr 10 MONEY R VAL=(@auth.calc.ibnr-@claims.posted.amt-@claims.ibnr.a
VAL=mt!0)
auth.number 18 FREE L $(YA)YAA[yaa]|2
auth.type 10 FREE L MIS.REF.TYPE $(YA)YAA[yaa]|3
benefit 10 FREE L MIS.INS.BENE $(YA)YAA[yaa]|9
claims.ibnr.amt 10 MONEY R $(YA)YAA[yaa]I|1
claims.posted.amt 10 MONEY R $(YA)YAA[yaa]I|2
coding.method 10 FREE L MIS.CODE.METH $(YA)YAA[yaa]|8
date 8 DATE L $(YA)YAA[yaa]|4
diag.code 7 FREE L $(YA)YAA[yaa]D|0
diag.desc 60 FREE L $(YA)YAA[yaa]D|1
diag.grouper.version 10 PINT R $(YA)YAA[yaa]D|2
exp.date 8 DATE L $(YA)YAA[yaa]|5
hold.from.adj 1 YN L $(YA)YAA[yaa]|16
hold.from.adj.reason 20 FREE L $(YA)YAA[yaa]|17
hold.from.adj.time 10 PINT R $(YA)YAA[yaa]|19
hold.from.adj.user 10 FREE L UNV.USER $(YA)YAA[yaa]|18
ibnr.status 8 CHOICE L $(YA)YAA[yaa]I|3
id 18 URN L
id.rm 18 URN L
id.rm.member 25 FREE L
ins.auth.number 18 FREE L $(YA)YAA[yaa]|10
insurance 10 FREE L MC.MEM.PLAN $(YA)YAA[yaa]|1
last.sent.to.emr 10 STIME L $(YA)YAA[yaa]EMR|0
last.update 10 STIME L $(YA)YAA[yaa]A|6
map.to.status 10 CHOICE L $(YA)YAA[yaa]A|5
mem.alt.mpi 25 URN L MC.MEM $(YA)YAA[yaa]|11
member 25 URN L MC.MEM $(YA)YAA[yaa]|0
member.care.group 10 URN L MC.CARE.GRP $(YA)YAA[yaa]M|1
member.id 57 FREE L VAL=(@MC.MEM.member.number_" "_IF{@member.name;@MC.ME
VAL=M.name}:0S)
member.name 30 FREE L $(YA)YAA[yaa]M|2
member.pcp 10 FREE L MC.PROV.CON $(YA)YAA[yaa]M|0
mis.insurance 10 FREE L MIS.INS $(YA)YAA[yaa]|12
num.claims.exp 2 INT R $(YA)YAA[yaa]I|4
num.claims.rec 2 INT R $(YA)YAA[yaa]I|5
other.auth.number2 18 FREE L $(YA)YAA[yaa]|13
policy.number 20 FREE L $(YA)YAA[yaa]RM|1
requested.action 3 FREE L MC.ACTION $(YA)YAA[yaa]|15
requested.care.group 10 URN L MC.CARE.GRP $(YA)YAA[yaa]RM|0
requested.location 10 FREE L MIS.LOCN $(YA)YAA[yaa]P|2
requested.prov.free.text 30 FREE L $(YA)YAA[yaa]RM|2
requested.prov.name 30 FREE L VAL=IF{@requested.provider @MC.PROV.CON.name[@requeste
VAL=d.provider];@requested.prov.free.text}
requested.provider 10 FREE L MC.PROV.CON $(YA)YAA[yaa]P|1
requested.specialty 10 FREE L MIS.ABS.SVC $(YA)YAA[yaa]P|3
requesting.prov.free.text 30 FREE L $(YA)YAA[yaa]RM|3
requesting.prov.name 30 FREE L VAL=IF{@requesting.provider @MC.PROV.CON.name[@request
VAL=ing.provider];@requesting.prov.free.text}
requesting.provider 10 FREE L MC.PROV.CON $(YA)YAA[yaa]P|0
rev.to.pending 1 INT R $(YA)YAA[yaa]A|4
source 12 FREE L $(YA)YAA[yaa]A|3
status 10 FREE L MC.AUTH.STATUS $(YA)YAA[yaa]A|0
status.time 10 PINT R $(YA)YAA[yaa]A|1
status.user 10 FREE L MIS.USER $(YA)YAA[yaa]A|2
units.of.service 4 PINT R $(YA)YAA[yaa]|6
units.of.service.avail 4 PINT R VAL=(@units.of.service-@units.of.service.used)
units.of.service.used 4 PINT R $(YA)YAA[yaa]|14
units.of.svc.perf.temp 4 PINT R VAL=IF{"I"=@t.auth.type's.patient.type @t.units.of.ser
VAL=vice.used!0;-@Root(@t.svc.units.performed[@urn])["
VAL="]!0}
units.of.svc.performed 4 PINT R VAL=%MC.AUTH.val.M.units.of.svc.performed(@urn)
units.of.svc.remain.temp 4 INT R VAL=%MC.AUTH.val.M.units.of.svc.remain.temp(@urn)
units.of.svc.remaining 4 INT R VAL=%MC.AUTH.val.M.units.of.svc.remaining(@urn)
units.of.svc.sched.temp 4 PINT R VAL=IF{@p.MIS.REF.TYPE.patient.type[@t.auth.type]="I"
VAL="N/A";-@Root(@t.svc.units.scheduled[@urn])[""]!0}
units.of.svc.scheduled 4 PINT R VAL=IF{@p.MIS.REF.TYPE.patient.type[@auth.type]="I" "N
VAL=/A";-@Root(@svc.units.scheduled[@urn])[""]!0}
visit 10 URN L $(YA)YAA[yaa]M|3
visit.copay 9 MONEY R $(YA)YAA[yaa]|7
visit.number 18 FREE L $(YA)YAA[yaa]M|4
Ì € i 2
audit.trail
[urn, audit.date,audit.time,audit.queue]
$(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L yaaTD
audit.time 4 HHMM L yaaTT
audit.queue 2 PINT R yaaTQ
audit.desc 60 FREE L $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]|4
audit.new.value 20 FREE L $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]|2
audit.old.value 20 FREE L $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]|1
audit.type 10 FREE L MC.TXN.TYPE $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]|0
audit.user 10 FREE L MIS.USER $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]|3
Ì € i 2
audit.trail.serv
[urn,audit.date,audit.time,audit.queue, audit.service.queue]
$(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.service.queue 3 PINT R yaaS
audit.service 10 FREE L $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|0
audit.service.avail.claim 3 INT R VAL=(@audit.service.qty-@audit.service.used.claim)
audit.service.code.method 10 FREE L MIS.CODE.METH $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|7
audit.service.copay 8 PDEC2 R $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|3
audit.service.copay.d.p 1 CHOICE L $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|4
audit.service.desc 60 FREE L $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|1
audit.service.group 10 FREE L MIS.SVC.GRP $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|5
audit.service.qty 3 PINT R $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|2
audit.service.used.claim 3 INT R $(YA)YAA[yaa]T[yaaTD,yaaTT,yaaTQ]S[yaaS]|6
Ì € i 2
cd.screen.queries
[urn, auth.cd.query]
$(YA)YAA[yaa]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auth.cd.query 10 FREE L MIS.QUERY ggv
auth.cd.display 90 FREE L VAL=@MIS.QUERY.text_" "_@auth.cd.response
auth.cd.response 75 QRY.RESP L $(YA)YAA[yaa]CD[ggv]|0
auth.cd.yn.comment 70 QRY.RESP L $(YA)YAA[yaa]CD[ggv]|5
Ì € i 2
comments
[urn, comment.urn]
$(YA)YAA[yaa]Z[yaaZ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
comment.urn 3 PINT R yaaZ
comment.text 79 TEXT L $(YA)YAA[yaa]Z[yaaZ]
Ì € i 2
inpatient.days
[urn, inpatient.day]
$(YA)YAA[yaa]J[yaaJ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inpatient.day 8 DATE L yaaJ
inday.accomodation 10 FREE L MIS.ACCOM $(YA)YAA[yaa]J[yaaJ]|4
inday.adm.no 12 FREE L $(YA)YAA[yaa]J[yaaJ]|1
inday.bed 3 FREE L $(YA)YAA[yaa]J[yaaJ]|3
inday.disp.room.bed 13 FREE L VAL=@inday.room_"/"_@inday.bed
inday.room 10 FREE L MIS.ROOM $(YA)YAA[yaa]J[yaaJ]|2
inday.status 1 CHOICE L $(YA)YAA[yaa]J[yaaJ]|0
Ì € i 2
referral.notes
[urn, ref.note.urn]
$(YA)YAA[yaa]Y[yaaY]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ref.note.urn 3 PINT R yaaY
ref.note.text 79 TEXT L $(YA)YAA[yaa]Y[yaaY]
Ì € i 2
referral.notes2
[urn, ref.note.urn2]
$(YA)YAA[yaa]Y2[yaaY2]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ref.note.urn2 2 PINT R yaaY2
ref.note.text2 79 TEXT L $(YA)YAA[yaa]Y2[yaaY2]
Ì € i 2
service.ref.type.claims
[urn, ref.type.claim]
$(YA)YAA[yaa]RC[yca]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ref.type.claim 10 URN L MC.CLAIM yca
ref.claimed.qty 4 INT R $(YA)YAA[yaa]RC[yca]|0
Ì € i 2
service.ref.type.detail
[urn,ref.type.claim, ref.type.svc.method,ref.type.svc.code]
$(YA)YAA[yaa]RC[yca]D[gsf,gsg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ref.type.svc.method 10 FREE L MIS.CODE.METH gsf
ref.type.svc.code 10 FREE L MIS.SVC.CODE gsg
ref.type.svc.qty 4 INT R $(YA)YAA[yaa]RC[yca]D[gsf,gsg]|0
Ì € i 2
services
[urn, service.queue]
$(YA)YAA[yaa]S[yaaS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
service.queue 3 PINT R yaaS
service 10 FREE L $(YA)YAA[yaa]S[yaaS]|0
service.access.detail 1 YN L $(YA)YAA[yaa]S[yaaS]|9
service.avail.for.claim 3 INT R VAL=(@service.qty-@service.used.by.claim)
service.code.method 10 FREE L MIS.CODE.METH $(YA)YAA[yaa]S[yaaS]|7
service.copay 8 PDEC2 R $(YA)YAA[yaa]S[yaaS]|3
service.copay.as.dol.per 1 CHOICE L $(YA)YAA[yaa]S[yaaS]|4
service.desc 60 FREE L $(YA)YAA[yaa]S[yaaS]|1
service.desc.temp 47 FREE L $(YA)YAA[yaa]S[yaaS]|8
service.group 10 FREE L MIS.SVC.GRP $(YA)YAA[yaa]S[yaaS]|5
service.performed 3 PINT R VAL=-@Root(@services.performed[@urn,@service.queue])["
VAL="]!0
service.performed.temp 3 PINT R VAL=-@Root(@t.services.performed[@urn,@service.queue])
VAL=[""]!0
service.qty 3 PINT R $(YA)YAA[yaa]S[yaaS]|2
service.remaining 3 INT R VAL=@service.qty-(-@Root(@services.scheduled[@urn,@ser
VAL=vice.queue])[""])-(-@Root(@services.performed[@urn
VAL=,@service.queue])[""])
service.remaining.temp 3 INT R VAL=@t.service.qty-(-@Root(@t.services.scheduled[@urn,
VAL=@t.service.queue])[""])-(-@Root(@t.services.perfor
VAL=med[@urn,@t.service.queue])[""])
service.scheduled 3 PINT R VAL=IF{@p.MIS.REF.TYPE.patient.type[@t.auth.type]="I"
VAL="N/A";-@Root(@services.scheduled[@urn,@service.que
VAL=ue])[""]!0}
service.scheduled.temp 3 PINT R VAL=IF{@p.MIS.REF.TYPE.patient.type[@t.auth.type]="I"
VAL="N/A";-@Root(@t.services.scheduled[@urn,@service.q
VAL=ueue])[""]!0}
service.used.by.claim 3 INT R $(YA)YAA[yaa]S[yaaS]|6
Ì € i 2
service.claims
[urn,service.queue, service.claim]
$(YA)YAA[yaa]S[yaaS]C[yca]
Field Name Len Dat Typ J DPM Offset/Local/VAL
service.claim 10 URN L MC.CLAIM yca
service.claim.qty 3 PINT R $(YA)YAA[yaa]S[yaaS]C[yca]|0
Ì € i 2
services.performed
[urn,service.queue, svc.qty.perf.appt.seq]
$(YA)YAA[yaa]S[yaaS]SUP[yaaPA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
svc.qty.perf.appt.seq 2 PINT R yaaPA
svc.qty.perf.appt.1or2 1 PINT R $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|7
svc.qty.perf.appt.date 8 DATE L $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|1
svc.qty.perf.appt.info 30 FREE L $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|6
svc.qty.perf.appt.status 9 CHOICE L $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|3
svc.qty.perf.appt.time 4 HHMM5 L $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|2
svc.qty.perf.appt.type 10 FREE L SCH.APPT.TYPE $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|0
svc.qty.perf.appt.urn 10 FREE L SCH.APPT $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|5
svc.qty.perf.sch.db 12 FREE L MIS.APPL.DB $(YA)YAA[yaa]S[yaaS]SUP[yaaPA]|4
Ì € i 2
services.scheduled
[urn,service.queue, svc.qty.sch.appt.seq]
$(YA)YAA[yaa]S[yaaS]SUS[yaaSA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
svc.qty.sch.appt.seq 2 PINT R yaaSA
svc.qty.sch.appt.1or2 1 PINT R $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|7
svc.qty.sch.appt.date 8 DATE L $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|1
svc.qty.sch.appt.info 30 FREE L $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|6
svc.qty.sch.appt.status 9 CHOICE L $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|3
svc.qty.sch.appt.time 4 HHMM5 L $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|2
svc.qty.sch.appt.type 10 FREE L SCH.APPT.TYPE $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|0
svc.qty.sch.appt.urn 10 FREE L SCH.APPT $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|5
svc.qty.sch.db 12 FREE L MIS.APPL.DB $(YA)YAA[yaa]S[yaaS]SUS[yaaSA]|4
Ì € i 2
svc.units.performed
[urn, perf.appt.seq]
$(YA)YAA[yaa]SUP[yaapa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
perf.appt.seq 2 PINT R yaapa
perf.appt.1or2 1 FREE L $(YA)YAA[yaa]SUP[yaapa]|7
perf.appt.date 8 DATE L $(YA)YAA[yaa]SUP[yaapa]|1
perf.appt.info 30 FREE L $(YA)YAA[yaa]SUP[yaapa]|6
perf.appt.status 9 CHOICE L $(YA)YAA[yaa]SUP[yaapa]|3
perf.appt.time 4 HHMM5 L $(YA)YAA[yaa]SUP[yaapa]|2
perf.appt.type 10 FREE L SCH.APPT $(YA)YAA[yaa]SUP[yaapa]|0
perf.appt.urn 10 FREE L SCH.APPT $(YA)YAA[yaa]SUP[yaapa]|5
perf.sch.db 12 FREE L MIS.APPL.DB $(YA)YAA[yaa]SUP[yaapa]|4
Ì € i 2
svc.units.scheduled
[urn, sch.appt.seq]
$(YA)YAA[yaa]SUS[yaasa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sch.appt.seq 2 PINT R yaasa
sch.appt.1or2 1 PINT R $(YA)YAA[yaa]SUS[yaasa]|7
sch.appt.date 8 DATE L $(YA)YAA[yaa]SUS[yaasa]|1
sch.appt.info 30 FREE L $(YA)YAA[yaa]SUS[yaasa]|6
sch.appt.status 9 CHOICE L $(YA)YAA[yaa]SUS[yaasa]|3
sch.appt.time 4 HHMM5 L $(YA)YAA[yaa]SUS[yaasa]|2
sch.appt.type 10 FREE L SCH.APPT.TYPE $(YA)YAA[yaa]SUS[yaasa]|0
sch.appt.urn 10 FREE L SCH.APPT $(YA)YAA[yaa]SUS[yaasa]|5
sch.db 12 FREE L MIS.APPL.DB $(YA)YAA[yaa]SUS[yaasa]|4
Ì i 2
process.actions
[pm.actions]
/YAAP["RA",yaaAC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pm.actions 3 FREE L MC.ACTION yaaAC
Ì i 2
process.auths.more
[pa.seq,
/YAAP["A",yaapS]MO
Field Name Len Dat Typ J DPM Offset/Local/VAL
pa.reqd.prov.name 30 FREE L /YAAP["A",yaapS]MO|1
pa.reqg.prov.name 30 FREE L /YAAP["A",yaapS]MO|0
Index Files Subscripts/Physical Base
auth.number.x [auth.number,urn]
?(YA)YAAA[yaaa,yaa]
date.x [date,urn]
?(YA)YAAD[yaad,yaa]
exp.date.x [exp.date,urn]
?(YA)YAAE[yaae,yaa]
ibnr.status.x [ibnr.status,urn]
?(YA)YAAIS[yaaIS,yaa]
insurance.date.x [insurance,date,urn]
?(YA)YAAF[ymp,yaad,yaa]
member.date.x [member,date,urn]
?(YA)YAAB[yma,yaad,yaa]
member.x [member,urn]
?(YA)YAAJ[yma,yaa]
other.number.x [ins.auth.number,urn]
?(YA)YAAL[yaal,yaa]
pcp.date.x [member.pcp,date,urn]
?(YA)YAAPC[ggg,yaad,yaa]
req.mem.x [requested.provider,member,urn]
?(YA)YAAR[ggg,yma,yaa]
reqd.ft.prov.date.x [requested.prov.free.text,date,urn]
?(YA)YAAHFT[gggfpd,yaad,yaa]
reqg.ft.prov.date.x [requesting.prov.free.text,date,urn]
?(YA)YAAGFT[gggfpg,yaad,yaa]
requested.action.x [requested.action,urn]
?(YA)YAAM[yab,yaa]
requested.loc.date.x [requested.location,date,urn]
?(YA)YAAI[ggn,yaad,yaa]
requested.prov.date.x [requested.provider,date,urn]
?(YA)YAAH[ggg,yaad,yaa]
requested.spec.date.x [requested.specialty,date,urn]
?(YA)YAAK[gsd,yaad,yaa]
requesting.prov.date.x [requesting.provider,date,urn]
?(YA)YAAG[ggg,yaad,yaa]
rm.id.x [auth.number,urn]
?(YA)YAAID[yaaa,yaa]
rm.mis.insurance.date.x [mis.insurance,date,urn]
?(YA)YAAMID[ggm,yaad,yaa]
status.x [status,urn]
?(YA)YAAC[yaas,yaa]
urn.x [urn]
?(YA)YAU[yaa]
web.prov.ltr.mem.x [web.prov,web.prov.ltr,web.prov.member]
?(YA)YWPLM[ggg,ywplt,yma]
web.prov.mem.auth.x [web.prov,web.prov.member,urn]
?(YA)YWPMA[ggg,yma,yaa]
|
|
| | | | | | | | | | | | | | | | | |