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
6678215d-3953-4544-94ca-d12006ae79c4	4715	CORREÇÃO DE HIPERTROFIA SEPTAL ASSIMETRICA (CRIANÇA E ADOLESCENTE)	0	227	0406011397	202402	1	1	3	4	34	32	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
57e30652-5e0f-41d2-988d-48f19932a251	4716	CORRECAO DE INSUFICIENCIA DA VALVULA TRICUSPIDE (CRIANÇA E ADOLESCENTE)	0	227	0406011400	202402	1	1	3	4	34	32	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
1cb05721-5a81-4361-98f2-59327386d91c	4717	CORRECAO DE INSUFICIENCIA MITRAL CONGENITA (CRIANÇA E ADOLESCENTE)	0	227	0406011419	202402	1	1	3	4	34	32	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
35659cdc-173f-4ff3-96cd-e0cf0177c013	4718	CORRECAO DE PERSISTENCIA DO CANAL ARTERIAL (CRIANÇA E ADOLESCENTE)	0	227	0406011427	202402	1	1	3	4	34	32	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
2370b662-e978-451b-b87f-0cca9067bcdf	4719	CORRECAO DO CANAL ATRIO-VENTRICULAR PARCIAL / INTERMEDIARIO (CRIANÇA E ADOLESCENTE)	0	227	0406011435	202402	1	1	3	4	34	32	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
4fb4842c-249f-4fd4-a3b3-70825582b4b4	4720	CORRECOES DE ANOMALIAS DO ARCO AORTICO (CRIANÇA E ADOLESCENTE)	0	227	0406011443	202402	1	1	3	4	34	32	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
a46b202b-075c-4b9c-9c8f-3365a9fdfc1f	2364	CORRECAO ENDOVASCULAR DE ANEURISMA / DISSECCAO DA AORTA ABDOMINAL C/ ENDOPROTESE RETA / CONICA	216	1571	0406040150	202402	1	1	3	4	34	161	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
a11b9b02-f815-4ee3-b5d4-a79660a2e359	2365	CORRECAO ENDOVASCULAR DE ANEURISMA / DISSECCAO DA AORTA ABDOMINAL E ILIACAS C/ ENDOPROTESE BIFURCADA	216	1571	0406040168	202402	1	1	3	4	34	161	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
c0cfd9a2-86d2-4468-8e74-b567fb884e3e	2366	CORRECAO ENDOVASCULAR DE ANEURISMA / DISSECCAO DA AORTA TORACICA C/ ENDOPROTESE RETA OU CONICA	216	1571	0406040176	202402	1	1	3	4	34	161	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
e2cf1fcd-e6ae-4096-84c2-73ccd53ca2d8	2367	CORRECAO ENDOVASCULAR DE ANEURISMA / DISSECCAO DAS ILIACAS C/ ENDOPROTESE TUBULAR	216	1571	0406040184	202402	1	1	3	4	34	161	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
6886859e-857e-4738-9ece-f80adc974d89	2651	COSTO-TRANSVERSECTOMIA	0	1571	0408030330	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
f6756500-8ea5-4e92-83a7-ea92a304bdf9	2652	COSTOPLASTIA (3 OU MAIS COSTELAS)	0	1571	0408030348	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
2b4d5d80-ef40-43e5-8688-2a81fea2c785	3229	CORREÇÃO DE TUBEROSIDADE DO MAXILAR	120	1571	0414020065	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
87184017-6553-40e2-a945-a34ccbf9538c	1740	CRIOCAUTERIZACAO / ELETROCOAGULACAO DE COLO DE UTERO	228	1571	0309030048	202402	0	1	2	3	43	123	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
ffb1998c-bf27-4d02-8108-9bc3a786066d	4646	DACLATASVIR 60 MG (POR COMPRIMIDO REVESTIDO)	216	1571	0604760027	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
9a1e2b7a-f48d-4fc1-8915-420b95531b7e	1061	CULTURA P/ IDENTIFICACAO DO VIBRIO CHOLERAE EM ANALISE DE AGUA	9999	9999	0213020076	202402	1	1	2	2	52	106	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<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
d9a0ad4e-4766-4758-a252-64856a867205	3026	CURETAGEM SEMIOTICA C/ OU S/ DILATACAO DO COLO DO UTERO	120	1571	0409060046	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
9876ec46-ce63-4e7a-8fab-ea4dca3e5d36	3027	CURETAGEM UTERINA EM MOLA HIDATIFORME	120	1571	0409060054	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f9ebd0c0-3600-4143-9f90-18f8767c4820	3176	CURATIVO EM GRANDE QUEIMADO	0	1571	0413010031	202402	1	1	3	4	53	39	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
845124d6-5135-4ce3-b439-6cd0a4da5ff6	3177	CURATIVO EM MEDIO QUEIMADO	0	1571	0413010040	202402	1	1	2	4	53	39	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
d3f8d7c4-3633-4b2e-8c9a-aacfa454fc4f	3178	CURATIVO EM PEQUENO QUEIMADO	0	1571	0413010058	202402	1	1	2	4	53	39	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
63d38726-27c2-40b2-8ecb-dee68c330220	3107	CURETAGEM POS-ABORTAMENTO / PUERPERAL	108	731	0411020013	202402	0	1	2	4	48	90	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
12bb1256-a4fe-4e1b-9ac5-f3855017c678	4501	CREATININA	0	1571	ABEX003	202402	1	1	2	2	9	4	1	163	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
42fb4661-5792-4681-88a8-7768d8bbb8e8	900	CURVA DIARIA DE PRESSAO OCULAR CDPO (MINIMO 3 MEDIDAS)	0	1571	0211060062	202402	1	1	2	2	49	203	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
b69b8a06-0e88-480c-9fb9-e79b285867e7	1062	CULTURA P/ IDENTIFICACAO DO VIBRIO CHOLERAE EM ANALISE DE ALIMENTOS	9999	9999	0213020084	202402	1	1	2	2	52	106	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<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
a3c33edc-72b1-4378-9ddb-a1fce8545202	1804	CRANIOTOMIA PARA RETIRADA DE CISTO / ABSCESSO / GRANULOMA ENCEFALICO (C/ TECNICA COMPLEMENTAR)	0	1571	0403010055	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
0f648c54-1bf8-401e-8f98-b953682b16c0	1805	CRANIOTOMIA PARA RETIRADA DE CORPO ESTRANHO INTRACRANIANO	0	1571	0403010063	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
bfca9b31-17be-4025-96fc-a76aa2a96a0b	2082	CRIOTERAPIA OCULAR	0	1571	0405030037	202402	1	1	2	4	29	126	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
ff2a984f-415b-4aba-b6cb-90b5ad783f83	2102	CRIOTERAPIA DE TUMORES INTRA-OCULARES	0	1571	0405040024	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
d94fb81e-3d8b-49df-ab17-27b934c1fddb	2443	CRIPTECTOMIA UNICA / MULTIPLA	144	1571	0407020110	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
539f456c-06d4-4649-a6a7-0a82ea3dd157	524	CULTURA P/ HERPESVIRUS	0	1571	0202080102	202402	1	1	2	2	9	242	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
73dab44d-5798-4827-b2cf-5736b8b18a11	3634	FORMOTEROL 6MCG + BUDESONIDA 200 MCG (POR CAPSULA INALANTE)	0	1571	0604040075	202402	1	1	3	6	26	152	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
40261587-c7e0-427b-a5c4-f3f5f54d0afb	3637	CODEINA 3 MG/ML SOLUCAO ORAL (POR FRASCO DE 120 ML)	0	1571	0604050011	202402	1	1	3	6	26	179	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
1217f0b2-a603-415b-90e8-3b5510403a8a	3638	CODEINA 30 MG/ML (POR AMPOLA DE 2 ML)	0	1571	0604050020	202402	1	1	3	6	26	179	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
8f3c1886-09b9-482f-8de6-bf18b8c3c267	3639	CODEINA 30 MG (POR COMPRIMIDO)	0	1571	0604050038	202402	1	1	3	6	26	179	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
325d28fa-36e9-4d96-bc78-59eea36996a6	3640	CODEINA 60 MG (POR COMPRIMIDO)	0	1571	0604050046	202402	1	1	3	6	26	179	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
ae3819d1-b8ee-417b-ada9-f339f8f8a44a	1765	CURATIVO GRAU I C/ OU S/ DEBRIDAMENTO	0	1571	0401010023	202402	1	1	1	4	8	27	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
2a2d9750-ca5f-40f8-8c31-fb91d61942d5	613	DACRIOCISTOGRAFIA	0	1571	0204010012	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ac54993c-9abe-4120-97c1-bc6866f09316	1191	CUIDADOS COM ESTOMAS	0	1571	0301100063	202402	1	1	2	3	1	263	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ff2a5d8b-fcc0-4a4d-8bb2-92a5d9e8b224	3591	DACLIZUMABE 5 MG/ ML INJETAVEL P/ TRANSPLANTE (POR FRASCO DE 5 ML)	0	1571	0603080065	202402	1	1	3	6	19	243	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
d7bd99b3-7836-46af-a9d1-fe2048482186	526	CULTURA PARA BACTERIAS ANAEROBICAS	0	1571	0202080129	202402	1	1	2	2	9	242	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
ed84805a-c8af-4fac-aa02-689f083e5f9a	527	CULTURA PARA IDENTIFICACAO DE FUNGOS	0	1571	0202080137	202402	1	1	2	2	9	242	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
2a2610d3-4d93-401a-8d6f-42be3675aa5a	4481	CURATIVO DE DEMORA C/ OU S/ PREPARO BIOMECÂNICO	0	1571	ABPO008	202402	1	1	1	3	36	78	0	1690	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
bb5ae80a-298b-4d11-8211-e1f9ba51ecd9	522	CULTURA DE BACTERIAS P/ IDENTIFICACAO	0	1571	0202080080	202402	1	1	2	2	9	242	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
ef8b01fc-e1aa-4f6d-8178-be5a8b2d0db1	523	CULTURA DO LEITE HUMANO (POS-PASTEURIZAÇÃO)	120	599	0202080099	202402	0	1	2	2	9	242	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
77d9aa06-393c-43f1-ae40-101c9e956e0d	1080	CONSULTA PARA AVALIAÇÃO CLÍNICA DO FUMANTE	120	1571	0301010099	202402	1	1	1	3	1	17	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	0	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2026-07-24T13:01:35.319000+00:00
133b9e78-9c8f-444a-b76c-863ccf398bed	1690	CURATIVO DE DEMORA C/ OU S/ PREPARO BIOMECANICO	0	1571	0307020029	202402	1	1	1	3	36	78	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
b3328dad-cb51-4936-8ac3-6beed4ff25ad	1764	CURATIVO GRAU II C/ OU S/ DEBRIDAMENTO	0	1571	0401010015	202402	1	1	2	4	8	27	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
05f5ab6f-546f-45f1-8f63-9a16ed2f71c9	4442	CURATIVO ESPECIAL	0	1571	ABPG007	202402	1	1	1	4	8	27	1	1765	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
53d88ce5-db44-460c-8823-49df34d41cb7	4469	CURATIVO SIMPLES	0	1571	ABPG035	202402	1	1	1	4	8	27	1	1765	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00