Data Capture - vLife DGO

Overview

vLife DGO requires employees to complete six comprehensive data sections as part of their background evaluation. Progress is tracked across all sections, with the ability to update or delete section data as needed.

Six Data Sections

Personal

Basic personal information, contact details, and address

Family

Family members, relationships, and dependents

Academic

Educational background and training certificates

Career

Employment history and professional trajectory

Economic

Financial information, assets, and liabilities

References

Personal and professional references

Progress Tracking

Completion Calculation

The system tracks completion of all six sections:

const Personales = datosPersonales.length;
const Familiares = datosFamiliares.length;
const Academicos = datosAcademicos.length;
const Laborales = trayectoria.length;
const Economicos = datosEconomicos.length;
const Referencias = datosReferencias.length;

const TotalCaptura = Personales + Familiares + Academicos + 
                     Laborales + Economicos + Referencias;

const ProcessCapture = TotalCaptura * 100 / 6;
const ProcessCaptureFormat = ProcessCapture.toFixed(2);

Progress is calculated as a percentage, with each completed section contributing 16.67% to the total.

Section 1: Personal Data

Overview

Captures comprehensive personal information, contact details, and residential data.

Data Fields

Basic Information:

Full name (personalesNombre)
Date of birth (personalesFechaNac)
Place of birth (personalesLugarNac)
Nationality (personalesNacionalidad)
Gender (personalesSexo)
Marital status (personalesEdoCivil)
Age (personalesEdad)
Education level (personalesEscolaridad)

Identification:

RFC (personalesRFC)
CURP (personalesCURP)

Contact Information:

Home phone (personalesTelFijo)
Cell phone (personalesTelCelular)
Office phone (personalesTelOficina)
Extension (personalesExt)
Emergency contact phone (personalesTelRecados)
Emergency contact person (personalesPersonaRecados)
Email (personalesEmail)

Address Information:

Street and number (personalesCalleNum)
Colony/neighborhood (personalesColonia)
Postal code (personalesCP)
City/locality (personalesLocalidad)
State (personalesEstado)
Years at residence (personalesAnioDom)
Number of residents (personalesPersonasHab)
Cross streets (personalesEntreCalles)
Property façade description (personalesFachada)
Google Maps link (personalesGoogle)
Additional observations (personalesObservaciones)

Implementation

const savePersonalesPermanencia = async (req, res) => {
  const {
    evalID,
    personalesNombre,
    personalesFechaNac,
    personalesLugarNac,
    // ... all personal fields
  } = req.body;
  
  const dataPacket = {
    evalID,
    personalesNombre,
    personalesFechaNac,
    // ... all fields
  };
  
  try {
    await PoolvLife.query(
      CaptureDataModel.saveDatosPersonalesPerma,
      dataPacket
    );
    req.flash("success", "Datos personales guardados, captura redes sociales");
    res.redirect("back");
  } catch (e) {
    console.log(e);
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

After saving personal data, employees can add social media accounts:

const SaveRedSocial = async (req, res) => {
  const { evalID, redesTipoRed, redesUsuario } = req.body;
  const dataPacket = {
    evalID,
    redesTipoRed,
    redesUsuario
  };
  try {
    await PoolvLife.query(CaptureDataModel.SaveRedSocial, dataPacket);
    req.flash("success", "Red social guardada");
    res.redirect("back");
  } catch (e) {
    console.log(e);
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

Multiple social media accounts can be added. Each is stored separately and can be deleted individually.

Section 2: Family Data

Overview

Captures information about family members and dependents.

Data Fields

For each family member:

First name (familiarNombres)
Last name (familiarApellidos)
Relationship (familiarParentesco)
Occupation (familiarOcupacion)
Age (familiarEdad)
Living status (familiarVive)
Phone number (familiarTelefono)
Dependent status (familiarDependiente)

Implementation

const saveFamiliares = async (req, res) => {
  const {
    evalID,
    familiarNombres,
    familiarApellidos,
    familiarParentesco,
    familiarOcupacion,
    familiarEdad,
    familiarVive,
    familiarTelefono,
    familiarDependiente,
  } = req.body;
  
  // Concatenate full name
  const familiarNombre = `${familiarApellidos} ${familiarNombres}`;

  const dataPacket = {
    evalID,
    familiarNombre,
    familiarParentesco,
    familiarOcupacion,
    familiarEdad,
    familiarVive,
    familiarTelefono,
    familiarDependiente,
  };
  
  try {
    await PoolvLife.query(CaptureFamiliaresModel.saveFamiliar, dataPacket);
    req.flash("success", "Se guardo familiar !");
    res.redirect("back");
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

Multiple family members can be added. Each entry can be edited or deleted independently.

Section 3: Academic Data

Overview

Captures educational background and professional training.

Components

Highest Academic Degree (single record)
Training Certificates (multiple records)

Academic Degree Fields

Degree level (academicoUltimoGrado)
Start period (academicoPeriodoInicio)
End period (academicoPeriodoFinal)
Institution (academicoInstitucion)
Document type (academicoDocumento)
Location (academicoUbicacion)

Training Certificate Fields

Training details (capacitacionDetalle)
Start date (capacitacionInicio)
End date (capacitacionFinal)
Institution (capacitacionInstitucion)
Document type (capacitacionDocumento)

Implementation

const SaveAcademicosPermanencia = async (req, res) => {
  const {
    evalID,
    academicoUltimoGrado,
    academicoPeriodoInicio,
    academicoPeriodoFinal,
    academicoInstitucion,
    academicoDocumento,
    academicoUbicacion,
  } = req.body;
  
  const dataPacket = {
    evalID,
    academicoUltimoGrado,
    academicoPeriodoInicio,
    academicoPeriodoFinal,
    academicoInstitucion,
    academicoDocumento,
    academicoUbicacion,
  };
  
  try {
    await PoolvLife.query(
      CaptureAcademicosModel.SaveGradoAcademico,
      dataPacket
    );
    req.flash("success", "Último grado académico guardado");
    res.redirect(`back`);
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

Section 4: Career Trajectory

Career data varies by evaluation type:

Permanencia: Current position and career history within the organization
Nuevo Ingreso: Previous employment history outside the organization

Permanencia
Nuevo Ingreso

For existing employees:

Current assignments
Departmental transfers
Position history
Family in law enforcement
Corporate family connections

Section 5: Economic Data

Overview

Comprehensive financial information including income, expenses, assets, and liabilities.

Income Information

Monthly income (economicosMensual)
Additional income (economicosAdicional)
Income source description (economicosConsiste)
Total income (economicosTotalIngreso)

Expenses

Food (economicosAlimentos)
Transportation (economicosTransporte)
Utilities (economicosServicios)
Communications (economicosComunicaciones)
Credit cards (economicosTarjetas)
Loans (economicosCreditos)
Clothing (economicosVestido)
Medical (economicosMedico)
Savings groups (economicosTandas)
Savings (economicosAhorros)
School expenses (economicosEscolares)
Rent (economicosRenta)
Alimony (economicosPension)
Other expenses (economicosFaltante)
Total expenses (economicosTotalEgresos)

Financial Details

Property type (economicosTipo)
Tax regime (economicosRegimen)
Financial issues (economicosProblematica)

Sub-tables

Economic data includes multiple related tables:

Bank Accounts - Type, institution, opening date, amounts
Credits/Loans - Type, institution, debt, monthly payment
Real Estate - Type, date, purchase method, value
Personal Property - Vehicles and other valuable items
Extra Income - Additional income sources

Implementation

const SaveEconomicos = async (req, res) => {
  try {
    const {
      evalID,
      economicosMensual,
      economicosAdicional,
      economicosConsiste,
      economicosTotalIngreso,
      economicosAlimentos,
      economicosTransporte,
      // ... all expense fields
      economicosTotalEgresos,
      economicosTipo,
      economicosRegimen,
      economicosProblematica,
    } = req.body;
    
    const dataPacket = {
      evalID,
      economicosMensual,
      economicosAdicional,
      // ... all fields
    };
    
    await PoolvLife.query(CaptureEconomicosModel.SaveEconomicos, [dataPacket]);
    req.flash("success", "Se guardaron economicos correctamente !");
    res.redirect("back");
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

Economic data is the most complex section, with five related sub-tables. Deleting economic data removes all related entries.

Section 6: References

Overview

Captures both personal and professional references.

Reference Types

Professional References (3 required)
- Name (referenciasNombre1-3)
- Position (referenciasPuesto1-3)
- Company (referenciasEmpresa1-3)
- Phone (referenciasTelefono1-3)
Personal References (3 required)
- Name (referenciasNombreP1-3)
- Home phone (referenciasFijoP1-3)
- Cell phone (referenciasCelularP1-3)

Implementation

const SaveReferencias = async (req, res) => {
  const {
    evalID,
    referenciasNombre1,
    referenciasPuesto1,
    referenciasEmpresa1,
    referenciasTelefono1,
    referenciasNombre2,
    referenciasPuesto2,
    referenciasEmpresa2,
    referenciasTelefono2,
    referenciasNombre3,
    referenciasPuesto3,
    referenciasEmpresa3,
    referenciasTelefono3,
    referenciasNombreP1,
    referenciasFijoP1,
    referenciasCelularP1,
    referenciasNombreP2,
    referenciasFijoP2,
    referenciasCelularP2,
    referenciasNombreP3,
    referenciasFijoP3,
    referenciasCelularP3,
    encryptedData,
  } = req.body;
  
  const daPacket = {
    evalID,
    referenciasNombre1,
    referenciasPuesto1,
    // ... all reference fields
  };
  
  try {
    await PoolvLife.query(CaptureReferenciasModel.SaveReferencias, [daPacket]);
    req.flash("success", "Referencias guardadas con exito !");
    res.redirect(`/evaluacionvLife/evaluacionView/${encryptedData}`);
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

All six references (3 professional + 3 personal) are saved as a single record. The entire set can be updated or deleted together.

Data Validation and Storage

Validation

The system performs validation at multiple levels:

Frontend validation - Form field requirements
Backend validation - Data type and format checks
Database constraints - Foreign key relationships

Encrypted Data Handling

All data capture forms receive encrypted evaluation IDs:

const generalesCapturePermanencia = async (req, res) => {
  const { encryptedData } = req.params;
  
  try {
    const ncryptObjet = new ncrypt(keyDecrypt.key);
    const decryptedData = ncryptObjet.decrypt(encryptedData);
    
    // Fetch existing data
    const [getDatosPersonalesPerma] = await PoolvLife.query(
      CaptureDataModel.getDatosPersonalesPerma,
      decryptedData
    );
    
    res.render("captureData/personalesCapturePermanencia", {
      user: req.session.name,
      decryptedData,
      encryptedData,
      dataPerma: getDatosPersonalesPerma[0],
    });
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

Deleting Section Data

Employees can delete and re-enter any section:

const DeletePersonales = async (req, res) => {
  const { evalID } = req.body;
  try {
    await PoolvLife.query(EvaluationvLifeModel.DeletePersonales, evalID);
    req.flash("success", "Datos personales eliminados");
    res.redirect("back");
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

Cascade Deletion

Some sections delete related data:

Academics: Deletes academic degree AND all training certificates
Career: Deletes trajectory AND family in process, corporate family, and employment history
Economic: Deletes economic data AND all bank accounts, credits, properties, and vehicles

Deleting a section removes all related sub-table entries. This action cannot be undone.

CapturePersonalesController.js (src/controllers/CapturePersonalesController.js:1) - Personal data
CaptureFamiliaresController.js (src/controllers/CaptureFamiliaresController.js:1) - Family data
CaptureAcademicosController.js (src/controllers/CaptureAcademicosController.js:1) - Academic data
CaptureTrayectoriaController.js - Career trajectory
CaptureEconomicosController.js (src/controllers/CaptureEconomicosController.js:1) - Economic data
CaptureReferenciasController.js (src/controllers/CaptureReferenciasController.js:1) - References

Get Started

Core Features

User Guides

System Configuration

​Overview

​Six Data Sections

Personal

Family

Academic

Career

Economic

References

​Progress Tracking

​Completion Calculation

​Section 1: Personal Data

​Overview

​Data Fields

​Implementation

​Social Media Accounts

​Section 2: Family Data

​Overview

​Data Fields

​Implementation

​Section 3: Academic Data

​Overview

​Components

​Academic Degree Fields

​Training Certificate Fields

​Implementation

​Section 4: Career Trajectory

​Section 5: Economic Data

​Overview

​Income Information

​Expenses

​Financial Details

​Sub-tables

​Implementation

​Section 6: References

​Overview

​Reference Types

​Implementation

​Data Validation and Storage

​Validation

​Encrypted Data Handling

​Deleting Section Data

​Cascade Deletion

​Related Controllers

​Next Steps

Document Upload

Expediente Generation

Build docs developers (and LLMs) love

Overview

Six Data Sections

Progress Tracking

Completion Calculation

Section 1: Personal Data

Overview

Data Fields

Implementation

Social Media Accounts

Section 2: Family Data

Overview

Data Fields

Implementation

Section 3: Academic Data

Overview

Components

Academic Degree Fields

Training Certificate Fields

Implementation

Section 4: Career Trajectory

Section 5: Economic Data

Overview

Income Information

Expenses

Financial Details

Sub-tables

Implementation

Section 6: References

Overview

Reference Types

Implementation

Data Validation and Storage

Validation

Encrypted Data Handling

Deleting Section Data

Cascade Deletion

Related Controllers

Next Steps