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
2bc5f187-06c7-402e-8664-a953e44047e4	289	PESQUISA DE ANTICORPO IGG ANTICARDIOLIPINA	0	1571	0202030253	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
f74f5f49-daad-4f52-9954-e6a43d89a521	290	PESQUISA DE ANTICORPO IGM ANTICARDIOLIPINA	0	1571	0202030261	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
8b2f9301-dd97-4054-a8e6-3df0058b3656	291	PESQUISA DE ANTICORPOS ANTI-DNA	0	1571	0202030270	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
0fe84ca4-4e22-4cef-8b4b-538f7cbe3134	292	PESQUISA DE ANTICORPOS ANTI-HELICOBACTER PYLORI	0	1571	0202030288	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
e68e07fa-870a-47c0-b2a9-8d9b62cc9a18	293	PESQUISA DE ANTICORPOS ANTI-HIV-1 (WESTERN BLOT)	24	1571	0202030296	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
6130418a-ed5f-46db-9a24-bb464e866737	414	PESQUISA / DOSAGEM DE AMINOACIDOS (POR CROMATOGRAFIA)	0	1571	0202050149	202402	1	1	2	2	9	190	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
aa2fae70-a1b1-46c5-bc25-703a21ab9923	415	PESQUISA DE ALCAPTONA NA URINA	0	1571	0202050157	202402	1	1	2	2	9	190	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
b080bdda-1df0-46d9-9e18-e70c63006c61	416	PESQUISA DE AMINOACIDOS NA URINA	0	1571	0202050165	202402	1	1	2	2	9	190	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
c8f7fb15-0109-4940-854f-6aaaae0e7ff0	1733	PASSAGEM DE SONDA NASO ENTERICA (INCLUI MATERIAL)	0	1571	0309010101	202402	1	1	3	3	43	25	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
06656563-355a-4406-848c-4b12b0451a16	2940	PIELOTOMIA	0	1571	0409010340	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
eada61ab-f713-4fb0-9dac-977fdaa362f8	4188	PLACA 1/3 TUBULAR 3,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030830	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
a38824d7-090e-4fe2-a01e-64ffaf025620	317	PESQUISA DE ANTICORPOS ANTILISTERIA	0	1571	0202030547	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
f8b25318-ef09-481a-9827-7fde4e9a4694	301	PESQUISA DE ANTICORPOS ANTIADENOVIRUS	0	1571	0202030377	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
774c8a67-98a5-4b63-89d9-72f363b9e16a	302	PESQUISA DE ANTICORPOS ANTIAMEBAS	0	1571	0202030385	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
4f906f7f-9b11-43f3-975f-166a9c50d27e	329	PESQUISA DE ANTICORPOS CONTRA O SPOROTRIX SCHENKII	0	1571	0202030660	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
7568cff8-cbe2-4858-8876-cd55e7978430	1768	EXCISAO DE LESAO E/OU SUTURA DE FERIMENTO DA PELE ANEXOS E MUCOSA	0	1571	0401010058	202402	1	1	2	4	8	27	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.273000+00:00	2026-07-31T18:15:09.075000+00:00
0fed770b-3af2-4489-b02a-9aafcfeff875	332	PESQUISA DE ANTICORPOS CONTRA O VIRUS DO SARAMPO	0	1571	0202030695	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
3d8763d9-0892-468b-ac90-4737b93b998d	333	PESQUISA DE ANTICORPOS CONTRA PARACOCCIDIOIDES BRASILIENSIS	0	1571	0202030709	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
ca763180-02de-4f90-9d9b-d2ce7309aad3	334	PESQUISA DE ANTICORPOS E/OU ANTIGENO DO VIRUS SINCICIAL RESPIRATORIO	0	1571	0202030717	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
e38550eb-ae34-42c9-b128-0cb1628ff658	335	PESQUISA DE ANTICORPOS EIE ANTICLAMIDIA	0	1571	0202030725	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
d89a12b6-bec7-4c60-a395-9faee4cfff77	336	PESQUISA DE ANTICORPOS HETEROFILOS CONTA O VIRUS EPSTEIN-BARR	0	1571	0202030733	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
a04b5a91-9a31-414f-8353-f1cf238d0e70	337	PESQUISA DE ANTICORPOS IGG ANTICITOMEGALOVIRUS	0	1571	0202030741	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
f7817bdb-bfe6-4576-8fc3-77c4458389f6	338	PESQUISA DE ANTICORPOS IGG ANTILEISHMANIAS	0	1571	0202030750	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
cc2de218-2495-46e3-a66f-066ddf9b928e	339	PESQUISA DE ANTICORPOS IGG ANTITOXOPLASMA	0	1571	0202030768	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
c6e4e0d8-a3fa-4fd0-9ed3-771043b212e0	340	PESQUISA DE ANTICORPOS IGG ANTITRYPANOSOMA CRUZI	0	1571	0202030776	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.278000+00:00	2021-05-25T19:39:57.279000+00:00
0f207b48-8a2b-4fe5-b613-56b6ebf28c38	4686	PESQUISA DE ANTICORPOS ANTICORPOS ANTI-HTLV-1 (WESTERN-BLOT)	228	1571	0202031268	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
0825dc52-87e1-48df-869b-2b4885a2c47f	558	PESQUISA DE ANTICORPOS ANTIESPERMATOZOIDES ( ELISA )	120	1571	0202090213	202402	1	0	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
9d0023a3-2105-4549-a11d-21fe49792be8	361	PESQUISA DE ANTIGENO E DO VIRUS DA HEPATITE B (HBEAG)	0	1571	0202030989	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
9d50715d-2c43-4f00-82e8-f1a07effb284	250	PESQUISA DE ATIVIDADE DO COFATOR DE RISTOCETINA	0	1571	0202020401	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
44a5854b-3d60-48f9-a930-9957ae6add1b	596	PESQUISA DE ANTICORPOS SERICOS IRREGULARES 37OC	0	1571	0202120066	202402	1	1	2	2	9	280	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
2fcbfb14-e0bf-4108-970f-1d0776b6b1b8	597	PESQUISA DE ANTICORPOS SERICOS IRREGULARES A FRIO	0	1571	0202120074	202402	1	1	2	2	9	280	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
d73128ec-aa66-4771-85e8-0f1507f81eca	595	PESQUISA DE ANTICORPOS IRREGULARES PELO METODO DA ELUICAO	0	1571	0202120058	202402	1	1	2	2	9	280	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
1d12b6b9-2e44-4e1b-8223-c9c7c5f547b3	352	PESQUISA DE ANTICORPOS IGM CONTRA ANTIGENO CENTRAL DO VIRUS DA HEPATITE B (ANTI-HBC-IGM)	0	1571	0202030890	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
22976431-177e-4028-8813-0e2f50ebe794	356	PESQUISA DE ANTICORPOS IGM CONTRA O VIRUS DA VARICELA-HERPES ZOSTER	0	1571	0202030938	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
9b3f9ab0-e5a2-47bb-8a26-057cb8677fd8	252	PESQUISA DE CORPUSCULOS DE HEINZ	0	1571	0202020428	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
f53921f3-9d29-4771-8d2a-d0c7b4319d9c	532	PESQUISA DE BACILO DIFTERICO	0	1571	0202080188	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
cc5251c6-3639-491e-a670-ea7db3f0d059	341	PESQUISA DE ANTICORPOS IGG E IGM CONTRA ANTIGENO CENTRAL DO VIRUS DA HEPATITE B (ANTI-HBC-TOTAL)	0	1571	0202030784	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
ec2f0ca6-0b9d-4523-aced-39065e7430df	342	PESQUISA DE ANTICORPOS IGG CONTRA ARBOVIRUS	0	1571	0202030792	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
0fc0d6f0-c786-461f-b8a6-0e69d7fa7d82	343	PESQUISA DE ANTICORPOS IGG CONTRA O VIRUS DA HEPATITE A (HAV-IGG)	0	1571	0202030806	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
3a19cec0-13bc-4418-9bcb-848712f43fdc	345	PESQUISA DE ANTICORPOS IGG CONTRA O VIRUS DA VARICELA-HERPES ZOSTER	0	1571	0202030822	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
4ccd38f2-8b21-4e89-aae4-856a4b045443	533	PESQUISA DE ESTREPTOCOCOS BETA-HEMOLITICOS DO Grupo A	0	1571	0202080196	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
8832c522-0632-4a93-8a64-f8e6b804c41a	560	PESQUISA DE CARACTERES FISICOS NO LIQUOR	0	1571	0202090230	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
e7716c3a-eae4-4f18-9dd2-aa74990addc2	561	PESQUISA DE CELULAS ORANGIOFILAS	0	1571	0202090248	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
dc359ada-c06f-4cdb-b2be-182fba0b4864	562	PESQUISA DE CRISTAIS C/ LUZ POLARIZADA	0	1571	0202090256	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
7ccaf72d-7974-4783-a522-2e6127fc135f	563	PESQUISA DE ESPERMATOZOIDES (APOS VASECTOMIA)	0	1571	0202090264	202402	1	0	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
c930a9c4-abd8-4bbd-81aa-41dce238ec77	1064	PESQUISA DE CORPOS CETONICOS NA URINA	0	1571	0214010023	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
71926bee-d6ce-4313-ba85-459c86c3fa18	2937	PIELOLITOTOMIA	0	1571	0409010316	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
290a36ab-bf05-4a6b-badd-871a2cd25d23	4189	PLACA 1/3 TUBULAR 4,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030848	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
e5cd1bdd-03fa-42a9-a2c1-d29065a74b10	4190	PLACA ANGULADA 4,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030856	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
cc785429-0082-48ad-abc3-143ef5122669	2938	PIELOPLASTIA	0	1571	0409010324	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.279000+00:00	2021-05-25T19:39:57.279000+00:00