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 |
|
|
|