Ver esquema da tabela
ColunaTipoPK
idTEXT✓
sequenciaINTEGER
descricaoTEXT
idade_minimaINTEGER
idade_maximaINTEGER
codigoTEXT
competencia_bpaTEXT
masculinoINTEGER
femininoINTEGER
procedimento_complexidadeINTEGER
tb_grupoINTEGER
tb_sub_grupoINTEGER
tb_forma_organizacaoINTEGER
filtro_padrao_esusINTEGER
codigo_sigtapINTEGER
idade_aplicavelINTEGER
tipoTEXT
planoINTEGER
exameINTEGER
padrao_dabINTEGER
esus_idINTEGER
ativoINTEGER
data_criacaoTEXT
data_alteracaoTEXT
idsequenciadescricaoidade_minimaidade_maximacodigocompetencia_bpamasculinofemininoprocedimento_complexidadetb_grupotb_sub_grupotb_forma_organizacaofiltro_padrao_esuscodigo_sigtapidade_aplicaveltipoplanoexamepadrao_dabesus_idativodata_criacaodata_alteracao
1632c102-274f-4469-a220-7397c2ac05ee1949REMOCAO DE CERUMEN DE CONDUTO AUDITIVO EXTERNO UNI / BILATERAL015710404010270202402112424300<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
57f48629-3eca-4972-b843-b598471d043f3273REIMPLANTE URETERAL EM ONCOLOGIA - URETEROCISTONEOSTOMIA015710416010180202402113457421<span class="null">NULL</span>1<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
4c8cd346-a8aa-4975-a391-3c3d419eecbf3274REIMPLANTE URETERAL EM ONCOLOGIA - URETEROENTEROSTOMIA015710416010199202402113457421<span class="null">NULL</span>1<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
de7ed830-d31a-49ce-9c28-a4ba061c950f3103REDUCAO MANUAL DE INVERSAO UTERINA AGUDA POS-PARTO1087310411010050202402012448371<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
244b185e-142f-4024-8e50-99349acd68033189REDUCAO MAMARIA EM PACIENTE C/ LIPODISTROFIA DECORRENTE DO USO DE ANTI-RETROVIRAIS22891104130300752024020134531321<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
bebd1745-50ab-4fba-80fa-2463ea44cddd5051TESTE DE HIBRIDIZAÇÃO DE SONDA EM LINHA DE 2ª LINHA PARA TUBERCULOSE (LPA)01571021301076320240211<span class="null">NULL</span>25215<span class="null">NULL</span><span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12024-09-18T00:29:30.356145+00:002024-09-18T00:29:30.356145+00:00
5533df93-12f5-450c-9986-400a2366aa895052TESTE RÁPIDO LF-LAM PARA TUBERCULOSE01571021401019820240211<span class="null">NULL</span>25516<span class="null">NULL</span><span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12024-09-18T00:29:30.356145+00:002024-09-18T00:29:30.356145+00:00
818ff58e-7483-46c4-8a66-284356edb0372768REDUCAO INCRUENTA DE FRATURA OU LESAO FISARIA DO JOELHO0157104080502502024021124411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
eda602e8-ee26-4720-9e2f-12e6a541c2cc2769REDUCAO INCRUENTA DE LUXACAO / FRATURA-LUXACAO DO JOELHO0157104080502682024021124411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
ec5f2635-c72f-400d-82d8-07dd02a810c74576REFLEXO ESTAPEDIANO ELICIADO ELETRICAMENTE0157102110704082024021132492251<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
537e754c-313d-4369-8099-0cc56b8dbff03019REIMPLANTE DE PENIS0157104090500912024021024421881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
791e296e-e577-46f5-bd94-25eee37f40452577REDUCAO INCRUENTA DE LUXACAO / FRATURA-LUXACAO E METACARPO-FALANGIANA / METATARSO-FALANGIANA / INTER-FALANGIANA015710408020237202402112441881<span class="null">NULL</span>1<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
a1991802-9121-4a4d-889a-a67ae8cb15e92100REMOÇÃO DE IMPLANTE EPISCLERAL0157104050302312024021124291261<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
568a0fca-9ff4-4dbb-b85b-df56945612322469REDUCAO MANUAL DE PROCIDENCIA DE RETO015710407020373202402112438871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
d545f5ab-dfcf-47ce-93b6-474b60f30c342470REMOCAO CIRURGICA DE FECALOMA015710407020381202402112438871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
e8a24721-28c5-453d-979d-84e15025f0142543REDUCAO INCRUENTA DE FRATURA E FRATURA-LUXACAO AO NIVEL DA CINTURA ESCAPULAR015710408010126202402112441341<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
1c053031-a56e-43ad-bf5f-87c87e279e4f2574REDUÇÃO INCRUENTA DE FRATURA DIAFISARIA DOS OSSOS DO ANTEBRAÇO015710408020202202402112441881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
26b19d1e-5da7-424b-bdda-ced9355438ed2575REDUÇÃO INCRUENTA DE FRATURA DOS METACARPIANOS015710408020210202402112441881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
69f34c85-facb-4b6f-ad2b-734d109446e92578REDUÇÃO INCRUENTA DE LUXAÇÃO OU FRATURA / LUXACAO NO PUNHO015710408020245202402112441881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
1d0913ed-2ad1-4514-8b94-432ba611bdb52579REIMPLANTE DO OMBRO ATÉ O TERÇO MÉDIO DO ANTEBRAÇO015710408020253202402113441881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
035cde06-8327-4103-9a11-3b64d4dc8b072580REIMPLANTE DO TERÇO DISTAL DO ANTEBRAÇO ATÉ OS METACARPIANOS015710408020261202402113441881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
d98d1489-9660-4d8f-bfbf-43ebb4c79b462582REIMPLANTE OU REVASCULARIZAÇÃO DO POLEGAR015710408020288202402113441881<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
969c05e8-65d8-478b-8ad9-447cee2929052726REDUÇÃO INCRUENTA DE LUXAÇÃO CONGÊNITA COXOFEMORAL03504080401812024021124411631<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
d81c8adc-69c7-4130-bcd8-9ddea1ab1b272727REDUÇÃO INCRUENTA DE LUXAÇÃO COXOFEMORAL TRAUMÁTICA / PÓS-ARTROPLASTIA0157104080401902024021124411631<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
134ddddc-f03d-49b1-9e9c-bce36b6d643b2728REDUÇÃO INCRUENTA DISJUNÇÃO / LUXAÇÃO / FRATURA / FRATURA-LUXAÇÃO AO NÍVEL DO ANEL PÉLVICO0157104080402032024021124411631<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
507c7061-c509-4097-a555-71e6ef8f33e52765REDUCAO INCRUENTA DE FRATURA DIAFISARIA / LESAO FISARIA DISTAL DA TIBIA C/ OU S/ FRATURA DA FIBULA0157104080502252024021124411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
a43a4522-010d-461c-b971-b05b833cd03a2766REDUCAO INCRUENTA DE FRATURA DIAFISARIA / LESAO FISARIA PROXIMAL DO FEMUR0157104080502332024021124411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
21027785-af93-4095-b719-1e18030f947c2767REDUCAO INCRUENTA DE FRATURA DOS OSSOS DO TARSO0157104080502412024021124411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
39360e24-692d-49df-b635-faadf69b674a2770REDUCAO INCRUENTA DE LUXACAO FEMURO-PATELAR0157104080502762024021124411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
c2d05ba4-4d02-4f73-ba6d-284874e7e5932774REIMPLANTE DO TERCO MEDIO DA PERNA ATE O PE0157104080503142024021134411871<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
fdb73527-a2fd-4b3f-ab2c-f7b6646908c05055INVESTIGAÇÃO DA RELAÇÃO DA DOENÇA OU AGRAVO RELACIONADO AO TRABALHO PARA FINS EPIDEMIOLÓGICOS601571030102005120240211<span class="null">NULL</span>31107<span class="null">NULL</span><span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12024-09-18T00:29:30.356145+00:002024-09-18T00:29:30.356145+00:00
e7b6d289-7bbc-4d95-9baf-e65b8292fef25056ESTIMULAÇÃO PRECOCE RELACIONADA AO NEURODESENVOLVIMENTO NA ATENÇÃO ESPECIALIZADA047030107029620240211<span class="null">NULL</span>31224<span class="null">NULL</span><span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12024-09-18T00:29:30.356145+00:002024-09-18T00:29:30.356145+00:00
3d4c7162-9816-443f-9473-1945b9c794383241REIMPLANTE E TRANSPLANTE DENTAL (POR ELEMENTO)60157104140202432024021124541091<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
fc0a2aa3-737f-4623-9d66-1e608dd5d4b03242REMOÇÃO DE DENTE RETIDO (INCLUSO / IMPACTADO)0157104140202782024021124541091<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
c68f75dd-0ff3-4d74-b77d-a222e07cf4804449REMOÇÃO DE CORPO ESTRANHO DA CAVIDADE AUDITIVA E NASAL01571ABPG01520240211142430019521CLINICO101<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
6b69909c-c507-4d08-a491-451a535a7ce8326PESQUISA DE ANTICORPOS CONTRA ANTIGENO DE SUPERFICIE DO VIRUS DA HEPATITE B (ANTI-HBS)015710202030636202402112291341<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.278000+00:002021-05-25T19:39:57.278000+00:00
ec592965-15f8-489c-a207-4ac9978a745c350PESQUISA DE ANTICORPOS IGM ANTITOXOPLASMA015710202030873202402112291341<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.279000+00:002021-05-25T19:39:57.279000+00:00
d0a931c5-7c4c-4abb-aff2-5db96ee4f0631706REEMBASAMENTO E CONSERTO DE PROTESE DENTARIA180157103070400892024021123361561<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
a65e9382-332c-4555-aa7c-91ebe85048f61359REMOCAO MANUAL DE FECALOMA0157103030700302024021113212311<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
9dde4249-3189-44fb-9b89-0d6afb5dbdab3291RESSECÇÃO DE GLANDULA SALIVAR MENOR EM ONCOLOGIA144157104160300252024021134571431<span class="null">NULL</span>1<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
d4f9e136-57cc-4de7-bf6e-eb0323c442162972RESSECCAO DE CARUNCULA URETRAL015710409020087202402112442891<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
16627cb8-3b12-41c5-98eb-747f699870882856RESSECÇÃO DE CISTO SINOVIAL0157104080602122024021124412141<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
5dff3f19-6957-40bd-a21e-24acfdca99993993REPOSIÇÃO DE AASI EXTERNO DE CONDUÇÃO ÓSSEA RETROAURICULAR TIPO A999999990701030178202402110751181<span class="null">NULL</span>0<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
cc3908d3-e58c-41ca-af5e-a94350b69cd31106REMOCAO EM AMBULANCIA DE SIMPLES TRANSPORTE (AMBULANCIA TIPO A)015710301030154202402112311411<span class="null">NULL</span>1ADMINISTRATIVO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
ca55dc40-eed5-4485-82a4-a7512d78cf0d1983RESSECÇÃO DE GLÂNDULA SALIVAR2415710404020070202402112424841<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
ac1e9f61-d675-4849-869c-c2ce4b6c7b5b2237REPOSICIONAMENTO DE ELETRODOS DE CARDIOVERSOR DESFIBRILADOR015710406010854202402113434321<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
ece86c55-c0b8-423d-b233-135103ccc5b22240RESSECCAO DE ENDOMIOCARDIOFIBROSE015710406010889202402113434321<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
9c635bbb-e5a5-46b6-97c2-e5896f8227bf2527REPARACAO DE OUTRAS HERNIAS0157104070402262024021124381621<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
5dabd8aa-2b33-4f63-a2eb-fffe31bda5b72545REPARO DE ROTURA DO MANGUITO ROTADOR (INCLUI PROCEDIMENTOS DESCOMPRESSIVOS)2409710408010142202402112441341<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
cf3a3a97-31ad-49b8-8942-5d05c69545542667RESSECÇÃO DE 2 OU MAIS CORPOS VERTEBRAIS CERVICAIS0157104080305002024021134411291<span class="null">NULL</span>1CLINICO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00