Skip to content

Data entry tracking log

Log structure

If, on a form, the Enable tracking of edits in data entry mode item is enabled in Form options, the system will apply the changes on saving. See Form options window.

In data entry mode, the edit tracking log on the LOG_PROSPETTO_DATA database table has the following fields.

  • OID_DATA: the edit’s unique identifier.
  • AFFECTED_OID: unique identifier of the row edited/added to the table of events.
  • TABLE_ID: identifier of the table involved.
  • COD_PROSPETTO: form code.
  • USERUPD: code of the user who performed the save.
  • DATEUPD: date and time saved.

The TABLE_ID field can have the following values:

  • 0 for the DATI_SALDI_LORDI table
  • 1 for the DATI_SALDI_IC table
  • 2 for the DATI_COMMENTI table
  • 3 for the DATI_NOTE table
  • 5 for the DATI_PROSPETTO_FORMULA table