Histórico da Página

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