Table: GSH_NOTIONAL_POINTS

GSH_NOTIONAL_POINTS

Name

GSH_NOTIONAL_POINTS

Comment

Notional Point currently registered under Part 24 of the Rules


Primary Key Columns

Name

EFFECTIVEDATE

FACILITY_ID

PHYSICAL_POINT_NAME

SERVICE_POINT_ID

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

FACILITY_ID

NUMBER(8,0)

X

Unique Facility ID for this market

SERVICE_POINT_ID

NUMBER(8,0)

X

The unique identifier of the service point.

EFFECTIVEDATE

DATE

X

The effective date of the notional point.

VERSION_DATETIME

DATE

X

The version timestamp of the record

SERVICE_POINT_NAME

VARCHAR2(100)

 

The descriptive name of the service point.

PHYSICAL_POINT_NAME

VARCHAR2(100)

X

The descriptive name of the physical point associated with the notional point.

GBB_CONNECTION_POINT_ID

NUMBER(8,0)

 

The corresponding GBB connection point identifier.

LASTCHANGED

DATE

 

The date and time the report was generated.