Table: GSH_CAP_XFR_AUCTION_NOTICE

GSH_CAP_XFR_AUCTION_NOTICE

Name

GSH_CAP_XFR_AUCTION_NOTICE

Comment

Notifies participants when the market delay or cancellation process is triggered


Primary Key Columns

Name

NOTICE_ID


Content

Name

Data Type

Mandatory

Comment

NOTICE_ID

NUMBER(8,0)

X

The unique identifier of the notice.

NOTICE_DATE

DATE

 

The date of the notice

GAS_DATE

DATE

 

The gas date of the notice. Disregard the time component as this is not applicable.

FACILITY_ID

NUMBER(8,0)

 

The unique identifier of the facility.

FACILITY_NAME

VARCHAR2 (100)

 

The descriptive name of the facility.

MARKET

VARCHAR2 (20)

 

The market that has triggered the notice, for example CTP or DAA.

NOTICE_TYPE

VARCHAR2 (50)

 

The type of notice, for example Cancel or Delay for CTP, Exclude or Delay for DAA.

DESCRIPTION

VARCHAR2 (1000)

 

The description of the notice.

LASTCHANGED

DATE

 

The date and time the report was generated.