Ì i 2
ml.by.name
[ml.by.name.date]
*(HP3)HPYMN[pyD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ml.by.name.date 8 DATE L pyD
ml.by.name.comp.date 8 DATE L *(HP3)HPYMN[pyD]|0
ml.by.name.comp.time 4 TIME L *(HP3)HPYMN[pyD]|1
ml.by.name.final 1 YN L *(HP3)HPYMN[pyD]|2
Ì i 2
ml.by.number
[ml.by.number.date]
*(HP3)HPYMR[pyD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ml.by.number.date 8 DATE L pyD
ml.by.number.comp.date 8 DATE L *(HP3)HPYMR[pyD]|0
ml.by.number.comp.time 4 TIME L *(HP3)HPYMR[pyD]|1
ml.by.number.final 1 YN L *(HP3)HPYMR[pyD]|2
Ì i 2
ml.by.procedure
[ml.by.procedure.date]
*(HP3)HPYMP[pyD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ml.by.procedure.date 8 DATE L pyD
ml.by.procedure.comp.date 8 DATE L *(HP3)HPYMP[pyD]|0
ml.by.procedure.comp.time 4 TIME L *(HP3)HPYMP[pyD]|1
ml.by.procedure.final 1 YN L *(HP3)HPYMP[pyD]|2
Ì i 2
posting.queue
[queue.time]
*(HP3)HPYQ[pyq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
queue.time 8 FREE L pyq
queue.value 14 FREE L *(HP3)HPYQ[pyq]
Ì i 2
top
[urn]
*(HP3)HPY[py]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 10 URN L py
bchnum 3 PINT R *(HP3)HPY[py]M|2
comment 30 FREE L *(HP3)HPY[py]M|9
control.amount 12 SMONEY R *(HP3)HPY[py]M|11
control.hash.total 12 INT R *(HP3)HPY[py]M|24
control.quantity 5 SDEC R *(HP3)HPY[py]M|12
control.txn.count 5 INT R *(HP3)HPY[py]M|13
copy.add.desc 1 CHOICE L *(HP3)HPY[py]M|18
date 8 DATE L *(HP3)HPY[py]M|0
default.doctor 8 FREE L PBR.DOCTOR *(HP3)HPY[py]M|5
default.ins 10 FREE L PBR.INS *(HP3)HPY[py]M|22
default.location 8 FREE L PBR.LOCATION *(HP3)HPY[py]M|6
default.ohcp 8 FREE L PBR.DOCTOR *(HP3)HPY[py]M|23
default.proc.five 10 FREE L PBR.PROC *(HP3)HPY[py]M|21
default.proc.four 10 FREE L PBR.PROC *(HP3)HPY[py]M|20
default.proc.one 10 FREE L PBR.PROC *(HP3)HPY[py]M|7
default.proc.three 10 FREE L PBR.PROC *(HP3)HPY[py]M|19
default.proc.two 10 FREE L PBR.PROC *(HP3)HPY[py]M|8
default.service.date 8 DATE L *(HP3)HPY[py]M|4
guar.txn.sort 1 CHOICE L *(HP3)HPY[py]M["A"]|1
hash.total 12 INT R *(HP3)HPY[py]M["ST"]|29
journal 10 FREE L PBR.JOURNAL *(HP3)HPY[py]M|1
last.device.to.use 15 FREE L *(HP3)HPY[py]M|15
last.txn.posted 5 PINT R *(HP3)HPY[py]M|25
last.user.to.use 10 FREE L MIS.USER *(HP3)HPY[py]M|14
new.batch.date 8 DATE L *(HP3)HPY[py]M["B"]|0
new.batch.num 3 PINT R *(HP3)HPY[py]M["B"]|1
nor.adj.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|6
nor.adj.count 5 PINT R *(HP3)HPY[py]M["ST"]|5
nor.bdx.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|12
nor.bdx.count 5 PINT R *(HP3)HPY[py]M["ST"]|11
nor.bill.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|10
nor.bill.count 5 PINT R *(HP3)HPY[py]M["ST"]|9
nor.chg.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|2
nor.chg.count 5 PINT R *(HP3)HPY[py]M["ST"]|1
nor.rcp.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|4
nor.rcp.count 5 PINT R *(HP3)HPY[py]M["ST"]|3
nor.ref.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|8
nor.ref.count 5 PINT R *(HP3)HPY[py]M["ST"]|7
nor.total.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|14
nor.total.count 5 PINT R *(HP3)HPY[py]M["ST"]|13
post.status.msg 40 FREE L *(HP3)HPY[py]M["A"]|0
re.opened 12 PINT R *(HP3)HPY[py]M|16
rev.adj.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|20
rev.adj.count 5 PINT R *(HP3)HPY[py]M["ST"]|19
rev.bdx.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|26
rev.bdx.count 5 PINT R *(HP3)HPY[py]M["ST"]|25
rev.bill.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|24
rev.bill.count 5 PINT R *(HP3)HPY[py]M["ST"]|23
rev.chg.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|16
rev.chg.count 5 PINT R *(HP3)HPY[py]M["ST"]|15
rev.rcp.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|18
rev.rcp.count 5 PINT R *(HP3)HPY[py]M["ST"]|17
rev.ref.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|22
rev.ref.count 5 PINT R *(HP3)HPY[py]M["ST"]|21
rev.total.amount 11 MONEY R *(HP3)HPY[py]M["ST"]|28
rev.total.count 5 PINT R *(HP3)HPY[py]M["ST"]|27
select 1 PINT R *(HP3)HPY[py]M|17
status 7 CHOICE L *(HP3)HPY[py]M|3
tot.adj.amount 11 SMONEY R VAL=@nor.adj.amount+@rev.adj.amount:2D
tot.adj.count 5 SINT R VAL=@nor.adj.count+@rev.adj.count
tot.amount 11 SMONEY R VAL=@nor.total.amount+@rev.total.amount:2D
tot.bdx.amount 11 SMONEY R VAL=@nor.bdx.amount+@rev.bdx.amount:2D
tot.bdx.count 5 SINT R VAL=@nor.bdx.count+@rev.bdx.count
tot.bill.amount 11 SMONEY R VAL=@nor.bill.amount+@rev.bill.amount:2D
tot.bill.count 5 SINT R VAL=@nor.bill.count+@rev.bill.count
tot.chg.amount 11 SMONEY R VAL=@nor.chg.amount+@rev.chg.amount:2D
tot.chg.count 5 SINT R VAL=@nor.chg.count+@rev.chg.count
tot.count 5 SINT R VAL=@nor.total.count+@rev.total.count
tot.rcp.amount 11 SMONEY R VAL=@nor.rcp.amount+@rev.rcp.amount:2D
tot.rcp.count 5 SINT R VAL=@nor.rcp.count+@rev.rcp.count
tot.ref.amount 11 SMONEY R VAL=@nor.ref.amount+@rev.ref.amount:2D
tot.ref.count 5 SINT R VAL=@nor.ref.count+@rev.ref.count
txn.count 5 PINT R *(HP3)HPY[py]M["ST"]|0
type 7 CHOICE L *(HP3)HPY[py]M|10
Ì € i 2
transactions
[urn, txn.number]
*(HP3)HPY[py]T[pyT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.number 4 PINT R pyT
dft.doctor 8 FREE L PBR.DOCTOR *(HP3)HPY[py]T[pyT]|1
dft.eps.seq 5 URN L *(HP3)HPY[py]T[pyT]|8
dft.location 8 FREE L PBR.LOCATION *(HP3)HPY[py]T[pyT]|2
dft.ref.in.phy 10 FREE L MIS.DOC *(HP3)HPY[py]T[pyT]|4
dft.ref.out.phy 10 FREE L MIS.DOC *(HP3)HPY[py]T[pyT]|9
dft.serv.date 8 DATE L *(HP3)HPY[py]T[pyT]|3
dft.therapist 8 FREE L PBR.DOCTOR *(HP3)HPY[py]T[pyT]|7
txn.account 44 URN L PBR.ACT *(HP3)HPY[py]T[pyT]|0
txn.chg.ticket 8 PINT R *(HP3)HPY[py]T[pyT]|12
txn.claim 3 URN L *(HP3)HPY[py]T[pyT]|11
txn.col.agency 10 FREE L PBR.COL.AG *(HP3)HPY[py]T[pyT]|15
txn.del.flag 1 INT R *(HP3)HPY[py]T[pyT]|14
txn.guar 44 URN L PBR.GUAR *(HP3)HPY[py]T[pyT]|13
txn.posted 1 YN L VAL=IF{@status="POSTED" "Y";"N"}
txn.split.mthd 10 CHOICE L *(HP3)HPY[py]T[pyT]|6
txn.stmt 3 URN L *(HP3)HPY[py]T[pyT]|17
txn.tip.insurance 10 FREE L PBR.INS *(HP3)HPY[py]T[pyT]|10
txn.user 10 FREE L MIS.USER *(HP3)HPY[py]T[pyT]|5
txn.zero.dollar 1 YN L *(HP3)HPY[py]T[pyT]|16
Ì € i 2
dft.diag
[urn,txn.number, dft.diagnosis.seq]
*(HP3)HPY[py]T[pyT]DX[pyDSQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dft.diagnosis.seq 2 URN L pyDSQ
dft.diagnosis 6 FREE L PBR.DIAGNOSIS *(HP3)HPY[py]T[pyT]DX[pyDSQ]|0
dft.diagnosis.side.ind 1 CHOICE L *(HP3)HPY[py]T[pyT]DX[pyDSQ]|1
Ì € i 2
transaction.denial.rsns
[urn,txn.number, denial.urn]
*(HP3)HPY[py]T[pyT]J[pyDI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
denial.urn 3 URN L pyDI
denial.dis.urn 4 URN L *(HP3)HPY[py]T[pyT]J[pyDI]|0
denial.reason 10 FREE L PBR.DEN.RSN *(HP3)HPY[py]T[pyT]J[pyDI]|1
Ì € i 2
transaction.items
[urn,txn.number, item.urn]
*(HP3)HPY[py]T[pyT]I[pyTI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.urn 3 URN L pyTI
..not.used.24 1 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]|24
item.add.desc 40 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]TX|0
item.agency 10 FREE L PBR.COL.AG *(HP3)HPY[py]T[pyT]I[pyTI]|15
item.amount 12 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]|5
item.auth.ins 10 FREE L PBR.INS *(HP3)HPY[py]T[pyT]I[pyTI]0|7
item.auth.num 20 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]0|8
item.category 10 FREE L PBR.CHG.CAT *(HP3)HPY[py]T[pyT]I[pyTI]|7
item.chg.adj.amount 8 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]A|4
item.chg.adj.proc 10 FREE L PBR.PROC *(HP3)HPY[py]T[pyT]I[pyTI]A|3
item.chg.adj.type 3 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]A|5
item.chg.adj2.amount 8 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]A|8
item.chg.adj2.proc 10 FREE L PBR.PROC *(HP3)HPY[py]T[pyT]I[pyTI]A|7
item.chg.adj2.type 3 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]A|9
item.chg.rcp.add.desc 40 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]A|6
item.chg.rcp.amount 8 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]A|1
item.chg.rcp.comment 40 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]A|10
item.chg.rcp.proc 10 FREE L PBR.PROC *(HP3)HPY[py]T[pyT]I[pyTI]A|0
item.chg.rcp.type 3 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]A|2
item.conv.age.offset 1 INT R *(HP3)HPY[py]T[pyT]I[pyTI]|33
item.conv.batch 15 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]|31
item.conv.held 5 INT R *(HP3)HPY[py]T[pyT]I[pyTI]|32
item.conv.seq 5 INT R *(HP3)HPY[py]T[pyT]I[pyTI]|30
item.diag.restrict 11 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]|18
item.doctor 8 FREE L PBR.DOCTOR *(HP3)HPY[py]T[pyT]I[pyTI]|1
item.edit 1 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]|20
item.eps.seq 5 URN L *(HP3)HPY[py]T[pyT]I[pyTI]|19
item.exploded.proc 10 FREE L PBR.PROC *(HP3)HPY[py]T[pyT]I[pyTI]|23
item.fqhc 1 YN L *(HP3)HPY[py]T[pyT]I[pyTI]0|3
item.fqhc.cat 10 FREE L PBR.CHG.CAT *(HP3)HPY[py]T[pyT]I[pyTI]0|4
item.hold.rsn 10 FREE L PBR.HOLD.REASON*(HP3)HPY[py]T[pyT]I[pyTI]0|5
item.location 8 FREE L PBR.LOCATION *(HP3)HPY[py]T[pyT]I[pyTI]|2
item.meditech.bch.id 29 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]|22
item.minutes 5 SINT R *(HP3)HPY[py]T[pyT]I[pyTI]|26
item.modifier 6 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]|17
item.posted 1 YN L VAL=IF{@status="POSTED" "Y";"N"}
item.procedure 10 FREE L PBR.PROC *(HP3)HPY[py]T[pyT]I[pyTI]|3
item.prv.enc 10 PINT R *(HP3)HPY[py]T[pyT]I[pyTI]0|2
item.prv.practice 10 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]0|1
item.prv.user 10 FREE L MIS.USER *(HP3)HPY[py]T[pyT]I[pyTI]0|0
item.pt.initial.amt 9 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]|25
item.quantity 5 SINT R *(HP3)HPY[py]T[pyT]I[pyTI]|6
item.ref.in.phy 10 FREE L MIS.DOC *(HP3)HPY[py]T[pyT]I[pyTI]|11
item.ref.out.phy 10 FREE L MIS.DOC *(HP3)HPY[py]T[pyT]I[pyTI]|21
item.rev.rsn 10 FREE L PBR.REV.RSN *(HP3)HPY[py]T[pyT]I[pyTI]TX|1
item.rpt.count 3 PINT R *(HP3)HPY[py]T[pyT]I[pyTI]|12
item.run.total 12 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]|13
item.rvp.urn 8 URN L *(HP3)HPY[py]T[pyT]I[pyTI]0|11
item.service.date 8 DATE L *(HP3)HPY[py]T[pyT]I[pyTI]|0
item.std.amount 12 MONEY R *(HP3)HPY[py]T[pyT]I[pyTI]|10
item.therapist 8 FREE L PBR.DOCTOR *(HP3)HPY[py]T[pyT]I[pyTI]|16
item.time1 4 HHMM L *(HP3)HPY[py]T[pyT]I[pyTI]TX|2
item.time2 4 HHMM L *(HP3)HPY[py]T[pyT]I[pyTI]TX|3
item.type 3 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]|4
item.undist.acct 44 URN L PBR.ACT *(HP3)HPY[py]T[pyT]I[pyTI]0|6
item.undist.bd.urn 5 URN L *(HP3)HPY[py]T[pyT]I[pyTI]0|10
item.undist.pbr.status 2 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]0|9
item.undistributed 12 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]|14
item.unit.amount 12 MONEY R *(HP3)HPY[py]T[pyT]I[pyTI]|9
item.vis.txn.urn 5 URN L *(HP3)HPY[py]T[pyT]I[pyTI]1|0
old.item.add.desc 40 FREE L *(HP3)HPY[py]T[pyT]I[pyTI]|8
Ì € i 2
txn.item.cd.queries
[urn,txn.number,item.urn, item.cd.query]
*(HP3)HPY[py]T[pyT]I[pyTI]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.cd.query 10 FREE L MIS.QUERY ggv
item.cd.response 75 QRY.RESP L *(HP3)HPY[py]T[pyT]I[pyTI]CD[ggv]|0
Ì € i 2
txn.item.diag
[urn,txn.number,item.urn, item.diag.seq]
*(HP3)HPY[py]T[pyT]I[pyTI]D[naxSQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.diag.seq 2 FREE L naxSQ
item.diagnosis 6 FREE L PBR.DIAGNOSIS *(HP3)HPY[py]T[pyT]I[pyTI]D[naxSQ]|0
Ì € i 2
txn.items.distrib
[urn,txn.number,item.urn, txn.items.dis.seq]
*(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.items.dis.seq 4 PINT R pyTD
txn.items.dis.acct 44 URN L PBR.ACT *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|6
txn.items.dis.amount 9 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|1
txn.items.dis.bd.urn 5 URN L *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|8
txn.items.dis.bd.xfr.amt 9 SMONEY R *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|9
txn.items.dis.claim.stat 1 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|4
txn.items.dis.conv.urn 5 INT R *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|15
txn.items.dis.doc 8 FREE L PBR.DOCTOR *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|2
txn.items.dis.loc 8 FREE L PBR.LOCATION *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|3
txn.items.dis.pbr.status 2 CHOICE L *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|7
txn.items.dis.urn 4 URN L *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|0
txn.items.dis.xfr.ins 10 FREE L PBR.INS *(HP3)HPY[py]T[pyT]I[pyTI]D[pyTD]|5
Index Files Subscripts/Physical Base
bd.receipt.x [date,urn,txn.number,item.urn,item.type,agency] = bd.amt
?(HP)HPYBD[pyD,py,pyT,pyTI,pyTY,pea]
except.x [date,urn,txn.number,item.urn]
?(HP)HPYEX[pyD,py,pyT,pyTI]
id.x [date,journal,bchnum] = urn
?(HP)HPYI[pyD,pdj,pyN]
ml.sort.by.name [date,PBR.ACT.sort.name,txn.account,urn,txn.number,item.urn,ml.type]
?(HP)HPYMN[pyD,pzN,pz,py,pyT,pyTI,pymlT]
ml.sort.by.number [date,PBR.ACT.actnum,txn.account,urn,txn.number,item.urn,ml.type]
?(HP)HPYMR[pyD,pzR,pz,py,pyT,pyTI,pymlT]
ml.sort.by.procedure [date,item.procedure,PBR.ACT.actnum,urn,txn.number,item.urn]
?(HP)HPYMP[pyD,pdp,pzR,py,pyT,pyTI]
number.x [date,bchnum] = urn
?(HP)HPYR[pyD,pyN]
refund.x [date,urn,txn.number,item.urn]
?(HP)HPYRF[pyD,py,pyT,pyTI]
unposted.x [PBR.ACT.account,PBR.ACT.txn.urn] = txn.items.dis.amount
?(HP)HPYJ[pz,pzT]
unposted2.x [PBR.ACT.account,PBR.ACT.txn.urn] = txn.items.dis.amount
?(HP)HPYJTMP[pz,pzT]
|
|
| | | | | | | | | | |