Legler Systems Company | DB Reports | Contact Us | Help | Home |

Database Control System Reports:

The Database Control System reports can be requested at any time and printed on a standard line printer or a laser printer. Most DB reports are 120 characters wide (landscape), while some control reports are 80 characters wide (portrait). Also, the DB reports can be written to a temporary disk file for subsequent viewing in a separate window by using procedure 92V or 92W.

The primary database control reports are Code Definitions Report, User Control Report, Company Control Report, User Activity Report, Transaction Audit Report, Database Dump Control Report and Database Restore Control Report. Each of these standard reports have several variations based on selection parameters entered online by the user. The 27 audit and management reports printed by the Database Control System from Legler Systems are listed below.

     PROC S  B   DB Report name and description
      --  -  -   ---------------------------------------------------------
  1.  02  N  Y   Code Definitions Report by code type (4)
  2.  04  N  N   Database Control Report - Update Global Control Record
  3.  05  N  N   Database Dump Control Report by system date range
  4.  05  N  N   Database Dump Control Report by record type (4)
  5.  05  N  N   Database Dump Control Report for export
  6.  06  N  N   Database Restore Control Report by system date range
  7.  06  N  N   Database Restore Control Report by record type (4)
  8.  07  N  Y   Database Records List by system date range
  9.  07  N  Y   Database Records List by record type (4)
 10.  09  N  Y   User Control Report by user-ID (4)
 11.  09  N  Y   User Control Report by system-ID (4)
 12.  09  N  Y   User Control Report by department (4)
 13.  10  N  Y   Company Control Report
 14.  11  N  N   File Load Control Report
 15.  11  N  N   Terminal Elements Report by system-ID (4)
 16.  11  N  N   Help Messages Report by system-ID (4)
 17.  11  N  N   Error Messages Report by system-ID (4)
 18.  11  N  N   Data Dictionary by system-ID (4)
 19.  11  N  N   Program Definition Report by system-ID (4)
 20.  12  Y  Y   User Defined Report (5)
 21.  13  N  Y   User Activity Report by activity date range
 22.  13  N  Y   User Activity Report by system-ID and procedure (4)
 23.  13  N  Y   User Activity Summary of elapsed time by procedure (6) 
 24.  15  N  Y   Transaction Audit Report by system date range
 25.  15  N  Y   Transaction Audit Report by format code (4)
 26.  15  N  Y   Transaction Audit Report by user-ID (4)
 27.  15  N  Y   Transaction Audit Report of deleted records.

--------------------------------------------------------------------------
Notes:
 1.  Column "PROC" refers to the online procedure number on the DB menu.
 2.  Column "S" means sort by code number, code name or Alphasort when
       'Y', otherwise 'N' means no record sorting.
 3.  Column "B" indicates both online processing and batch job processing
       is available when 'Y', otherwise 'N' means no batch processing,
       only online processing.
 4.  These DB reports can be printed for a single code or all codes.
 5.  Any data field within any data record can be selected, sorted and
     printed by this general report writer program.
 6.  Summary reports are printed when the 'Entry Correct' prompt = 'S'.
--------------------------------------------------------------------------

The online DB procedures that print these reports are described in the Database Control Menu document.

More Information on the DBS Software:

To receive sample Database Control System reports, e-mail Bill Legler in the SF Bay Area, California or go to the Database Control System main page.
Version 11.5 (2015). All rights reserved by Legler Systems Company.