Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAppointmentResource Contains patient appointment resource 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
SchResourceTypevarchar(30)NOT NULL Type of Resource sent from Soarian Scheduling(Staff,Equipment etc.)
SchResourceCodevarchar(30)NULL Staff Identifier sent in the Schedule transactions and which matches with HStaffIdentifier's IDType = 'SCHRES'
SchResourceSetIDvarchar(30)NULL Incremental number valued from 1-n for each Appointment Resource so as to identify in Update/Delete Txns
Staff_OIDintNULL ObjectID of the Staff row associated with the appoitment
SchIsPrimaryResourcetinyintNULL Indicates which resource is sent first in the Txn(1-yes, 0-No)

Return to Table-Index

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