Table: GSH_PARTICIPANT_CONTACTS

GSH_PARTICIPANT_CONTACTS

Name

GSH_PARTICIPANT_CONTACTS

Comment

The purpose of this report is to provide the participant with a list of all their contact details.


Primary Key Columns

Name

CONTACT_ID


Content

Name

Data Type

Mandatory

Comment

CONTACT_ID

VARCHAR2(20)

X

The unique identifier for the contact

PARTICIPANT_CODE

VARCHAR2(20)

 

The participant code

PARTICIPANT_NAME

VARCHAR2(80)

 

The trading participant name

ROLE

VARCHAR2(80)

 

Contact type, for example: Trading Contact, Gas Delivery Contact, System contact, Regulatory contact, Head office contact, Primary settlements contact, Secondary settlements contact, Settlements manager contact, CFO, CEO, First Escalation settlements, Second escalation settlements, Third escalation settlements

FIRST_NAME

VARCHAR2(80)

 

First name of the contact

LAST_NAME

VARCHAR2(80)

 

Last name of the contact

SALUTATION

VARCHAR2(20)

 

Salutation of the contact

JOB_TITLE

VARCHAR2(80)

 

Job title for the contact

ADDRESS_LINE_1

VARCHAR2(80)

 

The address of the contact

ADDRESS_LINE_2

VARCHAR2(80)

 

The address of the contact

ADDRESS_LINE_3

VARCHAR2(80)

 

The address of the contact

ADDRESS_LINE_4

VARCHAR2(80)

 

The address of the contact

BUSINESS_PHONE_NUMBER

VARCHAR2(80)

 

The business phone number for the contact

MOBILE_NUMBER

VARCHAR2(80)

 

Mobile number of the contact

FAX_NUMBER

VARCHAR2(80)

 

Fax number for the contact

EMAIL_ADDRESS

VARCHAR2(255)

 

Email address of the contact

LASTCHANGED

DATE

 

The date and time the report is issued