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	esus_id	ativo	data_criacao	data_alteracao
463af8ec-ce02-4f2c-b0fc-7e31f5663269	2474	TRATAMENTO CIRURGICO DE ANOMALIAS CONGENITAS DO ANUS E RETO	0	1571	0407020420	202402	1	1	2	4	38	87	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
e2f387cb-e206-4a7c-9528-74026f1b9424	2554	TRATAMENTO CIRÚRGICO DA SÍNDROME DO IMPACTO SUB-ACROMIAL	240	971	0408010231	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
c5266db5-bbe6-46d8-89ac-c978d271dde0	2585	TRANSPOSIÇÃO DA ULNA PARA O RÁDIO	0	1571	0408020318	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
2883059e-7c8f-4d2c-822c-6ca9af5432f2	2586	TRATAMENTO CIRÚRGICO DE DEDO EM GATILHO	0	1571	0408020326	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
a2900ead-9998-4bda-840e-2040ec88f334	2593	TRATAMENTO CIRÚGICO DE FRATURA DA DIÁFISE DO ÚMERO	0	1571	0408020393	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
efc55910-dd1b-4136-aee1-4997ea399643	2732	TRATAMENTO CIRÚRGICO DA AVULSÃO DE TUBEROSIDADES / ESPINHAS E CRISTA ILÍACA S/ LESÃO DO ANEL PÉLVICO	60	1571	0408040246	202402	1	1	2	4	41	163	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
532f97f8-c349-4936-b338-f5783563a4ac	2733	TRATAMENTO CIRÚRGICO DE ASSOCIAÇÃO FRATURA / LUXAÇÃO / FRATURA-LUXAÇÃO / DISJUNÇÃO DO ANEL PÉLVICO	60	1571	0408040254	202402	1	1	3	4	41	163	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
3e456be7-39cf-4428-a1fd-085938cf0e4b	2785	TRATAMENTO CIRURGICO DAS DESINSERCOES DAS ESPINHAS INTERCONDILARES / EPICONDILARES	0	1571	0408050420	202402	1	1	2	4	41	187	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
d1b2da5c-067a-4888-aa64-784491b2cfca	3072	TRATAMENTO CIRURGICO DE COAPTACAO DE NINFAS	0	1571	0409070220	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
55a3e23e-63ed-47f9-a9e0-e8f0acc2580c	3119	TRAQUEOPLASTIA POR ACESSO TORÁCICO	0	1571	0412010097	202402	1	1	3	4	50	38	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
512a1572-9da7-47af-a3be-1e99dccf0cca	3120	TRAQUEOPLASTIA E/OU LARINGOTRAQUEOPLASTIA	144	1571	0412010100	202402	1	1	3	4	50	38	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
9306d5f0-c746-43cf-878c-a524c38c5dd6	3121	TRAQUEORRAFIA E/OU FECHAMENTO DE FISTULA TRAQUEO-CUTANEA	0	1571	0412010119	202402	1	1	2	4	50	38	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
47076126-7694-4afb-b794-63d11361add9	3130	TRAQUEOSTOMIA MEDIASTINAL	0	1571	0412020076	202402	1	1	3	4	50	91	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
2c952b34-4bd7-46f0-ba2e-252f7e92f45b	2786	TRATAMENTO CIRURGICO DE AVULSAO DO GRANDE E DO PEQUENO TROCANTER	0	1571	0408050438	202402	1	1	2	4	41	187	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
daf24cce-5c3a-44c4-b2c7-584633a9b9a8	832	TRAQUEOSCOPIA	0	1571	0209040033	202402	1	1	2	2	44	170	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
bda9b50c-cb05-4ea7-b3b2-54525b7af3c8	621	RADIOGRAFIA DE LARINGE	0	1571	0204010098	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
9afe427f-6cfa-4af8-8744-befb7a6774a6	622	RADIOGRAFIA DE MASTOIDE / ROCHEDOS (BILATERAL)	0	1571	0204010101	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
8979cebd-eca3-4e89-9c96-7a2be934a26b	626	RADIOGRAFIA DE SEIOS DA FACE (FN + MN + LATERAL + HIRTZ)	0	1571	0204010144	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
1b98af9b-b113-46bb-9b8d-d3e19db8de95	3220	TRATAMENTO CIRÚRGICO DE CISTO DO COMPLEXO MAXILO-MANDIBULAR	0	1571	0414010329	202402	1	1	2	4	54	40	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
0ceb4140-2910-438c-9d4f-574bc45e0ff4	4763	SESSÃO DE GEOTERAPIA	0	1571	0309050146	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
fb3c1ae7-b240-4ad3-8e2a-dbad4096c4fa	2697	TRATAMENTO CIRURGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR DOZE NIVEIS OU MAIS	0	1571	0408030801	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
75ab281f-2094-43ea-bd7c-044cf535d8cf	2706	TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA POSTERIOR DOIS NIVEIS	0	1571	0408030895	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
44674c5a-9147-43c2-875b-8c4aeb0d0653	3006	TRATAMENTO CIRURGICO DE ELEFANTIASE DA BOLSA ESCROTAL	0	1571	0409040207	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
48c4c63a-6da1-47ac-9b7f-8a523b9069d3	3020	TRATAMENTO CIRURGICO DE ELEFANTIASE DO PENIS	0	1571	0409050105	202402	1	0	2	4	42	188	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
fad9dee9-bbad-4396-92f7-26b408599fea	3123	TRATAMENTO CIRURGICO DE FISTULA BRONCOPLEURAL COM AMPUTAÇÃO DE COTO BRONQUICO	0	1571	0412010135	202402	1	1	3	4	50	38	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
f8c27e62-3b67-4c62-92f4-1cb6035b681f	3156	TRATAMENTO CIRÚRGICO DE DEFEITOS CONGÊNITOS DO TORAX	0	1571	0412040182	202402	1	1	3	4	50	165	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
e6efdc41-1d26-4491-868e-ff7b701b6810	3206	TRATAMENTO CIRURGICO DE ELEFANTIASE AO NIVEL DO PE	120	851	0413040160	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
7ac613d5-e57e-44ed-b875-cba2937c1e73	3223	TRATAMENTO CIRÚRGICO DE DENTE INCLUSO EM PACIENTE COM ANOMALIA CRÂNIO E BUCOMAXILOFACIAL	0	1571	0414010370	202402	1	1	3	4	54	40	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
9e3e39ab-9a60-48a9-8baf-f3883c6301a1	627	RADIOGRAFIA DE SELA TURSICA (PA + LATERAL + BRETTON)	0	1571	0204010152	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
6ee16862-8cb1-4ac1-8cbe-9449538f8e30	638	RADIOGRAFIA DE COLUNA LOMBO-SACRA	0	1571	0204020069	202402	1	1	2	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
c1127733-7679-487a-aa59-0793f6299d40	639	RADIOGRAFIA DE COLUNA LOMBO-SACRA (C/ OBLIQUAS)	0	1571	0204020077	202402	1	1	2	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
90608021-8e59-4045-a127-0fb2373773d8	642	RADIOGRAFIA DE COLUNA TORACO-LOMBAR	0	1571	0204020107	202402	1	1	2	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
9fc13e3f-5eaf-4140-b378-75e32acc88c0	643	RADIOGRAFIA DE COLUNA TORACO-LOMBAR DINAMICA	0	1571	0204020115	202402	1	1	2	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
97a364aa-7d59-48cc-aa1c-eb34bf7c2db9	644	RADIOGRAFIA DE REGIAO SACRO-COCCIGEA	0	1571	0204020123	202402	1	1	2	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.282000+00:00	2021-05-25T19:39:57.282000+00:00
8cdaf038-125a-4f4f-a9f0-91e50a86bffc	650	RADIOGRAFIA DE CORACAO E VASOS DA BASE (PA + LATERAL + OBLIQUA)	0	1571	0204030056	202402	1	1	2	2	25	135	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
d9563b96-1620-481b-9895-8af17e249571	651	RADIOGRAFIA DE CORACAO E VASOS DA BASE (PA + LATERAL)	0	1571	0204030064	202402	1	1	2	2	25	135	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
05237d2c-6b88-4079-a5af-fa4f5fef31f4	2153	TRATAMENTO CIRÚRGICO DE DEISCÊNCIA DE SUTURA DE CÓRNEA	0	1571	0405050399	202402	1	1	2	4	29	185	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
454d21f5-fa6a-4c2c-a41a-e4ebb54c3f99	2087	TRATAMENTO CIRURGICO DE DEISCENCIA DE SUTURA DE ESCLERA	0	1571	0405030100	202402	1	1	2	4	29	126	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
ed7ec1d7-40e4-4661-afba-a429ce7c35fb	1776	TRATAMENTO CIRURGICO DE FISTULA DO PESCOCO (POR APROXIMACAO)	0	1571	0401010139	202402	1	1	2	4	8	27	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
53c41bce-b2fa-4332-adb6-914e829bddc9	1821	TRATAMENTO CIRURGICO DE DISRAFISMO ABERTO	0	1571	0403010225	202402	1	1	3	4	20	29	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
14b5fd2b-f6e0-4296-8de6-7d71df27c38d	1822	TRATAMENTO CIRURGICO DE DISRAFISMO OCULTO	0	1571	0403010233	202402	1	1	3	4	20	29	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
82b5916c-c98d-4679-981b-0f68341a0a3b	1871	TRATAMENTO CIRURGICO DE FISTULA CAROTIDEO-CAVERNOSA	0	1571	0403040086	202402	1	1	3	4	20	159	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
13b2d47c-c1f6-413d-ba00-878f28dae4bd	1960	TRATAMENTO CIRURGICO DE ESTENOSE DO CONDUTO AUDITIVO	12	1571	0404010385	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
3541bfd6-7cd6-4ce7-8eff-2a36e02470c6	2000	TRATAMENTO CIRÚRGICO DE FÍSTULA E CISTOS ORO-MAXILARES	0	1571	0404020356	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
0be410d3-394a-43ef-892b-4fe1afeb0753	2423	TRATAMENTO CIRURGICO DE DIVERTICULO DO TUBO DIGESTIVO	216	1571	0407010289	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.286000+00:00	2021-05-25T19:39:57.286000+00:00
87af59a4-4807-4b24-bd85-3974213c11f3	2682	TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERO-POSTERIOR NOVE OU MAIS NÍVEIS	0	1571	0408030658	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
aa835266-94e9-4155-821e-dde48d83baff	2683	TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR OITO NÍVEIS	0	1571	0408030666	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
f6c2cf67-8ef0-48b3-9220-25e084b5c1e0	2684	TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR QUATRO NÍVEIS	0	1571	0408030674	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
a8cf924c-74dd-493e-bbed-87b97c01d0d6	2685	TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR CINCO NÍVEIS	0	1571	0408030682	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
e12f3bf7-a05a-46b8-8e7d-a877d49c9340	2686	TRATAMENTO CIRÚRGICO DE DEFORMIDADE DA COLUNA VIA ANTERIOR POSTERIOR ATÉ OITO NÍVEIS	12	1571	0408030690	202402	1	1	3	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00