Level 1 Model Exam Activity 5

In Activity 5 of the model building exam, it asks to adjust formulas for EMP02 Employee Expenses module for the Bonus, Car Costs, and medical expenses to reference driver data in EMP03 Employee Drivers by Role module. I have no idea what that means, can you help me?

Tagged:

Answers

  • Hi @jed14 -

    The EMP03 module should be a driver module that holds the data about the bonus, car costs, medical expenses etc all by Country and Department. So to bring these into your EMP02 Module, you should be able to reference this to the drivers in EMP03, by looking up the Employee Department, and the Employee Country. These details (Department and Country) about the employee can be found in the SYS08 Employee Details Module. 

     

    Hope this helps to clarify. 

    Jason