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

Intergy Version: 22.00.00.00

OBPregnancyActivity

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table contains activity records about a specific OB Pregnancy record.

Field Datatype Default Null Option Comment
OBPregnancyActivitySID INTEGER ?   MANDATORY System generated unique id using the OB Chart sequence.
ClinicalCaseSID INTEGER ?   MANDATORY System generated unique for the records on this table.
ActivityType CHAR(30)   MANDATORY System defined. Field is supported by the lookup types:[OBPregnancyActivity]. Values are defined in the LookupCode table for the above lookup types.
ActivityDetails CHAR(5000)   OPTIONAL This field will contain additional details of the activity that has taken place for the given OB Pregnancy.
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...
OBPregnancy OBPregnancyActivity.ClinicalCaseSID = OBPregnancy.ClinicalCaseSID CASCADE if OBPregnancyActivity exists

Child Tables
Child TableJoin PhraseWhen deleting OBPregnancyActivity record...