...
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, 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 <> '' 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 <> '' |
...