Skip to main content

ā€‹
Overview

vLife DGO supports two distinct evaluation types with different document requirements and workflows:
  1. Permanencia (tipo_eval = 1) - For existing employees maintaining their position
  2. Nuevo Ingreso (tipo_eval = 2) - For new employees entering the organization

ā€‹
Evaluation Types Comparison

Permanencia

Existing employees maintaining their positions. Requires 5 mandatory documents and 6 data sections.

Nuevo Ingreso

New employees joining the organization. Requires 6 mandatory documents and 6 data sections.

ā€‹
Creating an Evaluation

ā€‹
Evaluation Creation Flow

1

Check for Existing Evaluation

System validates if employee already has an evaluation for the current year.
2

Create or Resume

Either creates new evaluation or resumes existing one.
3

Generate Encrypted ID

Creates unique encrypted identifier using ncrypt-js.
4

Redirect to Evaluation View

User is directed to their evaluation workspace.

ā€‹
Implementation

import ncrypt from "ncrypt-js";

const validityEvaluation = async (req, res) => {
  const { tipo_eval, empID } = req.body;
  const anioEval = new Date().getFullYear();

  try {
    // Check if evaluation exists for current year
    const [validate] = await PoolvLife.query(
      EvaluationvLifeModel.validityEvaluation,
      [empID, anioEval]
    );

    if (validate.length === 1) {
      // Resume existing evaluation
      req.flash("success", "Retomado evaluaciĆ³n ...");
      res.redirect(
        `/evaluacionvLife/evaluacionView/${validate[0].evalEncrypt}`
      );
    } else {
      // Create new evaluation
      const _superKey = "key_cecc";
      const ncryptObjet = new ncrypt(_superKey);
      
      const [rowsAffected] = await PoolvLife.query(
        EvaluationvLifeModel.createEvaluacion,
        [empID, anioEval, tipo_eval]
      );
      
      // Encrypt the evaluation ID
      const dataToEncrypt = rowsAffected.insertId;
      const encryptedData = ncryptObjet.encrypt(dataToEncrypt);
      
      await PoolvLife.query(EvaluationvLifeModel.encryptEvaluation, [
        encryptedData,
        dataToEncrypt,
      ]);

      req.flash("success", "EvaluaciĆ³n creada con exito");
      res.redirect(`/evaluacionvLife/evaluacionView/${encryptedData}`);
    }
  } catch (e) {
    console.log(e);
  }
};
Each employee can only have one evaluation per year. The system automatically checks and either resumes the existing evaluation or creates a new one.

ā€‹
Encrypted Evaluation IDs

ā€‹
Security Implementation

vLife DGO uses ncrypt-js to encrypt evaluation IDs for secure URL transmission. 
const evaluacionView = async (req, res) => {
  const { encryptedData } = req.params;
  
  try {
    const _superKey = "key_cecc";
    const ncryptObjet = new ncrypt(_superKey);
    
    // Decrypt the evaluation ID
    const decryptedData = ncryptObjet.decrypt(encryptedData);
    
    // Fetch evaluation data
    const [getCurrentEvaluation] = await PoolvLife.query(
      EvaluationvLifeModel.getEvaluationProcess,
      decryptedData
    );
    
    const tipo_eval = getCurrentEvaluation[0].tipoEvalID;
    // ... continue processing
  } catch (e) {
    console.log(e);
  }
};
The encryption key key_cecc should be moved to environment variables in production for enhanced security.

ā€‹
Permanencia Evaluation (tipo_eval = 1)

ā€‹
Required Documents

Permanencia evaluations require 5 mandatory documents:
DocumentDescriptionVariable
Acta de NacimientoBirth certificateGetActaPerma
INEOfficial identificationGetINEPerma
Comprobante de DomicilioProof of addressGetDomicilioPerma
Comprobante de EstudiosEducational documentsGetEstudiosPerma
Comprobante de IngresosIncome verificationGetIngresosPerma

ā€‹
Optional Documents

Additional optional documents for Permanencia:
  • State de cuenta bancaria (bank statements)
  • Cartilla militar (military service card)
  • Reporte de crĆ©dito (credit report)
  • Cuentas departamentales
  • Comprobante de pago de pareja
  • FotografĆ­a de fachada
  • Documentos de inmuebles
  • Licencia de portaciĆ³n de arma
  • Tarjeta de circulaciĆ³n
  • Procedimientos legales
  • Actividades informales

ā€‹
Completion Requirements

if (tipo_eval === 1) {
  if (TotalCaptura === 6 && TotalCargaPerma === 5) {
    const ListoRevision = true;
    // Evaluation ready for review
  }
}
For Permanencia, evaluation is complete when:
  • All 6 data sections are captured
  • All 5 mandatory documents are uploaded

ā€‹
Nuevo Ingreso Evaluation (tipo_eval = 2)

ā€‹
Required Documents

