The connection to the database server (postgreSql 15) is carried out using the following code format
# Dependences and libraries:
install.packages("RPostgres")
install.packages("DBI")
install.packages("sf")
library(DBI)
library(RPostgres)
library(sf)
dvr <- RPostgres::Postgres()
db <- 'meat_bus_I' ##Nombre de la BBDD
host_db <- 'localhost'
db_port <- '5432'
db_user <- 'postgres' ##Your User
db_password <- 'postgres' ##your password
# 3.0 Conexión
con <- dbConnect(dvr, dbname = db, host=host_db, port=db_port,
user=db_user, password=db_password) The meat company Candidez Carnica SL, which has a factory where it manufactures packs of cooked ham for a well-known distribution chain, has asked us for a database to manage its packs for a well-known distribution chain, asked us for a database to manage the hourly records of its factory workers and the the time records of its factory workers and the units manufactured of its assorted products to know the productivity of the company’s shifts.
Let’s start by creating a database for the client, specifically for each of its components
Note that in Postgres, databases are created from the GUI. This would be the code we would use in another database management system.
CREATE DATABASE meat_bus_I
ENCODING 'UTF8'
LC_COLLATE = 'es_ES.UTF-8'
LC_CTYPE = 'es_ES.UTF-8'
TEMPLATE = template0;
-- DROP SCHEMA IF EXISTS erp;
-- CREATE SCHEMA erp;
Verifying the creation of the scheme:
SELECT schema_name
FROM information_schema.schemata
WHERE schema_name = 'erp';| schema_name |
|---|
| erp |
/* CREATE TABLE erp.tb_category (
category_id INT NOT NULL,
category_name CHARACTER(30) NOT NULL,
category_extra_price INT NOT NULL,
CONSTRAINT pk_category PRIMARY KEY (category_id),
CONSTRAINT u_category_name UNIQUE (category_name)
);*/
/* CREATE TABLE erp.tb_employee (
employee_id INT NOT NULL,
employee_name CHARACTER(20) NOT NULL,
employee_surname CHARACTER VARYING(50) NOT NULL,
category_id INT NOT NULL,
employee_hiredate DATE NOT NULL,
employee_birthdate DATE NOT NULL,
employee_gender CHARACTER(10) NOT NULL DEFAULT 'Hombre',
employee_boss INT,
employee_shift CHARACTER(1),
CONSTRAINT pk_employee PRIMARY KEY (employee_id),
CONSTRAINT fk_employee FOREIGN KEY (employee_boss) REFERENCES erp.tb_employee (employee_id),
CONSTRAINT fk_category FOREIGN KEY (category_id) REFERENCES erp.tb_category (category_id)
); */
/* CREATE TABLE erp.tb_terminals (
terminal_id CHARACTER(3) NOT NULL,
terminal_name CHARACTER VARYING(20) NOT NULL,
CONSTRAINT pk_terminals PRIMARY KEY (terminal_id)
); */
/* CREATE TABLE erp.tb_sign_employees (
sign_id INT NOT NULL,
employee_id INT NOT NULL,
sign_term_in CHARACTER(3) NOT NULL,
sign_data_in TIMESTAMP NOT NULL,
sign_term_out CHARACTER(3) NOT NULL,
sign_data_out TIMESTAMP NOT NULL,
sign_time_minutes INT NOT NULL,
CONSTRAINT pk_sign_employees PRIMARY KEY (sign_id),
CONSTRAINT fk_employees FOREIGN KEY (employee_id) REFERENCES erp.tb_employee (employee_id),
CONSTRAINT fk_terminals_in FOREIGN KEY (sign_term_in) REFERENCES erp.tb_terminals (terminal_id),
CONSTRAINT fk_terminals_out FOREIGN KEY (sign_term_out) REFERENCES erp.tb_terminals (terminal_id)
);*/ /* CREATE TABLE erp.tb_products (
products_id CHARACTER(5) NOT NULL,
products_name CHARACTER VARYING(50) NOT NULL,
products_size INT NOT NULL,
products_cost NUMERIC(12,2),
CONSTRAINT pk_products PRIMARY KEY (products_id)
); *//*CREATE TABLE erp.tb_production_cab (
production_cab_id INT NOT NULL,
production_date date NOT NULL,
production_shift CHARACTER(1) NOT NULL,
CONSTRAINT pk_production_cab PRIMARY KEY (production_cab_id)
);*/ /*CREATE TABLE erp.tb_production_lin (
production_lin_id INT NOT NULL,
production_cab_id INT NOT NULL,
products_id CHARACTER(5) NOT NULL,
production_lin_quantity INT NOT NULL,
CONSTRAINT pk_production_lin PRIMARY KEY (production_lin_id),
CONSTRAINT fk_production_cab FOREIGN KEY (production_cab_id) REFERENCES erp.tb_production_cab (production_cab_id),
CONSTRAINT fk_products FOREIGN KEY (products_id) REFERENCES erp.tb_products (products_id)
); */SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'erp';| table_name |
|---|
| tb_sign_employees |
| tb_production_cab |
| tb_production_lin |
| tb_products |
| employee_not_shift |
| tb_employee |
| tb_terminals |
| tb_category |
We enter the data we have collected from the client, but we do it
directly from the database manager pgadmin, since from R we
will have difficulties to enter multiple lines.
SET datestyle = YMD; -- Year-month-day date format;
SET search_path TO erp; -- We indicate the path;
------------------------------------------------------------------------------------------------
--
-- Data tb_category;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (1,'Director Producción',60);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (2,'Resp. Mantenimiento',50);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (3,'Resp. Producción',50);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (4,'Resp. Turno Mantenimiento',40);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (5,'Resp. Turno Producción',40);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (6,'Operario Mantenimiento',30);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (7,'Operario Producción',30);
INSERT INTO erp.tb_category (category_id,category_name,category_extra_price) VALUES (8,'Técnico Laboratorio',40);
------------------------------------------------------------------------------------------------
--
-- Data tb_employee;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (1,'CARLOS','CABRERA',1,to_date('29/01/2000','DD-MM-YYYY'),to_date('02/08/1967','DD/MM/YYYY'),'Hombre',null,null);
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (2,'ENRIQUE','FERRER',2,to_date('28/03/2002','DD-MM-YYYY'),to_date('24/12/1973','DD/MM/YYYY'),'Hombre',1,null);
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (3,'FERNANDO','NIETO',3,to_date('11/11/1996','DD-MM-YYYY'),to_date('18/04/1951','DD/MM/YYYY'),'Hombre',1,null);
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (4,'ANDRES','CARMONA',4,to_date('24/09/2017','DD-MM-YYYY'),to_date('25/01/1990','DD/MM/YYYY'),'Hombre',2,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (5,'JUAN MANUEL','VICENTE',4,to_date('25/05/2015','DD-MM-YYYY'),to_date('16/05/1987','DD/MM/YYYY'),'Hombre',2,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (6,'JAVIER','FLORES',5,to_date('01/06/2022','DD-MM-YYYY'),to_date('29/08/2000','DD/MM/YYYY'),'Hombre',3,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (7,'DIEGO','HIDALGO',5,to_date('27/05/2008','DD-MM-YYYY'),to_date('18/05/1976','DD/MM/YYYY'),'Hombre',3,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (8,'JOSEFA','SAEZ',6,to_date('01/10/2022','DD-MM-YYYY'),to_date('12/05/2003','DD/MM/YYYY'),'Mujer',4,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (9,'SARA','GOMEZ',6,to_date('13/02/2021','DD-MM-YYYY'),to_date('17/06/2000','DD/MM/YYYY'),'Mujer',5,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (10,'ANTONIA','SANCHEZ',6,to_date('03/02/2021','DD-MM-YYYY'),to_date('17/06/2003','DD/MM/YYYY'),'Mujer',4,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (11,'SERGIO','AGUILAR',6,to_date('24/01/2020','DD-MM-YYYY'),to_date('05/10/2002','DD/MM/YYYY'),'Hombre',5,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (12,'JORGE','SANTANA',7,to_date('24/07/2020','DD-MM-YYYY'),to_date('31/08/1995','DD/MM/YYYY'),'Hombre',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (13,'PABLO','FUENTES',7,to_date('09/10/2019','DD-MM-YYYY'),to_date('07/10/1993','DD/MM/YYYY'),'Hombre',9,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (14,'RAMON','MORA',7,to_date('14/11/2019','DD-MM-YYYY'),to_date('30/08/1999','DD/MM/YYYY'),'Hombre',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (15,'ADRIAN','MONTERO',7,to_date('23/11/2022','DD-MM-YYYY'),to_date('06/07/1993','DD/MM/YYYY'),'Hombre',9,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (16,'MARIA CARMEN','SOTO',7,to_date('04/12/2019','DD-MM-YYYY'),to_date('05/04/2002','DD/MM/YYYY'),'Mujer',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (17,'DAVID','CRUZ',7,to_date('30/08/2018','DD-MM-YYYY'),to_date('28/02/2002','DD/MM/YYYY'),'Hombre',9,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (18,'RAFAEL','REYES',7,to_date('13/09/2018','DD-MM-YYYY'),to_date('06/10/1999','DD/MM/YYYY'),'Hombre',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (19,'MARIA JOSE','LOPEZ',7,to_date('24/08/2017','DD-MM-YYYY'),to_date('13/05/1998','DD/MM/YYYY'),'Mujer',9,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (20,'ALVARO','VARGAS',7,to_date('24/06/2017','DD-MM-YYYY'),to_date('02/03/1993','DD/MM/YYYY'),'Hombre',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (21,'MARIA PILAR','VELASCO',7,to_date('24/05/2017','DD-MM-YYYY'),to_date('22/01/2002','DD/MM/YYYY'),'Mujer',9,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (22,'ISABEL','MOYA',7,to_date('25/07/2016','DD-MM-YYYY'),to_date('25/07/1999','DD/MM/YYYY'),'Mujer',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (23,'LAURA','PARRA',7,to_date('25/06/2016','DD-MM-YYYY'),to_date('26/01/1985','DD/MM/YYYY'),'Mujer',9,'T');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (24,'JOSE MANUEL','CAMPOS',7,to_date('25/03/2015','DD-MM-YYYY'),to_date('22/12/1983','DD/MM/YYYY'),'Hombre',7,'M');
INSERT INTO erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (25,'RAUL','SANTIAGO',8,to_date('24/08/2020','DD-MM-YYYY'),to_date('13/11/1990','DD/MM/YYYY'),'Hombre',9,null);
------------------------------------------------------------------------------------------------
--
-- Data tb_terminals;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_terminals(terminal_id,terminal_name) VALUES ('EP','Entrada Principal');
INSERT INTO erp.tb_terminals(terminal_id,terminal_name) VALUES ('EV','Entrada Vestidores');
INSERT INTO erp.tb_terminals(terminal_id,terminal_name) VALUES ('EF1','Entrada Fàbrica 1');
INSERT INTO erp.tb_terminals(terminal_id,terminal_name) VALUES ('EF2','Entrada Fàbrica 2');
------------------------------------------------------------------------------------------------
--
-- Data tb_sign_employees;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (1,1,'EP',TO_TIMESTAMP('27/02/2023 09:19:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 18:32:00','DD/MM/YYYY hh24:mi:ss'),553);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (2,2,'EP',TO_TIMESTAMP('27/02/2023 09:09:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 18:32:00','DD/MM/YYYY hh24:mi:ss'),563);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (3,3,'EP',TO_TIMESTAMP('27/02/2023 08:45:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 17:15:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (4,4,'EP',TO_TIMESTAMP('27/02/2023 05:53:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (5,5,'EV',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('27/02/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (6,6,'EF1',TO_TIMESTAMP('27/02/2023 07:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 15:30:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (7,7,'EF1',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (8,8,'EF2',TO_TIMESTAMP('27/02/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),479);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (9,9,'EP',TO_TIMESTAMP('27/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),479);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (10,10,'EV',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('27/02/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (11,11,'EF1',TO_TIMESTAMP('27/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),479);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (12,12,'EF1',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (13,13,'EF2',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (14,14,'EP',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (15,15,'EV',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (16,16,'EF1',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (17,17,'EF1',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (18,18,'EF2',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('27/02/2023 13:00:00','DD/MM/YYYY hh24:mi:ss'),420);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (19,19,'EP',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (20,20,'EV',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (21,21,'EF1',TO_TIMESTAMP('27/02/2023 13:30:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (22,22,'EF1',TO_TIMESTAMP('27/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (23,23,'EF2',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('27/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (24,24,'EP',TO_TIMESTAMP('27/02/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),479);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (25,25,'EP',TO_TIMESTAMP('27/02/2023 08:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('27/02/2023 16:02:00','DD/MM/YYYY hh24:mi:ss'),482);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (26,1,'EP',TO_TIMESTAMP('28/02/2023 09:45:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 18:04:00','DD/MM/YYYY hh24:mi:ss'),499);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (27,2,'EP',TO_TIMESTAMP('28/02/2023 08:19:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),521);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (28,3,'EP',TO_TIMESTAMP('28/02/2023 08:39:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),501);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (29,4,'EP',TO_TIMESTAMP('28/02/2023 05:55:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),486);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (30,5,'EV',TO_TIMESTAMP('28/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('28/02/2023 22:02:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (31,6,'EF1',TO_TIMESTAMP('28/02/2023 07:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 15:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (32,7,'EF1',TO_TIMESTAMP('28/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),479);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (33,8,'EF2',TO_TIMESTAMP('28/02/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),477);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (34,9,'EP',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (35,10,'EV',TO_TIMESTAMP('28/02/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (36,11,'EF1',TO_TIMESTAMP('28/02/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),491);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (37,12,'EF1',TO_TIMESTAMP('28/02/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),491);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (38,13,'EF2',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('28/02/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (39,14,'EP',TO_TIMESTAMP('28/02/2023 05:59:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),501);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (40,15,'EV',TO_TIMESTAMP('28/02/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('28/02/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),491);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (41,16,'EF1',TO_TIMESTAMP('28/02/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 12:00:00','DD/MM/YYYY hh24:mi:ss'),370);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (42,17,'EF1',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (43,18,'EF2',TO_TIMESTAMP('28/02/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('28/02/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),499);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (44,19,'EP',TO_TIMESTAMP('28/02/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (45,20,'EV',TO_TIMESTAMP('28/02/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (46,21,'EF1',TO_TIMESTAMP('28/02/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (47,22,'EF1',TO_TIMESTAMP('28/02/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('28/02/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (48,23,'EF2',TO_TIMESTAMP('28/02/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('28/02/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (49,24,'EP',TO_TIMESTAMP('28/02/2023 05:58:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),512);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (50,25,'EP',TO_TIMESTAMP('28/02/2023 08:03:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('28/02/2023 16:05:00','DD/MM/YYYY hh24:mi:ss'),482);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (51,1,'EP',TO_TIMESTAMP('01/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (52,2,'EP',TO_TIMESTAMP('01/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (53,3,'EP',TO_TIMESTAMP('01/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (54,4,'EP',TO_TIMESTAMP('01/03/2023 05:40:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),502);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (55,5,'EV',TO_TIMESTAMP('01/03/2023 14:04:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('01/03/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),477);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (56,6,'EF1',TO_TIMESTAMP('01/03/2023 07:03:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 15:50:00','DD/MM/YYYY hh24:mi:ss'),527);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (57,7,'EF1',TO_TIMESTAMP('01/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 21:01:00','DD/MM/YYYY hh24:mi:ss'),419);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (58,8,'EF2',TO_TIMESTAMP('01/03/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('01/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),495);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (59,9,'EP',TO_TIMESTAMP('01/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (60,10,'EV',TO_TIMESTAMP('01/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('01/03/2023 13:00:00','DD/MM/YYYY hh24:mi:ss'),417);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (61,11,'EF1',TO_TIMESTAMP('01/03/2023 13:55:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (62,12,'EF1',TO_TIMESTAMP('01/03/2023 05:55:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (63,13,'EF2',TO_TIMESTAMP('01/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('01/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (64,14,'EP',TO_TIMESTAMP('01/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (65,15,'EV',TO_TIMESTAMP('01/03/2023 13:55:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('01/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),488);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (66,16,'EF1',TO_TIMESTAMP('01/03/2023 05:56:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 15:00:00','DD/MM/YYYY hh24:mi:ss'),544);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (67,17,'EF1',TO_TIMESTAMP('01/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),476);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (68,18,'EF2',TO_TIMESTAMP('01/03/2023 05:45:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('01/03/2023 14:40:00','DD/MM/YYYY hh24:mi:ss'),535);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (69,19,'EP',TO_TIMESTAMP('01/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),484);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (70,20,'EV',TO_TIMESTAMP('01/03/2023 05:45:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('01/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),496);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (71,21,'EF1',TO_TIMESTAMP('01/03/2023 13:30:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),520);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (72,22,'EF1',TO_TIMESTAMP('01/03/2023 05:51:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('01/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),539);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (73,23,'EF2',TO_TIMESTAMP('01/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('01/03/2023 21:45:00','DD/MM/YYYY hh24:mi:ss'),465);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (74,24,'EP',TO_TIMESTAMP('01/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 14:40:00','DD/MM/YYYY hh24:mi:ss'),520);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (75,25,'EP',TO_TIMESTAMP('01/03/2023 08:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('01/03/2023 16:30:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (76,1,'EP',TO_TIMESTAMP('02/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (77,2,'EP',TO_TIMESTAMP('02/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (78,3,'EP',TO_TIMESTAMP('02/03/2023 09:05:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (79,4,'EP',TO_TIMESTAMP('02/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (80,5,'EV',TO_TIMESTAMP('02/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('02/03/2023 21:59:00','DD/MM/YYYY hh24:mi:ss'),474);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (81,6,'EF1',TO_TIMESTAMP('02/03/2023 07:01:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 15:30:00','DD/MM/YYYY hh24:mi:ss'),509);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (82,7,'EF1',TO_TIMESTAMP('02/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 21:30:00','DD/MM/YYYY hh24:mi:ss'),460);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (83,8,'EF2',TO_TIMESTAMP('02/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('02/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (84,9,'EP',TO_TIMESTAMP('02/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (85,10,'EV',TO_TIMESTAMP('02/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('02/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),520);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (86,11,'EF1',TO_TIMESTAMP('02/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (87,12,'EF1',TO_TIMESTAMP('02/03/2023 05:59:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),471);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (88,13,'EF2',TO_TIMESTAMP('02/03/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('02/03/2023 22:07:00','DD/MM/YYYY hh24:mi:ss'),507);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (89,14,'EP',TO_TIMESTAMP('02/03/2023 05:55:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (90,15,'EV',TO_TIMESTAMP('02/03/2023 13:10:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('02/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),535);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (91,16,'EF1',TO_TIMESTAMP('02/03/2023 05:59:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),531);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (92,17,'EF1',TO_TIMESTAMP('02/03/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),503);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (93,18,'EF2',TO_TIMESTAMP('02/03/2023 06:04:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('02/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),476);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (94,19,'EP',TO_TIMESTAMP('02/03/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (95,20,'EV',TO_TIMESTAMP('02/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('02/03/2023 14:08:00','DD/MM/YYYY hh24:mi:ss'),488);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (96,21,'EF1',TO_TIMESTAMP('02/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (97,22,'EF1',TO_TIMESTAMP('02/03/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('02/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),520);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (98,23,'EF2',TO_TIMESTAMP('02/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('02/03/2023 21:03:00','DD/MM/YYYY hh24:mi:ss'),418);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (99,24,'EP',TO_TIMESTAMP('02/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (100,25,'EP',TO_TIMESTAMP('02/03/2023 08:07:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('02/03/2023 16:05:00','DD/MM/YYYY hh24:mi:ss'),478);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (101,1,'EP',TO_TIMESTAMP('03/03/2023 09:03:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),477);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (102,2,'EP',TO_TIMESTAMP('03/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 17:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (103,3,'EP',TO_TIMESTAMP('03/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (104,4,'EP',TO_TIMESTAMP('03/03/2023 06:05:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),478);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (105,5,'EV',TO_TIMESTAMP('03/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('03/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (106,6,'EF1',TO_TIMESTAMP('03/03/2023 06:59:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 15:15:00','DD/MM/YYYY hh24:mi:ss'),496);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (107,7,'EF1',TO_TIMESTAMP('03/03/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (108,8,'EF2',TO_TIMESTAMP('03/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('03/03/2023 14:15:00','DD/MM/YYYY hh24:mi:ss'),495);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (109,9,'EP',TO_TIMESTAMP('03/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (110,10,'EV',TO_TIMESTAMP('03/03/2023 06:06:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('03/03/2023 15:00:00','DD/MM/YYYY hh24:mi:ss'),534);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (111,11,'EF1',TO_TIMESTAMP('03/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 22:12:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (112,12,'EF1',TO_TIMESTAMP('03/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (113,13,'EF2',TO_TIMESTAMP('03/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('03/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (114,14,'EP',TO_TIMESTAMP('03/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),482);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (115,15,'EV',TO_TIMESTAMP('03/03/2023 13:44:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('03/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),506);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (116,16,'EF1',TO_TIMESTAMP('03/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (117,17,'EF1',TO_TIMESTAMP('03/03/2023 13:30:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),515);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (118,18,'EF2',TO_TIMESTAMP('03/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('03/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (119,19,'EP',TO_TIMESTAMP('03/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),473);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (120,20,'EP',TO_TIMESTAMP('03/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (121,21,'EF2',TO_TIMESTAMP('03/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('03/03/2023 22:07:00','DD/MM/YYYY hh24:mi:ss'),457);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (122,22,'EP',TO_TIMESTAMP('03/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('03/03/2023 14:15:00','DD/MM/YYYY hh24:mi:ss'),494);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (123,23,'EV',TO_TIMESTAMP('03/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('03/03/2023 21:04:00','DD/MM/YYYY hh24:mi:ss'),421);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (124,24,'EF1',TO_TIMESTAMP('03/03/2023 06:07:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),473);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (125,25,'EF1',TO_TIMESTAMP('03/03/2023 08:10:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('03/03/2023 16:07:00','DD/MM/YYYY hh24:mi:ss'),477);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (126,1,'EP',TO_TIMESTAMP('06/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 18:40:00','DD/MM/YYYY hh24:mi:ss'),580);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (127,2,'EP',TO_TIMESTAMP('06/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 16:20:00','DD/MM/YYYY hh24:mi:ss'),440);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (128,3,'EP',TO_TIMESTAMP('06/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (129,4,'EF2',TO_TIMESTAMP('06/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('06/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),469);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (130,5,'EP',TO_TIMESTAMP('06/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (131,6,'EV',TO_TIMESTAMP('06/03/2023 06:50:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('06/03/2023 15:03:00','DD/MM/YYYY hh24:mi:ss'),493);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (132,7,'EF1',TO_TIMESTAMP('06/03/2023 13:45:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 22:20:00','DD/MM/YYYY hh24:mi:ss'),515);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (133,8,'EF1',TO_TIMESTAMP('06/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (134,9,'EF2',TO_TIMESTAMP('06/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('06/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (135,10,'EP',TO_TIMESTAMP('06/03/2023 05:59:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),484);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (136,11,'EV',TO_TIMESTAMP('06/03/2023 14:04:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('06/03/2023 21:20:00','DD/MM/YYYY hh24:mi:ss'),436);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (137,12,'EF1',TO_TIMESTAMP('06/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),489);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (138,13,'EF1',TO_TIMESTAMP('06/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 23:00:00','DD/MM/YYYY hh24:mi:ss'),540);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (139,14,'EF2',TO_TIMESTAMP('06/03/2023 06:06:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('06/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (140,15,'EP',TO_TIMESTAMP('06/03/2023 13:56:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),489);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (141,16,'EV',TO_TIMESTAMP('06/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('06/03/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (142,17,'EF1',TO_TIMESTAMP('06/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 21:45:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (143,18,'EF1',TO_TIMESTAMP('06/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),530);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (144,19,'EF2',TO_TIMESTAMP('06/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('06/03/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (145,20,'EP',TO_TIMESTAMP('08/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 14:09:00','DD/MM/YYYY hh24:mi:ss'),489);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (146,21,'EV',TO_TIMESTAMP('06/03/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('06/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),503);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (147,22,'EF1',TO_TIMESTAMP('06/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (148,23,'EF1',TO_TIMESTAMP('06/03/2023 14:07:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('06/03/2023 21:07:00','DD/MM/YYYY hh24:mi:ss'),420);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (149,24,'EP',TO_TIMESTAMP('06/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (150,25,'EP',TO_TIMESTAMP('06/03/2023 07:56:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('06/03/2023 16:40:00','DD/MM/YYYY hh24:mi:ss'),524);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (151,1,'EP',TO_TIMESTAMP('07/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (152,2,'EP',TO_TIMESTAMP('07/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 17:06:00','DD/MM/YYYY hh24:mi:ss'),486);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (153,3,'EP',TO_TIMESTAMP('07/03/2023 09:07:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),473);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (154,4,'EF2',TO_TIMESTAMP('07/03/2023 05:59:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('07/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (155,5,'EP',TO_TIMESTAMP('07/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (156,6,'EV',TO_TIMESTAMP('07/03/2023 06:58:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 15:40:00','DD/MM/YYYY hh24:mi:ss'),522);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (157,7,'EF1',TO_TIMESTAMP('07/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (158,8,'EF1',TO_TIMESTAMP('07/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 13:30:00','DD/MM/YYYY hh24:mi:ss'),440);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (159,9,'EF2',TO_TIMESTAMP('07/03/2023 14:07:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 21:50:00','DD/MM/YYYY hh24:mi:ss'),463);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (160,10,'EP',TO_TIMESTAMP('07/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),489);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (161,11,'EV',TO_TIMESTAMP('07/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),430);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (162,12,'EF1',TO_TIMESTAMP('07/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (163,13,'EF1',TO_TIMESTAMP('07/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 23:04:00','DD/MM/YYYY hh24:mi:ss'),544);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (164,14,'EF2',TO_TIMESTAMP('07/03/2023 06:07:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('07/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (165,15,'EP',TO_TIMESTAMP('07/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 22:01:00','DD/MM/YYYY hh24:mi:ss'),491);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (166,16,'EV',TO_TIMESTAMP('07/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),509);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (167,17,'EF1',TO_TIMESTAMP('07/03/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 21:03:00','DD/MM/YYYY hh24:mi:ss'),443);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (168,18,'EF1',TO_TIMESTAMP('07/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('07/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (169,19,'EP',TO_TIMESTAMP('07/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (170,20,'EP',TO_TIMESTAMP('07/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),527);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (171,21,'EP',TO_TIMESTAMP('07/03/2023 13:20:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('07/03/2023 22:08:00','DD/MM/YYYY hh24:mi:ss'),528);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (172,22,'EV',TO_TIMESTAMP('07/03/2023 06:02:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (173,23,'EV',TO_TIMESTAMP('07/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 22:15:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (174,24,'EV',TO_TIMESTAMP('07/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (175,25,'EV',TO_TIMESTAMP('07/03/2023 07:34:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('07/03/2023 16:10:00','DD/MM/YYYY hh24:mi:ss'),516);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (176,1,'EP',TO_TIMESTAMP('08/03/2023 09:05:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 17:12:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (177,2,'EP',TO_TIMESTAMP('08/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (178,3,'EP',TO_TIMESTAMP('08/03/2023 09:08:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 17:32:00','DD/MM/YYYY hh24:mi:ss'),504);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (179,4,'EV',TO_TIMESTAMP('08/03/2023 05:55:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),488);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (180,5,'EV',TO_TIMESTAMP('08/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 22:30:00','DD/MM/YYYY hh24:mi:ss'),507);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (181,6,'EV',TO_TIMESTAMP('08/03/2023 07:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 16:01:00','DD/MM/YYYY hh24:mi:ss'),541);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (182,7,'EV',TO_TIMESTAMP('08/03/2023 13:40:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (183,8,'EV',TO_TIMESTAMP('08/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (184,9,'EF2',TO_TIMESTAMP('08/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('08/03/2023 21:55:00','DD/MM/YYYY hh24:mi:ss'),465);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (185,10,'EP',TO_TIMESTAMP('08/03/2023 06:07:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),523);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (186,11,'EV',TO_TIMESTAMP('08/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 21:50:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (187,12,'EF1',TO_TIMESTAMP('08/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('08/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (188,13,'EF1',TO_TIMESTAMP('08/03/2023 13:01:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('08/03/2023 19:40:00','DD/MM/YYYY hh24:mi:ss'),399);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (189,14,'EF2',TO_TIMESTAMP('08/03/2023 06:09:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('08/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),476);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (190,15,'EP',TO_TIMESTAMP('08/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 22:05:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (191,16,'EV',TO_TIMESTAMP('08/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (192,17,'EF1',TO_TIMESTAMP('08/03/2023 13:44:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('08/03/2023 21:04:00','DD/MM/YYYY hh24:mi:ss'),440);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (193,18,'EF1',TO_TIMESTAMP('08/03/2023 06:20:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('08/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),461);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (194,19,'EF2',TO_TIMESTAMP('08/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('08/03/2023 22:04:00','DD/MM/YYYY hh24:mi:ss'),484);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (195,20,'EP',TO_TIMESTAMP('08/03/2023 06:04:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),486);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (196,21,'EV',TO_TIMESTAMP('08/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('08/03/2023 22:09:00','DD/MM/YYYY hh24:mi:ss'),489);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (197,22,'EF1',TO_TIMESTAMP('08/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('08/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),487);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (198,23,'EF1',TO_TIMESTAMP('08/03/2023 14:06:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('08/03/2023 22:07:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (199,24,'EP',TO_TIMESTAMP('08/03/2023 06:40:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),460);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (200,25,'EP',TO_TIMESTAMP('08/03/2023 07:45:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('08/03/2023 15:50:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (201,1,'EP',TO_TIMESTAMP('09/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (202,2,'EP',TO_TIMESTAMP('09/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 17:05:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (203,3,'EP',TO_TIMESTAMP('09/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (204,4,'EF2',TO_TIMESTAMP('09/03/2023 05:58:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('09/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),484);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (205,5,'EP',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),483);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (206,6,'EV',TO_TIMESTAMP('09/03/2023 07:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('09/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),450);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (207,7,'EF1',TO_TIMESTAMP('09/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('09/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (208,8,'EF1',TO_TIMESTAMP('09/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('09/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (209,9,'EP',TO_TIMESTAMP('09/03/2023 13:45:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),495);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (210,10,'EP',TO_TIMESTAMP('09/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (211,11,'EP',TO_TIMESTAMP('09/03/2023 14:50:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 21:50:00','DD/MM/YYYY hh24:mi:ss'),420);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (212,12,'EP',TO_TIMESTAMP('09/03/2023 06:02:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 13:50:00','DD/MM/YYYY hh24:mi:ss'),468);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (213,13,'EF2',TO_TIMESTAMP('09/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('09/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),479);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (214,14,'EP',TO_TIMESTAMP('09/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 14:04:00','DD/MM/YYYY hh24:mi:ss'),474);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (215,15,'EV',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('09/03/2023 22:30:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (216,16,'EF1',TO_TIMESTAMP('09/03/2023 06:04:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),476);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (217,17,'EF1',TO_TIMESTAMP('09/03/2023 13:30:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('09/03/2023 21:06:00','DD/MM/YYYY hh24:mi:ss'),456);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (218,18,'EP',TO_TIMESTAMP('09/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 14:40:00','DD/MM/YYYY hh24:mi:ss'),519);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (219,19,'EP',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (220,20,'EP',TO_TIMESTAMP('09/03/2023 06:05:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (221,21,'EP',TO_TIMESTAMP('09/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('09/03/2023 22:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (222,22,'EV',TO_TIMESTAMP('09/03/2023 06:04:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('09/03/2023 14:30:00','DD/MM/YYYY hh24:mi:ss'),506);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (223,23,'EF1',TO_TIMESTAMP('09/03/2023 14:07:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('09/03/2023 22:08:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (224,24,'EF1',TO_TIMESTAMP('09/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('09/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (225,25,'EF2',TO_TIMESTAMP('09/03/2023 07:55:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('09/03/2023 16:06:00','DD/MM/YYYY hh24:mi:ss'),491);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (226,1,'EP',TO_TIMESTAMP('10/03/2023 09:04:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 17:00:00','DD/MM/YYYY hh24:mi:ss'),476);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (227,2,'EP',TO_TIMESTAMP('10/03/2023 09:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('10/03/2023 17:04:00','DD/MM/YYYY hh24:mi:ss'),484);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (228,3,'EP',TO_TIMESTAMP('10/03/2023 09:11:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 17:23:00','DD/MM/YYYY hh24:mi:ss'),492);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (229,4,'EF2',TO_TIMESTAMP('10/03/2023 06:00:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('10/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (230,5,'EP',TO_TIMESTAMP('10/03/2023 14:02:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 22:03:00','DD/MM/YYYY hh24:mi:ss'),481);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (231,6,'EV',TO_TIMESTAMP('10/03/2023 07:00:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('10/03/2023 15:34:00','DD/MM/YYYY hh24:mi:ss'),514);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (232,7,'EF1',TO_TIMESTAMP('10/03/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 21:50:00','DD/MM/YYYY hh24:mi:ss'),450);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (233,8,'EF1',TO_TIMESTAMP('10/03/2023 06:05:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 14:03:00','DD/MM/YYYY hh24:mi:ss'),478);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (234,9,'EF2',TO_TIMESTAMP('10/03/2023 13:55:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),485);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (235,10,'EP',TO_TIMESTAMP('10/03/2023 06:30:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 14:01:00','DD/MM/YYYY hh24:mi:ss'),451);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (236,11,'EV',TO_TIMESTAMP('10/03/2023 14:10:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('10/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),470);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (237,12,'EF1',TO_TIMESTAMP('10/03/2023 06:01:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 13:59:00','DD/MM/YYYY hh24:mi:ss'),478);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (238,13,'EF1',TO_TIMESTAMP('10/03/2023 14:05:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (239,14,'EF2',TO_TIMESTAMP('10/03/2023 06:11:00','DD/MM/YYYY hh24:mi:ss'),'EF2',TO_TIMESTAMP('10/03/2023 14:06:00','DD/MM/YYYY hh24:mi:ss'),475);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (240,15,'EP',TO_TIMESTAMP('10/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (241,16,'EV',TO_TIMESTAMP('10/03/2023 06:07:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('10/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),473);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (242,17,'EF1',TO_TIMESTAMP('10/03/2023 13:00:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 21:10:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (243,18,'EF1',TO_TIMESTAMP('10/03/2023 06:03:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 15:50:00','DD/MM/YYYY hh24:mi:ss'),587);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (244,19,'EP',TO_TIMESTAMP('10/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 22:00:00','DD/MM/YYYY hh24:mi:ss'),480);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (245,20,'EP',TO_TIMESTAMP('10/03/2023 06:08:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),472);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (246,21,'EP',TO_TIMESTAMP('10/03/2023 14:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 22:20:00','DD/MM/YYYY hh24:mi:ss'),500);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (247,22,'EV',TO_TIMESTAMP('10/03/2023 06:10:00','DD/MM/YYYY hh24:mi:ss'),'EV',TO_TIMESTAMP('10/03/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),490);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (248,23,'EF1',TO_TIMESTAMP('10/03/2023 14:07:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 22:09:00','DD/MM/YYYY hh24:mi:ss'),482);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (249,24,'EF1',TO_TIMESTAMP('10/03/2023 05:50:00','DD/MM/YYYY hh24:mi:ss'),'EF1',TO_TIMESTAMP('10/03/2023 14:20:00','DD/MM/YYYY hh24:mi:ss'),510);
INSERT INTO erp.tb_sign_employees(sign_id,employee_id,sign_term_in,sign_data_in,sign_term_out,sign_data_out,sign_time_minutes) VALUES (250,25,'EP',TO_TIMESTAMP('10/03/2023 08:00:00','DD/MM/YYYY hh24:mi:ss'),'EP',TO_TIMESTAMP('10/03/2023 16:30:00','DD/MM/YYYY hh24:mi:ss'),510);
------------------------------------------------------------------------------------------------
--
-- Data tb_products;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_products(products_id,products_name,products_size,products_cost) VALUES ('JCE55','Jamón cocido extra finas lonchas 550gr',550,2.89);
INSERT INTO erp.tb_products(products_id,products_name,products_size,products_cost) VALUES ('JCE25','Jamón cocido extra finas lonchas 250gr',250,1.44);
INSERT INTO erp.tb_products(products_id,products_name,products_size,products_cost) VALUES ('JCL20','Jamón cocido finas lonchas light 200gr',200,0.96);
INSERT INTO erp.tb_products(products_id,products_name,products_size,products_cost) VALUES ('JCN10','Jamón cocido natural 100gr',100,0.63);
INSERT INTO erp.tb_products(products_id,products_name,products_size,products_cost) VALUES ('JCN25','Jamón cocido natural 250gr',250,1.47);
INSERT INTO erp.tb_products(products_id,products_name,products_size,products_cost) VALUES ('JCS20','Jamón cocido bajo en Sal 200gr',200,1.04);
------------------------------------------------------------------------------------------------
--
-- Data tb_production_cab;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (1,to_date('27/02/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (2,to_date('28/02/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (3,to_date('01/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (4,to_date('02/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (5,to_date('03/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (6,to_date('06/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (7,to_date('07/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (8,to_date('08/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (9,to_date('09/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (10,to_date('10/03/2023','DD/MM/YYYY'),'M');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (11,to_date('27/02/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (12,to_date('28/02/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (13,to_date('01/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (14,to_date('02/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (15,to_date('03/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (16,to_date('06/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (17,to_date('07/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (18,to_date('08/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (19,to_date('09/03/2023','DD/MM/YYYY'),'T');
INSERT INTO erp.tb_production_cab(production_cab_id,production_date,production_shift) VALUES (20,to_date('10/03/2023','DD/MM/YYYY'),'T');
------------------------------------------------------------------------------------------------
--
-- Data tb_production_lin;
--
------------------------------------------------------------------------------------------------
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (1,1,'JCE55',1202);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (2,1,'JCE25',805);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (3,1,'JCL20',908);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (4,1,'JCN10',1110);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (5,1,'JCN25',1312);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (6,1,'JCS20',1414);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (7,2,'JCE55',918);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (8,2,'JCE25',1115);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (9,2,'JCL20',1310);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (10,2,'JCN10',1412);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (11,2,'JCN25',914);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (12,2,'JCS20',0);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (13,3,'JCE55',1218);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (14,3,'JCE25',820);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (15,3,'JCL20',922);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (16,3,'JCN10',1124);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (17,3,'JCN25',1326);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (18,3,'JCS20',1428);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (19,4,'JCE55',824);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (20,4,'JCE25',927);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (21,4,'JCL20',1129);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (22,4,'JCN10',1323);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (23,4,'JCN25',1426);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (24,4,'JCS20',1228);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (25,5,'JCE55',832);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (26,5,'JCE25',939);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (27,5,'JCL20',1129);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (28,5,'JCN10',1332);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (29,5,'JCN25',1436);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (30,5,'JCS20',938);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (31,6,'JCE55',1131);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (32,6,'JCE25',1332);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (33,6,'JCL20',1433);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (34,6,'JCN10',934);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (35,6,'JCN25',1135);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (36,6,'JCS20',1236);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (37,7,'JCE55',837);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (38,7,'JCE25',938);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (39,7,'JCL20',1139);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (40,7,'JCN10',1340);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (41,7,'JCN25',1441);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (42,7,'JCS20',0);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (43,8,'JCE55',943);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (44,8,'JCE25',1144);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (45,8,'JCL20',1345);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (46,8,'JCN10',1446);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (47,8,'JCN25',1247);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (48,8,'JCS20',848);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (49,9,'JCE55',949);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (50,9,'JCE25',1150);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (51,9,'JCL20',1351);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (52,9,'JCN10',1452);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (53,9,'JCN25',953);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (54,9,'JCS20',1154);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (55,10,'JCE55',1355);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (56,10,'JCE25',1456);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (57,10,'JCL20',957);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (58,10,'JCN10',1158);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (59,10,'JCN25',1259);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (60,10,'JCS20',860);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (61,11,'JCE55',961);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (62,11,'JCE25',1162);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (63,11,'JCL20',1363);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (64,11,'JCN10',1464);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (65,11,'JCN25',865);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (66,11,'JCS20',966);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (67,12,'JCE55',1167);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (68,12,'JCE25',1368);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (69,12,'JCL20',1469);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (70,12,'JCN10',1270);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (71,12,'JCN25',871);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (72,12,'JCS20',0);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (73,13,'JCE55',1173);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (74,13,'JCE25',1374);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (75,13,'JCL20',1475);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (76,13,'JCN10',976);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (77,13,'JCN25',1177);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (78,13,'JCS20',1378);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (79,14,'JCE55',1479);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (80,14,'JCE25',980);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (81,14,'JCL20',1203);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (82,14,'JCN10',1282);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (83,14,'JCN25',883);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (84,14,'JCS20',984);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (85,15,'JCE55',1185);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (86,15,'JCE25',1386);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (87,15,'JCL20',737);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (88,15,'JCN10',888);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (89,15,'JCN25',739);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (90,15,'JCS20',1190);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (91,16,'JCE55',1391);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (92,16,'JCE25',892);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (93,16,'JCL20',1293);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (94,16,'JCN10',894);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (95,16,'JCN25',995);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (96,16,'JCS20',1196);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (97,17,'JCE55',197);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (98,17,'JCE25',1498);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (99,17,'JCL20',999);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (100,17,'JCN10',1200);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (101,17,'JCN25',1401);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (102,17,'JCS20',0);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (103,18,'JCE55',803);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (104,18,'JCE25',1428);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (105,18,'JCL20',1305);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (106,18,'JCN10',906);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (107,18,'JCN25',1007);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (108,18,'JCS20',1208);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (109,19,'JCE55',1909);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (110,19,'JCE25',1555);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (111,19,'JCL20',911);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (112,19,'JCN10',1346);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (113,19,'JCN25',613);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (114,19,'JCS20',1014);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (115,20,'JCE55',1215);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (116,20,'JCE25',1416);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (117,20,'JCL20',1517);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (118,20,'JCN10',1021);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (119,20,'JCN25',1221);
INSERT INTO erp.tb_production_lin(production_lin_id,production_cab_id,products_id,production_lin_quantity) VALUES (120,20,'JCS20',1421);
We will check the data by performing different queries to the database:
SELECT te.employee_name,te.employee_surname,te.employee_hiredate,te.employee_birthdate
FROM erp.tb_employee te
WHERE te.employee_gender = 'Hombre' AND
te.employee_name LIKE 'A%'
ORDER BY te.employee_birthdate DESC;| employee_name | employee_surname | employee_hiredate | employee_birthdate |
|---|---|---|---|
| ADRIAN | MONTERO | 2022-11-23 | 1993-07-06 |
| ALVARO | VARGAS | 2017-06-24 | 1993-03-02 |
| ANDRES | CARMONA | 2017-09-24 | 1990-01-25 |
SELECT te.employee_name,te.employee_surname,ts.sign_data_in,tr.terminal_name
FROM erp.tb_employee te,erp.tb_sign_employees ts,erp.tb_terminals tr
WHERE ts.employee_id=te.employee_id AND
ts.sign_term_in = tr.terminal_id AND
ts.sign_data_in between TO_TIMESTAMP('28-02-2023 05:00:00','DD/MM/YYYY hh24:mi:ss') AND
TO_TIMESTAMP('28-02-2023 05:59:00','DD/MM/YYYY hh24:mi:ss') AND
terminal_id IN ('EP','EV');| employee_name | employee_surname | sign_data_in | terminal_name |
|---|---|---|---|
| ANDRES | CARMONA | 2023-02-28 05:55:00 | Entrada Principal |
| RAMON | MORA | 2023-02-28 05:59:00 | Entrada Principal |
| ALVARO | VARGAS | 2023-02-28 05:50:00 | Entrada Vestidores |
| JOSE MANUEL | CAMPOS | 2023-02-28 05:58:00 | Entrada Principal |
SELECT tp.products_id,products_name,production_shift,
(products_size*production_lin_quantity)/1000 "Kg Fabricados"
FROM erp.tb_products tp, erp.tb_production_cab tc, erp.tb_production_lin tl
WHERE tc.production_cab_id=tl.production_cab_id AND
tl.products_id=tp.products_id AND
tc.production_date=TO_DATE('27/02/2023','DD/MM/YYYY') AND
tp.products_id IN('JCE25','JCS20','JCN25')
ORDER BY tp.products_id| products_id | products_name | production_shift | Kg Fabricados |
|---|---|---|---|
| JCE25 | Jamón cocido extra finas lonchas 250gr | M | 201 |
| JCE25 | Jamón cocido extra finas lonchas 250gr | T | 290 |
| JCN25 | Jamón cocido natural 250gr | M | 328 |
| JCN25 | Jamón cocido natural 250gr | T | 216 |
| JCS20 | Jamón cocido bajo en Sal 200gr | M | 282 |
| JCS20 | Jamón cocido bajo en Sal 200gr | T | 193 |
SELECT tl.products_id AS "Product Code",
pr.products_name AS "Product Name",
ROUND(avg((tl.production_lin_quantity*products_size)/1000),2) AS "Average kg/day",
MAX (ROUND((tl.production_lin_quantity*products_size)/1000,2)) AS "MAX kg/day",
MIN(ROUND((tl.production_lin_quantity*products_size)/1000,2)) AS "MIN kg/day"
FROM erp.tb_production_cab tp, erp.tb_production_lin tl, erp.tb_products pr
WHERE tp.production_cab_id = tl.production_cab_id AND
pr.products_id=tl.products_id AND
tp.production_shift='M'
GROUP BY tl.products_id,pr.products_name
ORDER BY "Average kg/day" DESC;| Product Code | Product Name | Average kg/day | MAX kg/day | MIN kg/day |
|---|---|---|---|---|
| JCE55 | Jamón cocido extra finas lonchas 550gr | 561.0 | 745 | 453 |
| JCN25 | Jamón cocido natural 250gr | 310.8 | 360 | 228 |
| JCE25 | Jamón cocido extra finas lonchas 250gr | 265.3 | 364 | 201 |
| JCL20 | Jamón cocido finas lonchas light 200gr | 232.0 | 286 | 181 |
| JCS20 | Jamón cocido bajo en Sal 200gr | 181.7 | 285 | 0 |
| JCN10 | Jamón cocido natural 100gr | 126.0 | 145 | 93 |
SELECT employee_name,employee_surname,ROUND(AVG(sign_time_minutes)) AS media_minutos
FROM erp.tb_sign_employees ts, erp.tb_employee te, erp.tb_category tc
WHERE ts.employee_id=te.employee_id AND
te.category_id=tc.category_id AND
tc.category_name='Operario Producción' AND
te.employee_shift='M'
GROUP BY employee_name,employee_surname
HAVING AVG(sign_time_minutes)>
(SELECT AVG(sign_time_minutes)
FROM erp.tb_sign_employees ts, erp.tb_employee te, erp.tb_category tc
WHERE ts.employee_id=te.employee_id AND
te.category_id=tc.category_id AND
tc.category_name='Operario Producción')
ORDER BY AVG(sign_time_minutes) ASC;| employee_name | employee_surname | media_minutos |
|---|---|---|
| ALVARO | VARGAS | 489 |
| JOSE MANUEL | CAMPOS | 491 |
| ISABEL | MOYA | 497 |
| RAFAEL | REYES | 500 |
/* insert into erp.tb_employee (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_boss,employee_shift) VALUES (26,'CARLOS','ALONSO',7,to_date('13/03/2023','DD/MM/YYYY'),to_date('05/03/1973','DD/MM/YYYY'),6,'M'); */Validating:
SELECT * FROM erp.tb_employee WHERE employee_id in (26);| employee_id | employee_name | employee_surname | category_id | employee_hiredate | employee_birthdate | employee_gender | employee_boss | employee_shift |
|---|---|---|---|---|---|---|---|---|
| 26 | CARLOS | ALONSO | 7 | 2023-03-13 | 1973-03-05 | Hombre | 6 | M |
SELECT products_cost FROM erp.tb_products| products_cost |
|---|
| 3.03 |
| 1.51 |
| 1.01 |
| 0.66 |
| 1.54 |
| 1.09 |
| NA |
/*UPDATE erp.tb_products
SET products_cost = products_cost + products_cost *0.05;*/Validating:
SELECT products_cost FROM erp.tb_products| products_cost |
|---|
| 3.03 |
| 1.51 |
| 1.01 |
| 0.66 |
| 1.54 |
| 1.09 |
| NA |
/* ALTER TABLE erp.tb_products
ADD COLUMN products_pvp NUMERIC(12,2);*/Updating:
/* UPDATE erp.tb_products
SET products_pvp = products_cost + products_cost *0.1;*/Validating:
SELECT products_cost,products_pvp FROM erp.tb_products| products_cost | products_pvp |
|---|---|
| 3.03 | 3.33 |
| 1.51 | 1.66 |
| 1.01 | 1.11 |
| 0.66 | 0.73 |
| 1.54 | 1.69 |
| 1.09 | 1.20 |
| NA | NA |
Employees without shifts in the schedule:
CREATE OR REPLACE VIEW erp.employee_not_shift AS
SELECT *
FROM erp.tb_employee
WHERE employee_shift IS NULL
WITH CHECK OPTION;Validating:
SELECT * FROM erp.employee_not_shift| employee_id | employee_name | employee_surname | category_id | employee_hiredate | employee_birthdate | employee_gender | employee_boss | employee_shift |
|---|---|---|---|---|---|---|---|---|
| 1 | CARLOS | CABRERA | 1 | 2000-01-29 | 1967-08-02 | Hombre | NA | NA |
| 2 | ENRIQUE | FERRER | 2 | 2002-03-28 | 1973-12-24 | Hombre | 1 | NA |
| 3 | FERNANDO | NIETO | 3 | 1996-11-11 | 1951-04-18 | Hombre | 1 | NA |
| 25 | RAUL | SANTIAGO | 8 | 2020-08-24 | 1990-11-13 | Hombre | 9 | NA |
| 28 | PEPE | MORRAL | 7 | 2023-03-13 | 2001-05-13 | Hombre | 7 | NA |
The WITH CHECK OPTION clause in a PostgreSQL view serves an important purpose. This clause is used to ensure that rows can only be inserted, updated, or deleted through the view if the resulting rows meet the filter condition specified in the view.
Wrong insertion method:
{/*{sql connection= con} insert into erp.employee_not_shift (employee_id,employee_name,employee_surname,category_id,employee_hiredate ,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (28,'PEPE','MORRAL',7,to_date('13/03/2023','DD/MM/YYYY'),to_date('13/05/2001','DD/MM/YYYY'),'Hombre',7,'T');*/
Correct insertion method:
/*insert into erp.employee_not_shift (employee_id,employee_name,employee_surname,category_id,employee_hiredate,employee_birthdate,employee_gender,Employee_boss,employee_shift) VALUES (28,'PEPE','MORRAL',7,to_date('13/03/2023','DD/MM/YYYY'),to_date('13/05/2001','DD/MM/YYYY'),'Hombre',7,NULL);*//*ALTER TABLE erp.tb_products
ADD CONSTRAINT ck_products_id CHECK
((products_id LIKE 'JC___' AND products_name LIKE 'Jamón cocido%')
OR (products_id LIKE 'PC___' AND products_name LIKE 'Pavo cocido%'));*/This ck_products_id constraint ensures that rows are only allowed to be inserted or updated in the erp.tb_products table if they meet the specified conditions. In this case, the constraint ensures that the values of products_id and products_name comply with the patterns set for products of type “Jamon cocido” and “Pavo cocido”.
-- Insert sin error
/*insert into erp.tb_products(products_id,products_name,products_size) VALUES ('JCE30','Jamón cocido extra finas lonchas 300gr',300);*/-- Insert con error
/*insert into erp.tb_products(products_id,products_name,products_size) VALUES ('JA25','Jamón cocido extra finas lonchas ahumado 250gr',250);*/-- CREATE USER registerered WITH LOGIN PASSWORD '1234'; -- new user-- GRANT USAGE ON SCHEMA erp TO registerered; -- GRANT SELECT,INSERT,UPDATE ON erp.tb_employee TO registerered; -- granting SELECT,INSERT and UPDATE permissions-- GRANT SELECT ON erp.tb_terminals,erp.tb_category TO registerered; -- single permissionsAnd at this point, we end this first part where the most common assumptions and steps in the creation of a new database for a corporate client are collected.
This was a real proposal based on a real client whose data has been anonymised.