Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientOrderSetResult
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientOrderSetResultSID | INTEGER | ? | MANDATORY | System Defined. Based on the OMOrder sequence. Uniquely identies a result. |
| ResultType | CHARACTER | OPTIONAL | Indicates the result type associated to the order. Possible values: (T)ext, (I)mage, (D)ocument, (L)abResult, (C)ardio | |
| LabOrderSID | INTEGER | ? | OPTIONAL | FK to Lab Order. This lab order contains the results for this order. |
| DocumentSID | INTEGER | ? | OPTIONAL | FK to Document. If the result is an image, this is where it comes from. |
| CatalogSID | INTEGER | ? | OPTIONAL | System generated document identifier. The identifier value is obtained from the DOCUMENT sequence. |
| IsAbnormal | LOGICAL | ? | OPTIONAL | Indicates if there are any abnormal results for the Order set. Possible values: (Y)es, (N)o and ?(Null). |
| ResultedStamp | CHAR(14) | OPTIONAL | Timestamp of when the Order set was resulted. | |
| ResultedUser | INTEGER | OPTIONAL | User id of the user that resulted the Order set. | |
| Comments | CHAR(32000) | OPTIONAL | User entered result comments. If the result type is 'Text' this field should contain the actual text comments. | |
| 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. |
| PatientOrderSetSID | INTEGER | ? | OPTIONAL | FK to PatientOrderSet |
| TextReferenceDate | DATE | OPTIONAL | Reference date for the (T)ext results. This field is valid only when ResultType = (T)ext. Reference date for the document. | |
| CardioOrderSID | INTEGER | ? | OPTIONAL | System-defined. System generated unique id using the "CardioOrder" sequence. |
| LOINCCode | CHAR(50) | OPTIONAL | LOINC Code that is associated with this PatientOrderSetResult. | |
| PracPersonSecureMessageSID | INTEGER | ? | OPTIONAL | FK to PracPersonSecureMessage table, if the result is a Secure Message. |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PracPersonSecureMessage | PatientOrderSetResult.PracPersonSecureMessageSID = PracPersonSecureMessage.PracPersonSecureMessageSID | RESTRICT if PatientOrderSetResult exists |
| CardioOrder | PatientOrderSetResult.CardioOrderSID = CardioOrder.CardioOrderSID | RESTRICT if PatientOrderSetResult exists |
| PatientOrderSet | PatientOrderSetResult.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | CASCADE if PatientOrderSetResult exists |
| TMSCatalog | PatientOrderSetResult.CatalogSID = TMSCatalog.CatalogSID | RESTRICT if PatientOrderSetResult exists |
| Document | PatientOrderSetResult.DocumentSID = Document.DocumentSID | RESTRICT if PatientOrderSetResult exists |
| LabOrder | PatientOrderSetResult.LabOrderSID = LabOrder.LabOrderSID | CASCADE if PatientOrderSetResult exists |
| Child Table | Join Phrase | When deleting PatientOrderSetResult record... |
|---|---|---|
| PatientOMOrderLineItem | PatientOMOrderLineItem.PatientOrderSetResultSID = PatientOrderSetResult.PatientOrderSetResultSID | SET NULL if PatientOMOrderLineItem exists |