30-09-26, 09:21 PM
DATABASE LEAK - UTEL ( Latin American Technological University)[Image: bewbs.gif]
![[Image: ?u=https%3A%2F%2Ftse3.mm.bing.net%2Fth%2...ipo=images]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fexternal-content.duckduckgo.com%2Fiu%2F%3Fu%3Dhttps%253A%252F%252Ftse3.mm.bing.net%252Fth%252Fid%252FOIP.KSO2lYMOLhR8U4DkgZ7DswHaHa%253Fr%253D0%2526pid%253DApi%26amp%3Bf%3D1%26amp%3Bipt%3Dc6b4d82b97a8ec5f4577ee980d3494bd6c15b962db5db05754510c881a14e2cf%26amp%3Bipo%3Dimages)
CONTENT[Image: kisses.gif]
├── total: 67 files · 618,732 registers · 138MB
├── ENROLLED 114,847 registers · 23 fields [id, full_name, total_debt_balance, late_fee, risk_level, cia_status, ...]
├── CONTACTS 503,802 registers · 6 fields [country, phone, area_code, country_code, term, email]
├── CHANNELS 83 registers · 7 fields [id, channel, groups, is_active, created_by, ...]
├── JOIN: enrolled.id → contacts[id]
└── SUMMARY: "UTEL (618,732 registers)" @DarkWhoam
@DarkWhoam
CONTENT[Image: kisses.gif]
├── total: 67 files · 618,732 registers · 138MB
├── ENROLLED 114,847 registers · 23 fields [id, full_name, total_debt_balance, late_fee, risk_level, cia_status, ...]
├── CONTACTS 503,802 registers · 6 fields [country, phone, area_code, country_code, term, email]
├── CHANNELS 83 registers · 7 fields [id, channel, groups, is_active, created_by, ...]
├── JOIN: enrolled.id → contacts[id]
└── SUMMARY: "UTEL (618,732 registers)" @DarkWhoam
"sample": [
{
"student_id": "010000077",
"full_name": "JUAN MANUEL ZEPEDA",
"is_enrolled": true,
"payment_plan_status": "Domiciliado",
"payment_plan_result": "",
"payment_plan_result_date": "",
"failed_subjects": 0,
"remediation_subjects_available": "Sin_Nivelacion",
"remediation_start_date": "",
"remediation_end_date": "",
"remediation_days_left": 0,
"risk_level": "Alto riesgo académico",
"late_fee": "Mora3",
"second_payment_date": "10/08/2026",
"remediation_risk_level": "Sin_Nivelacion",
"total_debt_balance": 6840,
"bti_status": "Etiquetado Fase 2",
"payment_deadline": "10/07/2026",
"current_balance": 4415,
"cia_status": "Cierre por adeudo",
"last_lms_access": "Nuncas",
"second_payment_applies": "No aplica",
"payment_counter": 0
},
{
"student_id": "010000124",
"full_name": "Arturo Durán",
"is_enrolled": true,
"payment_plan_status": "No domiciliado",
"payment_plan_result": "",
"payment_plan_result_date": "",
"failed_subjects": 0,
"remediation_subjects_available": "Sin_Nivelacion",
"remediation_start_date": "",
"remediation_end_date": "",
"remediation_days_left": 0,
"risk_level": "Alto riesgo académico",
"late_fee": "Mora2",
"second_payment_date": "10/08/2026",
"remediation_risk_level": "Sin_Nivelacion",
"total_debt_balance": 0,
"bti_status": "",
"payment_deadline": "10/07/2026",
"current_balance": 0,
"cia_status": "",
"last_lms_access": "Nuncas",
"second_payment_applies": "No aplica",
"payment_counter": 0
},
{
"student_id": "010000319",
"full_name": "Javier Pérez",
"is_enrolled": true,
"payment_plan_status": "No domiciliado",
"payment_plan_result": "",
"payment_plan_result_date": "",
"failed_subjects": 0,
"remediation_subjects_available": "Sin_Nivelacion",
"remediation_start_date": "",
"remediation_end_date": "",
"remediation_days_left": 0,
"risk_level": "Alto riesgo académico",
"late_fee": "Mora1",
"second_payment_date": "10/08/2026",
"remediation_risk_level": "Sin_Nivelacion",
"total_debt_balance": 2460,
"bti_status": "",
"payment_deadline": "10/07/2026",
"current_balance": 856,
"cia_status": "",
"last_lms_access": "Nuncas",
"second_payment_applies": "No aplica",
"payment_counter": 0
}
]
},
"student_contacts": {
"endpoint": "GET /api/v1/usuarios/student-contact/bulk-info/?level=LI|MA|MS|ES&page=N",
"total_registers": 503802,
"breakdown": {
"LI": 421583,
"MA": 71868,
"MS": 10349,
"ES": 2
},
"per_page": 10000,
"files": "contacts/contact_{LI,MA,MS,ES}_p*.json (54 files)",
"format": "results is a dict: { student_id: { country, phone, area_code, country_code, term, email } }",
"sample": {
"010001383": {
"country": "México",
"phone": "31216045",
"area_code": "60",
"country_code": "+52",
"term": null,
"email": "[email protected]"
},
"010001450": {
"country": "México",
"phone": "61185225",
"area_code": "47",
"country_code": "+52",
"term": null,
"email": "[email protected]"
},
"010001420": {
"country": "México",
"phone": "21349748",
"area_code": "46",
"country_code": "+52",
"term": null,
"email": "[email protected]"
}
}
},
"inconcert_channels": {
"endpoint": "GET /api/v1/inconcert/channel-groups/",
"total_registers": 83,
"files": "channels.json",
"fields": [
"id",
"channel",
"channel_id",
"groups",
"is_active",
"created_at",
"created_by"
],
"sample": [
{
"id": 1,
"channel": "UTEL_ESPANA",
"channel_id": 54,
"groups": "UTEL ESPAÑA",
"is_active": true,
"created_at": "2026-06-03T19:09:45.651963",
"created_by": "c3p0"
},
{
"id": 2,
"channel": "UTEL_URUGUAY",
"channel_id": 87,
"groups": "UTEL URUGUAY",
"is_active": true,
"created_at": "2026-06-03T19:11:51.328038",
"created_by": "c3p0"
},
{
"id": 3,
"channel": "CALL_CENTER_DIRECTAS",
"channel_id": 4,
"groups": "Licenciaturas y Bachillerato, Maestrías y Doctorados",
"is_active": true,
"created_at": "2026-06-03T20:34:27.876125",
"created_by": "000064312"
}
]
},
"join": {
"key": "enrolled.student_id -> contacts[student_id]",
"result": "full_name + debt + balance + risk + email + phone per student"
}
}@DarkWhoam
![[Image: bQ2YD.gif]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fs15.gifyu.com%2Fimages%2FbQ2YD.gif)