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

Intergy Version: 22.00.00.00

LabOrderActivity

Table Definition  Parent Tables  Child Tables

Table Definition

Description:

Field Datatype Default Null Option Comment
LabOrderSID INTEGER ?   MANDATORY FK - From LabOrder
ActivityCount INTEGER 0   MANDATORY System generated activity count. It serves to uniquely identify an activity.
ActivityClass CHAR(20) ?   OPTIONAL Indicates action taken to create the activity
Note CHAR(28000) ?   OPTIONAL Annotates lab order activity
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...
LabOrder LabOrderActivity.LabOrderSID = LabOrder.LabOrderSID CASCADE if LabOrderActivity exists

Child Tables
Child TableJoin PhraseWhen deleting LabOrderActivity record...