Audit trail of masterfile changes

[Art, Clifford]

We want to give the users an enquiry screen that clearly shows what was
changed and when.
With 50 fields on a masterfile its not really practical to use the audit
file. All
the masterfile fields have to be on the one record and there could be dozens
of records 
with changes to different fields. I don't thinks it possible to give enquiry
access to an audit file
so that the users can clearly see what's changed and when.

Clifford Art

>-----Original Message-----
>Perhaps I'm missing something, but surely by using a PH audit file, the
>previous 'after' image of a record is your current 'before' image, so that
>the data is already captured on your system? Why do it twice? (unless you
>have some none PH programs updating your data.
>
>Steve Dickens
>Deputy Training Manager
>Cognos UK.



> ----------
> From: 	Art, Clifford[SMTP:cart@metropolitan.co.za]
> Sent: 	07 May 1999 11:11
> 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.