Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_IMMUNIZ_HISTORY Immunization History
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_NUMvarchar(12)not null Patient Number
CVX_CODEvarchar(6)not null CVX(Vaccine Administered) Code.(Link to PHM_CVXCODES_MASTER.CVX_CODE)
SEQvarchar(12)not null Sequence Number
PMPvarchar(5)null Pharmacy Order Number
VACCINEvarchar(80)null Vaccine
DOSEvarchar(120)null Dose
CHARTED_DATE_TIMEvarchar(18)null Charted Date/Time. Value could be MM/YYYY, MM/DD/YYYY, or MM/DD/YYYY HH:MM, or MM/DD/YYYY HH:MMxx
CHARTED_BY_INITIALSvarchar(6)null Charted By Initials
CHARTED_BY_NAMEvarchar(32)null Charted By Name
ROUTE_CODEvarchar(10)null Route Code
ROUTE_CODE_DESCvarchar(18)null Route Code Description
DR_NOvarchar(6)null Doctor Number
DR_NAMEvarchar(23)null Doctor Name
DR_NPIvarchar(10)null Doctor NPI(National Provider Identifier)
ADMIN_SITE_CODEvarchar(12)null Admin Site Code
ADMIN_SITE_CODE_DESCvarchar(32)null Admin Site Code Description
LOT_NUMBERvarchar(30)null Lot Number
MFG_CODEvarchar(6)null Manufacturer Code
MFG_CODE_DESCvarchar(30)null Manufacturer Code Description
EXP_DATEvarchar(10)null Expiration Date(MM/YYYY or MM/DD/YYYY)
ADMIN_NOvarchar(3)null Admin Number
VACCINE_INFO_CODEvarchar(3)null Vaccine Information Code
VACCINE_INFO_STATEMENTvarchar(40)null Vaccine Information Statement
VACCINE_INFO_PUB_DATEvarchar(10)null Vaccine Information Publication Date(MM/DD/YYYY)
VACCINE_ELIGIBILITY_CODEvarchar(3)null Vaccine Eligibility Code
VACCINE_ELIGIBILITY_CODE_DESCvarchar(65)null Vaccine Eligibility Code Description
NOT_GIVE_TYPEvarchar(12)null Not Given Type(Refused or Immune)
REFU_OR_IMMU_RSN_CODEvarchar(9)null Refused or Immune Reason Code
REFU_OR_IMMU_RSN_CODE_DESCvarchar(69)null Refused or Immune Reason Code Description
NOTESvarchar(180)null Notes
SOURCE_CODEvarchar(2)null Source Code
SOURCE_CODE_DESCvarchar(65)null Source Code Description
OCCURRENCE_DATTIMvarchar(12)null Occurrence Date/Time(YYYYMMDDHHMM)
STATUSvarchar(12)null Status
ENTER_BY_INITIALSvarchar(6)null Enter By Initials
ENTER_BY_NAMEvarchar(32)null Enter By Name
ENTERED_DATTIMvarchar(12)null Entered Date/Time(YYYYMMDDHHMM)
ITNvarchar(12)null Internal Number used to create a Unique Key for Active Patient Files
IMRvarchar(16)null Internal Number used to create a Unique Key for Historical Files
NDC_NUMBERvarchar(14)null NDC(National Drug Code) Number
BRAND_NAMEvarchar(30)null Brand Name of Drug
GENERIC_NAMEvarchar(30)null Generic Name of Drug
PRIMARY_NAME_INDvarchar(8)null Primary Name Indicator. Indicates whether or not the Primary Name is Brand or Generic.(0=Generic, 1=Brand)
DATA_SOURCEvarchar(512)null Source of Data
DATA_SOURCE_AUTHORvarchar(512)null Data Source Author
DATA_SOURCE_TITLEvarchar(512)null Data Source Title
EXTERNAL_SYSTEMvarchar(3)null External System(AIS or IIS)
RECONCILE_STATEvarchar(16)null Reconcile State(Rejected or Accepted)
RECONCILE_DATE_TIMEvarchar(18)null Reconcile Date/Time(MM/DD/YYYY HH:MM, or MM/DD/YYYY HH:MMxx)
RECONCILE_BY_INITIALSvarchar(6)null Reconcile By Initials
RECONCILE_BY_NAMEvarchar(32)null Reconcile By Name
NCIT_ROUTE_CODEvarchar(6)null NCIT(National Cancer Institute Thesaurus) Route Code
NCIT_ROUTE_CODE_DESCvarchar(30)null NCIT(National Cancer Institute Thesaurus) Route Code Description
VACCINE_INFO_BARCODEvarchar(24)null Vaccine Information Barcode
FUNDING_SOURCE_CODEvarchar(6)null Funding Source Code
FUNDING_SOURCE_CODE_DESCvarchar(30)null Funding Source Code Description
POPULATION_GROUP_CODEVARCHAR(15)NULL Population Group code
POPULATION_GROUP_CODE_DESCVARCHAR(45)NULL Population Group code Description
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