Spreadsheet: 785354d1656354062-index-match-for-multiple-values-in-array-college-db
Sheet: Job Data

EmplID | Effdt | EffSeq | Status | Action | Reason | Position Nbr | Manager [NAME]
10293 | 44378 | 1 | Active | Pay Change | MER | 716499 | 348562
10293 | 44378 | 0 | Active | Pay Change | SCI | 716499 | 348562
10293 | 44153 | 0 | Active | Hire | HIR | 716499 | 348562
11111 | 43586 | 0 | Terminated | Termination | JOB | 825593 | 457152
11111 | 43466 | 2 | Active | Pay Change | SAI | 825593 | 457152
11111 | 43466 | 1 | Active | Pay Change | ASI | 825593 | 457152
11111 | 43466 | 0 | Active | Hire | HIR | 825593 | 457152
12345 | 42583 | 0 | Retired | Retirement | ERT | 628465 | 798762
12345 | 41821 | 2 | Active | Pay Change | SCI | 628465 | 798762
12345 | 41821 | 1 | Active | Rehire | REH | 628465 | 798762
12345 | 41821 | 0 | Terminated | Termination | JOB | 628465 | 798762
12345 | 41456 | 0 | Active | Pay Change | SCI | 628465 | 798762
12345 | 41091 | 0 | Active | Pay Change | SCI | 628465 | 798762
12345 | 40909 | 0 | Active | Pay Change | CSA | 628465 | 798762
12345 | 40725 | 0 | Active | Hire | AST | 628465 | 798762
28331 | 42125 | 0 | On Leave | Pay Change | ASI | 368235 | 348562
28331 | 41760 | 0 | On Leave | Pay Change | ASI | 368235 | 348562
28331 | 41456 | 1 | On Leave | Leave of Absence | ACD | 368235 | 348562
28331 | 41456 | 0 | Active | Job Change | ARC | 368235 | 348562
29673 | 40909 | 0 | Active | Pay Change | CSA | 726384 | 457152
29673 | 40360 | 0 | Active | Hire | AST | 726384 | 457152
29781 | 41456 | 1 | On Leave | Pay Change | SCI | 654915 | 798762
29781 | 41456 | 0 | On Leave | Data Adjustment | JED | 654915 | 798762
29781 | 41091 | 3 | On Leave | Leave of Absence | PER | 654915 | 798762
29781 | 41091 | 2 | Active | Hire | CNV | 654915 | 798762
29781 | 41091 | 1 | Terminated | Hire | HIR | 654915 | 798762
29781 | 40909 | 1 | On Leave | Leave of Absence | NEG | 654915 | 798762
29781 | 40909 | 0 | Active | Hire | AST | 654915 | 798762
46385 | 44743 | 0 | On Leave | Pay Change | SAI | 798762 | 348562
46385 | 44455 | 1 | On Leave | Leave of Absence | PER | 798762 | 348562
46385 | 44455 | 0 | Active | Return from Leave | TMP | 798762 | 348562
46385 | 44378 | 1 | On Leave | Pay Change | SPI | 798762 | 348562
46385 | 44378 | 0 | On Leave | Pay Change | SCI | 798762 | 348562
46385 | 44013 | 1 | On Leave | Pay Change | SPI | 798762 | 348562
46385 | 44013 | 0 | On Leave | Pay Change | SCI | 798762 | 348562
46385 | 43905 | 0 | On Leave | Leave of Absence | TMP | 798762 | 348562
46385 | 43647 | 1 | Active | Pay Change | SPI | 798762 | 348562
46385 | 43647 | 0 | Active | Pay Change | SCI | 798762 | 348562
46385 | 43282 | 1 | Active | Pay Change | SPI | 798762 | 348562
46385 | 43282 | 0 | Active | Pay Change | SCI | 798762 | 348562
46385 | 42917 | 1 | Active | Pay Change | SPI | 798762 | 348562
46385 | 42917 | 0 | Active | Pay Change | SCI | 798762 | 348562
46385 | 42705 | 2 | Active | Transfer | PRO | 798762 | 348562
46385 | 42705 | 1 | Active | Transfer | PRO | 798762 | 348562
56209 | 44743 | 1 | On Leave | Data Adjustment | JED | 991564 | 457152
56209 | 44743 | 0 | On Leave | Pay Change | ASI | 991564 | 457152
56209 | 44682 | 0 | On Leave | Pay Change | ASI | 991564 | 457152
56209 | 44621 | 0 | On Leave | Leave of Absence | NEG | 991564 | 457152
56209 | 44317 | 0 | Active | Pay Change | ASI | 991564 | 457152
56209 | 43979 | 0 | Active | Position Data Adjustment | UPD | 991564 | 457152
56209 | 40360 | 0 | Active | Hire | AST | 991564 | 457152
63792 | 44682 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 44317 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 43952 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 43586 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 43221 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 42917 | 1 | On Leave | Leave of Absence | PER | 549823 | 457152
63792 | 42917 | 0 | Active | Return from Leave | PER | 549823 | 457152
63792 | 42856 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 42552 | 2 | On Leave | Job Data Adjustment | UDJ | 549823 | 457152
63792 | 42552 | 1 | On Leave | Leave of Absence | PER | 549823 | 457152
63792 | 42552 | 0 | Active | Return from Leave | PER | 549823 | 457152
63792 | 42491 | 0 | On Leave | Pay Change | ASI | 549823 | 457152
63792 | 42186 | 0 | On Leave | Leave of Absence | PER | 549823 | 457152
63792 | 42125 | 0 | Active | Pay Change | ASI | 549823 | 457152
63792 | 41821 | 0 | Active | Rehire | REH | 549823 | 457152
74536 | 44743 | 1 | Active | Pay Change | ASI | 190765 | 457152
74536 | 44743 | 0 | Active | Retirement | ERT | 190765 | 457152
74536 | 44682 | 0 | Active | Pay Change | ASI | 190765 | 457152
74536 | 44378 | 1 | Active | Job Change | ROT | 190765 | 457152
74536 | 44378 | 0 | Active | Return from Leave | ACD | 190765 | 457152
74536 | 44317 | 0 | On Leave | Pay Change | ASI | 190765 | 457152
74536 | 44197 | 0 | On Leave | Leave of Absence | ACD | 190765 | 457152
74536 | 43952 | 0 | Active | Pay Change | ASI | 190765 | 457152
74536 | 43678 | 0 | Active | Job Change | RTC | 190765 | 457152
74536 | 40026 | 0 | Active | Hire | CNV | 190765 | 457152
76933 | 44743 | 1 | Active | Pay Change | SPI | 565728 | 798762
76933 | 44743 | 0 | Active | Pay Change | SAI | 565728 | 798762
76933 | 44378 | 1 | Active | Pay Change | SPI | 565728 | 798762
76933 | 44378 | 0 | Active | Pay Change | SCI | 565728 | 798762
76933 | 44136 | 0 | Active | Job Change | RTC | 565728 | 798762
76933 | 44013 | 1 | Active | Pay Change | SPI | 565728 | 798762
76933 | 44013 | 0 | Active | Pay Change | SCI | 565728 | 798762
76933 | 43894 | 0 | Active | Transfer | PRO | 565728 | 798762
76933 | 43831 | 0 | Active | Position Change | PRU | 659204 | 385637
76933 | 43647 | 1 | Active | Pay Change | SPI | 659204 | 385637
76933 | 43647 | 0 | Active | Pay Change | SCI | 659204 | 385637
76933 | 43466 | 0 | Active | Data Adjustment | DAT | 659204 | 385637
76933 | 43282 | 1 | Active | Pay Change | SPI | 659204 | 385637
76933 | 43282 | 0 | Active | Pay Change | SCI | 659204 | 385637
76933 | 42917 | 1 | Active | Pay Change | SPI | 659204 | 385637
76933 | 42917 | 0 | Active | Pay Change | SCI | 659204 | 385637
76933 | 42374 | 0 | Active | Transfer | LTL | 659204 | 385637
76933 | 42332 | 0 | Active | Rehire | REH | 913728 | 385637
76933 | 42295 | 0 | Terminated | Termination | JOB | 913728 | 385637
76933 | 42186 | 1 | On Leave | Leave of Absence | SWB | 913728 | 385637
76933 | 42186 | 0 | On Leave | Pay Change | SPI | 913728 | 385637
76933 | 42164 | 0 | On Leave | Leave of Absence | SWB | 913728 | 385637
76933 | 42162 | 0 | Active | Return from Leave | SWB | 913728 | 385637
76933 | 42108 | 0 | On Leave | Leave of Absence | SWB | 913728 | 385637
76933 | 42052 | 0 | Active | Transfer | PRO | 913728 | 385637
78243 | 41861 | 0 | Terminated | Termination | JOB | 275446 | 798762
78243 | 41821 | 1 | Active | Pay Change | SPI | 275446 | 798762
78243 | 41821 | 0 | Active | Pay Change | SCI | 275446 | 798762
78243 | 41790 | 0 | Active | Data Adjustment | DAT | 275446 | 798762
78243 | 41712 | 0 | Active | Transfer | PRO | 275446 | 798762
78243 | 41518 | 1 | Active | Rehire | REH | 918867 | 627837
78243 | 41518 | 0 | Terminated | Termination | JOB | 918867 | 627837
78243 | 41480 | 0 | Active | Hire | HIR | 918867 | 627837
84536 | 42125 | 0 | Active | Pay Change | ASI | 457152 | 348562
84536 | 41760 | 0 | Active | Pay Change | ASI | 457152 | 348562
84536 | 41483 | 0 | Active | Return from Leave | NEG | 457152 | 348562
84536 | 41458 | 1 | On Leave | Pay Change | ASI | 457152 | 348562
84536 | 41458 | 0 | On Leave | Leave of Absence | NEG | 457152 | 348562
84536 | 41456 | 2 | Active | Pay Change | ASI | 457152 | 348562
84536 | 41456 | 1 | Active | Job Data Adjustment | UDJ | 457152 | 348562
84536 | 41456 | 0 | Active | Job Change | ARC | 457152 | 348562
94723 | 43647 | 1 | Active | Rehire | REH | 196634 | 457152
94723 | 43647 | 0 | Terminated | Termination | JOB | 196634 | 457152
94723 | 42552 | 1 | Active | Rehire | REH | 196634 | 457152
94723 | 42552 | 0 | Terminated | Termination | JOB | 196634 | 457152
94723 | 42064 | 1 | Active | Job Data Adjustment | UDJ | 196634 | 457152
94723 | 42064 | 0 | Active | Position Data Adjustment | UPD | 196634 | 457152
94723 | 41506 | 0 | Active | Hire | HIR | 196634 | 457152
98125 | 43466 | 0 | Active | Data Adjustment | DAT | 348562 | 832443
98125 | 43282 | 1 | Active | Pay Change | MER | 348562 | 832443
98125 | 43282 | 0 | Active | Pay Change | SCI | 348562 | 832443
98125 | 42901 | 0 | Active | Transfer | PRO | 348562 | 832443
98765 | 43665 | 0 | Terminated | Termination | JOB | 822345 | 716499
98765 | 43647 | 1 | Active | Pay Change | SPI | 822345 | 716499
98765 | 43647 | 0 | Active | Pay Change | SCI | 822345 | 716499
98765 | 43586 | 0 | Active | Data Adjustment | JED | 822345 | 716499
98765 | 43378 | 0 | Active | Hire | HIR | 822345 | 716499