Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PatientAppointmentOID | int | NOT NULL | Unique ObjectID of each row |
Patient_OID | int | NULL | Patient ObjectID |
PatientVisit_OID | int | NULL | Visit ObjectID |
CreationDTimeMins | smalldatetime | NULL | Creation date time of the row |
SchSystemID | varchar(30) | NULL | ID of Scheduling System taken from MSH segment in S12 Txn |
SchAppointmentID | varchar(30) | NOT NULL | AppointmentID sent from the Scheduling system |
SchApptStatus | varchar(64) | NOT NULL | Indicates the status of Appointment(NotArrived,Arrived,ReadyToBeSeen,Cancelled) |
ScApptStatus | varchar(64) | NULL | This is for the status that the clinician set from the schedule view. |
SchApptStartDTimeMins | smalldatetime | NOT NULL | Appointment Start Date and Time |
SchApptDuration | smallint | NULL | Duration of the Appointment |
SchApptDurationUOM | varchar(20) | NULL | Unit of measure of Appointment duration |
SchLocation_OID | int | NULL | Scheduled Location internal ObjectID of Soarian Clinicals |
SchLocationCode | varchar(30) | NULL | Scheduled Location code sent from Scheduling system |
SchLocationName | varchar(255) | NULL | Scheduled Location Name sent from Scheduling system |
SchDepartment_OID | int | NULL | Scheduled Department(MRU) internal ObjectID of Soarian Clinicals |
SchDepartmentCode | varchar(30) | NULL | Scheduled Department Code sent from Scheduling system |
SchDepartmentName | varchar(255) | NULL | Scheduled Department Name sent from Scheduling system |
SchApptReason | varchar(255) | NULL | Reason for Appointment |
SchNotes | varchar(1024) | NULL | Any notes coming in from the Schedule transactions(NTE-3 segment) |
SchPatientName | varchar(120) | NULL | Used only if patient not yet registered in master ADT system. Formatted according to ADT name preference. |
SchGender | tinyint | NULL | Used only if patient not yet registered in master ADT system. |
SchBirthDate | smalldatetime | NULL | Used only if patient not yet registered in master ADT system. |
ExamRoom | varchar(100) | NULL | Exam room information at the location(updated by front desk) |
Comments | varchar(255) | NULL | Used to store any comments about the appointment(updated by front desk) |
LastCngDTime | datetime | NOT NULL | UTC Date time of when the data is inserted/modified |
|