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	padrao_dab	esus_id	ativo	data_criacao	data_alteracao
dbb8fad5-feb6-4035-9ae5-a316ddb00808	159	DOSAGEM DE COLESTEROL HDL	0	1571	0202010279	202402	1	1	2	2	9	4	0	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
5979995e-229c-4540-876f-8c894ecda8ac	160	DOSAGEM DE COLESTEROL LDL	0	1571	0202010287	202402	1	1	2	2	9	4	0	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
b253b238-1b91-4f5a-be19-3626cf869cfb	161	DOSAGEM DE COLESTEROL TOTAL	0	1571	0202010295	202402	1	1	2	2	9	4	0	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
e4d292e1-ee42-4644-bc30-2632688c6aaa	162	DOSAGEM DE COLINESTERASE	0	1571	0202010309	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
7522f12d-d366-4982-8a6b-26a1df9c4b14	227	DOSAGEM DE ANTITROMBINA III	0	1571	0202020177	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
6731e74a-aeb5-42ec-b14b-a13039b76460	408	DOSAGEM DE CITRATO	0	1571	0202050084	202402	1	1	2	2	9	190	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f6d580c5-9abc-4a0a-a87b-4a93cdab2edc	440	DOSAGEM DE ADRENOCORTICOTROFICO (ACTH)	0	1571	0202060080	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f3e55445-fbae-41bd-9f47-03a5b6c54bd0	441	DOSAGEM DE ALDOSTERONA	0	1571	0202060098	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
046c16cf-a870-4478-80f4-cb0ea5ad5d06	442	DOSAGEM DE AMP CICLICO	0	1571	0202060101	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
bb98250a-d9a2-4ca8-a244-86518e5ef173	443	DOSAGEM DE ANDROSTENEDIONA	0	1571	0202060110	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
bc98ccea-6d9e-4556-b29b-cfe297072d70	444	DOSAGEM DE CALCITONINA	0	1571	0202060128	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
0d528886-b93f-480d-bcef-6fabf306d3da	484	DOSAGEM DE ACIDO VALPROICO	0	1571	0202070050	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
4b56c219-ae21-4c34-a1c7-b8751f7bd311	485	DOSAGEM DE ALA-DESIDRATASE	0	1571	0202070069	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
1c6b2fe6-7ab5-445e-88e5-ec4697feb492	486	DOSAGEM DE ALCOOL ETILICO	0	1571	0202070077	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
457423f5-3aac-4029-b2da-7db5de2836e2	488	DOSAGEM DE AMINOGLICOSIDEOS	0	1571	0202070093	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
2d02b3be-df62-4e20-8676-6bfdb2e5e6d3	489	DOSAGEM DE ANFETAMINAS	0	1571	0202070107	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
4cd29cc8-6c5a-471d-bcd6-a1cdf2706a4c	490	DOSAGEM DE ANTIDEPRESSIVOS TRICICLICOS	0	1571	0202070115	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ccd67e10-caad-475e-ad44-6017984d6dd2	491	DOSAGEM DE BARBITURATOS	0	1571	0202070123	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
280cbaf6-75a4-4b61-a604-980fccefbf22	236	DOSAGEM DE FATOR XI	0	1571	0202020266	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
a2cd5b05-a376-4842-902d-1eec0f94c491	4634	DOSAGEM DE EVEROLIMO (EM PACIENTE TRANSPLANTADO)	0	1571	0501080104	202402	1	1	2	5	7	241	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
3953f150-78ad-429a-b8ec-8e1d73342acb	580	DOSAGEM DE FENILALANINA (CONTROLE / DIAGNOSTICO TARDIO)	0	1571	0202110044	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
5cce0585-3ccd-4ffb-830b-4dc41b97eca6	168	DOSAGEM DE DESIDROGENASE LATICA	0	1571	0202010368	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
15b2616a-44f7-41bb-9fa4-a0c4986683f8	446	DOSAGEM DE DEHIDROEPIANDROSTERONA (DHEA)	0	1571	0202060144	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
edc3920e-bdd3-4e45-b8d3-2fe0ba28f934	447	DOSAGEM DE DIHIDROTESTOTERONA (DHT)	0	1571	0202060152	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
ccc41741-3684-4797-adf7-234fc28a9768	449	DOSAGEM DE ESTRIOL	0	1571	0202060179	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
efb34f1c-60c1-4b23-b701-4fc850de6bce	581	DOSAGEM DE FENILALANINA E TSH OU T4	0	1571	0202110052	202402	1	1	2	2	9	270	0	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
9bfebd08-ab05-429d-9282-c2f94485c92b	235	DOSAGEM DE FATOR X	0	1571	0202020258	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
1af0414b-26bc-4bd0-892f-d83483255364	499	DOSAGEM DE DIGITALICOS (DIGOXINA, DIGITOXINA)	0	1571	0202070204	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
db61d41d-efac-40de-9921-df2e976ce1af	276	DOSAGEM DE COMPLEMENTO C3	0	1571	0202030121	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
67cacf51-5a22-432a-9567-d69087bbb653	277	DOSAGEM DE COMPLEMENTO C4	0	1571	0202030130	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
b657a90b-7aad-4b83-82dc-9479968e632c	582	DOSAGEM DE FENILALANINA TSH OU T4 E DETECCAO DA VARIANTE DE HEMOGLOBINA (COMPONENTE DO TESTE DO PEZINHO)	0	1	0202110060	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
bd1d1999-5d6d-42fa-9618-03e8028cec28	448	DOSAGEM DE ESTRADIOL	0	1571	0202060160	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
ee4bea64-13d0-4e37-bba8-cfa0dc6c1792	228	DOSAGEM DE FATOR II	0	1571	0202020185	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
ac248335-ccd0-4223-816b-a2285be62ac7	163	DOSAGEM DE CREATININA	0	1571	0202010317	202402	1	1	2	2	9	4	0	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
3140a0d6-7054-49ce-a62a-b116f1f8aae1	164	DOSAGEM DE CREATINOFOSFOQUINASE (CPK)	0	1571	0202010325	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
b11c3b00-0177-45ab-b0a7-d45ecfbfac36	165	DOSAGEM DE CREATINOFOSFOQUINASE FRACAO MB	0	1571	0202010333	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
46ec5ca5-31c4-4467-ba40-cd8884054621	166	DOSAGEM DE DESIDROGENASE ALFA-HIDROXIBUTIRICA	0	1571	0202010341	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
292ae4cd-1a3b-49d8-abb1-ce47398ed831	384	DOSAGEM DE ESTERCOBILINOGENIO FECAL	0	1571	0202040011	202402	1	1	2	2	9	167	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
169966bf-c88c-47ab-9f4c-fd70e6acdfdb	445	DOSAGEM DE CORTISOL	0	1571	0202060136	202402	1	1	2	2	9	210	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
0bdd5655-403c-48b1-a552-04b0a8243799	500	DOSAGEM DE ETOSSUXIMIDA	0	1571	0202070212	202402	1	1	2	2	9	227	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
6ebf377f-9031-4b72-ae64-6cdbb9d8d74f	546	DOSAGEM DE CREATININA NO LIQUIDO AMNIOTICO	120	599	0202090086	202402	0	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
3666224d-0740-42f1-ab15-53ec8a45c196	547	DOSAGEM DE FOSFATASE ALCALINA NO ESPERMA	120	1571	0202090094	202402	1	0	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
8e19f433-fa25-444a-9a39-835a5489c6ad	559	DOSAGEM DE FOSFATASE ÁCIDA NO ESPERMA	120	1571	0202090221	202402	1	0	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
65f8aad3-4750-4883-ac27-3267304acf1d	243	DOSAGEM DE HEMOSSIDERINA	0	1571	0202020339	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
7d7c1595-03a7-44a2-850d-1ad82f080622	3849	CALCITONINA 100 UI INJETAVEL (POR AMPOLA)	0	1571	0604570023	202402	1	1	3	6	26	360	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
27be4df0-eb60-4f6e-8bbd-7d94ab1f56e0	3859	ACITRETINA 10 MG (POR CAPSULA)	0	1571	0604600011	202402	1	1	3	6	26	363	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.263000+00:00	2021-05-25T19:39:57.263000+00:00
23cb74cb-b47d-47fd-8933-a36d0b8a2c77	188	DOSAGEM DE MAGNESIO	0	1571	0202010562	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
0bbfa6aa-33b2-4837-9823-f659cd453add	183	DOSAGEM DE HIDROXIPROLINA	0	1571	0202010511	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
b0f991cc-ad88-4dfd-975f-8dd7a82c9040	279	DOSAGEM DE IMUNOGLOBULINA A (IGA)	0	1571	0202030156	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
92cd631c-3144-42e7-87f2-7206692a81fb	280	DOSAGEM DE IMUNOGLOBULINA E (IGE)	0	1571	0202030164	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00