Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES_ENHANCED_HELD Pharmacy Active Patient Enhanced Charges Held
Column Name Column Datatype Column Null Option Column Comment
ITNvarchar(12)not null Internal Number used to create a Unique Key for Active Patient Files
SVC_DATEvarchar(8)not null Service Date(YYYYMMDD)
CHG_IDvarchar(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_SEQvarchar(7)not null Charge Sequence
FUNCTIONvarchar(3)null Function Code(Link to TRANFUNCTION_MASTER.FUNCTION)
CHGTYPEvarchar(3)null Charge Type(Null=Order Ingredient Charge, INT=Intervention Charge, MCC=Mini Charge/Credit, MCS=Miscellaneous Charge, MTD=Method Charge)
QTYvarchar(6)null Quantity
AMOUNTvarchar(10)null Amount
UNIT_COSTvarchar(15)null Unit Cost
CHG_DESCvarchar(30)null Charge Code Description
CHG_CODEvarchar(6)null Charge Code
CDM_CODEvarchar(8)null CDM(Charge Description Master) Code(Link to CDMX.FMS_CDM_NO)
DRG_STRENGTHvarchar(47)null Drug Strength
NUM_OF_DOSESvarchar(7)null Number of Doses
DOSEvarchar(47)null Dose
DISP_UNITvarchar(20)null Dispensing Unit
CONTROL_DRUG_FLAvarchar(1)null Control Drug Flag
LEGAL_STATUS_CODvarchar(2)null Legal Status Code
LABELERvarchar(32)null Labeler
DOSE_FORMvarchar(32)null Dose Form
DR_NUMBERvarchar(6)null Doctor Number
DR_NAMEvarchar(32)null Doctor Name
COMPONENTvarchar(12)null Component
PAT_NUMBERvarchar(12)null Patient Number
PAT_SITEvarchar(2)null Patient Site
PAT_CLASSvarchar(1)null Patient Class
PAT_BILLING_NUMBvarchar(12)null Patient Billing Number
ENT_LOCATIONvarchar(2)null Entered Location
MCC_CAB_IDvarchar(13)null Mini Charge/Credit(MCC) Cabinet Id
MCC_ENTERED_BYvarchar(6)null Mini Charge/Credit(MCC) Entered By
UNIQUE_IDvarchar(10)null Unique Id
BUCKET_DESCvarchar(15)null Bucket Description
RX_LOCATIONvarchar(5)null Pharmacy Location
NRS_STATIONvarchar(13)null Nurse Station
PTTYPEvarchar(1)null Patient Type(Link to PTM.PTTYPE)
PTSERVvarchar(3)null Patient Service
CUSTOM_FIELDvarchar(16)null Custom Field
MEDICAID_NDC_NUMBERvarchar(14)null Medicaid NDC(National Drug Code) Number
MEDICAID_NDC_QUANTITYvarchar(10)null Medicaid NDC(National Drug Code) Quantity
MEDICAID_NDC_UNIT_OF_MEASUREvarchar(7)null Medicaid NDC(National Drug Code) Unit of Measure
RX_NUMBERvarchar(12)null Rx Number
MEDICAID_NDC_UNIT_COSTvarchar(12)null Medicaid NDC(National Drug Code) Unit Cost
JCODE_WASTE_QTYvarchar(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_COSTvarchar(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_QTYvarchar(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_COSTvarchar(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_NODUvarchar(12)null Medicaid NDC Number Dispensing Units
PATIENT_OIDINTnot null Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates