Skip to content

Modify the check: The number and percent of records with a value in the OBSERVATION_PERIOD_START_DATE field of the OBSERVATION_PERIOD that occurs prior to the date in the BIRTH_DATETIME field of the PERSON table. #513

Description

@dimshitc

Need to modify the check. Currently if the only year of birth is given, it uses CAST(CONCAT(plausibleTable.year_of_birth,'-06-01') AS DATE. But the real date of birth can be easily in the beginning of the year, leading to observation period start at this date.

Metadata

Metadata

Assignees

Labels

check bug/enhancementDQ check SQL logic has a bug or needs refinement

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions