Table: GSH_AUCTION_CURTAIL_NOTICE

GSH_AUCTION_CURTAIL_NOTICE

Name

GSH_AUCTION_CURTAIL_NOTICE

Comment

Contains details of curtailment of nominations against secondary firm rights (CTP trades) for service points (receipt and delivery points).


Primary Key Columns

Name

AUCTION_SERVICE

EFFECTIVE_DATE_TIME

FACILITY_ID

GAS_DATE

NOTICE_ID


Content

Name

Data Type

Mandatory

Comment

NOTICE_ID

NUMBER(8,0)

X

The unique identifier of the notice.

FACILITY_ID

NUMBER(8,0)

X

The unique facility identifier as defined in the Transportation Facility Register.

CURTAILED

VARCHAR2(3)

 

A flag to indicate curtailment

MATERIAL

VARCHAR2(3)

 

Flag to indicate material curtailment

DESCRIPTION

VARCHAR2(255)

 

A description of the curtailment.

EFFECTIVE_DATE_TIME

DATE

X

The date and time the curtailment is effective from.

FACILITY_NAME

VARCHAR2(100)

 

The descriptive name of the facility.

AUCTION_SERVICE

VARCHAR2(20)

X

The auction service impacted by curtailment

GAS_DATE

DATE

X

The gas date for which the auction service is curtailed.

LASTCHANGED

DATE

 

The date and time the report was generated.