Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

PatientOMOrderLineItemAUC

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table records the AUC fields entered for an order.

Field Datatype Default Null Option Comment
PatientOMOrderLineItemSID INTEGER ?   MANDATORY System Defined - Generated from the OMOrder sequence.
AppropriatenessScore INTEGER 0   OPTIONAL Appropriateness Score
GCode CHAR(10)   OPTIONAL G Code
Modifier CHAR(2)   OPTIONAL Modifier
SessionID CHAR(50)   OPTIONAL Session ID
ConsultationMethod CHAR(1)   OPTIONAL The method of the consultation. Possible values: 'M' - input manually, 'A' - API.
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.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
PatientOMOrderLineItem PatientOMOrderLineItemAUC.PatientOMOrderLineItemSID = PatientOMOrderLineItem.PatientOMOrderLineItemSID CASCADE if PatientOMOrderLineItemAUC exists

Child Tables
Child TableJoin PhraseWhen deleting PatientOMOrderLineItemAUC record...