codDepto |
nombreDpto |
ciudad |
codDirector |
1000 |
GERENCIA |
CALI |
31.840.269 |
1500 |
PRODUCCIÓN |
CALI |
16.211.383 |
2000 |
VENTAS |
CALI |
31.178.144 |
2100 |
VENTAS |
POPAYAN |
1.751.219 |
2200 |
VENTAS |
BUGA |
768.782 |
2300 |
VENTAS |
CARTAGO |
737.689 |
3000 |
INVESTIGACIÓN |
CALI |
16.759.060 |
3500 |
MERCADEO |
CALI |
22.222.222 |
nDIEmp |
nomEmp |
sexEmp |
fecNac |
fecIncorporacion |
salEmp |
comisionE |
cargoE |
jefeID |
codDepto |
1.751.219 |
Melissa Roa |
F |
1960-06-19 |
2001-03-16 |
2250000 |
2500000 |
Vendedor |
31.178.144 |
2100 |
16.211.383 |
Luis Pérez |
M |
1956-02-25 |
2000-01-01 |
5050000 |
0 |
Director |
31.840.269 |
1500 |
16.759.060 |
Darío Casas |
M |
1960-04-05 |
1992-11-01 |
4500000 |
500000 |
Investigador |
31.840.269 |
3000 |
22.222.222 |
Carla López |
F |
1975-05-11 |
2005-07-16 |
4500000 |
500000 |
Jefe Mercadeo |
31.840.269 |
3500 |
22.222.333 |
Carlos Rozo |
M |
1975-05-11 |
2001-09-16 |
750000 |
500000 |
Vigilante |
31.840.269 |
3500 |
31.178.144 |
Rosa Angulo |
F |
1957-03-15 |
1998-08-16 |
3250000 |
3500000 |
Jefe Ventas |
31.840.269 |
2000 |
31.840.269 |
María Rojas |
F |
1959-01-15 |
1990-05-16 |
6250000 |
1500000 |
Gerente |
null |
1000 |
737.689 |
Mario Llano |
M |
1945-08-30 |
1990-05-16 |
2250000 |
2500000 |
Vendedor |
31.178.144 |
2300 |
768.782 |
Joaquín Rosas |
M |
1947-07-07 |
1990-05-16 |
2250000 |
2500000 |
Vendedor |
31.178.144 |
2200 |