L_Problem table

The L_Problem table in Centralized data.mdb 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

Link to table of cross-checks that use L_Problem table to exclude false-positives