Table: GSH_RCPT_DELIV_POINT_PREFS

GSH_RCPT_DELIV_POINT_PREFS

Name

GSH_RCPT_DELIV_POINT_PREFS

Comment

This report is available to participants as an audit trail of the entries in the CTP Receipt and Delivery Point Preferences markets portal application.


Primary Key Columns

Name

BUY_SELL_POSITION

PARTICIPANT_CODE

PRODUCT_NAME

STEP_NUMBER

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

PARTICIPANT_CODE

VARCHAR2(20)

X

The participant code used in the ETS.

PRODUCT_NAME

VARCHAR2(80)

X

The capacity product name.

BUY_SELL_POSITION

VARCHAR2(4)

X

Specifies the position that the contract reference must be used for, for example Buy, Sell or Both.

STEP_NUMBER

NUMBER(6)

X

The step number for the corresponding capacity quantity.

VERSION_DATETIME

DATE

X

The date and time the preference was updated.

FROM_GAS_DATE

DATE

 

The first gas date that the contract reference takes effect from. Disregard the time component as this is not applicable.

TO_GAS_DATE

DATE

 

The last gas date that the contract reference takes effect until. Disregard the time component as this is not applicable.

OVERRIDE_FLAG

VARCHAR2(3)

 

A flag to indicate whether the receipt and delivery points specified in the original order should override this preference, for example Yes or No.

PRODUCT_RECEIPT_POINT

VARCHAR2(40)

 

The default Receipt Point for Spread Product

RECEIPT_POINT_ID

NUMBER(8,0)

 

The unique identifier of the Receipt Point as defined in the Transportation Service Point Register. This is the point where gas is injected into the pipeline

RECEIPT_POINT_NAME

VARCHAR2(255)

 

The descriptive name of the Receipt Point as defined in the Transportation Service Point Register.

PRODUCT_DELIVERY_POINT

VARCHAR2(40)

 

The default Delivery Point for Spread Product

DELIVERY_POINT_ID

NUMBER(8,0)

 

The unique identifier of the Delivery Point as defined in the Transportation Service Point Register. This is the point where gas is withdrawn from the pipeline. Mandatory for service points registered under Part 24 of the rules.

DELIVERY_POINT_NAME

VARCHAR2(255)

 

The descriptive name of the Delivery Point as defined in the Transportation Service Point Register.

STEP_QUANTITY

NUMBER(10,0)

 

The step quantity to applied to the contract reference (GJ/day).

LAST_UPDATED

DATE

 

The date and time the preference was updated.

LAST_UPDATED_BY

VARCHAR2(20)

 

The user name who updated the preference.

LASTCHANGED

DATE

 

The date and time the report was generated.