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
9003ce34-5654-44d8-9f3e-2db0787e81031393TRATAMENTO CONSERVADOR DE FRATURA DE OSSO METACÁRPICO0157103030901622024021123212471<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
6a6a68fb-6617-4bfa-bace-34d815438dc31394TRATAMENTO CONSERVADOR DE FRATURA DE OSSOS DA FACE0157103030901702024021123212471<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
388722b5-e30f-47ee-931b-00a729c029601419TRATAMENTO DE NEUROFIBROMATOSE0157103031100822024021123212671<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.288000+00:002021-05-25T19:39:57.288000+00:00
7dd4e071-4840-4b1b-9c17-9e15fe009489761RESSONANCIA MAGNETICA DE TORAX0157102070200352024021132371001<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
009c1276-16fc-45c6-84f3-7f67359e481b1284TRATAMENTO CONSERVADOR DE TRAUMATISMO CRANIOENCEFALICO GRAVE0157103030401062024021133211451<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
ec3ff386-3d37-467e-b51b-5b6c545119aa1285TRATAMENTO CONSERVADOR DE TRAUMATISMO RAQUIMEDULAR0157103030401142024021133211451<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
10a1b069-1f9f-4624-aea5-eabd0c4cf55a1447TRATAMENTO DE OUTRAS DOENCAS DAS VIAS AEREAS SUPERIORES0157103031401272024021123212901<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.288000+00:002021-05-25T19:39:57.288000+00:00
0a483425-5347-4eae-aa6a-01fdbbbff88a1448TRATAMENTO DE OUTRAS DOENCAS DO APARELHO RESPIRATORIO0157103031401352024021123212901<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.288000+00:002021-05-25T19:39:57.288000+00:00
3ecc910d-0479-4c59-888e-13034a903f5c1449TRATAMENTO DE OUTRAS INFECCOES AGUDAS DAS VIAS AEREAS INFERIORES0157103031401432024021123212901<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.288000+00:002021-05-25T19:39:57.288000+00:00
2d9a6b51-c54d-4a9e-806a-3e4ada98fd111450TRATAMENTO DE PNEUMONIAS OU INFLUENZA (GRIPE)0157103031401512024021123212901<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.288000+00:002021-05-25T19:39:57.288000+00:00
a038e9b8-0c99-45ed-8cab-7dd86558df411465TRATAMENTO EM PSIQUIATRIA EM HOSPITAL DIA36157103031701072024021123212981<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.288000+00:002021-05-25T19:39:57.288000+00:00
fafaa66c-a2df-4f57-9c9e-4446b6556ee21466TRATAMENTO CLÍNICO EM SAÚDE MENTAL EM SITUAÇÃO DE RISCO ELEVADO DE SUICÍDIO.48157103031701312024021123212981<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
07d7fd36-5600-48a8-87da-e124d3cd3bc61467TRATAMENTO CLÍNICO PARA CONTENÇÃO DE COMPORTAMENTO DESORGANIZADO E/OU DISRUPTIVO48157103031701402024021123212981<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
1cafcc86-48aa-468c-8f0b-ca314e699a2270BIOPSIA DE CONDUTO AUDITIVO EXTERNO0157102010100892024021122331<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.267000+00:002021-05-25T19:39:57.267000+00:00
ed8f03db-397f-4322-ba5a-6b8579794e3b3355TRAQUELECTOMIA RADICAL EM ONCOLOGIA144157104160600802024020134572021<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
debe0237-afb6-4ab7-a27a-12492b484ae14740MONOQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO – 1ª LINHA22815710304020427202402113327751<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
83f775dd-a5e7-490e-b42c-121deabd3de64364ESFERA DE MÜLLER9999999907020700412024021107122221<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.273000+00:002021-05-25T19:39:57.273000+00:00
5318939c-83e8-47e0-adca-0fa8e5bcd8511353TRATAMENTO DE PERICARDITE0157103030602712024021123212061<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.288000+00:002021-05-25T19:39:57.288000+00:00
eb4d5b57-88fa-4125-9602-9383d3fd2ed41591HORMONIOTERAPIA DO CARCINOMA DE MAMA EM ESTÁDIO I228157103040500402024021133271821<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.275000+00:002021-05-25T19:39:57.275000+00:00
3058da8b-2f9a-4474-a7ec-d23c1ec08b6e1601QUIMIOTERAPIA DO OSTEOSSARCOMA228157103040502102024021133271821<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
e2e5fefc-e432-470c-beff-c56e909649891614QUIMIOTERAPIA DE LEUCEMIA AGUDA/ MIELODISPLASIA / LINFOMA DE BURKITT - 1ª LINHA228157103040600702024021133271971<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
6efe8d1a-506c-4abb-9fdc-1cebe4c47c4a1615QUIMIOTERAPIA DE LEUCEMIA AGUDA/ MIELODISPLASIA/LINFOMA LINFOBLÁSTICO/ LINFOMA DE BURKITT - 2ª LINHA228157103040600892024021133271971<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
91105c1c-9d7d-42d1-a276-6a9cb437593e1616QUIMIOTERAPIA DE LEUCEMIA AGUDA/ MIELODISPLASIA/ LINFOMA LINFOBLÁSTICO/ LINFOMA DE BURKITT 3ª LINHA228157103040600972024021133271971<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
5cd569d7-e355-4913-9fda-65a1b16545431617QUIMIOTERAPIA DE LEUCEMIA AGUDA/MIELODISPLASIA/ LINFOMA LINFOBLÁSTICO/ LINFOMA DE BURKITT - 4ª LINHA228157103040601002024021133271971<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
8b73309c-e69d-4954-ad94-cbfef01436f71618QUIMIOTERAPIA DE LINFOMA NÃO HODGKIN GRAU INTERMEDIÁRIO OU ALTO - 2ª LINHA228157103040601192024021133271971<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
eb4c2a61-dd56-49c7-a66b-6b29434eaa021619QUIMIOTERAPIA DE LINFOMA NÃO HODGKIN GRAU INTERMEDIÁRIO OU ALTO - 3ª LINHA228157103040601272024021133271971<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
59981a31-58d2-45e3-a82f-13aafd9df41a1620QUIMIOTERAPIA DE LINFOMA NÃO HODGKIN DE GRAU DE MALIGNIDADE INTERMEDIÁRIO OU ALTO - 1ª LINHA228157103040601352024021133271971<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
f6c595d8-2c71-4cd9-965f-5452fb8f3c661621QUIMIOTERAPIA DE TUMOR GERMINATIVO EXTRA-GONADAL228157103040601512024021133271971<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
91748102-1ed7-4eb0-8150-d7f6e2efb815112BIOPSIA/PUNÇÃO DE VAGINA0157102010105002024020122331<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.268000+00:002021-05-25T19:39:57.268000+00:00
7f16f2d1-4e51-4af3-adfc-00b423f0037c1633FATOR ESTIMULANTE DO CRESCIMENTO DE COLÕNIAS DE GRANULÓCITOS / MACRÓFAGOS0157103040800122024021133272361<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
16eee315-7785-4105-bac4-0a65b3ec7f731634INTERNAÇÃO P/ QUIMIOTERAPIA DE ADMINISTRAÇÃO CONTÍNUA0157103040800202024021133272361<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.275000+00:002021-05-25T19:39:57.275000+00:00
f822eeff-0640-447f-9c5e-8db3d802325d1635INTERNAÇÃO P/ QUIMIOTERAPIA DE LEUCEMIAS AGUDAS / CRÔNICAS AGUDIZADAS0157103040800392024021133272361<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.275000+00:002021-05-25T19:39:57.275000+00:00
1153eb73-20f3-48f9-9ff8-3844e4fef8b01636QUIMIOTERAPIA INTRA-ARTERIAL0157103040800472024021133272361<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
bc98fef1-8870-4b96-b475-53e44665ac8b1637QUIMIOTERAPIA INTRA-TECAL0157103040800552024021133272361<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
58da6f8f-469d-4961-89fe-24b5b0a73dcc1638QUIMIOTERAPIA INTRACAVITARIA228157103040800632024021133272361<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
e4d1cd59-8cba-4ce3-9430-40c3ecc9d3511639INIBIDOR DA OSTEÓLISE0157103040800712024021133272361<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.275000+00:002021-05-25T19:39:57.275000+00:00
e3788eea-9a32-4c6b-8691-2223928f53b61306EXERCICIOS ORTOPTICOS0157103030500202024021123211961<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
07851625-a2ab-4580-b9e6-8c4769ce49e91681TRANSFUSAO DE SUBSTITUICAO / TROCA (EXSANGUINEOTRANSFUSÃO)015710306020130202402113335771<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
ef28dd6d-df9c-4569-b248-d3cc40150b991682TRANSFUSAO DE UNIDADE DE SANGUE TOTAL015710306020149202402112335771<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
5712f62b-0118-4fa9-887e-fa0f53df1ed21747LITOTRIPSIA EXTRACORPOREA (ONDA DE CHOQUE - TRATATAMENTO SUBSEQUENTE EM 2 REGIOES RENAIS)0157103090301102024021133431231<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
a0fde07f-4886-4fd0-85a1-0f5aae06c0b41748LITOTRIPSIA EXTRACORPOREA (ONDA DE CHOQUE PARCIAL / COMPLETA EM 1 REGIAO RENAL)0157103090301292024021133431231<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
98a7c125-8315-48e0-bb1f-8d6f21bcf2fb1750MASSAGEM DE PROSTATA (POR SESSAO)144157103090301452024021023431231<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
35d0b5c2-5f82-43ea-8102-f9a2188985e71789TRATAMENTO CIRURGICO DE ESCALPO TOTAL01571040102013420240211248811<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
64e9412f-d990-4ff9-8f01-e7e00ef2b55a1791TRATAMENTO CIRURGICO DO SINUS PRE-AURICULAR01571040102015020240211248811<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
7a69b2ed-125c-492f-87c4-58eea2c219bf1858MICROCIRURGIA DE TUMOR MEDULAR0157104030301022024021134201241<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
68f4da4b-6bd1-4517-ae39-c46a281969081883NEUROTOMIA PERCUTANEA DE NERVOS PERIFERICOS POR AGENTES QUIMICOS0157104030500812024021124201841<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
2e1903de-6476-41ec-a355-ce46479a89a71886SIMPATECTOMIA LOMBAR A CEU ABERTO12157104030501112024021124201841<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
841799f4-20c8-4922-8672-fe7e1078fc3c1916MIECTOMIA SUPERSELETIVA156157104030800452024021134202321<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
b106fcb9-cbac-4842-b741-bf1cb7267bf31155ABORDAGEM COGNITIVA COMPORTAMENTAL DO FUMANTE (POR ATENDIMENTO / PACIENTE)12015710301080011202402111312401<span class="null">NULL</span>1CLINICO000<span class="null">NULL</span>12021-05-25T19:39:57.263000+00:002021-05-25T19:39:57.263000+00:00
9a73eeee-c66c-4d40-8b03-18bdd2c9778d2051TRATAMENTO CIRÚRGICO DE FÍSTULAS ORONASAIS EM PACIENTE COM ANOMALIA CRÂNIO E BUCOMAXILOFACIAL0157104040302542024021134241251<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