Report Descripts System Table
The report_descripts table acts as a table of contents and statistician for four different types of tables or files that are part of the Reporting World in Millennium. Each row in report_descripts represents one of these other tables or files. The possible types are:
- Criteria tables - These are the created and saved report criteria tables that contain all the criteria statements and other components that comprise a complete set of criteria.
- Template tables - These are the system standard template tables that may be used to create new report criteria.
- Advanced Search query tables - Each user may "own" one such table that holds the criteria for their most recent Advanced Search.
- HTML Output files - These files hold the .htm results of the run of a report that was sent to an HTML destination, rather than to a printer.
The first five fields in the report_descripts table are shown with examples as follows:
|
report_name (text) |
report_table (30 char) |
report_category (text) |
report_owner (User ID) |
report_type (1 character) |
|---|---|---|---|---|
|
name of criteria November Cash Receipts Detail |
table name november_cash_ |
report group Financial & Giving |
User ID - who created it kfs |
U(ser) |
|
name of template Cash Receipts |
table name template_cash_ |
report group Financial & Giving |
dbo (always) |
T(emplate) |
|
advanced search kfs_query |
table name kfs_query |
na |
User ID - who owns it kfs |
Q(uery) |
|
HTML output November Cash Receipts Detail |
none |
report group Financial & Giving |
User ID - who ran it kfs |
V(iew) |
At the top of the Run Reports page, where the saved reports are listed to be run, there are seven fields stored in the report_descripts table that are displayed. This gives the user the ability to sort on certain information making the reports easier to find. The seven column headers with examples are as follows:
|
report_name (text) |
report_owner (User ID) |
report_created (date) |
report_run_date (date) |
report_run_user (User ID) |
report_export_table
|
report_format_name (text) |
|---|---|---|---|---|---|---|
|
name of saved criteria
kfs roster single line test |
User ID - who created it
kfs |
date when the report was created 2004/05/28 |
date when the report was last run 2005/06/13 |
User ID - who executed the most recent run
mjr |
name of the saved export worktable
kfs_roster_test |
Crystal report format name
ROSTER SINGLE LINE MILL.RPT |
When you use the Millennium Explorer to access the display of an indexed list of criteria to Edit, a report output to View, or a template to use to create New Criteria, the items that appear in each of those situations are taken from the first field in the report_descripts table. The Explorer will only display those items with the appropriate character in the report_type field for each of those functions.
In the case of an Advanced Search table, each user can own one such table and therefore the report_descripts table could include one row for each user's current Advance Search criteria table. (Each time that user executes a new Advanced Search, the criteria overwrite the previous advanced search criteria for that user.) The name of that table is system-generated and does not display to the user.
The report_descripts table includes twenty additional columns, that are used exclusively by the criteria tables (Type = U). These fields provide the details for the Report Information page for a saved report criteria, consisting of the following:
| Column | Description |
|---|---|
|
report_created |
The date on which the report was created. |
|
report_edit_date |
The most recent date on which the report was edited. |
|
report_edit_user |
The User ID who made the most recent edit. |
|
report_run_date |
The date of the most recent run. |
|
report_run_user |
The User ID who executed the most recent run. |
|
report_select_time |
The amount of time spent performing the selection, the last time this report was run. |
|
report_format_time |
The amount of time spent by the 3rd party formatting software, the last time this report was run. |
|
report_total_time |
The sum of the select, format, and export times, the last time this report was run. |
|
report_records |
The number of rows that were initially selected, minus any that were removed according to duplicate, spouse, and deceased removal options. |
|
report_export_time |
The amount of time spent building the export worktable, including name formatting time. |
|
report_export_owner |
The User ID who owns the export worktable. |
|
report_export_table |
The name of the saved export worktable. |
|
report_export_dbase |
The database where the export worktable is stored. |
|
report_groups |
The code from the Report Group lookup table entry associated with this row. |
|
report_mgp1 |
The code for the information in the Maintenance 1 field from the Report Group lookup table entry associated with this row. |
|
report_mgp2 |
The code for the information in the Maintenance 2 field from the Report Group lookup table entry associated with this row. |
|
report_agp1 |
The code for the information in the Access 1 field from the Report Group lookup table entry associated with this row. |
|
report_agp2 |
The code for the information in the Access 2 field from the Report Group lookup table entry associated with this row. |
|
report_descriptions |
The free text description associated with this set of criteria. |
|
report_format_name |
The crystal report format name associated with this set of criteria. |