L_Problem table

The L_Problem table in Centralized_data.accdb contains known data errors to exclude them from several CFE Data Integrity Checks. This could be needed because we deliberately decided they were not worth fixing, or because a cross check delivers a false positive in some circumstances.

It is manually populated by the data processor as she encounters the errors or false positives, for example as part of vetting.

L_Problem contains the fields

field	type	description
D_ID	long	unique record ID
Query	text	One of the following: query from which to exclude this false positive Known data errors#Other known errors documentation
Notes	text	further explanations, eg why the error was not corrected or why it is a false positive

List of cross-checks that use L_Problems

page	Status	Timing	Summary
page	Status	Timing	Summary
Query NDC dx implying death across encounters	implemented	always	Category:Diagnosis implying death across encounters
Link suspect dead then alive query	implemented	always	Used in Correcting suspect links to find records where an earlier record with that PHIN was listed as dispo field deceased, but a later entry then shows up.
Link suspect negative transit time query	implemented	always	Used in Correcting suspect links to find records where an earlier record for a patient with that PHIN has a Dispo DtTm that is later than the next record's Admit DtTm.
Link suspect mismatch pre inpt ours incomplete query	implemented	always	Checks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.
Link suspect mismatch pre inpt should be ours incomplete query	implemented	always	What is description
Query cardiac arrest throughout admission	ready to implement	complete	Any patient who is admitted to ICU from Med or another ICU with a #Cardiac Arrest dx should have one in their immediately preceeding Med or ICU record also.
Link suspect visitAdmitDtTm mult to-from-home query	ready to implement	always	Checks for records that are likely part of the same admission but have different Visit Admit DtTm field.