Migration Monitoring Report needed
Bug #794896 reported by
Carl Leitner
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| ihris-manage-cssc |
Triaged
|
Low
|
josephat mathayo | ||
Bug Description
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.
Revision history for this message
| Carl Leitner (litlfred) wrote | #1 |
| Changed in ihris-manage-cssc: | |
| importance: | Undecided → Low |
Revision history for this message
| Carl Leitner (litlfred) wrote | #2 |
| Changed in ihris-manage-cssc: | |
| assignee: | nobody → josephat mathayo (jmathayo) |
| status: | New → Triaged |
To post a comment you must log in.
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_
For the previous you can do max_parent of the person_
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.