Re: [MEDITECH-L] Formulary NPR Report

Sat, 20 Jan 2007 09:42:08 -0800 

Bob,

I wrote this report for one of my clients in Magic. Hope this helps.
Please feel free to call if you have any question.

Hao Luu
Programmer
The IN Group, Inc.
714-955-7613


> Hi everyone,
>
> Has anyone developed a NPR report that can be used to download all of the
> fields in the Drug Dictionary as either a CSV or TXT file? I'm working at
> cleaning up my formulary and fixing some of the data entry errors that can
> creep into any file this size and would love to be able to build either a
> spreadsheet or a data base for identifying some of the issues. It seems
> crazy
> that I can't run quick queries without having to have IS write a NPR
> report
> and going through the whole testing and development routine.
>
> I'd be interested to hear how everyone else handles this sort of thing.
>
> Thanks,
> Bob
>
> Robert Brennan RPh
> St Joseph Health Services of  Rhode Island
> Department of Pharmacy
> 200 High Service Ave
> N. Providence, RI 02904
> (401) 456-3522
>
>
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
> 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
>

MEDITECH.CUST.RPTS^Providence Health 
Services-California^CA^TEST.5.5.MIS^HXL9^20070116^PTA^
@@VERSION:1
PHA.DRUG.zcus.tig.formulary.download
@@PROC
PHA.DRUG.zcus.tig.formulary.download
PHA.DRUGzcus.tig.formulary.downloadUYY
@@RPT
Yzcus.tig.formulary.downloadPHA.DRUG
AT      842870418
HXL9E
AT      843293133
HXL9E
AT      843389226
PRC3C(PHA.DRUG.zcus.prc.formulary.download.cdm
AT      844617723
HXL9E
AT      844788925
HXL9E
AT      845726051
HXL9C/PHA.DRUG.zcus.tig.formulary.download.for.phcsub
AT      845921975
PRC3E
AT      845971289
HXL9E
AT      845971307
HXL9C(PHA.DRUG.zcus.tig.formulary.download.bar
AT      845983583
HXL9E
CI

F1
mnemonic
F2
ndc.din.number
F3

xx.drug.id
xx.drug.id2L
F3CDAT
FREE
F3CJFY
L
F3CLEN
72
F3CVAL
[EMAIL PROTECTED];@[EMAIL PROTECTED]" "[EMAIL PROTECTED]" "[EMAIL PROTECTED]
F4
name
F5

xx.other.mne1
xx.other.mne12L
F5CDAT
FREE
F5CJFY
L
F5CLEN
15
F5CVAL
@First(other.mnemonic)^OM1
F6

xx.other.mne2
xx.other.mne22L
F6CDAT
FREE
F6CJFY
L
F6CLEN
15
F6CVAL
IF{OM1^other.mnemonic @Next(other.mnemonic);""}^OM2
F7
xx.admin.route1
F7CDAT
FREE
F7CJFY
L
F7CLEN
10
F7CVAL
@First(admin.route)^AR1
F8
xx.admin.route2
F8CDAT
FREE
F8CJFY
L
F8CLEN
10
F8CVAL
IF{AR1^admin.route @Next(admin.route);""}^AR2
F9
xx.admin.route3
F9CDAT
FREE
F9CJFY
L
F9CLEN
10
F9CVAL
IF{AR2^admin.route @Next(admin.route);""}^AR3
F10
xx.admin.route4
F10CDAT
FREE
F10CJFY
L
F10CLEN
10
F10CVAL
IF{AR3^admin.route @Next(admin.route);""}^AR4
F11
xx.admin.route5
F11CDAT
FREE
F11CJFY
L
F11CLEN
10
F11CVAL
IF{AR4^admin.route @Next(admin.route);""}^AR5
F12
xx.admin.route6
F12CDAT
FREE
F12CJFY
L
F12CLEN
10
F12CVAL
IF{AR5^admin.route @Next(admin.route);""}^AR6
F13
print.number
print.numb10R
F14
xx.generic.name
F14CDAT
FREE
F14CJFY
L
F14CLEN
30
F14CVAL
@[EMAIL PROTECTED]
F15
strength
F16

admin.form
admin.form10L
F17

dispense.form
dispense.f10L
F18

order.size
F19

order.unit
order.unit10L
F20

dispense.size
F21

dispense.unit
dispense.u10L
F22
        bulk.form
F23
        bulk.size
F24
        drug.type
F25
        xx.emr.id
F25CDAT
FREE
F25CJFY
L
F25CLEN
35
F25CVAL
@[EMAIL PROTECTED]
F26
carrier
F27
premix
F28
additive
F29

ingredient
F30

order.from.oe
F31
xx.restricted.sites
F31CDAT
FREE
F31CJFY
L
F31CLEN
40
F31CVAL
IF{""^access.to.limit^ST,[EMAIL PROTECTED](access.to.limit) IF{'ST 
access.to.limit^ST;ST_"/"_access.to.limit^ST}}},ST
F31CLVAL1
25
F31CLVAL2
52
F31CLVAL3
31
F32
        unit.cost
F33
unit.awp
F34

xx.package
xx.package2L
F34CDAT
FREE
F34CJFY
L
F34CLEN
10
F34CVAL
@dispense.form
F35

xx.pkgd.in
xx.pkgd.in2L
F35CDAT
FREE
F35CJFY
L
F35CLEN
30
F35CVAL
IF{""^pack.q^PCK,[EMAIL PROTECTED](pack.q) IF{'PCK @package^PCK;PCK_"/"[EMAIL 
PROTECTED],PCK
F35CLVAL1
55
F35CLVAL2
27
F36
up
F37
xx.packing.string
F37CDAT
FREE
F37CJFY
L
F37CLEN
32
F37CVAL
IF{mnemonic^/mnemonic %PHA.DRUG.pkg.string("")}^PCKS
F38
document.cds
F39
adj.admin.mins
F40
cosig.req.doc.med
F41
cosig.req.doc.iv
F42
variance.limit
F43
multidose.container
F44
lab.test.group
lab.test.g10L
F45
auto.display.order
F46
auto.display.admin
F47
auto.display.verify
F48
xx.dose.range1
F48CDAT
FREE
F48CJFY
L
F48CLEN
15
F48CVAL
@First(dose.range)^dose.range
F49
xx.dose.range.name1
F49CDAT
FREE
F49CJFY
L
F49CLEN
30
F49CVAL
[EMAIL PROTECTED](dose.range)^dose.range @PHA.DR.name}
F50
        xx.error1
F50CDAT
FREE
F50CJFY
L
F50CLEN
1
F50CVAL
[EMAIL PROTECTED](dose.range)^dose.range @dose.range.error}
F51
xx.calc1
F51CDAT
FREE
F51CJFY
L
F51CLEN
1
F51CVAL
[EMAIL PROTECTED](dose.range)^dose.range @dose.range.display}
F52
xx.dose.range2
F52CDAT
FREE
F52CJFY
L
F52CLEN
15
F52CVAL
[EMAIL PROTECTED](dose.range)^dose.range @Next(dose.range)}
F53
xx.dose.range.name2
F53CDAT
FREE
F53CJFY
L
F53CLEN
30
F53CVAL
[EMAIL PROTECTED](dose.range)^dose.range @Next(dose.range),@PHA.DR.name}
F53CLVAL1
51
F53CLVAL2
13
F54
        xx.error2
