Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtPoCTemplate Plan of Care Templates assigned to Visit (Patient's Visit)
Column Name Column Datatype Column Null Option Column Comment
PtPoCTemplateOIDintNOT NULL Object ID of the Plan of Care Template
PtPoCCVEIdvarchar(32)NOT NULL Common Vocabulary Engine(CVE) identifier of the Template that has been assigned
DisplayNamevarchar(254)NOT NULL Name of the Template defined in Common Vocabulary Engine(CVE)
LastCngSeqNointNOT NULL Number of times this problem has been changed(Initial creation value will be 1)
Patient_oidintNOT NULL Object ID of the patient(HPatient)
PatientVisit_oidintNOT NULL Object ID of the patient visit(HPatientVisit)
AssignedBy_oidintNOT NULL Object ID of the User who assigned the Plan of Care(HSUser)
AssignedByDateTimesmalldatetimeNOT NULL Date and time(local) when the Template was assigned
AssignedByNamevarchar(188)NOT NULL Name of the User who assigned the Template
StopDatesmalldatetimeNULL Date and time the Plan of Care was stopped
StoppedByNamevarchar(188)NULL DEFAULT Name of the User who stopped the Plan of Care
StoppedBy_oidintNULL Object ID of the User who stopped the Plan of Care(HSUser)
StopReasonCdsmallintNULL Code describing why the Plan of Care was stopped
Allowable Values:
1 - Plan Fulfilled
2 - Plan Discontinued
3 - Plan Added in Error
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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