Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtProblem__PatientVisit Problems associated to a Patient Visit
Column Name Column Datatype Column Null Option Column Comment
PtProblemPatientVisitOIDintNOT NULL Object ID of the Patient Visit a Problem is associated with(HPatientVisit)
PatientVisitNamevarchar(254)NOT NULL Indicates the patient visit name combination of healthcare unit and date/time.
ChangeDateTimesmalldatetimeNOT NULL Date and time(local) the Problem association to a Visit was Inserted / Changed
ChangedByNamevarchar(188)NOT NULL Name of the User that Inserted / Changed the Problem
ChangedBy_oidintNOT NULL Object ID of the User who Inserted / Changed the Problem(HSUser)
LastCngSeqNointNOT NULL Number of times this problem has been changed(Initial creation value will be 1). Used for Optimistic locking
PatientVisit_oidintNOT NULL Object ID of the Patient Visit a problem is associated with(HPatientVisit)
PtProblem_oidintNOT NULL Object ID of the Problem associated with a Patient(HPtProblem)
IsTreatingComplaintsmallintNOT NULL Problem is marked as a treating complaint for the visit
Allowable Values:
1 - yes
0 - no
IsPrimaryTreatingComplaintsmallintNOT NULL Problem is marked as a primary treating complaint for the visit
Allowable Values:
1 - yes
0 - no
IsDispositionDiagnosissmallintNOT NULL Problem is marked as a disposition diagnosis for the visit
Allowable Values:
1 - yes
0 - no
LastCngDtimedatetimeNOT NULL Last date and time the Problem / Visit association was Inserted or Changed(UTC)

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates