|
|
Al intentar hacer un cambio de centro de costo, al seleccionar al empleado afectado, despliega el siguiente mensaje:
La Posición del empleado seleccionado tiene mas de un empleado asociado. Modificar las asociaciones de centros de costo a La Posición afectará a mas de un empleado.
En efecto, la posición tiene asociado más de un empleo, pero pasa que el otro empleo está en estado retirado, según el query mostrado por el profiler del SQL.
¿Tiene sentido que valide también a los retirados?. Adjunto query mencionado anteriormente:
SELECT [Project1].[plz_codigo] AS
[plz_codigo], [Project1].[plz_nombre]
AS [plz_nombre],
[Project1].[plz_max_empleados] AS
[plz_max_empleados],
[Project1].[plz_es_temporal] AS
[plz_es_temporal],
[Project1].[plz_fecha_ini] AS
[plz_fecha_ini],
[Project1].[plz_fecha_fin] AS
[plz_fecha_fin],
[Project1].[plz_estado] AS
[plz_estado],
[Project1].[plz_fecha_estado] AS
[plz_fecha_estado],
[Project1].[plz_usuario_grabacion] AS
[plz_usuario_grabacion],
[Project1].[plz_fecha_grabacion] AS
[plz_fecha_grabacion],
[Project1].[plz_usuario_modificacion]
AS [plz_usuario_modificacion],
[Project1].[plz_fecha_modificacion] AS
[plz_fecha_modificacion],
[Project1].[plz_property_bag_data] AS
[plz_property_bag_data],
[Project1].[plz_estado_workflow] AS
[plz_estado_workflow],
[Project1].[plz_codigo_workflow] AS
[plz_codigo_workflow],
[Project1].[plz_ingresado_portal] AS
[plz_ingresado_portal],
[Project1].[plz_presupuestada] AS
[plz_presupuestada],
[Project1].[plz_codcdt] AS
[plz_codcdt], [Project1].[plz_codcia]
AS [plz_codcia],
[Project1].[plz_codpue] AS
[plz_codpue], [Project1].[plz_coduni]
AS [plz_coduni],
[Project1].[plz_wfl_ce_solicita] AS
[plz_wfl_ce_solicita],
[Project1].[plz_wfl_ce_def_auth] AS
[plz_wfl_ce_def_auth],
[Project1].[plz_wfl_ce_suj_acc] AS
[plz_wfl_ce_suj_acc],
[Project1].[plz_wfl_ce_autorizador] AS
[plz_wfl_ce_autorizador],
[Project1].[C1] AS [C1],
[Project1].[emp_codigo] AS
[emp_codigo], [Project1].[emp_estado]
AS [emp_estado],
[Project1].[emp_estado_activo] AS
[emp_estado_activo],
[Project1].[emp_fecha_ingreso] AS
[emp_fecha_ingreso],
[Project1].[emp_fecha_retiro] AS
[emp_fecha_retiro],
[Project1].[emp_contrato_ini] AS
[emp_contrato_ini],
[Project1].[emp_contrato_fin] AS
[emp_contrato_fin],
[Project1].[emp_usuario_grabacion] AS
[emp_usuario_grabacion],
[Project1].[emp_fecha_grabacion] AS
[emp_fecha_grabacion],
[Project1].[emp_usuario_modificacion]
AS [emp_usuario_modificacion],
[Project1].[emp_fecha_modificacion] AS
[emp_fecha_modificacion],
[Project1].[emp_property_bag_data] AS
[emp_property_bag_data],
[Project1].[emp_fecha_ult_liquidacion]
AS [emp_fecha_ult_liquidacion],
[Project1].[emp_codplz] AS
[emp_codplz], [Project1].[emp_codcmr]
AS [emp_codcmr],
[Project1].[emp_codexp] AS
[emp_codexp], [Project1].[emp_codjor]
AS [emp_codjor],
[Project1].[emp_codmrt] AS
[emp_codmrt], [Project1].[emp_codtco]
AS [emp_codtco],
[Project1].[emp_codtpl] AS
[emp_codtpl] FROM ( SELECT
[Limit1].[plz_codigo] AS [plz_codigo],
[Limit1].[plz_nombre] AS [plz_nombre],
[Limit1].[plz_codcia] AS [plz_codcia],
[Limit1].[plz_coduni] AS [plz_coduni],
[Limit1].[plz_codpue] AS [plz_codpue],
[Limit1].[plz_codcdt] AS [plz_codcdt],
[Limit1].[plz_max_empleados] AS
[plz_max_empleados],
[Limit1].[plz_es_temporal] AS
[plz_es_temporal],
[Limit1].[plz_presupuestada] AS
[plz_presupuestada],
[Limit1].[plz_fecha_ini] AS
[plz_fecha_ini],
[Limit1].[plz_fecha_fin] AS
[plz_fecha_fin], [Limit1].[plz_estado]
AS [plz_estado],
[Limit1].[plz_fecha_estado] AS
[plz_fecha_estado],
[Limit1].[plz_property_bag_data] AS
[plz_property_bag_data],
[Limit1].[plz_estado_workflow] AS
[plz_estado_workflow],
[Limit1].[plz_codigo_workflow] AS
[plz_codigo_workflow],
[Limit1].[plz_ingresado_portal] AS
[plz_ingresado_portal],
[Limit1].[plz_usuario_grabacion] AS
[plz_usuario_grabacion],
[Limit1].[plz_fecha_grabacion] AS
[plz_fecha_grabacion],
[Limit1].[plz_usuario_modificacion] AS
[plz_usuario_modificacion],
[Limit1].[plz_fecha_modificacion] AS
[plz_fecha_modificacion],
[Limit1].[plz_wfl_ce_def_auth] AS
[plz_wfl_ce_def_auth],
[Limit1].[plz_wfl_ce_solicita] AS
[plz_wfl_ce_solicita],
[Limit1].[plz_wfl_ce_suj_acc] AS
[plz_wfl_ce_suj_acc],
[Limit1].[plz_wfl_ce_autorizador] AS
[plz_wfl_ce_autorizador],
[Extent2].[emp_codigo] AS
[emp_codigo], [Extent2].[emp_codplz]
AS [emp_codplz],
[Extent2].[emp_codexp] AS
[emp_codexp], [Extent2].[emp_estado]
AS [emp_estado],
[Extent2].[emp_estado_activo] AS
[emp_estado_activo],
[Extent2].[emp_fecha_ingreso] AS
[emp_fecha_ingreso],
[Extent2].[emp_fecha_retiro] AS
[emp_fecha_retiro],
[Extent2].[emp_codcmr] AS
[emp_codcmr], [Extent2].[emp_codmrt]
AS [emp_codmrt],
[Extent2].[emp_codtco] AS
[emp_codtco], [Extent2].[emp_codjor]
AS [emp_codjor],
[Extent2].[emp_codtpl] AS
[emp_codtpl],
[Extent2].[emp_contrato_ini] AS
[emp_contrato_ini],
[Extent2].[emp_contrato_fin] AS
[emp_contrato_fin],
[Extent2].[emp_fecha_ult_liquidacion]
AS [emp_fecha_ult_liquidacion],
[Extent2].[emp_property_bag_data] AS
[emp_property_bag_data],
[Extent2].[emp_usuario_grabacion] AS
[emp_usuario_grabacion],
[Extent2].[emp_fecha_grabacion] AS
[emp_fecha_grabacion],
[Extent2].[emp_usuario_modificacion]
AS [emp_usuario_modificacion],
[Extent2].[emp_fecha_modificacion] AS
[emp_fecha_modificacion], CASE WHEN
([Extent2].[emp_codigo] IS NULL) THEN
CAST(NULL AS int) ELSE 1 END AS [C1]
FROM (SELECT TOP (1)
[Extent1].[plz_codigo] AS
[plz_codigo], [Extent1].[plz_nombre]
AS [plz_nombre],
[Extent1].[plz_codcia] AS
[plz_codcia], [Extent1].[plz_coduni]
AS [plz_coduni],
[Extent1].[plz_codpue] AS
[plz_codpue], [Extent1].[plz_codcdt]
AS [plz_codcdt],
[Extent1].[plz_max_empleados] AS
[plz_max_empleados],
[Extent1].[plz_es_temporal] AS
[plz_es_temporal],
[Extent1].[plz_presupuestada] AS
[plz_presupuestada],
[Extent1].[plz_fecha_ini] AS
[plz_fecha_ini],
[Extent1].[plz_fecha_fin] AS
[plz_fecha_fin],
[Extent1].[plz_estado] AS
[plz_estado],
[Extent1].[plz_fecha_estado] AS
[plz_fecha_estado],
[Extent1].[plz_property_bag_data] AS
[plz_property_bag_data],
[Extent1].[plz_estado_workflow] AS
[plz_estado_workflow],
[Extent1].[plz_codigo_workflow] AS
[plz_codigo_workflow],
[Extent1].[plz_ingresado_portal] AS
[plz_ingresado_portal],
[Extent1].[plz_usuario_grabacion] AS
[plz_usuario_grabacion],
[Extent1].[plz_fecha_grabacion] AS
[plz_fecha_grabacion],
[Extent1].[plz_usuario_modificacion]
AS [plz_usuario_modificacion],
[Extent1].[plz_fecha_modificacion] AS
[plz_fecha_modificacion],
[Extent1].[plz_wfl_ce_def_auth] AS
[plz_wfl_ce_def_auth],
[Extent1].[plz_wfl_ce_solicita] AS
[plz_wfl_ce_solicita],
[Extent1].[plz_wfl_ce_suj_acc] AS
[plz_wfl_ce_suj_acc],
[Extent1].[plz_wfl_ce_autorizador] AS
[plz_wfl_ce_autorizador] FROM
[eor].[plz_plazas] AS [Extent1] WHERE
5603 = [Extent1].[plz_codigo] ) AS
[Limit1] LEFT OUTER JOIN
[exp].[emp_empleos] AS [Extent2] ON
[Limit1].[plz_codigo] =
[Extent2].[emp_codplz] ) AS [Project1]
ORDER BY [Project1].[plz_codigo] ASC,
[Project1].[C1] ASC
asked
09 Jul '20, 11:21
Erick Túchez
210●65●71●68
accept rate:
37%
|
