This was a big issue here at Wayne State University when we implemented
Banner in 1999.  Our old system was able to provide the data and was told
no modifications.  However we felt that this was a necessary
modification.  So the request went up the ladder to the Oversight Committee
and was approve as a modification.    The modification we made was to save
the data in a table before the program deletes it.  As a result we are able
to develop reports for both us centrally and our units.

Just this week Wayne State University led a Large Schools and Grant
Management Birds of Feather session at the SCT Summit.   We are putting
together a list of items that came out of that discussion and will add this
to the list.

If you need any additional information you can contact me directly at 313
577-6594

Marlene

At 10:29 AM 4/1/2004 -0500, you wrote:
>Sarah,
>We use Deferred IDC Processing.
>
>You're correct that a .lis file is generated, but that file contains only
>summary information, unless the process is run 'one grant account at a
>time', in which case it DOES show the IDC details.  This approach can indeed
>show me the ifo  I need, but with a large number grant accounts this
>approach is prohibitive in terms of time.  And of course sifting the desired
>information out of .lis text files is a time-consuming task in itself.
>
>The .lis data is also written to a Banner table called FRRGRNC.
>Unfortunately, this table is wiped clean of its data after each run of the
>deferred IDC process.
>
>Obviously taking the info from a Banner table is the approach most people
>would HOPE for, but this appears unworkable.  And, while gathering IDC data
>from .lis logs is certainly possible, it is incredibly time-consuming.
>
>
>Does anyone see a third option?  Or even a way to make theses first two
>options workable?
>
>Has anyone solved this situation in another way entirely?
>
>
>--
>Thanks for your time,
>
>Rich Magyar
>Systems Administrator
>Eastern Michigan University
>Graduate Studies & Research
>734-487-3090
>
>
>
>
>On 04/01/2004 9:28 AM, "Sarah Ber" <xxxxxx@isugw.indstate.edu> wrote:
>
> > Rich,
> >
> > Do you use the Deferred IDC process or does the idc calculate as each
> > transaction is posted?  I don't use the deferred IDC process, but there
> > should be a .lis file from resulting from the  process which may detail
> > how the process summaries were arrived at.
> >
> > Sarah
> >
> > Sarah Ber
> > Director Grants & Contracts
> > Office of the Controller
> > Indiana State University
> > 812-237-3553
> > xxxxxx@indstate.edu
> >
> >>>> xxxxxx@EMICH.EDU 4/1/2004 8:54:37 AM >>>
> > Hi everyone,
> >
> > I have a question about the SCT Banner Database and any institution
> > out
> > there that is using Banner to track Indirect Cost Recovery.
> >
> > I had HOPED for simple data like "FROM, a "TO", and "AMOUNT".
> >
> > Unfortunately Banner doesn't store info like this.  It DOES calculate
> > all of
> > the details, of course, but then it deletes the details once finished.
> > Only
> > monthly summaries remain.
> >
> > Want to to verify WHERE money was transferred?... Too bad.   Want to
> > verify
> > that the money credited into your destination account is correct?...
> > Too
> > Bad.
> >
> > Unfortunately, the lack of details in these fund transfer records
> > leaves us
> > with few options at here at Eastern Michigan University to
> > TROUBLESHOOT
> > possible mistakes or VERIFY or that IDC amounts are arriving in the
> > correct
> > places and correct amounts.
> >
> >
> > I'd be very interested to learn if anyone has found a solution to this
> > problem, and report details of IDC destination/amount for each grant.
> > --
> > Does anyone have an Ad Hoc Report that can list the actual IDC dollar
> > amounts and account numbers involved when Indirect Cost is recovered
> > from
> > each individual Grant?
> >
> >
> >
> > --
> > Thanks for your time,
> >
> > Rich Magyar
> > Systems Administrator
> > Eastern Michigan University
> > Graduate Studies & Research
> > 734-487-3090
> >
> >
> > ======================================================================
> > Instructions on how to use the RESADM-L Mailing List, including
> > subscription information and a web-searchable archive, are available
> > via our web site at http://www.hrinet.org (click on "Listserv Lists")
> > ======================================================================
>
>
>======================================================================
>  Instructions on how to use the RESADM-L Mailing List, including
>  subscription information and a web-searchable archive, are available
>  via our web site at http://www.hrinet.org (click on "Listserv Lists")
>======================================================================

Marlene Grazioli Erno
Director
Sponsored Program Administration
Wayne State University
Phone (313) 577-3726
FAX  (313) 577-5055
E-Mail: xxxxxx@wayne.edu

======================================================================
 Instructions on how to use the RESADM-L Mailing List, including
 subscription information and a web-searchable archive, are available
 via our web site at http://www.hrinet.org (click on "Listserv Lists")
======================================================================