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 |
SVC_DATE | varchar(8) | not null | Service Date(YYYYMMDD) |
CHG_ID | varchar(6) | not null | Charge ID(Either the PMP(Pharmacy Order Number), or INT=Intervention Charge, MCC=Mini Charge/Credit, MCS=Miscellaneous Charge, MTD=Method Charge) |
CHG_SEQ | varchar(7) | not null | Charge Sequence |
FUNCTION | varchar(3) | null | Function Code(Link to TRANFUNCTION_MASTER.FUNCTION) |
CHGTYPE | varchar(3) | null | Charge Type(Null=Order Ingredient Charge, INT=Intervention Charge, MCC=Mini Charge/Credit, MCS=Miscellaneous Charge, MTD=Method Charge) |
QTY | varchar(6) | null | Quantity |
AMOUNT | varchar(10) | null | Amount |
UNIT_COST | varchar(15) | null | Unit Cost |
CHG_DESC | varchar(30) | null | Charge Code Description |
CHG_CODE | varchar(6) | null | Charge Code |
CDM_CODE | varchar(8) | null | CDM(Charge Description Master) Code(Link to CDMX.FMS_CDM_NO) |
DRG_STRENGTH | varchar(47) | null | Drug Strength |
NUM_OF_DOSES | varchar(7) | null | Number of Doses |
DOSE | varchar(47) | null | Dose |
DISP_UNIT | varchar(20) | null | Dispensing Unit |
CONTROL_DRUG_FLA | varchar(1) | null | Control Drug Flag |
LEGAL_STATUS_COD | varchar(2) | null | Legal Status Code |
LABELER | varchar(32) | null | Labeler |
DOSE_FORM | varchar(32) | null | Dose Form |
DR_NUMBER | varchar(6) | null | Doctor Number |
DR_NAME | varchar(32) | null | Doctor Name |
COMPONENT | varchar(12) | null | Component |
PAT_NUMBER | varchar(12) | null | Patient Number |
PAT_SITE | varchar(2) | null | Patient Site |
PAT_CLASS | varchar(1) | null | Patient Class |
PAT_BILLING_NUMB | varchar(12) | null | Patient Billing Number |
ENT_LOCATION | varchar(2) | null | Entered Location |
MCC_CAB_ID | varchar(13) | null | Mini Charge/Credit(MCC) Cabinet Id |
MCC_ENTERED_BY | varchar(6) | null | Mini Charge/Credit(MCC) Entered By |
UNIQUE_ID | varchar(10) | null | Unique Id |
BUCKET_DESC | varchar(15) | null | Bucket Description |
RX_LOCATION | varchar(5) | null | Pharmacy Location |
NRS_STATION | varchar(13) | null | Nurse Station |
PTTYPE | varchar(1) | null | Patient Type(Link to PTM.PTTYPE) |
PTSERV | varchar(3) | null | Patient Service |
CUSTOM_FIELD | varchar(16) | null | Custom Field |
MEDICAID_NDC_NUMBER | varchar(14) | null | Medicaid NDC(National Drug Code) Number |
MEDICAID_NDC_QUANTITY | varchar(10) | null | Medicaid NDC(National Drug Code) Quantity |
MEDICAID_NDC_UNIT_OF_MEASURE | varchar(7) | null | Medicaid NDC(National Drug Code) Unit of Measure |
RX_NUMBER | varchar(12) | null | Rx Number |
MEDICAID_NDC_UNIT_COST | varchar(12) | null | Medicaid NDC(National Drug Code) Unit Cost |
JCODE_WASTE_QTY | varchar(12) | null | Jcode(Healthcare Common Procedure Coding System(HCPCS) Level II alpha-numeric code issued by CMS to identify and describe a drug product) Waste Qty |
JCODE_WASTE_COST | varchar(12) | null | Jcode(Healthcare Common Procedure Coding System(HCPCS) Level II alpha-numeric code issued by CMS to identify and describe a drug product) Waste Cost |
JCODE_DISP_QTY | varchar(12) | null | Jcode(Healthcare Common Procedure Coding System(HCPCS) Level II alpha-numeric code issued by CMS to identify and describe a drug product) Dispensed Qty |
JCODE_DISP_COST | varchar(12) | null | Jcode(Healthcare Common Procedure Coding System(HCPCS) Level II alpha-numeric code issued by CMS to identify and describe a drug product) Dispensed Cost |
MEDICAID_NDC_NODU | varchar(12) | null | Medicaid NDC Number Dispensing Units |
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. |
|
|
|