Eple Aggregated

The mrt_collective__eple_aggregated is designed to store comprehensive information about institutions.

Table description

This table contains informations about institutions that can book ou were able to book collective offers.

name	data_type	description
institution_id		Id of the institution.
institution_external_id		The external identifier for the educational institution.
institution_name		Name of the educational institution.
institution_city_code		City code where the educational institution is located.
institution_city		City where the educational institution is located.
institution_department_code		Department code of the educational institution.
institution_region_name		Region name of the educational institution.
institution_academy_name		Academy name of the educational institution.
institution_epci		EPCI name of the educational institution.
institution_epci_code		EPCI code of the educational institution.
ministry		The ministry to which the educational institution belongs. Values can be : AGRICULTURE; AGRICULTURE; EDUCATION_NATIONALE; MER.
institution_type		Type of institution.
macro_institution_type		Type of macro institution. Values can be : COLLEGE; ECOLE; LYCEE.
institution_program_name		Name of the program at the educational institution.
institution_macro_density_label		Macro density label of the educational institution : rural or urban.
scholar_year		Scholar year of the deposit.
total_students		The total number of students for the educational institution.
sept_dec_deposit		Amount of sept-dec deposit - only for the institutions and scholar year with a split deposit.
jan_aug_deposit		Amount of jan-aug deposit - only for the institutions and scholar year with a split deposit.
sept_dec_total_theoric_bookings		Total non cancelled collective bookings made during sept-dec period - only for the institutions and scholar year with a split deposit.
jan_aug_total_theoric_bookings		Total non cancelled collective bookings made during jan-aug period - only for the institutions and scholar year with a split deposit.
sept_dec_theoric_amount_spent		Total amount associated to the number of non cancelled collective bookings made during sept-dec period - only for the institutions and scholar year with a split deposit.
jan_aug_theoric_amount_spent		Total amount associated to the number of non cancelled collective bookings made during jan-aug period - only for the institutions and scholar year with a split deposit.
sept_dec_total_confirmed_bookings		Total confirmed, used and reimbursed collective bookings made during sept-dec period - only for the institutions and scholar year with a split deposit.
jan_aug_total_confirmed_bookings		Total confirmed, used and reimbursed collective bookings made during jan-aug period - only for the institutions and scholar year with a split deposit.
sept_dec_real_amount_spent		Total amount associated to the number of used and reimbursed collective bookings made during sept-dec period - only for the institutions and scholar year with a split deposit.
jan_aug_real_amount_spent		Total amount associated to the number of used and reimbursed collective bookings made during jan-aug period - only for the institutions and scholar year with a split deposit.
sept_dec_reimbursed_amount		Total reimbursed amount during sept-dec period - only for the institutions and scholar year with a split deposit.
jan_aug_reimbursed_amount		Total reimbursed amount during jan-aug period - only for the institutions and scholar year with a split deposit.
total_scholar_year_deposit		Total amount of the educational deposit for the scholar year (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
is_split_deposit		Whether or not the scholar year has one or two deposit.s associated.
all_year_total_theoric_bookings		Total non cancelled collective bookings made during scholar year (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
all_year_theoric_amount_spent		Total amount associated to the number of non cancelled collective bookings made during scholar year (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
pct_all_year_theoric_amount_spent		All year theoric amount spent / all year deposit.
pct_sept_dec_theoric_amount_spent		Sept-dec theoric amount spent / sept_dec deposit (only for the institutions and scholar year with a split deposit).
pct_jan_aug_theoric_amount_spent		Jan-aug theoric amount spent / jan-aug deposit (only for the institutions and scholar year with a split deposit).
all_year_total_confirmed_bookings		Total confirmed, used and reimbursed collective bookings made during scholar year (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
all_year_real_amount_spent		Total amount associated to the number of used and reimbursed collective bookings made during scholar year (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
pct_sept_dec_real_amount_spent		Sept-dec real amount spent / sept-dec deposit (only for the institutions and scholar year with a split deposit).
pct_jan_aug_real_amount_spent		Jan-aug real amount spent / jan-aug deposit (only for the institutions and scholar year with a split deposit).
pct_all_year_real_amount_spent		Total scholar real amount spent / total scholar_year deposit (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
all_year_reimbursed_amount		Total reimbursed amount during scholar year (if the deposit is split it is the sum of sept-dec and jan-aug deposit).
pct_sept_dec_reimbursed_amount_spent		Sept-dec reimbursed amount / sept-dec deposit (only for the institutions and scholar year with a split deposit).
pct_jan_aug_reimbursed_amount_spent		Jan-aug reimbursed amount / jan-aug deposit (only for the institutions and scholar year with a split deposit).
pct_all_year_reimbursed_amount_spent		Scholar year reimbursed amount / scholar year deposit (if the deposit is split it is the sum of sept-dec and jan-aug deposit).