Ver site completo

PORTAL DE DOCUMENTAÇÃO
Gestão de Pessoas | HCM - senior X
Gestão de Pessoas - senior X - Manual do Usuário > Integrador SST > Saneamento da base do prestador > MedNet

Saneamento da base do prestador — MedNet

Extrair informações usando comandos no banco de dados

Estes são os comandos de SELECT que podem ser executados no sistema da Senior, para facilitar a extração dos dados. Os comandos estão divididos por tipo de informação (colaboradores, filiais, setores e cargos).

Instruções:

  1. Use os comandos desta página para consultar os registros no banco de dados.
  2. Exporte os resultados da consulta para um arquivo no formato .XLS ou .CSV.
  3. Envie o arquivo exportado para o prestador SST.

Ao receber o arquivo exportado, o prestador SST deverá fazer o saneamento da base de dados no sistema MedNet. Para fazer o saneamento, o prestador pode optar entre:

Saneamento de dados:

Colaboradores

Comandos do banco de dados para saneamento da base

ClosedSQL Server

SELECT

R034FUN.NomFun 'Nome funcionário',

CASE

WHEN R034FUN.TipCol = 1 THEN '1-Empregado'

WHEN R034FUN.TipCol = 2 THEN '2-Terceiro'

WHEN R034FUN.TipCol = 3 THEN '3-Parceiro'

ELSE 'Valor inválido'

END 'Tipo',

R034FUN.NumCad 'Código cadastro (matrícula)',

CASE

WHEN R034FUN.NumCPF = 0 THEN ' '

