search

smallAreaHealthStatisticsUnit / rapidInquiryFacility

The Rapid Inquiry Facility (RIF) helps epidemiologists and public health researchers in environmental health activities.
GNU Lesser General Public License v3.0
14 stars 5 forks source link

Improve the audit trail #81

Open devilgate opened 6 years ago

devilgate commented 6 years ago

I said that SQL statements and similar are put into the log.

Peter's comments:

All SQL is also logged in the database.

Add t_rif40_warnings/rif40_warnings table and view to contain warning messages on a study basis. Can be created by the extract or R the scripts. Add traps for:

  • Out of range or null covariates by year;
  • Missing years of numerator or denominator data;
  • Males/females not present when requested in numerator or denominator;
  • ICD codes not present when requested in numerator;
  • Maljoin detection
devilgate commented 6 years ago

Logging and auditing

peterhambly commented 5 years ago

Also: Add Java processing log, SQL statement and warnings logs to extract