|
Name |
|
|
Comment |
Operating Status of Participant |
|
Name |
|
EFFECTIVEDATE |
|
MARKET_ID |
|
PARTICIPANT_ID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKET_ID |
VARCHAR2(20) |
X |
Unique Market ID |
|
PARTICIPANT_ID |
VARCHAR2(20) |
X |
Unique Participant ID for this market |
|
EFFECTIVEDATE |
DATE |
X |
The Effective date of the Participant Operating State |
|
VERSION_DATETIME |
DATE |
X |
Versioning with EffectiveDate |
|
STATUS |
VARCHAR2(30) |
|
Current State of the Product (ACTIVE/INACTIVE) |
|
AUTHORISEDDATE |
DATE |
|
The date of the latest authorisation record |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
|
|