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

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

FORMATION DIPLOME	NIVEAU FORMATION DIPLOME	GROUPE SPECIALITE	LETTRE SPECIALITE	ANCIEN RECME	LIBELLE COURT	LIBELLE STAT 33	LIBELLE LONG 200	DATE OUVERTURE	DATE FERMETURE	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	CITE DOMAINE FORMATION	ID	UPDATED AT	NIVEAU QUALIFICATION RNCP

26X32401	26X	324	T		TH2-X	STENOTYPISTE DE CONFERENCES	STENOTYPISTE DE CONFERENCES (EDTA SORNAS)	01/09/2020	31/08/2028				31/05/2028									rncp 39095	2	DEPPA1	24/07/2024	BCNSPN4	51	345	6034	2024-07-23 00:00:00	06
26X32402	26X	324	P		TH2-X	ATTACHE JURIDIQUE	ATTACHE JURIDIQUE (ADDSA)	01/09/2021	31/08/2026				27/03/2026									rncp 37417	2	DEPPA1	20/07/2023	BCNSPN4	51	345	6035	2023-07-19 00:00:00	06
32032401	320	324	T	323003	BTS	BUREAUTIQUE ET SECRETARIAT	BUREAUTIQUE ET SECRETARIAT (BTS)	01/01/1992	02/09/1992													CREE PAR ERREUR. VOIR 32032402T, 32032403T, 32032404T.	Z	DGESIP A2	10/12/2020	BCNVICTOR	02	999	6504		05
32032402	320	324	T	323004	BTS	BUREAUTIQ.SECRET_A: SECRET.DIREC.	BUREAUTIQUE ET SECRETARIAT OPTION A : SECRETARIAT DE DIRECTION (BTS)	17/07/1986	31/08/1996	1988	1995	17/07/1986	10/06/1994	11/06/1987	10/03/1988							REMPLACE PAR LE BTS ASSISTANT DE DIRECTION (32032405T).	1	DGESIP A2	10/12/2020	BCNVICTOR	02	346	6505		05
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	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	346	6506		05
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	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	346	6507		05
32032405	320	324	T	323007	BTS	ASSISTANT DE DIRECTION	ASSISTANT DE DIRECTION (BTS)	10/06/1994	31/08/2009	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	345	6508		05
32032406	320	324	T	323008	BTS	ASSISTANT SECRETAIRE TRILINGUE	ASSISTANT SECRETAIRE TRILINGUE (BTS)	10/06/1994	31/08/2009	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	346	6509		05
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	999	6510		05
32032408	320	324	T		BTS	ASSISTANT DE MANAGER	ASSISTANT DE MANAGER (BTS)	01/09/2008	31/08/2019	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	345	6511		05
32032409	320	324	T		BTS	SUPPORT A L'ACTION MANAGERIALE	SUPPORT A L'ACTION MANAGERIALE (BTS)	01/09/2018		2020		16/02/2018											1	DGESIP A2	10/12/2020	BCNVICTOR	02	345	6512		05
35532401	355	324	T		DEUST	BUREAUTIQUE COMMUNICATION XMEDIA	BUREAUTIQUE ET COMMUNICATION MULTIMEDIA (DEUST UNIV DU LITTORAL)	01/09/2014	31/08/2025													rncp 3973	1	DEPPA1	21/01/2021	BCNSPN4	51	346	6884	2021-01-21 00:00:00	05
35532402	355	324	M		DEUST	BUREAUTIQUE ET MULTIMEDIA	BUREAUTIQUE ET MULTIMEDIA (DEUST)	01/09/2021														rncp 36837	1	DEPPA1	25/01/2023	BCNSPN4	51	346	6885	2023-01-24 00:00:00	05
36C32401	36C	324	P		TH3-X	ASSISTANT JURIDIQUE	ASSISTANT JURIDIQUE (CCI ROUEN METROPOLE)	01/09/2019	31/08/2026				14/12/2025									rncp 37159	2	DEPPA1	20/01/2023	BCNSPN4	51	345	7098	2023-01-19 00:00:00	05
36C3240A	36C	324	P		TH3-C	ATTACHE DE DIRECTION	ATTACHE DE DIRECTION (CCIP)	01/09/1998	31/08/2012			21/12/2005	31/01/2011									rncp 4306	2	SPN DEP B4	10/12/2020	BCNSPN4	51	345	7099	2011-07-25 12:16:25	05
36C3240B	36C	324	P		TH3-C	ASSISTANT DE DIRECTION	ASSISTANT DE GESTION ET D'ADMINISTRATION D'ENTREPRISE (CCI FRANCE)	01/09/2009	31/08/2027				25/04/2027									rncp 36390	2	DEPPA1	25/05/2022	BCNSPN4	51	345	7100	2022-05-24 00:00:00	05
36T32401	36T	324	P		TH3-T	ASSISTANTE DE DIRECTION	ASSISTANT DE DIRECTION (TP)	01/09/2007	31/08/2029				29/07/2029									rncp 38667	2	DEPPA1	24/07/2024	BCNSPN4	51	346	7236	2024-07-24 00:00:00	05
36T32402	36T	324	T		TH3-T	ASSISTANT COMMERCIAL	ASSISTANT COMMERCIAL (TP)	01/09/2012	31/08/2026				29/10/2025									rncp 35031	2	DEPPA1	23/03/2021	BCNSPN4	51	340	7237	2021-03-23 00:00:00	05
36T32403	36T	324	P		TH3-T	ASSISTANT IMMOBILIER	ASSISTANT IMMMOBILIER (TP)	01/09/2019	31/08/2025				07/01/2025									rncp 34441 remplace le 46T32404	2	DEPPA1	28/07/2021	BCNSPN4	51	340	7238	2021-07-19 00:00:00	05
36X32401	36X	324	T		TH3-X	ASSIST RESP UNITE OPERATIONL	ASSISTANT(E) DE RESPONSABLE UNITE OPERATIONNELLE (CIEFA IGS)	01/09/2019	31/08/2022				29/05/2021									rncp 34620	2	DEPPA1	28/07/2021	BCNSPN4	51	345	7428	2021-07-21 00:00:00	05

