| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
Defines a valid instance of a type of wellbore trajectory shape. Common types are: build & hold, S shaped, vertical, horizontal. In the early stages of well planning, this information, along with some key parameters, are used to generate an approximate well profile - without the requirement for detailed trajectory planning. This information is also of value for wells that have already been drilled because it is difficult to categorize wells by their detailed trajectory.
- r_wb_traj_shap_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- r_wb_traj_shap_nm (M: CHAR VARYING(40))
- ref_wellbore_trajectory_shape.name
The common name by which a trajectory type is referred to. Examples are: build & hold, S shaped, vertical, horizontal.
- 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_wellbore_trajectory_shape.description
A comment about the trajectory type.
- 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, wellbore
Intersection Tables: reference_data_x
Primary Key Constraint on: R_WB_TRAJ_SHAP_S
Fully implemented Unique Constraint on: R_WB_TRAJ_SHAP_NM
Generated on Mon Dec 1 10:27:25 1997
© Copyright 1997 POSC. All rights reserved.