IT is correct that there can be multiple record series within a single database.  When this occurs there a few options available when applying retention periods.  Among those options are the obvious - retaining the record (line of data in the database table) for the longest of the retention periods (most simple to apply), to surgically purge data from each record at the end of the retention period for those elements, and many others in between.  When choosing an approach, you should analyze the costs, the risks of keeping data longer than required, and any other factor you might uncover in the research.

As usual this answer is full of', "It depends" but so it goes in our field of work.

Tod Chernikoff, CRM
[log in to unmask] 

From: "Clinton, Mary" <[log in to unmask]>
Sent: Thursday, August 06, 2009 13:57
To: <[log in to unmask]>
Subject: [RM] Records Classification for Databases

Hello ListServ Members!
I am new to the Records Management profession, but not quite so new to the ListServ. This is, however, my first attempt at posting a question to all of the very knowledgeable ListServ members!!! :)
The IT team at my company is advising that there could be multiple record classes for the data contained in a single database. When/if this occurs, how is the records classification for the single database managed? Are you aware of best practices for this? Does anyone have specific experience in dealing with this issue? I would appreciate any assistance you can provide. Thanks!!!
P.S.: I did search the ListServ archives; however, I was unable to find specific information.
Thank you!
Mary L. Clinton, MBA, PMP(r)Director, Records and Information ManagementDistribution Services757.962.6411 (office); 757.233.1963 (fax)Corporate Services Administration, AMERIGROUP Corporation[log in to unmask]

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may include AMERIGROUP member(s) information that is legally privileged. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy copies of the original message.

List archives at
Contact [log in to unmask] for assistance
To unsubscribe from this list, click the below link. If not already present, place UNSUBSCRIBE RECMGMT-L or UNSUB RECMGMT-L in the body of the message.
mailto:[log in to unmask]