I see no value in not deleting from the original source. I know that option is available but I could never understand why you would want to do that. I am sure there are some who could justify it. We just don't do it. We delete from Source after coping to the Archive.
Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SUBSCRIBE arslist Melissa Sent: Wednesday, June 10, 2009 9:41 AM To: arslist@ARSLIST.ORG Subject: Re: Archiving and reporting/searching? ** Thanks for the info Chris. I would assume we would do the archive to delete from original. What is the value of archiving, but not deleting? (maybe I'm missing something). Wouldn't it still search all the data in the original form if it weren't deleted? "Pruitt, Christopher J" <christopher.pru...@eds.com> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 06/10/2009 09:32 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Archiving and reporting/searching? If you are using the imbedded Archiving solution for AR System and you are doing an Archive Type of 'Copy to Archive', then creating a join does not make since because the data would still be in the original data form, so no need to a join. However, it you are doing a 'Copy to Archive and Delete form Source' then building a join is a good idea, however, doing a Join and choosing "Request ID" as the join criteria would not work. The problem is when the data moves to the Archive form the "Request ID" form the original data form is copied into a field called " Original Request ID" and the "Request ID" on the Archive form would never match the "Request ID" on the Original data form, as it gets a new "Request ID" when the record is moved to the Archive. Second, for a join on fields to work there has to be matching data in those fields on both forms. What we did was to include a field called "Form Name" that held the name of the original data form in it and then we did the join criteria on that field. However, you really need to be careful on doing reports off of this join form. I will give you duplicates. For example on one of the Data form to Archive form joins we have the following counts: A_Test_Data: 4,450,400 A_Test_Archive: 34 A_Test_JN: 151,313,600 If you do the math the 151,313,600 equals 4,450,400 x 34. So you really need to make sure when you are doing reports to use a lot of qualifications to eliminate getting duplicate records returned. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of jham36 Sent: Tuesday, June 09, 2009 4:13 PM To: arslist@ARSLIST.ORG Subject: Re: Archiving and reporting/searching? I don't think it matters. You can choose any field. I have not tested it, but it should work and should be easy for you to test. I would choose RequestID as the join criteria and an inner join. On Jun 9, 4:41 pm, SUBSCRIBE arslist Melissa <melissa.r...@stls.frb.org> wrote: > What would you use as the join critieria? > > jham36 <jha...@gmail.com> > Sent by: "Action Request System discussion list(ARSList)" > <arsl...@arslist.org> > 06/09/2009 03:39 PM > Please respond to > arsl...@arslist.org > > To > arsl...@arslist.org > cc > > Subject > Re: Archiving and reporting/searching? > > How about a join form between the live data and the archived data? > Perform all searches and reports against that. > > James > > On Jun 9, 3:32 pm, SUBSCRIBE arslist Melissa<melissa.r...@stls.frb.org> wrote: > > We are starting to look into how to handle archiving and are running > into > > road blocks with how to be able to search/report on all the data, but > > still archive old data. What are other organizations doing? Does > anyone > > have any white papers or such they can share? We are using ARS 7.1. > > > TIA! > > Melissa > > ________________________________________________________________________ _______> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers > > Are" > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"