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
1c2b1492-d8b5-464b-b1c5-79729e72b17c	378	TESTES CUTANEOS DE LEITURA IMEDIATA	0	1571	0202031152	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
9321bf62-3a41-448a-9aab-0df61218c520	916	TESTE ORTÓPTICO	0	1571	0211060232	202402	1	1	2	2	49	203	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
ab1a8e01-364c-4922-a5eb-d890f3d3b8ae	372	TESTE TREPONEMICO P/ DETECÇÃO DE SIFILIS	0	1571	0202031098	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
ae880e82-4941-40b2-b1b8-141133f33d6d	478	TESTE P/ INVESTIGACAO DO DIABETES INSIPIDUS	0	1571	0202060462	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
05c40647-490f-48dd-8639-32d70114a4db	599	TESTE INDIRETO DE ANTIGLOBULINA HUMANA (TIA)	0	1571	0202120090	202402	1	1	2	2	9	280	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
67c58dd0-f58e-4d47-b552-11fb0c7041f3	600	TITULACAO DE ANTICORPOS ANTI A E/OU ANTI B	0	1571	0202120104	202402	1	1	2	2	9	280	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
0221da8d-e310-4281-8b18-8729f7fbdde8	1067	TESTE RÁPIDO PARA DETECÇÃO DE INFECÇÃO PELO HIV	24	1571	0214010058	202402	1	1	2	2	55	16	0	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
208757fd-1fda-4775-872d-c51df32d5779	1068	TESTE RÁPIDO DE GRAVIDEZ	108	671	0214010066	202402	0	1	1	2	55	16	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
808c57fd-ad3a-470f-937c-c65e6cd55840	1069	TESTE RÁPIDO PARA SÍFILIS	24	1571	0214010074	202402	1	1	2	2	55	16	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
fc902782-0f75-4075-8620-12b6aebd0134	4460	TESTE RÁPIDO PARA SÍFILIS	24	1571	ABPG026	202402	1	1	2	2	55	16	0	1069	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
1c03858c-e859-4e61-a9a3-cb000c2ff913	4456	TESTE RÁPIDO DE GRAVIDEZ	108	671	ABPG022	202402	0	1	1	2	55	16	0	1068	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
afd23cc3-8e0f-42d5-b705-88f5ae205799	4458	TESTE RÁPIDO DE HIV	24	1571	ABPG024	202402	1	1	2	2	55	16	1	1067	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
b827ca2e-77e0-41d7-85e2-a3a20945b752	4459	TESTE RÁPIDO PARA HEPATITE C	24	1571	ABPG025	202402	1	1	1	2	55	16	1	1071	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
3a80e6eb-e703-4b01-b849-5daa58109481	4530	TESTE RÁPIDO PARA DOSAGEM DE PROTEINÚRIA	0	1571	ABPG040	202402	1	1	1	2	55	16	1	<span class="null">NULL</span>	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
522abe4b-2f1f-4ec1-ae51-aa62e20017d0	3376	TORACECTOMIA COMPLEXA EM ONCOLOGIA	0	1571	0416110037	202402	1	1	3	4	57	274	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
f8193620-4c96-4952-b407-5e3a061af5c5	3827	TOLCAPONA 100 MG (POR COMPRIMIDO)	0	1571	0604490020	202402	1	1	3	6	26	352	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
3af8fe02-150e-41e8-b99f-32b39a2be709	4498	ULOTOMIA / ULECTOMIA	0	1571	ABPO027	202402	1	1	1	4	54	109	0	3248	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
68cd88c9-3b57-4b3a-bb8f-b112fb15f1a9	4913	INSERÇÃO DO IMPLANTE SUBDÉRMICO LIBERADOR DE ETONOGESTREL	216	599	0301040176	202402	0	1	<span class="null">NULL</span>	3	1	172	<span class="null">NULL</span>	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:31:26.336000+00:00	2026-07-31T18:17:51.836000+00:00
14be2ab7-c427-4d04-bf59-f5d9f8b80944	3377	TORACECTOMIA SIMPLES EM ONCOLOGIA	0	1571	0416110045	202402	1	1	3	4	57	274	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
6dff0ef6-d21b-400b-aed4-5065eac892aa	3151	TORACECTOMIA COM RECONSTRUÇÃO PARIETAL (POR PROTESE)	0	1571	0412040123	202402	1	1	3	4	50	165	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
eb77a5b6-e882-4a06-9a78-6453f2f26f71	3152	TORACECTOMIA SEM RECONSTRUÇÃO PARIETAL	0	1571	0412040131	202402	1	1	3	4	50	165	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
2ac3a34c-1af8-4e1f-bbee-660228882ff9	3153	TORACOPLASTIA (QUALQUER TECNICA)	0	1571	0412040158	202402	1	1	3	4	50	165	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
de0edffc-bb79-4d72-9df2-06436fa91013	3154	TORACOSTOMIA COM DRENAGEM PLEURAL FECHADA	0	1571	0412040166	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
263591fb-1bc1-4171-b6db-5bebbddb767b	3155	TORACOTOMIA EXPLORADORA	0	1571	0412040174	202402	1	1	3	4	50	165	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
a8f94568-3e98-42ca-b400-d482af4a1315	3173	TORACOCENTESE/DRENAGEM DE PLEURA	0	1571	0412050170	202402	1	1	2	4	50	189	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
186e107a-48ee-4bc9-99ba-915cab0ee850	3205	TRANSFERENCIA INTERMEDIARIA DE RETALHO	0	1571	0413040151	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
4baca77b-21f8-4f92-b89d-56ebfb14edac	3833	TOPIRAMATO 25 MG (POR COMPRIMIDO)	0	1571	0604500068	202402	1	1	3	6	26	353	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
0ac0b1dc-85e3-4256-87c2-cf553a765fca	3834	TOPIRAMATO 50 MG (POR COMPRIMIDO)	0	1571	0604500076	202402	1	1	3	6	26	353	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
269e7783-8528-43b7-8939-315db73847d8	3835	TOPIRAMATO 100 MG (POR COMPRIMIDO)	0	1571	0604500084	202402	1	1	3	6	26	353	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
45dd1dd5-bc97-4c30-8f3c-f743c8c99efe	3845	TOXINA BOTULINICA TIPO A 100 U INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604550014	202402	1	1	3	6	26	358	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
62bb2867-1ed2-48b6-b20d-77a6c4e37711	3846	TOXINA BOTULINICA TIPO A 500 U INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604550022	202402	1	1	3	6	26	358	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
72af15c2-48c8-40ee-a4b9-f0261e50dfc5	3378	TORACOTOMIA EXPLORADORA EM ONCOLOGIA	0	1571	0416110053	202402	1	1	3	4	57	274	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
1853d599-1b05-4362-9a52-c352f873f8cb	3427	TRANPORTE DE UNIDADE DE CELULAS TRONCO HEMATOPOETICAS DE SANGUE DE CORDAO UMBILICAL E PLACENTARIO NO BRASIL	0	851	0501030123	202402	1	1	3	5	7	112	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
6cc7b04e-2414-4070-8c92-ef57620e97fb	737	TOMOGRAFIA COMPUTADORIZADA DE COLUNA CERVICAL C/ OU S/ CONTRASTE	0	1571	0206010010	202402	1	1	3	2	33	8	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
5dda87b1-172e-47be-bba0-f59eb5215ea1	919	TOPOGRAFIA COMPUTADORIZADA DE CÓRNEA	0	1571	0211060267	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
6e0f6da1-d320-46a7-9ab8-cf46370c91d2	4754	TOMOGRAFIA DE COERÊNCIA ÓPTICA	216	1571	0211060283	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
5edba821-24d4-49c5-8a2a-b4794dd46c22	918	TONOMETRIA	0	1571	0211060259	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
976da544-94db-4249-876c-3d1133e9d1a2	1673	TRANSFUSAO DE CONCENTRADO DE GRANULOCITOS	0	1571	0306020050	202402	1	1	3	3	35	77	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
f26466bd-92b8-4f65-9958-ed05467244cf	1900	TRANSECÇÕES SUB-PIAIS MULTIPLAS EM AREAS ELOQUENTES	0	1571	0403060095	202402	1	1	3	4	20	201	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
52b26219-7a53-4efa-99aa-6731e55283a3	2781	TRANSFERENCIA DO GRANDE TROCANTER (PROCEDIMENTO ISOLADO)	0	1571	0408050381	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
bb21f538-277b-4eb1-9b9b-928c38f71977	2782	TRANSFERENCIA MUSCULAR / TENDINOSA NO MEMBRO INFERIOR	0	1571	0408050390	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
bf556290-8776-4cb7-b0fa-3422351b9b85	4900	REABILITAÇÃO CARDIORRESPIRATÓRIA DE PACIENTES PÓS COVID-19	0	1571	0301070229	202402	1	1	<span class="null">NULL</span>	3	1	224	<span class="null">NULL</span>	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:40.155173+00:00	2024-09-18T00:29:40.155173+00:00
670d658c-32f3-4c77-967c-9ec02d47f529	4897	DISPENSAÇÃO DE SUPLEMENTO DE FERRO	5	731	0101040113	202402	1	1	<span class="null">NULL</span>	1	4	166	<span class="null">NULL</span>	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:40.155173+00:00	2024-09-18T00:29:40.155173+00:00
c916a865-8568-44e1-b243-036cf1d12cc2	1501	RADIOTERAPIA ESTEREOTÁXICA FRACIONADA	144	1571	0304010243	202402	1	1	3	3	27	20	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.282000+00:00	2021-05-25T19:39:57.282000+00:00
3febd826-b6c8-4044-9dc4-f2b231b09768	1500	RADIOTERAPIA DE DOENÇA OU CONDIÇÃO BENIGNA (POR CAMPO)	0	1571	0304010235	202402	1	1	3	3	27	20	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.282000+00:00	2021-05-25T19:39:57.282000+00:00
5a881826-c214-4a21-ba2d-abc8b8773336	1148	ATENDIMENTO/ACOMPANHAMENTO INTENSIVO DE PACIENTE EM REABILITAÇÃO FÍSICA (1 TURNO PACIENTE-DIA - 15 ATENDIMENTOS-MÊS)	0	1571	0301070105	202402	1	1	2	3	1	224	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
5ab9a9ba-51d4-4b43-84a5-6ac004154444	1235	ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE NO PRÉ/PÓS-OPERATÓRIO DE NEUROCIRURGIA	0	1571	0302060057	202402	1	1	2	3	16	209	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
66019be5-5100-465c-a8a6-42260a372da9	615	RADIOGRAFIA BILATERAL DE ORBITAS (PA + OBLIQUAS + HIRTZ)	0	1571	0204010039	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
55a090e4-de63-40e2-915e-48156566dadf	616	RADIOGRAFIA DE ARCADA ZIGOMATICO-MALAR (AP+ OBLIQUAS)	0	1571	0204010047	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
367fdabe-c2f2-4b57-8f14-c3d464dd7502	617	RADIOGRAFIA DE ARTICULACAO TEMPORO-MANDIBULAR BILATERAL	0	1571	0204010055	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.281000+00:00	2021-05-25T19:39:57.281000+00:00