Project Status- Project Summary by Notes Status

The Project Status by Notes Status report summarizes the notes for a given project and selected tables. The report identifies total columns, total columns not annotated, a breakdown of notes by Note Status, and a summary of notes.

Parameters

Specify the parameters for the report:

Project Name
Select the name of the project that contains the project that you want included in the report.
Host Name
Select the host name that has the columns that you want to be included in the report.
Data Store Name
Select the data store on the selected host computer. A data store is a virtual entity that has connection details to the source repository.
Database Name
Select the name of the database that you want to include in the report.
Table Name
Select the tables that you want included in the report.
Enter Data Collection Parameter
Select the columns that you want included in the report.
Comments
Enter any comments you want included in the report output.
Locale specification [Language,Territory]
Select the language and demographic region for the data included in the report.
Output format
Specify the format that you want for your report. You can select HTML, XML, RTF, PDF, or TXT.
Expiration
Specify when you want your report to expire.
History policy
Specify whether you want your report data to replace older versions each time it is run, or if you want to archive each individual report you run.
Report name
Specify a name for the report.
Save report
Select this option if you want to save this report so you can run it again in the future. If you want to save your report, then you must select the folder in which you want to save the report. You have the option of adding the report to your favorites folder, and of viewing the report after the processing finishes.

Content

The following defines the structure of the report:

Heading
Project Summary by Notes Status
Project Level Summary
Project Name
# of Columns Total
Not Annotated Columns
# Open
% Open
# Pending
% Pending
# Other
% Other
# Closed
% Closed
# Annotations: Total
# Annotations: Average Notes per annotated column
Host Level Summary
Project Name
# of Columns Total
Not Annotated Columns
# Open
% Open
# Pending
% Pending
# Other
% Other
# Closed
% Closed
# Annotations: Total
# Annotations: Average Notes per annotated column
Data Store Level Summary
Project Name
# of Columns Total
Not Annotated Columns
# Open
% Open
# Pending
% Pending
# Other
% Other
# Closed
% Closed
# Annotations: Total
# Annotations: Average Notes per annotated column
Data Schema Level Summary
Project Name
# of Columns Total
Not Annotated Columns
# Open
% Open
# Pending
% Pending
# Other
% Other
# Closed
% Closed
# Annotations: Total
# Annotations: Average Notes per annotated column
Table Level Detail Statistics
Project Name
# of Columns Total
Not Annotated Columns
# Open
% Open
# Pending
% Pending
# Other
% Other
# Closed
% Closed
# Annotations: Total
# Annotations: Average Notes per annotated column

Example of Report Output

An example of the Project Status- Project Summary by Notes Status report that contains sample data