Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_EDM_DOCUMENT_ID EDM (Enterprise Document Management) Document ID
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
EDM_VERSIONvarchar(1)null EDM(Enterprise Document Management) Version
EDM_OBJECT_TYPEvarchar(1)null EDM(Enterprise Document Management) Object Type
EDM_DB_IDvarchar(4)null EDM(Enterprise Document Management) Database Id
EDM_USER_IDvarchar(20)null EDM(Enterprise Document Management) User Id
RECEIVED_DATE_TIMEvarchar(12)null Received Date/Time(YYYYMMDDHHMM)
DOCUMENT_STATUSvarchar(1)null Document Status(0 = HOLD, 1 = INCOMPLETE, 2 = COMPLETE)
DOCUMENT_STATUS_DESCvarchar(12)null Document Status Description
STATvarchar(3)null Stat?(YES or NO)
EDM_DOCUMENT_NAMEvarchar(30)null EDM(Enterprise Document Management) Document Name
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