Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
ITN | varchar(12) | not null | Internal Number used to create a Unique Key for Active Patient Files |
CHARGE_NO | varchar(15) | not null | Charge Number(Order or Adjust Number) |
QTY | varchar(8) | null | Quantity |
AMOUNT | varchar(10) | null | Amount |
UNIT_COST | varchar(15) | null | Unit Cost |
DRUG_CODE | varchar(5) | null | Drug Code |
CDM_NO | varchar(8) | null | CDM(charge description master) Number(drug or iv method) |
DRUGNAME_IVMETHOD | varchar(30) | null | Generic Name or IV Method |
DRUGNAME_IVMETHOD_TM | varchar(30) | null | Generic Name Tall Man or IV Method |
SITE | varchar(2) | null | Hospital Site |
PAT_NUM | varchar(12) | null | Patient Number |
PTNAME | varchar(32) | null | Patient Name |
CHARGE_TYPE | varchar(3) | null | Charge Type(Null=Order Ingredient Charge, INT=Intervention Charge, MCC=Mini Charge/Credit, MCS=Miscellaneous Charge, MTD=Method Charge) |
BILLING_PAT_NUM | varchar(12) | null | Billing Patient Number |
PATIENT_OID | INT | not null | Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export. |
|
|
|