Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_IMMUNIZ_HISTORY_PATIENT_DEM Immunization History Patient 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
PAT_ADDRESSvarchar(64)null Patient Address
PAT_CITYvarchar(32)null Patient City
PAT_STATEvarchar(2)null Patient State
PAT_ZIPvarchar(12)null Patient Zip Code
PTBIRTHvarchar(10)null Patient Birthdate(MM/DD/YYYY)
PTBIRTH_ORDERvarchar(2)null Patient Birth Order
PTBIRTH_PLACEvarchar(24)null Patient Birth Place
COUNTRY_CODEvarchar(3)null Country Code
COUNTRY_NAMEvarchar(25)null Country Name
COLLECTED_BY_ACCOUNT_NAMEvarchar(12)null Collected By Account Name
COLLECTED_BY_NAMEvarchar(64)null Collected By Name
ETHNIC_GROUPvarchar(50)null Ethnic Group
PAT_EMAILvarchar(60)null Patient Email
ENTERED_BY_ACCOUNT_NAMEvarchar(12)null Entered By Account Name
ENTERED_DATE_TIMEvarchar(12)null Entered Date/Time(YYYYMMDDHHMM)
LOCATIONvarchar(13)null Location(Nurse Station or Clinic)
MULTIPLE_BIRTHvarchar(3)null Multiple Birth?(YES or NO)
MOTHER_MAIDEN_NAMEvarchar(30)null Mother's Maiden Name
PTNAMEvarchar(32)null Patient Name
PTSEXvarchar(1)null Patient Sex. Allowable values: M - Male, F - Female, U - Unknown.
PAT_PHONEvarchar(24)null Patient Phone
PAT_RACEvarchar(50)null Patient Race
PAT_SOC_SECvarchar(11)null Patient Social Security Number
SITEvarchar(2)null Hospital Site
TIDvarchar(3)null Terminal ID
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