Introduction

These pages document SecuTix BI and provide:

An overview of SecuTix BI domains
A Description of SecuTix BI domains and of the data included in these domains

This documentation takes automatically into account any changes brought to the domains.

Domains presentation

The following table gives an overview of the domains available in SecuTix BI.

By clicking on one of the report types, you can visualise the detail of the domains linked to this type. You will also find the descriptions of the data contained in these domains.

Type de rapport	Domaine	Description du domaine	Nom technique du domaine
A ccounting	Account follow up	Pending account and credit account follow-up	D_ACCOUNT_FOLLOW_UP_V1_0
A ccounting	List of payments	List of payments and refunds	D_ACCOUNT_LIST_PAYMENTS_V1_0
A ccounting	Voucher management	Voucher management	D_VOUCHER_MANAGEMENT_V1_0
A ttendance	Attendance	Attendance statistics	D_ANALYTICS_ATTEND_V1_0
A vailability	Product follow up	Product availability	D_AVL_PROD_FOLLWUP_V1_0
A vailability	Room availability	Availability of seats in a given room	D_AVL_ROOM_AVL_V1_0
Contact	Contact information	Detailed information of the contact	D_CONTACT_LIST_V1_0
Contact	Contact criteria and other values	All contact information depending on the organization	D_CONTACT_ORG_INFO_V1_0
Contact	Cultural history	Cultural history of a contact	D_CONCT_CULTURAL_HISTORY_V1_0
G oods	Purchase diary	Purchase diary (by cultural institution) of a selection of goods	D_GOODS_PURCHASE_DIARY_V1_0
G oods	Stock status	Stock status of a selection of goods	D_GOODS_STATUS_V1_0
S ales	Link between operation and payment	Link between operation and payment	D_PAYMENT_OPERATION_LINK_V1_0
S ales	List of invoices	List of invoices and payment tracking	D_ACCOUNT_LIST_INVOICE_V1_0
S ales	List of sales	Detailed information on sales	D_SALES_LIST_SALES_V1_0
S ales	Product revenue	Number of sales and revenue	D_SALES_PROD_RECEIPT_V1_0
S ales	List of sales and matching payments	Detailed information on sales and their payment	D_SALES_PROD_PAYMENT_V1_0
S ales	Summary of fees	Revenue due to fees	D_SALES_FEES_V1_0
S eats	List of seats	Detailed information on seats	D_SEATS_LIST_SEATS_V1_0
T ickets	Access control	Access control history	D_ACONTROL_TICKETCHECK_V1_0
T ickets	List of tickets	List of tickets	D_SHIPMENTTICKET_TICKETS_V1_0
T ickets	Questionnaires	Answers to questionnaires	D_SHIPMENTTICKET_QSTNR_V1_0
Visits	Guide planning	Guides availability	D_VISIT_GUIDE_AVL_V1_0
Visits	Visit planning	Visit planning	D_VISIT_PLANNING_DATA_V1_1

Physical data model

Below graphs present the SecuTix BI domains and the interactions between these.

These graphs describe the way to naviguate between domains.

Sales and payments

For instance: From a ticket (D_SHIPMENTTICKET_TICKETS), it is possible to know all controls (D_ACONTROL_TICKETCHECK) of this ticket as well as the answers to potential questionnaire associated to this ticket (D_SHIPTMENTTICKET_QSTNR).

Following links between two domains are not illustrated in the graph for clarity reasons but are available in order to simplify the access:
- Link between D_PAYMENT_OPERATION_LINK and D_CONCT_CULTURAL_HISTORY via T_OPERATION_ID. Cardinality: 0:n, 0:n
- Link between D_SALES_LIST_SALES and D_ACONTROL_TICKETCHECK via T_OPERATION_ID. Cardinality: 1:1, 0:n

- Link between D_PAYMENT_OPERATION_LINK and _ACONTROL_TICKETCHECK via T_OPERATION_ID. Cardinality: 0:n, 0:n
Contact

Lottery

Configuration

Goods

Visits

In above graphs:

Names starting by "T_" represent the fields allowing to navigate from one domain to another.

: indicates that each instance of the entity A is linked to 0 or several instances of B and each instance of B is linked to exactly one instance of A

Following domains are not yet accessible from an external BI tool:

D_SHIPMENTTICKET_QSTNR
D_GOODS_STATUS

SecuTix BI - Documentation

Introduction

Domains presentation

Physical data model