F54CDAT
FREE
F54CJFY
L
F54CLEN
1
F54CVAL
[EMAIL PROTECTED](dose.range)^dose.range @Next(dose.range),@dose.range.error}
F55
xx.calc2
F55CDAT
FREE
F55CJFY
L
F55CLEN
1
F55CVAL
[EMAIL PROTECTED](dose.range)^dose.range @Next(dose.range),@dose.range.display}
F56
xx.phc.dose
xx.phc.dos2L
F56CDAT
FREE
F56CJFY
L
F56CLEN
10
F56CVAL
@dft.dose.ee["PHC"]
F57

xx.phc.sig
xx.phc.sig2L
F57CDAT
FREE
F57CJFY
L
F57CLEN
20
F57CVAL
@dft.sig.ee["PHC"]
F58

xx.phc.med
xx.phc.med2L
F58CDAT
FREE
F58CJFY
L
F58CLEN
10
F58CVAL
@dft.inp.chg.type.ee["PHC"]
F59
        xx.phc.iv
F59CDAT
FREE
F59CJFY
L
F59CLEN
10
F59CVAL
@dft.inp.iv.chg.type.ee["PHC"]
F60
xx.phc.comp
xx.phc.com2L
F60CDAT
FREE
F60CJFY
L
F60CLEN
10
F60CVAL
@dft.inp.comp.chg.type.ee["PHC"]
F61
xx.phc.stk.med
xx.phc.stk2L
F61CDAT
FREE
F61CJFY
L
F61CLEN
10
F61CVAL
@dft.inp.stock.chg.type.ee["PHC"]
F62

