Table: GSH_ZONE_CURTAILMENT

GSH_ZONE_CURTAILMENT

Name

GSH_ZONE_CURTAILMENT

Comment

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


Primary Key Columns

Name

FACILITY_ID

GAS_DATE

SERVICE_POINT_ID


Content

Name

Data Type

Mandatory

Comment

FACILITY_ID

NUMBER(8,0)

X

The unique identifier of the parent facility.

FACILITY_NAME

VARCHAR2(100)

 

The descriptive name of the parent facility.

SERVICE_POINT_ID

NUMBER(8,0)

X

The unique identifier of the service point.

SERVICE_POINT_NAME

VARCHAR2(100)

 

The descriptive name of the service point.

SERVICE_POINT_TYPE

VARCHAR2(100)

 

The type of service point, for example forward haul receipt point, forward haul delivery point, backhaul receipt point, backhaul delivery point, compression receipt point or compression delivery point.

SERVICE_POINT_DESCRIPTION

VARCHAR2(255)

 

The description of the service point.

GAS_DATE

DATE

X

The effective gas date of the rejected nomination quantity.

CURTAILED_QUANTITY

NUMBER(10,0)

 

The curtailed quantity of nominations by the facility operator for transportation capacity that has been transferred pursuant to an operational transfer (GJ)

LASTCHANGED

DATE

 

The date and time the report was generated.