anonymous translation

[atthevilla]

Crystal 10 Oracle 10. Looking for ideas. I need to create a translation table of constituent IDs and anonymous dummy record IDs that will allow me to combine the constituent donations into the anonymous record donations and show the total as one anonymous donor in a Crystal report grouped by ID. This relationship is not recorded in the database due to fear that users would be able to identify anonymous. I'm thinking of a table like

Anon_ID Real_ID
00077 00001
00088 00002
00099 00003

If Real ID 00001 is a donor, then credit his gifts plus all gifts from Anon ID 00077 and display total under the 00077 Anon ID and nothing under 00001. If possible, I want to avoid making a report-specific formula; I'd rather have a table that can be updated as needed. There will probably not be more than a dozen of these cases.

 

[hilfy]

One way I can think of to do this would be to have a set of Views created in the database for reporting for every table where you need to translate Real_ID to Anon_ID. The views would use some formula for every record to translate the Real_ID to an Anon_ID. For the table where the Real_ID is related to a donor, you either leave it out of the views or you have the view only include a subset of the fields that doesn't include the donor name or other identifying information.

If you don't give access to the tables with the Real_ID value to the user id(s) you use for reporting, but do give access to the views, then the users will not be able to get to the real donor identifying informaton.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.