[193] in iswork
Getting activity information into IS Work
daemon@ATHENA.MIT.EDU (Robert Ferrara)
Fri Jan 5 16:52:29 2001
Message-Id: <4.3.2.7.2.20010105155605.00bad9f0@po9.mit.edu>
Date: Fri, 05 Jan 2001 16:54:52 -0500
To: itlt@mit.edu
From: Robert Ferrara <rferrara@MIT.EDU>
Cc: iswork@mit.edu, verbeek@mit.edu
In-Reply-To: <3A53793F.667E13D2@mit.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Hello,
At yesterday's ITLT meeting we discussed moving ahead with populating the IS-Work database with Activities from the data collected in the Profiles for the Budget Proposal. Tim McGovern and company will now proceed to do this per the proposal below.
So in a few weeks, there should be about 50 more Activities to go along with those Allison has already manually entered for CG. Once they are entered, however, there will be some cleanup work - principally for Service and Support - to add values in the "new" unmapped fields such as Practice, Priority, Status, etc. that Tim notes in the message below.
This cleanup should not be a huge amount of work, but it will require several hours of knowledgeable people time. We - Tim, Kris, and I - can help and will be discussing with Nate and Roger how best to do this in the weeks to come.
Thanks, Bob
At 02:10 PM 1/3/2001 -0500, Tim McGovern wrote:
>Bob / Dani,
>
>Please review the following proposal that Kris and I have put together, and give
>us your feedback, questions and comments. Once we have your go-ahead, we will
>meet with Phil to get the process started.
>
>Phil would populate an Excel spreadsheet which contains four (see note below)
>columns of information, and one row for each business plan. We will map the
>business plan fields into these four columns as follows:
>
>Business Plan Field -> IS Work / Activity Field
>----------------------- ------------------------
>Name & Cost Center Activity Name
>Purpose + Work + Goals Description
>Vision Justification
>Customers Customers
>
>Note: if any of the following IS Work fields are easily knowable (by ISVP) and
>therefore enterable by Phil, we could add additional column to the Excel spreadsheet:
>
> Unmapped IS Work / Activity Field
> ---------------------------------
> Practice
> Priority
> URL
> Status
> Responsible Person
> Sponsor
> Process
>
>It would seem that Practice, Process or Responsible Person might be the most
>likely candidates...but I will leave that to you all to decide.
>
>Once Phil has a spreadsheet with all of the business plans in it, he will send
>it to <knyzio@mit.edu>, who will bulk load the data into the database. At that
>point, there will still be maintenance required, to fill in any of the fields
>above that are relevant, and then to link individual activities to their
>relevant initiatives. I believe that such entry/linking is properly the
>province of the ITLT member who is responsible for the activity.
>
>Tim
