Spreadsheet: 677072d1589186929-power-query-extraction-of-field-in-duplicated-record-leave-fte-example
Sheet: Summary

ID | Surname | Preferred | JobPositionsSeq | AwardCode | JobPositionCode | JobPositionDescription | AwardLevelCode | JobPositionCategoryCode | JobPositionActiveFlag | ReportsToJobPositionsSeq | SchoolStaffCode | CurrentJobPositionFlag | FutureJobPositionFlag | JobLevel | JobLevelNextIncrementDate | StartDate | EndDate | FTE | JobLevelNextIncrementYears | NextReviewDate
11884 | Smith | [NAME] | 17 | TEACHING | TEACHER | Teacher | ET | TEACHER | True | 18 |  | True | False | 0 |  | 2019-04-24 00:00:00 |  | 0 | 1
11884 | Smith | [NAME] | 17 | TEACHING | TEACHER | Teacher | CONTRACT | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-05-19 00:00:00 | 0.8 | 1
18054 | [NAME] | [NAME] | 17 | TEACHING | TEACHER | Teacher | LDR_WELLBEING | TEACHER | True | 18 |  | True | False | 0 | 2019-05-01 00:00:00 | 2019-01-29 00:00:00 | 2022-01-27 00:00:00 | 1 | 1
18054 | [NAME] | [NAME] | 17 | TEACHING | TEACHER | Teacher | ASST_HEAD_LEARN | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2022-01-27 00:00:00 | 0 | 1
18092 | Hark | [NAME] | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2013-01-29 00:00:00 |  | 1 | 1
18092 | Hark | Emma | 17 | TEACHING | TEACHER | Teacher | PARENTAL | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-27 00:00:00 | 0 | 1
18144 | Liver | [NAME] | 28 | ES | COUNSELLORS | Counsellor | OVERAWARD | COUNSELLOR | True | 18 |  | True | False | 0 |  | 2019-01-29 00:00:00 |  | 0.8 | 1
18144 | Liver | [NAME] | 28 | ES | COUNSELLORS | Counsellor | PARENTAL | COUNSELLOR | True | 18 |  | True | False | 0 |  | 2019-02-23 00:00:00 |  | 0 | 1
18241 | Severn | Rebecca | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2019-01-29 00:00:00 |  | 1 | 1
18241 | Severn | Rebecca | 17 | TEACHING | TEACHER | Teacher | MUS_DIR | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
18279 | Viccar | [NAME] | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2005-01-25 00:00:00 |  | 1 | 1
18279 | Viccar | [NAME] | 17 | TEACHING | TEACHER | Teacher | LONG_TERM_CARER | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
18443 | [NAME] | [NAME] | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2018-11-28 00:00:00 | 2020-07-12 00:00:00 | 1 | 1
18443 | [NAME] | [NAME] | 17 | TEACHING | TEACHER | Teacher | LSL | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-06-23 00:00:00 | 0 | 1
23325 | Nguyen | Mark | 17 | TEACHING | TEACHER | Teacher | ET | TEACHER | True | 18 |  | True | False | 0 |  | 2016-01-27 00:00:00 |  | 0 | 1
23325 | Nguyen | Mark | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-06-24 00:00:00 | 0.53 | 1
23328 | [NAME] | Marianne | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-06-21 00:00:00 | 0.71 | 1
23328 | [NAME] | Marianne | 17 | TEACHING | TEACHER | Teacher | RESEARCH_LEAD | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
23382 | Iota | [NAME] | 17 | TEACHING | TEACHER | Teacher | HEAD_JUSTICE ED | TEACHER | True | 18 |  | True | False | 0 |  | 2019-01-29 00:00:00 | 2022-01-27 00:00:00 | 1 | 1
23382 | Iota | [NAME] | 17 | TEACHING | TEACHER | Teacher | HEAD_LEARN_CENT | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-29 00:00:00 | 2022-01-27 00:00:00 | 0 | 1
23629 | O'Kevin | Heather | 17 | TEACHING | TEACHER | Teacher | CONTRACT | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-12-11 00:00:00 | 0.13 | 1
23629 | O'Kevin | Heather | 90 | ES | LEARN_DIV | Learning Diversity | CONTRACT | LEARN_CENTRE | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-12-11 00:00:00 | 0.67 | 1
24231 | [NAME] | [NAME] | 87 | ES | STAFF_COACH | Staff Coach | OVERAWARD | ADMIN | True | 16 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
24231 | [NAME] | [NAME] | 87 | ES | STAFF_COACH | Staff Coach | CONTRACT | ADMIN | True | 16 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0.2 | 1
24306 | [NAME] | Mark | 17 | TEACHING | TEACHER | Teacher | COLL_TIMETABLER | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2023-01-28 00:00:00 | 0 | 1
24306 | [NAME] | Mark | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 |  | 1 | 1
24405 | [NAME] | Geoff | 45 | ES | LEARN_ENHANCE | Learning Enhancement |  | LEARN_ENHANCE | True | 18 |  | True | False | 0 |  | 2019-01-29 00:00:00 |  | 0.6 | 1
24405 | [NAME] | Geoff | 17 | TEACHING | TEACHER | Teacher | ET | TEACHER | True | 18 |  | True | False | 0 |  | 2020-04-06 00:00:00 |  | 0 | 1
25114 | Shaw | Cath | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 |  | 2019-01-29 00:00:00 |  | 1 | 1
25114 | Shaw | Cath | 17 | TEACHING | TEACHER | Teacher | PUB_SPK | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
25188 | Lemon | [NAME] | 17 | TEACHING | TEACHER | Teacher |  | TEACHER | True | 18 |  | True | False | 0 | 2019-05-01 00:00:00 | 2019-01-29 00:00:00 |  | 1 | 1
25188 | Lemon | [NAME] | 17 | TEACHING | TEACHER | Teacher | DEBATING | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
25252 | [NAME] | Marianne | 17 | TEACHING | TEACHER | Teacher | [NAME] | TEACHER | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0.8 | 1
25252 | [NAME] | Marianne | 90 | ES | LEARN_DIV | Learning Diversity |  | LEARN_CENTRE | True | 18 |  | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0.2 | 1
26018 | Keen | [NAME] | 17 | TEACHING | TEACHER | Teacher | HEAD_SW_DIANELL | TEACHER | True | 18 |  | True | False | 0 |  | 2019-01-29 00:00:00 | 2022-01-27 00:00:00 | 1 | 1
26018 | Keen | [NAME] | 17 | TEACHING | TEACHER | Teacher | LSL | TEACHER | True | 18 |  | True | False | 0 |  | 2020-02-26 00:00:00 | 2020-06-19 00:00:00 | 0 | 1