Domain - Contact information
Domain description
This domain contains the contact detailed information and corresponds to the table D_CONTACT_LIST_V1_0 in which:
1 record = 1 contact. Prospects are also included. Every record contains information related to:
The contact itself (e.g. first name, last name)
Postal address
Communications channel (email address, telephone number)
Information related to the structure if the contact is a structure’s relay
A record is identified in a unique way by means of the attribute T_CONTACT_ID. In case of relay, a first record describes the person and a second record describes the structure linked to the relay.
Domain's columns description
The following link contains more information related to the range of data of the domain: linkmissing
Domain - Contact criteria and other values
Domain description
This domain contains all information of a contact linked to a structure and corresponds to the table D_CONTACT_ORG_INFO_V1_0 in which:
1 record = 1 information linked to a given contact for a given organization with the information related to:
- Financial information
Communication authorizations
Contact criteria
Indicators
Personal data of a loyalty program
Notes about the contact
A record is identified in a unique way by means of the attributes: T_CONTACT_ID, ORGANIZATION, T_INFORMATION_KIND, T_INFORMATION_CODE, INFORMATION_RANK.
Domain's columns description
The following link contains more information related to the range of data of the domain: linkmissing
Domain - Cultural history
Domain description
This domain contains the cultural history of a contact and corresponds to the table D_CONCT_CULTURAL_HISTORY_V1_0 in which:
1 record = 1 contact benefiting of a given product as part of a given operation (sales or reservation) with information related to:
Beneficiary (cultural contact) and his/her address
The product (including its price, tariff and location in the seat map)
The buyer (purchase contact and file contact)
Order executor (operator)
A record is identified in a unique way by means of the attribute T_MOVEMENT_ID.
Domain's columns description
The following link contains more information related to the range of data of the domain: linkmissing