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
7c4f25c0-895f-49e1-855c-e04249521b42	4647	DACLATASVIR 30 MG (POR COMPRIMIDO REVESTIDO)	216	1571	0604760035	202402	1	1	3	6	26	381	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
d73caed1-3c89-49f8-8fc0-6dacbdfc3a22	525	CULTURA PARA BAAR	0	1571	0202080110	202402	1	1	2	2	9	242	0	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
05181eab-d049-458c-b769-d6a1137eba7a	3618	DEFERASIROX 250 MG (POR COMPRIMIDO)	0	1571	0604020023	202402	1	1	3	6	26	72	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
c4a20bba-a330-4155-a078-bdf743a469fe	3619	DEFERASIROX 500 MG (POR COMPRIMIDO)	0	1571	0604020031	202402	1	1	3	6	26	72	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
6658a3b6-9466-42e2-96fc-6beaaf24e3d2	3621	DESFERROXAMINA 500 MG INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604020058	202402	1	1	3	6	26	72	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
bfe3ac82-8efb-43de-ac2c-52360a76de68	3620	DEFERIPRONA 500 MG (POR COMPRIMIDO)	0	1571	0604020040	202402	1	1	3	6	26	72	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
1463a816-eebc-4cf2-9f74-ca198b750317	1867	DESCOMPRESSAO NEUROVASCULAR DE NERVOS CRANIANOS	12	1571	0403040027	202402	1	1	3	4	20	159	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
d94c6b6b-ba76-46b4-bd5f-a636c32d38bf	1807	DERIVACAO RAQUE-PERITONEAL	0	1571	0403010080	202402	1	1	2	4	20	29	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
9d08d4af-51ca-438f-be52-5f8218e3f9ea	1808	DERIVACAO VENTRICULAR EXTERNAR-SUBGALEAL EXTERNA	0	1571	0403010098	202402	1	1	2	4	20	29	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
1ccaadfe-375c-4ecc-a461-6277e12b4957	1810	DESCOMPRESSAO DE ORBITA POR DOENÇA OU TRAUMA	0	1571	0403010110	202402	1	1	3	4	20	29	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
7bcfebca-90c8-406b-b905-b901b092bcd5	2103	DESCOMPRESSAO DE NERVO OPTICO	0	1571	0405040040	202402	1	1	3	4	29	160	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
6f3cab7b-d723-4926-9df3-7f6b6a66866a	2104	DESCOMPRESSAO DE ORBITA	0	1571	0405040059	202402	1	1	3	4	29	160	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
861ab053-b647-4783-8101-b10a49db926a	2396	DEGASTROGASTRECTOMIA C/ OU S/ VAGOTOMIA	144	1571	0407010017	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
29f0a7c5-50f3-40a1-bb49-f75f4b2789e9	2538	DESARTICULACAO DA ARTICULACAO ESCAPULO-UMERAL	0	1571	0408010070	202402	1	1	2	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
447ca958-eeab-4a2f-aa71-79fe69a6ba32	2539	DESARTICULACAO INTERESCAPULO-TORÁCICA	0	1571	0408010088	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
f3bb0b15-3ac2-45f9-8179-622108fe4661	2654	DESCOMPRESSÃO OSSEA NA JUNÇÃO CRANIO-CERVICAL VIA POSTERIOR	0	1571	0408030364	202402	1	1	3	4	41	129	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
f2ccec51-04a6-42d1-8e37-1cf1332cb9e3	2655	DESCOMPRESSÃO OSSEA NA JUNÇÃO CRANIO-CERVICAL VIA POSTERIOR C/ DUROPLASTIA	0	1571	0408030372	202402	1	1	3	4	41	129	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
e1c6db98-0af8-4f41-a0bd-a351d282b81f	2718	DESARTICULAÇÃO COXOFEMORAL	0	1571	0408040106	202402	1	1	2	4	41	163	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
619ea219-46cc-4f37-bbbe-b662bc5540ea	3259	DEBRIDAMENTO DE ULCERA / DE TECIDOS DESVITALIZADOS	0	1571	0415040035	202402	1	1	2	4	56	174	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
fd2093f6-d6ec-491d-80d8-69484103789a	3258	DEBRIDAMENTO DE FASCEITE NECROTIZANTE	0	1571	0415040027	202402	1	1	2	4	56	174	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
49625281-56b0-4ca1-ba9e-2bd7ecf188dc	3482	DESLOCAMENTO DE EQUIPE PROFISSIONAL P/ RETIRADA DE ORGAOS - INTERMUNICIPAL	0	1091	0503040037	202402	1	1	0	5	22	148	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
aba21019-146b-416c-906b-553fa4427085	3372	DESARTICULACAO ESCAPULO-TORACICA INTERNA EM ONCOLOGIA	0	1571	0416090125	202402	1	1	3	4	57	246	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
7938c2c6-395c-48a0-b023-75cb0a3a4d3a	2844	DESCOMPRESSÃO COM ESVAZIAMENTO MEDULAR POR BROCAGEM / VIA CORTICOTOMIA	0	1571	0408060093	202402	1	1	2	4	41	214	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
4f5bdcac-2d79-4600-ac3d-d995f5d930e3	3028	DILATACAO DE COLO DO UTERO	120	731	0409060062	202402	0	1	2	4	42	211	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
8bbc9e9c-00ea-476b-8ee8-ef22c04636aa	3099	DESCOLAMENTO MANUAL DE PLACENTA	108	731	0411010018	202402	0	1	2	4	48	37	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
e004c555-c163-4338-bf6d-bd4d5f285628	3193	DERMOLIPECTOMIA (1 OU 2 MEMBROS INFERIORES)	240	851	0413040038	202402	1	1	3	4	53	144	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
64a25b1b-bd19-4418-8bfd-f8ab412e44d4	3194	DERMOLIPECTOMIA ABDOMINAL NAO ESTETICA (PLASTICA ABDOMINAL)	240	851	0413040046	202402	1	1	2	4	53	144	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
06b57bc4-3c6a-4e47-b043-77b650ba2208	3195	DERMOLIPECTOMIA ABDOMINAL POS-CIRURGIA BARIATRICA	216	1571	0413040054	202402	1	1	3	4	53	144	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
b99ad12d-3973-4bda-bded-fbd98f590c92	4677	DANÇA CIRCULAR/BIODANÇA	0	1571	0101050038	202402	1	1	1	1	4	382	1	<span class="null">NULL</span>	1	GRUPO	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ed92ffe0-3110-406e-959d-1c57917ad951	978	DELEUCOCITACAO DE CONCENTRADO DE HEMACIAS	0	1571	0212020013	202402	1	1	2	2	51	105	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
4a8444b9-d4e7-437a-af63-4f4d79616ba2	979	DELEUCOCITACAO DE CONCENTRADO DE PLAQUETAS	0	1571	0212020021	202402	1	1	2	2	51	105	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
76b9d28c-44f7-45a5-ba26-8dc02f21ebcc	3481	DESLOCAMENTO INTERESTADUAL DE EQUIPE PROFISSIONAL P/ RETIRADA DE ORGAOS	0	1091	0503040029	202402	1	1	0	5	22	148	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
4d6b7e5c-deeb-45ba-8bd5-0b8646ebb3a7	3550	DESMOPRESSINA (DDAVP) - FRASCO AMPOLA DE 4 MCG/ML EM COAGULOPATIAS HEREDITARIAS	0	1571	0602010136	202402	1	1	3	6	13	52	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
d29b4925-1e22-41a9-a6f2-7b413e112a0b	1756	SESSÃO DE ELETROESTIMULAÇÃO	0	1571	0309050030	202402	1	1	2	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2026-07-03T14:37:34.238000+00:00
67a59a95-2ef0-4472-adcf-fb5f4295af75	3617	DEFERASIROX 125 MG (POR COMPRIMIDO)	0	1571	0604020015	202402	1	1	3	6	26	72	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
0d01e578-08e6-49b9-b5cc-26f26856f996	816	DEMONSTRACAO DE SEQUESTRO DE HEMACIAS PELO BACO (C/ RADIOISOTOPOS)	0	1571	0208080023	202402	1	1	3	2	39	239	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
3accd589-5c37-4740-887b-762c02b2becd	1371	DESBASTAMENTO DE CALOSIDADE E/OU MAL PERFURANTE (DESBASTAMENTO)	0	1571	0303080027	202402	1	1	2	3	21	233	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ad69f117-5ac3-4676-ab1c-3e0e2fdc2788	3371	DESARTICULACAO INTERESCAPULO-TORACICA EM ONCOLOGIA	0	1571	0416090117	202402	1	1	3	4	57	246	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
8688eb12-9b40-488f-87c5-7739eb4bf949	695	DENSITOMETRIA OSSEA DUO-ENERGETICA DE COLUNA (VERTEBRAS LOMBARES E/OU FEMUR)	0	1571	0204060028	202402	1	1	3	2	25	207	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
e743cb8e-5979-470a-abf9-d84a968da3d2	139	DETERMINACAO DE CURVA GLICEMICA CLASSICA (5 DOSAGENS)	0	1571	0202010074	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ceb2568e-2a0e-47d9-8e1d-c1dcf7e7fe22	881	DETERMINACAO DE DURACAO DA CURVA DE INTENSIDADE	0	1571	0211050016	202402	1	1	2	2	49	193	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
3957e10e-b8ca-499e-8a8a-ddcb77d5ffb7	4685	DETECÇÃO DE RNA DO HTLV-1	228	1571	0202031250	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
479a81a1-7734-4f80-8ef0-af149b32e0a4	134	DETERMINACAO DE CAPACIDADE DE FIXACAO DO FERRO	0	1571	0202010023	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
597c8793-2623-408a-a861-ca76f49dc787	140	DETERMINACAO DE OSMOLARIDADE	0	1571	0202010082	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
d8dbfd65-1f6a-4d50-b7a2-d1a7b7aa34a2	577	DETECCAO DE VARIANTES DA HEMOGLOBINA (DIAGNOSTICO TARDIO)	0	1571	0202110010	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
6bf9d9db-6d09-4200-a358-9279572603e4	984	DETERMINACAO DE CARGA VIRAL DO HIV POR RT-PCR	0	1571	0213010011	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
793147c8-49b5-4612-8f9f-b4eaa9ef4dfb	3654	DESMOPRESSINA 0,1 MG/ML APLICACAO NASAL (POR FRASCO DE 2,5 ML	0	1571	0604100019	202402	1	1	3	6	26	262	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
72c46b09-5692-4e46-b986-14d8f4418b60	578	DETECCAO MOLECULAR DE MUTACAO EM HEMOGLOBINOPATIAS (CONFIRMATORIO)	0	1571	0202110028	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
c3474665-fac4-43a3-9d3a-c8e52599d92b	969	DETERMINACAO DE PRESSAO INTRA-ABDOMINAL	0	1571	0211090050	202402	1	1	2	2	49	251	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
86470e94-fa92-495c-9d9e-7d61034b4c3c	579	DETECCAO MOLECULAR EM FIBROSE CISTICA (CONFIRMATORIO)	0	1571	0202110036	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00