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
9227f6e2-b137-4875-b917-592eeca9aa04	1029	PESQUISA DE TRIPANOSSOMAS (NO BARBEIRO)	0	1571	0213010461	202402	1	1	2	2	52	15	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
955531cb-a601-4423-a617-515febec379c	536	PESQUISA DE LEPTOSPIRAS	0	1571	0202080226	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
8f0a3014-2c73-4bc2-b19f-53124d26902a	255	PESQUISA DE PLASMODIO	0	1571	0202020452	202402	1	1	1	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
433dc3f0-505b-4ef5-af9e-1b81a1d7863f	253	PESQUISA DE FILARIA	0	1571	0202020436	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
f4de1991-a877-4ab4-a40e-f200e392261b	254	PESQUISA DE HEMOGLOBINA S	0	1571	0202020444	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
69df2217-71d9-4449-b99e-40186a3e05f1	256	PESQUISA DE TRIPANOSSOMA	0	1571	0202020460	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
bcc998b9-c2f1-4299-a52e-0b949d6ecd19	398	PESQUISA DE SUBSTANCIAS REDUTORAS NAS FEZES	0	1571	0202040151	202402	1	1	2	2	9	167	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
27b7761d-4876-41c5-afef-1ddcdae5e942	534	PESQUISA DE HAEMOPHILUS DUCREY	0	1571	0202080200	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
54924b0a-e848-498c-9229-416900e19169	537	PESQUISA DE TREPONEMA PALLIDUM	0	1571	0202080234	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
c129216b-e941-46a8-817d-a167526bdda1	364	PESQUISA DE FATOR REUMATOIDE (WAALER-ROSE)	0	1571	0202031012	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
b94ffef2-f670-43b3-aee5-db3939b58951	365	PESQUISA DE HIV-1 POR IMUNOFLUORESCENCIA	0	1571	0202031020	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
e7768d55-abb8-4c22-8fd7-e8be33b7052a	366	PESQUISA DE IMUNOGLOBULINA E (IGE) ALERGENO-ESPECIFICA	0	1571	0202031039	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
a030ff69-0408-4bb2-b680-05292dc9dee8	367	PESQUISA DE TRYPANOSOMA CRUZI (POR IMUNOFLUORESCENCIA)	0	1571	0202031047	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
8341ff67-3a5a-4dfa-9e6a-92ed1a11ddc9	390	PESQUISA DE GORDURA FECAL	0	1571	0202040070	202402	1	1	2	2	9	167	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
97bd2d9f-0b09-4f10-8b3f-172daf1e6658	391	PESQUISA DE LARVAS NAS FEZES	0	1571	0202040089	202402	1	1	2	2	9	167	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
c50a71e4-e545-4c73-a001-49dbecde8221	394	PESQUISA DE OVOS DE SCHISTOSOMAS (EM FRAGMENTO DE MUCOSA)	0	1571	0202040119	202402	1	1	2	2	9	167	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
1439272e-39ef-49a7-801f-6a412bffdc60	479	PESQUISA DE MACROPROLACTINA	0	1571	0202060470	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
6b37e972-3523-4d75-945f-84ccb4f32c41	535	PESQUISA DE HELICOBACTER PYLORI	0	1571	0202080218	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
26e0e939-a266-4407-97a8-c1aa6c7fff4c	564	PESQUISA DE RAGOCITOS NO LIQUIDO SINOVIAL E DERRAMES	0	1571	0202090272	202402	1	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
dae5723d-687d-4c5b-b148-cd1c49c9814f	682	PIELOGRAFIA ANTEROGRADA PERCUTANEA	0	1571	0204050073	202402	1	1	3	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
0b8f1cbb-7dee-4fc2-a4f0-8335af068303	683	PIELOGRAFIA ASCENDENTE	0	1571	0204050081	202402	1	1	2	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
1b4709c4-6c61-45cb-9a59-002c62ea8b48	1065	PESQUISA DE GLICOSE NA URINA	0	1571	0214010031	202402	1	1	1	2	55	16	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
64f54d8d-03a2-4411-9337-96bf8501f1e3	4211	PLACA PONTE 4,5 MM (INCLUI PARAFUSO)	9999	9999	0702031062	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
a4caf6c3-8ab4-4ff1-8732-051d239cf878	2418	PILOROPLASTIA	0	1571	0407010238	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
d74b113e-b6f5-4437-a49b-6ade2db6c9cd	3672	PIRIDOSTIGMINA 60 MG (POR COMPRIMIDO)	0	1571	0604130112	202402	1	1	3	6	26	287	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
55490d8b-ea0b-4863-948c-f0c67465ba27	3884	PILOCARPINA 20 MG/ML SOLUÇÃO OFTÁLMICA (POR FRASCO DE 10 ML)	0	1571	0604730012	202402	1	1	3	6	26	376	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
347440b8-8a7d-4791-aa2c-e7fcc22f160b	4106	PLACA DE CONTENÇÃO	12	1571	0702020044	202402	1	1	0	7	12	74	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
58189b33-c3a3-45ba-bf3a-ac8db91cb877	4185	PINO DE SHANTZ	9999	9999	0702030805	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
5630512a-9567-4f5f-86c0-594dedbaf9e3	4343	PLACA CERVICAL ASSOCIADA A PARAFUSOS INTRA-SOMATICOS DE TITANIO	9999	9999	0702050458	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
0d849b2e-57b5-4e47-b265-baf9796a4a35	4344	PLACA CERVICAL ASSOCIADA A PARAFUSOS DE TITANIO P/ FIXACAO EM ESTRUTURAS POSTERIORES	9999	9999	0702050466	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
e41c3b3a-8728-4fe7-acb5-252d34b54e17	4345	PLACA DE RECONSTRUCAO EM TITANIO P/ FRATURA DE MANDIBULA (INCLUI PARAFUSOS)	9999	9999	0702050474	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
fc7a54a3-b947-4547-9847-94508a90ef15	4346	PLACA DE TITÂNIO SISTEMA MINI/MICROFRAGMENTOS (INCLUI PARAFUSOS)	9999	9999	0702050482	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
f0fa7cdd-edc0-4ea2-90f9-4ad7432f5df1	4184	PINO DE KNOWLES	9999	9999	0702030791	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
5e051754-2292-47ff-b645-3f5b84108834	4209	PLACA P/ CALCANEO (INCLUI PARAFUSO)	9999	9999	0702031046	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
17ff7e17-1bc2-4a7e-99d1-06b4f4d7f68c	4236	PLACA EM L 1,5MM (INCLUI PARAFUSOS)	9999	9999	0702031313	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
da770be3-1582-414d-bcc7-a5c7672484ae	4187	PLACA C/ PARAFUSO DESLIZANTE DE 95 GRAUS	9999	9999	0702030821	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
4d330c51-1ec0-46d6-a38d-d79340601576	4210	PLACA PONTE 3,5 MM (INCLUI PARAFUSOS)	9999	9999	0702031054	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
2866aeca-c429-406a-b2ed-0e50b8145d07	4197	PLACA DE RECONSTRUÇÃO 3,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030929	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
9e788458-d95c-4f5e-81ce-37c42bbeedc9	4238	PLACA EM T 2,0MM (INCLUI PARAFUSOS)	9999	9999	0702031330	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
905a8e13-b7f3-48c2-9049-a73a750b3744	4671	PILAR DA PRÓTESE AUDITIVA ANCORADA NO OSSO	9999	9999	0702090069	202402	1	1	0	7	12	252	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
e2fad584-4f07-499f-b4b1-077370aceed4	4036	PLACA OCLUSAL	144	1571	0701070072	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
9e6c3c65-9020-4f50-bd49-c6aef48ad8d5	3375	PNEUMOMECTOMIA RADICAL EM ONCOLOGIA	0	1571	0416110029	202402	1	1	3	4	57	274	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
269a22fb-2cb9-475f-8759-a1526de54a80	4757	POLIQUIMIOTERAPIA COM DUPLO ANTI HER-2 DO CARCINOMA DE MAMA HER-2 POSITIVO 1ª LINHA	228	1571	0304020435	202402	1	1	3	3	27	75	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
8022c53f-6ec9-4035-b3fc-e19d9148f00d	859	PLETISMOGRAFIA (POR LATERALIDADE / TERRITORIO)	0	1571	0211010049	202402	1	1	2	2	49	13	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
5c936d11-1693-42a9-9c41-19ce91167fac	1498	PLANEJAMENTO SIMPLES (POR TRATAMENTO)	0	1571	0304010200	202402	1	1	3	3	27	20	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
55fbe085-d275-4bb5-b27c-069eee2c340f	1496	PLANEJAMENTO COMPLEXO (POR TRATAMENTO)	0	1571	0304010189	202402	1	1	3	3	27	20	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
a8ace7cd-1af7-4048-8cb3-466b3216fe05	1497	PLANEJAMENTO DE BRAQUITERAPIA DE ALTA TAXA DE DOSE (POR TRATAMENTO)	228	1571	0304010197	202402	1	1	3	3	27	20	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
02029c89-3cbd-4f12-9a24-5bfe80876761	3164	PNEUMOMECTOMIA	0	1571	0412050064	202402	1	1	3	4	50	189	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
4ba840d1-6230-49ff-8cad-b137bc968754	3166	PNEUMORRAFIA	0	1571	0412050080	202402	1	1	2	4	50	189	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
ba802108-d20f-43f6-ab33-c709b4e180a4	4739	POLIQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO – 1ª LINHA	228	1571	0304020419	202402	1	1	3	3	27	75	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