Educational Institution

The mrt_global__educational_institution table lists all schools that are partners in the collective component of the pass Culture.

All schools that have received an EAC credit in any school year since the introduction of the collective component of the pass Culture (end 2021 - beginning 2022) are included.

Table description

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.
ministry		The ministry to which the educational institution belongs. Values can be : AGRICULTURE; AGRICULTURE; EDUCATION_NATIONALE; MER.
institution_type		Type of institution.
institution_program_name		Name of the program at the educational institution.
first_deposit_creation_date		First deposit creation date.
current_deposit_amount		The current amount of deposit for the educational institution.
current_deposit_creation_date		The date when the current deposit was created for the educational institution.
total_deposit_amount		Total amount deposited by the user.
total_deposits		The total number of deposits for the educational institution.
first_booking_date		Date of the first booking.
last_booking_date		Date of the last booking.
total_non_cancelled_collective_bookings		Total number of collective bookings that were not cancelled.
total_current_year_non_cancelled_collective_bookings		The total non cancelled collective bookings for the current year.
total_collective_theoretic_revenue		Total theoretical revenue from collective bookings.
total_current_year_collective_theoretic_revenue		Total collective theoretical revenue for the current year.
total_used_collective_bookings		Total number of collective bookings that were used.
total_current_year_used_collective_bookings		Total collective used bookings for the current year.
total_collective_real_revenue		Total actual revenue from collective bookings.
total_current_year_collective_real_revenue		The total real revenue from collective bookings for the current year.
ratio_current_credit_utilization		The ratio of current credit utilization for the educational institution based on validated bookings
total_tickets		The total number of tickets for the educational institution.
total_current_year_tickets		The total number of tickets for the current year.
total_students		The total number of students for the educational institution.
macro_institution_type		Type of macro institution. Values can be : COLLEGE; ECOLE; LYCEE.
institution_city		City where the educational institution is located.
institution_epci		EPCI code of the educational institution.
institution_density_label		Density label of the educational institution's area.
institution_macro_density_label		Macro density label of the educational institution : rural or urban.
institution_density_level		Density level of the educational institution's area.
institution_latitude		The latitude coordinate of the educational institution.
institution_longitude		The longitude coordinate of the educational institution.
institution_academy_name		Academy name of the educational institution.
institution_region_name		Region name of the educational institution.
institution_in_qpv		Indicates whether the educational institution is located in a QPV or not(Priority Urban Area).
institution_department_code		Department code of the educational institution.
institution_department_name		Department name of the educational institution.
institution_internal_iris_id		Internal IRIS identifier for the educational institution.
institution_postal_code		Postal code of the educational institution.