xx.phc.stk.iv
xx.phc.stk2L
F62CDAT
FREE
F62CJFY
L
F62CLEN
10
F62CVAL
@dft.inp.stk.iv.cg.type.ee["PHC"]
F63
xx.phc.bill.number
xx.phc.bil2L
F63CDAT
FREE
F63CJFY
L
F63CLEN
10
F63CVAL
@bill.number.ee["PHC"]
F64
xx.psj.dose
xx.psj.dos2L
F64CDAT
FREE
F64CJFY
L
F64CLEN
10
F64CVAL
@dft.dose.ee["PSJ"]
F65

xx.psj.sig
xx.psj.sig2L
F65CDAT
FREE
F65CJFY
L
F65CLEN
20
F65CVAL
@dft.sig.ee["PSJ"]
F66

xx.psj.med
xx.psj.med2L
F66CDAT
FREE
F66CJFY
L
F66CLEN
10
F66CVAL
@dft.inp.chg.type.ee["PSJ"]
F67
        xx.psj.iv
F67CDAT
FREE
F67CJFY
L
F67CLEN
10
F67CVAL
@dft.inp.iv.chg.type.ee["PSJ"]
F68
xx.psj.comp
xx.psj.com2L
F68CDAT
FREE
F68CJFY
L
F68CLEN
10
F68CVAL
@dft.inp.comp.chg.type.ee["PSJ"]
F69
xx.psj.stk.med
xx.psj.stk2L
F69CDAT
FREE
F69CJFY
L
F69CLEN
10
F69CVAL
@dft.inp.stock.chg.type.ee["PSJ"]
F70

xx.psj.stk.iv
xx.psj.stk2L
F70CDAT
FREE
F70CJFY
L
F70CLEN
10
F70CVAL
@dft.inp.stk.iv.cg.type.ee["PSJ"]
F71
xx.psj.bill.number
xx.psj.bil
F71CDAT
FREE
F71CJFY
L
F71CLEN
10
F71CVAL
@bill.number.ee["PSJ"]
F72
control.schedule
control.sc10L
FS1
active
FS1SE1
EQ"Y"
FI60
101
FI611
122
FI624
723
FI697
454
FI6143
155
FI6159
156
FI6175
107
FI6186
108
FI70
109
FI711
1010
FI722
1011
FI733
1012
FI744
1013
FI755
3014
FI786
3015
FI7117
1016
FI7128
1017
FI7139
818
FI7148
1019
FI7159
820
FI7168
1021
FI7179
1022
FI7190
823
FI80
1024
FI811
3525
FI847
126
FI849
127
FI851
128
FI853
129
FI855
130
FI857
4031
FI898
932
FI8108
933
FI8118
1034
FI8129
3035
FI8160
436
FI8165
3237
FI90
1538
FI916
339
FI920
140
FI922
141
FI924
442
FI929
143
FI931
1044
FI942
845
FI951
846
FI960
847
FI969
1548
FI985
3049
FI9116
150
FI9118
151
FI9120
1552
FI9136
3053
FI9167
154
FI9169
155
FI9171
1056
FI100
2057
FI1021
1058
FI1032
1059
FI1043
1060
FI1054
1061
FI1065
1062
FI1076
1063
FI1087
1064
FI1098
2065
FI10119
1066
FI10130
1067
FI10141
1068
FI10152
1069
FI10163
1070
FI10174
1071
FI10185
1072
L1
HR
L1CNL
NO
L2
HR
L2CNL
NO
L3
HR
L3CNL
NO
L4
HR
L4CNL
NO
L5
HR
L6
D
L6CNL
NO
L7
D
L7CNL
NO
L8
D
L8CNL
NO
L9
D
L9CNL
NO
L10
D
N1
RL 1000
N2
EFF NO
N3
SFF NO
N4
PFF NO
P1
Mnemonic|NDC#|Drug ID|Trade Name|Other Mnemonic #1|Other Mnemonic #2|Admin 
Route #1|Admin Route #2|Admin Route #3|Admin Route #4|Admin Route #5|Admin 
Route #6|Print Number|Generic Name|Strength|Admin
P2
Form|Dispense Form|Order Size|Order Unit|Dispense Size|Dispense Unit|Bulk 
Form|Bulk Size|Drug Type|EMR ID|Carrier|Pre-mix|Additive|Compound|Ord: by 
OE|Restricted Sites|Unit Cost|Unit AWP|Package|Pkg'd
P3
 in|UP|Packaging String|NUR Document CDS|Adjust Admin Minutes|Co-Signature for 
