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

Database Control System Reports

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

A new 2018 option (Sys-Opt-44 in DB03) converts all uppercase letters to upper and lowercase letters when database control reports are printed for easier reading.

The standard 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. Some 27 audit and management reports printed by the Database Control System from Legler Systems are identified below.

List of Database Control Reports:

     PROC S  B   Database Control 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 database control reports can be printed for a single Record-type
       or all Record-types.
 5.  Any data field within any data record can be selected, sorted and
     printed by the general report writer procedure DB12.
 6.  Summary reports are printed when the 'Entry Correct' prompt = 'S'.
--------------------------------------------------------------------------
The online procedures that print these database control reports are described in the Database Control Menu document.

More Information on the DBS Software:

Any questions on these 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.8 (2018). All rights reserved by Legler Systems Company.