|
Name |
|
|
Comment |
The operating status of all registered organisations i.e the BB Participants of the Bulletin Board over time |
|
Name |
|
COMPANYID |
|
EFFECTIVEDATE |
|
MARKETID |
|
VERSIONDATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKETID |
Varchar2(20) |
X |
Unique Market identifier |
|
COMPANYID |
Number(10,0) |
X |
Unique company identifier |
|
EFFECTIVEDATE |
Date |
X |
Effective date for this operating state |
|
VERSIONDATETIME |
Date |
X |
Version date time for this operating state |
|
OPERATINGSTATE |
Varchar2 (20) |
|
Operating status - active, inactive |
|
AUTHORISEDDATE |
Date |
|
Date and time this operating state was authorised |
|
AUTHORISEDBY |
Varchar2 (30) |
|
User which authorised the change |
|
|
|