INSERT INTO `svctdavancescardiologicos` (`codava`,`nompdf`,`tippdf`,`tampdf`,`datpdf`,`despdf`,`numfil`) VALUES 
 ('0000000019','10calendario.pdf','application/pdf',7951,0x[encoded data, 21768 characters],'Calendario de Eventos 2008',10),
 ('0000000019','11indice.pdf','application/pdf',20894,0x[encoded data, 57188 characters],'Indice',11);


--
-- Definition of table `svctdedicacion`
--

CREATE TABLE `svctdedicacion` (
  `codded` varchar(3) NOT NULL,
  `nomded` varchar(50) NOT NULL,
  PRIMARY KEY  (`codded`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctdedicacion`
--

INSERT INTO `svctdedicacion` (`codded`,`nomded`) VALUES 
 ('001','Ecosonografista'),
 ('002','Cirujano de Corazon');


--
-- Definition of table `svctdirectivacapitulo`
--

CREATE TABLE `svctdirectivacapitulo` (
  `codcap` varchar(10) default NULL,
  `codaso` varchar(10) NOT NULL,
  `carasocap` varchar(30) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctdirectivacapitulo`
--

INSERT INTO `svctdirectivacapitulo` (`codcap`,`codaso`,`carasocap`) VALUES 
 ('002','0000000015','Presidente'),
 ('011','0000000008','Presidente'),
 ('012','0000000008','Administrador'),
 ('006','0000000001','Administrador'),
 ('006','0000000002','Director');


--
-- Definition of table `svctdirectivafilial`
--

CREATE TABLE `svctdirectivafilial` (
  `codfil` varchar(10) NOT NULL,
  `codaso` varchar(10) NOT NULL,
  `carasofil` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctdirectivafilial`
--

INSERT INTO `svctdirectivafilial` (`codfil`,`codaso`,`carasofil`) VALUES 
 ('001','0000000001','Vocal'),
 ('002','0000000009','Administrador');


--
-- Definition of table `svctdjuntadirectiva`
--

CREATE TABLE `svctdjuntadirectiva` (
  `codjun` varchar(3) NOT NULL,
  `codaso` varchar(10) NOT NULL,
  `carasojun` varchar(50) default NULL,
  `stajunred` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctdjuntadirectiva`
--

INSERT INTO `svctdjuntadirectiva` (`codjun`,`codaso`,`carasojun`,`stajunred`) VALUES 
 ('001','0000000047','SECRETARÍA DE PUBLICACIONES','N'),
 ('001','0000000057','VOCALES','N'),
 ('001','0000000059','COMITE CREDENCIALES','N'),
 ('001','0000000246','SECRETARÍA GENERAL','N'),
 ('001','0000000265','SECRETARÍA DE ORGANIZACIÓN','N'),
 ('001','0000000352','SECRETARÍA DE RELACIONES INTERNACIONALES','N'),
 ('001','0000000376','SECRETARÍA DE ORGANIZACIÓN','N'),
 ('001','0000000548','DELEGADO RED DE SOCIEDADES','N'),
 ('001','0000000568','PRESIDENTE ELECTO','N'),
 ('001','0000000592','TESORERO','N'),
 ('001','0000000593','PRESIDENTE','N'),
 ('001','0000000594','SECRETARÍA DE RELACIONES INTERNACIONALES','N'),
 ('001','0000000596','COMITE CREDENCIALES','N'),
 ('001','0000000599','SECRETARÍA DE RELACIONES INTERNACIONALES','N'),
 ('001','0000000611','SECRETARÍA DE RELACIONES INTERINSTITUCIONALES','N'),
 ('001','0000000613','SECRETARÍA DE EDUCACIÓN','N'),
 ('001','0000000624','SECRETARÍA DE EDUCACIÓN','N'),
 ('001','0000000632','COMITE CREDENCIALES','N'),
 ('001','0000000668','VOCALES','N'),
 ('001','0000000728','VOCALES','N'),
 ('001','0000000960','VOCALES','N'),
 ('001','0000000966','SECRETARÍA DE RELACIONES INTERNACIONALES','N'),
 ('001','0000000985','SECRETARÍA DE PUBLICACIONES','N'),
 ('001','0000000992','VOCALES','N');


--
-- Definition of table `svctegresados`
--

CREATE TABLE `svctegresados` (
  `cedegr` varchar(15) default NULL,
  `nomegr` varchar(30) default NULL,
  `apeegr` varchar(30) default NULL,
  `fecegr` date default NULL,
  `codpro` varchar(3) default NULL,
  `diregrhab` varchar(150) default NULL,
  `telegrhab` varchar(20) default NULL,
  `telcelhab` varchar(20) default NULL,
  `emaegrhab` varchar(40) default NULL,
  `codciuhab` varchar(3) default NULL,
  `codesthab` varchar(3) default NULL,
  `codpaihab` varchar(3) default NULL,
  `codins` varchar(3) default NULL,
  `diregr` varchar(150) default NULL,
  `telegr` varchar(20) default NULL,
  `faxegr` varchar(20) default NULL,
  `emaegr` varchar(40) default NULL,
  `codciutra` varchar(3) default NULL,
  `codesttra` varchar(3) default NULL,
  `codpaitra` varchar(3) default NULL,
  `codpos` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctegresados`
--

INSERT INTO `svctegresados` (`cedegr`,`nomegr`,`apeegr`,`fecegr`,`codpro`,`diregrhab`,`telegrhab`,`telcelhab`,`emaegrhab`,`codciuhab`,`codesthab`,`codpaihab`,`codins`,`diregr`,`telegr`,`faxegr`,`emaegr`,`codciutra`,`codesttra`,`codpaitra`,`codpos`) VALUES 
 ('4100628','MAGDA','MOLINA HERMOSO','1994-12-16','014','AV. UNIVERSIDAD URB. ROMULO BETANCOURTH CALLE B CASA 7-B','0249-29355','0414-5953900','MHM920@HOTMAIL.COM','045','005','001','511','FINAL AV. RICAURTE.          HOPITAL GENERAL SAN CARLOS   DR. EGOR NUCETE','0258-4330536','','','045','005','001','0000000001'),
 ('3135676','JOSE  JESUS','VELASQUEZ  FIERRO','1982-03-15','001','','0251  2511392','0414  511489','','002','011','001','001','CARRERA 17 CON CALLE 12','0251  522592','0251  2518398','','001','001','','0000000001'),
 ('3723889','ELEAZAR','GARCIA  DIAZ','1982-12-15','001','','4425336--   4422778','0416 518371','','002','011','001','001','PROLONGACION DE LA CARRERA 17 CON CALLE 12','0251    2527546','2527320','','001','001','001','0000000001'),
 ('3314722','EUSEBIO ANTONIO','ARENDS  SALDIVIA','1982-12-15','001','','0251  2530784','04140503836','','002','011','001','001','PROGONGACION  DE LA CARRERA  17  CON CALLE  12','0251-514390','0251  2528398','','001','001','001','0000000001'),
 ('3086488','RHAIZA','FERNANDEZ DE RAMIREZ','1982-12-15','001','','0251-2521602','','','002','011','001','001','PROLONGACION DE LA CARRERA 17 CON CALLE 12','0251-2520848','0251-2518398','','001','001','001','0000000001'),
 ('4069320','CARLOS','ROJAS BORGES','1983-12-15','002','','2540262','0414-5000284','','002','011','001','373','CARRERA 21 CON ESQUENA CALLE   21','7105750','','','001','001','001','0000000001'),
 ('4382075','ZULEIMA','STANLY DE LIMA','1983-12-15','002','CARRERA 17 CON CALLE 17  EDIF.  CHE-DIAZ  APAT.  2','0251   4452266','','','002','011','001','461','CARRERA 1  ENTRE 2 Y 3   BARRIO UNION','0251-2510310','','','001','001','001','0000000001'),
 ('3861648','ZENAIDA','SANCHEZ DE RAMIREZ','1983-04-30','002','','0257-2510255-2512255','','ZENAIDARAMIREZ@CANTV. NET','014','015','001','','CLINICA CARDIOLOGICA CARRERA 5 EDIF. RASAIS PLANTA BAJA','0257--2512734','0257--2511475','CORSENO@CANTV.NET','014','015','001','0000000001'),
 ('3857975','WILLIAMS','TORRES MOGOLLON','1984-03-30','003','RESIDENCIA TUMERCINO TORRE 1 APATO 9-4 FUNDALARA','0251--2535739','0416  6567412','','002','011','001','001',' PROLONGACION CARRERA 17 CON CALLE 12   HEMODINAMIA','0251 -  2527546','EL MISMO','','001','001','001','0000000001'),
 ('3940097','JUANA INEZ','GUTIERREZ DE RIVERO','1984-03-30','003','','0273- 5411027','0414  5670135','JIRIVERO351@HOTMAIL.COM','036','014','001','076','PISO  CONSULTORIO 20   CALLE GUIGUERRA C/C ARISMENDI','0273  5525152','0273--','','036','014','001','0000000001'),
 ('1383513','ONEIDA','RAMIREZ','1984-03-30','003','INIVERSIDAD AUTONOMA DE SANTO DOMINGO','001 809  4128396','001 809  6976616','ONEYDARAMIREZ1@HOTMAIL.COM','','','013','','UNIVERSIDAD AUTONOMA DE SANTO DOMINGO','809  2213018','','ONEYDARAMIREZ1@HOTMAIL.COM','','','013','0000000001'),
 ('2961835','MANUEL','ALVAREZ   CORDERO','1984-12-30','004','','0251-4450073','0416-8507950','','002','011','001','001','PROLONGACION CARRERA 17 CON CALLE 12','0251-2522592','0251-2518398','','001','001','001','0000000001'),
 ('81105220','LUIS A.','BAEZ PIMENTEL','1984-12-30','004','SANTO  DOMINGO    REPUBLICA DOMINICANA','001 809  5226486','  001 089  6346130','','','','013','','SANTO  DOMINGO     REPUBLICA  DOMINICANA    IDENTENTICA','001 809  526486','','','','','013','0000000001'),
 ('4070794','FILIPPO','PANTO LAPI','1985-12-15','005','','0251-552805','0414-9518542','','002','011','001','001','UNIDAD CLINICA DE ASCARDIO   CARRERA 17 CON CALLE 12','','','','001','001','001','0000000001'),
 ('3849268','HECTOR  JOSE','VARGAS','1985-12-15','005','IPASME  CARRERA 32  CON  AV LIBERTADOR','0251 4458775','','','002','011','001','203','AV LIBERTADOR','0251-2535836','0251 4459211','','001','001','001','0000000001'),
 ('3446502','PARMY','CHAVEZ DE MORALES','1985-12-15','005','CORO','0268  2521557','0414  6811067','','072','010','001','','SEGURO SOCIAL DE CORO','','','','072','010','001','0000000001'),
 ('4576375','RUBEN','','1986-12-15','006','AVENIDA  VARGA','','','','002','011','001','403','AVENIDA  VARGAS     TRABAJA   ENLA TARDE','0251--2520455','','','001','001','001','0000000001'),
 ('4171586','IRLANDA','','1986-12-15','006','VIA EL MANZANO','','04143501523','','002','011','001','485','AVENIDA  INTERCEMUNAL DE    CABUDARE','0251 2630022','630022','','002','001','001','0000000001'),
 ('4658554','JOSE','CRESPO FERRER','1984-12-30','004','','6622784','','','002','011','001','118','','','','','001','001','001','0000000001'),
 ('2862447','NEGLIS','BUSTILLO DOUNQUE','1987-03-30','007','AV. BOLIVAR','0243  2348124','0416 8463453','','002','011','001','487','AV.  BOLIVAR','0243 44560290','','','008','006','001','0000000001'),
 ('4326087','IVONNE','SIMONS','1987-12-31','007','','0261  2312857','','','029','002','001','260','','','','','003','002','001','0000000001'),
 ('81326669','JOAQUIN','CANABAL MENENDEZ','1987-12-31','007','','0251 2546105','04166515852','','002','011','001','437','CARRERA 17 CON CALLE 12','','','','001','001','001','0000000001'),
 ('4209133','YOLANDA','MELENDEZ','1988-12-30','008','','0276  3532784','0416 8789172','DRAYOLANDAMELENDEZ@HOTMAIL.COM','017','008','001','448','SANTA TERESA','','','','017','008','001','0000000001'),
 ('4741301','ALEXANDER','PARA FINOL','1988-12-30','008','CARACAS','','','','004','003','001','483','FUERTE TIUNA EL VALLE JEFATURA DE SERVICIOS DE CARDIOLOGIA  DR. VICENTE SALIAS SANOJA','0232 2736098','02322315373','','004','003','001','0000000001'),
 ('3903288','EMI  MECEDES','PLAZA DE PLAZA','1988-12-30','008','URB EL PEDREGAL','0251 2531609','','','002','011','001','437','CARRERA 17 CON CALLE 12','0251   2520848','0251  2518398','ASCARDIO.ORG','001','001','001','0000000001'),
 ('4074182','FRANCO BRUNO JOSE','CATALIOTTI  BONETTA ZOTTI','1989-12-30','009','','0246  4316822','0216  87008935','CATALIOTIF @CANT.NET','054','016','001','239','','0246 2314324','0246  4317141','CATALIOTIF @CANT.NET','054','016','001','0000000001'),
 ('9889636','SIMON VICENTE','DAVALOS','1989-12-31','009','ECUADOR','','','','','','005','314','ECUADOR','','','','032','','005','0000000001'),
 ('4966652','LUIS','ROCHA GALINDES','1990-12-30','010','','','','','002','011','001','437','CARRERA 17 CON CALLE 12','0251  518589','0251 2518398','','001','001','001','0000000001'),
 ('5022064','OMAR','SUAREZ COLMENAREZ','1991-12-31','011','','','','','026','017','001','263','CENTRO MEDICO ANZOATEGUI  AV.  PRINCIPAL DE LECHERIA','O281 867378','0281 862404','','026','017','01','0000000001'),
 ('4875174','SERGIO','HERNANDEZ','1991-12-31','011','','','','','002','011','001','001','SERVICIO DE HOLTER  CARRERA 17 CON CALLE 12','0251  252','','','001','001','001','0000000001'),
 ('8304691','CESAR','RAMIREZ','1991-12-31','011','PEDRO LEON TORRES','','0216  5010351','','002','011','001','118','CARRERA 22 CON CALLE 28','','','','001','001','001','0000000001'),
 ('81412320','ELENA','DE TRONCOSO','1991-12-31','011','AV. LAS AMERICAS RES. LAS AMERICAS TORRE A APTO  9-3 ALTAVISTA NORTE','0286  621385','0286  624887','','025','020','','','','','','','025','020','001','0000000001'),
 ('4384473','ADELA  MERCEDES','ARENAS','1991-12-14','011','CALLE 29 CON AV. CARTAGENA  9-19','0254    317740','0414   95400912','CARADELAARENAS@YAHOO.COM','081','009','001','','EDIFICIO J.M.S.   CALLE 7  CON AV. 9  FRENTE A LA POLICLINICA SAN FELIPE','0254     315115','','','081','009','001','0000000001'),
 ('5722477','JOSE ANTONIO','GONZALEZ CHOURIO','1992-12-31','012','','0264    3711250','0216    8965735','JOCHOURIO@HOTMAIL.COM','003','002','001','','CENTRO MEDICO ASESORES','','','JOCHOURIO@IFXA.COM.VE','003','002','001','0000000001'),
 ('5655032','FERMIN','CARRILLO   CHACON','1992-12-31','012','','0276  443613','0416 6766784','FCARRILLOC@CANTV.NET','017','008','001','448','CENTRO CLINICA SAN CRISTOBAL  AV. LAS PILAS CONSULTORIO 603 PISO 6','0276  441451','0276  443613','','017','008','001','0000000001'),
 ('170650061','MIRIAN','','1992-12-31','012','CALLE 8  CON AV. LARA  EDIF','','','','002','011','001','001','CARRERA 17 CON CALLE 12     SERVICIO  DE ECOCARDIOGRAFIA','0251   2524808','','','001','001','001','0000000001'),
 ('8068533','DOMENICA','NORCINI   CORONA','1992-12-31','012','URB. SAN FRANCISCO CALLE 2 AV. 2','0257 2519127','0414  5750200','DIMENICANORCINI@HOTMAIL.COM','014','015','001','492','CENTRO MEDICO PORTUGUESA AL LADO DE LA CONCHA  ACUSTICA','0257   2516527','0257  2514675','','014','015','001','0000000001'),
 ('12920092','JOSE','CORDERO','1993-12-31','013','','','','','040','022','001','','ANGIOCOR   CALLE  EL  COLEGIO CC MAKRO  NIVEL ESTACIONAMIENTO LOCAL 13-B','0295  6422492','','','040','022','001','0000000001'),
 ('176037','LOURDES','CARVAJAL','1989-12-31','009','','809 5494580','','','','','013','','SANTO DOMINGO','809','','','','','013','0000000001'),
 ('3911911','RAFAEL JOSE','HERNANDEZ PEREZ','1993-12-31','013','CALLE 15 ENTRE CARRERA  5 Y 6','','','','049','009','001','251','','','','','049','009','001','0000000001'),
 ('4096842','AURORA IRENE','RUIZ','1993-12-03','013','','0258 4336320','0416  7403129','','045','005','001','008','URB. LOS SAMANES  CALLE TINAQUILLO AL LADO DE FUNDA COMUN','0258  4332660','','','045','005','001','0000000001'),
 ('5252191','MARTHA  CECILIA','ISAAC    ESPINOSA','1992-12-31','012','CALLE 32 ENTREAV. BOLIVAR T AV 6  QTA. EL PRADO   LAS ACACIAS','0271 2314078','0414 7290867','MARTHAISAACE@CANTV.NET','051','008','001','260','AV 6 CON CALLE 23   INSTITUTO MEDICO VALERA','0271  2310533','','','051','008','001','0000000001'),
 ('5172078','YAKELINE','ALFONSO','1991-12-31','011','URB. LOS LI MENCITOS CASA 7 AV  VALERA ESCUQUE','0271    2950941','','','051','008','001','260','CENTRO CLINICO MARIA  EDELMESA  ARAUJO','','','','051','008','001','0000000001'),
 ('4962302','MARISOL','OJEDAS','1993-12-31','013','CALLE ALEGRIA CON CALLE MANRIQUE 10-5','','','','051','008','001','260','','','','','051','008','001','0000000001'),
 ('4863936','HECTOR','GONZALEZ','1992-12-31','012','','','04145255460','HECTORDOMINGO@CANTV.NET','002','011','001','118','','','','','001','001','001','0000000001'),
 ('4569110','MATILDE','RODRIGUEZ','1994-12-31','014','','','','','008','006','001','260','','','','','008','006','001','0000000001'),
 ('7755068','CARLOS','LEON  PIRELES','1994-12-31','014','PARQUE RES. ARCA DEL NORTE TORRE A.  PISO 3 APTO 34 AV. LIBERTADOR','0251  515317','','','002','011','001','001','CARRERA 17 CON CALLE 12','0251 2522073','0251 2518398','','001','001','001','0000000001'),
 ('4731530','ELSY','MENDOZA','1994-12-31','014','CARRERA  27 ENTRE 37 Y 38 37 -41','4412308','','','002','011','001','397','AV   VEINTE','','','','001','001','001','0000000001'),
 ('6017918','JAIME','MARIN CARRILLO','1994-12-31','014','','0272   5328786','0414   5673205','JAIMEW_MC@CANTV.NET','036','014','001','007','CALLE SANTA ROSAS  MADULA  LA CONCARDIA CENTRO CARDIOVASCULAR  BARINAS  ABACOR','0273 338697','','','036','014','001','0000000001'),
 ('2552011','DANIEL','MESSINA','1994-12-31','014','REPUBLICA DOMINICANA','809  5333774','809  6623344','','','','013','','','','','','','','013','0000000001'),
 ('7548207','EVELIO  JOSE','ARAQUE  RODRIGUEZ','1995-12-31','015','','0255  6228238','0414  5598390','EVECARDIO@CANTV.NET','018','015','001','288',' CARRETERA NACIONAAL VIA GUANARE','0255  6152991','','','018','015','001','0000000001'),
 ('8132516','CECILIA','BASTIDAS','1995-12-31','015','URB. CUATRICENTENARIA BLOQUE 5 EDIF. OL APT. 007  PLATA BAJA   AV. GUAICAIPURO','0273  24094','0416730630','CECILIABH@CANTV..NET','036','014','001','007','URB. LA CONCORDIA CALLE SANTA  ROSA AMBULATORIO LA CONCARDIA','0273  5338697','','','036','014','001','0000000001'),
 ('5435957','ALEXARIS','CASTILLO','1995-12-31','015','','0253  633149','0414  9537152','ALEXARI@CANTV.COM','083','011','001','266','','0253  632068','6355429','','083','001','001','0000000001'),
 ('13636317','SOFIA','','1995-12-31','015','AV. PRINCIPAL DE LECHERIA C-88','0281  605805','','','026','023','001','','','','','','026','023','01','0000000001'),
 ('7505328','CARLOS','SIERRA   FIGUEREDO','1995-12-31','015','AV. LAS AMERICAS  URB. BELLA VISTA EDIF. DON VICENTE APTO. PB2','0254   2343074','0414  5460103','CARLOSSIERRA@CANTV.NET','081','009','001','','CETRO ISAMAR  CALLE 16 ENTRE AV. 8 Y 9','0254 2343013','','','081','009','001','0000000001'),
 ('3765642','ROSA','VALERO','1995-12-31','015','','0269  456871-8083483','0414  6952420','ROSVALERO@HOTMAIL.COM','028','010','001','','C/ ESTEBAN SMITH MONZON NUEVO PUEBLO  CLINICA  SAN LORENZO','0269   2455281','','','028','010','001','0000000001'),
 ('4234735','CARMEN','CUBEROS','1995-12-31','015','','0257  2531197','0416  6572068','','014','015','001','161','GUANARE','','','','014','015','001','0000000001'),
 ('7476910','KADUO','ARAI  FFIGURA','1996-12-31','016','','','','','002','011','001','001','CARRERA 17 CON CALLE 12','0251 2525718','','','001','001','001','0000000001'),
 ('123','RAFAEL','GARCIA','1996-12-31','016','','','','','002','011','001','281','AV LOS LEONES CON AV MADRID CONS 6   2 PISO','0251  2531871','','','001','001','001','0000000001'),
 ('789','WILLIAN GERDARDO','ARAQUE  JUAREZ','1996-12-31','016','URB. CANTA CLARO RES. ALTO LLANO EDIF. 4 APTO 2-C','0258 4334025','0416  5480133','','045','005','001','008','URB. LOS SAMUEL I CALLE TINAQUILLO SECTOR MODULO DE FUNDASALUD','0258  4332660','0258  337376','','045','005','001','0000000001'),
 ('456','ANGEL','REA','1996-12-31','016','','0243   3961706','0414 4895392','','008','006','001','163','AV. BOLIVAR ESTE SECTOR LA  PLACERA','0243  2377332','','','008','006','001','0000000001'),
 ('741','MARCOS  RAMON','MORENO  DIAZ','1996-12-31','016','AV RICAUTEZ EDIF. VIOLANTE  APTO. 6','0258  332660','0416 4411616','','045','005','001','008','URB. SAMUEL I CALLE TINAQUILLO  AL LADO DE FUNDASALUD','0258  332462','0258 4332660','','045','005','001','0000000001'),
 ('852','ALI','FERNANDEZ','1996-12-31','016','CALLE NEGRO PRIMERO','0257  8889268','04145792030','CHABASQUEN02@CANTV.NET','091','015','001','','HOSPITAL  CHABASQUEN','','','','091','015','001','0000000001'),
 ('963','JOSE  CUPERTINO','BORGES  CAMPOS','1996-12-31','016','','0265  6510841','0414  6551752','JOSEBOR@HOTMAIL.COM','029','002','001','','HOSPITAL PRIVADO EL ROSARIO SECTOR  5 BACAS AV. K','0264  3719696','','','029','002','001','0000000001'),
 ('951','EUCLIDES','CARRILLO','1996-12-31','016','RESD. ORINOCO SUITES PISO 15 APTO.  15-F   VALLE DE CAMORUCO','0241  8255742','0416  6475224','EUCARRILLO@CANTV.NET','012','011','001','494','HOSPITAL DR. ENRIQUE TEJERA. AV. LISANDRO AALVARADO','0241  8358049','','','012','011','001','0000000001'),
 ('753','RAFAEL','FELICE','1996-12-31','016','','0241  8317826','0416 6489347','RAFELICE@TELCEL.NET.VE','012','011','001','','CLINICO LA ISABELICA  2DA AV. ZONA CENTRAL 2DO PISO CONS 210','0241  8338046','0241  331544','','012','011','001','0000000001'),
 ('943','CARLOS','MIRANDA  RAMOS','1996-12-31','016','RES. SUN AND SEA TORRE B APTO 3D PISO 3    AV  LA  PLAYA  CUMBOOTO NORTE   PTO CABELLO','0242   3640790','0416   6422313','CARLOSMIRANDA50@HOTMAIL.COM','013','011','001','','CENTRO CLINICO ESTE       POLICLINICA CENTRAL','0242  3615149','','2001CARLOS@CANTV.NET','013','011','001','0000000001'),
 ('13033024','ALEJANDRO','CABRERA','1997-12-31','017','','0251  446326','0416  6561837','','002','011','001','482','CARERA 21 ENTRE 55 Y 56 TORRE B PISO 4 APTO 4-2','0251  449618','','','001','001','001','0000000001'),
 ('7361425','SALVADOR','D\'ARMATA','1997-12-31','017','CARRERA  21','','0414  5251205','DARMATA@CANTV.NET','002','011','001','482','CARRERA 21 ENTRE 55 Y 56  TORRE  B EDIF CARALI APTO 2','0251    4419618','0251  7187203','','001','001','001','0000000001'),
 ('7874205','JUAN CARLOS','HENRRIQUE','1997-12-31','017','','0291   6512025','0416  69199696','JCHENRIQUEZ@HOTMAIL.COM','023','017','001','010','INCARDIO','0291  6414129','','INCARDIO@CATV.NET','023','017','001','0000000001'),
 ('7048359','JORGE','LEON','1997-12-31','017','','','0414 4740926','JORGELEON42@HOTMAIL.COM','021','013','001','','CENTRO MEDICO DEL SUR','','','','021','013','001','0000000001'),
 ('8315365','FRANCISCO','LOPEZ','1997-12-31','017','','028  2651718','','','026','017','001','','','','','','026','017','001','0000000001'),
 ('6438792','JOSE FELIX','RUIZ','1997-12-31','017','','0291  6514706','0416 6910605','PRECARDIO@HOTMAIL.COM','023','017','001','010','AV BICENTENARIA 30-A','0291  6431891','','','023','017','001','0000000001'),
 ('8468486','NESTOR','RAMIREZ','1997-12-31','017','','0282  2003603','','0281  676578','010','023','001','','GLOBALSANTAFE','0282  4253661','0282  4222234','NRAMIREZ@GRFDRILL.COM','010','023','01','0000000001'),
 ('11427657','ROSARIO','SAPELLI  DE CANABAL','1997-12-31','017','','0251  2546105','','','002','011','001','','','','','','001','001','001','0000000001'),
 ('7366648','ZULEIMA','TORRES','1997-12-31','017','AV LA MATA   CABUDARE','0251 2671202','0416  6520624','','005','011','001','','GRUPO MEDICO DE IMAGENES TEREPAIMA .   AV LA MATA EDIF. MARCER LOCAL 5 PLANTA BAJA   CABUDARE','0251  2628033','','','001','001','001','0000000001'),
 ('5359575','EDGAR','VILLEGAS','1997-12-31','017','URB BANCO OBRERO','','','CCRCYU@CATV.NET','045','005','001','008','','0258  337376','','','045','005','001','0000000001'),
 ('5209821','MARIA VICTORIA','ROJAS','1998-12-31','018','','','','','002','011','001','001','CARRERA 17 CON CALLE 12','','','','001','001','','0000000001'),
 ('7157491','OLGA','PINTO','1998-12-31','018','URB.  ALTO BARINAS  KLOSTER LAS PALMAS','0273  3300723',' 0273  24051','','036','014','001','','','','','','036','014','001','0000000001'),
 ('8658906','VALENTIN','GONZALEZ','1998-12-31','018','CALLE 28  C/AV.   33 EDIF. LOS LUGOS PISO  2  APTO   3','0255   211405','','','018','015','001','','','','','','018','015','001','0000000001'),
 ('170443907','IVAN','ZULETA','1998-12-31','018','CIUDAD ANDALUCIA  CALLE  GONZALO  GALLO 761','005932  24901','','','032','','005','','','','','','032','','005','0000000001'),
 ('7402843','JOSE','MARTINEZ','1998-12-31','018','','','','','002','011','001','001','CARRERA 17 CON CALLE 12','0251  2522073','','','001','001','001','0000000001'),
 ('4732017','RASALBA','CAMMARATA','1998-12-31','018','','0251  2329842','0416  6561950','RCAMMARATA@CANTV.NET','002','011','001','267','','0251  2591837','','','001','001','001','0000000001'),
 ('65466910','PEDRO','ESTANGA','1998-12-31','018','','0251  26116951','','','002','011','001','397','','','','','001','001','001','0000000001'),
 ('8907539','JOSE GREGORIO','RODRIGUEZ','1998-12-31','018','AV. PRINCIPAL  SAN  JACISTO EDIF. CUMBOLO 7D','0243  2357040','0412   7548762','COROBA@CANTV.NET','008','006','001','006','AV. SUCRE AASODIAM HOSPITAL CENTRAL DE MARACAY  URB.  LA FLORESTA','02432425861','0243  2425861','','008','006','001','0000000001'),
 ('7005054','RUBEN','GUERRA','1998-12-31','018','','0241  587913','','','012','011','001','008','','','','','045','005','001','0000000001'),
 ('8476633','JORGE','PEREZ','1998-12-31','018','CALLE STA EULALIA','0232  44231','','','048','012','001','','','','','','048','012','','0000000001'),
 ('5950712','EDSON','HERNANDEZ','1998-12-31','018','URB LA MORA AAAV.  PPAL RESI 413 APTO B12','0251  2622575','','','002','011','001','001','CARRERA 17 CON CALLE 12','','','','001','001','001','0000000001'),
 ('8935138','RITO','ABILE','1998-12-31','018','','0291  6 424211','0416 6911350','RABILE@CANTV.NET','023','017','001','010','','0291  6423001','','','023','017','001','0000000001'),
 ('7072443','CARMEN','MONTESSINO','1999-12-31','019','','0273  5410609','0416  4409075','CEMONTESINO@HOTMAIL.COM','036','014','001','','AMBULATORIO LA CONCORDIA','0273  5338697','','','036','014','001','0000000001'),
 ('9269096','NORYS','GODOY','1999-12-31','019','','02       5323237','0414   1592261','NORRYSG@HOTMAIL.COM','036','014','001','','HOSPITAL  LUIS RASETTI   AV. RONOLON C/CALLE MERIDA HOSP. PRIVADO SAN JUAN','    5323265','   5320018','','036','014','001','0000000001'),
 ('8912760','CARLOS','LOPEZ RUIZ','1999-12-31','019','','','0416  4451983','','008','006','001','120','OLICLINICA COROMOTO AV. RAMON NARVAEZ # 40  MARACAY','0243  5544723','0243  5541002','DRLOPEZRUIZ@HOTMAIL.COM','008','006','001','0000000001'),
 ('7332324','MIGUEL','CHIDIAC','1999-12-31','019','URB. VILLA ROSA III CASA 16-03','','0416 6515859','','002','011','001','123','SERVICIO DE CARDIOLOGIA','','','','001','001','001','0000000001'),
 ('7468965','LEIDA','PEREZ','1999-12-31','019','BOSTON','','','','','','004','','','','','','','','004','0000000001'),
 ('9283933','CRUZ ALBERTO','ARIAS JIMENEZ','1999-12-31','019','AV. JOSE TADEO MNAGAS RES. CANACAS PISO 2 APTO 204','0291  42001','0414 7666233','JJBA@TELCEL.NET.VE','023','017','001','010','CLINICA LA TRINIDAD','0291  424211','','','023','017','01','0000000001'),
 ('7333836','BARBARA','ARMAS RIVAS','1999-12-31','019','URB DEL ESTE AV. COROMOTO RESD. CAPRICORNIO ARTO 6B','0251  510241','0414  5128702','DRABARBARA@TELCEL.NET.VE','002','011','001','168','SISALUD CALLE12 ENTRE 21 Y 22','0251  2518159','0416 6507663','','005','001','001','0000000001'),
 ('7258897','YOLIMAR','MESA MENDEZ','1999-12-31','019','CALLE  7  LOYQUE PLAZA II PISO 12  APTO 12B  URB BASE ARAGUA','0243  330526','0414 4518778','','008','006','001','006','','0243 343302','','','008','006','001','0000000001'),
 ('8002478','EDICTA','DAVILA','1999-12-31','019','','         341227','0414  5397261','','005','011','001','168','CALLE CARABOBO','0252  214411','','','005','001','001','0000000001'),
 ('4733203','GREGORIA JOSEFINA','CASAMAYOR','1999-12-31','019','AV. ANTONIO JOSE DE SUCRE  BQ. 26 APTO. 3  / URB. PRIMAVERA PARCELA 2 CALLE 2 C2-8 CABDARE.','2325794 - 328084','0414  5181555','JOSEFINACAZAMAYOR@HOTMAIL.COM','002','011','001','203','AV LIBERTADOR /    HOSPITAL ROTAARIO GIMENEZ','663412','','','001','001','001','0000000001'),
 ('7246043','JOSE  BIAGIO','POMPINI CUGNO','1999-12-31','019','CALLE COROMOTO RES. LA CASCADA APTO 5-B URB. LA CASCADA','0243  2460519','0414  5907600','POMPINI@YAAHOO.COM','008','006','001','006','','0243 2464657','','','008','006','001','0000000001'),
 ('5784845','LUSMILA DEL CARMEN','CASTELLANO ARAUJO','2000-12-31','020','','0272  2360731','0416  8723784','LUSMILA@CANTV.NET','051','008','001','','','','','','051','008','001','0000000001'),
 ('9461918','EVA MARIA','LUCENA CORDERO','2000-12-31','020','URB SANTA ELENA AV FRANCIA CON PASEO HIPICO QTA EVA MARIA  PH 80','0251  2533847','','','002','011','001','118','','','','','001','001','001','0000000001'),
 ('7889721','MAYELA JOSEFINA','URDANETA  BARRIOS','2000-12-31','020','AAV. FRANCISCO DE LORETO RES,LORETO PISO 3 APTO. 3B','0244  4189002','0416  34475155','MURDANETA2001@YAHOO.ES','003','002','001','','CENTRO PROFESIONAL EL CARDONAL 2DO. PISO CONSULTORIO 2-8 AL LADO DE LA CLINICA ACHASQUE LA VICTORIA','','','MURDANET@TELCEL.NET.VE','008','006','001','0000000001'),
 ('8340926','ONELIA  TERESA','GREATTY   CREMONESI','2000-12-31','020','AV. PASEO CABRIALES EDIF.  JARDIN VELENCIA TORRE 2 APTO 8B','0241  8248524','0414  4706160','GREATTY@TELCEL.NET.VE','012','011','001','494','EDIF. ANEXO PLATA BAJA       CENTRO MEDICO TTORRE D','0241 8574405-8561317','0241 8561246','GREATTY@MSN.COM','012','011','001','0000000001'),
 ('8329885','JOSE GREGORIO','ARAY GARCIA','2000-12-31','020','','0281  2868081','0416  68111266','DRCHAPARRO@CANTV.NET','022','023','001','','AV. MIRANDA C.C.O. CASANOVA P.B. LOCAL  FAMISALUD','0251  2740933','0281  2663647','','022','023','001','0000000001'),
 ('8649857','RAFAEL JOSE','ROSAS AVELES','2000-11-03','020','URB NUEVA CADIZ    CALLE BARCELONA QTA LA ROSALEDA','0293  324870','0414 8403276','ROSAV@HOTMAIL.COM','015','018','001','','','','','','015','018','001','0000000001'),
 ('7021857','OSCAR JULIO','LAMAS FIGUEROA','2000-12-31','020','','0243  337332','','','008','006','001','','','','','','008','006','001','0000000001'),
 ('8335592','OSCAR ENRRIQUE','GERALDINO CARVAJAL','2000-12-31','020','','','','OSCARJERARDINO@LATINMAIL.COM','026','017','001','','AV. MIRANDA C.C.O. CASANOVA PB LOCAL 2 FAMISALUD','0281  2740933','','','026','017','01','0000000001'),
 ('9327814','SOFIA  LIBETH','ALCEGA ZUE','2001-12-31','021','SECTOR EL GIANNY RESIDENCIA VICTO HERMOSA II PISO 1 APAT. 4 II','0271 2012387','04147292864','ORTEGUA@TELCEL.NET.VE','051','008','001','','C.C. PLAZA PISO 6 CONSULTORIO  601-602','0271  2319504','','','051','008','001','0000000001'),
 ('6971210','LILIANA','DIPASQUALE TORRES','2001-12-31','021','AV. LARA EDIF. PARQUE CENTRAL TORRE B #  6-3.','','','','002','011','001','281','AV  LOS LEONES','','','','001','001','001','0000000001'),
 ('6980652','SILKA CECILIA','BECERRA ARRAEZ','2001-12-31','021','','','0414-5101068','BECERRAS@TELCEL.NET.VE','002','011','001','253','TORRE CARALI CALLE 54 CON CARR. 21 PISO 6 APTO. 6-B','0251-4424913','','','001','001','001','0000000001'),
 ('7578541','MILAGROS HAIDEE','','2001-12-31','021','','','0414  5486511','MILAGROSHCP@HOTMAIL.COM','081','009','001','','HOSPITAL  CENTRAL   DE  SAN FELIPE','','','','081','009','001','0000000001'),
 ('9948734','ALVARO ENRIQUE','GONZALEZ ROCCA','2001-12-31','021','URB VISTA HERMOSA II BOQUE 4 EDIF  4 PTO 0004','','','','011','020','001','','','','','','011','020','001','0000000001'),
 ('9391151','VICTOR JULIO','MORENO  LEAL','2001-12-31','021','','0275  8810094','0414  7572929','VICTORLEAL2000@HOTMAIL.COM','051','008','001','','CLINICA E. MEDICA  URB. SAN ISIDRO','0255  8812276','0275  8812276','','051','008','001','0000000001'),
 ('7586111','MANUEL  FELIPE','','2002-12-31','022','','0251  8831350','0416  2507110','INMANUEL_Y@HOTMAIL.COM','098','009','001','500','','','','','098','009','001','0000000001'),
 ('8870359','FRANCISCO','AMBROSINO MORABETOO','2002-12-31','022','','0285  6322814','0416  4855918','MORABITOVE@YAHOO.COM','011','020','001','','CLINICA MATERNO QUIRURGICA LA MILAGROSA PASEO HERES C/C AAV. BOLIVAR CONSL.6','6  0283  6329797','0285  6324701','','011','020','001','0000000001'),
 ('8324452','ISABEL','VELASQUEZ','2002-12-31','022','','0281  26680915','0416  7803089','DRAISAVELASQUEZ@HOTMAI.COML','026','017','001','','AV. MUNICIPAL C.C. GRAN PARADA GRUPO MEDICO SAGRAFAM  LOCAL 7B','0281  2687429','','','026','023','001','0000000001'),
 ('9567928','MARIA GABRIELA','SANCHEZ ARAUJO','2002-12-31','022','','0255 66641587','','SANCHEZMAGA@YAHOO.COM','018','015','001','','','','','','018','015','001','0000000001'),
 ('7981390','LIGIA ENVIRA','RODRIGUEZ HERRERA','2002-12-31','022','AAV LOS LEONES EDIF  MATA LINDA AAPTO 8-A PISO 8','0251 2531512','0416  7542358','','002','011','001','156','CARRERA 18 CON CALLE 12','','','','001','001','001','0000000001'),
 ('7401072','LIANKYS ESTRELLA','LOPEZ DIAZ','2002-12-31','022','','4451517','0416 7508444','','002','011','001','001','CARRERA 17 CON CALLE 12','0251  2522595','','DRLIANKYS@HOTMAI.COM','001','001','001','0000000001'),
 ('6316388','LEONANDO E','SAAVEDRA  M.','2002-12-31','022','AV. LARA  RESIDENCIA  PARQUE CENTRAL TORRE A  APTO. 13-3','','0414  5213599','LEONARDOSAAVEDRA@INTERCABLE.NET.VE','002','011','001','001','CARRERA 17 CON CALLE 12  / CENTRO MEDICO ONCOLOGIA','0251  4469833','','','001','001','001','0000000001'),
 ('023','JUAN ALBERTO','CHIRINOS VILLEGAS','2003-12-31','023','','','','','002','011','001','','','','','','001','001','001','0000000001'),
 ('0123','YRIS  MARLENE','FLORES GRATEROL','2003-12-31','023','','','','','002','011','001','001','','','','','001','001','001','0000000001'),
 ('0456','JOSE  ALFONSO','MESSINO RIVEROS','2003-12-31','023','','','','','003','002','001','','','','','','003','002','001','0000000001'),
 ('0789','GLADYS YOLEIDA','PEREZ PADILLA','2003-12-31','023','','','','','004','003','001','','','','','','004','003','001','0000000001'),
 ('0159','OSMAN','YANEZ','2003-12-31','023','RESIDENCIA SANTA CECILIA II 16 CALLE 19    EL TOCUYO','','0416  7545205','','083','011','001','151','EL TOCUYO','','','','083','001','001','0000000001'),
 ('00357','RENE','GALUE','2003-12-31','023','','','','','002','011','001','','','','','','001','001','001','0000000001'),
 ('0753','JUAN','SALAS','2003-12-31','023','','','','','023','017','001','010','','','','','023','017','001','0000000001'),
 ('4953994','CARMEN','MATUTE','2004-12-31','024','','','','','008','006','001','','','','','','008','006','001','0000000001'),
 ('10140984','IVANNE','','2004-12-31','024','CARACAS','','0414  4321836','','004','003','001','127','','012  212 9922801','','','004','003','001','0000000001'),
 ('8851836','AQUILINO','GONZALEZ','2004-12-31','024','','','','','037','020','001','','','','','','037','020','001','0000000001'),
 ('170962521','VLADIMIR','ULLAURI','2004-12-31','024','','','','','032','','005','','','','','','032','','005','0000000001'),
 ('8979331','MIGUEL','VILLALBA','2004-12-31','024','RESIDENCIA DE HEMODINAMIA','','','','002','011','001','','','','','','001','001','001','0000000001'),
 ('8895145','JORGE','ROMHAIN  WASUF','2004-12-31','024','','','0414  8936049','JORGEROMHAIN@YAHOO.COM','011','020','001','','CLINICA SAN PEDRO S.A.','','','JRW2005@HOTMAIL.COM','011','020','001','0000000001'),
 ('159','CARMEN     V.','ARGUELLO','2003-12-31','023','CARRERA 3A  CON CARRERA 4  PIEDRAD NORTE  CONJUNTO VIEJO  TRAPICHE  CASA 2','0251  2624476','0414  5188484','ARGUELLOCARMEN@YAHOO.ES','002','011','001','','CENTRO CLINICO VALENTINA CANABAL  URB. DEL ESTE CALLE BOLIVAR CON AV.CRIPULO BENITEZ','0251  7107725 -','0251 2545551','AARGUELLOCARMEN@CANTV.NET','001','001','001','0000000001'),
 ('10988298','RAIZA SOBELLA','ROMAN','2004-12-31','024','PREBO 1 EDIF. PUNTA BRAVA EDIF. 7 HAB. 701','0241  8224732','0416 3520471','CHALATIRAVE@HOTMAIL.COM','012','011','001','494','CALLE RONDON C/C 5 DE JULIO','0241  8561162','','','012','011','001','0000000001'),
 ('5375041','RAFAEL DE JESUS','ABINAZAR MORENO','1997-12-31','017','','0258  4336247','0414 5943024','','045','005','001','008','','0258  4332660','0258 4337376','','045','005','001','0000000001'),
 ('125','KARINA','GONZALEZ CARTA','2003-12-31','023','','','0414  5257198','','002','011','001','001',' CENTRO CLINICO UROLOGICO BARQUISIMETO  TORRE LA PREVISORA CARR.19 ESQ. CALLE 33 PISO 2 MEZAB. 2B','0251  2318555','0251  2318844','KARINAALVIREZ@HOTMAIL.COM','001','001','001','0000000001'),
 ('15279224','FRANCESCO','IACONA','1995-12-30','015','MIAMI','','','','023','017','001','','CLINICA TRINIDAD','02912426337','','','023','017','01','0000000001'),
 ('126','CANDIDA','ARTIGA','1996-12-31','016','UPATA','0288  8083051','','JLOANDRE131PISO2003@HOTMAIL.COM','037','020','001','','UPATA','0286 8887026','0288  4147892','','037','020','001','0000000001'),
 ('2006','JOSE ABIMAEL','SALAZAR BOADA','2006-03-18','025','','','0416   1261215','ABISNAELSALAZAR@HOTMAIL.COM','002','011','001','001','CARRERA 17 CON CALLE 12','','','','001','001','001','0000000001'),
 ('32006','XIMENA PATRICIA','MADRID','2006-03-18','025','CONJUNTO  RESIDENCIAL CERRAMAR APTO B-13 SECTOR MORRO SUR  LECHERIA','0281   2635494','0414  5251275','XIMENAMADRID@YAAHOO.COM','022','023','001','211','PUERTO LA CRUZ','','','','026','017','001','0000000001'),
 ('82006','GIOVANNI','','2006-03-18','025','','0251  2615778','0414  7062110','','002','011','001','001','CARRERA 17 CON CALLE 12','','','','001','001','001','0000000001'),
 ('12006','JOSE LUIS','CASTILLO RANGEL','2006-03-18','025','CALLE CRUZ PAREDEZ N 23-142 URB. LA VICTORIA DETRAS DEL HOSP. LUIS RAZZETTI','0273  4153093','0414  5168866','JUSTNACASTILLO@HOTMAIL.COM','036','014','001','295','BARINAS','','','','036','014','001','0000000001'),
 ('182006','EVELIO RAMON','PACHECO HERNANDEZ','2006-03-18','025','AV.  PLAZA N 18-74','0249 7930813','0412  8507329','EMANEPACHECO@HOTMAIL.COM','090','011','001','446','NIRGUA','','','','090','011','001','0000000001'),
 ('812006','RAFAEL  ANGEL','SULBARAN QUINTERO','2006-03-18','025','URB. LAS MESETAS EDIF. 6 PISO 6 N 66','','0414  7291144','SILBARANQUINTERO@HOTMAIL,COM','051','008','001','001','HEMODINAMA   DE ASCARDIO','','','','001','001','001','0000000001'),
 ('2212006','SANDRA','RAMOS','2006-03-18','025','AV. LARA','','','','002','011','001','394','AV BOLIVAR','','','','001','001','001','0000000001'),
 ('1832006','VIRGINIA','BRAVO','2006-03-18','025','','','','','023','017','001','010','MATURIN','','','','023','017','001','0000000001'),
 ('8194340','HORACIO LUCIANO','SINEIRO DIAZ','2004-03-01','026','TIERRA DEL SOL CABUDARE','O251  2659966','','','002','011','001','001','CARRERA 17 CON CALLE 12','0251   2524808','','','001','001','','0000000001'),
 ('11880981','MONICA','ROMERO LOFIEGO','0200-03-01','026','','0251     2542182','','','002','011','','001','CARRERA 17 CON CALLE 12    SERVICIO DE REHABILITACION','0251    5254191','','','001','001','','0000000001'),
 ('10053158','ADRIANA DE JESUS','BETANCOURT MARIN','2004-03-01','026','','0251   7185939','','','002','011','','001','CARRERA 17 CON CALLE 12','0251   2524808','','','001','001','','0000000001'),
 ('8546308','RAQUEL MARIA','RUIZ RAGEL','2004-03-01','026','','','','','002','011','','091','AV. BOLIVAR','','','','001','001','','0000000001'),
 ('9791366','MARCIA VANESSA','FERRER MARCANO','2004-03-01','026','URB AGUA VIVA CASA 27 D TIPORO','','0416 2875190','','023','017','01','489','MATULIN','','','','023','017','01','0000000001'),
 ('8640825','JOSE MIGUEL','ZAMORA ALVAREZ','2004-03-01','026','','','','','026','017','01','211','','','','','026','017','01','0000000001'),
 ('8411905','NESTOR RAFAEL','VELAZQUEZ PAREDES','2004-03-01','026','URB. LA MORA','','','','002','011','','456','ACARIGUA','','','','018','015','001','0000000001'),
 ('8298641','GABRIELA DEL VALLE','DIAZ CANACHE','2008-04-15','027','URB. RAFAEL CALDERA CALLE 1,  # 14  QUITA CRISTO JOSE BARCELONA','0281  2773714','0414  3945568','','002','011','001','001','HOLTER    POSTGRADO DE ELECTRFISIOLOGIA','','','','001','001','001','0000000001'),
 ('9869774','MARIELA DEL VALLE','EXTTINGELTT PEREZ','2008-04-15','027','QUITA LA MILAGROSA  CALLE PLAZA  #25 ENTRE MUNICIPIO Y JABILLO','','','','021','013','001','','PRIVADA  EN SAN FERNANDO DE APURE','','','','021','013','001','0000000001'),
 ('6300702','ANA LUCIA','FEBRE MARQUINA','2008-04-15','027','BARRIO LA FERIA   CALLE 12 CON CARRERA 16','','','','002','011','001','123','CARRERA 22 CON CALLE 29','','','','001','001','001','0000000001'),
 ('10135920','ANA  BELLA','GUILLEN GUEDEZ','2008-04-15','027','CARRERA 9  #35 PIRITU','','','','018','015','001','001','CIRUGIA CARDIOVASCULAR','','','','001','001','001','0000000001'),
 ('11433196','LUZ  ELENA','FALCON ROMERO','2008-04-15','027','SANTA ELENA','0251  2552589','0414  4537303','','002','011','001','001','SERVICIO DE ECOCARDIOGRAFIA','','','','001','001','001','0000000001'),
 ('11803468','NELLYS CAROLINA','CAMPOS JORDAN','2008-04-15','027','SANTA  ROSA','','0414 24  1935093','NEJOK4@YAHOO.COM','002','011','001','001','CONSULTA   VALVULAR','','','','001','001','001','0000000001'),
 ('12239903','CARLOS RAFAEL','PEREZ ALTUVE','2008-04-15','027','','0251','0414 5758500','','002','011','001','001','SERVICIO DE ECOCARDIOGRAFIA    EL   FELO','0251   2520848','','','001','001','001','0000000001'),
 ('8932202','SURIMA  LEONARDA','VELASQUEZ  MARTINEZ','2008-04-15','027','GUAYANA','0286  9315490','0416   3907640','','100','020','001','','PRIVADA  EN BOLIVAR','','','','100','020','001','0000000001'),
 ('9602331','VICEEMY MARIA','OCHOA MIJEREZ','2008-03-15','027','URB VISTA MAS  EDIF. LOS SAMANES 4  APART 2B  PUERTO CABELLO','0242  3771097','0414  9578170--','VICCEMY@HOTMAIL.COM, VICCEMY@GMAIL.COM','013','011','001','167','VIA BASE NAVAL   PUERTO CABELLO','0242  3601284','','','013','011','001','0000000001'),
 ('123456','bb','bb','0000-00-00','124','bb','qqqq','bb','bb','004','013','015','4','45','4','54','5','002','013','016','0000000001');


--
-- Definition of table `svctegresadospostgrado`
--

CREATE TABLE `svctegresadospostgrado` (
  `codpos` varchar(10) NOT NULL,
  `cedegr` varchar(10) NOT NULL,
  `nomegr` varchar(25) NOT NULL,
  `apeegr` varchar(25) NOT NULL,
  `anogra` varchar(4) default NULL,
  `stasvc` varchar(2) default NULL,
  PRIMARY KEY  (`cedegr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctegresadospostgrado`
--

INSERT INTO `svctegresadospostgrado` (`codpos`,`cedegr`,`nomegr`,`apeegr`,`anogra`,`stasvc`) VALUES 
 ('0000000001','112233','lolo','kiko','1986','SI');


--
-- Definition of table `svctespeciali`
--

CREATE TABLE `svctespeciali` (
  `codesp` varchar(10) NOT NULL,
  `nomesp` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctespeciali`
--

INSERT INTO `svctespeciali` (`codesp`,`nomesp`) VALUES 
 ('001','Cardiologo'),
 ('002','Cirujano'),
 ('003','abcdeá'),
 ('004','áéíóúñÑ¡¿+/&');


--
-- Definition of table `svctestados`
--

CREATE TABLE `svctestados` (
  `codest` char(3) NOT NULL,
  `nomest` char(50) default NULL,
  PRIMARY KEY  (`codest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctestados`
--

INSERT INTO `svctestados` (`codest`,`nomest`) VALUES 
 ('001','AMAZONAS'),
 ('002','ANZOATEGUI'),
 ('003','APURE'),
 ('004','ARAGUA'),
 ('005','BARINAS'),
 ('006','BOLIVAR'),
 ('007','CARABOBO'),
 ('008','COJEDES'),
 ('009','DELTA AMACURO'),
 ('010','FALCON'),
 ('011','LARA'),
 ('012','MERIDA'),
 ('013','MIRANDA'),
 ('014','MONAGAS'),
 ('015','NUEVA ESPARTA'),
 ('016','PORTUGUESA'),
 ('017','SUCRE'),
 ('018','TACHIRA'),
 ('019','TRUJILLO'),
 ('020','YARACUY'),
 ('021','ZULIA'),
 ('022','DISTRITO FEDERAL'),
 ('023','VARGAS'),
 ('024','GUARICO');


--
-- Definition of table `svcteventos`
--

CREATE TABLE `svcteventos` (
  `codeve` varchar(10) NOT NULL,
  `nomeve` varchar(100) NOT NULL,
  `lugeve` varchar(200) default NULL,
  `emaeve` varchar(30) NOT NULL,
  `urleve` varchar(120) NOT NULL,
  `televe` varchar(40) NOT NULL,
  `fecdes` date NOT NULL,
  `fechas` date NOT NULL,
  `staven` varchar(2) default NULL,
  PRIMARY KEY  (`codeve`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcteventos`
--

INSERT INTO `svcteventos` (`codeve`,`nomeve`,`lugeve`,`emaeve`,`urleve`,`televe`,`fecdes`,`fechas`,`staven`) VALUES 
 ('0000000001','1st International Congress on Cardiomyopathies and','Kyoto - Japan','meetings@ischf.org','www.ischf.org',' 81 757516477','2007-04-10','2007-04-13','NO'),
 ('0000000002','56th  Annual Scientific Session','New Orleans - Usa','resource@acc.org','www.acc.org','13018979745','2007-04-26','2007-05-31','NO'),
 ('0000000003','16th ASEAN Congress of Cardilogy','Nusa Dua - Indonesia','secretariat@16thacc.org','www.16thacc.org','62215681149','2007-04-23','2007-05-31','SI'),
 ('0000000004','Prueba 4','-','-','-','-','2007-04-27','2007-04-30','SI'),
 ('0000000005','Curso PHP','kk','kk','kk','kk','2007-08-21','2007-08-24','SI');


--
-- Definition of table `svctfilial`
--

CREATE TABLE `svctfilial` (
  `codfil` varchar(10) NOT NULL,
  `nomfil` varchar(60) default NULL,
  PRIMARY KEY  (`codfil`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctfilial`
--

INSERT INTO `svctfilial` (`codfil`,`nomfil`) VALUES 
 ('001','Sede (Caracas - Miranda - Vargas)'),
 ('002','Centro Occidental (Lara - Yaracuy)'),
 ('003','Andina (Merida - Trujillo)'),
 ('004','Centro Carabobo (Carabobo)'),
 ('005','Centro Cojedes (Cojedes)'),
 ('006','Centro Sur (Aragua - Guarico - Apure)'),
 ('007','Falcon (Falcon)'),
 ('008','Insular (Nueva Esparta)'),
 ('009','Llanos Occidentales (Portuguesa - Barinas)'),
 ('010','Nor Oriental (Anzoategui - Sucre)'),
 ('011','Sur Guayana (Bolivar - Amazonas)'),
 ('012','Sur Oriental (Monagas - Delta Amacuro)'),
 ('013','Tachira (Tachira)'),
 ('014','Zulia (Zulia)'),
 ('015','Inubicable');


--
-- Definition of table `svctfilialcapitulo`
--

CREATE TABLE `svctfilialcapitulo` (
  `codcap` varchar(10) default NULL,
  `codaso` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctfilialcapitulo`
--

INSERT INTO `svctfilialcapitulo` (`codcap`,`codaso`) VALUES 
 ('002','0000000015'),
 ('002','0000000001'),
 ('002','0000000023'),
 ('011','0000000009'),
 ('012','0000000009'),
 ('006','0000000001'),
 ('006','0000000002');


--
-- Definition of table `svctfilialestados`
--

CREATE TABLE `svctfilialestados` (
  `codfil` varchar(10) NOT NULL,
  `codest` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctfilialestados`
--

INSERT INTO `svctfilialestados` (`codfil`,`codest`) VALUES 
 ('003','012'),
 ('003','019'),
 ('004','007'),
 ('005','008'),
 ('006','004'),
 ('006','003'),
 ('006','024'),
 ('007','010'),
 ('008','015'),
 ('009','005'),
 ('009','016'),
 ('010','002'),
 ('010','017'),
 ('012','009'),
 ('012','014'),
 ('013','018'),
 ('014','021'),
 ('001','022'),
 ('001','013'),
 ('001','023'),
 ('002','011'),
 ('002','020'),
 ('011','006'),
 ('011','001');


--
-- Definition of table `svctformatos`
--

CREATE TABLE `svctformatos` (
  `codfor` varchar(10) NOT NULL default '',
  `nomfor` varchar(50) default NULL,
  `nomarc` varchar(50) default NULL,
  `tiparc` varchar(20) default NULL,
  `tamarc` int(11) default NULL,
  `datarc` longblob,
  PRIMARY KEY  (`codfor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctformatos`
--



--
-- Definition of table `svctfotos`
--

CREATE TABLE `svctfotos` (
  `codfot` varchar(10) NOT NULL default '',
  `titfot` varchar(30) default NULL,
  `nomfot` varchar(50) NOT NULL,
  `tipfot` varchar(20) NOT NULL,
  `tamfot` int(11) NOT NULL,
  `datfot` longblob NOT NULL,
  PRIMARY KEY  (`codfot`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctfotos`
--

INSERT INTO `svctfotos` (`codfot`,`titfot`,`nomfot`,`tipfot`,`tamfot`,`datfot`) VALUES 
 ('0000000001','Jornadasxiv','xivjainicio.jpg','image/pjpeg',15531,0x[encoded data, 42508 characters]),
 ('0000000002','cesta','cesta.gif','image/gif',2198,0x[encoded data, 6020 characters]),
 ('0000000003','bichos','bichos.gif','image/gif',6541,0x[encoded data, 17908 characters]),
 ('0000000005','Chica','20070404.jpg','image/pjpeg',51998,0x[encoded data, 142316 characters]);
INSERT INTO `svctfotos` (`codfot`,`titfot`,`nomfot`,`tipfot`,`tamfot`,`datfot`) VALUES 
 ('0000000007','Congreso Venezolano Caracas','bannercongre.jpg','image/jpeg',18969,0x[encoded data, 51916 characters]),
 ('0000000008','Congreso Margarita','congresoccc.jpg','image/jpeg',40628,0x[encoded data, 111196 characters]),
