You can ask me for an Access Database,
but please enter a Subject, otherwise your email will be treated as Spam.
Microsoft has added a Hierarchy ID to SQL Server 2008 which is definitely worth checking out.
The Steps in using this Data Model would be :-
1. Establish the Organisation Structure in HR's Resource Link.
2. Establish the Management Hierarchy in Agresso.
3. Define the Mappings between the two.
5. Reconcile any differences.
6. Update the Data Dictionary.