This describes a required action in the event that a guideline or privilege is violated.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
activity_class_s (FSK, M: CHAR VARYING(19))
guideline_or_privilege_remedy.activity_class
This is the type of activity that is required by this remedy. That is, there must be an activity which is a member of this class.
Defines a foreign key to table activity_class.
guideline_or_privilege_remedy.action_value
This is a data value that should be applied as appropriate to the specified typical activity. For example, 10 percent as a reduction in rate. action_value_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. action_value_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.
apply_order (O: INTEGER)
guideline_or_privilege_remedy.apply_order
This is the relative order in which the remedy is to be applied. A remedy with an order of one should be applied before a remedy with an order of two.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
guideline_or_privilege_remedy.test_value
A data value that should be used to test the guideline or privilege to ensure that compliance is achieved. For example, a guideline or privilege data value of 3000 SCF/STB may be the operating limit but the value of 2500 SCF/STB should be used to make sure that the remedy activity is effective. The meaning of this value is defined by the data value within the guideline or privilege. test_value_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. test_value_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.