Table: GSH_PARTICIPANT_OPSTATE

GSH_PARTICIPANT_OPSTATE

Name

GSH_PARTICIPANT_OPSTATE

Comment

Operating Status of Participant


Primary Key Columns

Name

EFFECTIVEDATE

MARKET_ID

PARTICIPANT_ID

VERSION_DATETIME


Content

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