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
d87eeb99-ece6-4db8-aa0b-311b177f6bc72743TRATAMENTO DE ARTICULACAO COXO-FEMORAL C/ IMOBILIZACAO GESSADA022704080403512024021124411631<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.287000+00:002021-05-25T19:39:57.287000+00:00
f7a49d30-b3d6-4462-83c6-1487c808abc91290TRATAMENTO DE CRISES EPILETICAS NAO CONTROLADAS0157103030401652024021123211451<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
4ce33e84-ef49-4048-b082-3d6b11f051271910TRATAMENTO DE ANEURISMA GIGANTE POR OCLUSÃO DO VASO PORTADOR0157104030701472024021134202291<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
ee5e1b62-902d-43c4-9bec-1aad3b63ef362248TRATAMENTO DE CONTUSAO MIOCARDICA015710406010960202402112434321<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
c7332985-14c1-4f9c-a7a2-61b177002f9f1294TRATAMENTO DE DOENCAS NEURO-DEGENERATIVAS0157103030402032024021123211451<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
490f32eb-64af-4e25-be64-cf5e921cc1ce550DOSAGEM DE GLICOSE NO LIQUIDO SINOVIAL E DERRAMES015710202090124202402112292481<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
65bbb7d3-17c7-4949-a31e-cc396406a976587DOSAGEM QUANTITATIVA DA ATIVIDADE DA BIOTINIDASE EM AMOSTRAS DE SORO015710202110117202402112292701<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
17abd2c9-af03-4723-9aff-831fe4dc6d633666GALANTAMINA 24 MG (POR CAPSULA DE LIBERAÇÃO PROLONGADA)480157106041300582024021136262871<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
3946513d-23e4-4e07-82ab-91c660dfb28a3669RIVASTIGMINA 3 MG (POR CAPSULA)480157106041300822024021136262871<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.283000+00:002021-05-25T19:39:57.283000+00:00
ef48658e-5c5a-4f2c-9ec3-eddbf11da1973670RIVASTIGMINA 4,5 MG (POR CAPSULA)480157106041300902024021136262871<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.283000+00:002021-05-25T19:39:57.283000+00:00
3040a69f-ae9a-4a59-8066-faf8e4666ef73674DANAZOL 100 MG (POR CAPSULA)0157106041400292024021136262891<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.271000+00:002021-05-25T19:39:57.271000+00:00
9ffad5d7-a78c-41d2-b658-d16a1577d31e3358HISTERECTOMIA COM OU SEM ANEXECTOMIA (UNI / BILATERAL) EM ONCOLOGIA0157104160601102024021134572021<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
db11180f-898b-49cd-9549-bcd4a42cd22d4991ALFAELOSULFASE 1 MG/ML SOLUÇÃO INJETÁVEL (POR FRASCO AMPOLA DE 5 ML)01571060424009020240211<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:29:59.617772+00:002024-09-18T00:29:59.617772+00:00
2f06fb59-93bc-4c87-b8c6-9e1d2118206f4321GANCHO LAMINAR SUPERIOR DE DISTRACAO-SISTEMA HARRINGTON (TODOS)9999999907020502372024021107121811<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
0475fcb6-4159-4cc9-9c11-6f9703540f01327PESQUISA DE ANTICORPOS CONTRA ANTIGENO E DO VIRUS DA HEPATITE B (ANTI-HBE)015710202030644202402112291341<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
bc396e03-5083-4511-b5f0-b286d72c8986328PESQUISA DE ANTICORPOS CONTRA HISTOPLASMA015710202030652202402112291341<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
c388f380-6222-4709-8204-330d246010f9346PESQUISA DE ANTICORPOS IGG CONTRA O VIRUS EPSTEIN-BARR015710202030830202402112291341<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
29b2b389-c9a8-4566-8150-9a0f59e3bd01347PESQUISA DE ANTICORPOS IGG CONTRA O VIRUS HERPES SIMPLES015710202030849202402112291341<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
30a3dc52-ace6-4513-a96d-fe4e7a8e0db4348PESQUISA DE ANTICORPOS IGM ANTICITOMEGALOVIRUS015710202030857202402112291341<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
24d49135-ca87-4c09-a8bf-7f5d885ddb46349PESQUISA DE ANTICORPOS IGM ANTILEISHMANIAS015710202030865202402112291341<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
4aeb2d08-4cb2-4870-916e-1975db7303051339TRATAMENTO DE EDEMA AGUDO DE PULMAO0157103030601312024021123212061<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.288000+00:00
07c6bd88-ac74-44af-bdf4-5c777408ca051242TRATAMENTO DE DOENÇAS BACTERIANAS ZOONÓTICAS015710303010045202402112321191<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
b519dd07-3581-40db-904c-d97267fdc8841291TRATAMENTO DE DISTROFIAS MUSCULARES0157103030401732024021123211451<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
d16c1d2d-2324-43ac-aaba-bdd0cceaca331292TRATAMENTO DE DOENCA DE PARKINSON240157103030401812024021123211451<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
21033b53-671e-4fb7-a1f7-c220e8f07dca1293TRATAMENTO DE DOENCA DOS NEURONIOS MOTORES CENTRAIS C/ OU S/ AMIOTROFIAS144157103030401902024021123211451<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
5e58c088-5214-4726-a5a0-e474b77ade431408TRATAMENTO DE ECLAMPSIA10873103031000282024020123212591<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
170e564e-bda4-45a7-981c-105bf66390c01336TRATAMENTO DE CRISE HIPERTENSIVA0157103030601072024021123212061<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:002026-04-27T11:26:37.787000+00:00
dc05510b-ab15-4b30-9c6e-fd6ddc4724be1409TRATAMENTO DE EDEMA, PROTEINURIA E TRANSTORNOS HIPERTENSIVOS NA GRAVIDEZ PARTO E PUERPERIO10873103031000362024020123212591<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
8b56529c-01fb-4538-87f0-e70f9e47560c1414TRATAMENTO DE ESPINHA BIFIDA020303031100312024021123212671<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
943ccb69-9fe2-4d95-bc76-9544ea86216c1425TRATAMENTO DE DOR/METÁSTASE ÓSSEA COM RADIOISÓTOPO (POR TRATAMENTO-EXCETO CÂNCER DE TIREOIDE)0157103031200532024021133212821<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
20d03a63-ace5-4934-9f41-085062e75a351442TRATAMENTO DE DOENCA DO OUVIDO EXTERNO MEDIO E DA MASTOIDE0157103031400702024021123212901<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
958f70bc-d061-4390-a3e4-bfb532ead3ab1443TRATAMENTO DE DOENCAS RESPIRATORIAS QUE AFETAM PRINCIPALMENTE O INTERSTICIO0157103031400892024021123212901<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
c260201c-70a2-416c-9f3d-dc77bd9cacde1451TRATAMENTO DE DOENCAS DOS ORGAOS GENITAIS MASCULINOS144157103031500172024021023212911<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
0d508545-ad1b-42a3-9226-bdc5fb61fe971452TRATAMENTO DE DOENCAS GLOMERULARES24157103031500252024021123212911<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
48b6bdf2-a33f-4eaa-b592-c3eb813865911453TRATAMENTO DE DOENCAS INFLAMATORIAS DOS ORGAOS PELVICOS FEMININOS144157103031500332024020123212911<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
48bcd835-6829-4843-904e-e8b55852a0ce1454TRATAMENTO DE DOENCAS RENAIS TUBULO-INTERSTICIAIS0157103031500412024021123212911<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
bcd38054-5f30-4382-9767-c5d8c46651921457TRATAMENTO DE ENTERITE NECROSANTE DO FETO E DO RECEM-NASCIDO0103031600122024021123212961<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
a255af6d-2051-4280-9127-e86c2292a9521476TRATAMENTO DE DOENÇAS DISSEMINADAS EM AIDS0157103031800642024021133213011<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
1f855fbb-5225-4ac7-ae7c-19a32841d2321715TRATAMENTO DE EFEITOS DE ASFIXIA / OUTROS RISCOS A RESPIRACAO015710308010027202402112340241<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
c8eb1023-dc08-41c1-a049-bc8341efff8e1719TRATAMENTO DE EFEITOS DO CONTATO C/ ANIMAIS E PLANTAS VENENOSOS015710308020022202402112340791<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
255ee9ad-c074-40ce-9d35-a73e59d2b9231721TRATAMENTO DE EFEITOS DA PENETRACAO DE CORPO ESTRANHO EM ORIFICIO NATURAL0157103080300102024021123401221<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
e14552d7-9b97-4506-aead-6c569cda78c41722TRATAMENTO DE EFEITOS DE OUTRAS CAUSAS EXTERNAS0157103080300282024021123401221<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
381e33a5-bafd-4b39-aca4-0c3ea119b3b31725TRATAMENTO DE EVENTOS ADVERSOS POS-VACINAIS0157103080400232024021123401571<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
f3688103-6e4e-4039-a6e5-446d4dd39e371919TRATAMENTO DE DOR POR ESTEREOTAXIA156157104030800702024021134202321<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
91de301b-b715-443e-b499-b6932962b85b2378TRATAMENTO DE EPISTAXE POR EMBOLIZACAO (INCLUI ESTUDO ANGIOGRAFICO E/OU ENDOSCOPICO)0157104060402902024021134341611<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
67141988-d216-4d9b-955a-d5b1a4b3c8973179TRATAMENTO DE GRANDE QUEIMADO015710413010066202402113453391<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
f8177bf3-35c5-481f-af5b-00a48fada5083180TRATAMENTO DE INTERCORRENCIA EM PACIENTE MEDIO E GRANDE QUEIMADO015710413010074202402112453391<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
6676bc91-be6b-48cb-9051-1fac08d0a86f3190TRATAMENTO DE GINECOMASTIA OU PSEUDOGINECOMASTIA EM PACIENTE C/ LIPODISTROFIA DECORRENTE DO USO DE ANTI-RETROVIRAIS21691104130300832024021034531321<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
8984d793-99d9-4964-8a0e-4e1f1d516ef13530TRATAMENTO DE INTERCORRENCIA POS-TRANSPLANTE ALOGENICO DE CELULAS-TRONCO HEMATOPOETICAS DE APARENTADO (HOSPITAL DIA)015710506020037202402113532691<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.288000+00:002021-05-25T19:39:57.288000+00:00
c1fbd2c2-5de2-453a-857c-11fb1443e17c3531TRATAMENTO DE INTERCORRÊNCIA PÓS-TRANSPLANTE DE ÓRGÃOS / CÉLULAS-TRONCO HEMATOPOÉTICAS015710506020045202402113532691<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.288000+00:002021-05-25T19:39:57.288000+00:00