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 |
SchActivityCode | varchar(30) | NOT NULL | Activity Code sent from the Scheduling system |
SchActivitySetID | varchar(30) | NOT NULL | Incremental number valued from 1-n for each Appointment Activity so as to identify in Update/Delete Txns |
SchActivityDesc | varchar(255) | NULL | Activity Description sent from the Scheduling system |
|