The compliance of a set of objects and/or activities with respect to a guideline or privilege. This is used to define the specific objects (i.e., drilling permit) that are designated to satisfy the requirements of certain activities (i.e., spudding a well) for certain objects (i.e., well #7).

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

Surrogate key of the table.


gdln_or_priv_s (FSK, M: CHAR VARYING(19))
gdln_or_priv_t (M: CHAR VARYING(16))

guideline_or_privilege_compliance.guideline_or_privilege
This defines the guideline, limitation, regulation or privilege that is described by this compliance statement.
gdln_or_priv_s: Implements a foreign key to a row in one of the tables projected from entity guideline_or_privilege depending on the value of the next column (See below).
gdln_or_priv_t: Defines the name of the referenced table. Possible values are: bsasc_privilege, guideline, limitation, regulation (@guideline_or_privilege).


description (O: CHAR VARYING(2000))

transient_association.description
A description of the transient association.


duration (O: FLOAT)
duration_u (FNK, O: CHAR VARYING(15))

transient_association.duration
Defines the duration of the association expressed in any valid units of time.
duration_u: Defines the unit of measure. Defines a foreign key to table r_uom.


end_time (O: TIMESTAMP)

transient_association.end_time
End time of the association.


start_time (O: TIMESTAMP)

transient_association.start_time
Start time of the association.


activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))

guideline_or_privilege_compliance.activity
This describes a specific activity for which this compliance statement is made.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


business_object_s (FSK, O: CHAR VARYING(19))
business_object_t (O: CHAR VARYING(16))

guideline_or_privilege_compliance.business_object
This is a business object for which this compliance statement is made.
business_object_s: Implements a foreign key to a row in one of the tables projected from entity business_object depending on the value of the next column (See below).
business_object_t: Defines the name of the referenced table. Possible values are defined in @business_object.


caused_by_s (FSK, O: CHAR VARYING(19))
caused_by_t (O: CHAR VARYING(16))

transient_association.caused_by
Specifies the activity which establishes this association.
caused_by_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
caused_by_t: Defines the name of the referenced table. Possible values are defined in @activity.


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

guideline_or_privilege_compliance.ref_guideline_compliance_status
This defines the status of the compliance statement. This will usually convey degree of compliance or noncompliance.
Defines a foreign key to table r_gdln_com_sta.


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

transient_association.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_pd.


terminated_by_s (FSK, O: CHAR VARYING(19))
terminated_by_t (O: CHAR VARYING(16))

transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
terminated_by_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
terminated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.