BCN - N_FORMATION_DIPLOME, les données (via une requête)

Consultation N_FORMATION_DIPLOME (exécution d'une requête)

STATUT ID	FORMATION DIPLOME	NIVEAU FORMATION DIPLOME	GROUPE SPECIALITE	LETTRE SPECIALITE	ANCIEN RECME	LIBELLE COURT	LIBELLE STAT 33	LIBELLE LONG 200	DATE OUVERTURE	DATE FERMETURE	ANCIEN DIPLOME 1	ANCIEN DIPLOME 2	ANCIEN DIPLOME 3	NOUVEAU DIPLOME 1	UNITE CAPITALISABLE	DATE PREMIERE SESSION	DATE DERNIERE SESSION	DATE ARRETE CREATION	DATE ARRETE ABROGATION	DATE ARRETE MODIFICATION 1	DATE ARRETE MODIFICATION 2	DATE ARRETE MODIFICATION 3	DATE ARRETE MODIFICATION 4	DATE ARRETE MODIFICATION 5	DATE ARRETE MODIFICATION 6	DATE ARRETE MODIFICATION 7	DATE ARRETE MODIFICATION 8	COMMENTAIRE	NATURE FORMATION DIPLOME	GESTIONNAIRE FORMATION DIPLOME	DATE INTERVENTION	NUMERO COMPTE	GESTION DIFFUSION	NB MEF OUVERT	NB MEF FERME	CITE DOMAINE FORMATION	DATE SESSION RATTRAPAGE	OBSERVATION	ID	UPDATED AT	CITE DOMAINE DETAILLE	NIVEAU QUALIFICATION RNCP	DATE STATUT

1	51032404	510	324	M		BEP	METIERS SERVICES ADMINISTRATIFS	METIERS DES SERVICES ADMINISTRATIFS (BEP)	01/09/2010	31/08/2021	51031401	51032403				2011	2021	30/07/2009	20/10/2020									Fermeture BEP* - demande DGESCO B22	1	DGESCO A2-3	04/05/2021	BCNVICTOR	02	0	0	345		Remplacé progressivement par l’attestation de réussite intermédiaire en bac pro, en fin de 1ère professionnelle	3334		0413	03	06/07/2021
1	51032402	510	324	T	513004	BEP	COMMUNICATION ADMIN.& SECRETARIAT	COMMUNICATION ADMINISTRATIVE ET SECRETARIAT (BEP)	04/12/1986	31/08/1997				51032403	O	1988	1997	04/12/1986	23/08/1996	11/01/1988	31/07/1989	22/11/1989	27/01/1993					REMPLACE PAR LE BEP METIERS DU SECRETARIAT (51032403T).	1	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	3	346			11			03	06/07/2021
1	32032409	320	324	T		BTS	SUPPORT A L'ACTION MANAGERIALE	SUPPORT A L'ACTION MANAGERIALE (BTS)	01/09/2018		32032408					2020		16/02/2018											1	DGESIP A2	10/12/2020	BCNVICTOR	02	3	0	345			5499		0413	05	06/07/2021
1	32032408	320	324	T		BTS	ASSISTANT DE MANAGER	ASSISTANT DE MANAGER (BTS)	01/09/2008	31/08/2019	32032406			32032409		2010	2019	15/01/2008	16/02/2018	10/04/2008	22/07/2008	08/04/2009	11/06/2009	23/09/2009	25/02/2010	03/06/2010	28/10/2010	REMPLACE LES BTS ASSISTANT DE DIRECTION (32032405T) & ASSISTANT SECRETAIRE TRILINGUE (32032406T).	1	DGESIP A2	10/12/2020	BCNVICTOR	02	0	3	345			2930		0413	05	06/07/2021
1	51032401	510	324	T	510185	BEPA	SECRETARIAT ACCUEIL	SECRETARIAT ACCUEIL (BEPA)	21/07/1992	31/08/1996						1994		01/01/1992											2	SPN AGRI	10/12/2020	BCNVICTOR	02	0	1	346			63			03	06/07/2021
1	45032401	450	324	T	453001	BP	BUREAUTIQUE	BUREAUTIQUE (BP)	18/09/1989	31/08/2024	45031401	45032402	45032601			1991	2023	18/09/1989	09/02/2022	05/07/1991	29/07/1992	28/04/1993	03/09/1997					REMPLACE LES BP COMPTABLE (45031401T), SECRETAIRE (45032402T) & INFORMATIQUE (45032601T). DECOUPAGE EN UNITES PAR ARRÊTE DU 03/09/1997 A PARTIR DE LA SESSION 1998 (pas de changement de code).	1	DGESCO A2-3	12/04/2022	BCNSCO7	02	0	2	346	2024	Comporte 3 options ne figurant pas dans l'intitulé de l'arrêté (Communication & organisation administrative, Administration financière & comptable, Assistance bureautique).	669		0415	04	12/04/2022
1	32032406	320	324	T	323008	BTS	ASSISTANT SECRETAIRE TRILINGUE	ASSISTANT SECRETAIRE TRILINGUE (BTS)	10/06/1994	31/08/2009	32032403	32032404		32032408		1996	2009	10/06/1994	15/01/2008	11/04/1996	03/09/1997	22/05/1998	22/07/2008					REMPLACE LES BTS 32032403T & 32032404T. DECOUP.UNITES PAR ARRÊTE DU 03/09/1997 A PARTIR SES.1998 (pas de changement de code). REMPLACE, AVEC 32032405T, PAR LE BTS ASSISTANT DE MANAGER (32032408T).	1	DGESIP A2	10/12/2020	BCNVICTOR	02	0	3	346			1020			05	06/07/2021
1	32032403	320	324	T	323005	BTS	BUREAUTIQ.SECRET_B: SECRET.TRILIN	BUREAUTIQUE ET SECRETARIAT OPTION B : SECRETARIAT TRILINGUE (BTS)	17/07/1986	31/08/1996				32032406		1988	1995	17/07/1986	10/06/1994	11/06/1987	10/03/1988							REMPLACE, AVEC L'OPTION C : SECRETARIAT COMMERCIAL BILINGUE (32032404T), PAR LE BTS ASSISTANT SECRETAIRE TRILINGUE (32032406T).	1	DGESIP A2	10/12/2020	BCNVICTOR	02	0	2	346		3 OPTIONS : A- SECRETARIAT DE DIRECTION (32032402T), B- SECRETARIAT TRILINGUE (32032403T), C- SECRETARIAT COMMERCIAL BILINGUE (32032404T).	1018			05	06/07/2021
1	32032407	320	324	P		BTS	COMMUNICATION DES ENTREPRISES	COMMUNICATION DES ENTREPRISES (BTS)	01/09/1995	02/09/1995																		ERREUR DE CODE NSF: RECODE EN 32032001P.	Z	DGESIP A2	10/12/2020	BCNVICTOR	13	0	1	999		Aucun élève inscrit.	1435			05	06/07/2021
1	45032402	450	324	T	453004	BP	SECRETAIRE	SECRETAIRE (BP)	11/10/1977	31/08/1993				45032401	O	1978	1993	11/10/1977	18/09/1989									DERNIERE SESSION EN 1993 POUR LES BP DELIVRES PAR UCC. REMPLACE PAR LE BP BUREAUTIQUE (45032401T).	1	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	0	999			640			04	06/07/2021
1	51032403	510	324	T		BEP	METIERS DU SECRETARIAT	METIERS DU SECRETARIAT (BEP)	01/09/1996	31/08/2011	51032402			51032404	O	1998	2010	23/08/1996	30/07/2009									A REMPLACE LE BEP COMMUNICATION ADMINISTRATIVE & SECRETARIAT (51032402T). REMPLACE, AVEC LE BEP METIERS DE LA COMPTABILITE (51031401T), PAR LE BEP METIERS DES SERVICES ADMINISTRATIFS (51032404M).	1	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	3	346	2011	Grille horaire n°6 Services.	1479			03	06/07/2021
1	40032402	400	324	T		BAC PRO	SECRETARIAT	SECRETARIAT (BAC PRO)	01/09/1996	31/08/2014	40032401			40030001		1998	2014	31/07/1996	27/12/2011	09/02/1998	05/09/2001	20/07/2011	05/10/2011					REMPLACE LE BPRO BUREAUTIQUE OPTION A GESTION ADMINISTRATIVE & SECRETARIAT (40032401T).	1	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	6	346		Ancienne Grille horaire n°3 Services. Nouvelle Grille horaire n°2 (arrêté du 10/02/2009).	1851			04	06/07/2021
1	32032405	320	324	T	323007	BTS	ASSISTANT DE DIRECTION	ASSISTANT DE DIRECTION (BTS)	10/06/1994	31/08/2009				32032408		1996	2009	10/06/1994	15/01/2008	03/09/1997	01/03/2000	22/07/2008	25/02/2010					REMPLACE LE BTS 32032402T. DECOUPAGE EN UNITES PAR ARRÊTE DU 03/09/1997 A PARTIR SES. 1998 (pas de changement de code). REMPLACE, AVEC 32032406T, PAR LE BTS ASSISTANT DE MANAGER (32032408T).	1	DGESIP A2	10/12/2020	BCNVICTOR	02	0	3	345			1932			05	06/07/2021
1	50032499	500	324	M		CAP	SECRETARIAT, BUREAUTIQUE	SECRETARIAT, BUREAUTIQUE	01/09/2004	31/08/2011																		Support créé par groupe de spécialités pour Mef académiques CAP 3 ans.	S	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	3	346			2679			03	06/07/2021
1	32032404	320	324	T	323006	BTS	BUREAUTIQ.SECR_C: SEC.COMMERC.BIL	BUREAUTIQUE ET SECRETARIAT OPTION C : SECRETARIAT COMMERCIAL BILINGUE (BTS)	17/07/1986	31/08/1996				32032406		1988	1995	17/07/1986	10/06/1994	11/06/1987	10/03/1988							REMPLACE, AVEC L'OPTION B : SECRETARIAT TRILINGUE (32032403T), PAR LE BTS ASSISTANT SECRETAIRE TRILINGUE (32032406T).	1	DGESIP A2	10/12/2020	BCNVICTOR	02	0	2	346		3 OPTIONS : A- SECRETARIAT DE DIRECTION (32032402T), B- SECRETARIAT TRILINGUE (32032403T), C- SECRETARIAT COMMERCIAL BILINGUE (32032404T).	1019			05	06/07/2021
1	40032401	400	324	T	403001	BAC PRO	BUREAUTIQ_A: GESTION ADMINISTRAT.	BUREAUTIQUE OPTION A : GESTION ADMINISTRATIVE ET SECRETARIAT (BAC PRO)	16/06/1987	31/08/1997				40032402		1988	1997	16/06/1987	31/07/1996	17/08/1987	15/04/1988	03/09/1990	29/07/1992					REMPLACE PAR LE BPRO SECRETARIAT (40032402T).	1	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	6	346		2 OPTIONS : A- GESTION ADMINISTRATIVE & SECRETARIAT (40032401T), B- COMPTABILITE & GESTION ADMINISTRATIVE (40031401T).	2847			04	06/07/2021
1	55032499	550	324	M		SES 3 A 6	SECRETARIAT, BUREAUTIQUE	SECRETARIAT, BUREAUTIQUE	01/09/1996	31/08/2002																			S	DGESCO A1-2	10/12/2020	BCNVICTOR	02	0	4	999			1575			03	06/07/2021
1	51332401	513	324	T	510185	BEPA	SERV SECRETARIAT ACCUEIL	SERVICES SPE SECRETARIAT ACCUEIL (BEPA)	15/02/1996	31/08/2012						1994												NSF95 : 510 324 01 T. Code E51 : BEP-0195. Code Agri : 634250. Apprentissage. Renove.	2	SPN AGRI	10/12/2020	BCNVICTOR	02	0	2	346			1780	2011-05-26 17:28:40		03	06/07/2021
1	42332401	423	324	M		BTA	COM-SERV SERVICES ADMINISTRATIFS	COMMERCIALISATION ET SERVICES SPE SERVICES ADMINISTRATIFS (BTA)	15/02/1996	31/08/2005						1987												Code E51 : BT-0162. Code Agri : A31150.	2	SPN AGRI	10/12/2020	BCNVICTOR	02	0	2	344			2757	2010-06-29 15:38:17		04	06/07/2021
1	50032403	500	324	T	503002	CAP	EMPLOYE SERV.ADMIN.& COMMERCIAUX	EMPLOYE DES SERVICES ADMINISTRATIFS ET COMMERCIAUX (CAP)	09/10/1986	31/08/1996	50031401	50031402	50032401		O	1988	1995	09/10/1986	16/07/1993	11/01/1988	09/08/1989	22/11/1989	16/07/1993					REMPLACE LES CAP EMPLOYE DE BUREAU (50031401T), EMPLOYE DE COMPTABILITE (50031402T), STENODACTYLOGRAPHE (50032401T). ABROGE NON REMPLACE.	1	DGESCO A2-3	10/12/2020	BCNVICTOR	02	0	6	346	1996		268			03	06/07/2021

26 LIGNES TROUVÉES

/ 2 pages

Nombre de lignes par page :

Voir la requête générée ↓

SELECT N_FORMATION_DIPLOME.STATUT_ID AS A0_STATUT_ID, N_FORMATION_DIPLOME.FORMATION_DIPLOME AS A0_FORMATION_DIPLOME, N_FORMATION_DIPLOME.NIVEAU_FORMATION_DIPLOME AS A0_NIVEAU_FORMATION_DIPLOME, N_FORMATION_DIPLOME.GROUPE_SPECIALITE AS A0_GROUPE_SPECIALITE, N_FORMATION_DIPLOME.LETTRE_SPECIALITE AS A0_LETTRE_SPECIALITE, N_FORMATION_DIPLOME.ANCIEN_RECME AS A0_ANCIEN_RECME, N_FORMATION_DIPLOME.LIBELLE_COURT AS A0_LIBELLE_COURT, N_FORMATION_DIPLOME.LIBELLE_STAT_33 AS A0_LIBELLE_STAT_33, N_FORMATION_DIPLOME.LIBELLE_LONG_200 AS A0_LIBELLE_LONG_200, N_FORMATION_DIPLOME.DATE_OUVERTURE AS A0_DATE_OUVERTURE, N_FORMATION_DIPLOME.DATE_FERMETURE AS A0_DATE_FERMETURE, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_1 AS A0_ANCIEN_DIPLOME_1, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_2 AS A0_ANCIEN_DIPLOME_2, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_3 AS A0_ANCIEN_DIPLOME_3, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_4 AS A0_ANCIEN_DIPLOME_4, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_5 AS A0_ANCIEN_DIPLOME_5, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_6 AS A0_ANCIEN_DIPLOME_6, N_FORMATION_DIPLOME.ANCIEN_DIPLOME_7 AS A0_ANCIEN_DIPLOME_7, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_1 AS A0_NOUVEAU_DIPLOME_1, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_2 AS A0_NOUVEAU_DIPLOME_2, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_3 AS A0_NOUVEAU_DIPLOME_3, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_4 AS A0_NOUVEAU_DIPLOME_4, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_5 AS A0_NOUVEAU_DIPLOME_5, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_6 AS A0_NOUVEAU_DIPLOME_6, N_FORMATION_DIPLOME.NOUVEAU_DIPLOME_7 AS A0_NOUVEAU_DIPLOME_7, N_FORMATION_DIPLOME.UNITE_CAPITALISABLE AS A0_UNITE_CAPITALISABLE, N_FORMATION_DIPLOME.DATE_PREMIERE_SESSION AS A0_DATE_PREMIERE_SESSION, N_FORMATION_DIPLOME.DATE_DERNIERE_SESSION AS A0_DATE_DERNIERE_SESSION, N_FORMATION_DIPLOME.DATE_ARRETE_CREATION AS A0_DATE_ARRETE_CREATION, N_FORMATION_DIPLOME.DATE_ARRETE_ABROGATION AS A0_DATE_ARRETE_ABROGATION, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_1 AS A0_DATE_ARRETE_MODIFICATION_1, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_2 AS A0_DATE_ARRETE_MODIFICATION_2, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_3 AS A0_DATE_ARRETE_MODIFICATION_3, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_4 AS A0_DATE_ARRETE_MODIFICATION_4, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_5 AS A0_DATE_ARRETE_MODIFICATION_5, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_6 AS A0_DATE_ARRETE_MODIFICATION_6, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_7 AS A0_DATE_ARRETE_MODIFICATION_7, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_8 AS A0_DATE_ARRETE_MODIFICATION_8, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_9 AS A0_DATE_ARRETE_MODIFICATION_9, N_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_10 AS A0_DATE_ARRETE_MODIFICATION_10, N_FORMATION_DIPLOME.COMMENTAIRE AS A0_COMMENTAIRE, N_FORMATION_DIPLOME.NATURE_FORMATION_DIPLOME AS A0_NATURE_FORMATION_DIPLOME, N_FORMATION_DIPLOME.GESTIONNAIRE_FORMATION_DIPLOME AS A0_GESTIONNAIRE_FORMATION_DIPL, N_FORMATION_DIPLOME.DATE_INTERVENTION AS A0_DATE_INTERVENTION, N_FORMATION_DIPLOME.NUMERO_COMPTE AS A0_NUMERO_COMPTE, N_FORMATION_DIPLOME.GESTION_DIFFUSION AS A0_GESTION_DIFFUSION, N_FORMATION_DIPLOME.NB_MEF_OUVERT AS A0_NB_MEF_OUVERT, N_FORMATION_DIPLOME.NB_MEF_FERME AS A0_NB_MEF_FERME, N_FORMATION_DIPLOME.ID_DOCUMENT AS A0_ID_DOCUMENT, N_FORMATION_DIPLOME.CITE_DOMAINE_FORMATION AS A0_CITE_DOMAINE_FORMATION, N_FORMATION_DIPLOME.DATE_SESSION_RATTRAPAGE AS A0_DATE_SESSION_RATTRAPAGE, N_FORMATION_DIPLOME.OBSERVATION AS A0_OBSERVATION, N_FORMATION_DIPLOME.ID AS A0_ID, N_FORMATION_DIPLOME.CREATED_AT AS A0_CREATED_AT, N_FORMATION_DIPLOME.UPDATED_AT AS A0_UPDATED_AT, N_FORMATION_DIPLOME.N_COMMENTAIRE AS A0_N_COMMENTAIRE, N_FORMATION_DIPLOME.CITE_DOMAINE_DETAILLE AS A0_CITE_DOMAINE_DETAILLE, N_FORMATION_DIPLOME.NIVEAU_QUALIFICATION_RNCP AS A0_NIVEAU_QUALIFICATION_RNCP, N_FORMATION_DIPLOME.DATE_STATUT AS A0_DATE_STATUT
FROM N_FORMATION_DIPLOME
WHERE N_FORMATION_DIPLOME.GROUPE_SPECIALITE = '324'

Exporter les données	: Avec clés étrangères