WHEN R034FUN.NumCPF IS NULL THEN ' '

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 1)) THEN (SUBSTRING('0000000000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('0000000000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('0000000000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('0000000000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 2)) THEN (SUBSTRING('000000000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('000000000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('000000000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('000000000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 3)) THEN (SUBSTRING('00000000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('00000000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('00000000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('00000000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 4)) THEN (SUBSTRING('0000000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('0000000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('0000000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('0000000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 5)) THEN (SUBSTRING('000000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('000000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('000000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('000000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 6)) THEN (SUBSTRING('00000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('00000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('00000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('00000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 7)) THEN (SUBSTRING('0000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('0000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('0000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('0000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 8)) THEN (SUBSTRING('000' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('000' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('000' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('000' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 9)) THEN (SUBSTRING('00' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('00' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('00' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('00' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 10)) THEN (SUBSTRING('0' + CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING('0' + CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING('0' + CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING('0' + CONVERT(CHAR, R034FUN.NumCPF),10,2))

WHEN ((R034FUN.NumCPF <> 0) AND (LEN(R034FUN.NumCPF)= 11)) THEN (SUBSTRING(CONVERT(CHAR, R034FUN.NumCPF),1,3) + '.' + SUBSTRING(CONVERT(CHAR, R034FUN.NumCPF),4,3) + '.' + SUBSTRING(CONVERT(CHAR, R034FUN.NumCPF),7,3) + '-' + SUBSTRING(CONVERT(CHAR, R034FUN.NumCPF),10,2))

ELSE ''

END 'CPF',

R034FUN.NumEmp 'Código empresa',

R030EMP.NomEmp 'Razão social empresa',

R034FUN.CodFil 'Código filial',

R030FIL.NomFil 'Nome filial',

R030ORG.TabOrg 'Tabela organograma setor',

R016HIE.CodLoc 'Código setor',

R016ORN.NomLoc 'Nome setor',

R030CAR.EstCar 'Estrutura cargos',

R034FUN.CodCar 'Código cargo',

R024CAR.TitRed 'Nome cargo',

R010SIT.DesSit 'Situação',

CASE

WHEN (convert(varchar, R034FUN.DatAdm, 103) = '31/12/1900') THEN null

ELSE (convert(varchar, R034FUN.DatAdm, 103))

END 'Data admissão',

CASE

WHEN (convert(varchar, R038AFA.DatAfa, 103) = '31/12/1900') THEN null

ELSE (convert(varchar, R038AFA.DatAfa, 103))

END 'Data demissão'

FROM R034FUN

inner join R030EMP on (R030EMP.NumEmp = R034FUN.NumEmp)

inner join R030CAR on (R030CAR.NumEmp = R034FUN.NumEmp AND R030CAR.EstCar = R034FUN.EstCar AND R030CAR.DatAlt = (SELECT MAX(C.DATALT) FROM R030CAR C WHERE R030EMP.NumEmp = C.NumEmp AND C.DatAlt <= GETDATE()))

inner join R024CAR on (R024CAR.EstCar = R034FUN.EstCar AND R024CAR.CodCar = R034FUN.CodCar)

inner join R030ORG on (R030ORG.NumEmp = R034FUN.NumEmp AND R030ORG.TabOrg = R034FUN.TabOrg AND R030ORG.DatAlt = (SELECT MAX(O.DATALT) FROM R030ORG O WHERE R030EMP.NumEmp = O.NumEmp AND O.DatAlt <= GETDATE()))

inner join R016ORN on (R016ORN.TabOrg = R034FUN.TabOrg AND R016ORN.NumLoc = R034FUN.NumLoc)

inner join R016HIE on (R016HIE.TabOrg = R034FUN.TabOrg AND R016HIE.NumLoc = R034FUN.NumLoc AND R016HIE.DatIni = (SELECT MAX(H.DATINI) FROM R016HIE H WHERE R034FUN.TabOrg = H.TabOrg AND R034FUN.NumLoc = H.NumLoc AND H.DatIni <= GETDATE()))

inner join R030FIL on (R030FIL.NumEmp = R034FUN.NumEmp AND R030FIL.CodFil = R034FUN.CodFil)

inner join R010SIT on (R010SIT.CodSit = R034FUN.SitAfa)

left join R033PES on (R033PES.CodPES = R034FUN.CodPes)

left join R038AFA on (R038AFA.numemp = R034FUN.NumEmp AND R038AFA.TipCol = R034FUN.tipcol AND R038AFA.NumCad = R034FUN.numcad AND r038afa.sitafa in (SELECT S.codsit FROM r010sit S WHERE S.tipsit = 7))

WHERE R034FUn.tipcol IN (1,2)

ORDER BY 1,2,3,4

Observação

O comando acima considera também os colaboradores que estão demitidos.

ClosedOracle 
SELECT
	R034FUN.NomFun AS "Nome funcionário",
	CASE
		WHEN R034FUN.TipCol = 1 THEN '1-Empregado'
		WHEN R034FUN.TipCol = 2 THEN '2-Terceiro'
		WHEN R034FUN.TipCol = 3 THEN '3-Parceiro'
		ELSE 'Valor inválido'
	END AS "Tipo",
	R034FUN.NumCad AS "Código cadastro (matrícula)",
	CASE
		WHEN R034FUN.NumCPF = 0 THEN ' '
		WHEN R034FUN.NumCPF IS NULL THEN ' '
		ELSE (SUBSTR(LPAD(R034FUN.NumCPF, 11, '0'), 1, 3) || '.' || SUBSTR(LPAD(R034FUN.NumCPF, 11, '0'), 4, 3) || '.' || SUBSTR(LPAD(R034FUN.NumCPF, 11, '0'), 7, 3) || '-' || SUBSTR(LPAD(R034FUN.NumCPF, 11, '0'), 10, 2))
	END AS "CPF",
	R034FUN.NumEmp AS "Código empresa",
	R030EMP.NomEmp AS "Razão social empresa",
	R034FUN.CodFil AS "Código filial",
	R030FIL.NomFil AS "Nome filial",
	R030ORG.TabOrg AS "Tabela organograma setor",
	R016HIE.CodLoc AS "Código setor",
	R016ORN.NomLoc AS "Nome setor",
	R030CAR.EstCar AS "Estrutura cargos",
	R034FUN.CodCar AS "Código cargo",
	R024CAR.TitRed AS "Nome cargo",
	R010SIT.DesSit AS "Situação",
	CASE
		WHEN TO_CHAR(R034FUN.DatAdm,
		'DD/MM/YYYY') = '31/12/1900' THEN NULL
		ELSE TO_CHAR(R034FUN.DatAdm,
		'DD/MM/YYYY')
	END AS "Data admissão",
	CASE
		WHEN TO_CHAR(R038AFA.DatAfa,
		'DD/MM/YYYY') = '31/12/1900' THEN NULL
		ELSE TO_CHAR(R038AFA.DatAfa,
		'DD/MM/YYYY')
	END AS "Data demissão"
FROM
	R034FUN
INNER JOIN R030EMP ON
	(R030EMP.NumEmp = R034FUN.NumEmp)
INNER JOIN R030CAR ON
	(R030CAR.NumEmp = R034FUN.NumEmp
	AND R030CAR.EstCar = R034FUN.EstCar
	AND R030CAR.DatAlt = (
	SELECT
		MAX(C.DATALT)
	FROM
		R030CAR C
	WHERE
		R030EMP.NumEmp = C.NumEmp
		AND C.DatAlt <= SYSDATE))
INNER JOIN R024CAR ON
	(R024CAR.EstCar = R034FUN.EstCar
	AND R024CAR.CodCar = R034FUN.CodCar)
INNER JOIN R030ORG ON
	(R030ORG.NumEmp = R034FUN.NumEmp
	AND R030ORG.TabOrg = R034FUN.TabOrg
	AND R030ORG.DatAlt = (
	SELECT
		MAX(O.DATALT)
	FROM
		R030ORG O
	WHERE
		R030EMP.NumEmp = O.NumEmp
		AND O.DatAlt <= SYSDATE))
INNER JOIN R016ORN ON
	(R016ORN.TabOrg = R034FUN.TabOrg
	AND R016ORN.NumLoc = R034FUN.NumLoc)
INNER JOIN R016HIE ON
	(R016HIE.TabOrg = R034FUN.TabOrg
	AND R016HIE.NumLoc = R034FUN.NumLoc
	AND R016HIE.DatIni = (
	SELECT
		MAX(H.DATINI)
	FROM
		R016HIE H
	WHERE
		R034FUN.TabOrg = H.TabOrg
		AND R034FUN.NumLoc = H.NumLoc
		AND H.DatIni <= SYSDATE))
INNER JOIN R030FIL ON
	(R030FIL.NumEmp = R034FUN.NumEmp
	AND R030FIL.CodFil = R034FUN.CodFil)
INNER JOIN R010SIT ON
	(R010SIT.CodSit = R034FUN.SitAfa)
LEFT JOIN R033PES ON
	(R033PES.CodPES = R034FUN.CodPes)
LEFT JOIN R038AFA ON
	(R038AFA.numemp = R034FUN.NumEmp
	AND R038AFA.TipCol = R034FUN.tipcol
	AND R038AFA.NumCad = R034FUN.numcad
	AND r038afa.sitafa in (
	SELECT
		S.codsit
	FROM
		r010sit S
	WHERE
		S.tipsit = 7))
WHERE
	R034FUn.tipcol IN (1, 2)
ORDER BY 1, 2, 3, 4

Observação

O comando acima considera também os colaboradores que estão demitidos.

Filiais

Comandos do banco de dados para saneamento da base

ClosedSQL Server

SELECT

R030FIL.NumEmp 'Código empresa',

R030EMP.NomEmp 'Nome empresa',

R030FIL.CodFil 'Código filial',

R030FIL.NomFil 'Nome filial',

R030FIL.RazSoc 'Razão social filial',

CASE R030FIL.TipIns

WHEN 1 THEN 'CNPJ'

WHEN 2 THEN 'CEI'

WHEN 3 THEN 'CPF'

ELSE null

END 'Tipo inscrição',

CASE R030FIL.TipIns

WHEN 1 THEN

CASE

WHEN (REPLACE(R030FIL.NumCGC, '.', '') = null) THEN null

ELSE (SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),1,2) + '.' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),3,3) + '.' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),6,3) + '/' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),9,4) + '-' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),13,2))

END

WHEN 2 THEN

CASE

WHEN (REPLACE(R030FIL.NumCGC, '.', '') = null) THEN null

ELSE (SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),1,2) + '.' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),3,3) + '.' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),6,5) + '/' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),11,2))

