ࡱ> XZWM bjbj== )HWW!l8L X.2&&&&&&G.I.I.I.I.I.I.$/ 2m.&&&&&m.&&.&j&&G.&G.%+hs,& ڻtv ,s,.0.,X22s,Task Force on Reporting Strategies 01/09/03 Functional Group Questions Team Comments TeamWhat is working well?What is not working well?What data or information barriers are there that hinder or prevent you from getting your job done?What data/information are you currently getting?What data/information are you not currently getting?What suggestions do you have for improvement?Accounting Web reports they are out there, but may not be working well for everyone Queries in Finance not widely used/users arent trained Feeders Daily and monthly processingSystem/Functional problems Encumbrances Grant/Project reporting does not provide what those users need Revenues shows billed but not collected System performance is an issue down time Consistency and data integrity No high-level campus reporting MOBIUS Not user friendly Hard to use Users unaware of availabilityKnowledgeable users Timing/accuracy of feeders Format/presentation of reports are poor Creates rework or dual data entry No effective repository for reports are created centrallyWeb reports QueriesPerformance measures/ratios Position management Fee data by college/schoolEducation/Training on reports we already have Common repository for reports Testing reports/changes make sure users needs are metHREmployees getting paid Single instance ad hoc reporting by technical staff Some reports and queries (developed by technical staff) are being providedCross instance reporting Delivered reports are not adequate Effective dated tables are not good for reporting Due to complexity of data structure, the average user cannot produce a report, i.e. labels No data dictionary and standards Joining tables (PS Query limitations) Effective dating is complex Limited reporting tools available to average userReporting instance access Various reportsData dictionary Ad hoc reporting by end users Management reportsCross instance access easier Improve tools and train users on data access Design and implement data warehouse/data mart structures Create/cultivate technical positions to work with functional  StudentDownloaded data easily accessed by non-technical functional staff Four-campus, mandated reports, written by ˿app/MIS office (so they are all the same) Functional users knowledgeable of data structure and can provide information as needed to technical staff Campuses have the tools for production and ad hoc reporting Web applications Highly technical staff working with users Improvements are not being made in legacy because focus is on PS implementation changes on hold Difficult to hire staff with experience in legacy tools When downloads dont work, refreshed data is not available No ˿appDW refresh on all SIS tables at MU Need to closely define selection criteria Time, due to volume of requests Everything related to student records Some HR data˿appDW HR crosswalk table (SSN, EmplID) HR address dataSystems need to be continuously improved and at the time, understandably, legacy is not With institutional need-to-know, data should be accessible (HR) Academic AffairsFinance/Accounting system Responsiveness of person asked for informationGrants Payroll Added burden we put on HR staff HAMP reportsDo not know what is available Time required for IR to respond to complex ad hoc reportsAlmost nothing, other than pulling FBMO information off web Admissions/exceptions/session Enrollment Faculty work loads End of date on grants Weekly report on account deficits Vacation/sick leave balances Increase documentation requirement on ProcardIRGeneral access to data (IPEDS, etc.) SQRsSecurity (complicated) Integrated reporting capablility Full understanding of table and data structure in PeopleSoft Disseminating of reports Inadequate central response (except for Ben) MOBIUS POC Documentation (absence of whats there and how to use) Security Retaining and integrating data from a variety of sourcesPeopleSoft: GL, Student, Grant Non-PeopleSoft UIDS, ˿appDW, MOBIUSGift information Documentation TrendMake security less ponderous Searchable, quality documentation Exchange of information between users Make sure reports tie Document business processes of users Platform that allows different levels of access to data, use of various tools Drill-down capabilities End/Fiscal UsersHR query (˿appR) Processing electronic JEs Use of classes to certain degreeFinancial reports No encumbrance on IS IS & BU dont balance Cant get encumbrance by class IS Checklist often missing transactions Incorrect encumbrance Encumbrance drill-down YTD Actual drill-down on IS include more than they should Cant print PeopleSoft screens FY02 year-end close!!!!Encumbrances not in format neededShadow (i.e. electronic 60s) programsDeptID reports not in format needed Leave accrual reports do not show current hours processed (just balances and YTD taken) (call Linda for solution) Report of JEs processedTraining whats out there for us to utilize Look at what will truly eliminate shadow systems, i.e. allow for adjusting encumbrances Involve more true end users Fiscal officers communication (campus and system-wide) Attachment A Page  PAGE 6 \6 0JCJmHnHu0JCJj0JCJU 5CJ\CJ5\ 0[\aw%ZFf$If $$Ifa$$a$6>[y & F h$If^` & F U$If^`U u$If$If;ZatQ]e7  & F h$If^` & F U$If^`U7 8 ; 4, .$If$$Ifs֞ ?i'08 n ` *0094 sa; R ? $If & F U$If^`U  C ] m } 1 n o p q r s t u v w x y z  & F U$If^`U$Ifz { | } ~  $If 6T00$If$$Ifs֞ ?i'08 n ` *0094 sa !     n 4TU{$If & F U$If^`UVW$If & F U$If^`UWXi6h0$If$$Ifs֞ ?i'08 n ` *0094 sai F$If & F U$If^`U *+,-./012345678 & F U$If^`U$If89:;<=>?@ABCq & F U$If^`U$If qru6 0$If$$Ifs֞ ?i'08 n ` *0094 sau.[hi&7EKh9ST$If $If^ & F U$If^`UTUVWXYZ[\]^_$If _`q6h 0$If$$Ifs֞ ?i'08 n ` *0094 saqCYt-Q f & F h$If^` & F U$If^`U61,*$a$$a$$$Ifs֞ ?i'08 n ` *0094 sa$a$'&P1h0= /!"#h$h%$$Ifs4֞ ?i'08 n ` * F0094 sa i8@8 NormalCJ_HaJmH sH tH <A@< Default Paragraph Font.>@. Title$a$ 5CJ\.P@. Body Text 2>*,@, Header  !, @", Footer  !&)@1& Page NumberH0[\aw%Z6>[y;ZatQ]e78;R ?C]m}1nopqrstuvwxyz{|}~!        n 4 T U {  V W X i F *+,-./0123456789:;<=>?@ABCqru.[hi&7EKh9STUVWXYZ[\]^_`qCYt-Q f0000000000@000000000000000000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 000000000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 000000000000000000000000 0 0 0 0 0 00000000000 0 00 0 0 0 00 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 000000000000000000000000 0 0 00000000000000000000000000 000 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000@0 0 # 7 ; z Wi8quT_q !"##!m  W^6m  W^lengerbdC:\Documents and Settings\lengerb\Application Data\Microsoft\Word\AutoRecovery save of Document9.asdlengerbvC:\Documents and Settings\lengerb\My Documents\Reporting Strategies Task Force\Functional Group Questions-Appendix.doclengerb~C:\Documents and Settings\lengerb\Application Data\Microsoft\Word\AutoRecovery save of Functional Group Questions-Appendix.asdlengerbvC:\Documents and Settings\lengerb\My Documents\Reporting Strategies Task Force\Functional Group Questions-Appendix.doclengerb~C:\Documents and Settings\lengerb\Application Data\Microsoft\Word\AutoRecovery save of Functional Group Questions-Appendix.asdlengerbvC:\Documents and Settings\lengerb\My Documents\Reporting Strategies Task Force\Functional Group Questions-Appendix.doclengerbxC:\Documents and Settings\lengerb\My Documents\Reporting Strategies Task Force\Functional Group Questions-Attachment.doclengerbsC:\Documents and Settings\lengerb\My Documents\Reporting Strategies Task Force\010903 FG Questions-Attachment A.doc Bob MullenkP:\IRP\decision_support\System Reporting Strategy\Meeting --- 01_09_03\010903 FG Questions-Attachment A.doc<%K<jT O";(pܳ $C &P h ^`OJQJo(h ^`OJQJo(oh pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo( hh^h`OJQJo(^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L. hh^h`OJQJo( hh^h`OJQJo(<%K&PO";jT $C         \aw%Z[Qe78;Cm U W X i F Cqrui&K_`q-@ I @{`@UnknownG: Times New Roman5Symbol3& : Arial?5 z Courier New;Wingdings"1hRq)rqF&rqF$!h90d2Q*Functional Group Questions  Team Commentslengerb Bob MullenOh+'0 0< X d p |+Functional Group Questions Team Commentsdunclengerbengeng Normal.dotG Bob MullenG7b Microsoft Word 9.0e@ Z@Dڻ@&ɸ@ڻ՜.+,00 hp  ˿appe$ +Functional Group Questions Team Comments Title  !"#$&'()*+,./0123456789:;<=>?@ABCDEFHIJKLMNPQRSTUVYRoot Entry F #ڻ[Data %1Table-2WordDocument)HSummaryInformation(GDocumentSummaryInformation8OCompObjjObjectPool #ڻ #ڻ  FMicrosoft Word Document MSWordDocWord.Document.89q