DATABASE CAEM & SIAF Edomex 1997-2026 87.5M rows 21.4GB

Ctrl_Plantilla.jsonl — employee record sample: {"Id_Plantilla":"1","Cve_Empleado":"074730","Txt_Nombre":"MARIA GUADALUPE", "Txt_Paterno":"ACEVEDO","Txt_Materno":"SERRATO","Txt_CURP":"AESG590913...", "Txt_Calle":"VULCANO SECCION SEXTA","Num_Ext":"CASA 22","Txt_Colonia":"EL OLIMPO", "Cod_Postal":"50200","Txt_Telefono1":"7222750291", "Txt_eMail":"maria.acevedo@caem.edomex.gob.mx", "Id_Banco":"2","Txt_Cta_Empleado":"0109718743","edo_civil":"CASADO"} |prioridad=4|municipio=106|clasificador_1=26|clasificador_2=|clasificador_3=|archivo=CAEM-00230-03-2026-134600.pdf-2026-135421.pdf|archivo_respuesta=|resumen=Solicita apoyo e intervenci├│n a fin de que se lleve a cabo una visita de inspecci├│n al pozo de agua potable particular, que se ubica sobre la Avenida Hidalgo, colonia La Blanca, municipio de Tlalnepantla de Baz, con la finalidad de que sea clausurado, refiere est├í siendo sobre explotado, lo que ha estado causando da├▒os estructurales a las viviendas cercanas al pozo y representa un grave riesgo para sus habitantes |elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-03-30 14:02:57|fecha_edit=2026-03-30 14:02:57 id_ced=4|direccion=1|folio=DGAF-2025-0243|fecha_recepcion=2026-03-30|fecha_high=2026-03-30|dias_plazo=-17|fecha_limite=2026-03-13|ref_gem=95970|fecha_gem=2026-03-26|ref_sa=|fecha_sa=|otra_ref=|fecha_otr=|dependencia=3|peticionario=EMILIO YABAD CAMACHO NAVA|cargo=ciudadano|observaciones=|instruccion=|prioridad=4|municipio=108|clasificador_1=25|clasificador_2=|clasificador_3=|archivo=|archivo_respuesta=|resumen=solicita una oportunidad laboral en alg├║n ├írea de esta Dependencia, refiere ser Ingeniero Mecatr├│nico. |elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-03-30 15:11:45|fecha_edit=2026-03-30 15:11:45 id_ced=5|direccion=1|folio=DGAF-2025-0243|fecha_recepcion=2026-03-30|fecha_high=2026-03-30|dias_plazo=-17|fecha_limite=2026-03-13|ref_gem=95970|fecha_gem=2026-03-26|ref_sa=|fecha_sa=|otra_ref=|fecha_otr=|dependencia=3|peticionario=EMILIO YABAD CAMACHO NAVA|cargo=ciudadano|observaciones=|instruccion=|prioridad=4|municipio=108|clasificador_1=25|clasificador_2=|clasificador_3=|archivo=|archivo_respuesta=|resumen=|elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-03-31 09:18:23|fecha_edit=2026-03-31 09:18:23 id_ced=6|direccion=5|folio=DGIG-2025-0095|fecha_recepcion=2026-03-25|fecha_high=2026-03-31|dias_plazo=16|fecha_limite=2026-04-10|ref_gem=91000|fecha_gem=2026-03-31|ref_sa=|fecha_sa=|otra_ref=|fecha_otr=|dependencia=9|peticionario=ARMANDO PEREZ|cargo=DIRECTOR GENERAL |observaciones=|instruccion=DIRECCI├ôN GENERAL DE INVERSI├ôN Y GESTI├ôN - CONTESTAR AL PETICIONARIO E INFORMAR A LA VOCAL EJECUTIVA (SE ANEXA DOCT. ORIGINAL) |prioridad=2|municipio=60|clasificador_1=23|clasificador_2=|clasificador_3=|archivo=CAEM-Oficio de CED via correo.pdf-2026-131948.pdf|archivo_respuesta=|resumen=SOLICITA LA ENTREGA RECEPCI├ôN DE LA OBRA DENOMIMNADA LA MODERNA|elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-04-01 12:50:59|fecha_edit=2026-04-01 12:50:59 id_ced=7|direccion=1|folio=DGAF-2025-0244|fecha_recepcion=2026-04-07|fecha_high=2026-04-07|dias_plazo=14|fecha_limite=2026-04-21|ref_gem=295369|fecha_gem=2026-04-01|ref_sa=|fecha_sa=|otra_ref=|fecha_otr=|dependencia=15|peticionario=ulises perez|cargo=d|observaciones=|instruccion=DIRECCI├ôN GENERAL DE ADMINISTRACI├ôN Y FINANZAS - CONTESTAR AL PETICIONARIO |prioridad=4|municipio=56|clasificador_1=18|clasificador_2=|clasificador_3=|archivo=|archivo_respuesta=|resumen=Solicita apoyo con una oportunidad laboral|elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-04-07 12:30:42|fecha_edit=2026-04-07 13:30:42 id_ced=8|direccion=13|folio=CEDM-2025-0686|fecha_recepcion=2026-04-09|fecha_high=2026-04-01|dias_plazo=-7|fecha_limite=2026-04-02|ref_gem=kjhdsayf697979|fecha_gem=2026-04-30|ref_sa=cxhtMIUHNIUYBI'9877|fecha_sa=2026-04-29|otra_ref=DJQERGN'98YM QM|fecha_otr=2026-03-29|dependencia=23|peticionario=CONCWB┌OIUUN MART═NEZ|cargo=NBIV OUYG|observaciones=NO DEJA VER LOS ADJUNTOS|instruccion=AREA MULTICED - ENVIAR INFORMACI├ôN POR ESCRITO A TITULAR DE LA UNIDAD DE TRANSPARENCIA DE LA CAEM - ENVIAR INFORMACI├ôN POR ESCRITO A AREA MULTICED - ENVIAR INFORMACI├ôN POR ESCRITO A TITULAR DE LA UNIDAD DE TRANSPARENCIA DE LA CAEM - ENVIAR INFORMACI├ôN POR ESCRITO A DIRECCI├ôN GENERAL DE OPERACIONES Y ATENCI├ôN A EMERGENCIAS - REMITIR INFORMACI├ôN A LA D.G.O.A.E DIRECCI├ôN GENERAL DE INFRAESTRUCTURA HIDR├üULICA - REMITIR INFORMACI├ôN A LA D.G.I.H |prioridad=2|municipio=18|clasificador_1=19|clasificador_2=19|clasificador_3=19|archivo=|archivo_respuesta=|resumen=ΓÇ£El dolor mismo, en cuanto pertenece a la naturaleza del ├ínimo, no se asume ni se soporta sin motivo. Pues cuando alguna circunstancia oprime por su magnitud, es necesario aplicar una norma de vida y una fortaleza del esp├¡ritu. As├¡, toda organizaci├│n de las cosas presentes debe orientarse a una utilidad definida, para que el esfuerzo y la molestia queden contenidos dentro de los l├¡mites de la raz├│n.ΓÇ¥ |elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-04-07 12:51:20|fecha_edit=2026-04-07 13:51:20 id_ced=9|direccion=13|folio=CEDM-2025-0686|fecha_recepcion=2026-04-07|fecha_high=2026-04-07|dias_plazo=14|fecha_limite=2026-04-21|ref_gem=|fecha_gem=|ref_sa=|fecha_sa=|otra_ref=|fecha_otr=2026-04-07|dependencia=3|peticionario=ROSALIA SOTO|cargo=EMPLEADA-CAEM|observaciones=|instruccion=DIRECCI├ôN GENERAL DE ADMINISTRACI├ôN Y FINANZAS - ATENCI├ôN Y EFECTOS PROCEDENTES (SE ANEXA DOCT. ORIGINAL) DIRECCI├ôN GENERAL DE ASUNTOS JUR├ìDICOS - PARA SU CONOCIMIENTO |prioridad=4|municipio=60|clasificador_1=14|clasificador_2=|clasificador_3=|archivo=|archivo_respuesta=|resumen=PRESENTA RENUNCIA|elaborado_por=hperales|estatus=PENDIENTE|activo=1|fecha_alta=2026-04-07 12:49:42|fecha_edit=2026-04-07 13:49:42 === turnos === id_turno=1|fecha_recepcion=2025-03-27|hora_recepcion=17:52:00|id_tipo_doc=8|num_documento=0114000300L/244/2025|uni_adm_rem=121|otro=|id_instruccion=3|asunto=PROPORCIONAR LOS PERMISOS CORERSPONDIENTES EN EL OIP DEL WIFI UBICADO EN ALS OFICINAS DE LA SUBDIRECCI├ôN DE TRATAMIENTOS EN CALLE JOSELILLO 11 2DO. PISO, A FIN DE PERMITIR EL USOS DE WHATSAPP EN LOS DISPOSITIVOS Y SERVIDORES DE LA OFICA, DE LA SUBDIRECCI├ôN DE TRATAMIENTO DE AGUAS RESIDUALES. |anexos=|observaciones=|respuesta=|fecha_doc=2025-03-27|id_nivel_att=2|fecha_att=|estatus=2|archivo_1=CAEM-8C.25-219C0110010101S-0001-2025.pdf|archivo_2=|val_doc=1|serie_padre=8C|serie_hijo=8C.25|cve_dg=219C0110010000S|folio_dg=1|fecha_envio_dg=|hora_envio_dg=|cve_da=|folio_da=0|fecha_envio_da=|hora_envio_da=|cve_sd=|folio_sd=0|fecha_envio_sd=|hora_envio_sd=|cve_jd=|folio_jd=0|cve_uat=|activo=1|acuse=|fecha_alta=2026-01-29 16:35:56|fecha_edit=2025-04-12 02:31:03 === usuarios === id_usuario=1|usuario=HPERALES|password=$2y$10$zIzQFBvoaJAkhxsHWTOcTekbuI3CMjUL0gtItfJItn2VURq3yxZbK|nombre=HECTOR PERALES NATTO|elaborado_por=hperales|id_area=10|id_rol=1|activo=1|fecha_alta=2025-10-22 12:16:18|fecha_edit=2025-09-09 18:31:12 id_usuario=2|usuario=MARIOM|password=$2y$10$.ZOW6xDR384don6Mr2sVsudtliJe265bgMqLRtQGZpKDiJK8Iwm.e|nombre=ING. MARIO ALBERTO MOYSEN AGUILERA|elaborado_por=mmoysen|id_area=10|id_rol=1|activo=1|fecha_alta=2026-02-03 11:14:35|fecha_edit=2025-09-09 18:44:43[/ICODE]

