Hide
Proposed solution
Change the logic to anchor the first qualifying bladder cancer to the diagnosis.
CURRENT LOGIC:
define "First Bladder Cancer Staging Procedure"
First(["Procedure, Performed": "Tumor staging (tumor staging)"] BladderCancerStaging
with "Bladder Cancer Diagnoses" BladderCancer
such that Global."NormalizeInterval"(BladderCancerStaging.relevantDatetime, BladderCancerStaging.relevantPeriod)starts on or before day of start BladderCancer.prevalencePeriod
and Global."NormalizeInterval"(BladderCancerStaging.relevantDatetime, BladderCancerStaging.relevantPeriod)overlaps day of BladderCancer.prevalencePeriod
sort by start of Global."NormalizeInterval"(relevantDatetime, relevantPeriod))
PROPOSED LOGIC:
define "First Bladder Cancer Staging Procedure"
First(["Procedure, Performed": "Tumor staging (tumor staging)"] BladderCancerStaging
with "Bladder Cancer Diagnoses" BladderCancer
such that Global."NormalizeInterval"(BladderCancerStaging.relevantDatetime, BladderCancerStaging.relevantPeriod)starts on or before day of start BladderCancer.prevalencePeriod
sort by start of Global."NormalizeInterval"(relevantDatetime, relevantPeriod))
Rationale for change
Some EHRs may not have the bladder cancer diagnosis entered prior to the end of the staging procedure
Show
Proposed solution
Change the logic to anchor the first qualifying bladder cancer to the diagnosis.
CURRENT LOGIC:
define "First Bladder Cancer Staging Procedure"
First(["Procedure, Performed": "Tumor staging (tumor staging)"] BladderCancerStaging
with "Bladder Cancer Diagnoses" BladderCancer
such that Global."NormalizeInterval"(BladderCancerStaging.relevantDatetime, BladderCancerStaging.relevantPeriod)starts on or before day of start BladderCancer.prevalencePeriod
and Global."NormalizeInterval"(BladderCancerStaging.relevantDatetime, BladderCancerStaging.relevantPeriod)overlaps day of BladderCancer.prevalencePeriod
sort by start of Global."NormalizeInterval"(relevantDatetime, relevantPeriod))
PROPOSED LOGIC:
define "First Bladder Cancer Staging Procedure"
First(["Procedure, Performed": "Tumor staging (tumor staging)"] BladderCancerStaging
with "Bladder Cancer Diagnoses" BladderCancer
such that Global."NormalizeInterval"(BladderCancerStaging.relevantDatetime, BladderCancerStaging.relevantPeriod)starts on or before day of start BladderCancer.prevalencePeriod
sort by start of Global."NormalizeInterval"(relevantDatetime, relevantPeriod))
Rationale for change
Some EHRs may not have the bladder cancer diagnosis entered prior to the end of the staging procedure