...
- No support from WD implementation project to shadow systems - had to be absorbed by the units
- Time Collection**
- No TC system
- There are specific groups of ppl who have time clocks. The time clock information is entered into an Excel spreadsheet and manually entered into the Payroll system.
- Others entries use timesheets for Payroll manual entry.
- Could not use WD's TimeIn/TimeOut - no costing model. Going to use Hours Worked timesheet within WD.
- Split shift workers need to be tracked in TimeIn/TimeOut per Georgetown's legal council's but they do not have split shift workers.
- Is Georgetown building an integrated Data Warehouse - No.
- Building an operational datastore to ensure shadow systems don't break. **
- using some of the data warehouse staff for this.
- 1 reports lead is focused on this - what information needs to go into the data store.
- 2 people from data warehouse team working off/on with reports lead
- To-date estimate - 2 weeks a month since February '11 (data warehouse ppl)
- Going forward estimate - 2 full-time data warehouse resources. Georgetown does not have cross domain reporting (at least not as integrated as CU). They tend to propagate data across domains to get integrated reporting.
- Integrations with external vendors - elongate the timeframe that WD gives you. WD doesn't account for delays when working with vendors.
- WD had planned for integration design work to start in October '10 although functional design work was not completed. Original estimate - design, build and testing starting in October '10 and ending in Feb '11. Today's plan - still trying to design and build and won't be done testing by July' 11. WD does not plan contigency in their estimates (for instance - issues from vendors, purchase order delays etc.). They don't factor into the estimates peripheral items.
- PS 7.6 Finance - inbound from PS to WD (cost centers/accounts) - 2 files. Outbound from WD to PS (payroll - actuals, encumberence, adjustments, accruals, fringe) - 5 files. GL is detailed employee information of payments. PS Finance system - SQR changes were not included in the project. 2 developers to make these changes (200 hour total effort for the 5 files). Transformation is done in the SQR and is fairly simple.
- Emergency Mass Notification system - yes but from ID Mgmt system.
...