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
117a744f-7e7d-4e32-b4b6-ae393b62e4493320RESSECCAO DE TUMOR TIREOIDIANO POR VIA TRANSESTERNAL EM ONCOLOGIA0157104160303602024021134571431<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.282000+00:002021-05-25T19:39:57.282000+00:00
81e93f95-1f9c-47b7-ae0a-40011c74c6ee3330RESSECCAO DE TUMOR RETROPERITONIAL C/ RESSECCAO DE ORGAOS CONTIGUOS EM ONCOLOGIA0157104160401442024021134571461<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.282000+00:002021-05-25T19:39:57.282000+00:00
701711ed-25ac-4949-9387-1143075555b93339RESSECCAO DE TUMOR RETROPERITONIAL EM ONCOLOGIA0157104160402502024021134571461<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.282000+00:002021-05-25T19:39:57.282000+00:00
e8bb29e0-42bd-4994-981c-3a266a756f6d3370RESSECCAO DE TUMOR OSSEO COM SUBSTITUICAO (ENDOPROTESE) OU COM RECONSTRUÇÃO E FIXAÇÃO EM ONCOLOGIA0157104160901092024021134572461<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.282000+00:002021-05-25T19:39:57.282000+00:00
c7d8e40c-1d97-4eb1-bb18-918aa3c5cfe73380RESSECÇAO PULMONAR EM CUNHA EM ONCOLOGIA0157104161100702024021134572741<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
e0cc19d4-e626-4504-8961-ae51af9b61c64511RETINOGRAFIA / FUNDO DE OLHO COM OFTALMOLOGISTA01571ABEX0132024021122492031<span class="null">NULL</span>1CLINICO011<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
6b9ef6fd-36b4-4e2e-83c3-240020b20bbd4513RETINOGRAFIA FLUORESCENTE01571ABEX01520240211224920319121CLINICO111<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
aa07b1ca-253d-43d0-b1ff-2b13ea750ac94512RETINOGRAFIA COLORIDA01571ABEX01420240211224920319111CLINICO111<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
6b7e17be-3003-4440-abc1-839051e9cb0c1685RESTAURAÇÃO DE DENTE DECÍDUO015710307010023202402111336231<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
17226f56-6c9c-4edc-92da-6e4d4ab712961686RESTAURAÇÃO DE DENTE PERMANENTE ANTERIOR015710307010031202402111336231<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
d3e6d139-3fbf-414c-8b2a-9b9c386eacf13272RESSECCAO ENDOSCOPICA DE TUMOR VESICAL EM ONCOLOGIA14415710416010172202402113457421<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
8bef7019-9a16-4df3-b746-96027a6cd9f92866RESSECÇÃO SIMPLES DE TUMOR ÓSSEO / DE PARTES MOLES0157104080603102024021124412141<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
09083c92-3cb6-43dc-9533-09a608e7709a2943RESSECCAO ENDOSCOPICA DA EXTREMIDADE DISTAL DO URETER015710409010375202402112442351<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
0a476aed-73e0-4329-a3e1-4400ed4d3bae2944RESSECCAO ENDOSCOPICA DE LESAO VESICAL015710409010383202402112442351<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
aacdab0d-21b8-4477-9c67-9f1e332b5d9a3005RESSECCAO PARCIAL DA BOLSA ESCROTAL0157104090401932024021024421641<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
82e10866-9cd0-4099-8b4f-62bf47db40a73167RESSECÇÃO EM CUNHA, TUMORECTOMIA / BIOPSIA DE PULMAO A CEU ABERTO0157104120501022024021124501891<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
1c1d067a-2935-4de7-a32f-9c001fe297de3168RESSECÇÃO PULMONAR ASSOCIADA A BRONCOPLASTIA/ ARTERIOPLASTIA0157104120501102024021124501891<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
7aa75cf6-79d9-4fd6-ac1a-761c813cd3354230RESTRITOR DE CIMENTO FEMORAL/UMERAL9999999907020312592024021107121191<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.283000+00:002021-05-25T19:39:57.283000+00:00
88b945e7-bb23-4ef2-ad15-4b41ff0d91c72865RESSECÇÃO MUSCULAR0157104080603012024021124412141<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
a676ed30-efe4-4ae5-bbaf-4ffbbdc7cf29753RESSONANCIA MAGNETICA DE ARTICULACAO TEMPORO-MANDIBULAR (BILATERAL)01571020701002120240211323791<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
87f810f8-e3fb-49a5-82b2-822369d6ab1b754RESSONANCIA MAGNETICA DE COLUNA CERVICAL/PESCOÇO01571020701003020240211323791<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
2439898e-c18a-476f-b9bd-e12352c4a5ca2529RESSUTURA DE PAREDE ABDOMINAL (POR DEISCENCIA TOTAL / EVISCERACAO)0157104070402422024021124381621<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
ae35f4e7-7d01-4f4c-99f7-f44fa264fb44911RETINOGRAFIA COLORIDA BINOCULAR0157102110601782024021122492030<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
436a6367-89e0-4127-8bed-c0675cc1fe3d912RETINOGRAFIA FLUORESCENTE BINOCULAR0157102110601862024021122492030<span class="null">NULL</span>1CLINICO110<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
6db1d2e4-f480-433c-bf39-ca22b967756a2986RESSECCAO ENDOSCOPICA DE PROSTATA360157104090300402024021024421301<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
7a8108f0-a05d-46fa-9370-82d22e9f28764349RETANGULO TIPO HARTSHILL / SIMILAR9999999907020505122024021107121811<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.283000+00:002021-05-25T19:39:57.283000+00:00
2881a007-9808-47ff-b502-b391bd3981cd5059APOIO MATRICIAL EM SAÚDE DO TRABALHADOR NA ATENÇÃO ESPECIALIZADA, URGÊNCIA E EMERGÊNCIA99999999030108041020240211<span class="null">NULL</span>31240<span class="null">NULL</span><span class="null">NULL</span>0ADMINISTRATIVO<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12024-09-18T00:29:30.356145+00:002024-09-18T00:29:30.356145+00:00
72ea0c47-cf0b-41ec-bb42-dedbdcf67ff95060APOIO MATRICIAL EM VIGILÂNCIA À SAÚDE DO TRABALHADOR (VISAT) PARA OUTROS COMPONENTES DA VIGILÂNCIA EM SAÚDE99999999030108042920240211<span class="null">NULL</span>31240<span class="null">NULL</span><span class="null">NULL</span>0ADMINISTRATIVO<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12024-09-18T00:29:30.356145+00:002024-09-18T00:29:30.356145+00:00
dd815765-71b9-4ca1-abf1-4d5ac3f909f55061CONSULTA EM SAÚDE DO TRABALHADOR (EXCETO MÉDICO)601571030301023120240211<span class="null">NULL</span>32119<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:30.356145+00:002024-09-18T00:29:30.356145+00:00
b8f8c593-9d52-4bff-8f16-5ae6892535655062IMUNOTERAPIA EM CRIANÇA OU ADOLESCENTE COM LEUCEMIA LINFOBLÁSTICA AGUDA (LLA) B0239030407008420240211<span class="null">NULL</span>327230<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:30.356145+00:002024-09-18T00:29:30.356145+00:00
ab897574-5b8c-45e2-9fd8-856ac8f78c1b5063CUIDADOS COM O MATERIAL DE SUPORTE PARA INFUSÃO DE IMUNOTERAPIA COM MOLÉCULA BISESPECÍFICA ATIVADORA DE CÉLULAS T PARA LEUCEMIA LINFOBLÁSTICA AGUDA (LLA) B DERIVADA PEDIÁTRICA EM PRIMEIRA RECIDIVA MEDULAR DE ALTO RISCO (POR TROCA DE BOLSA)0239030407009220240211<span class="null">NULL</span>327230<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:30.356145+00:002024-09-18T00:29:30.356145+00:00
636c88de-79d3-4620-9112-79cd700b3c3a4494RESTAURAÇÃO DE DENTE PERMANENTE ANTERIOR01571ABPO02220240211133623016861<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>1<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
2ea97668-e4da-4a52-9acb-329a2dd85fbb1687RESTAURAÇÃO DE DENTE PERMANENTE POSTERIOR015710307010040202402111336231<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
60050db9-a820-43ab-86f6-705fbbaa15c84493RESTAURAÇÃO DE DENTE DECÍDUO01571ABPO02120240211133623016851<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>1<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
76cf02e5-20b5-4b91-920b-539bbeadde2e4495RESTAURAÇÃO DE DENTE PERMANENTE POSTERIOR01571ABPO02320240211133623016871<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>1<span class="null">NULL</span>12021-05-25T19:39:57.283000+00:002021-05-25T19:39:57.283000+00:00
98d8b0cc-7f3e-444a-bada-7a71e411aab53298RESSECCAO EM CUNHA DE LABIO E SUTURA EM ONCOLOGIA144157104160301492024021134571431<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
0a2dca28-05a1-41a4-80bc-ad4e3c1b50243299RESSECCAO PARCIAL DE LABIO COM ENXERTO OU RETALHO EM ONCOLOGIA144157104160301572024021134571431<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
bc22efeb-6f00-4223-9a62-bb0c0bd6ac593300RESSECCAO TOTAL DE LABIO E RECONSTRUCAO COM RETALHO MIOCUTANEO EM ONCOLOGIA144157104160301652024021134571431<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
c01a11d5-9e37-41b7-a868-678de4b648b42867RETIRADA DE CORPO ESTRANHO INTRA-ARTICULAR0157104080603282024021124412141<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
b4bb710b-2345-46b2-847a-7208df02d49f2868RETIRADA DE CORPO ESTRANHO INTRA-ÓSSEO0157104080603362024021124412141<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
9c552291-19fa-4355-a274-7345acc2ff092869RETIRADA DE ESPAÇADORES / OUTROS MATERIAIS0157104080603442024021124412141<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
50de8777-a9ee-42e1-9242-a46459362e672870RETIRADA DE FIO OU PINO INTRA-ÓSSEO0157104080603522024021124412141<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
68775da6-e0b7-43e5-9746-56718b2a9edc3141RETIRADA DE DRENO TUBULAR TORACICO0157104120301282024021124501311<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
c5e37eb3-f876-4142-8426-0490308b6d1d2676RETIRADA DE CORPO ESTRANHO DA COLUNA TORACO-LOMBO-SACRA POR VIA ANTERIOR0157104080305932024021134411291<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
b4cf9dcb-5481-49a5-8339-f0026917125e1360RETIRADA DE CORPO ESTRANHO DO ESOFAGO0157103030700482024021123212311<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
b77cbf30-7e8d-403d-b591-070e6814b12c1361RETIRADA DE CORPO ESTRANHO DO ESTOMAGO / DUODENO0157103030700562024021123212311<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
c68aba15-c070-4360-b3d7-6c20e19d95351775RETIRADA DE LESAO POR SHAVING01571040101012020240211248271<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
0a44f99a-5b74-4e11-84a0-07509e4187ca1815RETIRADA DE DERIVACAO VENTRICULAR PARA PERITONEO / ATRIO / PLEURA / RAQUE015710403010160202402112420291<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
be95147d-1260-4f6d-b5af-f9cc0e12455a1953RETIRADA DE CORPO ESTRANHO DE OUVIDO / FARINGE / LARINGE / NARIZ015710404010318202402112424301<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
ed65d462-b7a9-4203-925e-3db2a44243791997RETIRADA DE CORPO ESTRANHO DOS OSSOS DA FACE015710404020313202402112424841<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