Action Plan Step CntrAction Plan Step Complete DateAction Plan Step NameAction Plan Step Start DateAction Plan Step StatusAction Plan Step Status ReasonAction Plan Step Target Complete DateStatus Ts
| Business Data Model Data Model |
| Description | The specific target an organization must meet within an action plan to bring one component of their business back into compliance relative to one or more goals. |
| Relationship | |
 Action Plan Step_Action Plan_FK |
|
| Action Plan Step_User_FK |
|
| Action Plan Step_Organization_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Action Plan Step Cntr
| Description | The numeric identifier for a step within an Action Plan. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Action Plan Step Complete Date
| Description | The date upon which the organization determines that the specific target or step within an action plan has been met. |
| 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 |
Action Plan Step Name
| Description | The text description of a step within an action plan. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Action Plan Step Start Date
| Description | The date upon which a specific target or step within an action plan has commenced. |
| 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 |
Action Plan Step Status
| Description | The state of the action plan step in the lifecycle of its management for this set of goals. For example: Proposed Approved Complete |
| 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 |
Action Plan Step Status Reason
| Description | Indicates the reason for the current Action Plan Step Status. |
| 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 |
Action Plan Step Target Complete Date
| Description | The date upon which the organization determines the action plan step must be completed. |
| 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 |
Status Ts
| Description | The date and time upon which the Action Plan Step Status and Action Plan Step Status Reason were established. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Action Plan Step_Action Plan_FK
| Is Identifying Relationship | false |
| Child Table | Action Plan Step |
| Child Role Name | has steps |
| 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 | Action Plan |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Action Plan Step_User_FK
| Is Identifying Relationship | false |
| Child Table | Action Plan Step |
| Child Role Name | is focus of |
| 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 | User |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Action Plan Step_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Action Plan Step |
| Child Role Name | measured by |
| 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 | Organization |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |