Migration Monitoring Report needed

[Carl Leitner]

Need report that gives the internal migration

Fields needed are (date of last position change, reason for change, facility that they were, facility that they are)
Need filter for "Between" date of position change, so can check the migration on a monthly basis, quarterly basis,
Need filter for "Position Change Reason"

Need also the people that are not currently employed.

[Carl Leitner (litlfred)]

To the person, you will need to join the most recent person_position and the previous person_position.

For the most recent you can do max_parent of the person_position+start_date with offset 0
For the previous you can do max_parent of the person_position+start_date with offset 1

Note, this is not how we do the current staff report. In the current staff report we do the person_position with end_date NULL. But here, we are interested in the previous two positions whether or not they are still working. So here, we do NOT want to limit so that the end_date is null.

[Carl Leitner (litlfred)]

I set the status to low, because this report is only useful once people have started changing positions within iHRIS.

Right now, there may not be enough data to a make very useful report.