Lower Threshold Unit Of MeasureLower Threshold ValMeasure Target End DateMeasure Target Start DateMeasure Target Time PeriodMeasure Target Unit Of MeasureMeasure Target ValUpper Threshold Unit Of MeasureUpper Threshold Val
| Business Data Model Data Model |
| Description | A set of values that are used to determine if a measure has met a pre-defined goal. |
| Relationship | |
 Measure Targets_Measure Definition_FK |
|
| Measure Target_Organization_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Lower Threshold Unit Of Measure
| Description | Indicates the Lower Threshold Val's unit of measure. Example: Val = 10 Unit Of Measure could be = ml, $, or km... |
| 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 |
Lower Threshold Val
| Description | Lower end of a measures threshold value. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Measure Target End Date
| Description | The date until which the metric holding the target value amount is valid. |
| 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 |
Measure Target Start Date
| Description | The date from which the metric holding the target value amount is valid. |
| 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 |
Measure Target Time Period
| Description | Indicates the time period to which the target pertains. |
| 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 |
Measure Target Unit Of Measure
| Description | Indicates the Measure Target Val's unit of measure. Example: Val = 10 Unit Of Measure could be = ml, $, or km... |
| 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 |
Measure Target Val
| Description | A metric holding the target value amount. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Upper Threshold Unit Of Measure
| Description | Indicates the Upper Threshold Value's unit of measure. Example: Val = 10 Unit Of Measure could be = ml, $, or km... |
| 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 |
Upper Threshold Val
| Description | Upper end of a measures threshold value. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Measure Targets_Measure Definition_FK
| Is Identifying Relationship | true |
| Child Table | Measure Target |
| 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 | Measure Definition |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Measure Target_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Measure Target |
| 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 |