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
dec6755c-aea9-43f9-8d46-e30018fca165	4053	PRÓTESE REMOVÍVEL EM PACIENTES COM ANOMALIAS CRÂNIO E BUCOMAXILOFACIAL	180	1571	0701080094	202402	1	1	0	7	5	234	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
84a9a7a2-81b2-435e-89a4-e1f7708bde7a	4228	PROTESE TENDINOSA DE SILICONE	9999	9999	0702031232	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
ead0bc93-75c6-44ac-b28a-e3a4c82611d0	4229	PRÓTESE TOTAL DE COTOVELO (COMPONENTE UMERAL CIMENTADO + COMPONENTE ULNAR)	9999	9999	0702031240	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
3b96de9b-f116-4e1a-97b7-62a4a38755de	4294	PROTESE VALVULAR BIOLOGICA	9999	9999	0702040541	202402	1	1	0	7	12	154	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
6ee16f7e-839d-47d3-9996-e60e99996816	4296	PROTESE VALVULAR MECANICA DE BAIXO PERFIL (DISCO)	9999	9999	0702040568	202402	1	1	0	7	12	154	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
ea5f7431-33ae-41c0-95b5-dbfebf49549e	4297	PROTESE VALVULAR MECANICA DE DUPLO FOLHETO	9999	9999	0702040576	202402	1	1	0	7	12	154	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
f847c75d-6770-437e-8319-4d89db3db1ce	4362	PROTESE PENIANA MALEAVEL (PAR DE CORPOS CAVERNOSOS)	9999	9999	0702060020	202402	1	0	0	7	12	215	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
203526fd-b827-414f-a476-3e1ca6f10b0a	4363	PROTESE TESTICULAR EM GEL DE SILICONE	9999	9999	0702060038	202402	1	0	0	7	12	215	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
16655efa-7b55-42ee-a50b-c95ca0c85099	368	PROVAS DE PRAUSNITZ-KUSTNER (PK)	0	1571	0202031055	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
47d9b076-7253-40d4-9bbf-0ca0db57ba92	538	PROVA CONFIRMATÓRIA DA PRESENÇA DE MICRO-ORGANISMOS COLIFORMES	9999	9999	0202080242	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	0	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
65e6868e-5e6b-4eba-a1c7-38328137a49b	260	PROVA DO LACO	0	1571	0202020509	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
c4274968-9f65-414b-aa75-85e0d569479d	258	PROVA DE CONSUMO DE PROTROMBINA	0	1571	0202020487	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
4d7f4e0d-bef0-4455-b612-71ac30940d21	259	PROVA DE RETRACAO DO COAGULO	0	1571	0202020495	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
40c4bff5-83c7-450e-9cc3-fc91c4a093a2	4371	PRÓTESE TRAQUEOESOFÁGICA PARA REABILITAÇÃO DA FONAÇÃO DO PACIENTE LARINGECTOMIZADO..INCLUI MATERIAL.	9999	9999	0702090042	202402	1	1	0	7	12	252	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
04ab4b33-76bb-491f-9581-2ee7b8ed9e96	4295	PROTESE VALVULAR BIOLOGICA S/ SUPORTE / ANEL	9999	9999	0702040550	202402	1	1	0	7	12	154	1	<span class="null">NULL</span>	0	<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.280000+00:00	2021-05-25T19:39:57.280000+00:00
36eda7fa-d4a6-408a-a920-7588b68cb5ef	257	PROVA DE COMPATIBILIDADE PRE-TRANSFUSIONAL (MEIOS SALINOS, ALBUMINOSO E COOMBS)	0	1571	0202020479	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
d7d48fc2-8d8f-402e-8227-c821e2a70693	3434	PROVAS CRUZADAS EM DOADOR VIVO DE RIM (CROSS MATCH)	216	1091	0501040072	202402	1	1	3	5	7	147	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
1d026aa7-a307-4917-a622-e0fceaa45a22	3432	PROVA CRUZADA EM DOADOR VIVO CONTRA LINFOCITOS T OU B C/ ABSORCAO DE PLAQUETAS (CROSS MATCH)	216	1571	0501040056	202402	1	1	3	5	7	147	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
6368bafe-646a-47c8-aa31-40b140eada10	206	PROVA DA D-XILOSE	0	1571	0202010740	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
2ea13bdc-a5d8-4a66-9e16-67c1f08282ed	565	PROVA DE PROGRESSAO ESPERMATICA (CADA)	120	1571	0202090280	202402	1	0	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
33cd7f04-89a4-4cb4-a247-cd0a6a9c098e	566	PROVA DO LATEX P/ HAEMOPHILLUS INFLUENZAE, STREPTOCOCCUS PNEUMONIAE, NEISSERIA MENINGITIDIS (SOROTIPOS A, B, C)	0	1571	0202090299	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.280000+00:00	2021-05-25T19:39:57.281000+00:00
117532b2-aa42-464d-addf-6951585d9949	4042	PROTESE TOTAL MAXILAR	180	1571	0701070137	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
8e5d5c62-c667-4e98-99b5-b32dd854579e	4041	PROTESE TOTAL MANDIBULAR	180	1571	0701070129	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
4267464b-f17c-46d0-9750-d5c65b292f26	1030	PROVA BIOLOGICA P/ IDENTIFICACAO DO VIRUS DA RAIVA	0	1571	0213010470	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
9bd1a538-5e3b-41d0-bdf4-0ea10eabc3b6	1031	PROVA CONTRA-IMUNOELETROFORESE P/ MENINGOCOCOS (MENINGITE BACTERIANA)	0	1571	0213010488	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
ceaed8de-8ad5-4b1d-915f-aaa2f05e70e6	2941	PUNCAO / ASPIRACAO DA BEXIGA	0	1571	0409010359	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
50a7989f-7eeb-41a5-a5af-33202674e681	3116	PUNCAO DE TRAQUEIA C/ ASPIRACAO	0	1571	0412010062	202402	1	1	2	4	50	38	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
e35c9760-b951-4fca-9ef6-2c99ce58d997	3697	QUETIAPINA 25 MG (POR COMPRIMIDO)	0	1571	0604230036	202402	1	1	3	6	26	313	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
c1c86cfa-04f7-4f12-95ae-2ff8d172b068	3699	QUETIAPINA 200 MG (POR COMPRIMIDO)	0	1571	0604230052	202402	1	1	3	6	26	313	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
e16a8230-3dab-47f0-8777-ac11edc42a42	3700	QUETIAPINA 300 MG (POR COMPRIMIDO)	0	1571	0604230060	202402	1	1	3	6	26	313	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
5f8345e8-ddb2-4b37-adec-a636e47b177d	4196	PLACA DE COMPRESSAO DINAMICA 4,5 MM LARGA (INCLUI PARAFUSOS)	9999	9999	0702030910	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
0b1d3842-3999-425c-9c8f-d2d1e820ac95	4198	PLACA DE RECONSTRUÇÃO DE 4,5 MM (INCLUÍ PARAFUSOS)	9999	9999	0702030937	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
f3f6cbf6-3abd-41f6-a960-b5063df93afa	4199	PLACA DE SUPORTE DE PLATEAU TIBIAL 4,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030945	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
4d4b17bf-9105-4f37-a3f8-4c180abcf388	4201	PLACA EM L 3,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030961	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
3c7dd774-d2f3-430b-ac0e-b19f32193dae	4202	PLACA EM L 4,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030970	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
fe5c8b68-f7be-44d4-9f60-f33a66a77df5	4203	PLACA EM T 2,7MM (INCLUI PARAFUSOS)	9999	9999	0702030988	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
56a7c679-5d32-4838-9908-3e3c9c97aaa9	4204	PLACA EM T 3,5 MM (INCLUI PARAFUSOS)	9999	9999	0702030996	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
9b5edb8b-8fa5-40b0-97d6-f80cc8a16776	2754	QUADRICEPSPLASTIA	0	1571	0408050110	202402	1	1	2	4	41	187	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
f43bee84-3840-4e29-ae54-44a8605679bd	120	PUNCAO DE CISTERNA SUB-OCCIPITAL	0	1571	0201010593	202402	1	1	2	2	3	3	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
acaa7547-e5b7-49e8-8d4b-83ff013e0760	123	PUNCAO EXPLORADORA DO DEFERENTE	0	1571	0201010623	202402	1	0	2	2	3	3	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
5afaf3b6-111a-46e2-9dca-1b2a1654a472	1546	QUIMIOTERAPIA DE CARCINOMA DO FÍGADO OU DO TRATO BILIAR AVANÇADO	228	1571	0304020389	202402	1	1	3	3	27	75	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
1636fe11-e739-4095-88d1-5ad22d0b812d	1599	QUIMIOTERAPIA DE CARCINOMA PULMONAR INDIFERENCIADO DE CÉLULAS PEQUENAS (ADJUVANTE)	228	1571	0304050180	202402	1	1	3	3	27	182	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
29b88082-fd36-4536-be64-b68eb8cedaa6	1612	QUIMIOTERAPIA DA DOENÇA DE HODGKIN - 2ª LINHA	228	1571	0304060038	202402	1	1	3	3	27	197	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
455e473a-832d-4e11-b8a8-3c51e364dc0b	1948	PUNCAO TRANSMEATICA DO SEIO MAXILAR (UNILATERAL)	0	1571	0404010261	202402	1	1	2	4	24	30	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
9c941f34-9c12-4da8-a8dc-7f1e8763e9bf	2077	PUNCTOPLASTIA	0	1571	0405010206	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
f9472db7-fdc4-4241-aa9f-d07bd41eea37	3333	QUIMIOEMBOLIZAÇÃO DE CARCINOMA HEPÁTICO	228	1571	0416040195	202402	1	1	3	4	57	146	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
f49e013c-f338-4ffd-acc3-f27615b62b84	4205	PLACA EM T 4,5 MM (INCLUI PARAFUSOS)	9999	9999	0702031003	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
9f7ac596-58c0-438b-a7bf-dc5622ba0751	1628	QUIMIOTERAPIA DE CANCER NA INFÂNCIA E ADOLESCÊNCIA - 1ª LINHA	0	299	0304070017	202402	1	1	3	3	27	230	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
34f891f9-b1e8-49ae-adba-305bb3642121	1629	QUIMIOTERAPIA DE CANCER NA INFÂNCIA E ADOLESCÊNCIA - 2ª LINHA	0	299	0304070025	202402	1	1	3	3	27	230	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
a7a62ef3-e554-4e2a-b05b-0be98a448692	1630	QUIMIOTERAPIA DE CÂNCER NA INFÂNCIA E ADOLESCÊNCIA - 4ª LINHA	0	299	0304070033	202402	1	1	3	3	27	230	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.281000+00:00	2021-05-25T19:39:57.281000+00:00