POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A description of an expectation applied to an object or activity, such as a regulation, limitation, guideline or privilege. Values for the guideline or privilege are defined by the related pty general property data. Violations of the guideline or privilege are recorded by pty guideline violation.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- guideline_or_privilege.identifier
The name of the guideline.
- 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).
- entity_type_nm (M: CHAR VARYING(30))
- 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: business_associate_privilege, guideline, limitation, objective, regulation.
- data_value (O: FLOAT)
data_value_u (FNK, O: CHAR VARYING(15))
data_value_q (FNK, O: CHAR VARYING(80))
- 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_unit_of_measure.
data_value_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- effective_date (O: TIMESTAMP)
effective_date_cd (O: CHAR(1))
effective_date_yr (O: FLOAT)
effective_date_yp (O: INTEGER)
effective_date_dy (O: INTEGER)
effective_date_hr (O: INTEGER)
effective_date_mt (O: INTEGER)
effective_date_st (O: FLOAT)
effective_date_of (O: FLOAT)
- guideline_or_privilege.effective_date
The date, including time of day if appropriate, that a guideline is effective.
- expiry_date (O: TIMESTAMP)
expiry_date_cd (O: CHAR(1))
expiry_date_yr (O: FLOAT)
expiry_date_yp (O: INTEGER)
expiry_date_dy (O: INTEGER)
expiry_date_hr (O: INTEGER)
expiry_date_mt (O: INTEGER)
expiry_date_st (O: FLOAT)
expiry_date_of (O: FLOAT)
- guideline_or_privilege.expiry_date
The date, including the time of day if appropriate, that a guideline expires.
- 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".
- text (O: CHAR VARYING)
- business_associate_privilege.text
The full text of the privilege.
guideline.text
The full text of the guideline.
limitation.text
The full text of the limitation.
objective.text
The full text of the objective.
- business_associate_s (FSK, O: CHAR VARYING(19))
- business_associate_privilege.business_associate
Specifies the business associate that has been assigned this privilege.
Defines a foreign key to table business_associate.
- guideline_set_s (FSK, O: CHAR VARYING(19))
- guideline.guideline_set
This defines the guideline set of which this guideline is a part.
Defines a foreign key to table guideline_set.
- limitation_set_s (FSK, O: CHAR VARYING(19))
- limitation.limitation_set
Specifies the group of limitations of which this is a member.
Defines a foreign key to table limitation_set.
- objective_set_s (FSK, O: CHAR VARYING(19))
- objective.objective_set
Specifies a group of objectives containing this one.
Defines a foreign key to table objective_set.
- r_business_assoc_privilege (FNK, O: CHAR VARYING(80))
- business_associate_privilege.ref_business_assoc_privilege
The type or kind of privilege for a business associate.
Defines a foreign key to table r_business_assoc_privilege.
- r_guideline (FNK, O: CHAR VARYING(80))
- guideline.ref_guideline
The type of guideline.
Defines a foreign key to table r_guideline.
- r_limitation (FNK, O: CHAR VARYING(80))
- limitation.ref_limitation
The type of limitation.
Defines a foreign key to table r_limitation.
- r_objective (FNK, O: CHAR VARYING(80))
- objective.ref_objective
The type of objective.
Defines a foreign key to table r_objective.
- r_regulation (FNK, O: CHAR VARYING(80))
- regulation.ref_regulation
The type of the regulation.
Defines a foreign key to table r_regulation.
- r_regulation_purpose (FNK, O: CHAR VARYING(80))
- 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_regulation_purpose.
Table is related to: activity_subject_to_guideline, contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, @graphical_element, guideline_compliance, guideline_or_privilege_remedy, object_activity_involvement, object_remark, object_subject_to_guideline, regulation_administration, regulation_clause, regulation_reference, regulation_status, regulatory_area_regulation, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:37:10 2001
© Copyright 2001 POSC. All rights reserved.