Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CLIN_AUDIT_2 Pharmacy Clinical Checking Audit - Part 2
Column Name Column Datatype Column Null Option Column Comment
CONFLICT_DATEvarchar(8)not null Conflict Date(YYYYMMDD)
CONFLICT_TYPE_CODEvarchar(2)not null Conflict Type Code. Corresponds to Column CONFLICT_DESC.(1=Gen Dup, 2=Algy, 3=Thera Dup, 4=Drug-Drug Int, 5=Ped Prec, 6=Geri Precaution, 7=Drug Lab, 8=IV Incompat, 9=Min/Max, 10=Min/Max Warning)
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PAT_NUMvarchar(12)not null Patient Number
SEQvarchar(3)not null Sequence Number
CONFLICT_DESCvarchar(25)null Conflict Type Description. Corresponds to column CONFLICT_TYPE_CODE. Use CONFLICT_TYPE_CODE to select certain types of conflicts.(GENERIC DUPLICATE, ALLERGY, THERAPEUTIC, DUPLICATE, DRUG-DRUG-INTERACTION, PEDIATRIC PRECAUTION, GERIATRIC PRECAUTION, DRUG-LAB INTERFERENCE, IV INCOMPATIBILITY, MIN/MAX DOSE, MIN/MAX WARNING)
LAB1_NAMEvarchar(12)null Lab Result 1 Name
LAB1_VALUEvarchar(8)null Lab Result 1 Value
LAB1_DATEvarchar(8)null Lab Result 1 Date(YYYYMMDD)
LAB1_TIMEvarchar(5)null Lab Result 1 Time(HH:MM)
LAB2_NAMEvarchar(12)null Lab Result 2 Name
LAB2_VALUEvarchar(8)null Lab Result 2 Value
LAB2_DATEvarchar(8)null Lab Result 2 Date(YYYYMMDD)
LAB2_TIMEvarchar(5)null Lab Result 2 Time(HH:MM)
LAB3_NAMEvarchar(12)null Lab Result 3 Name
LAB3_VALUEvarchar(8)null Lab Result 3 Value
LAB3_DATEvarchar(8)null Lab Result 3 Date(YYYYMMDD)
LAB3_TIMEvarchar(5)null Lab Result 3 Time(HH:MM)
LAB4_NAMEvarchar(12)null Lab Result 4 Name
LAB4_VALUEvarchar(8)null Lab Result 4 Value
LAB4_DATEvarchar(8)null Lab Result 4 Date(YYYYMMDD)
LAB4_TIMEvarchar(5)null Lab Result 4 Time(HH:MM)
LAB5_NAMEvarchar(12)null Lab Result 5 Name
LAB5_VALUEvarchar(8)null Lab Result 5 Value
LAB5_DATEvarchar(8)null Lab Result 5 Date(YYYYMMDD)
LAB5_TIMEvarchar(5)null Lab Result 5 Time(HH:MM)
LAB6_NAMEvarchar(12)null Lab Result 6 Name
LAB6_VALUEvarchar(8)null Lab Result 6 Value
LAB6_DATEvarchar(8)null Lab Result 6 Date(YYYYMMDD)
LAB6_TIMEvarchar(5)null Lab Result 6 Time(HH:MM)
LAB7_NAMEvarchar(12)null Lab Result 7 Name
LAB7_VALUEvarchar(8)null Lab Result 7 Value
LAB7_DATEvarchar(8)null Lab Result 7 Date(YYYYMMDD)
LAB7_TIMEvarchar(5)null Lab Result 7 Time(HH:MM)
LAB8_NAMEvarchar(12)null Lab Result 8 Name
LAB8_VALUEvarchar(8)null Lab Result 8 Value
LAB8_DATEvarchar(8)null Lab Result 8 Date(YYYYMMDD)
LAB8_TIMEvarchar(5)null Lab Result 8 Time(HH:MM)
LAB9_NAMEvarchar(12)null Lab Result 9 Name
LAB9_VALUEvarchar(8)null Lab Result 9 Value
LAB9_DATEvarchar(8)null Lab Result 9 Date(YYYYMMDD)
LAB9_TIMEvarchar(5)null Lab Result 9 Time(HH:MM)
LAB10_NAMEvarchar(12)null Lab Result 10 Name
LAB10_VALUEvarchar(8)null Lab Result 10 Value
LAB10_DATEvarchar(8)null Lab Result 10 Date(YYYYMMDD)
LAB10_TIMEvarchar(5)null Lab Result 10 Time(HH:MM)
LAB11_NAMEvarchar(12)null Lab Result 11 Name
LAB11_VALUEvarchar(8)null Lab Result 11 Value
LAB11_DATEvarchar(8)null Lab Result 11 Date(YYYYMMDD)
LAB11_TIMEvarchar(5)null Lab Result 11 Time(HH:MM)
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