A set of text that describes a distinct section of a regulation, usually addressing a specific subject.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
identifier (M: CHAR VARYING(80))
regulation_clause.identifier
The identifier applied to the regulation clause.
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).
Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: regulation_clause, regulation_clause_amendment.
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.
occurrence_order (O: INTEGER)
regulation_clause.occurrence_order
This is the relative order of the clause within the regulation. A clause with an order of one occurs before a clause with an order of two.
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".