Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtPoCReview Patient's Plan of Care Review records
Column Name Column Datatype Column Null Option Column Comment
PtPoCReviewOIDintNOT NULL Object ID of a Plan of Care Review
ReviewByOIDintNOT NULL Object ID of the User who reviewed a Patient's Plan of Care(HSUser)
ReviewByNamevarchar(188)NOT NULL Name of the User reviewing a Patient's Plan of Care
PatientOIDintNOT NULL Object ID of the Patient the Plan of Care was reviewed for(HPatient)
PatientVisitOIDintNOT NULL Object ID of the Patient Visit the Plan of Care was reviewed for(HPatientVisit)
ReviewDateTimesmalldatetimeNOT NULL Date and time(Local) the Plan of Care was reviewed
CreationDateTimesmalldatetimeNOT NULL Date and time(Local) the Review record was originally created
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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