Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHCDT Pharmacy Cumulative Dose Tracking (CDT)
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
CDTvarchar(12)not null CDT(Cumulative Dose Tracking) Code(Link to PHCDTBL.CDT_CODE)
PAT_NUMvarchar(12)not null Patient Number
TRANS_DATEvarchar(8)not null Transaction Date(YYYYMMDD)
SEQvarchar(4)not null Sequence Number
DOSEvarchar(47)null Dose(Normalized Dose) - this should be the dose dispensed.
BSAvarchar(8)null Body Surface Area
PAT_HEIGHT_CMvarchar(12)null Patient Height in Centimeters
PAT_WEIGHT_KGvarchar(12)null Patient Weight in Kilograms
PMPvarchar(6)null Pharmacy Order Number
FCTvarchar(3)null Function which posted this transaction
INITIALSvarchar(6)null Initials
ENTERED_DATEvarchar(8)null Entered Date(YYYYMMDD)
ACCUMULATED_DOSEvarchar(12)null This is what the system calculated as the patient's cumulative dose of this CDT after this dose was administered AT THE TIME the transaction was logged.
DRUG_NAMEvarchar(30)null Drug Name
DRUG_CODEvarchar(5)null Drug Code
COMMENTSvarchar(60)null Comments
SITEvarchar(2)null Hospital Site
PTNAMEvarchar(32)null Patient Name
PTBIRTHvarchar(8)null Patient Date of Birth(YYYYMMDD)
PTAGEvarchar(4)null Patient Age
ATTDOCNUvarchar(6)null Patient Attending Doctor Number
ATTDOCNAvarchar(32)null Patient Attending Doctor Name
ORD_DRNOvarchar(6)null Ordering Doctor Number
ORD_DRNAMEvarchar(32)null Ordering Doctor Name
SIGvarchar(15)null SIG(Latin Directions Abbreviation)
ROUTEvarchar(10)null Route of Administration
IV_METHOD_CODEvarchar(2)null IV Method Code(0 to 10). See Pharmacy Method Masterfile PHM_METHOD_MF
IV_METHODvarchar(6)null IV Method Abbreviation(Ex: PUSH,LVP,TPN,...). See Pharmacy Method Masterfile PHM_METHOD_MF
PTAGE_IN_DAYSFLOATnull Patient Age Displayed in Number of Days
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