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
|
CREATE TABLE FACT_AO
(
ID_AO NUMBER ,
REFERENCE_AO VARCHAR2(50) ,
RANK_AO NUMBER ,
ID_ETAT NUMBER,
ID_CALENDAR_EMIS NUMBER ,
ID_CALENDAR_CLOT NUMBER ,
ID_RESPONSABLE NUMBER,
ID_RESSOURCE NUMBER,
TYPE_RESSOURCE NUMBER,
FLG_SALARIE NUMBER(1) DEFAULT 0,
FLG_CANDIDAT NUMBER(1) DEFAULT 0,
ID_SOCIETE NUMBER,
ID_STATUT NUMBER,
ID_COMP_FONC NUMBER,
ID_COMP_TECH NUMBER,
ID_FAM_MOA NUMBER,
ID_SFAM_MOA NUMBER,
ID_FAM_MOE NUMBER,
ID_SFAM_MOE NUMBER,
ID_ETUDE NUMBER,
ID_EXPERIENCE NUMBER,
ID_CLIENT NUMBER,
ID_LANGUE NUMBER,
DISTINCT_AO NUMBER(1)
);
Insert into FACT_AO (ID_AO,REFERENCE_AO,RANK_AO,ID_ETAT,ID_CALENDAR_EMIS,ID_CALENDAR_CLOT,ID_RESPONSABLE,ID_RESSOURCE,TYPE_RESSOURCE,FLG_SALARIE,FLG_CANDIDAT,ID_SOCIETE,ID_STATUT,ID_COMP_FONC,ID_COMP_TECH,ID_FAM_MOA,ID_SFAM_MOA,ID_FAM_MOE,ID_SFAM_MOE,ID_ETUDE,ID_EXPERIENCE,ID_CLIENT,ID_LANGUE,DISTINCT_AO) values ('121','2010_MMA_1','32','2','3820','3825','1','0','0','0','0','0','99','3','2','0','0','0','0','5','7','116','0',null);
Insert into FACT_AO (ID_AO,REFERENCE_AO,RANK_AO,ID_ETAT,ID_CALENDAR_EMIS,ID_CALENDAR_CLOT,ID_RESPONSABLE,ID_RESSOURCE,TYPE_RESSOURCE,FLG_SALARIE,FLG_CANDIDAT,ID_SOCIETE,ID_STATUT,ID_COMP_FONC,ID_COMP_TECH,ID_FAM_MOA,ID_SFAM_MOA,ID_FAM_MOE,ID_SFAM_MOE,ID_ETUDE,ID_EXPERIENCE,ID_CLIENT,ID_LANGUE,DISTINCT_AO) values ('121','2010_MMA_1','32','2','3820','3825','1','0','0','0','0','0','99','3','5','0','0','0','0','5','7','116','0',null);
Insert into FACT_AO (ID_AO,REFERENCE_AO,RANK_AO,ID_ETAT,ID_CALENDAR_EMIS,ID_CALENDAR_CLOT,ID_RESPONSABLE,ID_RESSOURCE,TYPE_RESSOURCE,FLG_SALARIE,FLG_CANDIDAT,ID_SOCIETE,ID_STATUT,ID_COMP_FONC,ID_COMP_TECH,ID_FAM_MOA,ID_SFAM_MOA,ID_FAM_MOE,ID_SFAM_MOE,ID_ETUDE,ID_EXPERIENCE,ID_CLIENT,ID_LANGUE,DISTINCT_AO) values ('124','2010_CTO_25','35','2','3872','4008','62','0','0','0','0','0','99','4','0','0','0','0','0','4','10','104','0',null);
Insert into FACT_AO (ID_AO,REFERENCE_AO,RANK_AO,ID_ETAT,ID_CALENDAR_EMIS,ID_CALENDAR_CLOT,ID_RESPONSABLE,ID_RESSOURCE,TYPE_RESSOURCE,FLG_SALARIE,FLG_CANDIDAT,ID_SOCIETE,ID_STATUT,ID_COMP_FONC,ID_COMP_TECH,ID_FAM_MOA,ID_SFAM_MOA,ID_FAM_MOE,ID_SFAM_MOE,ID_ETUDE,ID_EXPERIENCE,ID_CLIENT,ID_LANGUE,DISTINCT_AO) values ('124','2010_CTO_25','35','2','3872','4008','62','0','0','0','0','0','99','2','0','0','0','0','0','4','10','104','0',null);
Insert into FACT_AO (ID_AO,REFERENCE_AO,RANK_AO,ID_ETAT,ID_CALENDAR_EMIS,ID_CALENDAR_CLOT,ID_RESPONSABLE,ID_RESSOURCE,TYPE_RESSOURCE,FLG_SALARIE,FLG_CANDIDAT,ID_SOCIETE,ID_STATUT,ID_COMP_FONC,ID_COMP_TECH,ID_FAM_MOA,ID_SFAM_MOA,ID_FAM_MOE,ID_SFAM_MOE,ID_ETUDE,ID_EXPERIENCE,ID_CLIENT,ID_LANGUE,DISTINCT_AO) values ('249','2011_PLA_6','99','2','4057','4158','40','0','0','0','0','0','99','0','0','42','0','0','0','5','7','281','0',null);
Insert into FACT_AO (ID_AO,REFERENCE_AO,RANK_AO,ID_ETAT,ID_CALENDAR_EMIS,ID_CALENDAR_CLOT,ID_RESPONSABLE,ID_RESSOURCE,TYPE_RESSOURCE,FLG_SALARIE,FLG_CANDIDAT,ID_SOCIETE,ID_STATUT,ID_COMP_FONC,ID_COMP_TECH,ID_FAM_MOA,ID_SFAM_MOA,ID_FAM_MOE,ID_SFAM_MOE,ID_ETUDE,ID_EXPERIENCE,ID_CLIENT,ID_LANGUE,DISTINCT_AO) values ('249','2011_PLA_6','99','2','4057','4158','40','0','0','0','0','0','99','0','0','41','0','0','0','5','7','281','0',null); |
Partager