A catalog or cross reference that identifies a specific regulation as being combined with or based upon an existing regulation.
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).
regulation_reference.referenced_regulation
This is the regulation that is used as a reference by another. Generally, this will be the preexisting regulation used to provide additional information to a subsequent regulation. For example, if regulation A1 states that regulation G2 must be honored, this points to regulation G2 as the preexisting regulation.
Defines a foreign key to table guideline_or_privilege.
regulation_reference.ref_regulation_reference_use
The description of the use for which a reference is made from one contract to the other.
Defines a foreign key to table r_regulation_reference_use.
regulation_s (FSK, M: CHAR VARYING(19))
regulation_reference.regulation
This is the regulation for which the reference is defined. This regulation uses the referenced regulation. For example, if regulation A1 states that regulation G2 must be honored, this points to regulation A1 as the regulation being defined by the reference.
Defines a foreign key to table guideline_or_privilege.
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".