|
Name |
|
|
Comment |
MARKETNOTICEDATA shows market notices data provided to all participants (market) and specific participants (participant). |
|
MARKETNOTICEDATA data is confidential to each participant, although some notices are sent to all participants. Source MARKETNOTICEDATA updates immediately available. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public |
|
Name |
|
NOTICEID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
NOTICEID |
NUMBER(10,0) |
X |
Notice Identifier |
|
EFFECTIVEDATE |
DATE |
|
Effective Date of Market notice |
|
TYPEID |
VARCHAR2(25) |
|
Market Notice Type Identifier (Market - all participants. Participant - selected participants) |
|
NOTICETYPE |
VARCHAR2(25) |
|
Market Notice Type |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REASON |
VARCHAR2(2000) |
|
Detail of market notices. |
|
EXTERNALREFERENCE |
VARCHAR2(255) |
|
External Reference for extra data pertaining to market notice |
|
Name |
|
|
Comment |
MARKETNOTICETYPE sets out the different types of market notices (e.g. market systems). |
|
MARKETNOTICETYPE data is public, so is available to all participants. Source MARKETNOTICETYPE updates whenever market notice types change. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
TYPEID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
TYPEID |
VARCHAR2(25) |
X |
Identifier for market notice type |
|
DESCRIPTION |
VARCHAR2(64) |
|
Type description |
|
RAISEDBY |
VARCHAR2(10) |
|
Not used |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
PARTICIPANTNOTICETRK provides the cross-reference between participant market notices and participants. |
|
PARTICIPANTNOTICETRK data is Confidential to the relevant participant. Source PARTICIPANTNOTICETRK updates immediately, whenever a participant notice is issued. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
NOTICEID |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
NOTICEID |
NUMBER(10,0) |
X |
Market notice identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|