Legend: Done /Green is on Track /Yellow is At Risk /Red is Off Track
Overall At Risk: Phase 1 & Phase 2 Project Complete
- Milestone 1 , Thin Slice of KS integration and KS technology stack
- Completed April 16, 2012
- Use of KRAD, KIM and KSA services
- Kuali Rice 2.x framework
- End-to-end in technology stack
- Milestone 2 , Transaction view of student receivables
- Completed April 16, 2012
- Strategic functional milestone
- Unfiltered transaction view and account summary
- Originally projected for 4Q 2012
- Milestone 3 , Account Aging and Delinquency
- Completed October 15, 2012
- Strategic functional milestone
- Originally projected for 4Q 2012
- Milestone 4 , Integration with KFS
- Completed January 23, 2013
- KFS integration testing with UMD completed
- Integration demonstrated to KS technical team and UMD Bursar representatives 1/23/13
- Milestone 5 , Fee Management (Assessment)
- Milestone 6 , 3rd Party Billing and Processing
- Upcoming presentation: March 10th, KSA will demonstrate the Fee Management module to the stakeholders.
- Upcoming presentation: March 13th, KSA will provide an overview demonstration for Kuali Days, South Africa.
- Recent demonstration: December 10-11, Community-wide webinar @ Boston College (Overview and Deep Dive in Modules)
- Recent demonstration: November 19-20, Kuali Days (two sessions- Overview and Payment Application)
- Recent demonstration: November 4-5, UMD and USC from UMD campus (Overview and Deep Dive in Modules)
Key Current Topics, Issues and Risks
Phase 1 Development Progress Metrics
Original Time Estimate
Expected Percent Complete
Actual Percent Complete
Phase 2 Development Progress Metrics
Original Time Estimate
Expected Percent Complete
Actual Percent Complete
- Phase 1 Founders Release: Available April 2013
- Phase 2 Founders Release: Available January 2014
Overview Completion Dates
Completed Notable Tasks
- February 2014 (as of 3/5/2014)
- Minor changes to support the Fee Management module have been applied as identified for the upcoming presentations.
- KSA will demonstrate the Fee Management module to the stakeholders on March 10th.
- KSA will provide an overview demonstration for Kuali Days, South Africa on March 13th.
- Sigma is in routine contact with Boston College regarding a planned KSA implementation starting about June 2014. We have drafted a proposal that will allow the KSA team to identify gaps in KSA against the BC requirements as a first step toward implementation services.
- January 2014 (as of 2/10/2014)
- The KSA team has wrapped up core phase 1 & phase 2 development for the project. The team is continuing development and testing efforts for additional scenarios and some out-of-scope for phase 1 & 2 items.
- The KSA team has met with Boston College individually to identify a potential implementation project and to identify gaps to their existing business processes. These conversations are on-going.
- November 2013 (as of 12/10/2013)
- KSA team presented status of the KSA module to Kuali community from the Boston College campus over the course of two days (Dec 10-11). This presentation represented the completion of KSA with the exception of the Fee Management module.
- A recording of this presentation will be made available to KS following the presentation.
- KSA team presented two live demonstrations of KSA at the Kuali Days conference.
- KSA development is complete with the exception of rules processing for the Fee Management module. All other Fee Management services have been completed.
- October 2013 (as of 11/11/2013)
- KSA team presented status of the KSA module to stakeholders over the course of two days (Nov 4 - 5). This presentation represented the completion of KSA with the exception of the Fee Management module.
- KSA has worked with KRAD team to resolve performance issue with light-boxes which are heavily used in KSA. This issue was included in a Rice sprint and appears to be resolved in beta 2.4 release.
- Sigma to implement Rice 2.4 with scheduled public release after KDs and confirm resolution
- Sigma will focus on USC model of fee assessment as development milestone for the Fee Management module and tackle the more complex UMD model next.
- September 2013 (as of 10/7/2013)
- KSA is now included in the KS CI automated build environment running in the cloud.
- Requested some assistance from the KS team to automate the scripts- thanks!
- Minor code modifications required to sync up, although clean builds were in place quickly.
- Rice 2.3.1 installed and in use for current development
- KSA will need to freeze at this release level in order to complete phase 1 & 2 for KD's
- KRAD roadblocks do still exists but have been documented in JIRA's and in some cases work arounds are in place
- Performance analysis completed internally against KRAD 2.2 and 2.3
- Results will be posted to KSA wiki
- Remaining milestone is the Fee Management module. Plan to demonstrate at KD's in November.
- Approximately 10 remaining UI screens to be completed.
- Completed new end-to-end gap analysis of product against stakeholder requirements
- Results are good. Only 3 development gaps were identified and are being implemented.
- August 2013 (as of 9/5/2013)
- This has been a heavy development period, with most minor requirements design remaining.
- The 6th milestone, Third-Party Billing and Processing has been completed.
- Rice 2.3.0 was installed this period and used for the presentation to U or Toronto on 9/6.
- Some refactoring of code was and is necessary for this release. This is not a current focus, once initial development is complete to meet deadlines, we will revisit the revisions necessary for the latest Rice enhancements.
- The outstanding development for the project is milestone 5- Fee Management.
- This requirements have been completed
- 60% of the services have been completed
- Includes completion of Rates service- the integration point with KE
- Remaining services to be completed are associate with the rules engine
- Output from the rules engine IS now supported and complete
- UI wireframes largely completed
- UI development will begin week of 9/9
- Senior management team will meet week of 9/9 to evaluate the status of the planned 9/13/13 phase 2 completion
- In the next period KSA will work with the KS developers to include KSA in the KS CI testing region
- July 2013 (as of 8/8/2013)
- Design specifications with KE which will support Fee Management (Milestone 5) integration have wrapped up. Design has been turned over to developers.
- Third Party and Payment Plans (Milestone 6) services are complete. UI development in progress.
- KSA team plans to implement Rice 2.3.0 week of 8/12 assuming availability on 8/9.
- It will be important to implement this release quickly to adopt performance improvements in time for demonstration to University of Toronto on 9/6.
- Some refactoring of code is necessary to adopt 2.3.0.
- June 2013 (as of 7/9/2013)
- Continued specific focus on KSA-FM this month. Design is 95% complete. Sprint development will take place from now until FM completion estimated in mid-September.
- Design discussions are wrapping up with the KE team.
- UI development is still a major remaining effort.
- May 2013 (as of 6/5/2013)
- Specific focus on KSA-FM (Fee Management) this month. The design is complete and development of a domain specific language for the rules management component will be underway next.
- Included in the KSA-FM design was additional progress and continued discussion with the KS services team regarding interface data.
- KSA upgraded to from Rice 2.2.0 to 2.2.4 and then to 2.3.0-M2 in support or ongoing KRAD performance concerns.
- KSA UI development met with Jerry Neal for a performance tuning review of KSA. Notes from this session can be found here.
- April 2013 (as of 5/7/2013)
- Provided a demonstration to the KS Service team
- One objective of this meeting was to assist the interaction b/w services and KSA when discussing integration points
- Fee Management is a key integration point that will make use of the RateService. This discussion is nearing completion
- Incorporated most of the suggestions received from the stakeholder review sessions held in March and April
- Documenting results for stakeholder by week end 5/5/13
- Wireframes were developed for a simplified activity log, Transaction Type setup, display, and modification, simple cashiering, and numerous updates to existing designs to improve user experience
- Completed a UX review with KS UX team at the April Community Workshop
- Results are documented here:
- KSA team documenting responses to UX feedback by week end 5/5/13
- Participation in User Experience Initiative Meeting (UIX),and the UX/UIM working group sessions
- Completion of the General Ledger UI
- March 2013 (as of 4/4/2013)
- Actively engaged with KS team to synchronize the Fee Management touch points
- All wireframes for phase 1 are completed
- Significant progress with outstanding UI development in active sprint
- Payment Application module now in testing
- February 2013 (as of 3/7/2013)
- Completed a UX review and began onsite user testing with stakeholders
- UMD completed early this month, USC scheduled for first week of April
- Continued major focus on UI development
- Making use of nice KRAD features such as subcollections within collections and lightboxes
- Great progress with the Payment Application rules engine using a DSL (Domain Specific Language) for end users
- Currently under internal testing with USC production rules
- Builds upon the proof of concept developed for KD's and is the foundation for the more complex Fee Assessment requirements (phase 2)
- Several conversations with the KS team regarding holds and ATP (time). Design for this in KSA is complete and in development
- Project update and live KSA presentation to the PAG 3/4/13
- January 2013 (as of 2/4/13)
- Payment Bill and Third Party design completed pending review
- UI for General Ledger (supporting KFS integration) designed and implemented, minor bug review taking place
- Transaction Type UI significant progress, however sprint ongoing
- KSA makes extensive use of KS 'Type' service
- Completed integration of KS ATP (academic time period) service into KSA
- Several reporting methods implemented including Aged Balance & 1098T
- December 2012 (as of 1/11/13)
- KSA was upgraded to Kuali Rice 2.2.0 release and KSA Maven dependencies were changed
- Integrated Kuali Student’s ATP (time) service in KSA
- Heavily used in Fee Management module
- Refactored Rules Service and its Drools implementation
- Creating a new database schema for storing rules and modifying the Drools persistence layer
- TransactionExportService and TransactionExportController classes used for General Ledger and KFS integration were completed
- Internal QA of general ledger completed (KFS XML file generation)
- Efforts ongoing to complete stakeholder testing
- Process design for Third party billing 90% complete
- Process design for payment billing 90% complete
- Multiple working sessions with KS services team members (Tom and Norm) to confirm migration of KS services in KSA (ATP, holds, possibly organization)
- UI working in-person meeting held with KS team (William Washington) to review KRAD capabilities and gap analysis for KSA requirements
- 8300 Reporting (cash payments over $10k) process 90% complete, includes export
- November 2012 (as of 12/10)
- Development for integration with KFS and generation of transactions is complete
- KSA has reached out to stakeholders to initiate test plan with desire to complete by 12/31.
- The following development is now complete for KFS integration needs and for testing:
- Refund Service
- Account import
- Account export
- Transaction import for UI controller
- Transaction utility for filtering and allocations
- General ledger service for preparing and summarizing transactions
- 3rd party (milestone 6) design now 65% complete
- UI development of Transaction types underway
- Anticipate significant additional development for remaining UI in phase 1 over the next month.
- October 2012 (as of 10/3)
- Completed a KRAD analysis and effort to support 2 levels of navigation between views and pages
- Incorporated search controls and a KSA logo into the application header (KRAD)
- Modified KRAD templates to position the UIF elements (including breadcrumbs) according to the wireframes
- September 2012 (as of 9/11)
- KFS output designed, under validation and development began (3Q 2012 deliverable)
- Sprints established to meet milestone
- Proof of concept for Fee Management (2Q, 2013 deliverable) designed
- Includes Classes, data model and import schema
- Payment Application conceptual design complete
- KSA trunk upgraded to Rice 2.2.0-M3 release
- August 2012
- Now able to process & import online and volume transactions / document to KSA ledger and create receipts / results
- Worked out the major contours of payment application and general ledger transaction production (but not interaction, KFS)
- Designed a number of standard reporting formats (1098T being one of them- strategic)
- Designed a number of transfer methods to transfer charges to other accounts, which will be fundamental to sponsor billing, etc. Includes write offs, etc.
- Implementing refund services development 50% complete
- Payment billing (phase II requirement) design underway
- This is a trigger for a general ledger review
- July 2012
- Interaction with KS-KFS Team Delayed and Off-Schedule
- Demonstrable Aging of Accounts
- Account Delinquency
- Collection Management
- Dynamic Transaction Views
- Integrating Rules Management System with KSA
- June 2012
- Audit for KSA Lifecycle Supported
- Transaction Service and XML Load Supported
- Aging of Accounts Service 70% Complete
- Utilize KSB Scheduler Factory & rules to initiate transaction input service to age accounts in volume
- Initiated Contact with Stakeholders to Stage QA Receivable Management Content to KSA Database
- (First development interaction with stakeholders)
- UMD fully engaged
- Refund Management Design Near Completion
- Personal Preferences Design Under Review
- Access Authorization for User Ability to Apply Certain Transactions Completed
- May 2012
- Interface with KIM Complete
- April 2012
- Major Milestone (1) Completion Announcement
- Thin Slide of KS Interaction and Kuali Technical Stack
- Major Milestone (2) Completion Announcement
- Transaction view of Student Receivables
- March 2012
- Published KSA-PB (Payment Billing)/TP (Third Party)/CM (Collections Management) requirements on Wiki
- Published KSA-RM UX Personae on Wiki
- Published designed KSA-RM use cases, data representation and ER diagrams
- Published KSA-RM UX Wireframes
- Stakeholder review/approval period started
- KS-Community comment period ended for KSA-FM
- KSA-FM rules design sign-off (epic dev - phase 2)
Overview: Phase 1 includes Receivables Management and Core Accounting
Objective: This module handles the core requirements of accounts receivable, including handling accounts, charges, payments, deferments, etc. Almost every other module in the system interacts with Accounts Receivable and core accounting functions. The module includes, but is not limited to the following functions:
- account management
- refund management
- reporting and reconciliation
- bill production
- transaction creation
- general ledger interaction
- payment type tracking
- charge type tracking
- payment application
- policy enforcements
- payment acceptance
- memo functionality
- bad debt and collections
- regulatory tracking
- All Phase 1 milestones have been completed.
Overview: Phase 2 includes Payment and Billing and Collection Management, Fee Management and Third Party
Objective: The fee assessment module will be able to calculate all fees and charges for a student given their demographic data, the course load, and other applicable variables. The necessary student data will need to be accessible to this module either via an integration to the school’s student system or an ESB request to the school’s student system or over the KSB. This will be a rules driven process that will be able to handle extremely sophisticated billing algorithms. The charges can then be posted to the account, or provided to another service (for example, in KE, a student could theoretically present their list of classes, and find out how much it would cost, and create several what-if scenarios.)
Third Party Accounts is otherwise known as sponsorship accounts. This is a module that provides a standard way to deal with an often ad hoc accounting practice, where third-party sponsors agree to pay for some portion of a student account. Most often, this is an employer offering some form of tuition benefit. Third-party access to bills and information is handled very differently to student access. This module will allow that customization, as well as handle the transfer of funds from a third-party payment to the student’s account. It will also handle the reversal of funds if a sponsor does not pay the bill or a student's participation requirements change. The module will include the following:
- third party sponsor and student accounts
- transfer of fee from the student(s) account to the third party sponsor account
- generations of third-party billing
- third-party payments
- third-party account aging
- third-party sponsor self-service/access (phase 3)
- All Phase 2 milestones have been completed.
Risks (in order of priority)