Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
sequencia	INTEGER
descricao	TEXT
idade_minima	INTEGER
idade_maxima	INTEGER
codigo	TEXT
competencia_bpa	TEXT
masculino	INTEGER
feminino	INTEGER
procedimento_complexidade	INTEGER
tb_grupo	INTEGER
tb_sub_grupo	INTEGER
tb_forma_organizacao	INTEGER
filtro_padrao_esus	INTEGER
codigo_sigtap	INTEGER
idade_aplicavel	INTEGER
tipo	TEXT
plano	INTEGER
exame	INTEGER
padrao_dab	INTEGER
esus_id	INTEGER
ativo	INTEGER
data_criacao	TEXT
data_alteracao	TEXT

id	sequencia	descricao	idade_minima	idade_maxima	codigo	competencia_bpa	masculino	feminino	procedimento_complexidade	tb_grupo	tb_sub_grupo	tb_forma_organizacao	filtro_padrao_esus	codigo_sigtap	idade_aplicavel	tipo	plano	exame	padrao_dab	esus_id	ativo	data_criacao	data_alteracao
b220f77f-9fea-49f9-9346-49e171655a6d	1287	TRATAMENTO Clinico DAS MIELITES / MIELOPATIAS	0	1571	0303040130	202402	1	1	2	3	21	145	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
fd0dbdd5-2db1-458b-8913-239eea7cc7e2	1848	TRATAMENTO CIRURGICO DE SINDROME COMPRESSIVA EM TUNEL OSTEO-FIBROSO AO NIVEL DO CARPO	12	1571	0403020123	202402	1	1	2	4	20	83	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
3680b787-ffe1-4950-9d19-5bdab1af1ca0	1962	TRATAMENTO CIRURGICO DE RINITE CRONICA (OZENA)	0	1571	0404010407	202402	1	1	2	4	24	30	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
239d85a3-6477-4064-a954-8a191b483169	2003	TRATAMENTO CIRÚRGICO DO SOALHO DA ÓRBITA	0	1571	0404020429	202402	1	1	2	4	24	84	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
b32933ba-5f88-46d7-b375-6b78b3e44655	2054	TRATAMENTO CIRÚRGICO REPARADOR DA FISSURA FACIAL RARA EM PACIENTES COM ANOMALIA CRÂNIO E BUCOMAXILOFACIAL	0	1571	0404030289	202402	1	1	3	4	24	125	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
1dde6bd9-2443-4a16-891e-5ced49c2cd65	2115	TRATAMENTO CIRURGICO DE XANTELASMA	144	1571	0405040199	202402	1	1	2	4	29	160	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
bb00a49f-8914-4dc6-8f19-f8bf98982067	2330	TRATAMENTO CIRURGICO DE VARIZES (BILATERAL)	0	1571	0406020566	202402	1	1	2	4	34	86	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
a6dec84b-94d1-4efe-8de1-9ac2bff38d71	2331	TRATAMENTO CIRURGICO DE VARIZES (UNILATERAL)	0	1571	0406020574	202402	1	1	2	4	34	86	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
5e7c38d4-dceb-4c41-b0ed-3ce7ebeee639	2425	TRATAMENTO CIRURGICO DE VARIZES ESOFAGICAS	240	1571	0407010300	202402	1	1	2	4	38	33	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
8348436e-d6a0-4c3b-b724-943d1ee3b547	2553	TRATAMENTO CIRURGICO DE RETARDO DE CONSOLIDACAO DA PSEUDARTROSE DE CLAVICULA / ESCAPULA	0	1571	0408010223	202402	1	1	2	4	41	34	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
49b0bb7e-7b7a-4477-a901-2c48faaa5176	2615	TRATAMENTO CIRÚRGICO DE ROTURA / DESINSERÇÃO / ARRANCAMENTO CAPSULO-TENO-LIGAMENTAR NA MÃO	0	1571	0408020610	202402	1	1	2	4	41	88	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
1cb39f11-0d77-4a73-ac61-d8d6ae63f02b	2617	TRATAMENTO CIRÚRGICO DE SINOSTOSE RÁDIO ULNAR	0	1571	0408020636	202402	1	1	2	4	41	88	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
7fb576a0-d55a-4c81-ba76-9464435bc4db	2618	TRATAMENTO CIRÚRGICO P/ CENTRALIZAÇÃO DO PUNHO	0	1571	0408020644	202402	1	1	2	4	41	88	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
bf0d55be-0451-4363-a7cc-49757d2b11d0	2692	TRATAMENTO CIRURGICO DE TORCICOLO CONGENITO	12	227	0408030755	202402	1	1	2	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
69c594bc-4133-4acd-bd9f-7f88a6ceeb8d	3257	TRATAMENTO CIRURGICO EM POLITRAUMATIZADO	0	1571	0415030013	202402	1	1	0	4	56	110	1	<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>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
cd2d7c6a-5f8e-4a33-8d21-0156b9a60aab	2902	TRATAMENTO CIRÚRGICO DE RETRAÇÃO MUSCULAR	0	1571	0408060670	202402	1	1	2	4	41	214	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
51625e53-6371-4b55-bcf8-b876977dd1bd	2903	TRATAMENTO CIRÚRGICO DE RUTURA DO APARELHO EXTENSOR DO DEDO	0	1571	0408060689	202402	1	1	2	4	41	214	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
f11be42c-6af8-4d31-ae4e-cb72dd89a92d	2956	TRATAMENTO CIRURGICO DE REFLUXO VESICO-URETERAL	0	1571	0409010502	202402	1	1	2	4	42	35	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
f45d7cb1-e070-4b07-9e6d-d7d6c28b43c5	3008	TRATAMENTO CIRURGICO DE TORCAO DO TESTICULO / DO CORDAO ESPERMATICO	0	1571	0409040223	202402	1	0	2	4	42	164	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
c846d50b-29f7-4312-a4b3-2c5171d21f7a	3009	TRATAMENTO CIRURGICO DE VARICOCELE	120	1571	0409040231	202402	1	0	2	4	42	164	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
27da1753-073c-4ff2-a6fc-2f17be23604c	3078	TRATAMENTO CIRURGICO DE VAGINA SEPTADA / ATRESICA	0	1571	0409070289	202402	0	1	2	4	42	228	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
67b5efa5-7d80-446c-b039-f26f40b86e75	3208	TRATAMENTO CIRURGICO DE RETRACAO CICATRICIAL DA AXILA	0	1571	0413040186	202402	1	1	2	4	53	144	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
9f8d4fd7-a832-4349-aed8-714230ed5a2c	3209	TRATAMENTO CIRURGICO DE RETRACAO CICATRICIAL DO COTOVELO	0	1571	0413040194	202402	1	1	2	4	53	144	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
912eccb8-1b78-4642-8234-45f269841baf	3210	TRATAMENTO CIRURGICO DE RETRACAO CICATRICIAL DOS DEDOS DA MAO/PE S/ COMPROMETIMENTO TENDINOSO	0	1571	0413040208	202402	1	1	2	4	53	144	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
a3d3d953-1bf7-46f0-b11b-d3424dd03823	3211	TRATAMENTO CIRÚRGICO DE RETRAÇÃO CICATRICIAL EM UM ESTÁGIO	0	1571	0413040216	202402	1	1	3	4	53	144	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
6bb23961-061d-4353-8c09-d889cf74f466	3245	TRATAMENTO CIRÚRGICO PARA TRACIONAMENTO DENTAL	60	1571	0414020367	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
a953c568-69d7-49a5-8a01-bda65efa4faf	3246	TRATAMENTO CIRÚRGICO PERIODONTAL (POR SEXTANTE)	60	1571	0414020375	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
c8f9e11d-5447-4a22-a1ea-21cf7eccdb5c	1865	TRATAMENTO CONSERVADOR DE TUMOR DO SISTEMA NERVOSO CENTRAL	0	1571	0403030170	202402	1	1	3	4	20	124	1	<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>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
3aac089a-9e78-404f-bcbb-89601da40fa8	708	RADIOGRAFIA DE PE / DEDOS DO PE	0	1571	0204060150	202402	1	1	2	2	25	207	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
717db7e7-3583-49f7-a47e-a15a3fc39bc5	709	RADIOGRAFIA DE PERNA	0	1571	0204060168	202402	1	1	2	2	25	207	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
93a005a9-b275-4822-9e01-e2306490bff1	710	RADIOGRAFIA PANORAMICA DE MEMBROS INFERIORES	0	1571	0204060176	202402	1	1	2	2	25	207	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
0925043c-920f-4b32-be55-211a0b8c94c4	873	ELETRODIAGNÓSTICO CINÉTICO FUNCIONAL	0	1571	0211030082	202402	1	1	2	2	49	140	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
2b527c4b-2579-468f-9f66-5bebec5307b8	926	AVALIACAO DE LINGUAGEM ESCRITA / LEITURA	0	131	0211070068	202402	1	1	2	2	49	225	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.267000+00:00	2021-05-25T19:39:57.267000+00:00
70cd7b87-a6b2-472a-a87a-589ffbb3d063	928	AVALIACAO MIOFUNCIONAL DE SISTEMA ESTOMATOGNATICO	0	1571	0211070084	202402	1	1	2	2	49	225	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.267000+00:00	2021-05-25T19:39:57.267000+00:00
fe5f8c07-e002-4783-85ed-b7679a4b412f	929	AVALIACAO P/ DIAGNOSTICO DE DEFICIENCIA AUDITIVA	36	1571	0211070092	202402	1	1	2	2	49	225	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.267000+00:00	2021-05-25T19:39:57.267000+00:00
c79de7fe-d6b2-4c35-8be8-a74f6e06ca61	930	AVALIACAO P/ DIAGNOSTICO DIFERENCIAL DE DEFICIENCIA AUDITIVA	0	1571	0211070106	202402	1	1	3	2	49	225	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.267000+00:00	2021-05-25T19:39:57.267000+00:00
7610a133-d288-400c-a218-aa4e68e23dd1	949	REAVALIACAO DIAGNOSTICA DE DEFICIENCIA AUDITIVA EM PACIENTE MAIOR DE 3 ANOS	36	1571	0211070297	202402	1	1	2	2	49	225	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
63b90e92-b014-4973-9cb7-e65232707d27	4984	ACOMPANHAMENTO DE PACIENTES NO PRÉ TRANSPLANTE DE CORAÇÃO	0	1211	0506010210	202402	1	1	<span class="null">NULL</span>	5	32	50	<span class="null">NULL</span>	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:59.617772+00:00	2024-09-18T00:29:59.617772+00:00
1766b760-13ea-4f99-96c1-280fbb3ed0e6	4786	PESQUISA DE SARS-COV-2 POR RT - PCR	0	1571	0213010720	202402	1	1	2	2	13	1	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
4eebc845-b615-48e2-bbd4-b479ebef512f	189	DOSAGEM DE MUCO-PROTEINAS	0	1571	0202010570	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
37e35058-373e-42de-903e-a1f5bc11b640	548	DOSAGEM DE FRUTOSE	0	1571	0202090108	202402	1	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
a6f98ef1-6c1e-44ac-bf60-20482bc65ab2	281	DOSAGEM DE IMUNOGLOBULINA G (IGG)	0	1571	0202030172	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
60b02675-ba48-4f6d-97fc-274d9d8581e8	4986	HIDROXICLOROQUINA 200 MG (POR COMPRIMIDO)	0	1571	0604080034	202402	1	1	<span class="null">NULL</span>	6	26	237	<span class="null">NULL</span>	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:59.617772+00:00	2024-09-18T00:29:59.617772+00:00
bf7daa86-d022-4f77-ae61-12f1e2c4d50e	4985	TRATAMENTO DE INTERCORRENCIA PÓS TRANSPLANTE DE PÂNCREAS - PÓS TRANSPLANTE CRÍTICO	0	1571	0506020134	202402	1	1	<span class="null">NULL</span>	5	32	69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:59.617772+00:00	2024-09-18T00:29:59.617772+00:00
8948bd65-1b4a-438d-99bd-ca42ead88128	598	PESQUISA DE FATOR RH (INCLUI D FRACO)	0	1571	0202120082	202402	1	1	2	2	9	280	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
785c5ef9-2aa4-48ca-948e-d9dff1372aca	310	PESQUISA DE ANTICORPOS ANTIESPERMATOZOIDES	120	1571	0202030466	202402	1	0	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
48efae8f-5e0d-455b-8292-4467a81a72ea	1645	TRATAMENTO CLÍNICO DE PACIENTE ONCOLÓGICO	0	1571	0304100021	202402	1	1	2	3	27	257	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
229af55e-0d5e-4367-9fba-a8e377098a29	1277	TRATAMENTO DA MIGRANEA COMPLICADA	60	1571	0303040033	202402	1	1	2	3	21	145	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
c7dc3a6b-4251-479b-89c2-3cf63604873f	1278	TRATAMENTO Clinico DE ABSCESSO CEREBRAL	144	1571	0303040041	202402	1	1	2	3	21	145	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
fc5848b4-c225-4248-8744-9a8fd18a484a	1279	TRATAMENTO Clinico DE COREIA AGUDA	60	1571	0303040050	202402	1	1	2	3	21	145	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00