Nuevo Ingreso evaluations require 6 mandatory documents:
DocumentDescriptionVariable
Acta de NacimientoBirth certificateGetActaNI
INEOfficial identificationGetIneNI
Comprobante de DomicilioProof of addressGetDomicilioNI
Comprobante de EstudiosEducational documentsGetEstudiosNI
Cartilla MilitarMilitary service cardGetCatrillaNI
Motivo de IngresoReason for joiningGetDataMotivo
Nuevo Ingreso requires ā€œMotivo de Ingresoā€ (reason for joining), which is captured as text rather than an uploaded file.

ā€‹
Optional Documents

Similar to Permanencia, with some specific additions:
  • Comprobante de ingresos opcionales
  • Estado de cuentas opcionales
  • Credito documents
  • Additional economic documentation

ā€‹
Completion Requirements

if (tipo_eval === 2) {
  if (TotalCaptura === 6 && TotalCargaNI === 6) {
    const ListoRevision = true;
    // Evaluation ready for review
  }
}
For Nuevo Ingreso, evaluation is complete when:
  • All 6 data sections are captured
  • All 6 mandatory documents are uploaded/provided

ā€‹
Progress Tracking

ā€‹
Capture Progress Calculation

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);
This calculation provides a percentage of completion for the six required data sections.

ā€‹
Document Upload Tracking

For Permanencia: 
const ActaPerma = GetActaPerma.length;
const InePerma = GetINEPerma.length;
const DomicilioPerma = GetDomicilioPerma.length;
const EstudiosPerma = GetEstudiosPerma.length;
const IngresosPerma = GetIngresosPerma.length;

const TotalCargaPerma = ActaPerma + InePerma + DomicilioPerma + 
                         EstudiosPerma + IngresosPerma;
For Nuevo Ingreso: 
const ActaNew = GetActaNI.length;
const IneNew = GetIneNI.length;
const DomicilioNI = GetDomicilioNI.length;
const EstudiosNi = GetEstudiosNI.length;
const IngresosNi = GetIngresosOpc.length;
const MotivoIngreso = GetDataMotivo.length;
const CreditoNi = GetCreditoPerma.length;

const TotalCargaNI = ActaNew + IneNew + DomicilioNI + EstudiosNi + 
                      IngresosNi + MotivoIngreso + CreditoNi;

ā€‹
Evaluation View Rendering

The system renders different data based on evaluation type: 
const tipo_eval = getCurrentEvaluation[0].tipoEvalID;

if (tipo_eval === 1) {
  // Render Permanencia view
  res.render("evaluationvLifeViews/evaluationView", {
    user: req.session.name,
    dataEvaluation: getCurrentEvaluation[0],
    Permanencia: true,
    // ... Permanencia-specific data
  });
} else if (tipo_eval === 2) {
  // Render Nuevo Ingreso view
  res.render("evaluationvLifeViews/evaluationView", {
    user: req.session.name,
    dataEvaluation: getCurrentEvaluation[0],
    NI: true,
    // ... Nuevo Ingreso-specific data
  });
}

ā€‹
Deleting Section Data

vLife DGO allows employees to delete and re-enter section data: 
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");
  }
};
Available delete functions:
  • DeletePersonales - Personal data
  • DeleteFamiliares - Family data
  • DeleteAcademicos - Academic records (includes capacitaciones)
  • DeleteTrayectoria - Career trajectory (includes related tables)
  • DeleteEconomicos - Economic data (includes all sub-tables)
  • DeleteReferencias - References
Deleting section data also removes all related sub-table entries. For example, deleting economic data removes all bank accounts, credits, properties, and vehicles.

ā€‹
Finalizing Evaluations

Once all requirements are met, employees can finalize their evaluation: 
const FinalizarEvaluacion = async (req, res) => {
  const { encryptedData } = req.body;
  try {
    const _superKey = "key_cecc";
    const ncryptObjet = new ncrypt(_superKey);
    const evalID = ncryptObjet.decrypt(encryptedData);
    const finalizadoFecha = Helpers.GetDate();
    
    const dataPacket = {
      evalID,
      finalizadoFecha,
    };
    
    await PoolvLife.query(EvaluationvLifeModel.SaveFinalizado, dataPacket);
    req.flash("success", "EvaluaciĆ³n Finalizada");
    res.redirect(`/auth/profile`);
  } catch (e) {
    req.flash("message", "Algo salio mal !");
    res.redirect("back");
  }
};

ā€‹
Gender-Specific Handling

The system handles gender-specific requirements: 
const [GetSexoEmpleado] = await PoolvLife.query(
  EvaluationvLifeModel.getSexoEmpleado,
  decryptedData
);

const Genero = GetSexoEmpleado[0].empSexo === "MUJER" ? true : false;
This flag adjusts requirements for military service card (Cartilla), which is typically required only for male employees.
  • EvaluationvLifeController.js (src/controllers/EvaluationvLifeController.js:1) - Evaluation management
  • EvaluationvLifeModel.js - Database queries for evaluations
  • AuthController.js (src/controllers/AuthController.js:108) - User registration with evaluation type

ā€‹
Next Steps

Data Capture

Learn about the six data capture sections

Document Upload

Understand the document upload process

Build docs developers (and LLMs) love

Get started for freeTalk to us