1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169
| --------------------------------------------------------
-- Fichier créé - mardi-février-07-2017
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table TYPE_POPULATION
--------------------------------------------------------
CREATE TABLE "GRHUM"."TYPE_POPULATION"
( "C_TYPE_POPULATION" VARCHAR2(2 BYTE),
"LC_TYPE_POPULATION" VARCHAR2(20 BYTE),
"LL_TYPE_POPULATION" VARCHAR2(40 BYTE),
"REF_REGLEMENTAIRE" VARCHAR2(40 BYTE),
"TEM_FONCTIONNAIRE" VARCHAR2(1 BYTE),
"TEM_ATOS" VARCHAR2(1 BYTE),
"TEM_ITARF" VARCHAR2(1 BYTE),
"TEM_ENS_SUP" VARCHAR2(1 BYTE),
"TEM_ENSEIGNANT" VARCHAR2(1 BYTE),
"TEM_2DEGRE" VARCHAR2(1 BYTE),
"TEM_HOSPITALIER" VARCHAR2(1 BYTE),
"TEM_BIBLIO" VARCHAR2(1 BYTE),
"TEM_CARRIERE" VARCHAR2(1 BYTE),
"D_CREATION" DATE,
"D_MODIFICATION" DATE,
"TEM_1DEGRE" VARCHAR2(1 BYTE),
"TEM_VISIBLE" VARCHAR2(1 BYTE) DEFAULT 'O',
"D_OUVERTURE" DATE,
"D_FERMETURE" DATE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATA_GRHUM" ;
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."C_TYPE_POPULATION" IS 'Code du type de population.$code type population';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."LC_TYPE_POPULATION" IS 'Libelle court d"un type de population.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."LL_TYPE_POPULATION" IS 'Libelle long du type de population.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."REF_REGLEMENTAIRE" IS 'Reference du reglementaire sur lequel s"appuie le statut associe au type de population.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_FONCTIONNAIRE" IS 'Temoin d"appartenance a la fonction publique.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_ATOS" IS 'Temoin d"appartenance a la population des ATOS.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_ITARF" IS 'Temoin d"appartenance a la population des ITARF.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_ENS_SUP" IS 'Temoin d"appartenance a la population des enseignants du superieur.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_ENSEIGNANT" IS 'Temoin d"appartenance a la population des enseignants.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_2DEGRE" IS 'Temoin permettant d"indiquer si la saisie d"une discipline d"enseignement du second degre est necessaire ou pas.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_HOSPITALIER" IS 'Temoin permettant de distinguer les categories de population rattachees au domaine hospitalier.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_BIBLIO" IS 'Temoin permettant de distinguer les categories de population rattachees aux bibliotheques';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_CARRIERE" IS 'Temoin permettant de savoir si une carriere est possible pour ce type de population.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."D_CREATION" IS 'Date de creation de l"enregistrement.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."D_MODIFICATION" IS 'Date de la derniere modification de l"enregistrement.';
COMMENT ON COLUMN "GRHUM"."TYPE_POPULATION"."TEM_1DEGRE" IS 'Temoin permettant d''indiquer si la saisie d''une discipline d''enseignement du premier degre est necessaire ou pas.';
COMMENT ON TABLE "GRHUM"."TYPE_POPULATION" IS 'Regroupement de corps se rapportant a un meme statut (ou a un ensemble coherent de statuts).';
REM INSERTING into GRHUM.TYPE_POPULATION
SET DEFINE OFF;
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('DF','MAAF -Ens 2nd deg.','MAAF - Enseignants 2nd degré',null,'O','N','N','N','O','O','N','N','O',to_date('2015-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2015-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('MF','MAAF Adm','MAAF - Personnel administratif',null,'O','O','O','N','N','N','N','N','O',to_date('2015-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2015-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('SF','MAAF - Ens.','MAAF - Enseignants',null,'O','N','N','O','O','N','N','N','O',to_date('2015-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2015-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('AM','Affectation directe','Affectation dir. depuis autre ministère','Loi 2009-972 du 3 août 2009','O','N','N','N','N','N','N','O','O',to_date('2011-11-16 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2011-11-16 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2014-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('01','Admin. Contractuels','Administratifs contractuels',null,'N','O','N','N','N','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('02','Admin. Titulaires','Administratifs titulaires',null,'O','O','N','N','N','N','N','N','O',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('03','Assistant Clinique','Assistants de clinique',null,'N','N','N','N','N','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('04','Chargés de consult.','Chargés de consultations',null,'N','N','N','N','N','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('05','Enseign. Chercheurs','Enseignants Chercheurs',null,'O','N','N','O','O','N','N','N','O',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('06','FR Contractuels','Formation recherche contractuels',null,'N','N','N','N','N','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('07','FR Titulaires','Formation recherche titulaires',null,'O','N','O','N','N','N','N','N','O',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('08','IPAC','IPAC',null,'O','N','N','O','O','N','N','N','O',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('09','Moniteurs','Moniteurs',null,'N','N','N','O','O','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('10','Pers. Direction','Personnel de Direction',null,'O','O','N','N','N','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('11','Résidents','Résidents',null,'O','N','N','N','N','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('12','Vacataires Enseign.','Vacataires d enseignement',null,'N','N','N','O','O','N','N','N','N',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('13','Insp.Santé Pub. Vét.','Inspecteur santé publique vétérinaire',null,'O','N','O','N','N','N','N','N','O',to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,'O',null,null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('AA','ASU','Pers. de l''admin. scolaire et univ.',null,'O','O','N','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2009-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('AC','ATOS','Pers. tech., ouvrier et de service',null,'O','O','N','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('AE','AENESR','Pers admin de l''ens sup et recherche',null,'O','O','N','N','N','N','N','N','O',to_date('2014-06-16 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2014-06-16 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('BA','Bibliothèque - Musée','Pers. des bibliothèques et des musées',null,'O','N','N','N','N','N','N','O','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('CA','Agent cont. admin.','Agent contract. de l''adm. scol. et univ.',null,'N','N','O','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2010-03-22 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','N',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('CC','Contract. type CNRS','Contractuel type CNRS',null,'N','N','O','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','N',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('CN','CNRS','Personnel CNRS',null,'O','N','N','N','N','N','N','N','N',to_date('2015-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2015-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('DA','Ens. 2nd degré','Enseignant du 2nd degré',null,'O','N','N','N','O','O','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('DC','Ens. 1er degré','Enseignant du 1er degré',null,'O','N','N','N','O','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'O','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('DI','Pers. Direction','Personnel de Direction',null,'O','N','N','N','N','N','N','N','O',to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('EC','Ens. Contract. Sup.','Enseignants contractuels du supérieur',null,'O','N','N','O','O','N','N','N','O',to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','N',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2013-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('ES','Ens. grands étab.','Enseignants des grands établissements',null,'O','N','N','O','O','N','N','N','O',to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('GA','Pers. grands établ.','Pers. des grands établissements',null,'O','N','N','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('GE','Générique ENS','Générique enseignant',null,'N','N','N','N','O','N','N','N','N',to_date('2015-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2015-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','N',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('GN','Générique NON ENS','Générique non enseignant',null,'N','N','N','N','N','N','N','N','N',to_date('2015-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2015-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','N',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('IA','ITRF','Pers. Ingenieur et Technique de RF',null,'O','N','O','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2012-06-14 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('IP','Pers. Inspection','Personnel d''Inspection',null,'O','N','N','N','N','N','N','N','O',to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('MA','Médicaux sociaux','Pers. médicaux et sociaux',null,'O','O','N','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('MG','EC univ méd générale','Enseignant cherch univ médecine générale','D. 2008-744','O','N','N','O','O','N','O','N','O',to_date('2011-05-05 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2011-05-05 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('MO','Moniteurs','Moniteurs',null,'O','N','N','N','O','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('N','Normalien','Elèves normaliens',null,'O','N','N','N','N','N','N','N','O',to_date('2007-11-14 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2007-11-14 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('OA','Informat. - Orient.','Pers. d''information et d''orientation',null,'O','N','N','N','N','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('PA','PAST','PAST',null,'O','N','N','N','O','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','N',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2013-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('SA','Ens. Chercheurs','Enseignants Chercheurs',null,'O','N','N','O','O','N','N','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('SB','Ens. Hos. Univ.','Enseignants hospitalo-univers.',null,'O','N','N','O','O','N','O','N','O',to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2001-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('SD','Ens. Hos-Univ. CSERD','Enseignants hospitalo-univers. des CSERD',null,'O','N','N','O','O','N','O','N','O',to_date('2010-04-15 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2010-04-15 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
Insert into GRHUM.TYPE_POPULATION (C_TYPE_POPULATION,LC_TYPE_POPULATION,LL_TYPE_POPULATION,REF_REGLEMENTAIRE,TEM_FONCTIONNAIRE,TEM_ATOS,TEM_ITARF,TEM_ENS_SUP,TEM_ENSEIGNANT,TEM_2DEGRE,TEM_HOSPITALIER,TEM_BIBLIO,TEM_CARRIERE,D_CREATION,D_MODIFICATION,TEM_1DEGRE,TEM_VISIBLE,D_OUVERTURE,D_FERMETURE) values ('SP','Ens.Hos.Univ.Pharma','Enseignant hosp-U disc. pharmaceutiques','D. 2006-593','O','N','N','O','O','N','O','N','O',to_date('2011-05-05 00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2011-05-05 00:00:00','YYYY-MM-DD HH24:MI:SS'),'N','O',to_date('2000-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null);
--------------------------------------------------------
-- DDL for Index PK_TYPE_POPULATION
--------------------------------------------------------
CREATE UNIQUE INDEX "GRHUM"."PK_TYPE_POPULATION" ON "GRHUM"."TYPE_POPULATION" ("C_TYPE_POPULATION")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "INDX_GRHUM" ;
--------------------------------------------------------
-- Constraints for Table TYPE_POPULATION
--------------------------------------------------------
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_2DEGRE" CHECK ( (tem_2degre in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_ATOS" CHECK ( (tem_atos in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_BIBLIO" CHECK ( (tem_biblio in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_ENS_SUP" CHECK ( (tem_ens_sup in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_FONCTIONNAIRE" CHECK ( (tem_fonctionnaire in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_HOSPITALIER" CHECK ( (tem_hospitalier in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "CKD_TEM_ITARF" CHECK ( (tem_itarf in ('O','N')) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CONSTRAINT "PK_TYPE_POPULATION" PRIMARY KEY ("C_TYPE_POPULATION")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "INDX_GRHUM" ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" MODIFY ("TEM_VISIBLE" NOT NULL ENABLE);
ALTER TABLE "GRHUM"."TYPE_POPULATION" MODIFY ("C_TYPE_POPULATION" NOT NULL ENABLE);
ALTER TABLE "GRHUM"."TYPE_POPULATION" MODIFY ("D_CREATION" NOT NULL ENABLE);
ALTER TABLE "GRHUM"."TYPE_POPULATION" MODIFY ("D_MODIFICATION" NOT NULL ENABLE);
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_fonctionnaire IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_atos IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_itarf IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_ens_sup IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_enseignant IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_2degre IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_hospitalier IN ( 'O' , 'N' ) ) ENABLE;
ALTER TABLE "GRHUM"."TYPE_POPULATION" ADD CHECK ( tem_biblio IN ( 'O' , 'N' ) ) ENABLE; |
Partager