L Problem table

L_Problem in Centralized_data.mdb contains some of the known data errors and some false-positives. It is used for excluding records from check queries.

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	query from which to exclude this false positive
Notes	text	further explanations, eg why the error was not corrected or why it is a false positive