...
Bloco de código | ||||
---|---|---|---|---|
| ||||
SELECT
BEA_ANOAUT AS AnoAutorizacao,
BEA_ATERNA AS AtendimentoRecemNascido,
BEA_AUDITO AS Auditoria,
BEA_CANCEL AS Cancelado,
BEA_CANEDI AS CancelamentoEDI,
BEA_MATRIC AS CodigoFamilia,
BEA_CODEMP AS CodigoGrpEmpresa,
BEA_CODLOC AS CodigoLocalAtendimento,
BEA_CDPFRE AS CodigoProfissionalResponsavel,
BEA_CDPFSO AS CodigoProfissionalSolicitante,
BEA_CODRDA AS CodigoPrestador,
BEA_TIPREG AS CodigoTipoBeneficiario,
BEA_TIPSAI AS CodigoTipoSaida,
BEA_DATPRO AS DataProcessamento,
BEA_DATSOL AS DataSolicitacao,
BEA_ESPEXE AS EspecialidadeExecutante,
BEA_ESPSOL AS EspecialidadeSolicitante,
BEA_ESTEXE AS EstadoExecutante,
BEA_ESTSOL AS EstadoSolicitante,
BEA_INDACI AS IndicacaoAcidente,
BEA_INDCLI AS IndicacaoClinica,
BEA_LIBERA AS Liberacao,
BEA_LOCAL AS LocalAtendimento,
BEA_MESAUT AS MesAutorizacao,
BEA_NUMAUT AS NumeroAutorizacao,
BEA_GUIPRI AS NumeroGuiaPrincipal,
BEA_NRLBOR AS NumeroLiberacaoOriginal,
BEA_NUMTIT AS NumeroTituloContasRec,
BEA_OPEMOV AS OperadoraMovimentacao,
BEA_OPEUSR AS OperadoraUsuario,
BEA_PARCEL AS Parcela,
BEA_PREFIX AS Prefixo,
BEA_PROATE AS ProtocoloAtendimento,
BEA_REGEXE AS RegistroExecutante,
BEA_REGSOL AS RegistroSolicitante,
BEA_SENHA AS Senha,
BEA_SIGLA AS SiglaConselho,
BEA_SIGEXE AS SiglaConselhoExecutante,
BEA_STATUS AS Status,
BEA_STALIB AS StatusLiberacao,
BEA_STTISS AS StatusTISS,
BEA_TIPADM AS TipoAdmissao,
BEA_TIPATE AS TipoAtendimento,
BEA_TIPCON AS TipoConsulta,
BEA_TIPO AS TipoGuia,
BEA_TIPTIT AS TipoTituloContasRec,
BEA_VALSEN AS ValidadeSenhaAtendimento,
BEA_OPEMOV + BEA_ANOAUT + BEA_MESAUT + BEA_NUMAUT AS NumeroGuiaOperadora,
BEA.D_E_L_E_T_ AS Deletado
FROM BEA010 BEA
INNER JOIN BCI010 BCI
ON BEA_FILIAL = BCI_FILIAL
AND BEA_OPEMOV = BCI_CODOPE
AND BEA_CODPEG = BCI_CODPEG
AND BEA_CODRDA = BCI_CODRDA
AND BCI_CODLDP = '9999'
AND BCI_FASE <> '4'
WHERE 1=1
AND BEA.S_T_A_M_P_ > (DATEADD(HOUR, -1, GETUTCDATE()))
AND BEA_OPEMOV = '0001'
AND BEA_ORIMOV = '1'
AND BEA_TIPGUI = '01'
AND BEA_LIBERA = '0'
AND BEA_NUMGUI <> ''
|
Observação: Para a view de carga inicial, basta remover o filtro de STAMP.