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
bf784aae-692e-4e6c-aea8-0c589da1b7832410GASTRECTOMIA VIDEOLAPAROSCOPICA015710407010157202402112438331<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
0cf0a604-0b3c-44c7-bb74-b4d6324b464a2411GASTROENTEROANASTOMOSE015710407010165202402112438331<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
cd3f942f-58b1-4ed3-ba46-53d652b5ab982409GASTRECTOMIA TOTAL24015710407010149202402112438331<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
b446374d-2453-4f92-bb42-281bc9ba49df960GASOMETRIA (APOS OXIGENIO A 100 DURANTE A DIFUSAO ALVEOLO-CAPILAR)0157102110800472024021122492351<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
d0ef5909-dfcf-473e-9308-f1f540578dd1958GASOMETRIA0157102110800202024021122492351<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
7ccb9e5d-a5ba-4f28-a6da-988ed8e4dc353335GASTRECTOMIA PARCIAL EM ONCOLOGIA144157104160402172024021134571461<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.274000+00:002021-05-25T19:39:57.274000+00:00
2f71f01d-15c6-4b06-b1c6-7c1e68d151a33717GENFIBROZILA 600 MG (COMPRIMIDO)0157106042700702024021136263211<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.274000+00:002021-05-25T19:39:57.274000+00:00
23d794ea-d34b-47ae-a46c-4b5a8d4c88463839GLATIRAMER 20 MG INJETAVEL (POR SERINGA PREENCHIDA )0157106045200182024021136263551<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.274000+00:002021-05-25T19:39:57.274000+00:00
454a2ce8-fa40-4be4-87fe-ae4352651d4d3967PROTESE FUNCIONAL EXOESQUELETICA TRANSRADIAL P/ PUNHO DE TROCA RAPIDA C/ GANCHO DE DUPLA FORCA99999999070102049020240211075731<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
830e2238-f918-4504-b915-82035a08dd733968PRÓTESE FUNCIONAL EXOESQUELÉTICA TRANSUMERAL99999999070102050420240211075731<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
0357597d-34e4-4d68-86f2-14da96debe6a3969PROTESE MAMARIA1921571070102051220240201075731<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.280000+00:002021-05-25T19:39:57.280000+00:00
ffd1ab5c-74d7-4bbd-9e32-45220715dd2c3973PROTESE PASSIVA PARA AMPUTACAO PARCIAL DA MAO99999999070102055520240211075731<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
5c93df86-400d-479b-9138-e384bb96655b3974PRÓTESE TIPO PALMILHA PARA AMPUTAÇÃO EM NÍVEL DO ANTE PE241571070102056320240211075731<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.280000+00:002021-05-25T19:39:57.280000+00:00
d198219a-5306-46b6-acb7-1f0f7aba29ba3975ADAPTAÇÃO DE OPM ORTOPEDICA01571070102057120240211075731<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.264000+00:002021-05-25T19:39:57.264000+00:00
97498ae6-007c-4b24-8b19-20f52ea84c304094GERADOR P/ ESTIMULACAO CEREBRAL999999990702010154202402110712561<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.274000+00:002021-05-25T19:39:57.274000+00:00
4faed459-8a10-4df7-a902-843654ab6a3f4248GERADOR- PARA CARDIOVERSOR DESFIBRILADOR IMPLANTÁVEL (CDI)9999999907020400532024021107121541<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.274000+00:002021-05-25T19:39:57.274000+00:00
641b1bed-adfb-4e7d-bfb8-76b2f0cd31ee4322GANCHO LAMINAR DE COMPRESSAO-SISTEMA HARRINGTON (TODOS)9999999907020502452024021107121811<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.274000+00:002021-05-25T19:39:57.274000+00:00
ff641ef7-753e-4814-b4a7-7d1c88cadb3a4524GLICEMIA01571ABEX02620240211229411791CLINICO<span class="null">NULL</span><span class="null">NULL</span>1<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
74ec9364-e4fa-4e69-aebb-1fbfa4912b8d1037GENOTIPAGEM DO HCV015710213010542202402113252151<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
88c3e684-a2f8-4d34-a7e5-d019b772a453905GONIOSCOPIA0157102110601192024021122492031<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
5f245865-1083-4e30-94ab-5b29c5e69034959GASOMETRIA (APOS EXERCICIO CICLO-ERGOMETRICO)0157102110800392024021122492351<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
1c94d18c-2da7-4713-86e0-1600ce024b244471GLICEMIA CAPILAR01571ABPG03720240211125516010631CLINICO111<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
268e2418-6d9d-487c-82dc-49da14da24f33718GENFIBROZILA 900 MG (POR COMPRIMIDO)0157106042700892024021136263211<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.274000+00:002021-05-25T19:39:57.274000+00:00
5b99702d-5d99-4b8b-ae83-9c640180b4904320GANCHO LAMINAR INFERIOR DE DISTRACAO-SISTEMA HARRINGTON (TODOS)9999999907020502292024021107121811<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.274000+00:002021-05-25T19:39:57.274000+00:00
d115d62b-7e01-4a04-a8ad-fdd7c7a0b8d6285GENOTIPAGEM DE VIRUS DA HEPATITE C015710202030210202402113291341<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
6161420e-25f8-4a64-ad8f-3a8b0eb52dd2205GASOMETRIA (PH PCO2 PO2 BICARBONATO AS2 (EXCESSO OU DEFICIT BASE )0157102020107322024021122941<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
efd56d4d-8cfa-4889-8879-0e7e17b058353237GENGIVOPLASTIA (POR SEXTANTE)24157104140201622024021124541091<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
7aa227c9-1dca-45a3-8b10-713217c3a3b33238GLOSSORRAFIA0157104140201702024021114541091<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
e0bb1ee9-2190-4836-afc2-b2295e63a0c14153HASTE DE RUSH9999999907020304732024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
36be6404-1276-438d-b2a8-e11db21e113e3368HEMIPELVECTOMIA EM ONCOLOGIA0157104160900362024021134572461<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.274000+00:002021-05-25T19:39:57.274000+00:00
81c86bf1-1b53-44d8-8733-43061e75feb63655GOSSERRELINA 3,60 MG INJETAVEL (POR SERINGA PREENCHIDA)0157106041100142024021136262721<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.274000+00:002021-05-25T19:39:57.274000+00:00
2ab910fa-d3b1-4521-a562-8c7b5246815d3977APARELHO DE AMPLIFICACAO SONORA INDIVIDUAL (AASI) EXTERNO DE CONDUCAO OSSEA CONVENCIONAL TIPO A999999990701030011202402110751181<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.265000+00:002021-05-25T19:39:57.265000+00:00
d4ccefc7-12ea-454e-b197-5936327371e03978APARELHO DE AMPLIFICACAO SONORA INDIVIDUAL (AASI) EXTERNO DE CONDUCAO OSSEA RETROAURICULAR TIPO A999999990701030020202402110751181<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.265000+00:002021-05-25T19:39:57.265000+00:00
a99d7c62-2950-4651-819b-cb04f5b305dd3979APARELHO DE AMPLIFICACAO SONORA INDIVIDUAL (AASI) EXTERNO INTRA-AURICULAR TIPO A999999990701030038202402110751181<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.265000+00:002021-05-25T19:39:57.265000+00:00
232208f2-250c-4388-abe8-2bd49d626b7b4150GRAMPO9999999907020304492024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
3a67ee55-9da9-4952-92e3-09ca5e54528e4151HALO CRANIANO9999999907020304572024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
9d7e436d-3947-40cd-b483-7d5f6b6977564506HEMOGLOBINA GLICADA01571ABEX00820240211229411821CLINICO<span class="null">NULL</span><span class="null">NULL</span>1<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
b509c2df-04f6-4daf-bc66-fd761e310566939GUSTOMETRIA0157102110701902024021122492251<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
d18745e1-9cd7-4c91-b2cb-9a6cb42b30ab1649HEMODIALISE CONTINUA015710305010042202402113328211<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
594f6101-be01-4bc5-92d6-453da00972bb1651HEMODIÁLISE (MÁXIMO 3 SESSÕES POR SEMANA)14415710305010107202402113328211<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
879f06cb-d072-447e-aff8-c8ba2bdbbfbf247HEMATOCRITO01571020202037120240211229951<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
86dc1182-3bb5-45b9-9712-ad3acb1e5bd0248HEMOGRAMA COMPLETO01571020202038020240211229950<span class="null">NULL</span>1CLINICO010<span class="null">NULL</span>12021-05-25T19:39:57.274000+00:002021-05-25T19:39:57.274000+00:00
505c7cf1-805c-4a07-a84e-45acbcfbe49f4152HASTE DE ENDER9999999907020304652024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
49a3ef4f-94d2-408d-b5a8-eb02d8bb88ed4154HASTE FEMORAL CURTA C/ BLOQUEIO CEFALICO (INCLUI PARAFUSOS)9999999907020304812024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
d59e59a7-1c4c-404b-aefd-3228c2bd4d694155HASTE FEMORAL LONGA C/ BLOQUEIO CEFALICO (INCLUI PARAFUSOS)9999999907020304902024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
d96d1cef-8658-4d7e-89c1-25156e472c2d4156HASTE FEMORAL P/ REVISAO DE PROTESE TOTAL DO JOELHO9999999907020305032024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
f476d733-98f0-4c44-a7ae-8fd15c4046574157HASTE INTRAMEDULAR BLOQUEADA DE FEMUR (INCLUI PARAFUSOS)9999999907020305112024021107121191<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.274000+00:002021-05-25T19:39:57.274000+00:00
9ba95038-d7bd-4fe2-aa3f-5890e08c32e64282GUIA E FILTRO P/ VEIA CAVA9999999907020403982024021107121541<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.274000+00:002021-05-25T19:39:57.274000+00:00
1a34605d-db52-4e71-ad64-61eabce0dd284327HALO CRANIANO ASSOCIADO A DISPOSITIVO TIPO VESTE9999999907020502962024021107121811<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.274000+00:002021-05-25T19:39:57.274000+00:00
ac0e79bf-f958-4753-958e-6560e7bce7cb4328HASTE DE COMPRESSÃO - (SISTEMA HARRINGTON)9999999907020503002024021107121811<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.274000+00:002021-05-25T19:39:57.274000+00:00