FREE ELECTRONIC LIBRARY - Dissertations, online materials

Pages:     | 1 |   ...   | 13 | 14 || 16 |

«Item type text; Dissertation-Reproduction (electronic) Authors DUNN, THURMAN STANLEY. Publisher The University of Arizona. Rights Copyright © is ...»

-- [ Page 15 ] --

Input File Characteristics. A variety of files and file types are typically accessible. These files may be sequential, index sequential, or their organization may depend on a particular data base system. Record types may be of fixed length or of variable length. Records may be grouped in blocks or they may be unblocked. Files may have ANSI standard labels, industry standard labels, non-standard labels or no labels. A system may have to recognize various file marks such as "end of reel II, "end of file", or "end of volume". In some applications, the auditor must specify detail in the client's files which is to be processed by the audit system. The files may be either processed directly, in which case complete specifications for all format detail must be stored in the object computer, or an intermediate file may be prepared, which is in a standardized format.

Media Characteristics. There exist a variety of media on which information can be recorded. This section summarizes media which can be handled by the various systems. Most systems provide flexibil ity for accepting files on cards, tapes, or disks. Variations of media codes, such as tape codes of various manufacturers usually are handled by different versions of software packages.

Basic Functions And Utilities. Includes processing functions, which permit the auditor to analyze client files, and to display client data in a form suitable for analysis by the auditor.

Copying. Although there usually are utility programs available at the clients site, some generalized audit packages provide for file copying capabilities. Detail on systems analyzed are given below. In some cases the copying function includes a selection capability.

Sorting. Sorting refers to the arranging of a set of records in a specified order, according to sort keys. The order may be an alphabetic or numeric sequence. Ascending or descending sequences may be required. Several sort keys may be specified in some systems for one pass operation. In some system sorting is combined with other input, processing or output functions to speed up or to simplfy the auditor's task.

Multiple File Input. Ability to handle multiple files simultaneously on input improves flexibility of the package.

This is useful for the comparison of files, for merging and matching operations. This capability requires the appropriate number of input equipments needed for simultaneous operation.

Merging. This refers to the combining of records of two or more files, that are each in the same sort order, into one file, in that order. Merging is useful for making files more understandable to the auditor e.g., a vendor name file may be merged with a sales file to provide vendor names rather than vendor codes to the auditor.

File Validation. File validation refers to the checking of data for correctness, or compliance with applicable standards, rules and conventions. Copies of files can be validated through bit-by-bit comparison with a master file.

Discrepancies can be indicated and system reaction can be programmed.

File Matching. Matching of files permits the determination of identity of records or files. Duplicate records can be identified in one file, or by comparison of~~ files~ Numerical And Logical Operations. Auditing software provides assistance to the auditor in the evidence gathering process.

The auditor collects data from client's files, and puts these data in a form which permits analysis and auditing. Both during the collection process and during the analysis of the data numeric and logical processes are used to combine fields, to compare fields, and to summarize and select data.

Arithmetic operations such as addition, subtraction, multiplication and division are available. Other capabilities are the counting of records, simple computation of percentages, and computation of standard deviations. Relational operations permit comparison of magnitudes of numeric fields on the basis of operators such as equal to, not equal to, greater than or less than and combinations of these. Logical capabi 1ities include AND, OR, and NOT operations, and a conditional operation similar to IF.•.• THEN.

Arithmetic Operations. Arithmetic operations such as addition, subtraction, multiplication and division are available. Other needed capabilities are the counting of records, simple computation of percentages, and computation of standard deviations.

Relational Operations. Relational operations permit comparison of magnitudes of numeric fields on the basis of operators such as equal to, not equal to, greater than or less than and combinations of these.

Logical Operations. Logical capabilities include and, or, and not operations, and a conditional operation simi lar to IF •••. THEN.

Classification. Under this heading are grouped several.

functions which permit assignment of records into a set of predetermined classes. The two most common \'Jays are stratification and aging. Classification permits the auditor to separate records or information into sets which then can be examined according to different criteria. It may be required to examine all disbursements above a certain dollar amount, but to only sample those below that amount.

Stratification. Stratification is defined here as the separation of records into sets of classes. Stratification may be based on dollar amounts, or dollar ranges, in which case these ranges must be specified by the auditor. Often the system provides a set of ranges as a default capability.

