The Table Specification report documents:
- Table properties such as number of columns, rows, size on disk.
- How a table is configured, including column names, data types and description.
- Information about how the table has changed over time in terms of:
- Structure, i.e. columns.
- Data, i.e. rows.
The most common scenarios where you might want to generate a specification report include (a) as documentation for important business processes (b) for risk, audit or compliance reviews (c) to facilitate the communication between teams and team members of how a process works and (d) to periodically review important business processes for correctness.
For this example we will be using the managed table Clients and a preview of the first five rows is below.
- Locate the managed table for which you want to generate a specification report.
- Right-click on the managed table and select "Generate table specification report" in the contextual menu.
Once you click on “Generate process document” button, a new separate browser window will be open with Table Specification report. The Table Specification Report is shown below.
- Adjust the date range for which the structure and data change log information should be shown in the Report parameters at the top and click "Refresh report" to regenerate the report.