ChkDB |
Open Source Rule-Based Data Checking | ||||||
|
Home Contact Download Releases Open Source License Project Contributing The PL/SQL Using ChkDB Installation Read-Me Rule-Sets ChkDB Tables E-R Diagram
Tiny Sample External Links Data Quality and Data Profiling (a glossary) |
The WELL_HDR_BASIC Rule-Setfor the OIL_GAS_WELL_1 data domainThe WELL_HDR_BASIC rule-set checks basic well-header data.
Summary of ruleset WELL_HDR_BASIC in domain OIL_GAS_WELL_1 (Inactive rules have RULE_ID in parentheses) TABLE_NAME RULE_ID CLASS -------------------------------- ---------------------- ----- DESCRIPTION ------------------------------------------------------------ CHKDB_OGW1_WELL (AREA_LONG) 3 area is too long CHKDB_OGW1_WELL (AREA_NULL) 2 area of well not set CHKDB_OGW1_WELL BH_LAT_BAD 4 bottom_hole_latitude is invalid CHKDB_OGW1_WELL BH_LON_BAD 4 bottom_hole_longitude is invalid CHKDB_OGW1_WELL (COUNTRY_LONG) 3 country is too long CHKDB_OGW1_WELL (COUNTRY_NULL) 2 country of well not set CHKDB_OGW1_WELL (COUNTY_LONG) 3 county is too long CHKDB_OGW1_WELL (COUNTY_NULL) 2 county of well not set CHKDB_OGW1_WELL (CURRENT_STATUS_LONG) 3 current_status is too long CHKDB_OGW1_WELL (CUR_STATUS_DATE_BAD) 3 current_status_date is invalid CHKDB_OGW1_WELL (DATA_SOURCE_LONG) 3 data_source is too long CHKDB_OGW1_WELL (DATA_SOURCE_NULL) 3 data_source is not set CHKDB_OGW1_WELL (DISTRICT_LONG) 3 district is too long CHKDB_OGW1_WELL (DISTRICT_NULL) 2 district of well not set CHKDB_OGW1_WELL (GOVT_WELL_ID_LONG) 3 govt_well_id is too long CHKDB_OGW1_WELL (GOVT_WELL_ID_NULL) 3 govt_well_id is not set CHKDB_OGW1_WELL (NUMERIC_ID_NULL) 3 numeric_id is not set CHKDB_OGW1_WELL PARENT_UWI_BAD 4 parent_uwi does not exist CHKDB_OGW1_WELL (PARENT_UWI_LONG) 3 parent_uwi is too long CHKDB_OGW1_WELL (PROSPECT_LONG) 3 prospect is too long CHKDB_OGW1_WELL (PROSPECT_NULL) 2 prospect of well not set CHKDB_OGW1_WELL (PROVINCE_STATE_LONG) 3 province/state is too long CHKDB_OGW1_WELL PROVINCE_STATE_NULL 2 province/state of well not set CHKDB_OGW1_WELL (REGION_LONG) 3 region is too long CHKDB_OGW1_WELL (REGION_NULL) 2 region of well not set CHKDB_OGW1_WELL SURFACE_LAT_BAD 4 surface_latitude is invalid CHKDB_OGW1_WELL SURFACE_LON_BAD 4 surface_longitude is invalid CHKDB_OGW1_WELL SURF_BH_LAT_APART 3 surface and bottom-hole latitude too far apart CHKDB_OGW1_WELL SURF_BH_LON_APART 3 surface and bottom-hole longitude too far apart CHKDB_OGW1_WELL (UWI_LONG) 3 uwi is too long CHKDB_OGW1_WELL (WELL_CLASS_LONG) 3 well_class is too long CHKDB_OGW1_WELL WELL_CLASS_NULL 3 well_class is not set CHKDB_OGW1_WELL (WELL_NAME_LONG) 3 well_name is too long CHKDB_OGW1_WELL WELL_NAME_NULL 3 well_name is not set CHKDB_OGW1_WELL WELL_STATUS_NULL 4 current_status is not set CHKDB_OGW1_WELL_COMPLETE ABANDONMENT_DT_BAD 3 abandonment_date is invalid or not set CHKDB_OGW1_WELL_COMPLETE BH_LAT_NULL 4 bottom_hole_latitude is not set CHKDB_OGW1_WELL_COMPLETE BH_LON_NULL 4 bottom_hole_longitude is not set CHKDB_OGW1_WELL_COMPLETE CF_ELEV_BAD 3 casing flange elevation is invalid or not set CHKDB_OGW1_WELL_COMPLETE COMPLETION_DT_BAD 3 completion_date is invalid or not set CHKDB_OGW1_WELL_COMPLETE (DRILLER_TD_BAD) 4 driller_td is invalid or not set CHKDB_OGW1_WELL_COMPLETE FIN_DRL_DT_BAD 3 finished_drilling_date is invalid or not set CHKDB_OGW1_WELL_COMPLETE GROUND_ELEV_BAD 3 ground_elevation is invalid or not set CHKDB_OGW1_WELL_COMPLETE KB_ELEV_BAD 4 KB elevation is invalid or not set CHKDB_OGW1_WELL_COMPLETE KB_GRND_APART 3 ground and KB elevations too far apart CHKDB_OGW1_WELL_COMPLETE (LEASE_NAME_LONG) 3 lease_name is too long CHKDB_OGW1_WELL_COMPLETE (LEASE_NAME_NULL) 2 lease_name is not set CHKDB_OGW1_WELL_COMPLETE (LEASE_NUM_LONG) 3 lease_num is too long CHKDB_OGW1_WELL_COMPLETE (LEASE_NUM_NOTNUM) 3 lease_num is not a number CHKDB_OGW1_WELL_COMPLETE (LEASE_NUM_NULL) 2 lease_num is not set CHKDB_OGW1_WELL_COMPLETE (LOGGER_TD_BAD) 4 logger_td is invalid or not set CHKDB_OGW1_WELL_COMPLETE (PLUGBACK_DEPTH_BAD) 4 plugback_depth is invalid or not set CHKDB_OGW1_WELL_COMPLETE RIG_REL_DT_BAD 3 rig_release_date is invalid or not set CHKDB_OGW1_WELL_COMPLETE SPUD_DATE_BAD 3 spud_date is not set CHKDB_OGW1_WELL_COMPLETE TOTAL_DEPTH_BAD 4 total (measured) depth is invalid or not set CHKDB_OGW1_WELL_COMPLETE TVD_BAD 3 true_vertical_depth is invalid CHKDB_OGW1_WELL_COMPLETE TVD_NULL 3 true_vertical_depth is not set CHKDB_OGW1_WELL_COMPLETE (WHIPSTOCK_DEPTH_BAD) 4 whipstock_depth is invalid or not set CHKDB_OGW1_WELL_SPUDDED (FIELD_LONG) 3 field is too long CHKDB_OGW1_WELL_SPUDDED FIELD_NULL 2 field is not set CHKDB_OGW1_WELL_SPUDDED (OPERATOR_LONG) 3 operator is too long CHKDB_OGW1_WELL_SPUDDED (POOL_LONG) 3 pool is too long CHKDB_OGW1_WELL_SPUDDED POOL_NULL 2 pool is not set CHKDB_OGW1_WELL_SPUDDED SPUD_DATE_BAD 3 spud_date is invalid CHKDB_OGW1_WELL_SPUDDED SURFACE_LAT_NULL 4 surface_latitude is not set CHKDB_OGW1_WELL_SPUDDED SURFACE_LON_NULL 4 surface_longitude is not set CHKDB_OGW1_WELL_SPUDDED WELL_OPERATOR_NULL 2 operator is not set |