Actual End DateActual Labor HoursActual Start DateActual Time SpentDelay ReasonLitigation Activity NameLitigation Activity TypePlanned DurationPlanned End DatePlanned ManpowerPlanned Start Date
| Business Data Model Data Model |
| Description | An action performed in the course and context of a legal action or arbitration. For example: Lawyer files a complaint at court |
| Relationship | |
 Litigation Activity_Legal Action_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Actual End Date
| Description | Actual date upon which the activity was 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 |
Actual Labor Hours
| Description | A count of hours taken to perform the activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Actual Start Date
| Description | Actual date upon which the activity 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 |
Actual Time Spent
| Description | The actual time spent performing the activity, describing the elapsed time rather than effort. For example: A four-hour task may have been completed over three days. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Delay Reason
| Description | Indicates the cause of any discrepancy between planned and actual end dates. |
| 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 |
Litigation Activity Name
| Description | A word or phrase identifying the Litigation Activity. |
| 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 |
Litigation Activity Type
| Description | Classifies a litigation activity according to the nature or purpose of the activity. |
| 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 |
Planned Duration
| Description | The time planned for the performing of the activity. This is the total elapsed time over which the activity is expected to be performed and not the planned labor hours. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Planned End Date
| Description | Date upon which the activity is planned to finish. |
| 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 |
Planned Manpower
| Description | The planned labor hours required for the activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Planned Start Date
| Description | Date upon which the activity is planned to start. |
| 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 |
Litigation Activity_Legal Action_FK
| Is Identifying Relationship | false |
| Child Table | Litigation Activity |
| Child Role Name | occurs in |
| 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 | Legal Action |
| Parent Role Name | has occurrence of |
| 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 |