Troubled by patients missing from Patient List

[artgoldberg]

Hi Folks

While testing deployment of a new clinical domain (procedures) I repeatedly encounter the "The Leaf server returned demographic data for less patients than were included in the original cohort. This usually indicates that demographic data are missing for these patients." warning message.

Comparing output of sqlcmd and Leaf executions of the same query, I find the additional patients found by sqlcmd
equals the count of missing patients in the Patient List warning about dropped patients.

But I don't understand the justification for dropping any patients. In our case the Patient List includes patient ids, which our users will want to have, independent of whether any other data is available for the patients.

This seems very important to me.

Example list of 2 patients is attached.

Arthur

test_1_leaf_cohort_1634655590941_demographics.csv

[ndobb]

Hi @artgoldberg,

Is it possible that any of the patients have the same patient ids? (ie, a collision)

Also, can you confirm that every patient id in procedure_occurrence has a corresponding row in person?

[artgoldberg]

@ndobb

Good intuition. Much to my surprise, some patient_ids in procedure_occurrence do not have corresponding rows in person.

[ndobb]

Phew! (well, I'm sorry to hear that but relieved it's not a bug with Leaf)