Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHHST_ORDERS_NOTES Pharmacy Historical Patient Order Notes
Column Name Column Datatype Column Null Option Column Comment
IMRvarchar(12)not null Internal Number used to create a Unique Key for Historical Files
PAT_NUMvarchar(12)not null Patient Number
NOTE_NUMBERvarchar(3)not null Note number
LINE_NUMBERvarchar(3)not null Line Number
NOTE_IDvarchar(10)null Note ID
ENTERED_BYvarchar(6)null Entered By
ENTERED_DATEvarchar(10)null Entered Date(MM/DD/YYYY)
ENTERED_TIMEvarchar(7)null Entered Time(HH:MM)
NOTE_TEXTvarchar(80)null Note Text
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