Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CLIN_INTERVS_DEM Pharmacy Clinical Interventions Patient Demographic Data
Column Name Column Datatype Column Null Option Column Comment
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PAT_NUMvarchar(12)null Patient Number
PTNAMEvarchar(32)null Patient Name
PT_NRSTAvarchar(6)null Nurse Station(For EHI-EXPORT, for values please refer to Soarian Clinical's table HHealthCareUnit; columns HealthCareUnitName or Abbreviation.)
BED_CODEvarchar(6)null Bed
PTAGEvarchar(6)null Patient Age
PTBIRTHvarchar(10)null Patient Date of Birth(MM/DD/YYYY)
PTSEXvarchar(1)null Patient Sex
PT_HEADER_DOC_NAvarchar(30)null Patient Header Doctor Name
HEIGHTvarchar(32)null Patient Height
WEIGHTvarchar(32)null Patient Weight
PTTYPEvarchar(1)null Patient Type(Link to PTM.PTTYPE)
PTSERVvarchar(3)null Patient Service(For EHI-EXPORT, for values please refer to Soarian Clinical's table HHealthCareUnit; columns HealthCareUnitName or Abbreviation.)
PTAGE_IN_DAYSFLOATnull Patient Age Displayed in Number of Days
PERSON_NUMBERvarchar(16)null Identifies a Patient uniquely across multiple sites for a single enterprise
PTMEDRECvarchar(16)null Medical Record 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