END

WHEN 3 THEN

CASE

WHEN (REPLACE(R030FIL.NumCGC, '.', '') = null) THEN null

ELSE (SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),1,3) + '.' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),4,3) + '.' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),7,3) + '-' +

SUBSTRING(CONVERT(CHAR, REPLACE(R030FIL.NumCGC, '.', '')),10,2))

END

ELSE null

END 'Número inscrição',

CASE

WHEN (R030FIL.InsCei = 0) THEN null

ELSE R030FIL.InsCei

END 'Número inscrição CEI',

CASE

WHEN (R030FIL.NumCno = 0) THEN null

ELSE R030FIL.NumCno

END 'Número inscrição CNO',

CASE

WHEN (R030FIL.NCaepf = 0) THEN null

ELSE R030FIL.NCaepf

END 'Número inscrição CAEPF'

FROM R030FIL, R030EMP

WHERE

R030Emp.NumEmp = R030FIL.NumEmp

ORDER BY 1,3,4
ClosedOracle 
SELECT
    R030FIL.NumEmp "Código empresa",
    R030EMP.NomEmp "Nome empresa",
    R030FIL.CodFil "Código filial",
    R030FIL.NomFil "Nome filial",
    R030FIL.RazSoc "Razão social filial",
    CASE
        WHEN R030FIL.TipIns = 1 THEN 'CNPJ'
        WHEN R030FIL.TipIns = 2 THEN 'CEI'
        WHEN R030FIL.TipIns = 3 THEN 'CPF'
        ELSE null
    END "Tipo inscrição",
    CASE
        WHEN R030FIL.TipIns = 1 THEN
            CASE
                WHEN REPLACE(R030FIL.NumCGC, '.', '') IS NULL THEN NULL
                ELSE (SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 1, 2) || '.' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 3, 3) || '.' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 6, 3) || '/' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 9, 4) || '-' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 13, 2))
            END
        WHEN R030FIL.TipIns = 2 THEN
            CASE
                WHEN REPLACE(R030FIL.NumCGC, '.', '') IS NULL THEN NULL
                ELSE (SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 1, 2) || '.' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 3, 3) || '.' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 6, 5) || '/' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 11, 2))
            END
        WHEN R030FIL.TipIns = 3 THEN
            CASE
                WHEN REPLACE(R030FIL.NumCGC, '.', '') IS NULL THEN NULL
                ELSE (SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 1, 3) || '.' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 4, 3) || '.' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 7, 3) || '-' || SUBSTR(TO_CHAR(REPLACE(R030FIL.NumCGC, '.', '')), 10, 2))
            END
        ELSE NULL
    END "Número inscrição",
    CASE
        WHEN R030FIL.InsCei = 0 THEN NULL
        ELSE R030FIL.InsCei
    END "Número inscrição CEI",
    CASE
        WHEN R030FIL.NumCno = 0 THEN NULL
        ELSE R030FIL.NumCno
    END "Número inscrição CNO",
    CASE
        WHEN R030FIL.NCaepf = 0 THEN NULL
        ELSE R030FIL.NCaepf
    END "Número inscrição CAEPF"
