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
d0744243-d876-4ae2-90bf-d8d2e00d9d3a2945RETIRADA PERCUTANEA DE CALCULO URETERAL C/ CATETER015710409010391202402112442351<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
7d3d1e08-fbdd-47cc-b84f-9a31b6d4d5a53095RETIRADA DE PRÓTESE MAMÁRIA UNILATERAL EM CASOS DE COMPLICAÇÃO DE IMPLANTAÇÃO DA PRÓTESE, COM IMPLANTAÇÃO DE NOVA PRÓTESE, NO MESMO ATO CIRÚRGICO19215710410010154202402112445361<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
e466f76d-820a-425e-a4ab-a77f3c0a34a23096RETIRADA DE PRÓTESE MAMÁRIA BILATERAL EM CASOS DE COMPLICAÇÃO DE IMPLANTAÇÃO DA PRÓTESE, COM IMPLANTAÇÃO DE NOVA PRÓTESE NO MESMO ATO CIRÚRGICO19215710410010162202402112445361<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
391825d0-6957-41c3-8197-d4953be868bc3477RETIRADA UNI / BILATERAL DE RIM (PARA TRANSPLANTE) - DOADOR FALECIDO0109105030300822024021135221131<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
2355408e-7388-4bc0-9e9c-ca6133e87a833478RETIRADA DE TECIDO ÓSTEO -FASCIO-CONDRO- LIGAMENTOSO12085105030300902024021135221131<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
d41c4522-887b-41e9-a50e-b364c8a364155064IMUNOTERAPIA COM MOLÉCULA BISPECÍIFICA ATIVADORA DE CÉLULAS T PARA LEUCEMIA LINFOBLÁSTICA AGUDA (LLA) B DERIVADA PEDIÁTRICA EM PRIMEIRA RECIDIVA MEDULAR DE ALTO RISCO (POR FRASCO AMPOLA)0239030408008020240211<span class="null">NULL</span>327236<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
f1c8d5bc-d3c5-4467-8e5e-6c4ab29ed91f5065TRATAMENTO DO ACIDENTE VASCULAR CEREBRAL ISQUÊMICO AGUDO COM TROMBECTOMIA MECÂNICA2161571040307017120240211<span class="null">NULL</span>420229<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
18719fd1-36cf-4663-981a-00fb18e8bcd55066OSTEOTOMIA DA MANDÍBULA PARA DISTRAÇÃO OSTEOGÊNICA MANDIBULAR01571040402079820240211<span class="null">NULL</span>42484<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
d5b0a788-bd6d-42d3-87f4-7e8116f976c1826RETOSSIGMOIDOSCOPIA015710209010053202402112244111<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
35ee7db3-51cb-4114-855a-bc17641ef24b1696RETRATAMENTO ENDODÔNTICO EM DENTE PERMANENTE BI-RADICULAR015710307020088202402112336781<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
c2707cc1-ed20-4e67-a876-6a23d5d753093369SACRALECTOMIA (ENDOPELVECTOMIA) EM ONCOLOGIA0157104160900792024021134572461<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
8ebc27ca-fd21-447d-a82a-7acf589167aa3813RIBAVIRINA 250 MG (POR CAPSULA)0157106044500102024021136263481<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
a149dc9d-c787-432e-8337-bdd1911b1d463838RISPERIDONA 3 MG (POR COMPRIMIDO)0157106045100392024021136263541<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
2fb59394-7205-4032-bc4f-69b8e5bb9c674746RIVASTIGMINA 18 MG ADESIVO TRANSDÉRMICO480157106041301392024021136262871<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
21c94143-1c13-404f-822f-4d0e4beb07c13710SACARATO DE HIDROXIDO FERRICO 100 MG INJETAVEL (POR FRASCO DE 5 ML)0157106042600162024021136263191<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
2571c12a-3a22-4ac0-9cdc-afaa8f1a87451502ROENTGENTERAPIA (POR CAMPO)015710304010260202402113327201<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
aea3738f-88f5-480c-9905-8efa1732082f1096SAMU 192: ATENDIMENTO PRÉ-HOSPITALAR MOVEL REALIZADO POR EMBARCAÇÃO015710301030057202402112311411<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.283000+00:002021-05-25T19:39:57.283000+00:00
7842dc15-dc4a-499c-81b7-fcd45c967ca61385REVISÃO COM TROCA DE APARELHO GESSADO EM MEMBRO INFERIOR0157103030900732024021123212471<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
7c9d7dcb-3754-4fcf-9004-e2e7e84458321387REVISÃO COM TROCA DE APARELHO GESSADO EM MEMBRO SUPERIOR0157103030900902024021123212471<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
3584d124-8140-4298-ab6e-1e4bf04a8e901817REVISAO DE DERIVACAO VENTRICULAR PARA PERITONEO / ATRIO / PLEURA / RAQUE015710403010187202402112420291<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
aa32b4d5-4b58-48a2-8e16-5d7ab68a2a2b3635SALBUTAMOL 100 MCG AEROSSOL (POR FRASCO DE 200 DOSES)0157106040400832024021136261521<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
7ebf4505-7e4a-4468-bf20-a960a7e9263d1998RINOPLASTIA PARA DEFEITOS PÓS-TRAUMÁTICOS015710404020321202402112424841<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
1775712a-fb23-460c-8d60-c9e8c6f631c32044RINOSEPTOPLASTIA EM PACIENTE COM ANOMALIA CRÂNIO E BUCOMAXILOFACIAL0157104040301302024021134241251<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
0bc35986-f247-491d-8f1d-4ca263c7407b2046RINOPLASTIA EM PACIENTE COM ANOMALIA CRÂNIO E BUCOMAXILOFACIAL0157104040301652024021124241251<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
2470f905-39f7-40f7-aaa1-889014bb90e02678REVISÃO DE ARTRODESE / TRATAMENTO CIRÚRGICO DE PSEUDARTOSE DA COLUNA TORACO-LOMBO-SACRA ANTERIOR0157104080306152024021134411291<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
5fdcdf72-9e60-4b41-afe9-db978c7362022679REVISÃO DE ARTRODESE / TRATAMENTO CIRÚRGICO DE PSEUDARTROSE DA COLUNA CERVICAL POSTERIOR0157104080306232024021134411291<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
0f0c70d7-08f4-4c02-b6b8-1dec405a724e2680REVISÃO DE ARTRODESE / TRATAMENTO CIRÚRGICO DE PSEUDARTROSE DA COLUNA TORACO-LOMBO-SACRA POSTERIOR0157104080306312024021134411291<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
b3220885-2ef5-4bcd-b457-f7a970692d1b2681REVISÃO DE ARTRODESE TRATAMENTO CIRÚRGICO DE PSEUDOARTORSE DA COLUNA CERVICAL ANTERIOR0157104080306402024021134411291<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
b2f6bae9-872a-4036-9adc-c936944d332a3045SALPINGECTOMIA UNI / BILATERAL0157104090602322024020124422111<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
53aab7e0-1584-4273-9b10-f780111a33183046SALPINGECTOMIA VIDEOLAPAROSCOPICA0157104090602402024020124422111<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
db2d8861-0b16-4497-8553-3e28ef26f5113047SALPINGOPLASTIA12073104090602592024020124422111<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
8a6b5fbb-098b-42c2-afc3-dcf134da9b273048SALPINGOPLASTIA VIDEOLAPAROSCOPICA0157104090602672024020124422111<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
c70b8718-0730-4084-beb4-4ab559194de63636SALMETEROL 50 MCG PO INALANTE OU AEROSSOL BUCAL (POR FRASCO DE 60 DOSES)0157106040400912024021136261521<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
b30b0d50-cdec-4d87-8ecf-07c4e24f11d53681RISEDRONATO 5 MG (POR COMPRIMIDO)0157106041600462024021136262951<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
52eefe8a-4d52-4a41-9309-cd65ba32d0dd3682RISEDRONATO 35 MG (POR COMPRIMIDO)0157106041600542024021136262951<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
93fcb58b-0039-4c97-a5a9-5e23c4a7d8c63836RISPERIDONA 1 MG (POR COMPRIMIDO)0157106045100122024021136263541<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
6dc533c5-6598-400c-8e95-df4b452d73083837RISPERIDONA 2 MG (POR COMPRIMIDO)0157106045100202024021136263541<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
b322170e-b212-4192-a8ed-4fb649959d264639RISPERIDONA 1,0 MG/ML SOLUÇÃO ORAL (POR FRASCO DE 30 ML)60157106045100472024021136263541<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
3d520f75-1059-45d9-b881-47a941b6633f3844RILUZOL 50 MG (POR COMPRIMIDO)0157106045400192024021136263571<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
e8a719fa-eba5-4ffe-b8e0-e44cc939d8c61884RIZOTOMIA PERCUTANEA COM BALÃO0157104030500902024021134201841<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
8b574892-5e76-4567-8d7a-46222ac11c781885RIZOTOMIA PERCUTANEA POR RADIOFREQUENCIA0157104030501032024021134201841<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
be8513dd-5d11-45e7-984e-2e6a4316a9155067NEOFALOPLASTIA EM HOMENS TRANS216911040905016420240211<span class="null">NULL</span>442188<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
a0d08488-bcf9-427d-b719-22f580e7ae2b5068PROVAS CRUZADAS EM DOADORES DE MEDULA ÓSSEA (APARENTADO NÃO IDÊNTICO)01331050104011020240211<span class="null">NULL</span>57147<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
9de4a921-b74e-44fb-98f9-a3dbe6842be95069PROVAS CRUZADAS EM DOADORES VIVOS DE ÓRGÃOS2161091050104012920240211<span class="null">NULL</span>57147<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
0bde4e96-1df8-4ac7-8bb6-b55aaf182f253667RIVASTIGMINA 1,5 MG (POR CAPSULA)480157106041300662024021136262871<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
4c29d17a-8817-4493-80a6-e9fd73898db53668RIVASTIGMINA 2,0 MG/ML SOLUÇÃO ORAL (POR FRASCO DE 120 ML)480157106041300742024021136262871<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
f41326ca-8526-46f7-bdf0-cfcf9fb1969e3671RIVASTIGMINA 6 MG (POR CAPSULA)480157106041301042024021136262871<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
a7cc979d-3e59-469a-9685-7915b65bf08b4745RIVASTIGMINA 9 MG ADESIVO TRANSDÉRMICO480157106041301202024021136262871<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
dd1aa824-cc9b-4f5c-8953-bd558a9e86413385SEGMENTECTOMIA/QUADRANTECTOMIA/SETORECTOMIA DE MAMA EM ONCOLOGIA144157104161200592024021134572811<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
0bc72e28-e67e-487d-82ea-308fc5717a9913SELAMENTO PROVISÓRIO DE CAVIDADE DENTÁRIA01571010102009020240211114931<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