| Legler Systems Company | | | DB System | | | Contact Us | | | Help | | | Home | | |
The Database Control System from Legler Systems contains basic support procedures that identify and maintain the users, codes, and other overall system options associated with any of the online accounting modules from Legler System. Generally, access to this control system is reserved for supervisory personnel.
Online database control (DB) procedures are identified on the Database Control Menu as shown below. Before any computer procedure can be run, the user must first sign-on by entering a valid User-ID and password. To start a specific DB procedure, enter the 2-digit number associated with that procedure.
DATABASE CONTROL MENU:
------------------------------------------------------------------------- | DATABASE CONTROL SYSTEM MENU (2005) 01-31-2005 11:04 | |=========================================================================| | | | No Procedure Name No Procedure Name | | -- -------------------------------- -- --------------------------- | | 01 - Enter Code Definition Records 10 - Print Company Control Report| | 02 - Print Code Definition Report 11 - Load And Print Support Files| | 03 - Enter Company Control Record 12 - Print User Defined Report | | 04 - Update Global Control Record 13 - Print User Activity Report | | 05 - Dump Master File To History 14 - Inquire Active Users | | 06 - Restore Master File From History 15 - Print Transaction Audit Rpt | | 07 - Print Master File Records 16 - Inquire Pending Batch Rqts | | 08 - Enter User Control Records 92 - Redefine System Printer | | 09 - Print User Control Report 99 - End DB Menu | | | | Enter DB Procedure Number......[ ] | | | |=========================================================================| | F1=Help F2=Enter F9=Print F10=Exit | -------------------------------------------------------------------------
Data entry procedures DB01, DB03 and DB08 display fields that comprises each record and perform online file update functions (add, modify and delete). The Company Control Record (DB03) defines the current and prior accounting period, special sequence counters for assigning voucher numbers, as well as other important system options. The User Control Record (DB08) defines each user and what computer procedures within an application that user can have access to. The Code Definition Record (DB01) defines each type of code and code value (e.g. account code) that can be entered online by the user.
Online DB software reporting procedures DB02, DB07, DB09, DB10, DB13 and DB15 print reports online printers (computer-size paper) or laser printers (letter-size paper). Each reporting procedure displays a screen for the user to enter selection criteria, report formatting and sorting options. Procedures DB04, DB05, DB06 and DB11 print a one-page control report showing the number of records processed for audit trail purposes. The User Defined Report (DB12) is a general report writer where the user defines the content and format of any report.
Inquiry procedure DB14 displays either active users currently on the system or all users that can possibly access the financial systems.
Load Support Files procedure DB11 reads standard text files (that can be changed with most any editor) containing the definitions of all data fields (DBSFMT), of online help messages when function key F1 is pressed (DBSHLP), and of programs and file specifications used to create the Global Control Record (DBSPGM). Procedure DB04 allows the user the capability to change temporarily the file specifications online.
Redefine system printer procedure DB92 allows the user to redefine where the reports are to be printed. If a disk file is specified, the report is written to disk from which it can be displayed in a pop-up report window (92V) and then printed on paper by pressing function key F9.
DATABASE CONTROL SYSTEM FEATURES:
In addition to the operational, security and technical features mentioned in the Accounting Software Summary, some key functional features of the DB System software are highlighted below:
1. Allow the operator to define codes and control options that affect how the various financial modules function.
2. Identify each user and what procedures each user has the authority to execute, as well as reporting on what procedures a user performed and how long they procedure took.
3. Monitor changes to the online master database though transaction logging so that deleted records can be identified and reported.
4. Flexible reporting capability allows the user to request and print 27 different database control reports, including a general report writer procedure (DB12).
FILE SPECIFICATIONS:
The master database (DBSMST) contains the detail records for all the financial systems and is an indexed sequential file where each data record is identified by a unique key. Up to five alternate keys are also defined to provide alternate paths to quickly access data in the file thereby reducing the number of disk I/Os when printing reports. For example, one alternate key is the system date which can used to query detail records chronologically in descending date order.
Support files in the financial systems are:
1. Transaction Log File (DBSTRN) contains records that were deleted or modified online.
2. User Log File (DBSUSR-indexed) contains the date, time, and report parameters for each procedure a user executed.
3. Backup History File (DBSHST) is a sequential file containing duplicate records from the master file after the dump by DB05.
4. Transfer File (DBSTFR) is used to pass records between systems.
5. Format File (DBSFMT-indexed) contains the screen prompts and field names used by the data entry procedures.
6. Program File (DBSPGM-indexed) contains the program names and location associated with each procedure in each accounting module.
7. Help File (DBSHLP-indexed) contains text messages that appear in a pop-up help window whenever function key F1 is pressed.
8. Report Work File (DBSRPT) and Report Sort File (DBSSRT) are temporary work files used when sorting records used to print a report.
HARDWARE AND SOFTWARE REQUIREMENTS:
The Database Control System (DBS) runs on any compatible 386 or higher PC or UNIX based computer, such as the IBM RS/6000 with IBM 3151 terminals using the AIX operating system. The DBS software operates on personal computers running all versions of Windows from Windows 3.1 to Windows Vista in a local area network (LAN) using Microsoft BackOffice Server, NetWare or LANtastic with complete flexibility in specifying the location of all files on the client or server. The Run Time Environment for Micro Focus COBOL support is included at no extra cost with the DOS executable programs of the DBS COBOL software.
This Database Control System is required to support any of the other online accounting modules from Legler Systems. The DB source programs are written in COBOL for easy maintenance and portability. More business software is written in the COBOL language than any other programming language. All DB COBOL programs are Year 2000 compliant and allow the user to define different date formats (MO-DA-YR or YRMODA) for data entry and reporting purposes.
MORE INFORMATION AVAILABLE:
To request all sample reports and screen formats, a General Information Manual or PC demo on CD-ROM of the DB System, please e-mail Bill Legler in the San Francisco Bay Area, California.
New software features are described in the Version 8.0 Summary document.
The DB System software cost is identified in the Software Price Sheet.
Custom versions of the DBS software have been in day-to-day operation for the past 25 years.