Spreadsheet: 785684d1656542737-index-match-for-multiple-values-in-array-sampledata
Sheet: Job Data

EmplID | Effdt | EffSeq | Status | Action | Reason | Position Nbr | Manager [NAME]
10293 | 2021-07-01 00:00:00 | 1 | Active | Pay Change | MER | 716499 | 348562 |  |  | Note: | So for employee ID 10293, it should pull both EffSeq and both [NAME] (F) into Desired Report Example Sheet
10293 | 2021-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 716499 | 348562
10293 | 2020-11-18 00:00:00 | 0 | Active | Hire | HIR | 716499 | 348562
11111 | 2019-05-01 00:00:00 | 0 | Terminated | Termination | JOB | 825593 | 457152
11111 | 2019-01-01 00:00:00 | 2 | Active | Pay Change | SAI | 825593 | 457152
11111 | 2019-01-01 00:00:00 | 1 | Active | Pay Change | ASI | 825593 | 457152
11111 | 2019-01-01 00:00:00 | 0 | Active | Hire | HIR | 825593 | 457152
12345 | 2016-08-01 00:00:00 | 0 | Retired | Retirement | ERT | 628465 | 798762
12345 | 2014-07-01 00:00:00 | 2 | Active | Pay Change | SCI | 628465 | 798762
12345 | 2014-07-01 00:00:00 | 1 | Active | Rehire | REH | 628465 | 798762
12345 | 2014-07-01 00:00:00 | 0 | Terminated | Termination | JOB | 628465 | 798762
12345 | 2013-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 628465 | 798762
12345 | 2012-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 628465 | 798762
12345 | 2012-01-01 00:00:00 | 0 | Active | Pay Change | CSA | 628465 | 798762
12345 | 2011-07-01 00:00:00 | 0 | Active | Hire | AST | 628465 | 798762
28331 | 2015-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 368235 | 348562
28331 | 2014-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 368235 | 348562
28331 | 2013-07-01 00:00:00 | 1 | On Leave | Leave of Absence | ACD | 368235 | 348562
28331 | 2013-07-01 00:00:00 | 0 | Active | Job Change | ARC | 368235 | 348562
29673 | 2012-01-01 00:00:00 | 0 | Active | Pay Change | CSA | 726384 | 457152
29673 | 2010-07-01 00:00:00 | 0 | Active | Hire | AST | 726384 | 457152
29781 | 2013-07-01 00:00:00 | 1 | On Leave | Pay Change | SCI | 654915 | 798762
29781 | 2013-07-01 00:00:00 | 0 | On Leave | Data Adjustment | JED | 654915 | 798762
29781 | 2012-07-01 00:00:00 | 3 | On Leave | Leave of Absence | PER | 654915 | 798762
29781 | 2012-07-01 00:00:00 | 2 | Active | Hire | CNV | 654915 | 798762
29781 | 2012-07-01 00:00:00 | 1 | Terminated | Hire | HIR | 654915 | 798762
29781 | 2012-01-01 00:00:00 | 1 | On Leave | Leave of Absence | NEG | 654915 | 798762
29781 | 2012-01-01 00:00:00 | 0 | Active | Hire | AST | 654915 | 798762
46385 | 2022-07-01 00:00:00 | 0 | On Leave | Pay Change | SAI | 798762 | 348562
46385 | 2021-09-16 00:00:00 | 1 | On Leave | Leave of Absence | PER | 798762 | 348562
46385 | 2021-09-16 00:00:00 | 0 | Active | Return from Leave | TMP | 798762 | 348562
46385 | 2021-07-01 00:00:00 | 1 | On Leave | Pay Change | SPI | 798762 | 348562
46385 | 2021-07-01 00:00:00 | 0 | On Leave | Pay Change | SCI | 798762 | 348562
46385 | 2020-07-01 00:00:00 | 1 | On Leave | Pay Change | SPI | 798762 | 348562
46385 | 2020-07-01 00:00:00 | 0 | On Leave | Pay Change | SCI | 798762 | 348562
46385 | 2020-03-15 00:00:00 | 0 | On Leave | Leave of Absence | TMP | 798762 | 348562
46385 | 2019-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 798762 | 348562
46385 | 2019-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 798762 | 348562
46385 | 2018-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 798762 | 348562
46385 | 2018-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 798762 | 348562
46385 | 2017-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 798762 | 348562
46385 | 2017-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 798762 | 348562
46385 | 2016-12-01 00:00:00 | 2 | Active | Transfer | PRO | 798762 | 348562
46385 | 2016-12-01 00:00:00 | 1 | Active | Transfer | PRO | 798762 | 348562
56209 | 2022-07-01 00:00:00 | 1 | On Leave | Data Adjustment | JED | 991564 | 457152
56209 | 2022-07-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 991564 | 457152
56209 | 2022-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 991564 | 457152
56209 | 2022-03-01 00:00:00 | 0 | On Leave | Leave of Absence | NEG | 991564 | 457152
56209 | 2021-05-01 00:00:00 | 0 | Active | Pay Change | ASI | 991564 | 457152
56209 | 2020-05-28 00:00:00 | 0 | Active | Position Data Adjustment | UPD | 991564 | 457152
56209 | 2010-07-01 00:00:00 | 0 | Active | Hire | AST | 991564 | 457152
63792 | 2022-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2021-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2020-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2019-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2018-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2017-07-01 00:00:00 | 1 | On Leave | Leave of Absence | PER | 549823 | 457152
63792 | 2017-07-01 00:00:00 | 0 | Active | Return from Leave | PER | 549823 | 457152
63792 | 2017-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2016-07-01 00:00:00 | 2 | On Leave | Job Data Adjustment | UDJ | 549823 | 457152
63792 | 2016-07-01 00:00:00 | 1 | On Leave | Leave of Absence | PER | 549823 | 457152
63792 | 2016-07-01 00:00:00 | 0 | Active | Return from Leave | PER | 549823 | 457152
63792 | 2016-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 2015-07-01 00:00:00 | 0 | On Leave | Leave of Absence | PER | 549823 | 457152
63792 | 2015-05-01 00:00:00 | 0 | Active | Pay Change | ASI | 549823 | 457152
63792 | 2014-07-01 00:00:00 | 0 | Active | Rehire | REH | 549823 | 457152
74536 | 2022-07-01 00:00:00 | 1 | Active | Pay Change | ASI | 190765 | 457152
74536 | 2022-07-01 00:00:00 | 0 | Active | Retirement | ERT | 190765 | 457152
74536 | 2022-05-01 00:00:00 | 0 | Active | Pay Change | ASI | 190765 | 457152
74536 | 2021-07-01 00:00:00 | 1 | Active | Job Change | ROT | 190765 | 457152
74536 | 2021-07-01 00:00:00 | 0 | Active | Return from Leave | ACD | 190765 | 457152
74536 | 2021-05-01 00:00:00 | 0 | On Leave | Pay Change | ASI | 190765 | 457152
74536 | 2021-01-01 00:00:00 | 0 | On Leave | Leave of Absence | ACD | 190765 | 457152
74536 | 2020-05-01 00:00:00 | 0 | Active | Pay Change | ASI | 190765 | 457152
74536 | 2019-08-01 00:00:00 | 0 | Active | Job Change | RTC | 190765 | 457152
74536 | 2009-08-01 00:00:00 | 0 | Active | Hire | CNV | 190765 | 457152
76933 | 2022-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 565728 | 798762
76933 | 2022-07-01 00:00:00 | 0 | Active | Pay Change | SAI | 565728 | 798762
76933 | 2021-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 565728 | 798762
76933 | 2021-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 565728 | 798762
76933 | 2020-11-01 00:00:00 | 0 | Active | Job Change | RTC | 565728 | 798762
76933 | 2020-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 565728 | 798762
76933 | 2020-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 565728 | 798762
76933 | 2020-03-04 00:00:00 | 0 | Active | Transfer | PRO | 565728 | 798762
76933 | 2020-01-01 00:00:00 | 0 | Active | Position Change | PRU | 659204 | 385637
76933 | 2019-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 659204 | 385637
76933 | 2019-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 659204 | 385637
76933 | 2019-01-01 00:00:00 | 0 | Active | Data Adjustment | DAT | 659204 | 385637
76933 | 2018-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 659204 | 385637
76933 | 2018-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 659204 | 385637
76933 | 2017-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 659204 | 385637
76933 | 2017-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 659204 | 385637
76933 | 2016-01-05 00:00:00 | 0 | Active | Transfer | LTL | 659204 | 385637
76933 | 2015-11-24 00:00:00 | 0 | Active | Rehire | REH | 913728 | 385637
76933 | 2015-10-18 00:00:00 | 0 | Terminated | Termination | JOB | 913728 | 385637
76933 | 2015-07-01 00:00:00 | 1 | On Leave | Leave of Absence | SWB | 913728 | 385637
76933 | 2015-07-01 00:00:00 | 0 | On Leave | Pay Change | SPI | 913728 | 385637
76933 | 2015-06-09 00:00:00 | 0 | On Leave | Leave of Absence | SWB | 913728 | 385637
76933 | 2015-06-07 00:00:00 | 0 | Active | Return from Leave | SWB | 913728 | 385637
76933 | 2015-04-14 00:00:00 | 0 | On Leave | Leave of Absence | SWB | 913728 | 385637
76933 | 2015-02-17 00:00:00 | 0 | Active | Transfer | PRO | 913728 | 385637
78243 | 2014-08-10 00:00:00 | 0 | Terminated | Termination | JOB | 275446 | 798762
78243 | 2014-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 275446 | 798762
78243 | 2014-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 275446 | 798762
78243 | 2014-05-31 00:00:00 | 0 | Active | Data Adjustment | DAT | 275446 | 798762
78243 | 2014-03-14 00:00:00 | 0 | Active | Transfer | PRO | 275446 | 798762
78243 | 2013-09-01 00:00:00 | 1 | Active | Rehire | REH | 918867 | 627837
78243 | 2013-09-01 00:00:00 | 0 | Terminated | Termination | JOB | 918867 | 627837
78243 | 2013-07-25 00:00:00 | 0 | Active | Hire | HIR | 918867 | 627837
84536 | 2015-05-01 00:00:00 | 0 | Active | Pay Change | ASI | 457152 | 348562
84536 | 2014-05-01 00:00:00 | 0 | Active | Pay Change | ASI | 457152 | 348562
84536 | 2013-07-28 00:00:00 | 0 | Active | Return from Leave | NEG | 457152 | 348562
84536 | 2013-07-03 00:00:00 | 1 | On Leave | Pay Change | ASI | 457152 | 348562
84536 | 2013-07-03 00:00:00 | 0 | On Leave | Leave of Absence | NEG | 457152 | 348562
84536 | 2013-07-01 00:00:00 | 2 | Active | Pay Change | ASI | 457152 | 348562
84536 | 2013-07-01 00:00:00 | 1 | Active | Job Data Adjustment | UDJ | 457152 | 348562
84536 | 2013-07-01 00:00:00 | 0 | Active | Job Change | ARC | 457152 | 348562
94723 | 2019-07-01 00:00:00 | 1 | Active | Rehire | REH | 196634 | 457152
94723 | 2019-07-01 00:00:00 | 0 | Terminated | Termination | JOB | 196634 | 457152
94723 | 2016-07-01 00:00:00 | 1 | Active | Rehire | REH | 196634 | 457152
94723 | 2016-07-01 00:00:00 | 0 | Terminated | Termination | JOB | 196634 | 457152
94723 | 2015-03-01 00:00:00 | 1 | Active | Job Data Adjustment | UDJ | 196634 | 457152
94723 | 2015-03-01 00:00:00 | 0 | Active | Position Data Adjustment | UPD | 196634 | 457152
94723 | 2013-08-20 00:00:00 | 0 | Active | Hire | HIR | 196634 | 457152
98125 | 2019-01-01 00:00:00 | 0 | Active | Data Adjustment | DAT | 348562 | 832443
98125 | 2018-07-01 00:00:00 | 1 | Active | Pay Change | MER | 348562 | 832443
98125 | 2018-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 348562 | 832443
98125 | 2017-06-15 00:00:00 | 0 | Active | Transfer | PRO | 348562 | 832443
98765 | 2019-07-19 00:00:00 | 0 | Terminated | Termination | JOB | 822345 | 716499
98765 | 2019-07-01 00:00:00 | 1 | Active | Pay Change | SPI | 822345 | 716499
98765 | 2019-07-01 00:00:00 | 0 | Active | Pay Change | SCI | 822345 | 716499
98765 | 2019-05-01 00:00:00 | 0 | Active | Data Adjustment | JED | 822345 | 716499
98765 | 2018-10-05 00:00:00 | 0 | Active | Hire | HIR | 822345 | 716499