67 lines
2.3 KiB
Transact-SQL
67 lines
2.3 KiB
Transact-SQL
-- =============================================
|
|
-- Description: Az alkalmazott munkaügyi exporthoz adja vissza az adatokat
|
|
-- =============================================
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
IF OBJECT_ID('[dbo].[sp_GetAlkalmazottMunkaugyiExport]') IS NOT NULL
|
|
BEGIN
|
|
DROP PROCEDURE [dbo].[sp_GetAlkalmazottMunkaugyiExport]
|
|
END
|
|
GO
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[sp_GetAlkalmazottMunkaugyiExport]
|
|
@tanevId int
|
|
,@intezmenyid int
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
|
|
select
|
|
a.ID as ID
|
|
,f.C_NYOMTATASINEV as 'PedagogusNeve'
|
|
,IIF(f.C_NEVSORREND = 'T', f.C_UTONEV + ' ' + f.C_VEZETEKNEV, f.C_VEZETEKNEV + ' ' + f.C_UTONEV) AS 'PedagogusNeveElotagNelkul'
|
|
,f.C_ELOTAG AS 'PedagogusNevElotag'
|
|
,f.C_VEZETEKNEV AS 'PedagogusVezetekneve'
|
|
,f.C_UTONEV AS 'PedagogusUtoneve'
|
|
,f.C_ANYJANEVE AS 'PedagogusAnyjaNeve'
|
|
,f.C_SZULETESIDATUM as 'PedagogusSzuletesiDatuma'
|
|
,f.C_SZULETESIHELY AS 'PedagogusSzuletesiHelye'
|
|
,f.C_ADOSZAM as 'Adoszam'
|
|
,m.C_BESOROLASIFOKOZAT as 'BesorolasiFokozat'
|
|
,m.C_MUNKAKORTIPUSA as 'Munkakor'
|
|
,m.C_MUNKAVISZONYTIPUSA as 'FoglalkoztatasModja'
|
|
,m.C_FOGLALKOZTATASTIPUS as 'FoglalkoztatasTipusa'
|
|
,m.C_KOTELEZOORASZAM as 'KotelezoOraszama'
|
|
,m.C_MUNKAIDOKEDVEZMENYORASZAM as 'MunkaidoKedvezmenyOraszama'
|
|
,m.C_VEZETOIORASZAMOK as 'VezetoiOraszamokTipus'
|
|
,m.C_MUNKAIDOKEDVEZMENYOKA as 'MunkaidoKedvezmenyOka'
|
|
,m.C_ALKALMAZASKEZDETE as 'AlkalmazasKezdete'
|
|
,f.C_OKTATASIAZONOSITO as 'Oktatasiazonosito'
|
|
,mh.C_NEV AS 'FeladatellatasiHely'
|
|
,m.C_TARTOSHELYETTESITES AS 'TartosHelyettesites'
|
|
,m.C_BETOLTETLENALLASHELY AS 'BetoltetlenAllashely'
|
|
,a.C_FOALLAS AS 'Foallasu'
|
|
,m.C_NYUGDIJAS AS 'Nyugdijas'
|
|
,a.C_SZAKERTOIVIZSGAELNOKI AS 'SzakertoiVagyVizsgaelnokiTevekenysegu'
|
|
,a.C_TOVABBKEPZES AS 'SzakmaiTovabbkepzes'
|
|
,a.C_SZAKVIZSGA AS 'Szakvizsga'
|
|
,m.C_ATTANITO AS 'Attanito'
|
|
from T_MUNKAUGYIADATOK_OSSZES m
|
|
inner join T_FELHASZNALO_OSSZES f on f.ID = m.C_ALKALMAZOTTID and f.TOROLT = 'F'
|
|
inner join T_ALKALMAZOTT_OSSZES a on a.ID = m.C_ALKALMAZOTTID and a.TOROLT = 'F'
|
|
INNER JOIN T_FELADATELLATASIHELY_OSSZES fh ON fh.ID = m.C_FELADATELLATASIHELYID AND fh.TOROLT = 'F'
|
|
INNER JOIN T_MUKODESIHELY_OSSZES mh ON mh.ID = fh.C_MUKODESIHELYID AND mh.TOROLT = 'F'
|
|
where
|
|
m.TOROLT = 'F' and m.C_INTEZMENYID = @intezmenyid and m.C_TANEVID = @tanevId
|
|
order by
|
|
PedagogusNeveElotagNelkul
|
|
|
|
|
|
END
|
|
GO |