Entity Action Plan Goal / Measure value

DescriptionAn association between an action plan goal and a measure value that indicates how a goal relates to a measure.

For example:
Must be greater than
Must be equal to
Must be less than

Attributes
Measure OperatorMeasure Operator

Relationship
Action Plan Goal / Measure value_Action Plan Goal_FKAction Plan Goal / Measure value_Action Plan Goal_FK
Action Plan Goal / Measure value_Measure Value_FKAction Plan Goal / Measure value_Measure Value_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Measure Operator
DescriptionThe arithmetic operator used between a Goal and the Measure Value.

For example:


=
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Action Plan Goal / Measure value_Action Plan Goal_FK
Is Identifying Relationshiptrue
Child TableAction Plan Goal / Measure value
Child Role Nameuses
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAction Plan Goal
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Action Plan Goal / Measure value_Measure Value_FK
Is Identifying Relationshiptrue
Child TableAction Plan Goal / Measure value
Child Role Nameused by
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableMeasure Value
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE