D_CONTACT_LIST

Version: 1.0

Attribute details

Attribute ID Datatype Data length Nullabe ? Label Description

ADDRESS_SALUTATION VARCHAR2 152 Y Adress salutation Polite salutation for the contact address. The value of the field is defined based on the "Title" field.

BADGE_IDENTIFIER VARCHAR2 400 Y Identifier of card owned by contact

BIC_NUMBER VARCHAR2 11 Y BIC of contact's bank account

BIRTHDATE DATE 7 Y Birth date Date of birth

COMMUNITY CHAR 1 Y Flag indicating whether the structure is a community or not

COMMUNITY_TYPE VARCHAR2 4000 Y Translated value of COMMUNITY_TYPE_IC

COMMUNITY_TYPE_IC VARCHAR2 120 Y Technical identifier of community type
Possible values:
- COMMUNITY/AGENCY
- COMMUNITY/ASSOCIATION
- COMMUNITY/AUTCOLL
- COMMUNITY/UNDEFINED
- COMMUNITY/ENSEIGN
- COMMUNITY/CE
- COMMUNITY/COMITY
- COMMUNITY/TOURISMOFFICE
- COMMUNITY/TOURISM

CONFIDENTIALITY_LEVEL VARCHAR2 4000 Y Translated value of "T_CONFIDENTIALITY_LEVEL"

CONTACT_LANGUAGE VARCHAR2 4000 Y Contact preferred language

CONTACT_NUMBER VARCHAR2 20 Y Contact number Contact number

COUNTRY_CODE CHAR 2 Y Country Contact nationality in the form of a country code

CREATED_DATE TIMESTAMP(6) WITH TIME ZONE 13 Y Date inserted

CREATED_FROM VARCHAR2 20 Y Created from User inserted

EMAIL VARCHAR2 254 Y Email Contact email address

END_VALIDITY_DATE DATE 7 Y Contact end of validity date. Set to "31.12.99" for valid contacts.

END_VALIDITY_REASON VARCHAR2 4000 Y Reason why a contact isn't valid any more

END_VALIDITY_REASON_IC VARCHAR2 120 Y Reason why a contact isn't valid anymore

FIRSTNAME VARCHAR2 400 Y Contact first name

FIRSTNAME_PHONETIC VARCHAR2 100 Y Firstname phonetic

FUNCTION VARCHAR2 400 Y Job title

GENDER VARCHAR2 25 Y Contact gender (M/F)

HANDICAP_TYPE VARCHAR2 4000 Y Translated value of HANDICAP_TYPE_IC

IBAN_NUMBER VARCHAR2 34 Y IBAN of contact's bank account

ID_NUMBER VARCHAR2 100 Y Number of contact's identity document

INSTIT_CODE VARCHAR2 15 N Institution code

INT_PREFIX_CELLPHONE VARCHAR2 10 Y Prefix of contact's mobile phone number

INT_PREFIX_FAX VARCHAR2 10 Y Prefix of the contact's fax number

INT_PREFIX_PHONE1 VARCHAR2 10 Y Prefix of the contact's first phone number

INT_PREFIX_PHONE2 VARCHAR2 10 Y Prefix of the contact's second phone number

INT_PREFIX_PHONE3 VARCHAR2 10 Y Prefix of the contact's third phone number

IS_GUEST CHAR 1 Y Indicates if the contact is a guest

LASTNAME VARCHAR2 400 Y Contact last name

LASTNAME_PHONETIC VARCHAR2 100 Y Lastname phonetic

LAST_MODIFICATION TIMESTAMP(6) WITH TIME ZONE 13 Y Last modification Date of last update of current contact

LAST_MODIFICATION_FROM VARCHAR2 20 Y Last modification from User Updated

LAST_UPDATE TIMESTAMP(6) WITH TIME ZONE 13 Y Date of last update of report data

LEGAL_STATUS_IC VARCHAR2 120 Y Company's legal status

LETTER_SALUTATION VARCHAR2 400 Y Letter salutation Polite salutation used for correspondence with contact

MAIN_ADDR_COUNTRY VARCHAR2 4000 Y Country of contact address

MAIN_ADDR_COUNTRY_CODE CHAR 2 Y Country code of contact address

MAIN_ADDR_GEO_ZONE VARCHAR2 240 Y Provides the name of the geographical zone of the contact's main address

MAIN_ADDR_GEO_ZONE_TYPE VARCHAR2 4000 Y Provides the name of the geographical zone of the contact's main address

MAIN_ADDR_GPS_LAT VARCHAR2 60 Y Provides GPS latitude of contact's main address

MAIN_ADDR_GPS_LONG VARCHAR2 60 Y Provides GPS longitude of contact's main address

MAIN_ADDR_LINE1 VARCHAR2 400 Y First line of contact address

MAIN_ADDR_LINE2 VARCHAR2 400 Y Second line of contact address

MAIN_ADDR_LINE3 VARCHAR2 400 Y Third line of contact address

MAIN_ADDR_TOWN VARCHAR2 400 Y Contact address town

MAIN_ADDR_ZIPCODE VARCHAR2 20 Y Postal code of contact address

NAT_NUMBER_CELLPHONE VARCHAR2 20 Y Contact mobile phone number (including area prefix)

NAT_NUMBER_FAX VARCHAR2 20 Y Contact fax number (including area prefix)

NAT_NUMBER_PHONE1 VARCHAR2 20 Y First contact phone number (including area prefix)

NAT_NUMBER_PHONE2 VARCHAR2 20 Y Second contact phone number (including area prefix)

NAT_NUMBER_PHONE3 VARCHAR2 20 Y Third contact phone number (including area prefix)

NICK_NAME VARCHAR2 400 Y Contact nickname

NUMBER_OF_EMPLOYEES NUMBER 22 Y Number of employees in the company the contact belongs to

PARENT_STRUCTURE_ID NUMBER 22 Y In the case of a structure tree, it is the identifier of the parent structure (for example, the parent company to which a subsidiary belongs).

PREFERRED_LANGUAGE VARCHAR2 4000 Y Company's preferred language

REMARK VARCHAR2 4000 Y Remark Remark on contact

ROLE VARCHAR2 25 Y Role Role of contact.
Possible values are:
- EXHIBITOR
- GUIDE
- PARTNER
- AUDIENCE
- PRODUCER
- RELAY
- SUPPLIER
- SUPPORT

SSO_ID VARCHAR2 255 Y SSO ID

SSO_PROVIDER VARCHAR2 25 Y SSO provider

STRUCTURE_NAME VARCHAR2 152 Y Name of company to which the contact belongs. The name may be truncated if its length exceeds a limit.

STRUCTURE_OFFICIAL_NAME VARCHAR2 400 Y Official name of company to which the contact belongs.

STRUCTURE_TYPE VARCHAR2 240 Y Structure types

STRUCT_CT_NUMBER VARCHAR2 20 Y In the case of a relay, this column represents the number of the company to which the relay belongs

TITLE_IC VARCHAR2 40 Y Contact title

TYPE VARCHAR2 25 Y Type Contact type
Possible values:
- Individual
- Company

T_CONFIDENTIALITY_LEVEL VARCHAR2 25 Y Confidentiality level of contact.
Possible values:
- Free
- Restricted
- Confidential

T_CONTACT_ID NUMBER 22 N Contact technical identifier

T_HANDICAP_TYPE_IC VARCHAR2 120 Y Technical identifier of disability type

T_STRUCTURE_ID NUMBER 22 Y Technical identifier of the company to which the contact belongs

