Checkpoint CodeCompletion Required IndPause QtyPriority Seq
| Business Data Model Data Model |
| Description | A relationship between an activity and some criteria to determine if the activity should occur where all activities are part of the global library of activities. For example: Only perform a certain lab test if drug X was administered. (target = another activity) Only perform a substance administration of drug X if the blood pressure was over some threshold number. (target = observation result from another activity that is an observation) Only perform a substance administration of drug Y if the blood pressure was over some threshold number and either the result of a certain lab test was positive or the subject's temperature was elevated, i.e. "(A and (B or C))". The criteria to evaluation the relationship could be one of the following: - The outcome of another activity where the source activity does not occur unless the target activity outcome has occurred - Another activity where the source activity does not occur unless the target activity has occurred - A group of other criteria that may be composed of a mix of other activities, observation results or other groups. To evaluate whether the contingency was satisfied, the simple existence of a Performed Activity (or subclass) related to the Defined Activity (or subclass) is not enough by itself. The Performed Activity Status Code and Performed Activity Negation Indicator must also be checked to ensure that the activity was actually performed. Performed Activity Status Code must be "Completed" and Performed Activity Negation Indicator must not be "true". |
| Attributes | |
| Checkpoint Code |
|
| Completion Required Ind |
|
| Pause Qty |
|
| Priority Seq |
|
| Relationship | |
 Activity Contingency_Prerequisite Activity_FK |
|
| Activity Contingency_Contingent Activity_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Checkpoint Code
| Description | Specifies the points in the course of an activity when a precondition for the activity is evaluated. For example: When the checkpoint code for a criterion of a repeatable activity is "end," the criterion is tested only at the end of each repetition of that activity. When the condition holds true, the next repetition is ready for execution. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Completion Required Ind
| Description | Specifies whether the target activity must have completed before the start of the source activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pause Qty
| Description | The time falling within minimum and maximum bounds that specifies the elapsed time between when an activity is ready for execution and the beginning of the execution. For example: If you take a blood sample 15 minutes after administration of study drug, or if you measure blood glucose two hours after each meal, the pause quantity is 15 minutes and two hours. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Priority Seq
| Description | A number specifying the relative preference for considering this relationship before other like-typed relationships having the same source activity. The ordering may be a total ordering, in which all priority number are unique, or a partial ordering, in which the same priority may be assigned to more than one relationship. Decimal numbers may be used to insert values between existing priority numbers. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Activity Contingency_Prerequisite Activity_FK
| Is Identifying Relationship | true |
| Child Table | Activity Contingency |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Activity |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Activity Contingency_Contingent Activity_FK
| Is Identifying Relationship | true |
| Child Table | Activity Contingency |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Activity |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |