Hi Brandon,
I have a similar report I use and used a different index file, bd.age.x.
If you end up using a date range as Dennis's response suggests, then you
might want to use the bd.age.date to specify your range, but changing the
index file might give you what you're looking for.
Francisco "Frank" Amor
Financial Systems Coordinator, MIS
Southwest Medical Center
PO Box 1340
Liberal, KS 67905
(620) 629-6377 - Office
(620) 629-6352 - Fax
"Gauntt, Brandon K." <[EMAIL PROTECTED]>
Sent by: [email protected]
03/20/2007 03:48 PM
To
<[email protected]>, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
cc
Subject
[MEDITECH-L] BAR report question
I have a report that I wrote for a bad debt collection agency that should
be straightforward to download weekly for one agency. The problem I have
is that the same patient prints over and over again. I have attached the
source code hoping that I am just missing something very simple. I am
hoping that someone can help point out my mistake. Any help would be
appreciated. Thanks,
Brandon Gauntt
Director - Information Services
Hopkins County Memorial Hospital
903-439-4054 Office
www.hcmh.com
This e-mail, facsimile, or letter and any files or attachments transmitted
with it contains information that is confidential and privileged. This
information is intended only for the use of the individual(s) and
entity(ies) to whom it is addressed. If you are the intended recipient,
further disclosures are prohibited without proper authorization. If you
are not the intended recipient, any disclosure, copying, printing, or use
of this information is strictly prohibited and possibly a violation of
federal or state law and regulations. If you have received this
information in error, please notify Baylor Health Care System immediately
at 1-866-402-1661 or via e-mail at [EMAIL PROTECTED] Baylor Health
Care System, its subsidiaries, and affiliates hereby claim all applicable
privileges related to this information.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM.
To check the status of the meditech-l, visit MTUsers.NET.
For help, email [EMAIL PROTECTED]
______________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
REPORT LIST
PAGE 1
RUN ON 03/20/07-1543
HCD.LIVE
RUN BY BRANDONG
BAR.PAT.zcus.bkg.sbc.download
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SCREEN: BAR.PAT.zcus.bkg.sbc.download
LN
+----------1---------2---------3---------4---------5---------6---------7--------+
1=c.agency
1 |Enter Agency:@1
|
+-------------------------------------------------------------------------------+
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
REPORT: BAR.PAT.zcus.bkg.sbc.download
CPI=12
CPL=200 LPI=6 LPG=60 PGSZ=66 MARG=0 BAN=NONE
TYPE LN
+----------1---------2---------3---------4---------5---------6---------7---------8---------9---------0---------1---------2---------3---------4---------5---------6---------7---------8---------9---------+
D 1
|number______pt.name__________________soc.sec________dob_______guar.name________________guar.adr1_____________________guar.adr2_____________________guar.city___________guguar.zip__
|
D 2
|guar.home.phone___guar.emp.name_________________guar.emp.phone____guar.soc.sec___adm.datedis.datear.chg.to__balancelast.paylast.pay.amountfin.class_visit.reason__________________
|
D 3
|ins1.name.disp___________ins1.addr.disp________________ins1.city.disp________________inins1.zip.dins1.phone.dissubscriber.name__________insured.policy.numb___________subscriber.grou
|
D 4
|subscriberins2.name.disp___________ins2.addr.disp________________ins2.city.disp________________inins2.zip.dins2.phone.disins2.group.numbins3.name.disp___________ins3.addr.disp________________
|
D 5
|ins3.city.disp________________inins3.zip.dins3.phone.disins3.group.numb
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
LINE ATTRIBUTES
---- ----------
1 NL = N
2 NL = N
3 NL = N
4 NL = N
FIELDS
------
1 number = number
23 ins1.name.disp = ins1.name.disp [LEN=25]
2 pt.name = pt.name [LEN=25]
24 ins1.addr.disp = ins1.addr.disp
3 soc.sec = soc.sec
25 ins1.city.disp = ins1.city.disp
4 dob = dob
26 in = ins1.state.disp
5 guar.name = guar.name [LEN=25]
27 ins1.zip.d = ins1.zip.disp
6 guar.adr1 = guar.adr1
28 ins1.phone.dis = ins1.phone.disp [LEN=14]
7 guar.adr2 = guar.adr2
29 subscriber.name = subscriber.name [LEN=25]
8 guar.city = guar.city
30 insured.policy.numb = insured.policy.number
9 gu = guar.state
31 subscriber.grou = subscriber.group.number
10 guar.zip = guar.zip
32 subscriber = subscriber.relationship
11 guar.home.phone = guar.home.phone
33 ins2.name.disp = ins2.name.disp [LEN=25]
12 guar.emp.name = guar.emp.name
34 ins2.addr.disp = ins2.addr.disp
13 guar.emp.phone = guar.emp.phone
35 ins2.city.disp = ins2.city.disp
14 guar.soc.sec = guar.soc.sec
36 in = ins2.state.disp
15 adm.date = adm.date
37 ins2.zip.d = ins2.zip.disp
16 dis.date = dis.date
38 ins2.phone.dis = ins2.phone.disp [LEN=14]
17 ar.chg.to = ar.chg.total
39 ins2.group.numb = ins2.group.number
18 balance = balance
40 ins3.name.disp = ins3.name.disp [LEN=25]
19 last.pay = last.pay.date
41 ins3.addr.disp = ins3.addr.disp
20 last.pay.amount = last.pay.amount
42 ins3.city.disp = ins3.city.disp
21 fin.class = fin.class
43 in = ins3.state.disp
22 visit.reason = visit.reason [LEN=30]
44 ins3.zip.d = ins3.zip.disp
(CONTINUED)
REPORT LIST
PAGE 2
RUN ON 03/20/07-1543
HCD.LIVE.Ring
BAR.PAT.zcus.bkg.sbc.download {continued}
45 ins3.phone.dis = ins3.phone.disp [LEN=14]
46 ins3.group.numb = ins3.group.number
DETAIL SEGMENT: top
INDEX FILE: ins.subscriber.x
SORT FIELDS PRODUCED BY DETAIL SEGMENT/INDEX FILE
1 subscriber.urn
2 account
3 insurance
# SELECT OP PROMPT/VALUE
DEFAULT/KEYWORD
-------- -- ------------
---------------
1 agency EQ Enter Agency:
2 balance GT 0
NOTES: SFF NO
PFF NO
EFF NO
FD 124
RL 600
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM.
To check the status of the meditech-l, visit MTUsers.NET.
For help, email [EMAIL PROTECTED]
______________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