Stratification may also be based on account classifications, or other criteria.


Aging refers to the placing of records into ranges on time based criteria. As an example all records may be classified into those from 0 to 3 months old, 3 to 6 months old, and older than 6 months.

Selection. The auditor selects those records from client files, which are of special interest to him. Selection may be based on record attributes, such as account number, vendor number, plant location etc., or it may be based on dollar range or account ranges, as defined during the classification process. Selection may also occur by means of sampling.

Sampling may be done on a periodic basis, i.e. every tenth record may be selected, or it may be done on a random basis.

Selection criteria may be combined by means of logical or relational operators. Selection may also occur on a temporary variable (a field produced as a result of an arithmetic calculation).

Summarization. Summarization refers to the summing of numeric totals, or subtotals, for items with common attributes, such as account number, vendor number etc. For purposes of internal control it is necessary to count and report total number of records. Summarization is used by the auditor to consolidate information of interest, which is fragmented in different files and records.

Diagnostic And Control Capabil ity. In this section the basic diagnostic capability of the software package is discussed.

Certain controls need to be exercised as part of an audit to assure integrity, and to maintain accuracy of the data. This pertains to the physical tape, the processing and the records resulting from the processing.

Report Preparation Capability. For many routine applications standard report formats are practical, and require only a minimum of specification. For ad-hoc reports, or one-time applications, report formats must however be flexible and must be easy to adjust. Points to be considered are number and widths of columns in reports, number of lines, heading and footing formats. Automatic editing capability with regard to dollar signs, commas and decimal points, zero suppression,. etc., if required. Functions which are necessary for internal control and maintenance of an audit trail are automatic line numbering, page numbering, record numbering, the counting of records, and the provision of control totals as required by the auditor. Another feature often provided is the ability to generate confirmation notices. Often provision for printing of mailing labels is also provided.

The NBS document compares the above capabi 1ities and features for seven general ized audit packages. A synopsis is provided below which provides a brief description of each of the packages. For the features of each package, the NBS document is referenced.

AUDITAPE. The system was originally developed in 1965 for internal use by a CPA firm in its audit practice. Based on its own experience and comments from clients the system was adapted for external use and is offered to clients and other organizations. A variety of tapes are available geared to vari ous makes of computers and to specific operat i ng systems.

There are approximately 600 users, including city, state and federal agencies.

The system has been prepared for several makes and types of machines, including sets of programs specially prepared and programs furnished by the manufacturers. Auditapes are in mach i ne 1anguage. Three different types of programs convert cl ient fi le reocrds into a standard Auditape format. IBM 1400 and Honeywell 200 machines use the basic edit program, DOS uses the manufacturer's utility, and as and DOS/VS use the expanded edit program. A set of specialized programs manipulate these standardized files and produce the desired output.

DYL 260. System offered since 1973, over 600 installed.

Listed in Datapro directory of commercial packages, won 1975 Datapro Award of Merit based upon satisfactory responses from user survey. Used by General Accounting Office and Veterans Administration.

A report writer, data manipulator, and file utility program, written in assembly language, and meant to be cataloged and used on the host computer. Required processing.

is controlled by simple parameters input on cards.

EASYTRIEVE. Initially installed in 1969. Rights acquired by present vendor in 1973. Over 750 systems installed as of December 1975. Version 6 released December 1975. Listed in Datapro "Hall of Fame". Currently in use in US Department of Cormnerce, US Department of Agriculture, and other Government agencies.

The system is written in assembly language and produces an audit report. It is a load-and-go system, and does not require intermediate program production and compilation. Options are available for interfacing with data base systems such as IMS and TOTAL. A CALL command permits use of auditor-written higher level language subroutines. A macro processor command processor permits use of auditor-defined macro routines.

EDP-AUDITOR. First installation was in 1970. Over 350 systems are installed in the U.S. and over 400 world-wide. Significant installations: Montgomery County Government, Rockville, Md., Federal Reserve Banks of Chicago, Dallas, Richmond, and San Francisco, Philadelphia, and Minneapolis; National Automobile Dealers Association, McLean, Virginia.

