Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHCLIN_DIAG_CODED Clinical Patient Diagnosis Coded
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
ICD9_CODEvarchar(8)not null ICD9(International Classification of Diseases, Ninth Revision ) Code(Link to PHM_ICD9_CODES.ICD9_CM)
CODE_AS_RECEIVED_OR_ENTEREDvarchar(8)null ICD9(International Classification of Diseases, Ninth Revision Code) Code as Received or Entered.(Link to PHM_ICD9_CODES.ICD9_CM)
CONDITION_DESCRIPTIONvarchar(80)null Condition Description
CONDITION_ONSET_DATTIMvarchar(30)null Condition Onset Date/Time(YYYYMMDDHHMM or Free Text)
CONDITION_RESOLUTION_DATTIMvarchar(12)null Condition Resolution Date/Time(YYYYMMDDHHMM)
DATTIM_ENTEREDvarchar(12)null Date/Time Entered(YYYYMMDDHHMM)
CONDITION_STATUSvarchar(15)null Condition Status(NOT REVIEWED, REVIEWED, INACTIVE, ERRONEOUS, UNKNOWN)
MERGE_COMMENTvarchar(80)null Merge Comment
DIAGNOSIS_AS_RECEIVEDvarchar(80)null Diagnosis as Received
ONGOING_COND_INDICATORvarchar(20)null Ongoing Condition Indicator(ADMISSION SPECIFIC, ONGOING CONDITION, UNKNOWN)
PAT_NUMvarchar(12)null Patient Number
ENTER_USER_IDvarchar(12)null Enter User 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