...
Bloco de código | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
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,
|
Observação: Para a view de carga inicial, basta remover o filtro de STAMP.