Audit trail of masterfile changes

[Rusk John D]

	Several years ago I had to come up with a way of recording before
and after images to satisfy auditors.  I created an audit file that
duplicated the primary file with the addition of a few fields including
auditstatus and reason for the change. The audit file was declared as
AUDIT-FILE AUDIT WITH PRIMARY-FILE.   I populated the audit file with the
before image by retrieving the primary file  as a designer file under an
alias and putting the records in the audit files using another alias.  The
audit file was then updated with the after image as part of the update
process.  It worked fine on the MicroVax I was using at the time.  It still
works under AIX.

John Rusk

> -----Original Message-----
> From:	Art, Clifford [SMTP:cart@metropolitan.co.za]
> Sent:	Friday, May 07, 1999 3:11 AM
> To:	'POWERH-L@lists.swau.edu'
> Subject:	Audit trail of masterfile changes
> 
> Anyone have a low maintenance method of writing audit trail records to a
> file when users update masterfile records.
> We want to keep the following info on a file so the users can see it:
> user
> date
> time
> masterfile name
> masterfile field
> changed from
> changed to
> 
> We currently call a cobol program in the pre-update procedure passing the
> masterfile record.
> The cobol program reads the original record and compares all the fields
> one
> by one writing 
> the audit trail records. It works but is a lot of work to maintain as our
> masterfiles are
> constantly changing.
> 
> The audit file option doesn't seem to help as it only stores an after
> image
> of all the fields changed.
> Anyone have a better, preferably low maintenance way of doing this...
> 
> PH 7.29.C5 on MPE/iX
> 
> Thanks
> Clifford Art
> cart@metropolitan.co.za
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.