|
Name |
|
|
Comment |
The purpose of this report is to provide all GSH participants with a list of all Trading and Delivery contacts details for all registered participants in the GSH market. This report will be made available to all GSH participants. |
|
Name |
|
CONTACT_ID |
|
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 this report it will only be two types: Trading Contact, Gas Delivery Contact |
|
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 |
|
|
|