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
06dcc4a0-4038-4cec-8638-a393da316b8f	3662	DONEPEZILA 5 MG (POR COMPRIMIDO)	480	1571	0604130015	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
af14177f-d75b-4c62-8455-4b9b1407028f	4734	DISPOSITIVO PEDICULAR PARA FIXAÇÃO DE HASTE (INCLUI BLOQUEADOR)	9999	9999	0702050822	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
6b41e4ea-02e3-48a0-8ca2-47aa38c06b1d	143	DOSAGEM DE ACIDO ASCORBICO	0	1571	0202010112	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
c9d12e2e-526e-4acc-933c-7c05cf92407f	2917	DILATACAO PERCUTANEA DE ESTENOSES URETERAIS E JUNCAO URETERO-VESICAL	0	1571	0409010111	202402	1	1	3	4	42	35	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
b6ee1806-ad27-4060-b5e5-260f66f492d8	2918	DIVERTICULECTOMIA VESICAL	0	1571	0409010120	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
c2764c3a-eb72-4f5b-9c69-1aebdec6e2ee	3651	CLOROQUINA 150 MG (POR COMPRIMIDO)	0	1571	0604080018	202402	1	1	3	6	26	237	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
9ab0157f-95b9-451c-a9ea-873ba2746ed5	1357	DILATACAO DE ESOFAGO C/ OGIVAS SOB VISAO ENDOSCOPICA (POR SESSAO)	0	1571	0303070013	202402	1	1	2	3	21	231	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f2d0f8f1-900e-474d-91ec-e4275a034566	2284	DISSECCAO DE VEIA / ARTERIA	0	1571	0406020094	202402	1	1	2	4	34	86	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
88934746-ca5a-4f71-9f62-201a22737198	2285	DISSECCAO RADICAL DO PESCOCO	360	1571	0406020108	202402	1	1	2	4	34	86	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
67498248-bebe-4384-a321-2635fec692d8	2397	DILATACAO ESOFAGICA / PILORICA	0	1571	0407010025	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
47ca3027-064a-4631-8908-e4877ff0d351	2444	DILATACAO DIGITAL / INSTRUMENTAL DO ANUS E/OU RETO	0	1571	0407020128	202402	1	1	2	4	38	87	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
e0656cbb-881b-47a1-a033-aaa75c6ccf8f	2656	DISCECTOMIA CERVICAL / LOMBAR / LOMBO-SACRA POR VIA POSTERIOR (1 NÍVEL C/ MICROSCÓPIO)	0	1571	0408030380	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
e9a4e6d8-3c52-41f8-8a14-7f527d9ea6a3	2657	DISCECTOMIA CERVICAL / LOMBAR / LOMBO-SACRA POR VIA POSTERIOR (UM NÍVEL)	120	1571	0408030399	202402	1	1	2	4	41	129	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
08d8f9cb-50c7-4c7c-b22b-2bafc2a35874	480	DOSAGEM DE ACIDO DELTA-AMINOLEVULINICO	0	1571	0202070018	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
7283a31e-2fe7-4d7f-8bf3-652e9301501b	3653	CICLOFOSFAMIDA 50 MG (POR DRAGEA)	0	1571	0604090013	202402	1	1	3	6	26	254	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
bfdf15d1-1db6-41b6-a71e-a8c0c5993ec6	3663	DONEPEZILA 10 MG (POR COMPRIMIDO)	480	1571	0604130023	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
a1d787a6-7a19-489d-baa6-daf2905a71cf	3721	ÁCIDO NICOTÍNICO 750 MG (POR COMPRIMIDO DE LIBERAÇÃO PROLONGADA)	0	1571	0604270119	202402	1	1	3	6	26	321	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
48942188-31b2-4a31-844b-e2317e9624d8	3730	BUDESONIDA 200 MCG PO INALANTE OU AEROSSOL BUCAL (POR FRASCO C/ 200 DOSES)	0	1571	0604280092	202402	1	1	3	6	26	323	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
0fb79b2b-2ea7-41ee-8ab7-61c32fea45e4	4638	ABATACEPTE 125 MG INJETÁVEL (POR SERINGA PREENCHIDA)	216	1571	0604320140	202402	1	1	3	6	26	331	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
897d0be7-f685-4dd3-bf2d-4ad598528f4a	3776	ATORVASTATINA 80 MG (POR COMPRIMIDO)	0	1571	0604360045	202402	1	1	3	6	26	339	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.267000+00:00	2021-05-25T19:39:57.267000+00:00
df28c769-442f-4bc4-b467-6c89f579a009	4868	ETANERCEPTE 50 MG INJETÁVEL (POR FRASCO-AMPOLA OU SERINGA PREENCHIDA)(BIOSSIMILAR A)	216	1571	0604380100	202402	1	1	<span class="null">NULL</span>	6	26	341	<span class="null">NULL</span>	<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>	<span class="null">NULL</span>	1	2024-09-18T00:28:42.309265+00:00	2024-09-18T00:28:42.309265+00:00
370a1bb9-1b25-4cac-ade4-36be2ffb0dbe	3820	ALFAEPOETINA 1.000 UI INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604470010	202402	1	1	3	6	26	350	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.264000+00:00	2021-05-25T19:39:57.264000+00:00
17bfd2ca-42ba-44e9-88cf-592815923f0c	3874	DORZOLAMIDA 20 MG/ML SOLUÇÃO OFTÁLMICA (POR FRASCO DE 5 ML)	0	1571	0604660022	202402	1	1	3	6	26	369	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
9c96889b-a340-4d9c-a229-75b07db8e93b	4137	DISPOSITIVO ANTI-PROTRUSAO C/ ORIFICIOS P/ PARAFUSOS	9999	9999	0702030317	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f677e466-b518-4726-b7cb-17981b76e35e	4313	DISPOSITIVO DE BLOQUEIO	9999	9999	0702050148	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
6fee0a21-3cec-4233-86c3-6bc9f47997a2	481	DOSAGEM DE ACIDO HIPURICO	0	1571	0202070026	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
9bacf000-8f4f-48b1-86ef-768564467d9a	144	DOSAGEM DE ACIDO URICO	0	1571	0202010120	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
6c326b74-0b12-49d4-9044-af49f1d2a04f	208	DOSAGEM DE 25 HIDROXIVITAMINA D	0	1571	0202010767	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
e9734b25-253f-46c4-af9c-6ff5d4b6a653	381	DOSAGEM DA FRAÇÃO C1Q DO COMPLEMENTO	0	1571	0202031195	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
1427adeb-f1ff-4ead-b1b0-3e4d74b1007c	436	DOSAGEM DE 17-ALFA-HIDROXIPROGESTERONA	0	1571	0202060047	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
8537a6c6-8f0a-48ed-b238-c8533b688ef8	437	DOSAGEM DE 17-CETOSTEROIDES TOTAIS	0	1571	0202060055	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
f28230f5-663a-45ee-84a3-49304b381145	438	DOSAGEM DE 17-HIDROXICORTICOSTEROIDES	0	1571	0202060063	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
faa23b72-2ad3-48f4-94c8-49795c58d4f6	482	DOSAGEM DE ACIDO MANDELICO	0	1571	0202070034	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
4778ef29-00d6-4941-a477-1bed144411a2	483	DOSAGEM DE ACIDO METIL-HIPURICO	0	1571	0202070042	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
9260630b-e124-4240-94be-067d14a9b5d4	3457	DOSAGEM DE CICLOSPORINA (EM PACIENTE TRANSPLANTADO)	0	1571	0501080031	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
e9d9fda4-9812-4ba9-abdd-abf2f4a026a3	148	DOSAGEM DE ALFA-1-GLICOPROTEINA ACIDA	0	1571	0202010163	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
d505a613-3a17-4032-9858-ba0763251151	149	DOSAGEM DE ALFA-2-MACROGLOBULINA	0	1571	0202010171	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
41ed81aa-1b3b-489b-8869-40b3bbe37096	151	DOSAGEM DE AMONIA	0	1571	0202010198	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
923044da-2ef2-43e2-aaa5-ee4c82bf6e65	152	DOSAGEM DE BILIRRUBINA TOTAL E FRACOES	0	1571	0202010201	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
16276276-2456-44e5-bc43-027f93764ded	153	DOSAGEM DE CALCIO	0	1571	0202010210	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
270a5255-0ee0-4dc5-bcab-e229b7bee796	497	DOSAGEM DE CICLOSPORINA	0	1571	0202070182	202402	1	1	3	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
7fa4ed58-31c2-4391-aefa-dd0a08af5260	154	DOSAGEM DE CALCIO IONIZAVEL	0	1571	0202010228	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
741972c7-6ea7-48c3-b5a8-54aa068458cf	226	DOSAGEM DE ANTICOAGULANTE CIRCULANTE	0	1571	0202020169	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
88ce4e9f-24ba-4daf-880d-aa7f216c0761	274	DOSAGEM DE ANTIGENO PROSTATICO ESPECIFICO (PSA)	0	1571	0202030105	202402	1	0	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
45dfcce4-d74e-4ef5-91df-ea8b1800816f	590	DOSAGEM DE CLORETO NO SUOR	0	35	0202110141	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
0ac21e0e-8753-4f33-a3c8-9c6c4874911d	145	DOSAGEM DE ACIDO VANILMANDELICO	0	1571	0202010139	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
19371658-a069-473f-aab7-1ebf3035d9ea	273	DOSAGEM DE ALFA-FETOPROTEINA	0	1571	0202030091	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
a55ce111-da18-4448-af6d-230141c63f28	275	DOSAGEM DE BETA-2-MICROGLOBULINA	0	1571	0202030113	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
aad8e426-59b5-498b-967e-ca38adde3651	157	DOSAGEM DE CERULOPLASMINA	0	1571	0202010252	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
c84dd5ef-e878-4b88-b2fe-3b7dcfd4492f	158	DOSAGEM DE CLORETO	0	1571	0202010260	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.271000+00:00	2021-05-25T19:39:57.271000+00:00