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
ac77cfee-34f7-4ce1-a36c-130a41fee8d7	2815	TRATAMENTO CIRÚRGICO DE METATARSO PRIMO VARO	0	1571	0408050721	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
2d9957a8-d9a0-488b-9a1d-9351d8a2b042	670	RADIOGRAFIA DE COTOVELO	0	1571	0204040078	202402	1	1	2	2	25	168	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
0d4d2d04-fc8b-41be-9683-1fe6b2043f1e	671	RADIOGRAFIA DE DEDOS DA MAO	0	1571	0204040086	202402	1	1	2	2	25	168	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
3ae0e0f7-acbc-4ef8-b88e-db9899dc2b5e	675	RADIOGRAFIA DE PUNHO (AP + LATERAL + OBLIQUA)	0	1571	0204040124	202402	1	1	2	2	25	168	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
5cd94104-3670-4772-9cd5-bc8a2f9ad883	686	RADIOGRAFIA DE ABDOMEN (AP + LATERAL / LOCALIZADA)	0	1571	0204050111	202402	1	1	2	2	25	191	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
9d0d3076-2e63-459d-82e1-2b2e590d97ea	687	RADIOGRAFIA DE ABDOMEN AGUDO (MINIMO DE 3 INCIDENCIAS)	0	1571	0204050120	202402	1	1	2	2	25	191	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
140997a5-8851-411e-9157-e35c50415c13	689	RADIOGRAFIA DE ESTOMAGO E DUODENO	0	1571	0204050146	202402	1	1	2	2	25	191	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
fd06028e-b544-43ba-9ed1-121b55591d32	2820	TRATAMENTO CIRÚRGICO DE PÉ TORTO CONGÊNITO INVETERADO	216	1571	0408050772	202402	1	1	3	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
b9439ad4-c3d7-4047-8e29-97475ba8fb86	2821	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA AO NÍVEL DO TARSO	0	1571	0408050780	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
2b057c89-6d84-4c44-8a45-f111a3f57b3c	2822	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA DA DIÁFISE DO FÊMUR	0	1571	0408050799	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
2546aa4b-5be4-4028-b5a2-d9965a704c13	2823	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA DA REGIÃO TROCANTERIANA	0	1571	0408050802	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
8311a86b-89eb-4334-adfd-4c945056099b	2824	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA DO COLO DO FÊMUR	0	1571	0408050810	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
c95d9092-3683-41cd-bf1d-676c8ea1486d	2825	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA DO PÉ	0	1571	0408050829	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
79b4f131-72c3-43f4-976a-316b104c255d	2900	TRATAMENTO CIRÚRGICO DE POLIDACTILIA NÃO ARTICULADA	0	1571	0408060654	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
3446ba5e-f328-4cf4-9dbe-41bff0cd2169	2901	TRATAMENTO CIRÚRGICO DE POLIDACTILIA ARTICULADA	0	1571	0408060662	202402	1	1	3	4	41	214	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
5cdd124b-9d70-44dd-b0a7-caf648f37e1f	2150	TRATAMENTO CIRURGICO DE PTERIGIO	0	1571	0405050364	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
bf724271-9ed2-4539-b098-9d943946e9fc	2088	TRATAMENTO CIRURGICO DE MIIASE PALPEBRAL	0	1571	0405030118	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
fa992142-b174-4a05-9ec6-88d274100656	1831	TRATAMENTO CIRÚRGICO DE OSTEOMIELITE DO CRÂNIO	0	1571	0403010322	202402	1	1	2	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
e50acaae-cac0-42df-ae52-97be3ff710e9	1832	TRATAMENTO CIRURGICO DE PLATIBASIA E MALFORMACAO DE ARNOLD CHIARI	0	1571	0403010330	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
533ce514-5aab-4cb0-b8e5-652aed6d979c	1961	TRATAMENTO CIRURGICO DE PERICONDRITE DE PAVILHAO	0	1571	0404010393	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
1c9190df-832b-40be-b57b-c03b67c12a71	2001	TRATAMENTO CIRÚRGICO DE OSTEOMIELITE DE OSSOS DA FACE	0	1571	0404020380	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
c6143831-31b6-43b4-a84f-d49474108aeb	2002	TRATAMENTO CIRÚRGICO DE PARALISIA FACIAL (SUSPENSÃO DE HEMIFACE)	0	1571	0404020399	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
97ff54b3-7689-432d-89c6-a643b4cfc191	2424	TRATAMENTO CIRURGICO DE REFLUXO GASTROESOFAGICO	0	1571	0407010297	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
f3222899-efed-4146-a923-dbaec74ca219	2479	TRATAMENTO CIRURGICO DE PROLAPSO ANAL	0	1571	0407020470	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
0c9c660a-fffb-4abc-9763-57332fdfd0e0	2480	TRATAMENTO CIRURGICO DE PRURIDO ANAL	0	1571	0407020489	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
e4c25095-5692-47ef-9b0e-d72d5ca3d989	2530	TRATAMENTO CIRURGICO DE PERITONITE	0	1571	0407040250	202402	1	1	2	4	38	162	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
616e3341-5b56-4bf5-8458-31f63a962a3f	2609	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA DA MÃO	0	1571	0408020555	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
34a5d6bb-644b-41b1-96e4-651bc87616c9	2610	TRATAMENTO CIRÚRGICO DE PSEUDARTROSE / RETARDO DE CONSOLIDAÇÃO / PERDA ÓSSEA DO ANTEBRAÇO	0	1571	0408020563	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
b1cc8cab-8827-4b80-8c48-89d3b2179ee8	2816	TRATAMENTO CIRÚRGICO DE PÉ CAVO	0	1571	0408050730	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
cbb56f1b-28b8-426f-a576-b3f11a7d74ac	2817	TRATAMENTO CIRÚRGICO DE PÉ PLANO VALGO	0	1571	0408050748	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
140cf2c9-1702-4c45-abb5-3cf5dd485fa2	2818	TRATAMENTO CIRÚRGICO DE PÉ TALO VERTICAL	0	227	0408050756	202402	1	1	3	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
ea743501-9630-4b6f-80bb-bde6068fcea4	2819	TRATAMENTO CIRÚRGICO DE PÉ TORTO CONGÊNITO	0	227	0408050764	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
d424e5d4-9bbf-4c2f-bde7-5450006bcc3c	3021	TRATAMENTO CIRURGICO DE PRIAPRISMO	120	1571	0409050113	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
f78d8da6-6783-44b2-aa4e-086895035af4	3159	TRATAMENTO CIRURGICO DE PAREDE TORACICA	0	1571	0412040212	202402	1	1	2	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.286000+00:00	2021-05-25T19:39:57.286000+00:00
9644e244-aa50-4a0f-99ac-a2d6a540b21a	690	RADIOGRAFIA DE INTESTINO DELGADO (TRANSITO)	0	1571	0204050154	202402	1	1	2	2	25	191	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
03af53fd-740a-4968-a41d-870f774f12be	699	RADIOGRAFIA DE ARTICULACAO COXO-FEMORAL	0	1571	0204060060	202402	1	1	2	2	25	207	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
e859a532-7c74-4b95-ae5b-e5c3f5f4e1d0	700	RADIOGRAFIA DE ARTICULACAO SACRO-ILIACA	0	1571	0204060079	202402	1	1	2	2	25	207	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
a953d82b-8886-44f2-bff6-847dc682d113	701	RADIOGRAFIA DE ARTICULACAO TIBIO-TARSICA	0	1571	0204060087	202402	1	1	2	2	25	207	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
0ab44f8b-2b87-458f-9a32-f81df12a5383	702	RADIOGRAFIA DE BACIA	0	1571	0204060095	202402	1	1	2	2	25	207	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
ec2b8368-6304-4c1b-af8e-e497c83fc7c7	703	RADIOGRAFIA DE CALCANEO	0	1571	0204060109	202402	1	1	2	2	25	207	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
364b3c6f-7312-4c2f-adef-ddf13dddf5ae	704	RADIOGRAFIA DE COXA	0	1571	0204060117	202402	1	1	2	2	25	207	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
5f94f5a8-d611-4245-854e-92aafd4a7ad1	705	RADIOGRAFIA DE JOELHO (AP + LATERAL)	0	1571	0204060125	202402	1	1	2	2	25	207	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
12659762-d4d9-4b9b-ad73-c835b96c0801	706	RADIOGRAFIA DE JOELHO OU PATELA (AP + LATERAL + AXIAL)	0	1571	0204060133	202402	1	1	2	2	25	207	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
f058b218-9b60-4188-a581-331b4eee5845	707	RADIOGRAFIA DE JOELHO OU PATELA (AP + LATERAL + OBLIQUA + 3 AXIAIS)	0	1571	0204060141	202402	1	1	2	2	25	207	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
a1dc116d-d6df-4afe-a3e2-1dd0f992e3dd	2831	TRATAMENTO CIRÚRGICO DE ROTURA DE MENISCO COM SUTURA MENISCAL UNI / BICOMPATIMENTAL	0	551	0408050888	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
b640b6b4-d8ce-489a-85c5-895dc6fa3298	2832	TRATAMENTO CIRÚRGICO DE ROTURA DO MENISCO COM MENISCECTOMIA PARCIAL / TOTAL	0	1571	0408050896	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
22797fae-48e4-4a64-ba4d-c0fc1af090bd	2833	TRATAMENTO CIRÚRGICO DO HALUX RIGIDUS	216	1571	0408050900	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
4bd16d5c-f269-44c5-851c-fd216d2fabbd	2694	TRATAMENTO CIRURGICO DESCOMPRESSIVO AO NIVEL DO DESFILADEIRO TORACICO	0	1571	0408030771	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
6b253615-5f85-4944-8a08-5de8991e1cd0	2957	TRATAMENTO CIRURGICO DE URETEROCELE	0	1571	0409010510	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.287000+00:00	2021-05-25T19:39:57.287000+00:00
de3806db-1a68-4056-b52f-cf5ee7fa0586	2076	TRATAMENTO CIRURGICO DE TRIQUIASE C/ OU S/ ENXERTO	0	1571	0405010192	202402	1	1	2	4	29	31	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.287000+00:00	2021-05-25T19:39:57.287000+00:00