search

OHDSI / DataQualityDashboard

A tool to help improve data quality standards in observational data science.
https://ohdsi.github.io/DataQualityDashboard
Apache License 2.0
136 stars 92 forks source link

OMOP v6 compatiblity #193

Closed sdebruyn closed 3 years ago

sdebruyn commented 3 years ago

I get the following errors when I run the DQD checks on an OMOP v6 database:

[Level: FIELD] [Check: cdmField] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: cdmField] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_value] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_value'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_VISIT_OCCURRENCE_admitting_source_value.txt
[Level: FIELD] [Check: cdmField] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_value] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_value'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_VISIT_DETAIL_admitting_source_value.txt
[Level: FIELD] [Check: cdmField] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_VISIT_DETAIL_admitting_source_concept_id.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: cost_domain_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'cost_domain_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_cost_domain_id.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: total_charge] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'total_charge'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_total_charge.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: total_cost] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'total_cost'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_total_cost.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: total_paid] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'total_paid'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_total_paid.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_by_payer] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_by_payer'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_by_payer.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_by_patient] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_by_patient'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_by_patient.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_patient_copay] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_copay'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_patient_copay.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_patient_coinsurance] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_coinsurance'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_patient_coinsurance.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_patient_deductible] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_deductible'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_patient_deductible.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_by_primary] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_by_primary'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_by_primary.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_ingredient_cost] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_ingredient_cost'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_ingredient_cost.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: paid_dispensing_fee] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_dispensing_fee'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_paid_dispensing_fee.txt
[Level: FIELD] [Check: cdmField] [CDM Table: COST] [CDM Field: amount_allowed] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'amount_allowed'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_COST_amount_allowed.txt
[Level: FIELD] [Check: cdmField] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: cdmField] [CDM Table: DRUG_ERA] [CDM Field: drug_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_DRUG_ERA_drug_era_end_date.txt
[Level: FIELD] [Check: cdmField] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: cdmField] [CDM Table: DOSE_ERA] [CDM Field: dose_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_DOSE_ERA_dose_era_end_date.txt
[Level: FIELD] [Check: cdmField] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_CONDITION_ERA_condition_era_start_date.txt
[Level: FIELD] [Check: cdmField] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmField_CONDITION_ERA_condition_era_end_date.txt
[Level: FIELD] [Check: isRequired] [CDM Table: COST] [CDM Field: cost_domain_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'cost_domain_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_COST_cost_domain_id.txt
[Level: FIELD] [Check: isRequired] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: isRequired] [CDM Table: DRUG_ERA] [CDM Field: drug_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_DRUG_ERA_drug_era_end_date.txt
[Level: FIELD] [Check: isRequired] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: isRequired] [CDM Table: DOSE_ERA] [CDM Field: dose_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_DOSE_ERA_dose_era_end_date.txt
[Level: FIELD] [Check: isRequired] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_CONDITION_ERA_condition_era_start_date.txt
[Level: FIELD] [Check: isRequired] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isRequired_CONDITION_ERA_condition_era_end_date.txt
[Level: FIELD] [Check: cdmDatatype] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_cdmDatatype_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: isForeignKey] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isForeignKey_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: isForeignKey] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isForeignKey_VISIT_DETAIL_admitting_source_concept_id.txt
[Level: FIELD] [Check: isForeignKey] [CDM Table: COST] [CDM Field: cost_domain_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'cost_domain_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isForeignKey_COST_cost_domain_id.txt
[Level: FIELD] [Check: isForeignKey] [CDM Table: COST] [CDM Field: paid_patient_copay] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_copay'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isForeignKey_COST_paid_patient_copay.txt
[Level: FIELD] [Check: fkDomain] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_fkDomain_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: isStandardValidConcept] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isStandardValidConcept_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: isStandardValidConcept] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_isStandardValidConcept_VISIT_DETAIL_admitting_source_concept_id.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_value] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_value'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_VISIT_OCCURRENCE_admitting_source_value.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_value] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_value'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_VISIT_DETAIL_admitting_source_value.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_VISIT_DETAIL_admitting_source_concept_id.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: cost_domain_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'cost_domain_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_cost_domain_id.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: total_charge] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'total_charge'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_total_charge.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: total_cost] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'total_cost'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_total_cost.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: total_paid] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'total_paid'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_total_paid.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_by_payer] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_by_payer'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_by_payer.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_by_patient] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_by_patient'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_by_patient.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_patient_copay] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_copay'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_patient_copay.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_patient_coinsurance] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_coinsurance'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_patient_coinsurance.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_patient_deductible] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_patient_deductible'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_patient_deductible.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_by_primary] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_by_primary'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_by_primary.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_ingredient_cost] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_ingredient_cost'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_ingredient_cost.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: paid_dispensing_fee] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'paid_dispensing_fee'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_paid_dispensing_fee.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: COST] [CDM Field: amount_allowed] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'amount_allowed'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_COST_amount_allowed.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: DRUG_ERA] [CDM Field: drug_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_DRUG_ERA_drug_era_end_date.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: DOSE_ERA] [CDM Field: dose_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_DOSE_ERA_dose_era_end_date.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_CONDITION_ERA_condition_era_start_date.txt
[Level: FIELD] [Check: measureValueCompleteness] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_measureValueCompleteness_CONDITION_ERA_condition_era_end_date.txt
[Level: FIELD] [Check: standardConceptRecordCompleteness] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_standardConceptRecordCompleteness_VISIT_OCCURRENCE_admitting_source_concept_id.txt
[Level: FIELD] [Check: standardConceptRecordCompleteness] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_standardConceptRecordCompleteness_VISIT_DETAIL_admitting_source_concept_id.txt
[Level: FIELD] [Check: sourceConceptRecordCompleteness] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_concept_id] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'admitting_source_concept_id'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_sourceConceptRecordCompleteness_VISIT_DETAIL_admitting_source_concept_id.txt
[Level: FIELD] [Check: sourceValueCompleteness] [CDM Table: VISIT_OCCURRENCE] [CDM Field: admitting_source_value] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ADMITTING_SOURCE_CONCEPT_ID'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_sourceValueCompleteness_VISIT_OCCURRENCE_admitting_source_value.txt
[Level: FIELD] [Check: sourceValueCompleteness] [CDM Table: VISIT_DETAIL] [CDM Field: admitting_source_value] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ADMITTING_SOURCE_CONCEPT_ID'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_sourceValueCompleteness_VISIT_DETAIL_admitting_source_value.txt
[Level: FIELD] [Check: plausibleValueLow] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueLow_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: plausibleValueLow] [CDM Table: DRUG_ERA] [CDM Field: drug_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueLow_DRUG_ERA_drug_era_end_date.txt
[Level: FIELD] [Check: plausibleValueLow] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueLow_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: plausibleValueLow] [CDM Table: DOSE_ERA] [CDM Field: dose_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueLow_DOSE_ERA_dose_era_end_date.txt
[Level: FIELD] [Check: plausibleValueLow] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueLow_CONDITION_ERA_condition_era_start_date.txt
[Level: FIELD] [Check: plausibleValueLow] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueLow_CONDITION_ERA_condition_era_end_date.txt
[Level: FIELD] [Check: plausibleValueHigh] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueHigh_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: plausibleValueHigh] [CDM Table: DRUG_ERA] [CDM Field: drug_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueHigh_DRUG_ERA_drug_era_end_date.txt
[Level: FIELD] [Check: plausibleValueHigh] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueHigh_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: plausibleValueHigh] [CDM Table: DOSE_ERA] [CDM Field: dose_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueHigh_DOSE_ERA_dose_era_end_date.txt
[Level: FIELD] [Check: plausibleValueHigh] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueHigh_CONDITION_ERA_condition_era_start_date.txt
[Level: FIELD] [Check: plausibleValueHigh] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleValueHigh_CONDITION_ERA_condition_era_end_date.txt
[Level: FIELD] [Check: plausibleTemporalAfter] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'drug_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleTemporalAfter_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: plausibleTemporalAfter] [CDM Table: DRUG_ERA] [CDM Field: drug_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'DRUG_ERA_START_DATE'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleTemporalAfter_DRUG_ERA_drug_era_end_date.txt
[Level: FIELD] [Check: plausibleTemporalAfter] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleTemporalAfter_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: plausibleTemporalAfter] [CDM Table: DOSE_ERA] [CDM Field: dose_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'dose_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleTemporalAfter_DOSE_ERA_dose_era_end_date.txt
[Level: FIELD] [Check: plausibleTemporalAfter] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_start_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleTemporalAfter_CONDITION_ERA_condition_era_start_date.txt
[Level: FIELD] [Check: plausibleTemporalAfter] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'condition_era_end_date'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleTemporalAfter_CONDITION_ERA_condition_era_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: OBSERVATION_PERIOD] [CDM Field: observation_period_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_OBSERVATION_PERIOD_observation_period_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: OBSERVATION_PERIOD] [CDM Field: observation_period_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_OBSERVATION_PERIOD_observation_period_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_OCCURRENCE] [CDM Field: visit_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_OCCURRENCE_visit_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_OCCURRENCE] [CDM Field: visit_start_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_OCCURRENCE_visit_start_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_OCCURRENCE] [CDM Field: visit_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_OCCURRENCE_visit_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_OCCURRENCE] [CDM Field: visit_end_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_OCCURRENCE_visit_end_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: CONDITION_OCCURRENCE] [CDM Field: condition_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_CONDITION_OCCURRENCE_condition_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: CONDITION_OCCURRENCE] [CDM Field: condition_start_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_CONDITION_OCCURRENCE_condition_start_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: CONDITION_OCCURRENCE] [CDM Field: condition_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_CONDITION_OCCURRENCE_condition_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: CONDITION_OCCURRENCE] [CDM Field: condition_end_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_CONDITION_OCCURRENCE_condition_end_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DRUG_EXPOSURE] [CDM Field: drug_exposure_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DRUG_EXPOSURE_drug_exposure_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DRUG_EXPOSURE] [CDM Field: drug_exposure_start_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DRUG_EXPOSURE_drug_exposure_start_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DRUG_EXPOSURE] [CDM Field: drug_exposure_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DRUG_EXPOSURE_drug_exposure_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DRUG_EXPOSURE] [CDM Field: drug_exposure_end_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DRUG_EXPOSURE_drug_exposure_end_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DRUG_EXPOSURE] [CDM Field: verbatim_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DRUG_EXPOSURE_verbatim_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: PROCEDURE_OCCURRENCE] [CDM Field: procedure_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_PROCEDURE_OCCURRENCE_procedure_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: PROCEDURE_OCCURRENCE] [CDM Field: procedure_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_PROCEDURE_OCCURRENCE_procedure_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DEVICE_EXPOSURE] [CDM Field: device_exposure_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DEVICE_EXPOSURE_device_exposure_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DEVICE_EXPOSURE] [CDM Field: device_exposure_start_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DEVICE_EXPOSURE_device_exposure_start_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DEVICE_EXPOSURE] [CDM Field: device_exposure_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DEVICE_EXPOSURE_device_exposure_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DEVICE_EXPOSURE] [CDM Field: device_exposure_end_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DEVICE_EXPOSURE_device_exposure_end_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_DETAIL] [CDM Field: visit_detail_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_DETAIL_visit_detail_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_DETAIL] [CDM Field: visit_detail_start_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_DETAIL_visit_detail_start_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_DETAIL] [CDM Field: visit_detail_end_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_DETAIL_visit_detail_end_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: VISIT_DETAIL] [CDM Field: visit_detail_end_datetime] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_VISIT_DETAIL_visit_detail_end_datetime.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DRUG_ERA] [CDM Field: drug_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DRUG_ERA_drug_era_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: DOSE_ERA] [CDM Field: dose_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_DOSE_ERA_dose_era_start_date.txt
[Level: FIELD] [Check: plausibleDuringLife] [CDM Table: CONDITION_ERA] [CDM Field: condition_era_start_date] Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'omop.death'.
An error report has been created at  /dbfs/mnt/aggregation/omop_dq/[REDACTED]_nlp/errors/FIELD_plausibleDuringLife_CONDITION_ERA_condition_era_start_date.txt
fdefalco commented 3 years ago

The CDM V6 specification is going through an overhaul. We will add support once the specification is finalized.