Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HRegStatusHistory Contains registration status history information for the patient visit.
Column Name Column Datatype Column Null Option Column Comment
RegStatusHistoryOIDintNOT NULL Unique ObjectID of each row. Primary key
PatientVisit_OIDintNOT NULL Visit ObjectID related to a RegStatusHistory. Must exist as objectid in HPatientVisit table.
CreationDTimeMinssmalldatetimeNOT NULL Creation date time of the row. System date/time defaulted.
LastCngDtimedatetimeNOT NULL Last system UTC date /time when row was updated.
RegStatusMilestonevarchar(10)NOT NULL Predefined to match Registration Status from HPatientVisit table.
Allowable Values: Quick_Reg - Quick Registration, Full_Reg - Full Registration
MilestoneDTimeMinssmalldatetimeNOT NULL Date and time when patient visit registration status was created or changed.

Return to Table-Index

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