ZZstate

All tables in Genio are created in the database with an integer field called zzstate. This field is never defined in Genio itself but is used by the application to check if each record is in a valid state.

Possible Values

  • 0: The record was correctly commited. Everything is ok
  • 1: The record is invalid and it's invisible to the user
  • 11: The record is invalid but can be changed by the user

There is a database maintenance operation that changes all records in state 1 to 11.