Table: GAS_FACILITY_OWNER_TRK

GAS_FACILITY_OWNER_TRK

Name

GAS_FACILITY_OWNER_TRK

Comment

The tracking of Facility ownership 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

LASTCHANGED

DATE

 

Date and time record was last modified