...
- what are the data conversion implications of org data?
- what are the implications of various Workday org representations and transformations from that to the pre-Workday org structures and representation?
Things to do:
- In an approved and scheduled BI for Workday Discovery project:
- categorize the impact in terms of size and complexity and impact/risk
- feeds/transformations
- reports
- models
- decide who owns talking to campus about downstream impacts / campus extracts and uses and their own reports
- categorize the impact in terms of size and complexity and impact/risk
- figure out if we need to and how to gauge the impact to models and reports
- make sure time collection is included in reporting needs (it's not just HR)
- dive into the diagram and illustrate the basic purpose, use,
- elaborate on the diagram with...
- the basic purpose and use of each DM
- owners and users of each DM
- data extracts, transformations, and extracts
- for each DM
- elaborate on the diagram with...
- For Workday to do: WORKDAY: Supply
- estimate the work to extract the same data now taken out of PeopleSoft (the 160 tables' worth of data)
- map out the canned Workday jobs extract with the PS jobs table used for 80% of the right hand side of the diagram
- need to think hard about if we really want transaction systems fed from a warehouse and we have to think about timing of the systems;
- make sure time collection is included in reporting
- supply a meta data model (fields definitions,types, uses, examples of fields)
- For analytical work in the discovery project:
- define minimal functionality
- define historical longitudinal reporting
- simple ad hoc access to an extract and PAIDS data
- updated APDB reporting solution
- align efforts in HR with efforts in other topics -> keep enterprise warehousing in mind.
- workday: delivers exports in a 'flat manner'
- In WD everything is position based. Vicky, Patrick and Tim roll up to Steve. Put a supervisor container in front of Steve and then CIT Applications can roll up to CIT Applications. The supervisor container is not included in the roll up. And, then use multiple containers for CIT and also for dual appointments.
- GET ETAs on all Workday numbers
- Notes:
- Workday Project Deliverable
- research outside solutions
- gaps
- longitudial
- compliance
- Enterprise model - for new work
- acceptable day 1, day n
- remediation - see picture
- Need overall BI strategy for project
- 2 discovery projects
- day 1 discovery project
- end goal discovery project
- each would have subsequent implementation work
- Need data model from Workday
- Need sponsor approval of what is needed day 1 (dodds, opperman, elmira, destefano)