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
302856db-9be7-48d3-99fd-042733616255	2390	ESTUDO ELETROFISIOLOGICO TERAPEUTICO II (ABLACAO DE TAQUICARDIA ATRIAL CICATRICIAL)	0	1571	0406050082	202402	1	1	3	4	34	186	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
2e156353-f817-46d6-925e-39491f619c3c	2392	ESTUDO ELETROFISIOLOGICO TERAPEUTICO II (ABLACAO DE TAQUICARDIA ATRIAL ESQUERDA)	0	1571	0406050104	202402	1	1	3	4	34	186	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
78befb73-6c35-4dcf-86a2-2eb8ea8e1b44	2393	ESTUDO ELETROFISIOLOGICO TERAPEUTICO II (ABLACAO DE TAQUICARDIA VENTRICULAR IDIOPATICA DO SEIO DE VALSALVA ESQUERDO)	0	1571	0406050112	202402	1	1	3	4	34	186	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
2d0cb1c0-57aa-4e03-9dd7-89926718c802	2394	ESTUDO ELETROFISIOLOGICO TERAPEUTICO II (ABLACAO DE TAQUICARDIA VENTRICULAR SUSTENTADA C/ CARDIOPATIA ESTRUTURAL)	0	1571	0406050120	202402	1	1	3	4	34	186	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
2433b665-bc73-43a1-8790-276ea33c073e	2395	ESTUDO ELETROFISIOLOGICO TERAPEUTICO II (ABLACAO DE VIAS ANOMALAS ESQUERDAS)	0	1571	0406050139	202402	1	1	3	4	34	186	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
b580ab44-da92-4995-aadf-723a55ea7bfc	2398	ESOFAGECTOMIA DISTAL C/ TORACOTOMIA	0	1571	0407010033	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
66af08c2-3311-4f0e-b918-c9b7cc700d8d	2399	ESOFAGECTOMIA DISTAL S/ TORACOTOMIA	240	1571	0407010041	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
7920b562-7c60-4e60-bca3-cab5cb3b5e4f	2400	ESOFAGECTOMIA VIDEOLAPAROSCOPICA	0	1571	0407010050	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
d8f71526-c1a4-423e-be98-9b245a21c4a3	2402	ESOFAGOGASTRECTOMIA	240	1571	0407010076	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
55c352ef-0343-4716-a067-2cb771e3a59c	2405	ESOFAGORRAFIA TORACICA	0	1571	0407010106	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
c9b45f0b-8efb-49ae-9df2-53bdddc49b8e	2406	ESOFAGOSTOMIA	0	1571	0407010114	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
77b45eed-807b-425b-9886-ca7c630c104c	2408	GASTRECTOMIA PARCIAL C/ OU S/ VAGOTOMIA	240	1571	0407010130	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
a446e071-cf28-4f31-a32f-c4f623f9472b	2412	GASTROPLASTIA C/ DERIVACAO INTESTINAL	192	1571	0407010173	202402	1	1	3	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
a078581b-a478-410e-a6d4-5c6580d1b193	2413	GASTROPLASTIA VERTICAL COM BANDA	192	1571	0407010181	202402	1	1	3	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
6100d99a-4559-462d-a996-c075ae9a202b	2414	GASTRORRAFIA	0	1571	0407010190	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
02726d94-d446-4ae3-934b-e3de03e6e92f	2415	GASTRORRAFIA VIDEOLAPAROSCOPICA	0	1571	0407010203	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
59bd2e4e-5c65-4b7e-850d-8f0c02cef7c4	2416	GASTROSTOMIA	0	1571	0407010211	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
3ac83e84-e2f2-4fae-80c5-47c956ca0ba3	2417	GASTROSTOMIA VIDEOLAPAROSCOPICA	0	1571	0407010220	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
4315d755-d0e1-4169-9bf6-de35727e7d49	2431	GASTRECTOMIA VERTICAL EM MANGA (SLEEVE)	192	1571	0407010360	202402	1	1	3	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
b3db3d1a-f0ef-44c3-afbc-30393eca900e	2440	COLECTOMIA VIDEOLAPAROSCOPICA	0	1571	0407020080	202402	1	1	3	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
da08035f-52b0-4249-b8a1-5d41685ffff6	2466	PROCTOPEXIA ABDOMINAL POR PROCIDENCIA DO RETO	240	1571	0407020349	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
d0788e00-792f-4239-b3bb-dfaea7000b50	2467	PROCTOPLASTIA E PROCTORRAFIA POR VIA PERINEAL	240	1571	0407020357	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
4123b3d8-50af-47db-9b0b-f4f2aeaf640a	2471	RETIRADA DE CORPO ESTRANHO / POLIPOS DO RETO / COLO SIGMOIDE	0	1571	0407020390	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.283000+00:00	2021-05-25T19:39:57.283000+00:00
17ace5aa-2260-46ef-8d37-a1da7a876fa4	2475	TRATAMENTO CIRURGICO DE AUSENCIA DO RETO (ABDOMINO-PERINEAL)	0	1571	0407020438	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
cf6fe477-fa83-4afa-a51c-ce2d294310e6	2483	COLECISTECTOMIA	24	1571	0407030026	202402	1	1	2	4	38	128	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
c2008502-99f1-4c2f-81bf-72c720a370e5	2484	COLECISTECTOMIA VIDEOLAPAROSCOPICA	0	1571	0407030034	202402	1	1	2	4	38	128	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
eaa89e46-37fa-44c3-b539-e56f5d4f2c2a	2485	COLECISTOSTOMIA	24	1571	0407030042	202402	1	1	2	4	38	128	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
905a7ca2-e4de-4e94-a6b1-f46652d09e53	2486	COLEDOCOPLASTIA	144	1571	0407030050	202402	1	1	2	4	38	128	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
079a86fa-9ca9-4eec-82fe-855d356df371	2487	COLEDOCOTOMIA C/ OU S/ COLECISTECTOMIA	144	1571	0407030069	202402	1	1	2	4	38	128	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
4e582fc1-7486-45c6-a6af-dbe104455b81	2488	COLEDOCOTOMIA VIDEOLAPAROSCOPICA	0	1571	0407030077	202402	1	1	2	4	38	128	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
e5e84fdc-68cf-4fc3-a1cf-89acfb2fd81b	2490	DILATACAO PERCUTANEA DE ESTENOSES E ANASTOMOSES BILIARES	0	1571	0407030093	202402	1	1	3	4	38	128	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
ecc46998-e3b5-452e-8e41-1927d9105e30	2491	DRENAGEM BILIAR PERCUTANEA EXTERNA	0	1571	0407030107	202402	1	1	3	4	38	128	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
58300de8-bb8b-4abb-bebb-e54f55a8996d	2496	HEPATORRAFIA COMPLEXA C/ LESAO DE ESTRUTURAS VASCULARES BILIARES	0	1571	0407030158	202402	1	1	2	4	38	128	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
c50bcb7e-ba64-454c-ba95-1b3476fad72a	2503	PANCREATOTOMIA P/ DRENAGEM	240	1571	0407030220	202402	1	1	2	4	38	128	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.277000+00:00	2021-05-25T19:39:57.277000+00:00
f333eda8-7b7e-454a-bb95-103a3563b600	2505	TRATAMENTO CIRURGICO DE CISTOS PANCREATICOS	240	1571	0407030247	202402	1	1	2	4	38	128	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
5603e440-4a9a-424d-8745-3b4f7ab652b0	2506	DRENAGEM DE ABSCESSO PELVICO	0	1571	0407040013	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
fe4b8b1a-c810-4d97-a252-7e36cacc75c8	2507	DRENAGEM DE ABSCESSO SUBFRENICO	0	1571	0407040021	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
4cb74d3e-9b72-4901-821f-cc60e7b2e235	2508	DRENAGEM DE HEMATOMA / ABSCESSO PRE-PERITONEAL	0	1571	0407040030	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
9c4aeaa9-491d-4189-844c-878772804bc4	2510	HERNIOPLASTIA DIAFRAGMATICA (VIA TORACICA)	0	1571	0407040056	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
2f919a77-9e50-4695-8c90-30e211e62502	2511	HERNIOPLASTIA EPIGASTRICA	0	1571	0407040064	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
d10d4d6f-fdcc-4867-a41f-146041e68f90	2512	HERNIOPLASTIA EPIGASTRICA VIDEOLAPAROSCOPICA	0	1571	0407040072	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
4e84e695-c8a4-4f7d-b9aa-94cabcc3d101	2520	HERNIORRAFIA UMBILICAL VIDEOLAPAROSCOPICA	0	1571	0407040153	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
355d334c-64fb-40b3-9120-3cf3b70e7419	2533	ARTRODESE DE GRANDES ARTICULAÇÕES ESCAPULO-UMERAIS	0	971	0408010029	202402	1	1	3	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
aba6b55b-01da-4eca-9ba6-f4a1710c0f74	2537	ARTROPLASTIA ESCAPULO-UMERAL TOTAL - REVISÃO / RECONSTRUÇÃO	480	1571	0408010061	202402	1	1	3	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
28dcd2d9-3218-4240-99fd-a42f054fc33a	2557	ARTRODESE DE MÉDIAS / GRANDES ARTICULAÇÕES DE MEMBRO SUPERIOR	180	1091	0408020032	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
c6b1dd4b-ce24-4b12-b4ee-860cc005d3fb	2559	ARTROPLASTIA DE CABEÇA DO RÁDIO	216	971	0408020059	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
1df9124b-5e65-4b11-9423-04f3cb561793	2561	ARTROPLASTIA TOTAL DE COTOVELO	720	1571	0408020075	202402	1	1	3	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
74ddb180-ec23-4858-aca7-99113c9b15e8	2562	ARTROPLASTIA TOTAL DE COTOVELO (REVISAO / RECONSTRUCAO)	720	1571	0408020083	202402	1	1	3	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
ab17416d-ea7b-451d-8ee4-185c9220410a	2581	REIMPLANTE OU REVASCULARIZAÇÃO AO NÍVEL DA MÃO E OUTROS DEDOS (EXCETO POLEGAR)	0	1571	0408020270	202402	1	1	3	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.282000+00:00	2021-05-25T19:39:57.282000+00:00
0f06a114-6665-4e71-8af3-e407084de4de	2588	TRATAMENTO CIRÚRGICO DE FRATURA / LESÃO FISARIA DAS FALANGES DA MÃO (COM FIXAÇÃO)	0	1571	0408020342	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.286000+00:00	2021-05-25T19:39:57.286000+00:00