Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientOMOrderLineItem
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientOMOrderLineItemSID | INTEGER | ? | MANDATORY | System Defined - Generated from the OMOrder sequence. |
| PatientOrderSetSID | INTEGER | ? | MANDATORY | FK - PatientOrderSet. |
| OMOrderDefSID | INTEGER | ? | MANDATORY | FK - OMOrderDef |
| Description | CHAR(20) | MANDATORY | System generated description of the Patient Order based on the Order description. | |
| ProcedureCode | CHARACTER(10) | OPTIONAL | FK - ProcedureCode. Procedure code which represents a procedure performed. User entered. | |
| Comments | CHAR(32000) | OPTIONAL | User entered comments regarding the order. | |
| 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. |
| PatientOrderSetResultSID | INTEGER | ? | OPTIONAL | FK to PatientOrderSetResult. This is the result for this order line item. When this field is ? it means that results have not yet been tied up to the order line item. |
| MacroCode | CHARACTER(10) | OPTIONAL | FK - from Macro table. Macro code which represents procedures performed in association with the order. User entered. | |
| AUCStatus | CHARACTER(1) | OPTIONAL | Indicates the Appropriate Use Criteria status. Values are empty, (R)equired, (C)ompleted. | |
| SnomedCode | CHAR(20) | OPTIONAL | Snomed code | |
| ConfidentialityLevel | CHAR(2) | Alpha_-_N | OPTIONAL | The field will hold Confidentiality Level for the OM Orders. |
| LOINCType | CHARACTER(60) | OPTIONAL | OID for the Value Set. OIDs are taken from from National Library of Medicine, Value Set Authority Center - NIH https://vsac.nlm.nih.gov/ | |
| LOINCCode | CHARACTER(10) | OPTIONAL | LOINC Code associated with Order Definition, which is derived from ValueSets: [Clinical Tests] , [LOINC Imaging Document Codes] |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PatientOrderSetResult | PatientOMOrderLineItem.PatientOrderSetResultSID = PatientOrderSetResult.PatientOrderSetResultSID | SET NULL if PatientOMOrderLineItem exists |
| Procedure | PatientOMOrderLineItem.ProcedureCode = Procedure.ProcedureCode | RESTRICT if PatientOMOrderLineItem exists |
| PatientOrderSet | PatientOMOrderLineItem.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | CASCADE if PatientOMOrderLineItem exists |
| Child Table | Join Phrase | When deleting PatientOMOrderLineItem record... |
|---|---|---|
| PatientOMOrderLineItemAUC | PatientOMOrderLineItemAUC.PatientOMOrderLineItemSID = PatientOMOrderLineItem.PatientOMOrderLineItemSID | CASCADE if PatientOMOrderLineItemAUC exists |
| PatientOMOrderLineAttr | PatientOMOrderLineAttr.PatientOMOrderLineItemSID = PatientOMOrderLineItem.PatientOMOrderLineItemSID | CASCADE if PatientOMOrderLineAttr exists |