Table: GAS_CONTACT_DETAIL

GAS_CONTACT_DETAIL

Name

GAS_CONTACT_DETAIL

Comment

The registered user list details of responsible contact persons for each BB Participant organisation as identified at registration or otherwise


Primary Key Columns

Name

EFFECTIVEDATE

PERSONID

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

PERSONID

Number(10,0)

X

Unique person identifier

EFFECTIVEDATE

Date

X

Effective date for this operating state

VERSIONDATETIME

Date

X

Version date time for this operating state

POSITION

varchar2(40)

 

Position of person

PHONE

Varchar2 (30)

 

Landline phone of person

FAX

Varchar2 (30)

 

Facsimile of person

MOBILE

Varchar2 (30)

 

Mobile phone of person

EMAIL

Varchar2 (255)

 

Email address of person

AUTHORISEDDATE

Date

 

Date and time this operating state was authorised

AUTHORISEDBY

Varchar2 (30)

 

User which authorised the change