Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CLIN_INTERVS Pharmacy Active Patient Clinical Interventions
Column Name Column Datatype Column Null Option Column Comment
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
ITNvarchar(12)not null Internal Number used to create a Unique Key for Active Patient Files
PMPvarchar(5)not null Pharmacy Order Number
INTERVENTION_NOvarchar(6)not null Intervention Number
CURRENT_INTERVENvarchar(3)not null Current Intervention
PAT_NUMvarchar(12)null Patient Number
PERSON_NUMBERvarchar(16)null Identifies a Patient uniquely across multiple sites for a single enterprise
PTMEDRECvarchar(12)null Medical Record Number
STATUSvarchar(1)null Status
ENTRY_DATEvarchar(8)null Entry Date(YYYYMMDD)
ENTRY_TIMEvarchar(5)null Entry Time(HHMM)
INITIALSvarchar(6)null Initials
DRUG_CODEvarchar(5)null Drug Code
GENERIC_NAMEvarchar(30)null Generic Name of Drug
PROBLEM_1varchar(6)null Problem 1 Code
PROBLEM_1_DESCvarchar(30)null Problem 1 Description
PROBLEM_CHARGEvarchar(8)null Problem Charge
FUTUREvarchar(6)null Future Use
CLIN_SIGNIF_1varchar(6)null Clinical Significance 1 Code
CLIN_SIGNIF_1_DESCvarchar(30)null Clinical Significance 1 Description
ACTION_1varchar(6)null Action 1 Code
ACTION_1_DESCvarchar(30)null Action 1 Description
ACTION_2varchar(6)null Action 2 Code
ACTION_2_DESCvarchar(30)null Action 2 Description
ACTION_3varchar(6)null Action 3 Code
ACTION_3_DESCvarchar(30)null Action 3 Description
DR_NUMvarchar(6)null Doctor Number
CONTACTvarchar(30)null Contact
INTERVENTION_1varchar(6)null Intervention 1 Code
INTERVENTION1_DESCvarchar(30)null Intervention 1 Description
ACCEPT_1varchar(6)null Acceptance 1 Code
ACCEPT_1_DESCvarchar(30)null Acceptance 1 Description
OUTCOME_1varchar(6)null Outcome 1 Code
OUTCOME_1_DESCvarchar(30)null Outcome 1 Description
COMMENT_1varchar(65)null Comment 1
COMMENT_2varchar(65)null Comment 2
COMMENT_3varchar(65)null Comment 3
USER_FLD_1varchar(65)null User Field 1
USER_FLD_2varchar(65)null User Field 2
USER_FLD_3varchar(65)null User Field 3
USER_FLD_4varchar(65)null User Field 4
REVIEW_DATEvarchar(8)null Review Date(YYYYMMDD)
DIAGNOSIS_1varchar(64)null Diagnosis 1
DIAGNOSIS_2varchar(64)null Diagnosis 2
TRANS_APPvarchar(8)null App which generated Transaction
OWNER_APPvarchar(8)null App which owns intervention(Pharmacy or MAK)
APP_ACCESSvarchar(6)null Access to this intervention granted to the other applications(None, View, Update)
NRS_VERIFICATIONvarchar(3)null Nurse Verification?(YES or NO)
USERNAMEvarchar(64)null Username
SITEvarchar(2)null Hospital Site
NDC_NUMBERvarchar(14)null NDC(National Drug Code) Number
REVISEDvarchar(1)null Revised?(R = YES, Null = No)
IN_HISTORICvarchar(3)null Is this record in the Historical Patient Clinical Interventions Table(PHHST_CLIN_INTERVS) Also?(YES or NO)
GENERIC_NAME_TM_FLAGvarchar(3)null Generic Name Tall Man Flag(YES or NO)
GCSFLOATnull GCS(Generic Code Sequence Number)
GENERIC_NAME_TMvarchar(30)null Generic Name of Drug in Tall Man Format
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