Repetition NumScheduled Activity End DateScheduled Activity Start Date
| Business Data Model Data Model |
| Description | An activity that is anticipated to occur at some time in the future and has been assigned a time or date when that activity is to be performed. For example: An X-Ray scheduled for February 15 is in state "Scheduled." If John is unable to have the X-Ray on that date, the X-Ray would either be rescheduled (remain in "Scheduled" state, but "date" attribute would change) or moved to state "Canceled." |
| Attributes | |
| Repetition Num |
|
| Scheduled Activity End Date |
|
| Scheduled Activity Start Date |
|
| Relationship | |
 instantiatedScheduledActivity |
|
| instantiatingScheduledActivity |
|
| Generalization | |
 R_1307 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Repetition Num
| Description | An integer that identifies the occurrence of a repeating activity. The first repetition is defined as '1'. For example: A planned activity can have a repeat quantity of 4, which results in four scheduled activities with repetition numbers 1, 2, 3, and 4. |
| 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 |
Scheduled Activity End Date
| Description | The expected end date of the scheduled activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Scheduled Activity Start Date
| Description | The expected start date of the scheduled activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
instantiatedScheduledActivity
| Description | |
| Is Identifying Relationship | false |
| Child Table | Scheduled Activity |
| Child Role Name | instantiatingPerformedActivity |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | SET_NULL |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | SET_NULL |
| Parent Table | Performed Activity |
| Parent Role Name | instantiatedScheduledActivity |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | SET_NULL |
| Parent Referential Integrity: On Update | SET_NULL |
instantiatingScheduledActivity
| Description | |
| Is Identifying Relationship | false |
| Child Table | Scheduled Activity |
| Child Role Name | instantiatedPlannedActivity |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | RESTRICT |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | RESTRICT |
| Parent Table | Planned Activity |
| Parent Role Name | instantiatingScheduledActivity |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | RESTRICT |
| Parent Referential Integrity: On Update | RESTRICT |
| Generalization Details |
R_1307
| Supertype | Activity |
| Subtype | Scheduled Activity |
| Transform As | TABLE |
| Business Data Model Data Model |