Attribute ID	Datatype	Data length	Nullabe ?	Label	Description
ADDRESS_SALUTATION	VARCHAR2	152	Y	Adress salutation	Polite salutation for the contact address. The value of the field is defined based on the "Title" field.
BADGE_IDENTIFIER	VARCHAR2	400	Y		Identifier of card owned by contact
BIC_NUMBER	VARCHAR2	11	Y		BIC of contact's bank account
BIRTHDATE	DATE	7	Y	Birth date	Date of birth
COMMUNITY	CHAR	1	Y		Flag indicating whether the structure is a community or not
COMMUNITY_TYPE	VARCHAR2	4000	Y		Translated value of COMMUNITY_TYPE_IC
COMMUNITY_TYPE_IC	VARCHAR2	120	Y		Technical identifier of community type Possible values: - COMMUNITY/AGENCY - COMMUNITY/ASSOCIATION - COMMUNITY/AUTCOLL - COMMUNITY/UNDEFINED - COMMUNITY/ENSEIGN - COMMUNITY/CE - COMMUNITY/COMITY - COMMUNITY/TOURISMOFFICE - COMMUNITY/TOURISM
CONFIDENTIALITY_LEVEL	VARCHAR2	4000	Y		Translated value of "T_CONFIDENTIALITY_LEVEL"
CONTACT_LANGUAGE	VARCHAR2	4000	Y		Contact preferred language
CONTACT_NUMBER	VARCHAR2	20	Y	Contact number	Contact number
COUNTRY_CODE	CHAR	2	Y	Country	Contact nationality in the form of a country code
CREATED_DATE	TIMESTAMP(6) WITH TIME ZONE	13	Y		Date inserted
CREATED_FROM	VARCHAR2	20	Y	Created from	User inserted
EMAIL	VARCHAR2	254	Y	Email	Contact email address
END_VALIDITY_DATE	DATE	7	Y		Contact end of validity date. Set to "31.12.99" for valid contacts.
END_VALIDITY_REASON	VARCHAR2	4000	Y		Reason why a contact isn't valid any more
END_VALIDITY_REASON_IC	VARCHAR2	120	Y		Reason why a contact isn't valid anymore
FIRSTNAME	VARCHAR2	400	Y		Contact first name
FIRSTNAME_PHONETIC	VARCHAR2	100	Y		Firstname phonetic
FUNCTION	VARCHAR2	400	Y		Job title
GENDER	VARCHAR2	25	Y		Contact gender (M/F)
HANDICAP_TYPE	VARCHAR2	4000	Y		Translated value of HANDICAP_TYPE_IC
IBAN_NUMBER	VARCHAR2	34	Y		IBAN of contact's bank account
ID_NUMBER	VARCHAR2	100	Y		Number of contact's identity document
INSTIT_CODE	VARCHAR2	15	N		Institution code
INT_PREFIX_CELLPHONE	VARCHAR2	10	Y		Prefix of contact's mobile phone number
INT_PREFIX_FAX	VARCHAR2	10	Y		Prefix of the contact's fax number
INT_PREFIX_PHONE1	VARCHAR2	10	Y		Prefix of the contact's first phone number
INT_PREFIX_PHONE2	VARCHAR2	10	Y		Prefix of the contact's second phone number
INT_PREFIX_PHONE3	VARCHAR2	10	Y		Prefix of the contact's third phone number
IS_GUEST	CHAR	1	Y		Indicates if the contact is a guest
LASTNAME	VARCHAR2	400	Y		Contact last name
LASTNAME_PHONETIC	VARCHAR2	100	Y		Lastname phonetic
LAST_MODIFICATION	TIMESTAMP(6) WITH TIME ZONE	13	Y	Last modification	Date of last update of current contact
LAST_MODIFICATION_FROM	VARCHAR2	20	Y	Last modification from	User Updated
LAST_UPDATE	TIMESTAMP(6) WITH TIME ZONE	13	Y		Date of last update of report data
LEGAL_STATUS_IC	VARCHAR2	120	Y		Company's legal status
LETTER_SALUTATION	VARCHAR2	400	Y	Letter salutation	Polite salutation used for correspondence with contact
MAIN_ADDR_COUNTRY	VARCHAR2	4000	Y		Country of contact address
MAIN_ADDR_COUNTRY_CODE	CHAR	2	Y		Country code of contact address
MAIN_ADDR_GEO_ZONE	VARCHAR2	240	Y		Provides the name of the geographical zone of the contact's main address
MAIN_ADDR_GEO_ZONE_TYPE	VARCHAR2	4000	Y		Provides the name of the geographical zone of the contact's main address
MAIN_ADDR_GPS_LAT	VARCHAR2	60	Y		Provides GPS latitude of contact's main address
MAIN_ADDR_GPS_LONG	VARCHAR2	60	Y		Provides GPS longitude of contact's main address
MAIN_ADDR_LINE1	VARCHAR2	400	Y		First line of contact address
MAIN_ADDR_LINE2	VARCHAR2	400	Y		Second line of contact address
MAIN_ADDR_LINE3	VARCHAR2	400	Y		Third line of contact address
MAIN_ADDR_TOWN	VARCHAR2	400	Y		Contact address town
MAIN_ADDR_ZIPCODE	VARCHAR2	20	Y		Postal code of contact address
NAT_NUMBER_CELLPHONE	VARCHAR2	20	Y		Contact mobile phone number (including area prefix)
NAT_NUMBER_FAX	VARCHAR2	20	Y		Contact fax number (including area prefix)
NAT_NUMBER_PHONE1	VARCHAR2	20	Y		First contact phone number (including area prefix)
NAT_NUMBER_PHONE2	VARCHAR2	20	Y		Second contact phone number (including area prefix)
NAT_NUMBER_PHONE3	VARCHAR2	20	Y		Third contact phone number (including area prefix)
NICK_NAME	VARCHAR2	400	Y		Contact nickname
NUMBER_OF_EMPLOYEES	NUMBER	22	Y		Number of employees in the company the contact belongs to
PARENT_STRUCTURE_ID	NUMBER	22	Y		In the case of a structure tree, it is the identifier of the parent structure (for example, the parent company to which a subsidiary belongs).
PREFERRED_LANGUAGE	VARCHAR2	4000	Y		Company's preferred language
REMARK	VARCHAR2	4000	Y	Remark	Remark on contact
ROLE	VARCHAR2	25	Y	Role	Role of contact. Possible values are: - EXHIBITOR - GUIDE - PARTNER - AUDIENCE - PRODUCER - RELAY - SUPPLIER - SUPPORT
SSO_ID	VARCHAR2	255	Y		SSO ID
SSO_PROVIDER	VARCHAR2	25	Y		SSO provider
STRUCTURE_NAME	VARCHAR2	152	Y		Name of company to which the contact belongs. The name may be truncated if its length exceeds a limit.
STRUCTURE_OFFICIAL_NAME	VARCHAR2	400	Y		Official name of company to which the contact belongs.
STRUCTURE_TYPE	VARCHAR2	240	Y		Structure types
STRUCT_CT_NUMBER	VARCHAR2	20	Y		In the case of a relay, this column represents the number of the company to which the relay belongs
TITLE_IC	VARCHAR2	40	Y		Contact title
TYPE	VARCHAR2	25	Y	Type	Contact type Possible values: - Individual - Company
T_CONFIDENTIALITY_LEVEL	VARCHAR2	25	Y		Confidentiality level of contact. Possible values: - Free - Restricted - Confidential
T_CONTACT_ID	NUMBER	22	N		Contact technical identifier
T_HANDICAP_TYPE_IC	VARCHAR2	120	Y		Technical identifier of disability type
T_STRUCTURE_ID	NUMBER	22	Y		Technical identifier of the company to which the contact belongs