Date constraints and tests for sources

[quindavies]

CARE_SITE

Not applicable

CONDITION_OCCURRENCE

• [ ] condition_start_datetime >= birth_datetime

For discussion

condition_start_datetime <= death_datetime condition_start_datetime >= visit_start_datetime condition_start_datetime <= visit_end_datetime

DEVICE_EXPOSURE

• [ ] device_exposure_start_datetime >= birth_datetime
• [ ] device_exposure_start_datetime <= death_datetime
• [ ] device_exposure_start_datetime >= visit_start_datetime
• [ ] device_exposure_start_datetime <= visit_end_datetime

DRUG_EXPOSURE

• [ ] drug_exposure_start_datetime >= birth_datetime
• [ ] drug_exposure_start_datetime <= death_datetime
• [ ] drug_exposure_start_datetime >= visit_start_datetime
• [ ] drug_exposure_start_datetime <= visit_end_datetime

LOCATION

Not applicable

MEASUREMENT

For discussion

measurement_datetime >= visit_start_datetime measurement_datetime <= visit_end_datetime measurement_datetime >= birth_datetime measurement_datetime <= death_datetime

OBSERVATION

For discussion

observation_datetime >= visit_start_datetime observation_datetime <= visit_end_datetime observation_datetime >= birth_datetime observation_datetime <= death_datetime

PERSON

• [ ] birth_datetime is a true date
• [ ] birth_datetime < current_datetime

For discussion

Do we need further checks on numbers in year, month and day

PROCEDURE_OCCURRENCE

• [ ] procedure_datetime >= birth_datetime

For discussion

procedure_datetime >= visit_start_datetime procedure_datetime <= visit_end_datetime procedure_datetime <= death_datetime

PROVIDER

Not applicable

SPECIMEN

For discussion

specimen_datetime >= visit_start_datetime specimen_datetime <= visit_end_datetime specimen_datetime >= birth_datetime specimen_datetime <= death_datetime

VISIT_DETAIL

• [ ] visit_detail_start_datetime <= visit_detail_end_datetime
• [ ] birth_datetime <= visit_detail_start_datetime
• [ ] visit_detail_start_datetime <= death_datetime
• [ ] visit_detail_start_datetime >= visit_start_datetime
• [ ] visit_detail_end_datetime <= visit_end_datetime

For discussion

VISIT_OCCURRENCE

• [ ] visit_start_datetime <= visit_end_datetime
• [ ] birth_datetime <= visit_start_datetime
• [ ] visit_start_datetime <= death_datetime

For discussion