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
1ef695af-9e26-4e0d-b98e-fde353d8fb60	3519	TRANSPLANTE DE RIM (ORGAO DE DOADOR FALECIDO)	0	1091	0505020092	202402	1	1	3	5	31	68	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
49ba249c-22ab-412a-ba99-a809eb96b92b	3520	TRANSPLANTE DE RIM (ORGAO DE DOADOR VIVO)	0	1091	0505020106	202402	1	1	3	5	31	68	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
218bf1c3-1f1e-4374-8459-279f69cb0a39	1478	TRATAMENTO EM REABILITACAO	0	1571	0303190019	202402	1	1	2	3	21	304	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2025-09-08T19:39:04.260000+00:00
064e2ed3-d73b-4219-a40b-b91c959f99a9	4761	SESSÃO DE AROMATERAPIA	0	1571	0309050120	202402	1	1	1	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	2025-11-04T13:50:09.554000+00:00
2055094e-baef-4be8-858a-cd7207e68e9f	1130	ATENDIMENTO DE URGENCIA C/ OBSERVACAO ATE 24 HORAS EM ATENCAO ESPECIALIZADA	0	1571	0301060029	202402	1	1	2	3	1	213	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2025-12-05T13:23:46.207000+00:00
0029e24e-85fe-4efe-9766-7141741f34e6	3522	TRANSPLANTE DE PULMÃO BILATERAL	0	1571	0505020122	202402	1	1	3	5	31	68	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
05655477-a5f5-4ea4-9d07-ed275479cad5	3589	CICLOSPORINA 25 MG P/ TRANSPLANTE (POR CAPSULA)	0	1571	0603080049	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
75640dce-a8be-4909-b2d4-ba0144b7add5	3590	CICLOSPORINA 50 MG P/ TRANSPLANTE (POR CAPSULA)	0	1571	0603080057	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
4001f4f1-91c4-4214-8da5-b13b84e1ce2c	213	CONTAGEM DE RETICULOCITOS	0	1571	0202020037	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
d2debc27-48ec-4de1-a664-47242e62f3f9	3012	CORRECAO DE EPISPADIA	0	1571	0409050024	202402	1	0	2	4	42	188	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
691ec550-d04c-4270-86fa-33bf7cfb2477	1879	CORDOTOMIA / MIELOTOMIA POR RADIOFREQUENCIA	156	1571	0403050049	202402	1	1	3	4	20	184	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
c75b3b60-4034-403f-b4cb-3c9cd079ebad	4711	CORREÇÃO DE DRENAGEM ANOMALA PARCIAL DE VEIAS PULMONARES (CRIANÇA E ADOLESCENTE)	0	227	0406011354	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
c7d95901-2e67-4eeb-bf87-a8c8399301df	4712	CORRECAO DE ESTENOSE MITRAL CONGENITA (CRIANÇA E ADOLESCENTE)	0	227	0406011362	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
e78b79da-5466-4e8a-b745-39927ee489db	1979	CORRECAO CIRURGICA DE FISTULA ORO-NASAL / ORO-SINUSAL	0	1571	0404020038	202402	1	1	2	4	24	84	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
721fdf4a-eaed-4942-b716-d2e5ceab7aec	2060	CORRECAO CIRURGICA DE EPICANTO E TELECANTO	0	1571	0405010028	202402	1	1	2	4	29	31	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
cc4f81fc-268a-4adb-b49a-0d463874bded	2078	CORRECAO CIRURGICA DE ESTRABISMO (ACIMA DE 2 MUSCULOS)	0	1571	0405020015	202402	1	1	2	4	29	85	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
b96c2ffb-9cc1-4c29-a18c-d5656d2e0642	2079	CORRECAO CIRURGICA DO ESTRABISMO (ATE 2 MUSCULOS)	0	1571	0405020023	202402	1	1	2	4	29	85	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
6bb2f05b-8a14-41c2-b3ce-2075bd7ced39	2101	CORRECAO CIRURGICA DE LAGOFTALMO	0	1571	0405040016	202402	1	1	2	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
552eb40d-325d-4af5-b090-ed2c804c8dd2	2123	CORRECAO DE ASTIGMATISMO SECUNDARIO	0	1571	0405050062	202402	1	1	2	4	29	185	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
2b4f1b11-4fda-46ba-9b6f-912ccdfd7bc3	2124	CORRECAO CIRURGICA DE HERNIA DE IRIS	0	1571	0405050070	202402	1	1	2	4	29	185	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
74d33c3d-bd2b-4449-b6ef-81bb61e049f5	2275	CORRECAO DE COARCTACAO DA AORTA COM CEC	228	1571	0406011249	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
81f5d6c8-542e-470a-aaaf-57454c69cbd7	4709	CORRECAO DE COARCTACAO DA AORTA (CRIANÇA E ADOLESCENTE)	0	227	0406011338	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
9c494ff5-1480-4ee8-b04c-9a372b34b7db	4710	CORRECAO DE DRENAGEM ANOMALA DO RETORNO SISTEMICO (CRIANÇA E ADOLESCENTE)	0	227	0406011346	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
88eb8ca0-fd4b-414c-ab4b-47c8ae410ab2	543	CONTAGEM ESPECIFICA DE CELULAS NO LIQUOR	0	1571	0202090051	202402	1	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
80248434-4024-435a-bd2b-a2bc144efe5f	3227	CORREÇÃO DE BRIDAS MUSCULARES	120	1571	0414020049	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
aa3f0b1a-dd3d-4c16-b558-6957174ef048	4034	COROA PROVISORIA	9999	9999	0701070056	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	0	OPME	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
439af83b-e601-4900-8aef-60d60d0a8d58	3013	CORRECAO DE HIPOSPADIA (1O TEMPO)	0	1571	0409050032	202402	1	0	2	4	42	188	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
fccd8023-baba-4f62-9c8d-c1426d410755	3014	CORRECAO DE HIPOSPADIA (2O TEMPO)	0	1571	0409050040	202402	1	0	2	4	42	188	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
9f0423a4-c94f-44d5-871b-15b1170e4af1	3142	COSTECTOMIA	0	1571	0412040018	202402	1	1	2	4	50	165	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
226175c6-0b83-459a-9923-9a8326f92813	3192	CORREÇÃO DE RETRAÇÃO CICATRICIAL VÁRIOS ESTÁGIOS	1	1571	0413040020	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
86a5fa3e-970b-4505-b233-3c24caa943ed	3605	TACROLIMO 1 MG P/ TRANSPLANTE (POR CAPSULA)	0	1571	0603080200	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
39fa9de4-5ed9-4345-abb7-a203f0d72776	3606	TACROLIMO 5 MG P/ TRANSPLANTE (POR CAPSULA)	0	1571	0603080219	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
e77d307f-adc4-4944-85a4-bc78e0ce667b	3632	FORMOTEROL 12 MCG + BUDESONIDA 400 MCG PO INALANTE (POR FRASCO DE 60 DOSES)	0	1571	0604040059	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
4381cae4-fe1a-4125-8b97-91efb345151c	3633	FORMOTEROL 6 MCG + BUDESONIDA 200 MCG PO INALANTE (POR FRASCO DE 60 DOSES)	0	1571	0604040067	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
620e10c3-7f8a-442e-ad81-fdf7a2e48c30	2190	CORRECAO DE JANELA AORTO-PULMONAR	228	1571	0406010382	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
f8bb4ed8-b5ba-45fb-bef9-4272b5f5154b	3228	CORREÇÃO DE IRREGULARIDADES DE REBORDO ALVEOLAR	120	1571	0414020057	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
0ee4eff1-53bc-42f3-ac06-8407ff9a8800	1800	CRANIOPLASTIA	0	1571	0403010012	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
4ac71c1a-b8fe-499f-9cac-e79e3547f950	1801	CRANIOTOMIA DESCOMPRESSIVA	0	1571	0403010020	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
8c36a6ed-b4f9-4154-88fa-7a0049ec9134	1854	CRANIECTOMIA POR TUMOR OSSEO	0	1571	0403030056	202402	1	1	3	4	20	124	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
67b16f61-36d3-4abc-b84f-c2054b56a9f6	2189	CORRECAO DE JANELA AORTO-PULMONAR (CRIANÇA E ADOLESCENTE)	0	227	0406010374	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
f1c7ef99-c186-4450-bd01-eb24711a043b	2183	CORRECAO DE FISTULA AORTO-CAVITARIAS	228	1571	0406010315	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
a718d444-092c-4387-978d-632a5902d65d	2184	CORRECAO DE HIPERTROFIA SEPTAL ASSIMETRICA	228	1571	0406010323	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
786cddcb-618e-41b7-bdeb-616ec136f59a	2185	CORRECAO DE HIPOPLASIA DE VENTRICULO ESQUERDO	0	47	0406010331	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
97083ce1-e8a1-4ad0-949d-8bf10d30bc18	2186	CORRECAO DE INSUFICIENCIA DA VALVULA TRICUSPIDE	228	1571	0406010340	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
396cd4bd-5097-4999-9260-bc2c4562459e	2187	CORRECAO DE INSUFICIENCIA MITRAL CONGENITA	228	1571	0406010358	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
e6e92834-b674-486c-9dd7-c516cd769bb3	2188	CORRECAO DE INTERRUPCAO DO ARCO AORTICO	0	47	0406010366	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
21c0cad7-e276-4b46-a1c3-63da54ca351e	2191	CORRECAO DE LESOES NA TRANSPOSICAO CORRIGIDA DOS VASOS DA BASE	0	227	0406010390	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
cff7ff20-2610-4b90-8a30-313b3aa9d7a3	2192	CORRECAO DE PERSISTENCIA DO CANAL ARTERIAL	228	1571	0406010404	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
92f0af26-07fa-4c4c-8fe7-5eaebb039780	4713	CORREÇÃO DE ESTENOSE SUPRA-AÓRTICA (CRIANÇA E ADOLESCENTE)	0	227	0406011370	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00
1577e865-d21b-4693-b1ec-9e2227c9ae8e	4714	CORRECAO DE FISTULA AORTO-CAVITARIAS (CRIANÇA E ADOLESCENTE)	0	227	0406011389	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.270000+00:00	2021-05-25T19:39:57.270000+00:00