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
c2b555e8-1731-4399-913a-42405eb6fa0b2894TRATAMENTO CIRÚRGICO DE FRATURA VICIOSAMENTE CONSOLIDADA DOS OSSOS LONGOS EXCETO DA MÃO E DO PÉ60157104080605902024021124412141<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.286000+00:002021-05-25T19:39:57.286000+00:00
be77f2ed-241c-4652-a7d6-108d640d8e752904TRATAMENTO CIRÚRGICO DE SINDACTILIA COMPLEXA (C/ FUSÃO ÓSSEA)0157104080606972024021134412141<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.287000+00:002021-05-25T19:39:57.287000+00:00
b1b9b3b4-8fee-4890-a767-59b9470b4bed2905TRATAMENTO CIRÚRGICO DE SINDACTILIA SIMPLES (DOIS DEDOS)0157104080607002024021124412141<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.287000+00:002021-05-25T19:39:57.287000+00:00
c778854f-747e-48a3-9586-058f569442482906VIDEOARTROSCOPIA0157104080607192024021124412141<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.289000+00:002021-05-25T19:39:57.289000+00:00
71c8e0dc-fc03-498a-ab9a-28a579b664df2908CISTECTOMIA PARCIAL015710409010022202402112442351<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.269000+00:002021-05-25T19:39:57.269000+00:00
a8675676-c9ae-46eb-8311-6b777beb1b522909CISTECTOMIA TOTAL015710409010030202402112442351<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.269000+00:002021-05-25T19:39:57.269000+00:00
fd42e9b5-b32b-4aa3-96e7-93664c98eb2e3060COLPOTOMIA0157104090701062024020124422281<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.270000+00:002021-05-25T19:39:57.270000+00:00
3ae72d20-92f5-4d08-ab89-10d46989ae633084EXERESE DE MAMILO015710410010049202402112445361<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.274000+00:002021-05-25T19:39:57.274000+00:00
1f607105-ebf6-4021-960f-e9194036951f3086MASTECTOMIA SIMPLES12015710410010065202402112445361<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.276000+00:002021-05-25T19:39:57.276000+00:00
dcbbcc77-8c97-40d7-8f70-13d52c47e9c53087PLASTICA MAMARIA FEMININA NAO ESTETICA12015710410010073202402012445361<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.279000+00:002021-05-25T19:39:57.279000+00:00
94d91b32-8381-41db-b8b5-497cc75e77973088PLASTICA MAMARIA MASCULINA015710410010081202402102445361<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.279000+00:002021-05-25T19:39:57.279000+00:00
507d532e-5c06-49a1-8ea1-6caea3e74a253089PLASTICA MAMARIA RECONSTRUTIVA - POS MASTECTOMIA C/ IMPLANTE DE PROTESE19215710410010090202402012445361<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.279000+00:002021-05-25T19:39:57.279000+00:00
67b5e0dc-dcfa-42cf-9527-565ca92bffff3090REVERSAO DE MAMILO INVERTIDO015710410010103202402012445361<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.283000+00:002021-05-25T19:39:57.283000+00:00
51b4f73a-420b-43de-8439-b412b1ef14873070OPERACAO DE BURCH360157104090702032024020124422281<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.277000+00:002021-05-25T19:39:57.277000+00:00
4443d0b9-d26d-40de-98ec-55ae1df0e5283104RESSUTURA DE EPISIORRAFIA POS-PARTO967310411010069202402012448371<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.283000+00:002021-05-25T19:39:57.283000+00:00
3d3de172-d77a-4cfe-be97-52bb54d836f23071RECONSTRUCAO DA VAGINA0157104090702112024020124422281<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
042b594e-aa93-416a-b059-18f1e361630d3132DESCORTICAÇÃO PULMONAR0157104120300122024021124501311<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.271000+00:002021-05-25T19:39:57.271000+00:00
0ae5b9a2-36ad-4058-8690-d776e8f3072f1180ACOMPANHAMENTO DE PESSOAS COM NECESSIDADES DECORRENTES DO USO DE ÁLCOOL, CRACK E OUTRAS DROGAS EM SERVIÇO RESIDENCIAL DE CARÁTER TRANSITÓRIO (COMUNIDADES TERAPÊUTICAS).21615710301080364202402112312401<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.264000+00:002021-05-25T19:39:57.264000+00:00
86ec16f8-3655-4ffa-847c-657d72b0125f1982ENXERTO TOTAL / PARCIAL INTRATEMPORAL DE NERVO FACIAL015710404020062202402112424841<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.273000+00:002021-05-25T19:39:57.273000+00:00
a2261f8f-c4ed-4a45-b678-e922cdfe80c91994RECONSTRUÇÃO TOTAL OU PARCIAL DE NARIZ015710404020240202402113424841<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
118d0d3c-1f3d-4ddd-8e54-ed9ce34dc9ef2306PONTE AXILO-FEMURAL015710406020329202402113434861<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.280000+00:002021-05-25T19:39:57.280000+00:00
f4a05758-dd38-47e5-8a46-16bbbf65840d3197DERMOLIPECTOMIA CRURAL POS-CIRURGIA BARIÁTRICA216157104130400702024021134531441<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.271000+00:002021-05-25T19:39:57.271000+00:00
b6896e23-736d-41c5-899f-7adc2a82c4ec4551VIGILÂNCIA DA SITUAÇÃO DE SAÚDE DOS TRABALHADORES9999999901020200192024021121103781<span class="null">NULL</span>0ADMINISTRATIVO<span class="null">NULL</span><span class="null">NULL</span>0<span class="null">NULL</span>12021-05-25T19:39:57.289000+00:002021-05-25T19:39:57.289000+00:00
376e1ef2-da1d-49a2-b8b4-d95b4e9056501173ATENÇÃO ÀS SITUAÇÕES DE CRISE015710301080291202402112312401<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.266000+00:002021-05-25T19:39:57.266000+00:00
f42ad67f-0487-4f86-988f-0b404d2f23283507TRANSPLANTE DE CORNEA015710505010097202402113531491<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.285000+00:002021-05-25T19:39:57.285000+00:00
f9f0b477-261d-43cf-9e73-939b54cff6b11652HEMODIÁLISE EM PACIENTE COM SOROLOGIA POSITIVA PARA HIV E/OU HEPATITE B E/OU HEPATITE C (MÁXIMO 3 SESSÕES POR SEMANA)015710305010115202402113328211<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.274000+00:002021-05-25T19:39:57.274000+00:00
d89d554b-5edc-4c02-bdc2-21179fad8e5a2544REDUCAO INCRUENTA DE LUXAÇÃO OU FRATURA / LUXAÇÃO ESCÁPULO-UMERAL015710408010134202402112441341<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
48ad4d4f-67a0-4b47-9f35-19e3352ca4c12616TRATAMENTO CIRÚRGICO DE SINDACTILIA DA MÃO (POR ESPACO INTERDIGITAL)015710408020628202402112441881<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.287000+00:002021-05-25T19:39:57.287000+00:00
f50aae99-5489-4948-b903-3e4f97c8f1c52653DESCOMPRESSÃO DA JUNÇÃO CRANIO-CERVICAL VIA TRANSORAL / RETROFARINGEA0157104080303562024021134411291<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.271000+00:002021-05-25T19:39:57.271000+00:00
088616cd-9ce3-493e-b9a9-84398394c5672699TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR ONZE NÍVEIS0157104080308282024021134411291<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.286000+00:002021-05-25T19:39:57.286000+00:00
cd059af8-378f-4a57-b908-cf7e8eeaedf62700TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR DOIS NÍVEIS0157104080308362024021134411291<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.285000+00:002021-05-25T19:39:57.285000+00:00
ecddf105-0ba8-41ae-abd2-5df6dc7f59952701TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR TRÊS NÍVEIS0157104080308442024021134411291<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.285000+00:002021-05-25T19:39:57.285000+00:00
4633707d-b4a9-4a56-b69b-29e2df4143702749ARTROPLASTIA TOTAL PRIMARIA DO JOELHO192157104080500632024021134411871<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.266000+00:002021-05-25T19:39:57.266000+00:00
b8925c4e-d6cd-4406-a868-43ebada583582753PATELECTOMIA TOTAL OU PARCIAL0157104080501012024021124411871<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.278000+00:002021-05-25T19:39:57.278000+00:00
daec50f6-4667-43fc-91ed-8cd37cb5f5d32755REALINHAMENTO DO MECANISMO EXTENSOR DO JOELHO0157104080501282024021124411871<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
aa0835a2-8fd1-46c9-84a1-8f9e682b58362773REIMPLANTE AO NIVEL DA COXA ATE O TERCO PROXIMAL DA PERNA0157104080503062024021134411871<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
c1b7aa1f-0706-4e6a-8d7c-e1323d8842362779TALECTOMIA0157104080503652024021124411871<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.284000+00:002021-05-25T19:39:57.284000+00:00
568b0ed3-c341-4929-a0e7-594f75f443ac3925ÓRTESE CRUROMALEOLAR PARA LIMITAÇÃO DOS MOVIMENTOS DO JOELHO99999999070102007520240211075731<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.277000+00:002021-05-25T19:39:57.277000+00:00
a9559633-704e-4f59-9c9c-4011116bcd323940ÓRTESE SUROPODALICA SEM ARTICULAÇÃO EM POLIPROPILENO (ADULTO)2281571070102022920240211075731<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.277000+00:002021-05-25T19:39:57.277000+00:00
102af559-5315-497a-a489-2714b9d848e63944ÓRTESE SUSPENSÓRIO DE PAVLIK99999999070102026120240211075731<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.277000+00:002021-05-25T19:39:57.277000+00:00
82cf51bc-345f-47b4-aa24-7b750c0fb0652847EXPLORAÇÃO ARTICULAR C/ OU S/ SINOVECTOMIA DE MÉDIAS / GRANDES ARTICULAÇÕES0157104080601232024021124412141<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.274000+00:002021-05-25T19:39:57.274000+00:00
ec5c4bc0-8452-4c66-9d05-d355e19b64543423TRANSPORTE DE MEDULA OSSEA OU DE CELULAS TRONCO HEMATOPOETICAS DE SANGUE PERIFERICO NO BRASIL DE DOADOR NAO APARENTADO08510501030085202402113571121<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.285000+00:002021-05-25T19:39:57.285000+00:00
b9897f8f-cae8-4d94-8def-f8fc119e8d823970PRÓTESE PARA AMPUTAÇÃO TIPO CHOPART99999999070102052020240211075731<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.280000+00:002021-05-25T19:39:57.280000+00:00
9e72e7c0-6596-4e62-9ae3-04d176c998fa4200PLACA EM L 2,7MM (INCLUI PARAFUSOS)9999999907020309532024021107121191<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.279000+00:002021-05-25T19:39:57.279000+00:00
ccc8a52a-a2e6-47b3-a218-73b399ecb4ea1623QUIMIOTERAPIA DE NEOPLASIA TROFOBLÁSTICA GESTACIONAL - BAIXO RISCO228157103040601782024020133271971<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.281000+00:002021-05-25T19:39:57.281000+00:00
79ad971f-e052-4c14-8308-8546bb81f9b41844NEURORRAFIA015710403020085202402112420831<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.277000+00:002021-05-25T19:39:57.277000+00:00
36c29a86-2b14-45ab-ab4e-6d4ae1157db52361ANGIOPLASTIA INTRALUMINAL DE VASOS VISCERAIS / RENAIS0157104060401252024021134341611<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.265000+00:002021-05-25T19:39:57.265000+00:00
93bb9cc9-3d7d-4dd4-a919-0ddfd1e30ef52677RETIRADA DE CORPO ESTRANHO DA COLUNA TORACO-LOMBO-SACRA POR VIA POSTERIOR0157104080306072024021124411291<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.283000+00:002021-05-25T19:39:57.283000+00:00
1c3a742d-ffb4-41ca-9447-c783f52fc0243094RETIRADA DE PRÓTESE MAMÁRIA BILATERAL EM CASOS DE COMPLICAÇÃO DA PRÓTESE MAMÁRIA IMPLANTADA19215710410010146202402112445361<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.283000+00:002021-05-25T19:39:57.283000+00:00
9dd40ecf-e72b-4f7d-b989-437e35c68dc82840ARTRODESE DE PEQUENAS ARTICULAÇÕES0157104080600502024021124412141<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.266000+00:002021-05-25T19:39:57.266000+00:00