...
- There are 160 tables from Peoplesoft; deltas go daily to replication db as is.
- There are a number of impacted dms / mini marts stewarded by CIT that haven't surfaced as impacted by HR/Payroll until we saw Dave's daigram
- Some have extensive impact and other have minor impact
- In all cases shown in the diagrams data is moved/copied, transformed and inserted into those tables
- There is no clarity (written, definitive statements) from the Workday project on the representation of level 9s org data
- All users of the marts will have to be the ones to explain how the various org roll ups work and why they are needed.
- There are various possibilities of getting the representation done in Workday:
- custom fields
- 'containers'‘containers’
- IN any case, the department tree is used broadly in the feeds from PS HR/Payroll
- workday: delivers exports in a 'flat manner'‘flat manner’:
- In WD everything is position based. ex: 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.
...