Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
OrderOID | int | NOT NULL | Internal Order Identifier. ObjectID of Order(HOrder table) |
VisitOID | int | NULL | Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table) |
PatientOID | int | NOT NULL | Internal Patient Identifier. ObjectID of Patient(HPatient table) |
RecOrderType | tinyint | NOT NULL | What type of recurring order is this |
| | | Allowable Values: |
| | | 1 - Open Ended Recurring Order |
| | | 2 - Duration based or explicit stop date Recurring order. |
GenOccCount | int | NOT NULL | Number of occurrences already generated for the order |
LastOccStDtTime | smalldatetime | NULL | Planned DateTime of the Last generated Occurrence |
NextGenOccStDtTime | smalldatetime | NOT NULL | Planned DateTime for the next occurrence to be generated |
RevisedDateTime | smalldatetime | NULL | DateTime when this entry got modified. |
Status | tinyint | NOT NULL | Status till when the record will qualify for occurrence generation |
| | | Allowable Values: |
| | | 0 - Active |
| | | 1 - Inactive |