Sample CATS_NMI_PARTICIPANT_RELATIONS table
|
ID |
Participant ID |
NMI |
Role ID |
Start date |
End date |
MAINTACTFLG |
MAINTUPDTDT |
MAINTCREATEDT |
|---|---|---|---|---|---|---|---|---|
|
1 |
RETSOUTH |
XXXXXXXX24 |
FRMP |
01-Feb-02 |
31-Dec-99 |
I |
03-Apr-2002 1:04 |
02-Feb-2002 1:44 |
|
2 |
RETSOUTH |
XXXXXXXX24 |
FRMP |
01-Feb-02 |
31-Mar-02 |
I |
09-Nov-2002 1:20 |
03-Apr-2002 1:04 |
|
3 |
RETEAST |
XXXXXXXX24 |
FRMP |
01-Apr-02 |
31-Dec-99 |
I |
09-Nov-2002 1:20 |
03-Apr-2002 1:04 |
|
4 |
RETSOUTH |
XXXXXXXX24 |
FRMP |
01-Feb-02 |
28-Feb-02 |
A |
31-Dec-99 |
09-Nov-2002 1:20 |
|
5 |
RETWEST |
XXXXXXXX25 |
FRMP |
01-Mar-02 |
31-Mar-02 |
A |
31-Dec-99 |
09-Nov-2002 1:20 |
|
6 |
RETWEST |
XXXXXXXX24 |
FRMP |
01-Apr-02 |
15-Aug-02 |
A |
31-Dec-99 |
09-Nov-2002 1:20 |
|
7 |
RETEAST |
XXXXXXXX24 |
FRMP |
16-Aug-02 |
31-Dec-99 |
A |
31-Dec-99 |
09-Nov-2002 1:20 |