Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PatientAppointment_OID | int | NOT NULL | ObjectID of the HPatientAppointment table |
SchAppointment_ID | varchar(30) | NOT NULL | AppointmentID sent from the Scheduling system |
SchApptStartDTimeMins | smalldatetime | NOT NULL | Appointment Start Date Time |
SchResourceType | varchar(30) | NOT NULL | Type of Resource sent from Soarian Scheduling(Staff,Equipment etc.) |
SchResourceCode | varchar(30) | NULL | Staff Identifier sent in the Schedule transactions and which matches with HStaffIdentifier's IDType = 'SCHRES' |
SchResourceSetID | varchar(30) | NULL | Incremental number valued from 1-n for each Appointment Resource so as to identify in Update/Delete Txns |
Staff_OID | int | NULL | ObjectID of the Staff row associated with the appoitment |
SchIsPrimaryResource | tinyint | NULL | Indicates which resource is sent first in the Txn(1-yes, 0-No) |