| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
The reference entity that provides the rules used to define wells. This contains the definitions of simple, simplex, compound, complex and network wells as defined by POSC, and may contain the description of other well definition rules used within the E&P industry.
- r_well_strule_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- r_well_strule_name (M: CHAR VARYING(40))
- ref_well_structure_rule.name
The identification of the well type of the well structure rule.
- source (FNK, M: CHAR VARYING(40))
- reference_behavior.source
The provider of this instance of reference information. If this instance is provided by POSC, then this attribute must be "POSC".
Defines a foreign key to table r_source.
- description (O: CHAR VARYING(2000))
- ref_well_structure_rule.description
A description of the rule for associating wellbores with well types.
- status (O: CHAR VARYING(11))
- reference_behavior.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
- source_reference_s (FSK, O: CHAR VARYING(19))
- reference_behavior.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
Defines a foreign key to table r_source_ref.
- version (FNK, O: CHAR VARYING(40))
- reference_behavior.version
Describes the version of Epicentre when this status was assigned to this instance of reference behavior
Defines a foreign key to table r_epcnt_version.
Table is related to: r_code_alias, well
Intersection Tables: reference_data_x
Primary Key Constraint on: R_WELL_STRULE_S
Fully implemented Unique Constraint on: R_WELL_STRULE_NAME
Generated on Mon Dec 1 10:27:29 1997
© Copyright 1997 POSC. All rights reserved.