|
Name |
|
|
Comment |
The purpose of this report is to provide the participant with a list of all their contact details. |
|
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 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 |
|
|
|