Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_METHOD_MF Pharmacy Method Masterfile
Column Name Column Datatype Column Null Option Column Comment
METHODvarchar(6)not null Method Code
DESCRIPTIONvarchar(30)null Method Code Description
METHOD_CHARGEvarchar(6)null Method Charge
STOP_DAYSvarchar(6)null Stop Days for this component from Drug Master
SET_TYPEvarchar(13)null Set Type
FUTUREvarchar(1)null Future Use
ROUTEvarchar(10)null Route of Administration
DUR_TRACKINGvarchar(3)null DUR(Drug Utilization Review) Tracking?(YES or NO)
PUMP_CODEvarchar(12)null IV Pump Code
METHOD_ABBRvarchar(6)null Method Abbreviation
METHOD_CDMvarchar(8)null Method CDM(Charge Description Master)
INSURANCE_CODEvarchar(2)null Insurance Code
SKILL_LEVELvarchar(1)null Skill Level
EARLY_SHIFT_THRESHOLDvarchar(9)null min/max - Threshold for triggering the automatic shift of the IV schedule when administering an IV occurrence before its due time(max=1440/1440)
LATE_SHIFT_THRESHOLDvarchar(9)null min/max - Threshold for triggering the automatic shift of the IV schedule when administering an IV occurrence after its due time(max=1440/1440)
CONTINUOUS_IVvarchar(3)null Continuous IV?(YES or NO)

Return to Table-Index

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