The kata is good, but there are too many unnecessary words in the description. This of course immerses in the context, but a little tightened. Anyway. working with a hierarchy is a common task, you need to master it.

All the manager-related stuff in this kata is noise which adds absolutely nothing to the task, and it really should be removed. (If somebody decides to rework the kata this way, it'd be nice if the tables' and columns' names were changed to be more appropriate than they are now).

I'm opening this a suggestion but it's more of an issue IMO.

Salary_Total [FLOAT]

numeric should be used for money calculations.

Sample tests should have fixed data and proper test cases.

hard to approve if the test cases are a black box

I've amended - the chance of collision was around 2-in-a-million, but yes, it would have likely shown up at some point (and could've confused the poor dev that hit it!).

whilst there's a small chance of a collision, I don't know that it's worth worrying about.

yes, that's always worth worrying about: considering the amount of users/tests launched, the problem will always show up, in the end.

Hi, I've added in some code to randomize the IDs of the employees, whilst there's a small chance of a collision, I don't know that it's worth worrying about.

I've changed employees_total to be an INT, totally agree that half an employee is no use to anyone. :)

Age is age-as-of-2016-04-01 as I understood it when completing the kata.

Have changed to INT.

It could be a very nice kata, shame it stuck at beta.

In description type of manager in company table is int, but in reality it is double precision. I think it should be changed to int as it references to int in employee table.

Your dataset is not random except manager names anyway so it's trivial to hardcode the values.

i.e Needs much better random tests.

employees_total should not be a float. It implies it's possible to have a fractional amount of employees.

Also, why the age is from 2016-04-01? This is not what age means in any common usage.