Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientOMOrderSet
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientOrderSetSID | INTEGER | ? | MANDATORY | System-defined. System generated unique id using the "OMOrder" sequence. |
| OMOrderGroupSID | INTEGER | ? | MANDATORY | FK - OMOrderGroup. Patient Orders maybe OMOrders. In which case, a PatientOMOrderSet record will exist for the PatientOrderSet. The OMOrderGroupSID indicates which OMOrderGroup this Order Set is for. |
| PostChargesOnAction | CHARACTER(1) | OPTIONAL | Indicates the order is in the specified status that the charges should be posted. Possible values: (O)rdered, re(S)ulted, re(V)iewed | |
| DiagnosisCode | CHARACTER(10) | OPTIONAL | FK - Diagnosis. This is the diagnosis code for the PatientOMOrderSet. | |
| ServiceCenterID | INTEGER | ? | OPTIONAL | FK - ServiceCenter. In general, this indicates where the order will be sent to or performed at. |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| ChargesPostedStamp | CHARACTER(14) | OPTIONAL | When this field is set, we do not need to auto-post charges for this order. When a user creates a order, charges may be defaulted into the shopping chart. If charges are defaulted into the shopping chart, this stamp should be set. (The user may choose to delete this charge and not post them.. but this flag will still be set). If the order is set to post charge when results are added to an order, or when all of the results are approved, then this field should be set at the time the charges were posted. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| ServiceCenter | PatientOMOrderSet.ServiceCenterID = ServiceCenter.ServiceCenterID | SET NULL if PatientOMOrderSet exists |
| Diagnosis | PatientOMOrderSet.DiagnosisCode = Diagnosis.DiagnosisCode | SET NULL if PatientOMOrderSet exists |
| PatientOrderSet | PatientOMOrderSet.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | CASCADE if PatientOMOrderSet exists |
| Child Table | Join Phrase | When deleting PatientOMOrderSet record... |
|---|