1 | personid | originalstart | finalend | pos |
|---|---|---|---|---|
2 | 1 | 1/1/2010 | 12/1/2010 | 100-1 |
3 | 2 | 2/1/2010 | 5/1/2010 | 200-1 |
4 | 2 | 7/1/2010 | 10/1/2010 | 200-2 |
5 | 3 | 5/1/2010 | 7/1/2010 | 300-1 |
6 | 3 | 8/1/2010 | 10/1/2010 | 300-2 |
7 | 3 | 11/1/2010 | 12/1/2010 | 300-3 |
1 | personid | termstart | termend | pos |
|---|---|---|---|---|
2 | 1 | 8/1/2010 | 9/1/2010 | blah |
3 | 1 | 3/1/2010 | 5/1/2010 | blah |
4 | 2 | 7/1/2010 | 10/1/2010 | blah |
5 | 2 | 3/1/2010 | 5/1/2010 | blah |
6 | 2 | 2/1/2010 | 3/1/2010 | blah |
7 | 3 | 11/1/2010 | 12/1/2015 | blah |
8 | 3 | 9/1/2010 | 10/1/2010 | blah |
9 | 3 | 8/1/2010 | 9/1/2010 | blah |
10 | 3 | 7/5/2010 | 7/15/2010 | blah |
11 | 3 | 5/1/2010 | 7/1/2010 | blah |
1 | wr.personid | originalstart | finalend | wr.pos | wt.personid | termstart | termend | wt.pos |
|---|---|---|---|---|---|---|---|---|
2 | 1 | 1/1/2010 | 12/1/2010 | 100-1 | 1 | 8/1/2010 | 9/1/2010 | blah |
3 | 1 | 1/1/2010 | 12/1/2010 | 100-1 | 1 | 3/1/2010 | 5/1/2010 | blah |
4 | 2 | 2/1/2010 | 5/1/2010 | 200-1 | 2 | 3/1/2010 | 5/1/2010 | blah |
5 | 2 | 2/1/2010 | 5/1/2010 | 200-1 | 2 | 2/1/2010 | 3/1/2010 | blah |
6 | 2 | 7/1/2010 | 10/1/2010 | 200-2 | 2 | 7/1/2010 | 10/1/2010 | blah |
7 | 3 | 5/1/2010 | 7/1/2010 | 300-1 | 3 | 5/1/2010 | 7/1/2010 | pos |
8 | 3 | 8/1/2010 | 10/1/2010 | 300-2 | 3 | 9/1/2010 | 10/1/2010 | blah |
9 | 3 | 8/1/2010 | 10/1/2010 | 300-2 | 3 | 8/1/2010 | 9/1/2010 | blah |
1 | personid | termstart | termend | pos |
|---|---|---|---|---|
2 | 1 | 8/1/2010 | 9/1/2010 | 100-1 |
3 | 1 | 3/1/2010 | 5/1/2010 | 100-1 |
4 | 2 | 7/1/2010 | 10/1/2010 | 200-2 |
5 | 2 | 3/1/2010 | 5/1/2010 | delete |
6 | 2 | 2/1/2010 | 3/1/2010 | delete |
7 | 3 | 11/1/2010 | 12/1/2015 | delete |
8 | 3 | 9/1/2010 | 10/1/2010 | delete |
9 | 3 | 8/1/2010 | 9/1/2010 | delete |
10 | 3 | 7/5/2010 | 7/15/2010 | delete |
11 | 3 | 5/1/2010 | 7/1/2010 | delete |