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 DST_BASIC Rule-Setfor the OIL_GAS_WELL_1 data domainThe DST_BASIC rule-set checks basic Drill Stem Test (DST) data.
Summary of ruleset DST_BASIC in domain OIL_GAS_WELL_1 (Inactive rules have RULE_ID in parentheses) TABLE_NAME RULE_ID CLASS -------------------------------- ---------------------- ----- DESCRIPTION ------------------------------------------------------------ CHKDB_OGW1_DST BOT_DEPTH_BAD 4 bottom_depth is invalid or not set CHKDB_OGW1_DST BOT_TOP_DEPTH_BAD 3 Bottom depth above or too far below top_depth CHKDB_OGW1_DST (DATA_SOURCE_LONG) 3 data_source is too long CHKDB_OGW1_DST (DATA_SOURCE_NULL) 3 data_source is not set CHKDB_OGW1_DST (DST_TYPE_LONG) 3 dst_type is too long CHKDB_OGW1_DST (DST_TYPE_NULL) 3 dst_type is not set CHKDB_OGW1_DST (GOOD_TEST_YN_NOT_YN) 3 GOOD_TEST_YN must be Y or N CHKDB_OGW1_DST (GOOD_TEST_YN_NULL) 3 GOOD_TEST_YN is not set CHKDB_OGW1_DST (NUMERIC_ID_NULL) 3 numeric_id is not set CHKDB_OGW1_DST (REP_TEST_NUM_LONG) 3 report_test_num is too long CHKDB_OGW1_DST (REP_TEST_NUM_NULL) 3 report_test_num is not set CHKDB_OGW1_DST (RUN_NUM_LONG) 3 run_num is too long CHKDB_OGW1_DST TESTDATE_BAD 3 test_date is invalid or not set CHKDB_OGW1_DST (TEST_COMPANY_LONG) 3 test_company is too long CHKDB_OGW1_DST (TEST_COMPANY_NULL) 3 test_company is not set CHKDB_OGW1_DST (TEST_NUM_LONG) 3 test_num is too long CHKDB_OGW1_DST (TEST_STATUS_LONG) 3 test_status is too long CHKDB_OGW1_DST (TEST_STATUS_NULL) 3 test_status is not set CHKDB_OGW1_DST (TEST_UNIQ_LONG) 3 test_uniq is too long CHKDB_OGW1_DST TOP_DEPTH_BAD 4 top_depth is invalid or not set CHKDB_OGW1_DST UWI_BAD 4 uwi does not exist CHKDB_OGW1_DST (UWI_LONG) 3 uwi is too long CHKDB_OGW1_DST_GOOD (BOT_FORMATION_LONG) 3 bottom_formation is too long CHKDB_OGW1_DST_GOOD (BOT_FORMATION_NULL) 3 bottom_formation is not set CHKDB_OGW1_DST_GOOD FIN_HS_PRESS_BAD 3 fin_hydrostatic_press is bad CHKDB_OGW1_DST_GOOD INIT_HS_PRESS_BAD 3 init_hydrostatic_press is bad CHKDB_OGW1_DST_GOOD SI1_FIN_PRESS_BAD 3 Final flow pressure in first shut-in period is bad CHKDB_OGW1_DST_GOOD SI2_FIN_PRESS_BAD 3 Final flow pressure in second shut-in period is bad CHKDB_OGW1_DST_GOOD (SULPHUR_STATUS_LONG) 3 sulphur_status is too long CHKDB_OGW1_DST_GOOD (SULPHUR_STATUS_NULL) 3 sulphur_status is not set CHKDB_OGW1_DST_GOOD TD_AT_TEST_BAD 4 td_at_test_time is invalid or not set CHKDB_OGW1_DST_GOOD TEMPERATURE_BAD 3 temperature is bad CHKDB_OGW1_DST_GOOD (TOP_FORMATION_LONG) 3 top_formation is too long CHKDB_OGW1_DST_GOOD (TOP_FORMATION_NULL) 3 top_formation is not set CHKDB_OGW1_DST_GOOD VO1_FIN_PRESS_BAD 3 Final flow pressure in first flow period is bad CHKDB_OGW1_DST_GOOD VO1_INIT_PRESS_BAD 3 Initial flow pressure in first flow period is bad CHKDB_OGW1_DST_GOOD VO2_FIN_PRESS_BAD 3 Final flow pressure in second flow period is bad CHKDB_OGW1_DST_GOOD VO2_INIT_PRESS_BAD 3 Initial flow pressure in second flow period is bad CHKDB_OGW1_DST_PERIOD DST_BAD 4 DST does not exist CHKDB_OGW1_DST_PERIOD FIN_PRESS_BAD 3 final pressure is invalid or not set CHKDB_OGW1_DST_PERIOD INIT_PRESS_BAD 3 initial pressure is invalid CHKDB_OGW1_DST_PERIOD MINUTES_BAD 3 duration is missing or bad CHKDB_OGW1_DST_PERIOD PERIOD_SEQ_NUM_BAD 4 period_seq_num is invalid CHKDB_OGW1_DST_PERIOD (PERIOD_SEQ_NUM_NULL) 4 period_seq_num is not set CHKDB_OGW1_DST_PERIOD (PERIOD_TYPE_LONG) 3 period_type is too long CHKDB_OGW1_DST_PERIOD PERIOD_TYPE_NULL 3 period-type is not set CHKDB_OGW1_DST_PERIOD (PERIOD_UNIQ_LONG) 3 period_uniq is too long CHKDB_OGW1_DST_PERIOD (PERIOD_UNIQ_NOTNUM) 3 period_uniq is not a number |