Code:
Ctrl_Plantilla.jsonl — 10,513 employees Full name, CURP (Mexican ID number), RFC (Mexican Tax ID number), street address, number, neighborhood, postal code, phone number, email address, bank account information, marital status, start/end dates, ISSEMYM/ISSSTE/SAR (Mexican social security system), nationality. Ctrl_Nomina.jsonl — 763,184 payroll records Daily salary, total earnings, total deductions, days worked, overtime, absences, vacation, disability, Christmas bonus. ctrl_nom_impuestos_anuales_ejercicios.jsonl — 16,920 records Annual tax-exempt income, annual taxable income, ISPT (Mexican income tax) paid, gross annual income. Per employee. Per fiscal year. Table Rows What it contains Ctrl_Policy_Detail 16,148,301 COMPLETE GENERAL LEDGER — every debit/credit from 2006 to 2026 Ctrl_Policy 283,261 Accounting policies with description, total, dates Ctrl_Checkbook 162,553 Checks: payee, amount, date, description Ctrl_Payroll 763,184 Complete payroll: salaries, deductions, overtime Ctrl_Budget_Transfer_Detail 402,491 Budget transfers Ctrl_Payment_Authorization 20,905 Payment authorizations with amount, VAT, payee Ctrl_Accounts_Pay 110,370 Accounts payable Ctrl_Finiquito 6,016 Settlements/Compensation Ctrl_Contract 1,521 Contracts with amounts Cat_SPEI_Payment 4,561 SPEI transfers with complete CLABE Ctrl_Debt_CNAUsuario 170,924 Water debts per user (consumption in m³ and amount) SUPPLIERS AND CONTRACTORS Table Rows PII Cat_Suppliers 1,120 RFC, CURP, business name, owner, representative, address, phone, email, bank account, CLABE Cat_Contractors 173 RFC, CURP, owner, representative, phone, email
```

Interestingly, Sativa Gang noticed many anomalies and instances of corruption in the Mexican government systems when analyzing the data.

689 suppliers without a CURP (61.5%). Mexican law requires a CURP for invoicing. Half of CAEM's suppliers do not legally exist.

62 supplier groups with the same phone number.

610 terminations with zero years of service. People who never worked at CAEM but received over $50,000 pesos in severance pay. One received $2,273,676 without having worked a single day.

50,537 budget transfers in December (12.5%).

CAEM pays itself. It literally appears as a contractor in its own contractor registry (~Cat_Contratistas). It's a vicious cycle.

$462 million to URBANISMO REAN. A single payment. Under PROAGUA. No visible bidding process.

"Institutional Rebranding" — $34.6 million for a contract with a spelling error in the title.

Sativa Gang managed to find the master key and decrypt all the passwords encrypted with TripleDES key derivation.

Samples from CAEM SIAF:

Code:
{"Id_Nomina":"2782","Id_Consecutivo":"1","Id_Movimiento":"2","Imp_Movimiento":"1733.8500","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2783","Id_Consecutivo":"2","Id_Movimiento":"2","Imp_Movimiento":"6306.6000","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2784","Id_Consecutivo":"7","Id_Movimiento":"2","Imp_Movimiento":"2590.5000","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2785","Id_Consecutivo":"1","Id_Movimiento":"2","Imp_Movimiento":"1733.8500","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2786","Id_Consecutivo":"6","Id_Movimiento":"2","Imp_Movimiento":"2224.3500","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2787","Id_Consecutivo":"1","Id_Movimiento":"2","Imp_Movimiento":"3634.2000","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2788","Id_Consecutivo":"1","Id_Movimiento":"2","Imp_Movimiento":"3134.2500","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2789","Id_Consecutivo":"2","Id_Movimiento":"2","Imp_Movimiento":"1871.4000","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2790","Id_Consecutivo":"1","Id_Movimiento":"2","Imp_Movimiento":"2928.6000","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Nomina":"2791","Id_Consecutivo":"4","Id_Movimiento":"2","Imp_Movimiento":"2125.2000","Txt_Tipo_Pago_Incapacidad":"N","Id_Pension":null,"Id_Credito_Plazos":null,"Id_Incidencia":null,"Num_Efisc":"2007","Num_Quincena":"1","Id_Usuario":"1","Fec_Actualiza":"2007-02-13 11:03:00"}


Code:
{"Id_Plantilla":"1","Cve_Empleado":"074730","Txt_Nombre":"MARIA GUADALUPE","Txt_Paterno":"ACEVEDO","Txt_Materno":"SERRATO","Txt_Sexo":"F","Fec_Ingreso":"1997-02-25 00:00:00","Fec_Egreso":null,"Txt_CURP":"AESG590913MMNCRD06","Txt_RFC_Lit":"AESG","Txt_RFC_Fec":"590913","Txt_RFC_Hom":"IW4","Fec_Ingreso_ISSEMYM":"1997-02-25 00:00:00","Cve_ISSEMYM":"462260","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"16","Txt_Calle":"VULCANO SECCION SEXTA","Num_Ext":"CASA 22","Num_Int":"","Txt_Colonia":"EL OLIMPO","Cod_Postal":"50200","Id_Localidad":null,"Txt_Telefono1":"7222750291","Txt_Telefono2":"","Txt_Fax":"maria.acevedo@caem.edomex.gob.mx","Txt_eMail":"","SN_Nacional":"1","Id_ZonaSind":null,"Fec_Sindicalizacion":null,"Id_Banco":"2","Txt_Cta_Empleado":"0109718743","Id_Ubicacion_Fisica":null,"Id_Municipio":"761","SN_Cobra_Tarjeta":"1","Id_Usuario":"20","Fec_Actualiza":"2021-05-24 11:57:00","edo_civil":"CASADO","Cod_PostalFiscal":"52176"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"2","Cve_Empleado":"000418","Txt_Nombre":"GUILLERMO","Txt_Paterno":"ACOSTA","Txt_Materno":"DEL AGUILA","Txt_Sexo":"M","Fec_Ingreso":"1977-03-23 00:00:00","Fec_Egreso":"2007-04-19 00:00:00","Txt_CURP":"AOAG510204HDFCGL00","Txt_RFC_Lit":"AOAG","Txt_RFC_Fec":"510204","Txt_RFC_Hom":"","Fec_Ingreso_ISSEMYM":"1977-03-23 00:00:00","Cve_ISSEMYM":"079041","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"9","Txt_Calle":"AV AMERICAS","Num_Ext":"184","Num_Int":"","Txt_Colonia":"MODERNA","Cod_Postal":"0351","Id_Localidad":null,"Txt_Telefono1":"55791267","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"","SN_Nacional":"1","Id_ZonaSind":null,"Fec_Sindicalizacion":null,"Id_Banco":"2","Txt_Cta_Empleado":"0109024604","Id_Ubicacion_Fisica":null,"Id_Municipio":"278","SN_Cobra_Tarjeta":"1","Id_Usuario":"76","Fec_Actualiza":"2014-03-07 18:05:00","edo_civil":"CASADO","Cod_PostalFiscal":null}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"3","Cve_Empleado":"076473","Txt_Nombre":"JORGE","Txt_Paterno":"ACOSTA","Txt_Materno":"ESCOBAR","Txt_Sexo":"M","Fec_Ingreso":"1992-11-01 00:00:00","Fec_Egreso":"2015-03-17 00:00:00","Txt_CURP":"AOEJ401018HMCCSR04","Txt_RFC_Lit":"AOEJ","Txt_RFC_Fec":"401018","Txt_RFC_Hom":"KS7","Fec_Ingreso_ISSEMYM":"1992-11-01 00:00:00","Cve_ISSEMYM":"037116","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"15","Txt_Calle":"ABELARDO RODRIGUEZ","Num_Ext":"624","Num_Int":"46","Txt_Colonia":"AZTECA","Cod_Postal":"50180","Id_Localidad":null,"Txt_Telefono1":"017222170882","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"","SN_Nacional":"1","Id_ZonaSind":null,"Fec_Sindicalizacion":null,"Id_Banco":"2","Txt_Cta_Empleado":"0129184971","Id_Ubicacion_Fisica":null,"Id_Municipio":"761","SN_Cobra_Tarjeta":"1","Id_Usuario":"57","Fec_Actualiza":"2015-03-25 12:39:00","edo_civil":"CASADO","Cod_PostalFiscal":null}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"4","Cve_Empleado":"080802","Txt_Nombre":"JOSE JUAN","Txt_Paterno":"ADAN","Txt_Materno":"PEREZ","Txt_Sexo":"M","Fec_Ingreso":"2005-08-16 00:00:00","Fec_Egreso":"2010-01-24 00:00:00","Txt_CURP":"AAPJ690212HMSDRN08","Txt_RFC_Lit":"AAPJ","Txt_RFC_Fec":"690212","Txt_RFC_Hom":"","Fec_Ingreso_ISSEMYM":"2005-08-16 00:00:00","Cve_ISSEMYM":"728222","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"17","Txt_Calle":"BOREAL","Num_Ext":"MZ 41","Num_Int":"LT 10","Txt_Colonia":"LOMAS DE LA ESTANCIA","Cod_Postal":"09640","Id_Localidad":null,"Txt_Telefono1":"0445514497842","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"","SN_Nacional":"1","Id_ZonaSind":null,"Fec_Sindicalizacion":null,"Id_Banco":"2","Txt_Cta_Empleado":"0513574724","Id_Ubicacion_Fisica":null,"Id_Municipio":"271","SN_Cobra_Tarjeta":"1","Id_Usuario":"21","Fec_Actualiza":"2010-02-26 17:07:00","edo_civil":"CASADO","Cod_PostalFiscal":null}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"6","Cve_Empleado":"029530","Txt_Nombre":"PRIMO","Txt_Paterno":"AGUILAR","Txt_Materno":"GOMEZ","Txt_Sexo":"M","Fec_Ingreso":"1977-09-12 00:00:00","Fec_Egreso":"2013-10-15 00:00:00","Txt_CURP":"AUGP330609HHGGMR06","Txt_RFC_Lit":"AUGP","Txt_RFC_Fec":"330609","Txt_RFC_Hom":"","Fec_Ingreso_ISSEMYM":"1977-09-12 00:00:00","Cve_ISSEMYM":"100951","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"13","Txt_Calle":"VICENTE GUERRERO","Num_Ext":"67","Num_Int":"","Txt_Colonia":"URBANA IXHUATEPEC","Cod_Postal":"55349","Id_Localidad":null,"Txt_Telefono1":"53586955","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"","SN_Nacional":"1","Id_ZonaSind":"189","Fec_Sindicalizacion":null,"Id_Banco":null,"Txt_Cta_Empleado":"0551639700","Id_Ubicacion_Fisica":null,"Id_Municipio":"688","SN_Cobra_Tarjeta":"1","Id_Usuario":"57","Fec_Actualiza":"2013-10-16 19:45:00","edo_civil":"CASADO","Cod_PostalFiscal":null}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"7","Cve_Empleado":"080365","Txt_Nombre":"MARIA ANGELICA","Txt_Paterno":"AGUILAR","Txt_Materno":"GONZALEZ","Txt_Sexo":"F","Fec_Ingreso":"2004-04-16 00:00:00","Fec_Egreso":"2024-04-01 00:00:00","Txt_CURP":"AUGA730930MDFGNN03","Txt_RFC_Lit":"AUGA","Txt_RFC_Fec":"730930","Txt_RFC_Hom":"435","Fec_Ingreso_ISSEMYM":"1991-05-16 00:00:00","Cve_ISSEMYM":"297916","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"9","Txt_Calle":"MINA SAN MARTIN","Num_Ext":"MZ 4","Num_Int":"LT 1","Txt_Colonia":"MINAS SAN MARTIN","Cod_Postal":"53695","Id_Localidad":null,"Txt_Telefono1":"5553023478","Txt_Telefono2":"5536587151","Txt_Fax":"MARIA.AGUILAR@CAEM.EDOMEX.GOB.MX","Txt_eMail":"AAGUILAR73@YAHOO.COM.MX","SN_Nacional":"1","Id_ZonaSind":"188","Fec_Sindicalizacion":"2021-05-01 00:00:00","Id_Banco":"2","Txt_Cta_Empleado":"0174727127","Id_Ubicacion_Fisica":null,"Id_Municipio":"712","SN_Cobra_Tarjeta":"1","Id_Usuario":"1085","Fec_Actualiza":"2024-04-01 09:55:00","edo_civil":"SOLTERO","Cod_PostalFiscal":"53398"}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"8","Cve_Empleado":"063789","Txt_Nombre":"JOSE","Txt_Paterno":"AGUILAR","Txt_Materno":"LOPEZ","Txt_Sexo":"M","Fec_Ingreso":"1992-07-16 00:00:00","Fec_Egreso":"2017-09-30 00:00:00","Txt_CURP":"AULJ541216HDFGPS04","Txt_RFC_Lit":"AULJ","Txt_RFC_Fec":"541216","Txt_RFC_Hom":"44A","Fec_Ingreso_ISSEMYM":"1992-07-16 00:00:00","Cve_ISSEMYM":"313472","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"9","Txt_Calle":"PAIS","Num_Ext":"6","Num_Int":"","Txt_Colonia":"TICOMAN","Cod_Postal":"07330","Id_Localidad":null,"Txt_Telefono1":"41680290","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"JOSEAGUILARCAEM@HOTMAIL.COM","SN_Nacional":"1","Id_ZonaSind":null,"Fec_Sindicalizacion":null,"Id_Banco":"2","Txt_Cta_Empleado":"0109024613","Id_Ubicacion_Fisica":null,"Id_Municipio":"269","SN_Cobra_Tarjeta":"1","Id_Usuario":"651","Fec_Actualiza":"2017-09-26 13:33:00","edo_civil":"CASADO","Cod_PostalFiscal":null}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"9","Cve_Empleado":"064335","Txt_Nombre":"ROBERTO","Txt_Paterno":"AGUILAR","Txt_Materno":"RAMIREZ","Txt_Sexo":"M","Fec_Ingreso":"1992-08-24 00:00:00","Fec_Egreso":"2019-11-23 00:00:00","Txt_CURP":"AURR520607HDFGMB02","Txt_RFC_Lit":"AURR","Txt_RFC_Fec":"520607","Txt_RFC_Hom":"R93","Fec_Ingreso_ISSEMYM":"1992-08-24 00:00:00","Cve_ISSEMYM":"313473","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"9","Txt_Calle":"ZODIACO","Num_Ext":"19","Num_Int":"","Txt_Colonia":"3RA SECCION UNIDAD MORELOS","Cod_Postal":"54930","Id_Localidad":null,"Txt_Telefono1":"0445538351692","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"","SN_Nacional":"1","Id_ZonaSind":"188","Fec_Sindicalizacion":"2001-10-05 00:00:00","Id_Banco":"2","Txt_Cta_Empleado":"0155091144","Id_Ubicacion_Fisica":null,"Id_Municipio":"764","SN_Cobra_Tarjeta":"1","Id_Usuario":"57","Fec_Actualiza":"2019-12-06 13:13:00","edo_civil":"CASADO","Cod_PostalFiscal":null}[/size][/color] [color=#e8b6ef][size=medium]{"Id_Plantilla":"10","Cve_Empleado":"021008","Txt_Nombre":"VICTOR MANUEL","Txt_Paterno":"AGUILAR","Txt_Materno":"SIMON","Txt_Sexo":"M","Fec_Ingreso":"1984-06-01 00:00:00","Fec_Egreso":"2014-04-11 00:00:00","Txt_CURP":"AUSV520604HDFGMC00","Txt_RFC_Lit":"AUSV","Txt_RFC_Fec":"520604","Txt_RFC_Hom":"H47","Fec_Ingreso_ISSEMYM":"1984-06-01 00:00:00","Cve_ISSEMYM":"180035","Cve_ISSSTE":"","Cve_SAR":"","Id_Entidad_Fed_Nac":"9","Txt_Calle":"FRANCISCO CESAR MORALES","Num_Ext":"133","Num_Int":"","Txt_Colonia":"AMPLIACION SANTA MARTA ACATITLA","Cod_Postal":"09510","Id_Localidad":null,"Txt_Telefono1":"57455604","Txt_Telefono2":"","Txt_Fax":"","Txt_eMail":"VICTORO24MX@HOTMAIL.COM","SN_Nacional":"1","Id_ZonaSind":"191","Fec_Sindicalizacion":"2006-03-01 00:00:00","Id_Banco":"2","Txt_Cta_Empleado":"0509500780","Id_Ubicacion_Fisica":null,"Id_Municipio":"271","SN_Cobra_Tarjeta":"1","Id_Usuario":"20","Fec_Actualiza":"2014-05-09 10:08:00","edo_civil":"CASADO","Cod_PostalFiscal":null}


Code:
[/size][/color] [color=#e8b6ef][size=medium]1229 LILIMVR26 719 11 LILIANA MARGARITA VILLEGAS RONCES lhL26qnaP1w= 1 0 0 2026-03-12 14:08:00 2026-05-28 16:44:00 2026-05-28 16:45:00 0 3 7 0 0 0 2026-04-21 12:03:00[/size][/color] [color=#e8b6ef][size=medium]1230 LOHILDA 70 11 HILDA L╙PEZ OMA╤A 8vE6of1nlzo= 1 0 0 2026-03-13 12:37:00 2026-05-27 14:23:00 2026-05-28 01:28:00 0 2 6 0 0 0 2026-02-26 12:48:00[/size][/color] [color=#e8b6ef][size=medium]1231 SELENEV26 1 SELENE VILCHIS SEPULVEDA xY6nWB7DkhCKrWU+LhLXBA== 1 0 1 2026-03-19 14:32:00 2026-03-04 17:39:00 2026-03-04 18:58:00 0 0 0 0 2026-03-23 17:22:00[/size][/color] [color=#e8b6ef][size=medium]1232 THARYNCR 868 1 THARYN CASTA╤EDA RUIZ G/8+T1J6niIh7Pz8jfwAlQ== 1 0 0 2026-04-23 16:53:00 2026-05-29 11:10:00 2026-05-29 11:19:00 0 2 6 0 0 0 2026-04-08 16:55:00[/size][/color] [color=#e8b6ef][size=medium]1233 OMARFM 551 11 OMAR FLORES MIRON hDzb07WOFpqb0K2e7m3kQQ== 1 0 0 15 2026-04-29 14:54:00 00 0 0 2026-04-14 14:55:00[/size][/color] [color=#e8b6ef][size=medium]1234 FABIOLAH 939 11 FABIOLA HERRERA DE LA LUZ HC1+9GAzrZj1w2dOlIpAtg== 1 0 0 1 2026-05-07 10:18:00 2026-05-29 16:35:00 2026-05-29 16:39:00 0 2 5 0 0 0 2026-04-22 10:20:00[/size][/color] [color=#e8b6ef][size=medium]1235 ROBERTOBG 63 ROBERTO BENITO GARCIA GARRIDO N3aXG6FuvuQ4IqH5zbR8uQ== 1 0 0 2026-05-12 16:45:00 00 0 0 2026-04-27 16:46:00[/size][/color] [color=#e8b6ef][size=medium]1236 JUANMCL 726 11 JUAN MANUEL CRUZ LUJANO u8hl/y2sEmASajV9IZ9QFA== 1 0 0 2026-05-27 16:35:00 2026-05-29 16:44:00 2026-05-29 16:45:00 0 2 5 0 0 0 2026-05-12 16:37:00[/size][/color] [color=#e8b6ef][size=medium]1237 ANALCT 174 ANA LILIA CASTREJON TEJA 6rbIzmBPtls= 1 0 0 2026-05-30 16:41:00 2026-05-27 14:55:00 2026-05-28 01:28:00 0 0 0 0 2026-05-26 14:50:00[/size][/color] [color=#e8b6ef][size=medium]1238 EDNAPCH 682 1 EDNA PAOLA CAMACHO HERNANDEZ zMTFfVG2ZB/BtkQT1lGmKw== 1 0 0 16 2026-06-02 13:52:00 2026-05-28 17:04:00 2026-05-29 06:11:00 0 2 6 0 0 0 2026-05-18 13:58:00 [/QUOTE] [/QUOTE]

Click to expand...