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
5543e0ff-09f1-4b8c-934f-0f432f1683402841ARTROPLASTIA DE RESSECÇÃO DE MÉDIA / GRANDE ARTICULAÇÃO0157104080600692024021124412141<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
42405535-a5c4-49d2-8e33-de275838b7b91168ATENDIMENTO DOMICILIAR PARA PACIENTES DE CENTRO DE ATENÇÃO PSICOSSOCIAL E/OU FAMILIARES015710301080240202402112312401<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.266000+00:002021-05-25T19:39:57.266000+00:00
bce55045-09b9-45e6-874b-a86b3bd3c2b71428ATENDIMENTO A PACIENTE SOB CUIDADOS PROLONGADOS DEVIDO A CAUSAS EXTERNAS0157103031300162024021123212831<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
a83cd5d1-e652-4cf8-b1db-85bd87d27bad1429ATENDIMENTO A PACIENTE SOB CUIDADOS PROLONGADOS POR ENFERMIDADES CARDIOVASCULARES0157103031300242024021123212831<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
fce9b825-9737-4c53-ad01-d566c3bdf52d1760ATENDIMENTO AO RECEM-NASCIDO NO MOMENTO DO NASCIMENTO000310010020202402112346261<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
758063dd-7a77-469d-98ae-ea6e877321aa2842ARTROPLASTIA DE RESSECÇÃO DE PEQUENAS ARTICULAÇÕES0157104080600772024021124412141<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
f2f672e2-9f76-49a7-8345-15daaab392772534ARTROPLASTIA ESCAPULO-UMERAL (NÃO CONVENCIONAL)015710408010037202402113441341<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
745cc88e-c2f5-4905-a908-252a2a6d35922535ARTROPLASTIA ESCAPULO-UMERAL PARCIAL21615710408010045202402112441341<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
97668ef9-b70b-4f2f-b7df-01095bc5f9f42536ARTROPLASTIA ESCAPULO-UMERAL TOTAL48015710408010053202402113441341<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
9568713c-87a6-4bc1-be52-1cbec53fdf7e2712ARTROPLASTIA DE QUADRIL (NÃO CONVENCIONAL)0157104080400412024021134411631<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
cdd6313f-48e8-4d7e-83f3-6dd83b8d43912713ARTROPLASTIA PARCIAL DE QUADRIL216157104080400502024021124411631<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
e63d2bc0-f692-4c65-af8c-1a816c112cdf2714ARTROPLASTIA TOTAL DE CONVERSÃO DO QUADRIL216157104080400682024021134411631<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
821e10d9-5776-4f93-bade-af040f2630082715ARTROPLASTIA DE REVISÃO OU RECONSTRUÇÃO DO QUADRIL180157104080400762024021134411631<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
4e32ef48-ff28-48fe-9ed8-e20780b02c552716ARTROPLASTIA TOTAL PRIMÁRIA DO QUADRIL CIMENTADA180157104080400842024021124411631<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
c05f39db-1926-4b20-8eaf-c707fc1be9812717ARTROPLASTIA TOTAL PRIMARIA DO QUADRIL NÃO CIMENTADA / HÍBRIDA180157104080400922024021134411631<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
956f7eec-efa5-4dd6-b286-1d08a4d9ba702748ARTROPLASTIA TOTAL DE JOELHO - REVISAO / RECONSTRUCAO192157104080500552024021134411871<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
8553e3a7-3ad6-4cc7-afef-3518d96f75283174ATENDIMENTO DE URGENCIA EM MEDIO E GRANDE QUEIMADO015710413010015202402112453391<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
7a4f0aaa-a7f2-4d07-a1a7-31dc4363910b1142ACOMPANHAMENTO NEUROPSICOLOGICO DE PACIENTE EM REABILITACAO015710301070040202402112312241<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.264000+00:002025-10-13T19:21:00.432000+00:00
1eaf59f3-b2b0-4980-93c3-f58eaa067ad81118ASSISTENCIA DOMICILIAR TERAPEUTICA MULTIPROFISSIONAL EM HIV/AIDS (ADTM)015710301050040202402112311941<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002021-05-25T19:39:57.266000+00:00
b48702e4-6c76-4e01-bf6a-838c47c8949a1131ATENDIMENTO DE URGÊNCIA EM ATENÇÃO BÁSICA015710301060037202402111312131<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002021-05-25T19:39:57.266000+00:00
79be6320-4cc4-47ec-95ee-719888ea99a71144ATENDIMENTO / ACOMPANHAMENTO EM REABILITAÇÃO NAS MULTIPLAS DEFICIÊNCIAS015710301070067202402112312241<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002021-05-25T19:39:57.266000+00:00
65dc1a9b-74b2-4d59-9ac5-3381c52c0d4e1145ATENDIMENTO / ACOMPANHAMENTO DE PACIENTE EM REABILITACAO DO DESENVOLVIMENTO NEUROPSICOMOTOR015710301070075202402112312241<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002024-08-07T19:13:06.290000+00:00
e9a9a240-a172-4129-8d11-c7dcbb6b297b1759ASSISTÊNCIA AO PARTO SEM DISTOCIA1087310310010012202402011346261<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002021-05-25T19:39:57.266000+00:00
a7373595-afeb-4e19-8a36-c368037917744602ATENDIMENTO DE PACIENTE EM CUIDADOS PALIATIVOS015710301140014202402111313791<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002024-11-08T19:37:23.481000+00:00
66be1964-7034-484b-b994-4654699766351233ATENDIMENTO FISIOTERAPÊUTICO NAS DESORDENS DO DESENVOLVIMENTO NEURO MOTOR0157103020600302024021123162091<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.266000+00:002021-05-25T19:39:57.266000+00:00
6ad14652-46d8-4b4e-8033-635fbeb1edc61221ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTES COM ALTERAÇÕES OCULOMOTORAS CENTRAIS C/ COMPROMETIMENTO SISTÊMICO0157103020300182024021123161421<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.266000+00:002021-05-25T19:39:57.266000+00:00
b7048e74-e6e4-4f41-8201-c44c419ee3e71230ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTES NO PRÉ E PÓS-OPERATÓRIO NAS DISFUNÇÕES MUSCULO- ESQUELETICAS C/ COMPLICAÇÕES SISTEMICAS0157103020500352024021123161951<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.266000+00:002021-05-25T19:39:57.266000+00:00
29a282cd-0c0d-4783-b14d-300ade3437051164ATENDIMENTO INDIVIDUAL DE PACIENTE EM CENTRO DE ATENÇÃO PSICOSSOCIAL015710301080208202402112312401<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.266000+00:002021-05-25T19:39:57.266000+00:00
79833178-5261-4eac-8998-89773c2bd1be1190CATETERISMO VESICAL DE DEMORA015710301100055202402111312631<span class="null">NULL</span>1CLINICO100<span class="null">NULL</span>12021-05-25T19:39:57.268000+00:002026-04-09T19:32:20.633000+00:00
941695d9-42c7-4079-9c52-687df436ee511165ATENDIMENTO EM Grupo DE PACIENTE EM CENTRO DE ATENÇÃO PSICOSSOCIAL015710301080216202402112312401<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.266000+00:002021-05-25T19:39:57.266000+00:00
cd71b471-34f8-43c0-95f1-6351772152581166ATENDIMENTO FAMILIAR EM CENTRO DE ATENÇÃO PSICOSSOCIAL015710301080224202402112312401<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.266000+00:002021-05-25T19:39:57.266000+00:00
d149fa30-c792-4b03-ad27-2cddff0685971219ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE ONCOLÓGICO CLÍNICO0157103020200202024021123161081<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.266000+00:002021-05-25T19:39:57.266000+00:00
a3d3f6ce-66da-4285-be08-d2321f57c10c1222ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE COM ALTERAÇÕES OCULOMOTORAS PERIFÉRICAS0157103020300262024021123161421<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.266000+00:002021-05-25T19:39:57.266000+00:00
0ce8ff9d-8fca-4405-befc-fb29a674c86f1225ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE COM TRANSTORNO CLÍNICO CARDIOVASCULAR0157103020400302024021123161731<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.266000+00:002021-05-25T19:39:57.266000+00:00
3ae950b4-3329-41eb-a60f-1caadf97d8da1226ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE PRÉ/PÓS CIRURGIA CARDIOVASCULAR0157103020400482024021123161731<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.266000+00:002021-05-25T19:39:57.266000+00:00
f15f3ec5-e702-4f1a-8d4b-c9d457d1e2061227ATENDIMENTO FISIOTERAPÊUTICO NAS DISFUNÇÕES VASCULARES PERIFÉRICAS0157103020400562024021123161731<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.266000+00:002021-05-25T19:39:57.266000+00:00
d6b9d313-4b6b-47c9-b4f7-91af8a8e0c854587ATENDIMENTO EM Grupo NA ATENÇÃO BÁSICA015710301040087202402111311721<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002021-05-25T19:39:57.266000+00:00
232771df-1561-43cd-b04f-cc3af7f1ad0d4850RESTAURAÇÃO DE DENTE PERMANENTE POSTERIOR COM AMÁLGAMA601571030701013920240211<span class="null">NULL</span>33623<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:44.019789+00:002024-09-18T00:27:44.019789+00:00
33b6e96d-cc38-4464-8bca-df87f4452da71487COBALTOTERAPIA (POR CAMPO)015710304010090202402113327201<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.269000+00:002021-05-25T19:39:57.269000+00:00
a05925b5-5b58-4d80-818c-143b8a8623b02826TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA METÁFISE DISTAL DO FÊMUR0157104080508372024021124411871<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
1a2aa7cc-00d0-4ded-914c-8ad3d24f711c2827TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO AO NÍVEL DO JOELHO0157104080508452024021124411871<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
6e411ba0-f8e3-431b-bee7-9d4abb2accbe1215ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE NO PRÉ/PÓS CIRURGIAS UROGINECOLÓGICAS015710302010017202402112316181<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.266000+00:002021-05-25T19:39:57.266000+00:00
bd99c4c7-0c0e-41f3-a2ed-a25b5dc8441e3675DANAZOL 200 MG (POR CAPSULA)0157106041400372024021136262891<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.266000+00:002021-05-25T19:39:57.266000+00:00
17d81de6-a01e-499b-b633-81931e5c2dc91216ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTES C/ DISFUNÇÕES UROGINECOLÓGICAS015710302010025202402112316181<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.266000+00:002021-05-25T19:39:57.266000+00:00
f0020f2b-85d2-4378-896c-cafbedab03f21217ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE NEONATO010302010033202402112316181<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.266000+00:002021-05-25T19:39:57.266000+00:00
b365916d-b7d3-40df-8eca-db4f31d74c791218ATENDIMENTO FISIOTERAPÊUTICO DE PACIENTE COM CUIDADOS PALIATIVOS0157103020200122024021123161081<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.266000+00:002021-05-25T19:39:57.266000+00:00
24f7132b-3867-471a-b0ec-b001cc7004f41220ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE NO PRÉ E PÓS CIRURGIA ONCOLÓGICA0157103020200392024021123161081<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.266000+00:002021-05-25T19:39:57.266000+00:00
0e64b7dd-f985-4502-850a-c00115a15b0a1123ATENDIMENTO MEDICO COM FINALIDADE DE ATESTAR OBITO015710301050090202402111311941<span class="null">NULL</span>1ADMINISTRATIVO000<span class="null">NULL</span>12021-05-25T19:39:57.266000+00:002025-10-20T19:28:04.886000+00:00
4b2a635d-cd63-475f-af1d-6c610f6462eb1234ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE C/ COMPROMETIMENTO COGNITIVO0157103020600492024021123162091<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.266000+00:002021-05-25T19:39:57.266000+00:00
10f25583-d42f-43f8-b867-06b2eabdff5f1231ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTES COM DISTÚRBIOS NEURO-CINÉTICO-FUNCIONAIS SEM COMPLICAÇÕES SISTÊMICAS0157103020600142024021123162091<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.266000+00:002024-11-25T19:41:35.331000+00:00