You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  • No labels