EDP-AUDITOR is written in assembly language and produces an object code program which is executed to produce the audit listing. This type of system is a load-and-go type system. Up to 256 input files and 100 output files or reports can be specified. A library of routines is available supporting six auditing areas: file footing-control; exception analyses;

summary analyses; special processing routines; confirmation of accounts; and selection and sampling. EDP-AUDITOR consists of the CULPRIT system plus the library of audit routines.

Interfaces are available for data base management systems such as IDMS, IMS, DLl, TOTAL, DATACOM/DB etc., as well as for the TSO, complete cataloging and macro facility and exits are provided to user written programs.

HEWCAS. Software development started in 1972 at the HEW Audit Agency. Was first available in 1973. Released for general use 1 ~uly 1974. Has been installed at US Civil Service Commission, HEW Audit Agency, US Department of Labor, US Department of Commerce, and the US Government Printing Office.

HEWCAS is written in the BASIC programming language, and produces COBOL programs which can be compiled and ~xecuted on various machines, the user is prompted for the input specifications. Two simultaneous files can be handled on input, with any combination of media. Up to 91 simultaneous outputs are possible (one printer and 90 disk or tape files).

No user written routines can be used, but produced· COBOL programs can be saved. External program linkages are only possible by modification of the COBOL program.

MARK IV/AUDITOR. First delivery of Mark IV was in 1968. More than 1000 systems have been installed in the US and in other countries. AUDITOR is a special feature and was first introduced in 1976. Mark IV/AUDITOR has been installed at ERDA in Germantown, MD.

MARK IV/AUDITOR is written in assembly language and produces an assembly language program which is executed to produce results. The system can be considered a IIload-and-go ll system. It consists of the Mark IV system and the library of audit routin~s. Mark IV handles various data processing consideratioil~. in a manner transparent to the auditor. The auditor specifies the fi 1e characteristics and functions to be performed by fill ing out worksheets, which are translated into parameter cards. Standard file types and data bases are automatically supported, multiple files coordinated and up to 255 reports produced in one pass of the file. The auditor can sample, select, compute and report by specifying selection criteria and custom reports or by utilizing the library of audit routines. The library includes routines for aging, confirmation notices, random sampling, monetary sampling, stratification and grouping amoung others.

SCORE. First introduced in 1969. SCORE III in January 1970, SCORE IV in March 1972. Over 400 systems installed. Some Washington DC area installations include HUD, Maritime Administration, Department of Agriculture.

The system is written in COBOL and generates COBOL programs as output. Program generation is governed by about thirty different keywork parameter cards, of which generally only a few are necessary for any given run. The vendor states that IIno superfluous PROCEDURE DIVISION CODE is generated, so that programs are only as long as they need to be". The user can insert his own COBOL code at almost any point.

Pages:     | 1 |   ...   | 13 | 14 || 16 |

Similar works:

«Public Disclosure Authorized 92618 Public Disclosure Authorized FINANCIAL SECTOR ASSESSMENT VIETNAM JUNE 2014 Public Disclosure Authorized FINANCIAL AND PRIVATE SECTOR DEVELOPMENT VICE PRESIDENCY EAST ASIA AND PACIFIC REGIONAL VICE PRESIDENCY THE WORLD BANK A joint mission from the World Bank (WB) and the International Monetary Fund (IMF) visited Vietnam in October 2012 and January 2013 to conduct the assessment of the Vietnamese financial system under the Financial Sector Assessment Program...»

«A Guide to Sixth Form Courses 2013/14 Contents Foreword.......................................................... 2 Introduction........................................................ 3 Advice and Information............................................... 4 Careers Experience Scheme..............................»

«CAMPAGNE MONDIALE POUR L’ABOLITION UNIVERSELLE DE LA PEINE DE MORT DOSSIER DE PRESSE UN ENGAGEMENT FRANÇAIS La peine de mort n’est pas la justice, c’est l’échec de la justice. La peine de mort n’est pas un instrument utile à la lutte contre la criminalité. La perte de vie humaine qu’elle entraine est irréparable et aucun système juridique n’est à l’abri d’une erreur judiciaire. Le recours à la peine de mort n’est pas un simple instrument de politique pénale, c’est...»

