Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_SPEC_ATTENTION_CODED Special Attentions Coded
Column Name Column Datatype Column Null Option Column Comment
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PROJECT_IDvarchar(3)not null Project Id
SEQvarchar(12)not null Sequence Number
SPEC_ATTENTION_CODEvarchar(10)null Special Attention Code.(Link to PHM_SPEC_ATTENTION_CODE_MASTER.SPEC_ATTENTION_CODE)
SPEC_ATTENTION_CODE_DESCvarchar(64)null Special Attention Code Short Description
USER_INITIALSvarchar(6)null User Initials of Person who entered Special Attention data
ENTERED_DATEvarchar(8)null Entered Date(YYYYMMDD)
ENTERED_TIMEvarchar(5)null Entered 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