Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES_LTC Pharmacy Long Term Care Charges
Column Name Column Datatype Column Null Option Column Comment
SERVICE_DATEvarchar(8)not null Service Date(YYYYMMDD)
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PAT_NUMvarchar(12)not null Patient Number
PMPvarchar(5)not null Pharmacy Order Number
SEQvarchar(2)not null Sequence Number
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
CHG_DESCvarchar(30)null Charge Code Description
CHG_CODEvarchar(6)null Charge Code
CDM_CODEvarchar(8)null CDM(Charge Description Master) Code
NDC_NUMBERvarchar(14)null NDC(National Drug Code) Number
RX_NUMBERvarchar(12)null RX Number
COMPvarchar(4)null Component
DAYS_SUPPLYvarchar(2)null Days Supply
DR_NPIvarchar(10)null Doctor NPI Number
DRvarchar(6)null Doctor Number
DR_NAMEvarchar(23)null Doctor Name
PT_NAMEvarchar(31)null Patient Name
PT_BIRTHDATEvarchar(10)null Patient BirthDate
PT_SEXvarchar(1)null Patient Sex
PT_SITEvarchar(1)null Patient Site
PT_CLASSvarchar(1)null Patient Class(I=Inpatient,O=Outpatient,E=EmergencyPatient)
PAT_TYPEvarchar(1)null Patient Type
PAT_SERVICEvarchar(3)null Patient Service
PT_LOCATIONvarchar(13)null Patient Location
PLAN_CDvarchar(15)null Plan Code
GROUP_IDvarchar(15)null Group Id
PT_IDvarchar(15)null Patient ID Number
CLAIM_REFvarchar(13)null Claim Reference Number
BATCH_IDvarchar(13)null Batch Id
PC_KEYvarchar(27)null PC Key
ORDER_TYPEvarchar(3)null Order Type(MED,IV,CXM)
SIGvarchar(15)null SIG(Latin Code)
PCK1varchar(8)null Key 1(ITN) into Active Pharmacy Charging File(PHM_CHARGES)
PCK2varchar(5)null Key 2(KEY2 - PMP or 'I=Interventions' or 'M=Misc Adjust') into Active Pharmacy Charging File(PHM_CHARGES)
PCK3varchar(8)null Key 3(DATETIME_OF_ENTRY) into Active Pharmacy Charging File(PHM_CHARGES)
PCK4varchar(4)null Key 4(SEQ) into Active Pharmacy Charging File(PHM_CHARGES)
CLM_REF_NUMvarchar(20)null Claim Reference Number
PLAN_DESCvarchar(30)null Plan Description
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