Doc MED|Co-Signature For Doc IV|Variance Limit|Multidose Container|LAB Test 
View Group|Auto-Disp at Order|Auto-Disp at Ad
P4
min|Auto-Disp at Verify|Dose Range #1|Dose Range Name #1|Error #1|Calc #1|Dose 
Range #2|Dose Range Name #2|Error #2|Calc #2|PHC Dose|PHC Sig|PHC Inp Med|PHC 
Inp IV|PHC Inp Comp|PHC Inp Stk Med|PHC Inp
P5
 Stk IV|Billing Code|PSJ Dose|PSJ Sig|PSJ Inp Med|PSJ Inp IV|PSJ Inp Comp|PSJ 
Inp Stk Med|PSJ Inp Stk IV|PSJ Billing Code|Control Schedule|
P6
mnemonic__|ndc.din.numb|xx.drug.id______________________________________________________________|name_________________________________________|xx.other.mne1__|xx.other.mne2__|xx.ar1____|xx.ar2____|
P7
xx.ar3____|xx.ar4____|xx.ar5____|xx.ar6____|print.numb|xx.generic.name_______________|strength______________________|admin.form|dispense.f|order.si|order.unit|dispense|dispense.u|bulk.form_|bulk.siz|
P8
drug.type_|xx.emr.id__________________________|c|p|a|i|o|xx.restricted.sites_____________________|unit.cost|_unit.awp|xx.package|xx.pkgd.in____________________|up__|xx.packing.string_______________|
P9
document.cds___|adj|c|c|vari|m|lab.test.g|auto.dis|auto.dis|auto.dis|xx.dose.range1_|xx.dose.range.name1___________|x|x|xx.dose.range2_|xx.dose.range.name2___________|x|x|xx.phc.dos|
P10
xx.phc.sig__________|xx.phc.med|xx.phc.iv_|xx.phc.com|xx.phc.stk|xx.phc.stk|xx.phc.bil|xx.psj.dos|xx.psj.sig__________|xx.psj.med|xx.psj.iv_|xx.psj.com|xx.psj.stk|xx.psj.stk|xx.psj.bil|control.sc|
T1
mnemonic
U       845798273
HXL9TEST.5.5.MIS
U       845816212
HXL9TEST.5.5.MIS
U       845914467
HXL9TEST.5.5.MIS
U       845971553
HXL9TEST.5.5.MIS
U       845983852
HXL9TEST.5.5.MIS
U       846001992
HXL9TEST.5.5.MIS
U       846004475
PRC3TEST.5.5.MIS
U       846009831
PRC3TEST.5.5.MIS
U       847127382
LEB13TEST.5.5.MIS
U       847188215
BXM31TEST.5.5.MIS
@@SCRN
Yzcus.tig.formulary.downloadPHA.DRUG$PHA.DRUG.zcus.tig.formulary.download2N
CS
4648
P1
Formulary Download%Z.on.device
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
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

Reply via email to