|
Export
File
The
'Formulary Pricing' module automatically creates a file that can be used to
update the patient prices in an external financial system.
If you want to do this, the file must be supplied to the staff that
manages the financial system (e.g., by diskette, network, etc.).
Unless
the export file is used, Ascend does not typically update prices in an external
financial system. Be sure to specify the file location and name on the
main screen.
Format : Standard
The
format of the export file is as follows (fixed-record length):
|
Field |
Len |
Position |
Type |
|
Charge
code |
16 |
1-16 |
Text |
|
Patient
Charge |
12 |
17-28 |
Numeric |
|
Drug
name |
35 |
29-63 |
Text |
|
CR+LF |
2 |
64-65 |
|
Drug name is a concatenation of the Drug Description + Dose +
Units + '/' + Per + Units
Example:
| Charge Code |
Price |
Drug Name |
| 55512121 |
5.38 |
ACETAMINOPHEN
DROPS 100 MG /
ML |
| 55512122 |
19.88 |
ACETAMINOPHEN
SUPP 325 MG |
| 55512123 |
0.70 |
ACETAMINOPHEN TAB
325 MG |
| 55512124 |
1.14 |
POTASSIUM CHLORIDE
10% LIQ 20 MEQ / 15 ML |
Format : Standard w/NDC
The
format of the export file is as follows (fixed length records):
|
Field |
Len |
Position |
Type |
|
Charge
code |
12 |
1-12 |
Text |
|
Patient
Charge |
12 |
13-24 |
Numeric |
|
Drug
name |
30 |
25-54 |
Text |
| Dose
Quantity |
7 |
55-61 |
Numeric |
| Dose Units |
7 |
62-68 |
Text |
| Per Quantity |
7 |
69-75 |
Numeric |
| Per
Units |
7 |
76-82 |
Text |
| NDC |
11 |
83-93 |
Text |
|
CR+LF |
2 |
|
|
| Charge
Code |
Price |
Drug Name |
Dose Qty |
Dose Units |
Per Qty |
Per Units |
NDC |
| 55512121 |
5.38 |
ACETAMINOPHEN
DROPS |
100 |
MG |
0 |
ML |
00536012372 |
| 55512122 |
19.88 |
ACETAMINOPHEN SUPP |
325 |
MG |
0 |
|
08881602133 |
| 55512123 |
0.70 |
ACETAMINOPHEN TAB |
325 |
MG |
0 |
|
51079000219 |
Format: HMS:
The
format of the export file is as follows ( fixed length records):
|
Field |
Len |
Position |
Type |
|
Charge
code |
12 |
1-12 |
Text |
|
Patient
Charge |
10 |
13-22 |
Numeric |
|
Drug
name |
29 |
23-51 |
Text |
|
CR+LF |
2 |
|
|
Example:
| Charge Code |
Price |
Drug Name |
| 55512121 |
0000005.38 |
ACETAMINOPHEN
DROPS 100 MG /
ML |
| 55512122 |
0000019.88 |
ACETAMINOPHEN
SUPP 325 MG |
| 55512123 |
0000000.70 |
ACETAMINOPHEN TAB
325 MG |
|