67 LIGNES TROUVÉES

/ 4 pages

Nombre de lignes par page :

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

SELECT V_FORMATION_DIPLOME.FORMATION_DIPLOME AS A0_FORMATION_DIPLOME, V_FORMATION_DIPLOME.NIVEAU_FORMATION_DIPLOME AS A0_NIVEAU_FORMATION_DIPLOME, V_FORMATION_DIPLOME.GROUPE_SPECIALITE AS A0_GROUPE_SPECIALITE, V_FORMATION_DIPLOME.LETTRE_SPECIALITE AS A0_LETTRE_SPECIALITE, V_FORMATION_DIPLOME.ANCIEN_RECME AS A0_ANCIEN_RECME, V_FORMATION_DIPLOME.LIBELLE_COURT AS A0_LIBELLE_COURT, V_FORMATION_DIPLOME.LIBELLE_STAT_33 AS A0_LIBELLE_STAT_33, V_FORMATION_DIPLOME.LIBELLE_LONG_200 AS A0_LIBELLE_LONG_200, V_FORMATION_DIPLOME.DATE_OUVERTURE AS A0_DATE_OUVERTURE, V_FORMATION_DIPLOME.DATE_FERMETURE AS A0_DATE_FERMETURE, V_FORMATION_DIPLOME.UNITE_CAPITALISABLE AS A0_UNITE_CAPITALISABLE, V_FORMATION_DIPLOME.DATE_PREMIERE_SESSION AS A0_DATE_PREMIERE_SESSION, V_FORMATION_DIPLOME.DATE_DERNIERE_SESSION AS A0_DATE_DERNIERE_SESSION, V_FORMATION_DIPLOME.DATE_ARRETE_CREATION AS A0_DATE_ARRETE_CREATION, V_FORMATION_DIPLOME.DATE_ARRETE_ABROGATION AS A0_DATE_ARRETE_ABROGATION, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_1 AS A0_DATE_ARRETE_MODIFICATION_1, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_2 AS A0_DATE_ARRETE_MODIFICATION_2, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_3 AS A0_DATE_ARRETE_MODIFICATION_3, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_4 AS A0_DATE_ARRETE_MODIFICATION_4, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_5 AS A0_DATE_ARRETE_MODIFICATION_5, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_6 AS A0_DATE_ARRETE_MODIFICATION_6, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_7 AS A0_DATE_ARRETE_MODIFICATION_7, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_8 AS A0_DATE_ARRETE_MODIFICATION_8, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_9 AS A0_DATE_ARRETE_MODIFICATION_9, V_FORMATION_DIPLOME.DATE_ARRETE_MODIFICATION_10 AS A0_DATE_ARRETE_MODIFICATION_10, V_FORMATION_DIPLOME.COMMENTAIRE AS A0_COMMENTAIRE, V_FORMATION_DIPLOME.NATURE_FORMATION_DIPLOME AS A0_NATURE_FORMATION_DIPLOME, V_FORMATION_DIPLOME.GESTIONNAIRE_FORMATION_DIPLOME AS A0_GESTIONNAIRE_FORMATION_DIPL, V_FORMATION_DIPLOME.DATE_INTERVENTION AS A0_DATE_INTERVENTION, V_FORMATION_DIPLOME.NUMERO_COMPTE AS A0_NUMERO_COMPTE, V_FORMATION_DIPLOME.GESTION_DIFFUSION AS A0_GESTION_DIFFUSION, V_FORMATION_DIPLOME.ID_DOCUMENT AS A0_ID_DOCUMENT, V_FORMATION_DIPLOME.CITE_DOMAINE_FORMATION AS A0_CITE_DOMAINE_FORMATION, V_FORMATION_DIPLOME.ID AS A0_ID, V_FORMATION_DIPLOME.UPDATED_AT AS A0_UPDATED_AT, V_FORMATION_DIPLOME.NIVEAU_QUALIFICATION_RNCP AS A0_NIVEAU_QUALIFICATION_RNCP
FROM V_FORMATION_DIPLOME
WHERE V_FORMATION_DIPLOME.GROUPE_SPECIALITE = '324'

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