FROM
    R030FIL,
    R030EMP
WHERE
    R030Emp.NumEmp = R030FIL.NumEmp
ORDER BY 1, 3, 4

Setores (Locais)

Comandos do banco de dados para saneamento da base

ClosedSQL Server

SELECT DISTINCT

R016HIE.TabOrg 'Tabela organograma',

R016HIE.CodLoc 'Código setor',

R016ORN.NomLoc 'Nome setor'

FROM R016ORN, R016HIE, R034FUN, R010SIT

WHERE R016ORN.TabOrg = R016HIE.TabOrg

AND R016ORN.NumLoc = R016HIE.NumLoc

AND R016HIE.DatIni = (SELECT MAX(DATINI) FROM R016HIE H

WHERE R016ORN.TabOrg = H.TabOrg

AND R016ORN.NumLoc = H.NumLoc

AND H.DatIni <= GETDATE())

AND (R016ORN.DatExt >= getdate() OR CAST(R016ORN.DatExt AS DATE) = '1900-12-31')

AND R016ORN.taborg = R034FUN.taborg

AND R016HIE.numloc = R034FUN.numloc

AND R034FUN.SITAFA = R010SIT.CODSIT

AND R010SIT.TIPSIT <> 7

ORDER BY 1,2,3
ClosedOracle 
SELECT DISTINCT 
    R016HIE.TabOrg "Tabela organograma",
    R016HIE.CodLoc "Código setor",
    R016ORN.NomLoc "Nome setor"
