Table: GAS_PARTICIPANT_OPSTATE

GAS_PARTICIPANT_OPSTATE

Name

GAS_PARTICIPANT_OPSTATE

Comment

The operating status of all registered organisations i.e the BB Participants of the Bulletin Board over time


Primary Key Columns

Name

COMPANYID

EFFECTIVEDATE

MARKETID

VERSIONDATETIME


Content

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