We are decreasingly creating custom tables. Over the last 4 years or so we will build a form/table using Dev Studio so we can manage it with Remedy but we might be building it with a DB integration in mind. We will turn off Status History or create a stored procedure that creates the H record in addition to the values of the core fields. In the cases where we do build a custom table or view we do it in a db space that is right next to ARSystem. We are working on keeping everything in ARSystem managed by Remedy and everything else in the resources DB.
Jason On Thu, Sep 12, 2013 at 1:08 PM, Brian Goralczyk <bgoralc...@gmail.com>wrote: > ** > I have worked on jobs that only created the tables directly in the DB and > never let Remedy create them. I think this is extreme, but there are MANY > reasons to manually create DB tables and I have created more than my share. > > Brian Goralczyk > > Brian Goralczyk > Phone 574-643-1144 > Email bgoralc...@gmail.com > > > On Wed, Sep 11, 2013 at 5:48 PM, Longwing, Lj <llongw...@usgs.gov> wrote: > >> ** >> Agreed, >> I have created db tables/views in the past to suit various needs of the >> customer. >> >> >> On Wed, Sep 11, 2013 at 3:09 PM, Grooms, Frederick W < >> frederick.w.gro...@xo.com> wrote: >> >>> Depending on what is needed Yes we do have direct Oracle tables and >>> views in the same tablespace as the ARSystem data. >>> >>> Fred >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] On Behalf Of John Sundberg >>> Sent: Wednesday, September 11, 2013 4:04 PM >>> To: arslist@ARSLIST.ORG >>> Subject: DB usage - adding tables >>> >>> ** >>> Does anybody add tables by hand to their ARSystem tablespace? >>> >>> Examples would be: >>> >>> Custom_Locations >>> Custom_Assets >>> >>> >>> Stuff like that. >>> >>> >>> Then - maybe you create a vendor form to view it??? >>> >>> Just wondering if anybody is doing this kind of thing? >>> >>> >>> -John >>> >>> >>> -- >>> John Sundberg >>> Kinetic Data, Inc. >>> "Your Business. Your Process." >>> >>> 651-556-0930 I john.sundb...@kineticdata.com >>> www.kineticdata.com I community.kineticdata.com >>> >>> >>> _______________________________________________________________________________ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> "Where the Answers Are, and have been for 20 years" >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
