Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_EDM_DOCUMENT_ID_ACTIONS EDM (Enterprise Document Management) Document ID Link to Orders
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
EDM_DOCUMENT_IDvarchar(64)not null EDM(Enterprise Document Management) Document ID
SEQFLOATnot null Sequence Number
FUNCTIONvarchar(8)null Function Code(Link to TRANFUNCTION_MASTER.FUNCTION)
ITN_ACTIONvarchar(12)null ITN Action
PMPvarchar(5)null Pharmacy Order Number
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