FROM
    R016ORN,
    R016HIE,
    R034FUN,
    R010SIT
WHERE
    R016ORN.TabOrg = R016HIE.TabOrg
    AND R016ORN.NumLoc = R016HIE.NumLoc
    AND R016HIE.DatIni = (
        SELECT
            MAX(DATINI)
        FROM
            R016HIE H
        WHERE
            R016ORN.TabOrg = H.TabOrg
            AND R016ORN.NumLoc = H.NumLoc
            AND H.DatIni <= SYSDATE)
    AND (R016ORN.DatExt >= SYSDATE
    OR TRUNC(R016ORN.DatExt) = TO_DATE('1900-12-31', 'YYYY-MM-DD'))
    AND R016ORN.taborg = R034FUN.taborg
    AND R016HIE.numloc = R034FUN.numloc
    AND R034FUN.SITAFA = R010SIT.CODSIT
    AND R010SIT.TIPSIT <> 7
ORDER BY 1, 2, 3

Cargos

Comandos do banco de dados para saneamento da base

ClosedSQL Server

SELECT DISTINCT

R024CAR.EstCar 'Estrutura cargo',

R024CAR.CodCar 'Código cargo',

R024CAR.TitRed 'Título cargo'

FROM R024CAR, R034FUN, R010SIT

WHERE (R024CAR.DatExt >= getdate() OR CAST(R024CAR.DatExt AS DATE) = '1900-12-31')

AND R024CAR.ESTCAR = R034FUN.ESTCAR

AND R024CAR.CODCAR = R034FUN.CODCAR

AND R034FUN.SITAFA = R010SIT.CODSIT

AND R010SIT.TIPSIT <> 7

ORDER BY 1,2,3
ClosedOracle 
SELECT DISTINCT 
    R024CAR.EstCar "Estrutura cargo",
    R024CAR.CodCar "Código cargo",
    R024CAR.TitRed "Título cargo"
FROM
    R024CAR,
    R034FUN,
    R010SIT
WHERE
    (R024CAR.DatExt >= SYSDATE
    OR TRUNC(R024CAR.DatExt) = TO_DATE('1900-12-31', 'YYYY-MM-DD'))
    AND R024CAR.ESTCAR = R034FUN.ESTCAR
    AND R024CAR.CODCAR = R034FUN.CODCAR
    AND R034FUN.SITAFA = R010SIT.CODSIT
    AND R010SIT.TIPSIT <> 7
ORDER BY 1, 2, 3

Este artigo ajudou você?

Base de Conhecimento

Portal de Exigências Legais

Documentação em outros idiomas:

English

Español

Senior Store

Universidade Corporativa

Fórum de Produtos

Trabalhe conosco

Blog

Todos os direitos de cópias reservadas para Senior Sistemas S.A.

A reprodução não autorizada desta publicação, no todo ou em parte, constitui violação dos direitos autorais (Lei 9.610/98).