Ver esquema da tabela
ColunaTipoPK
idTEXT
protocoloTEXT
codigo_ibgeTEXT
usuario_envioTEXT
data_protocoloTEXT
situacaoTEXT
tipo_servicoTEXT
tipo_operacaoTEXT
exportacao_horusTEXT
ativoINTEGER
data_criacaoTEXT
data_alteracaoTEXT
idprotocolocodigo_ibgeusuario_enviodata_protocolosituacaotipo_servicotipo_operacaoexportacao_horusativodata_criacaodata_alteracao
8a6b8dfe-e18c-49d3-963f-30aa5b4c9cf0199086588420917gabifar2026-06-22SUCESSO41{"protocolo": 199086588, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-22T22:00:11.869", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-23T01:00:12.129026+00:002026-06-23T01:00:12.129026+00:00
00e0d7cf-c003-4ff4-8ee7-4746c542c701199509916420917gabifar2026-06-23SUCESSO21{"protocolo": 199509916, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-23T22:00:06.568", "situacao": 1, "tipoServico": 2, "tipoOperacao": 1}12026-06-24T01:00:06.606792+00:002026-06-24T01:00:06.606792+00:00
89012245-9e19-4431-9ff6-f87b0787a1dc197883107420917gabifar2026-06-19SUCESSO41{"protocolo": 197883107, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-19T22:00:50.313", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-20T01:00:50.512806+00:002026-06-20T01:00:50.512806+00:00
b88d6a97-3db1-45c8-a486-eb0143b5870e198309846420917gabifar2026-06-20SUCESSO41{"protocolo": 198309846, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-20T22:00:09.383", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-21T01:00:09.448189+00:002026-06-21T01:00:09.448189+00:00
fbc40df7-2adc-496d-bcda-08dba11a7cd4198655647420917gabifar2026-06-21SUCESSO41{"protocolo": 198655647, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-21T22:00:11.057", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-22T01:00:11.348459+00:002026-06-22T01:00:11.348459+00:00
424467c4-61f6-40e3-ad98-8b7c56ab2ed7199509922420917gabifar2026-06-23SUCESSO41{"protocolo": 199509922, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-23T22:00:09.202", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-24T01:00:09.688980+00:002026-06-24T01:00:09.688980+00:00
1903a640-197b-445f-b8cd-07c2db53e54a199818212420917gabifar2026-06-24SUCESSO41{"protocolo": 199818212, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-24T22:00:10.7", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-25T01:00:11.071179+00:002026-06-25T01:00:11.071179+00:00
d2579f51-e3a2-49cb-a5a5-9c66b78cd14c200209880420917gabifar2026-06-25SUCESSO41{"protocolo": 200209880, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-25T22:00:09.894", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-26T01:00:10.200320+00:002026-06-26T01:00:10.200320+00:00
1e0a18a0-9f21-4328-bc79-3cc02fe18985200623926420917gabifar2026-06-26SUCESSO41{"protocolo": 200623926, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-26T22:00:08.964", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-27T01:00:09.227819+00:002026-06-27T01:00:09.227819+00:00
0deaf94e-2c68-40ff-8b5b-36bd28fa550a200935160420917gabifar2026-06-27SUCESSO41{"protocolo": 200935160, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-27T22:00:07.98", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-28T01:00:08.162409+00:002026-06-28T01:00:08.162409+00:00
0d4477f0-77e6-4d3b-9855-e7705f0aeee2201249813420917gabifar2026-06-28SUCESSO41{"protocolo": 201249813, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-28T22:00:08.756", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-29T01:00:09.075769+00:002026-06-29T01:00:09.075769+00:00
9ef0f1ea-2423-45d8-bce8-85b813576158201596621420917gabifar2026-06-29SUCESSO41{"protocolo": 201596621, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-29T22:00:09.546", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-06-30T01:00:09.714886+00:002026-06-30T01:00:09.714886+00:00
cf5288ee-4851-4c62-87ba-ce74ad4d0125202001807420917gabifar2026-06-30SUCESSO21{"protocolo": 202001807, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-30T22:00:05.784", "situacao": 1, "tipoServico": 2, "tipoOperacao": 1}12026-07-01T01:00:05.839268+00:002026-07-01T01:00:05.839268+00:00
b2f0cec9-54a9-4b62-892d-d971baabd446202001839420917gabifar2026-06-30SUCESSO41{"protocolo": 202001839, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-06-30T22:00:10.058", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-01T01:00:10.244907+00:002026-07-01T01:00:10.244907+00:00
f188041e-f3f3-4f96-b57e-96b3e405fb2e202411383420917gabifar2026-07-01SUCESSO41{"protocolo": 202411383, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-01T22:00:10.094", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-02T01:00:10.404363+00:002026-07-02T01:00:10.404363+00:00
fd87b365-444b-4743-983f-b5f5fb13ed59202797598420917gabifar2026-07-02SUCESSO41{"protocolo": 202797598, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-02T22:00:10.658", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-03T01:00:10.777610+00:002026-07-03T01:00:10.777610+00:00
2d8ed036-4e7b-46b6-8dec-8c10fa3c2b4a203245254420917gabifar2026-07-03SUCESSO41{"protocolo": 203245254, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-03T22:00:11.202", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-04T01:00:11.445908+00:002026-07-04T01:00:11.445908+00:00
f71e53de-b551-474f-90f6-837d0d35a960203617051420917gabifar2026-07-04SUCESSO41{"protocolo": 203617051, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-04T22:00:09.083", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-05T01:00:09.227971+00:002026-07-05T01:00:09.227971+00:00
a13b0e7b-cd95-4660-94b5-687a1fedd272203996767420917gabifar2026-07-05SUCESSO41{"protocolo": 203996767, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-05T22:00:07.687", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-06T01:00:07.959094+00:002026-07-06T01:00:07.959094+00:00
73878e39-65ad-4e2d-928e-db1b52a9cd2f204353205420917gabifar2026-07-06SUCESSO41{"protocolo": 204353205, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-06T22:00:09.581", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-07T01:00:09.891004+00:002026-07-07T01:00:09.891004+00:00
6aee886c-bb92-4b5d-b13a-027d7af6a700204739212420917gabifar2026-07-07SUCESSO41{"protocolo": 204739212, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-07T22:00:11.474", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-08T01:00:11.662144+00:002026-07-08T01:00:11.662144+00:00
b5996f0f-4891-4d13-9370-bbb20fcf16ff205073807420917gabifar2026-07-08SUCESSO41{"protocolo": 205073807, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-08T22:00:11.429", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-09T01:00:11.663959+00:002026-07-09T01:00:11.663959+00:00
fef8e151-8083-469b-9051-6dab7c9e2f8a205398974420917gabifar2026-07-09SUCESSO41{"protocolo": 205398974, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-09T22:00:10.644", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-10T01:00:10.859027+00:002026-07-10T01:00:10.859027+00:00
dc52b487-3f26-45aa-9800-ada6d33f25d6205750379420917gabifar2026-07-10SUCESSO41{"protocolo": 205750379, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-10T22:00:10.223", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-11T01:00:10.716114+00:002026-07-11T01:00:10.716114+00:00
b2faebe2-be11-42c7-a387-18df32794b00206049716420917gabifar2026-07-11SUCESSO41{"protocolo": 206049716, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-11T22:00:09.8", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-12T01:00:09.994261+00:002026-07-12T01:00:09.994261+00:00
f84f747d-0283-41bc-b3ec-3754eee1b40f206350449420917gabifar2026-07-12SUCESSO41{"protocolo": 206350449, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-12T22:00:09.644", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-13T01:00:10.008604+00:002026-07-13T01:00:10.008604+00:00
ac552689-8f9f-4285-a917-a113a7234fc1206702387420917gabifar2026-07-13SUCESSO41{"protocolo": 206702387, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-13T22:00:09.812", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-14T01:00:09.994297+00:002026-07-14T01:00:09.994297+00:00
9ac149e0-3d59-46bf-b99e-dff0d286d72c207071958420917gabifar2026-07-14SUCESSO41{"protocolo": 207071958, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-14T22:00:09.781", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-15T01:00:10.010891+00:002026-07-15T01:00:10.010891+00:00
733c796b-cf5a-4c4d-8bce-1bb7fed3b6f6207468187420917gabifar2026-07-15SUCESSO41{"protocolo": 207468187, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-15T22:00:09.991", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-16T01:00:10.413511+00:002026-07-16T01:00:10.413511+00:00
ba66b880-1d3d-40dd-bfd1-5f73ba0cc2fb207869157420917gabifar2026-07-16SUCESSO41{"protocolo": 207869157, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-16T22:00:10.777", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-17T01:00:11.048831+00:002026-07-17T01:00:11.048831+00:00
f9ccae82-fecd-4b46-92f1-8851ddf0fdc8208259661420917gabifar2026-07-17SUCESSO21{"protocolo": 208259661, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-17T22:00:08.054", "situacao": 1, "tipoServico": 2, "tipoOperacao": 1}12026-07-18T01:00:08.097017+00:002026-07-18T01:00:08.097017+00:00
b7d89dbb-ba8d-4d26-8890-b8289c584ad7208259680420917gabifar2026-07-17SUCESSO41{"protocolo": 208259680, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-17T22:00:10.569", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-18T01:00:10.814009+00:002026-07-18T01:00:10.814009+00:00
455f4546-aa81-4cee-af19-08871831997b208593760420917gabifar2026-07-18SUCESSO41{"protocolo": 208593760, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-18T22:00:10.008", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-19T01:00:10.173735+00:002026-07-19T01:00:10.173735+00:00
418c3946-04ec-441e-b6b7-cbc93b11cbe8208936593420917gabifar2026-07-19SUCESSO41{"protocolo": 208936593, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-19T22:00:10.815", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-20T01:00:11.018893+00:002026-07-20T01:00:11.018893+00:00
2da01351-cf63-4a45-8f41-7de75485952f209337912420917gabifar2026-07-20SUCESSO41{"protocolo": 209337912, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-20T22:00:10.906", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-21T01:00:11.176707+00:002026-07-21T01:00:11.176707+00:00
b213cb9d-d501-4738-b9f2-364dc1ea239f209629410420917gabifar2026-07-21SUCESSO41{"protocolo": 209629410, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-21T22:00:09.19", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-22T01:00:09.265165+00:002026-07-22T01:00:09.265165+00:00
a36ccc4a-caa9-4fea-ab2f-6a35d9750287210037133420917gabifar2026-07-22SUCESSO41{"protocolo": 210037133, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-22T22:00:10.065", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-23T01:00:10.121246+00:002026-07-23T01:00:10.121246+00:00
764e9bd3-b62b-4ea2-9970-01112f686cc4210446298420917gabifar2026-07-23SUCESSO21{"protocolo": 210446298, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-23T22:00:08.493", "situacao": 1, "tipoServico": 2, "tipoOperacao": 1}12026-07-24T01:00:08.536817+00:002026-07-24T01:00:08.536817+00:00
6e9ba361-9e55-45ca-a7a3-f0af0c6482bc210446302420917gabifar2026-07-23SUCESSO41{"protocolo": 210446302, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-23T22:00:11.651", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-24T01:00:11.706062+00:002026-07-24T01:00:11.706062+00:00
ec69c15a-6969-4f19-a7c4-416d032f9b57210841883420917gabifar2026-07-24SUCESSO41{"protocolo": 210841883, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-24T22:00:12.881", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-25T01:00:12.951312+00:002026-07-25T01:00:12.951312+00:00
fd860f76-1f0d-4ef8-9129-6b344ff374c1<span class="null">NULL</span>420917<span class="null">NULL</span>ERRO41{"message": "Erro na requisição HTTP: Post \"https://servicos.saude.gov.br/bnafar/produto/ibge/420917/posicao-estoque-lote/\": read tcp 10.15.1.100:34090-&gt;189.28.130.14:443: read: connection reset by peer"}12026-07-26T01:00:11.082159+00:002026-07-26T01:00:11.082159+00:00
ff43e396-d213-4c9b-82a3-97e177e7e48f<span class="null">NULL</span>420917<span class="null">NULL</span>ERRO41{"message": "Erro na requisição HTTP: Post \"https://servicos.saude.gov.br/bnafar/produto/ibge/420917/posicao-estoque-lote/\": read tcp 10.15.1.100:19168-&gt;189.28.130.14:443: read: connection reset by peer"}12026-07-27T01:00:12.127999+00:002026-07-27T01:00:12.127999+00:00
6dac07da-cdea-4b6d-a5cc-6b766116d878<span class="null">NULL</span>420917<span class="null">NULL</span>ERRO21{"message": "Erro ao obter token"}12026-07-28T01:00:16.522563+00:002026-07-28T01:00:16.522563+00:00
0e2413af-bc51-492f-94d1-776f0412a255<span class="null">NULL</span>420917<span class="null">NULL</span>ERRO41{"message": "Erro ao obter token"}12026-07-28T01:00:24.704703+00:002026-07-28T01:00:24.704703+00:00
49fcb3a2-bc4a-4fc0-a180-c808b6ae9672211511858420917gabifar2026-07-28SUCESSO21{"protocolo": 211511858, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-28T22:00:11.861", "situacao": 1, "tipoServico": 2, "tipoOperacao": 1}12026-07-29T01:00:11.917953+00:002026-07-29T01:00:11.917953+00:00
d2773e08-0176-409c-8558-98d8e27c104c211511863420917gabifar2026-07-28SUCESSO41{"protocolo": 211511863, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-28T22:00:15.674", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-29T01:00:15.738314+00:002026-07-29T01:00:15.738314+00:00
8611d96f-1a4c-4be3-bd56-65c5c3e31319211894573420917gabifar2026-07-29SUCESSO41{"protocolo": 211894573, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-29T22:00:13.29", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-30T01:00:13.346050+00:002026-07-30T01:00:13.346050+00:00
eaa0900c-2d93-472d-94a4-42874fe8d191212152171420917gabifar2026-07-30SUCESSO41{"protocolo": 212152171, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-30T22:00:12.91", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-07-31T01:00:12.971696+00:002026-07-31T01:00:12.971696+00:00
3a298fc2-37b6-4101-840c-85f59a581603212414701420917gabifar2026-07-31SUCESSO41{"protocolo": 212414701, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-07-31T22:00:13.273", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-08-01T01:00:13.348185+00:002026-08-01T01:00:13.348185+00:00
7065f774-84d5-48e0-ae42-243f9c1a612b212699285420917gabifar2026-08-01SUCESSO41{"protocolo": 212699285, "codigoIbge": "420917", "usuarioEnvio": "gabifar", "dataProtocolo": "2026-08-01T22:00:09.874", "situacao": 1, "tipoServico": 4, "tipoOperacao": 1}12026-08-02T01:00:09.946161+00:002026-08-02T01:00:09.946161+00:00