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) |
Rules in the OIL_GAS_SEIS_INV data domainThe rules in the OIL_GAS_SEIS_INV domain check basic seismic inventory data.This is a work in progress... Suggestions are appreciated.
Summary of rules in domain OIL_GAS_SEIS_INV (A ruleset/table/rule in parentheses is Inactive) RULESET_ID TABLE_NAME RULE_ID ---------------------- -------------------------------- ---------------------- DESCRIPTION CLASS ------------------------------------------------------------ ----- DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (CONTAINED_BY_ID_LONG) contained_by_store_id is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE CONTAINED_BY_ID_NOT contained_by_store_id does not exist 4 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (DATA_STORE_STAT_LONG) data_store_status is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (DATA_STORE_STAT_NULL) data_store_status is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (DATA_STORE_TYPE_LONG) data_store_type is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE DATA_STORE_TYPE_NULL data_store_type is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (EFFECTIVE_DATE_NULL) effective_date is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (EXPIRY_DATE_NULL) expiry_date is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (LOCATION_LONG) location is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (LOCATION_NULL) location is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (NUMERIC_ID_NULL) numeric_id is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_BARCODE_LONG) store_barcode is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_BARCODE_NULL) store_barcode is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_DESC_LONG) store_desc is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_DESC_NULL) store_desc is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_ID_LONG) store_id is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_NAME2_LONG) store_name2 is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_NAME2_NULL) store_name2 is not set 3 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_NAME_LONG) store_name is too long 2 DATA_STORE_BASIC CHKDB_OGSI_DATA_STORE (STORE_NAME_NULL) store_name is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (AREA_LONG) area is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (AREA_NULL) area is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (COUNTRY_LONG) country is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM COUNTRY_NULL country is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (COUNTY_LONG) county is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (COUNTY_NULL) county is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (CREATE_END_DATE_NULL) create_end_date is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (CREATE_START_DT_NULL) create_start_date is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM CRE_START_AFTER_END create_start_date after create_end_date 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (DATA_VERSION_LONG) data_version is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (DATA_VERSION_NULL) item_format is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (DISTRICT_LONG) district is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (DISTRICT_NULL) district is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (EFFECTIVE_DATE_NULL) effective_date is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (EXPIRY_DATE_NULL) expiry_date is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM FIRST_LAST_SP_SAME first and last shotpoints are the same 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (FIRST_NLINE_NUM_NULL) first_nline_num is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (FIRST_REC_NUM_LONG) first_rec_num is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (FIRST_REC_NUM_NULL) first_rec_num is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (FIRST_SP_LONG) first_shot_point is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM FIRST_SP_NULL first_shot_point is not set 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (FIRST_XLINE_NUM_NULL) first_xline_num is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (INFO_ITEM_ID_LONG) info_item_id is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM ITEM_BYTES_BAD item_bytes is invalid 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (ITEM_BYTES_NULL) item_bytes is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (ITEM_CATEGORY_LONG) item_category is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (ITEM_FORMAT_LONG) item_format is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM ITEM_FORMAT_NULL item_format is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (ITEM_SUBCAT_LONG) item_subcategory is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (ITEM_TYPE_LONG) item_type is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM ITEM_TYPE_NULL item_type is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LAST_NLINE_NUM_NULL) last_nline_num is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LAST_REC_NUM_LONG) last_rec_num is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LAST_REC_NUM_NULL) last_rec_num is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LAST_SP_LONG) last_shot_point is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM LAST_SP_NULL last_shot_point is not set 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LAST_XLINE_NUM_NULL) last_xline_num is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_KEY_2_LONG) line_key_2 is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_KEY_2_NULL) line_key_2 is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM LINE_LENGTH_BAD line_length is invalid 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_LENGTH_NULL) line_length is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_LEN_UNITS_LONG) line_length_units is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_LEN_UNITS_NULL) line_length_units is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_NAME_KEY2_NOT) line_name,line_key_2 does not exist 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_NAME_LONG) line_name is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (LINE_NAME_NULL) line_name is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM MAX_LATITUDE_BAD max_latitude is invalid 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (MAX_LATITUDE_NULL) max_latitude is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM MAX_LONGITUDE_BAD max_longitude is invalid 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (MAX_LONGITUDE_NULL) max_longitude is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM MIN_LATITUDE_BAD min_latitude is invalid 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (MIN_LATITUDE_NULL) min_latitude is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM MIN_LONGITUDE_BAD min_longitude is invalid 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (MIN_LONGITUDE_NULL) min_longitude is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (NUMERIC_ID_NULL) numeric_id is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (PROCESSED_BY_NULL) processed_by is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (PROCESS_DATE_NULL) process_date is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (PROSPECT_LONG) prospect is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (PROSPECT_NULL) prospect is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (PROV_STATE_LONG) prov_state is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM PROV_STATE_NULL prov_state is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM RECORD_LENGTH_BAD record_length_ms is invalid 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (RECORD_LENGTH_NULL) record_length_ms is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (REGION_LONG) region is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (REGION_NULL) region is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM RLEN_SLEN_SREC_BAD rec-len, samp-len, samp/rec not consistent 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM SAMPLE_LENGTH_BAD sample_length is invalid 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (SAMPLE_LENGTH_NULL) sample_length is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM SAMP_PER_REC_BAD samples_per_record is invalid 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (SAMP_PER_REC_NULL) samples_per_record is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (SEIS_LINE_ID_LONG) seis_line_id is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM SEIS_LINE_ID_NOT seis_line_id does not exist 4 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (SEIS_LINE_ID_NULL) seis_line_id is not set 3 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (SURVEY_LONG) survey is too long 2 INFO_ITEM_BASIC CHKDB_OGSI_INFO_ITEM (SURVEY_NULL) survey is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (AREA_LONG) area is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (AREA_NULL) area is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (COUNTRY_LONG) country is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (COUNTRY_NULL) country is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (COUNTY_LONG) county is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (COUNTY_NULL) county is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (DISTRICT_LONG) district is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (DISTRICT_NULL) district is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (EFFECTIVE_DATE_NULL) effective_date is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (EXPIRY_DATE_NULL) expiry_date is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE FIRST_LAST_SP_SAME first and last shotpoints are the same 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (FIRST_NLINE_NUM_NULL) first_nline_num is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (FIRST_REC_NUM_LONG) first_rec_num is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (FIRST_REC_NUM_NULL) first_rec_num is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (FIRST_SP_LONG) first_shot_point is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (FIRST_SP_NULL) first_shot_point is not set 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (FIRST_XLINE_NUM_NULL) first_xline_num is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (INFO_ITEM_ID_LONG) info_item_id is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE INFO_ITEM_ID_NOT info_item_id does not exist 5 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (INFO_LINE_UNIQ_LONG) info_line_uniq is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE INFO_LINE_UNIQ_NULL info_line_uniq is not set 5 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LAST_NLINE_NUM_NULL) last_nline_num is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LAST_REC_NUM_LONG) last_rec_num is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LAST_REC_NUM_NULL) last_rec_num is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LAST_SP_LONG) last_shot_point is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LAST_SP_NULL) last_shot_point is not set 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LAST_XLINE_NUM_NULL) last_xline_num is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE LINE_LENGTH_BAD line_length is invalid 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LINE_LENGTH_NULL) line_length is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LINE_LEN_UNITS_LONG) line_length_units is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (LINE_LEN_UNITS_NULL) line_length_units is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE MAX_LATITUDE_BAD max_latitude is invalid 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (MAX_LATITUDE_NULL) max_latitude is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE MAX_LONGITUDE_BAD max_longitude is invalid 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (MAX_LONGITUDE_NULL) max_longitude is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE MIN_LATITUDE_BAD min_latitude is invalid 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (MIN_LATITUDE_NULL) min_latitude is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE MIN_LONGITUDE_BAD min_longitude is invalid 4 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (MIN_LONGITUDE_NULL) min_longitude is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (PROSPECT_LONG) prospect is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (PROSPECT_NULL) prospect is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (PROV_STATE_LONG) prov_state is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (PROV_STATE_NULL) prov_state is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (REGION_LONG) region is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (REGION_NULL) region is not set 3 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (SEIS_LINE_ID_LONG) seis_line_id is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE SEIS_LINE_ID_NOT seis_line_id does not exist 5 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (SURVEY_LONG) survey is too long 2 INFO_LINE_BASIC CHKDB_OGSI_INFO_LINE (SURVEY_NULL) survey is not set 3 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (EFFECTIVE_DATE_NULL) effective_date is not set 3 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (EXPIRY_DATE_NULL) expiry_date is not set 3 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (INFO_ITEM_ID_LONG) info_item_id is too long 2 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS INFO_ITEM_ID_NOT info_item_id does not exist 5 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (INFO_PHYS_UNIQ_LONG) info_phys_uniq is too long 2 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS INFO_PHYS_UNIQ_NULL info_phys_uniq is not set 5 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (PHYS_ITEM_ID_LONG) phys_item_id is too long 2 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS SEIS_LINE_ID_NOT phys_item_id does not exist 5 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (STORE_ID_LONG) store_id is too long 4 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (STORE_ID_NULL) store_id is not set 5 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (STORE_NAME_LONG) store_name is too long 4 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (STORE_NAME_NULL) store_name is not set 5 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (STORE_OFFSET_NULL) store_offset is not set 5 INFO_PHYS_BASIC CHKDB_OGSI_INFO_PHYS (STORE_POS_NULL) store_pos is not set 5 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (BOX_ID_LONG) BOX_id is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (BOX_ID_NULL) box_id is not set 5 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (CREATE_DATE_BAD) create_date is before 1940 or after today 4 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (CREATE_DATE_NULL) create_date is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (EFFECTIVE_DATE_NULL) effective_date is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (EXPIRY_DATE_NULL) expiry_date is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_DENSITY_NOT_NUM) item_density is not a number 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_DENSITY_NULL) item_density is not set 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_NAME_LONG) item_name is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_NAME_NULL) item_name is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_SIZE_NOT_NUM) item_size is not a number 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_SIZE_NULL) item_size is not set 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_SIZE_UNITS_LONG) item_size_units is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_SIZE_UNITS_NULL) item_size_units is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (ITEM_TYPE_LONG) item_type is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM ITEM_TYPE_NULL item_type is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (LABEL1_LONG) lable1 is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (LABEL1_NULL) lable1 is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (LABEL2_LONG) lable2 is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (LABEL2_NULL) lable2 is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (LABEL3_LONG) lable3 is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (LABEL3_NULL) lable3 is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (NUMERIC_ID_NULL) numeric_id is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (PHYS_ITEM_ID_LONG) phys_item_id is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (PHYS_ITEM_STAT_LONG) phys_item_status is too long 2 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (PHYS_ITEM_STAT_NULL) phys_item_status is not set 3 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (STORE_ID_LONG) store_id is too long 4 PHYS_ITEM_BASIC CHKDB_OGSI_PHYS_ITEM (STORE_ID_NULL) store_id is not set 5 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (BOX_ID_LONG) box_id is too long 4 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (BOX_ID_NULL) box_id is not set 5 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (EFFECTIVE_DATE_NULL) effective_date is not set 3 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (EXPIRY_DATE_NULL) expiry_date is not set 3 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (PHYS_ITEM_ID_LONG) phys_item_id is too long 2 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (PHYS_STORE_UNIQ_LONG) phys_store_uniq is too long 2 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE PHYS_STORE_UNIQ_NULL phys_store_uniq is not set 5 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE SEIS_LINE_ID_NOT phys_item_id does not exist 5 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE (STORE_ID_LONG) store_id is too long 2 PHYS_STORE_BASIC CHKDB_OGSI_PHYS_STORE STORE_ID_NOT store_id does not exist 5 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE ACTIVE_YN_BAD ACTIVE_YN is not Y or N 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (AREA_LONG) area is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (AREA_NULL) area is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (COUNTRY_LONG) country is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE COUNTRY_NULL country is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (COUNTY_LONG) county is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (COUNTY_NULL) county is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (DISTRICT_LONG) district is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (DISTRICT_NULL) district is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (EFFECTIVE_DATE_NULL) effective_date is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (EXPIRY_DATE_NULL) expiry_date is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE EXPIRY_LT_EFFECTIVE expiry_date before effective_date 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE FIRST_LAST_SP_SAME first and last shotpoints are the same 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (FIRST_NLINE_NUM_NULL) first_nline_num is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (FIRST_REC_NUM_LONG) first_rec_num is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (FIRST_REC_NUM_NULL) first_rec_num is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (FIRST_SP_LONG) first_shot_point is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE FIRST_SP_NULL first_shot_point is not set 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (FIRST_XLINE_NUM_NULL) first_xline_num is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE IS_3D_YN_BAD IS_3D_YN is something other than Y or N 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (IS_3D_YN_NULL) IS_3D_YN is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LAST_NLINE_NUM_NULL) last_nline_num is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LAST_REC_NUM_LONG) last_rec_num is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LAST_REC_NUM_NULL) last_rec_num is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LAST_SP_LONG) last_shot_point is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE LAST_SP_NULL last_shot_point is not set 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LAST_XLINE_NUM_NULL) last_xline_num is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LINE_KEY_2_LONG) line_key_2 is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE LINE_KEY_2_NULL line_key_2 is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE LINE_LENGTH_BAD line_length is invalid 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LINE_LENGTH_NULL) line_length is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LINE_LEN_UNITS_LONG) line_length_units is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LINE_LEN_UNITS_NULL) line_length_units is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (LINE_NAME_LONG) line_name is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE LINE_NAME_NULL line_name is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE MAX_LATITUDE_BAD max_latitude is invalid 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (MAX_LATITUDE_NULL) max_latitude is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE MAX_LONGITUDE_BAD max_longitude is invalid 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (MAX_LONGITUDE_NULL) max_longitude is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE MIN_LATITUDE_BAD min_latitude is invalid 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (MIN_LATITUDE_NULL) min_latitude is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE MIN_LONGITUDE_BAD min_longitude is invalid 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (MIN_LONGITUDE_NULL) min_longitude is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (NUMERIC_ID_NULL) numeric_id is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (PARENT_KEY2_LONG) parent_line_key_2 is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (PARENT_LINE_ID_LONG) parent_seis_line_id is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE PARENT_LINE_ID_NOT parent_seis_line_id does not exist 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (PARENT_LIN_NAME_LONG) parent_line_name is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE PARENT_NAME_KEY2_NOT parent_line_name|parent_line_key_2 does not exist 4 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (PROSPECT_LONG) prospect is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (PROSPECT_NULL) prospect is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (PROV_STATE_LONG) prov_state is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE PROV_STATE_NULL prov_state is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (REGION_LONG) region is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (REGION_NULL) region is not set 3 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (SEIS_LINE_ID_LONG) seis_line_id is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (SURVEY_LONG) survey is too long 2 SEIS_LINE_BASIC CHKDB_OGSI_SEIS_LINE (SURVEY_NULL) survey is not set 3 |