A rule or policy defined by a regulatory agency which obligates a business associate to perform specific procedures and reporting.

regulation_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


gdln_or_priv_id (M: CHAR VARYING(40))

guideline_or_privilege.identifier
The name of the guideline.


r_regulation_kind (FNK, M: CHAR VARYING(40))

regulation.ref_regulation
The type of the regulation.
Defines a foreign key to table r_regulation.


data_value (O: FLOAT)
data_value_u (FNK, O: CHAR VARYING(15))
data_value_q (FNK, O: CHAR VARYING(40))

guideline_or_privilege.data_value
A numerical value associated with the guideline of privilege. An example is a maximum working pressure of 1500 psi.
data_value_u: Defines the unit of measure. Defines a foreign key to table r_uom.
data_value_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.


description (O: CHAR VARYING(2000))

guideline_or_privilege.description
A brief description of the guideline or privilege.


effective_date (O: TIMESTAMP)

guideline_or_privilege.effective_date
The date, including time of day if appropriate, that a guideline is effective.


expiry_date (O: TIMESTAMP)

guideline_or_privilege.expiry_date
The date, including the time of day if appropriate, that a guideline expires.


r_rglt_purp_name (FNK, O: CHAR VARYING(40))

regulation.ref_regulation_purpose
An indicator for the purpose of the regulation. For example: oil well spacing, recompletion procedures, defining new versus old oil.
Defines a foreign key to table r_rglt_purp.


regulation_set_s (FSK, O: CHAR VARYING(19))

regulation.regulation_set
Specifies a group of regulations containing this one.
Defines a foreign key to table regulation_set.