Versions Compared

Old Version 1

changes.mady.by.user David Santamauro

Saved on

compared with

New Version 2

changes.mady.by.user David Santamauro

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The table xml.t_patent_document_values houses the load-ids that affect the overall status of the entire document.

  • created_load_id – the load-id when the document was added to the data warehouse
  • modified_load_id – the load-id that last modified the document, whether it be addition, correction or deletion of content
  • deleted_load_id – the load-id that the entire document was marked deleted
  • created_load_id – the load-id when the document was added to the data warehouse

 

Each satellite table also contains a modified_load_id column that is specific to the content in that table and will always be <= xml.t_patent_document_values(modified_load_id). The following table should clarify the sequence of update events and the effect on load-id values for three database tables.

...