«RAPPORT SPÉCIAL Mission conjointe d’évaluation des récoltes et de la sécurité alimentaire au Niger 20 janvier 2011 ORGANISATION DES NATIONS UNIES POUR L'ALIMENTATION ET L'AGRICULTURE, ROME PROGRAMME ALIMENTAIRE MONDIAL, ROME -2Le présent rapport a été établi par Jean Senahoun, Cheikh Ndiaye, Abdoul Malick Haido, Oua Saidou pour la FAO et Lawan Tahirou, Koffi Akakpo et Bouabacar Idrissa Kountche pour le PAM, sous la responsabilité des secrétariats de la FAO et du PAM à partir...»

«Gunner and Baker Continuum Electrostatics Approaches to Calculating pKas and Ems in Proteins MR Gunner and Nathan A. Baker Physics Department, City College of New York in the City University of New York 160 Convent Avenue, New York NY 10031. Email: mgunner@ccny.cuny.edu Computational and Statistical Analytics Division, Pacific Northwest National Laboratory; Division of Applied Mathematics, Brown University. Email: nathan.baker@pnnl.gov Gunner and Baker Key words: Dielectric constant,...»

«FPO 34 S 2 5 6 F-19649873 1711 PRODUCT INFORMATION ® CLARITIN brand of loratadine TABLETS, SYRUP, and RAPIDLY-DISINTEGRATING TABLETS DESCRIPTION Loratadine is a white to off-white powder not soluble in water, but very soluble in acetone, alcohol, and chloroform. It has a molecular weight of 382.89, and empirical formula of C22H23CIN2O2; its chemical name is ethyl 4-(8-chloro-5,6-dihydro-11H-benzo[5,6]cyclohepta[1,2-b]pyridin-11-ylidene)-1-piperidinecarboxylate and has the following structural...»

«Milligan, Steven George (2010) Candidosis management: antifungal, cytotoxic and immunomodulatory properties of tea tree oil and its derivative components. MSc(R) thesis. http://theses.gla.ac.uk/2282/ Copyright and moral rights for this thesis are retained by the author A copy can be downloaded for personal non-commercial research or study, without prior permission or charge This thesis cannot be reproduced or quoted extensively from without first obtaining permission in writing from the Author...»

«Generation of real algebraic loci via arXiv:1510.05464v1 [math.AG] 19 Oct 2015 complex detours Stefan Kranich∗ 20 October 2015 Abstract We analyze the locus generation algorithm of the dynamic geometry software Cinderella, and examine how it uses complex detours to resolve singularities. We show that the algorithm terminates if its step width is small enough. In this case, the algorithm is independent of the orientation of its complex detours. We introduce a variation of the algorithm that...»


«Gleanings Columbia District United Methodist Women June 2014 Columbia District 42nd Annual Meeting Theme: September 20, 2014 Union United Methodist Church 7582 Woodrow Street Irmo, SC 29063 (803) 781-3013 What’s Coming Up. June 17 Registration:  Columbia District Executive 8:15AM – 9:00AM Committee MeetingUnion UMC, Irmo, SC Program: July  9:00AM Rural Mission, Inc. Special Emphasis Month Keynote Speaker: July 24-26  Rev. Mallory Forte Mission u – Spartanburg Methodist College,...»

«       The City of Muskogee encourages participation from all its citizens in public meetings. If participation is not possible due to a disability, notify the City Clerk, in writing, at least forty-eight hours prior to the scheduled meeting and necessary accommodations will be made (ADA 28 CFR/36). (Public Comment during Public Hearing or Agenda item comment) Council Rules of Decorum limit citizen comments on agenda items and public hearings to five (5) minutes. Any person desiring to...»

«Praise for Wasted Prayer For years, I’ve helped people figure out what they should do with their lives. One of the biggest roadblocks is the fear of moving forward when you should be waiting on God. I’m extremely thankful that my friend and fellow thought leader Greg took on this challenge in this great book! —Jon Acuff, New York Times best-selling author of Start and Stuff Christians Like Greg Darley has spent his life in pursuit of the things that matter most. This book is a manifesto...»

<<  HOME   |    CONTACTS
2016 www.dissertation.xlibx.info - Dissertations, online materials

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.