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
53647e2d-2067-4343-bd75-031d88700afb	429	PESQUISA DE PORFOBILINOGENIO NA URINA	0	1571	0202050297	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
3169ef16-c5fe-44f7-97ad-6f8f71520d28	430	PESQUISA DE PROTEINAS URINARIAS (POR ELETROFORESE)	0	1571	0202050300	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
d2f046ef-9067-40c7-89cb-cde0f6ea58d8	431	PESQUISA DE TIROSINA NA URINA	0	1571	0202050319	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
cf7c14fc-7ad3-4325-b674-e0080913f66f	439	DOSAGEM DE ACIDO 5-HIDROXI-INDOL-ACETICO (SEROTONINA)	0	1571	0202060071	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
06869fd0-e2ad-4c36-9dce-adbb188bca8b	471	DOSAGEM DE TRIIODOTIRONINA (T3)	0	1571	0202060390	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
368d0738-45f3-4e24-bf5a-5b82a8507320	474	TESTE DE ESTIMULO COM GNRH OU COM AGONISTA GNRH	0	1571	0202060420	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
9f4df065-22bd-442a-8aa6-9acef10fe84e	475	TESTE DE ESTIMULO DO HGH APOS GLUCAGON	0	1571	0202060438	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
ee34fe23-7a33-4c82-9633-de566dc40a6e	476	TESTE DE SUPRESSAO DO CORTISOL APOS DEXAMETASONA	0	1571	0202060446	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
38a0570f-249e-460a-96ce-58d7b1dd2d1e	477	TESTE DE SUPRESSAO DO HGH APOS GLICOSE	0	1571	0202060454	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
d2838290-569e-4403-be5b-3a4a6b5999eb	492	DOSAGEM DE BENZODIAZEPINICOS	0	1571	0202070131	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
78527746-2938-4500-b902-33c44ab4823a	493	DOSAGEM DE CADMIO	0	1571	0202070140	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
41b8bfaf-8505-404a-bfb5-327dd5f3a17c	494	DOSAGEM DE CARBAMAZEPINA	0	1571	0202070158	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
333da7f4-dfed-463d-97a1-ed39c1fe158f	495	DOSAGEM DE CARBOXI-HEMOGLOBINA	0	1571	0202070166	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
11ffc61c-6c34-48f7-a902-370dd1001c0b	496	DOSAGEM DE CHUMBO	0	1571	0202070174	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
762688a7-4be4-48ff-aa57-334f9a82bc25	510	DOSAGEM DE SALICILATOS	0	1571	0202070310	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
415c779c-0130-4554-b9ba-408bba675a5e	511	DOSAGEM DE SULFATOS	0	1571	0202070328	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
bb0c4cc8-3d0c-44fe-87df-815b6ae62bca	512	DOSAGEM DE TEOFILINA	0	1571	0202070336	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
50e372f3-371c-4013-bb9b-21f2454cd744	544	CONTAGEM GLOBAL DE CELULAS NO LIQUOR	0	1571	0202090060	202402	1	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
139192a0-a39d-475a-b26b-162a83ff2c77	571	TESTE DE GASTROACIDOGRAMA - SECRECAO BASAL POR 60 EM 4 AMOSTRAS	0	1571	0202090345	202402	1	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
2076a63f-f681-4b62-909d-eb14c6dbe053	572	TESTE DE HOLLANDER NO SUCO GASTRICO	0	1571	0202090353	202402	1	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
7dc7b3f5-ae0b-426e-bda2-e74ce53f0c15	575	DETERMINACAO DE CARIOTIPO EM SANGUE PERIFERICO (C/ TECNICA DE BANDAS)	0	1571	0202100030	202402	1	1	2	2	9	266	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
d4baddc2-4232-4609-9556-42d2d82d79f6	4564	DOSAGEM QUANTITATIVA DE CARNITINA, PERFIL DE ACILCARNITINAS	0	1571	0202100146	202402	1	1	2	2	9	266	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
d59d2d54-d5be-4dd3-afc7-6be3116ddef0	4565	DOSAGEM QUANTITATIVA DE AMINOÁCIDOS	0	1571	0202100154	202402	1	1	2	2	9	266	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
b0df2f6c-d26c-45ea-9232-78c4652d1086	4566	DOSAGEM QUANTITATIVA DE ÁCIDOS ORGÂNICOS	0	1571	0202100162	202402	1	1	2	2	9	266	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
a311654d-cfb0-4b00-8213-b6b59d4e3958	4570	CONTROLE DE QUALIDADE DO EXAME CITOPATOLÓGICO CERVICO VAGINAL	120	1571	0203010078	202402	0	1	2	2	17	5	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
ee74cb74-466d-4ec1-8820-490565fcfbe2	605	DETERMINACAO DE RECEPTORES TUMORAIS HORMONAIS	228	1571	0203020014	202402	1	1	2	2	17	96	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
4ae557f1-a5a1-425b-a72e-36e24a6a7666	779	CINTILOGRAFIA DE GLANDULAS SALIVARES C/ OU S/ ESTIMULO	0	1571	0208020039	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
90e69c2d-787a-43d8-b889-44489e864633	780	CINTILOGRAFIA DE PANCREAS	0	1571	0208020047	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
eabce5e3-c37b-43be-972c-d7ca1d1b9454	781	CINTILOGRAFIA P/ ESTUDO DE TRANSITO ESOFAGICO (LIQUIDO)	0	1571	0208020055	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
043a7954-0087-48f1-93ab-425377411a45	782	CINTILOGRAFIA P/ ESTUDO DE TRANSITO ESOFAGICO (SEMI-SOLIDO)	0	1571	0208020063	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
ed456278-9ed1-4748-a638-b6b6601acca7	783	CINTILOGRAFIA P/ ESTUDO DE TRANSITO GASTRICO	0	1571	0208020071	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
055ea890-ecfb-4916-85e1-08db2fd1861a	784	CINTILOGRAFIA P/ PESQUISA DE DIVERTICULOSE DE MECKEL	0	1571	0208020080	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
80532046-0c57-4d4a-8d97-d5ad6980c277	785	CINTILOGRAFIA P/ PESQUISA DE HEMORRAGIA DIGESTIVA ATIVA	0	1571	0208020098	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
d3d6f617-89a5-468a-a674-dda599339478	786	CINTILOGRAFIA P/ PESQUISA DE HEMORRAGIA DIGESTIVA NAO ATIVA	0	1571	0208020101	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
e9537518-7083-4619-b92e-50d1e64605c6	787	CINTILOGRAFIA P/ PESQUISA DE REFLUXO GASTRO-ESOFAGICO	0	1571	0208020110	202402	1	1	3	2	39	101	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
61c7bce0-f640-4216-80e7-166d67a761a0	789	CINTILOGRAFIA DE PARATIREOIDES	0	1571	0208030018	202402	1	1	3	2	39	138	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
3d866c53-a9e4-4538-8437-3fd0152afe64	795	CINTILOGRAFIA DE RIM C/ GALIO 67	0	1571	0208040021	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
6e93d986-f0a6-4802-954b-436f40c6b9c5	796	CINTILOGRAFIA DE TESTICULO E BOLSA ESCROTAL	0	1571	0208040030	202402	1	0	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
d4b5556b-dde0-4774-8814-133c95c72131	797	CINTILOGRAFIA P/ PESQUISA DO REFLUXO VESICO-URETERAL	0	1571	0208040048	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
3795fc2b-5d59-4742-aa00-c66d2696c9ff	798	CINTILOGRAFIA RENAL/RENOGRAMA (QUALITATIVA E/OU QUANTITATIVA)	0	1571	0208040056	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
b37b2016-9b53-4172-ab3c-3dc9426d4084	807	CINTILOGRAFIA DE SEGMENTO OSSEO C/ GALIO 67	0	1571	0208050043	202402	1	1	3	2	39	192	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
36cb3929-d0c9-480f-a919-e7ba59475cf1	808	CINTILOGRAFIA DE PERFUSAO CEREBRAL C/ TALIO (SPCTO)	0	1571	0208060014	202402	1	1	3	2	39	204	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
475cba17-07e2-4ff6-8807-e37141482984	811	CINTILOGRAFIA DE PULMAO C/ GALIO 67	0	1571	0208070010	202402	1	1	3	2	39	226	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
dfa40479-d007-4add-ae4c-f904370f73d7	813	CINTILOGRAFIA DE PULMAO POR INALACAO (MINIMO 2 PROJECOES)	0	1571	0208070036	202402	1	1	3	2	39	226	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
79e002c4-6558-4100-a2a0-073b61e03f75	814	CINTILOGRAFIA DE PULMAO POR PERFUSAO (MINIMO 4 PROJECOES)	0	1571	0208070044	202402	1	1	3	2	39	226	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
e1ebe4df-fafc-44d7-9aa3-3ccaf4ee108d	820	CINTILOGRAFIA DE GLANDULA LACRIMAL (DACRIOCINTILOGRAFIA)	0	1571	0208090029	202402	1	1	3	2	39	250	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
b6468eac-c5e8-47a9-9ce7-2fca262aa777	821	CINTILOGRAFIA DE MAMA (BILATERAL)	192	1571	0208090037	202402	1	1	3	2	39	250	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
208c70b0-4883-4172-9506-55d3270ddd83	827	VIDEOLAPAROSCOPIA	0	1571	0209010061	202402	1	1	3	2	44	11	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
66221b72-5d94-458c-9571-ebdcf147458b	828	CISTOSCOPIA E/OU URETEROSCOPIA E/OU URETROSCOPIA	0	1571	0209020016	202402	1	1	2	2	44	102	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
f0c8f26b-68ba-4ffb-8fc2-65dc09019bfb	834	VIDEOTORACOSCOPIA	0	1571	0209040050	202402	1	1	3	2	44	170	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00