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
c65e2a22-1ad2-4d50-9d83-a52d0dea27cc2664DISCECTOMIA TORACO-LOMBO-SACRA POR VIA ANTERIOR (1 NÍVEL)0157104080304612024021134411291<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
1972a517-385d-41a6-b65c-5a28083ad4092670RESSECÇÃO DE ELEMENTO VERTEBRAL POSTERIOR / POSTERO-LATERAL / DISTAL A C2 (MAIS DE 2 SEGMENTOS)0157104080305342024021124411291<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
4e29bf8c-b5da-4ae0-82e7-b2f516ecb0d62688TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR SEIS NÍVEIS0157104080307122024021134411291<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
2bc1d1aa-e4b9-4b6a-b12c-3e2ab26519772689TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR SETE NÍVEIS12157104080307202024021134411291<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
05dfb09c-886d-4a18-8a4f-9cc3ee2373e72693TRATAMENTO CIRURGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR NOVE NIVEIS0157104080307632024021134411291<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
080432b9-5183-48af-a071-8ae42e5bc6b12698TRATAMENTO CIRURGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR DEZ NIVEIS0157104080308102024021134411291<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
2a6503ea-51a9-43e4-88f7-e019d7663fae2702TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR CINCO NÍVEIS0157104080308522024021134411291<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
f6bc056f-ce2b-416e-a6b7-ca7f3cc794ae2703TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR SEIS NÍVEIS0157104080308602024021134411291<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
2063fa35-7962-48c5-a1a4-1dab15366cb12704TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR TRÊS NÍVEIS0157104080308792024021134411291<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
077d5ac7-a58c-4d80-b456-d833af01cf9e2705TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR QUATRO NÍVEIS0157104080308872024021134411291<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
2f609a30-a22d-49cb-a290-d7f665285a562707TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR SETE NÍVEIS0157104080309092024021134411291<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
2be59db5-f382-4f73-8fdc-2833984cc5f62708ARTRODESE CERVICAL / CERVICO TORÁCICA POSTERIOR QUATRO NÍVEIS0157104080309172024021134411291<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
47be0726-3abe-4508-8a6d-4dfcde8bb29c2709ARTRODESE COXOFEMORAL0157104080400172024021124411631<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
b4cf11dd-d558-43fb-be09-288293f18fb62710ARTRODESE DA SÍNFISE PÚBICA0157104080400252024021124411631<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
3a9aa698-c666-4ba3-8da4-d2116f22a0772711ARTRODESE DE ARTICULAÇÕES SACROILIACAS0157104080400332024021134411631<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
d391c60e-e430-4094-8d00-88941d4debc32719DESARTICULAÇÃO INTERÍLIO-ABDOMINAL0157104080401142024021134411631<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
764f5737-6afa-441c-b165-067169a1894b2787TRATAMENTO CIRURGICO DE COALIZAO TARSAL60157104080504462024021124411871<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
63996bca-8e89-42f9-8702-bb87fdd0e5b8964TESTE DA CAMINHADA DE 6 MINUTOS48157102110800802024021122492351<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.284000+00:002021-05-25T19:39:57.284000+00:00
ea476a05-1aeb-44bf-b1dc-b7816bff5dac2799TRATAMENTO CIRÚRGICO DE FRATURA DO TALUS0157104080505602024021124411871<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
9af349b8-d2b2-438f-9b54-22dbb95222292800TRATAMENTO CIRÚRGICO DE FRATURA DO TORNOZELO UNIMALEOLAR0157104080505782024021124411871<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
27f71e33-ccaa-4b7c-9031-95ca44af32862801TRATAMENTO CIRÚRGICO DE FRATURA INTERCONDILEANA / DOS CÔNDILOS DO FÊMUR0157104080505862024021124411871<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
18b70310-59ba-49e6-a5d3-28a189eebaa12802TRATAMENTO CIRÚRGICO DE FRATURA LESÃO FISÁRIA AO NÍVEL DO JOELHO0157104080505942024021124411871<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
52d5db30-269e-426f-b0c9-81fd3ec1b1ea2803TRATAMENTO CIRÚRGICO DE FRATURA LESÃO FISÁRIA DISTAL DE TÍBIA022704080506082024021124411871<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
5c17cae3-ef02-42d8-abc4-d8b687d4c5e74988LEUPRORRELINA 45 MG INJETÁVEL (SERINGA PREENCHIDA)241571060411008120240211<span class="null">NULL</span>626272<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:26:55.545984+00:002024-09-18T00:26:55.545984+00:00
821306c3-c4af-4c91-95d9-c9e9157668ff673RADIOGRAFIA DE MAO E PUNHO (P/ DETERMINACAO DE IDADE OSSEA)0157102040401082024021122251681<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.282000+00:002021-05-25T19:39:57.282000+00:00
247eaee3-93ec-4d19-81b5-0fc2c9b372074989ÁCIDO ZOLEDRÔNICO 0,05 MG/ML (POR FRASCO DE 100 ML)2161571060416006220240211<span class="null">NULL</span>626295<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:26:55.545984+00:002024-09-18T00:26:55.545984+00:00
b9b3a084-19e8-4084-891b-d5f5a9e96de03297PAROTIDECTOMIA TOTAL EM ONCOLOGIA144157104160300922024021134571431<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.278000+00:002021-05-25T19:39:57.278000+00:00
1dfa263f-17e6-4ff1-b6cc-fd6a934a8819498DOSAGEM DE COBRE015710202070190202402112292271<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
c2c7fa79-f20a-4602-b662-9c3934307060505DOSAGEM DE MERCURIO015710202070263202402112292271<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.272000+00:002021-05-25T19:39:57.272000+00:00
9699c18d-eb2e-4cf1-be35-137667933025506DOSAGEM DE META-HEMOGLOBINA015710202070271202402112292271<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.272000+00:002021-05-25T19:39:57.272000+00:00
0948ffd0-066f-436d-a2dd-f05aa6eb7938507DOSAGEM DE METABOLITOS DA COCAINA015710202070280202402112292271<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.272000+00:002021-05-25T19:39:57.272000+00:00
36dc4854-a6cc-420a-9612-241e294708b6513DOSAGEM DE TIOCIANATO015710202070344202402112292271<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.272000+00:002021-05-25T19:39:57.272000+00:00
7b0e1c51-cb6c-4216-b26b-c4d439ae8b654990GALSULFASE 1 MG/ML SOLUÇÃO INJETÁVEL (POR FRASCO AMPOLA DE 5 ML)01571060424008220240211<span class="null">NULL</span>626315<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:26:55.545984+00:002024-09-18T00:26:55.545984+00:00
a9e110e3-8447-4295-bbaa-deb703150019193DOSAGEM DE PROTEINAS TOTAIS0157102020106192024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.272000+00:002021-05-25T19:39:57.272000+00:00
e8665267-d9fb-4de1-8274-ed6b78c8b954322PESQUISA DE ANTICORPOS ANTINUCLEO015710202030598202402112291341<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
2ec23bb1-acd2-4e11-8a2b-3d124e57b41a331PESQUISA DE ANTICORPOS CONTRA O VIRUS DA HEPATITE D (ANTI-HDV)015710202030687202402112291341<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
a4a838e6-3418-4abf-8286-81b72841b4ac380DOSAGEM DE ANTICORPOS ANTITRANSGLUTAMINAISE RECOMBINANTE HUMANO IGA015710202031187202402112291341<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
070b89cc-6a7d-49b5-8e5d-ef142cbdf726344PESQUISA DE ANTICORPOS IGG CONTRA O VIRUS DA RUBEOLA015710202030814202402112291341<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
bdc61833-0574-4649-a5f2-5e3854c62046146DOSAGEM DE ALDOLASE0157102020101472024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
6dc5b863-c883-46af-8893-dcf0af90b704147DOSAGEM DE ALFA-1-ANTITRIPSINA0157102020101552024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
8da1faac-6519-40cc-85af-484e5a5d12f1150DOSAGEM DE AMILASE0157102020101802024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
9efd447b-4cbd-4ff2-be75-20d7b94d7d8f4992ALFA-ALGLICOSIDASE 50 MG PÓ LIOFILIZADO PARA SOLUÇÃO INJETÁVEL01571060424010420240211<span class="null">NULL</span>626315<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:27:05.199833+00:002024-09-18T00:27:05.199833+00:00
622c07bd-7a98-4676-ba52-03d3e6d073bf4993ALFAVESTRONIDASE 10 MG SOLUÇÃO INJETÁVEL (FRASCOCOM 5ML)01571060424011220240211<span class="null">NULL</span>626315<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:27:05.199833+00:002024-09-18T00:27:05.199833+00:00
a6f0b1fc-4f03-498b-a125-4a5d3a224ff3135DETERMINACAO DE CROMATOGRAFIA DE AMINOACIDOS0157102020100312024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
c26809b8-ac7b-4910-8587-0269ec77d962136DETERMINACAO DE CURVA GLICEMICA (2 DOSAGENS)0157102020100402024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
b32b4336-3fb3-4c9b-829b-612607a191ae137DETERMINACAO DE CURVA GLICEMICA C/ INDUCAO POR CORTISONA ( 5 DOSAGENS)0157102020100582024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
3f65f6d5-1cc6-4097-9889-30d03bad8484138DETERMINACAO DE CURVA GLICEMICA C/ INDUCAO POR CORTISONA (4 DOSAGENS)0157102020100662024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.271000+00:002021-05-25T19:39:57.271000+00:00
9b48f80f-74d2-4d68-b5fd-dd05a3d2608f4995BARICITINIBE 2MG (POR COMPRIMIDO)2161571060432017520240211<span class="null">NULL</span>626331<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:27:05.199833+00:002024-09-18T00:27:05.199833+00:00
6663019c-34dd-4745-9f0b-a35c1c2222b54996BARICITINIBE 4MG (POR COMPRIMIDO)2161571060432018320240211<span class="null">NULL</span>626331<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:27:05.199833+00:002024-09-18T00:27:05.199833+00:00
f72e155c-1ceb-4e4c-8e33-0b126adfb6e44997UPADACITINIBE 15 MG (POR COMPRIMIDO REVESTIDO DE LIBERAÇÃO PROLONGADA)2161571060432019120240211<span class="null">NULL</span>626331<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:27:05.199833+00:002024-09-18T00:27:05.199833+00:00