Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_IMMUNIZ_HISTORY_NEXTOFKIN_DEM Immunization History Next of Kin Demographics
Column Name Column Datatype Column Null Option Column Comment
PERSON_NUMBERvarchar(16)not null Identifies a Patient uniquely across multiple sites for a single enterprise
NEXTOFKIN_NAMEvarchar(32)null Next of Kin Name
RELATIONSHIP_CODEvarchar(3)null Relationship Code
RELATIONSHIP_NAMEvarchar(25)null Relationship Name
NEXTOFKIN_ADDRESSvarchar(64)null Next of Kin Address
NEXTOFKIN_CITYvarchar(32)null Next of Kin City
NEXTOFKIN_STATEvarchar(2)null Next of Kin State
NEXTOFKIN_ZIPvarchar(12)null Next of Kin Zip Code
COUNTRY_CODEvarchar(3)null Country Code
COUNTRY_NAMEvarchar(25)null Country Name
NEXTOFKIN_PHONEvarchar(24)null Next of Kin Phone
NEXTOFKIN_LANGUAGEvarchar(17)null Next of Kin Language
NEXTOFKIN_EMAILvarchar(60)null Next of Kin Email
COLLECTED_BY_ACCOUNT_NAMEvarchar(12)null Collected By Account Name
COLLECTED_BY_NAMEvarchar(64)null Collected By Name
ENTERED_BY_ACCOUNT_NAMEvarchar(12)null Entered By Account Name
ENTERED_DATE_TIMEvarchar(12)null Entered Date/Time(YYYYMMDDHHMM)
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