Table: GAS_PARTICIPANT_CONTACT_TRK

GAS_PARTICIPANT_CONTACT_TRK

Name

GAS_PARTICIPANT_CONTACT_TRK

Comment

The tracking of sets of contacts against a gas participant over time


Primary Key Columns

Name

COMPANYID

EFFECTIVEDATE

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

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

AUTHORISEDDATE

Date

 

Date and time this operating state was authorised

AUTHORISEDBY

Varchar2 (30)

 

User which authorised the change