Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientAppointment Contains patient appointments information.
Column Name Column Datatype Column Null Option Column Comment
PatientAppointmentOIDintNOT NULL Unique ObjectID of each row
Patient_OIDintNULL Patient ObjectID
PatientVisit_OIDintNULL Visit ObjectID
CreationDTimeMinssmalldatetimeNULL Creation date time of the row
SchSystemIDvarchar(30)NULL ID of Scheduling System taken from MSH segment in S12 Txn
SchAppointmentIDvarchar(30)NOT NULL AppointmentID sent from the Scheduling system
SchApptStatusvarchar(64)NOT NULL Indicates the status of Appointment(NotArrived,Arrived,ReadyToBeSeen,Cancelled)
ScApptStatusvarchar(64)NULL This is for the status that the clinician set from the schedule view.
SchApptStartDTimeMinssmalldatetimeNOT NULL Appointment Start Date and Time
SchApptDurationsmallintNULL Duration of the Appointment
SchApptDurationUOMvarchar(20)NULL Unit of measure of Appointment duration
SchLocation_OIDintNULL Scheduled Location internal ObjectID of Soarian Clinicals
SchLocationCodevarchar(30)NULL Scheduled Location code sent from Scheduling system
SchLocationNamevarchar(255)NULL Scheduled Location Name sent from Scheduling system
SchDepartment_OIDintNULL Scheduled Department(MRU) internal ObjectID of Soarian Clinicals
SchDepartmentCodevarchar(30)NULL Scheduled Department Code sent from Scheduling system
SchDepartmentNamevarchar(255)NULL Scheduled Department Name sent from Scheduling system
SchApptReasonvarchar(255)NULL Reason for Appointment
SchNotesvarchar(1024)NULL Any notes coming in from the Schedule transactions(NTE-3 segment)
SchPatientNamevarchar(120)NULL Used only if patient not yet registered in master ADT system. Formatted according to ADT name preference.
SchGendertinyintNULL Used only if patient not yet registered in master ADT system.
SchBirthDatesmalldatetimeNULL Used only if patient not yet registered in master ADT system.
ExamRoomvarchar(100)NULL Exam room information at the location(updated by front desk)
Commentsvarchar(255)NULL Used to store any comments about the appointment(updated by front desk)
LastCngDTimedatetimeNOT NULL UTC Date time of when the data is inserted/modified

Return to Table-Index

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