Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAppointmentActivity Contains patient appointments activity information.
Column Name Column Datatype Column Null Option Column Comment
PatientAppointment_OIDintNOT NULL ObjectID of the HPatientAppointment table
SchAppointment_IDvarchar(30)NOT NULL AppointmentID sent from the Scheduling system
SchApptStartDTimeMinssmalldatetimeNOT NULL Appointment Start Date Time
SchActivityCodevarchar(30)NOT NULL Activity Code sent from the Scheduling system
SchActivitySetIDvarchar(30)NOT NULL Incremental number valued from 1-n for each Appointment Activity so as to identify in Update/Delete Txns
SchActivityDescvarchar(255)NULL Activity Description sent from the Scheduling system

Return to Table-Index

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