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
242960c6-b5fb-422d-972b-1125fa2979e7	676	CLISTER OPACO C/ DUPLO CONTRASTE	0	1571	0204050014	202402	1	1	2	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
b77596dc-99d0-40f6-a0b0-130c71224fbc	799	CISTOCINTILOGRAFIA DIRETA	0	1571	0208040064	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
52659554-44bf-4afd-aa85-7a3faf7a55dd	800	CISTOCINTILOGRAFIA INDIRETA	0	1571	0208040072	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
d9150c8f-d765-4c7c-b8de-eec44b82b08c	809	CISTERNOCINTILOGRAFIA (INCLUINDO PESQUISA E/OU AVALIACAO DO TRANSITO LIQUORICO)	0	1571	0208060022	202402	1	1	3	2	39	204	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
79ec4bf9-e87c-4671-9490-0d808c6210bf	4616	CIRURGIA DE UNHA (CANTOPLASTIA)	0	1571	0401020177	202402	1	1	1	4	8	81	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
c4fd878d-477f-438a-9c2f-0feadf1b0fa7	4440	CIRURGIA DE UNHA (CANTOPLASTIA)	0	1571	ABPG005	202402	1	1	1	4	8	81	0	4616	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
0bbd00e1-2f2b-4b95-b14a-7eff12d89bda	3421	COLETA E ACONDICIONAMENTO DE MEDULA OSSEA NO BRASIL PARA TRANSPLANTE AUTOGENICO OU DE DOADOR APARENTADO OU NAO APARENTADO	0	911	0501030069	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
e21d92d4-bcef-4173-b10c-1f07d059c885	3416	COLETA, ACONDICIONAMENTO E TRANSPORTE INTERNACIONAL DE CELULAS-TRONCO HEMATOPOIETICAS DE MEDULA OSSEA P/ TRANSPLANTE	9999	9999	0501030018	202402	1	1	3	5	7	112	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
85c8c38e-3fac-4ba6-bdc0-76e77a6fade9	3213	TRATAMENTO CIRURGICO NAO ESTETICO DA ORELHA	60	851	0413040232	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
b7ac6c0f-4794-41a3-99e0-f53c716ca389	3214	TRATAMENTO CIRURGICO P/ REPARACOES DE PERDA DE SUBSTANCIA DA MAO	0	1571	0413040240	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.287000+00:00	2021-05-25T19:39:57.287000+00:00
7a5531c2-5829-44c3-ba4a-4f6cff5d6893	3215	DERMOLIPECTOMIA ABDOMINAL CIRCUNFERENCIAL PÓS CIRURGIA BARIATRICA	216	1571	0413040259	202402	1	1	3	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
04fd93d3-fa33-42d3-9458-c7ef84e66667	3390	ANESTESIA REGIONAL	0	1571	0417010052	202402	1	1	2	4	58	43	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
a6382d06-5ac4-47fc-8655-972886801501	3394	CONFECCAO DE FISTULA ARTERIO-VENOSA P/ HEMODIALISE	0	1571	0418010030	202402	1	1	3	4	59	44	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
3a9242bd-c7d4-4f12-9c6f-4f01240d9089	3404	COLETA DE SANGUE EM HEMOCENTRO P/ EXAMES DE HISTOCOMPATIBILIDADE (CADASTRO DE DOADOR NO REDOME)	0	431	0501010017	202402	1	1	3	5	7	45	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
21b5b072-0d02-42cc-bc9c-ded48ae30e3c	3412	CONFIRMACAO DE TIPIFICACAO DE DOADOR DE MEDULA OSSEA OU DE OUTROS PRECURSORES HEMATOPOETICO - 3ª FASE	216	731	0501010092	202402	1	1	3	5	7	45	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
68ccf07f-8bda-48cb-bb8b-7f9cee09d30a	4259	COILS EMBOLIZANTE	9999	9999	0702040169	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
5bd11a8f-e256-4abf-bc35-5105ad488493	128	COLETA DE LAVADO BRONCO-ALVEOLAR	0	1571	0201020017	202402	1	1	2	2	3	94	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
6fbb30e7-d101-4cf8-b5f5-59b53ae25cc1	4585	COLETA DE VESTÍGIOS DE VIOLÊNCIA SEXUAL	0	1571	0301040060	202402	1	1	2	3	1	172	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
f72a5a26-c78b-4c72-b9c4-7af5413197a7	1666	COLETA DE SANGUE P/ TRANSFUSAO	192	839	0306010011	202402	1	1	2	3	35	22	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
8e51916f-3570-4e18-a887-f741af51abe0	1667	COLETA DE SANGUE P/ TRANSFUSAO (C/ PROCESSADORA AUTOMATICA)	192	839	0306010020	202402	1	1	3	3	35	22	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
c9c6d082-6679-40fd-994d-7d65a0c5945b	3701	CLOZAPINA 25 MG (POR COMPRIMIDO)	0	1571	0604230079	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
99cf0858-3a8e-4585-8274-a81eae9a4cb2	3343	COLECTOMIA PARCIAL (HEMICOLECTOMIA) EM ONCOLOGIA	0	1571	0416050026	202402	1	1	3	4	57	175	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
9c875c5a-f58f-4e09-9322-6c9b25a32dab	2438	COLECTOMIA PARCIAL (HEMICOLECTOMIA)	0	1571	0407020063	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
edbbc687-329c-4979-a369-9bf40f3e0e32	2439	COLECTOMIA TOTAL	144	1571	0407020071	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
cb721b29-21b2-4dff-96e1-c37957e4d6f0	3702	CLOZAPINA 100 MG (POR COMPRIMIDO)	0	1571	0604230087	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
1f7b9770-92a2-4bff-8179-885c5fad18a3	3337	COLECISTECTOMIA EM ONCOLOGIA	144	1571	0416040233	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
a5850fc6-4aaa-4831-945c-70bf77487abc	3344	COLECTOMIA TOTAL EM ONCOLOGIA	0	1571	0416050034	202402	1	1	3	4	57	175	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
9792b406-87d7-420f-8abd-03ae44c4b73a	3571	CLORIDRATO DE TIROFIBANA	0	1571	0603050026	202402	1	1	2	6	19	178	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
6a72af65-fe47-46fa-a0bd-5e44b6e2a5de	3579	CLOPIDOGREL 75MG (COMPRIMIDO)	0	1571	0603050107	202402	1	1	2	6	19	178	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
e718f6c0-4b29-4db3-9e53-f5b48055b0d8	3762	CLOPIDOGREL 75 MG (POR COMPRIMIDO)	0	1571	0604330022	202402	1	1	3	6	26	332	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
772da319-c671-4d08-aa0e-0b4831751f30	4500	COLESTEROL TOTAL	0	1571	ABEX002	202402	1	1	2	2	9	4	1	161	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
f9cb1e75-85b1-41c8-8d0b-60b1884ff0d4	4444	COLETA DE CITOPATOLÓGICO DE COLO UTERINO	120	1571	ABPG010	202402	0	1	1	2	3	94	1	130	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
21aa5729-36da-41e1-b9d4-cb15ef2f8541	130	COLETA DE MATERIAL P/ EXAME CITOPATOLOGICO DE COLO UTERINO	120	1571	0201020033	202402	0	1	1	2	3	94	0	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
d5623731-5de8-4991-9b14-fabb4358420a	677	COLANGIOGRAFIA PER-OPERATORIA	0	1571	0204050022	202402	1	1	2	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
06f92975-b4ab-46e3-8193-7cc497793d68	678	COLANGIOGRAFIA POS-OPERATORIA	0	1571	0204050030	202402	1	1	2	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
bbb8b356-7859-49c1-9b2a-a0a9eec9b235	855	COLANGIOGRAFIA TRANSCUTANEA	0	1571	0210020016	202402	1	1	3	2	47	103	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
d18d9625-5a92-4efe-8b53-d295248f565c	129	COLETA DE LINFA P/ PESQUISA DE M. LEPRAE	0	1571	0201020025	202402	1	1	1	2	3	94	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
1853bb06-cfc4-4693-99b4-d930a993a157	132	COLETA DE SANGUE P/ TRIAGEM NEONATAL	0	11	0201020050	202402	1	1	1	2	3	94	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
390ffcd3-5d78-4732-8a71-9cac72a5f8fa	822	COLANGIOPANCREATOGRAFIA RETROGRADA (VIA ENDOSCOPICA)	0	1571	0209010010	202402	1	1	2	2	44	11	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
74684d78-a8a3-4837-9ed4-039da61a38f5	3322	COLEDOCOSTOMIA C/ OU S/ COLECISTECTOMIA EM ONCOLOGIA	144	1571	0416040020	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
6a970eef-3f23-4cfd-8c9c-cf54312f10e7	4470	COLETA DE MATERIAL PARA EXAME LABORATORIAL	0	1571	ABPG036	202402	1	1	1	2	3	94	0	131	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.269000+00:00	2021-05-25T19:39:57.269000+00:00
dab9f941-2e75-4c8e-9818-47e4580fd8e0	4117	COMPONENTE CEFALICO	9999	9999	0702030112	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
b8089f30-af43-48d6-aea9-8a345f2f096d	4122	COMPONENTE FEMORAL CIMENTADO MODULAR PRIMARIO	9999	9999	0702030163	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
cc5388df-3090-4fb0-a162-9b8f9259fe40	4123	COMPONENTE FEMORAL CIMENTADO MONOBLOCO TIPO CHARNLEY	9999	9999	0702030171	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
f13ba9c2-7174-4999-8bf1-f26f83b87b27	3540	COMPLEXO PROTROMBINICO FRASCO DE 500 A 600 UI EM COAGULOPATIAS HEREDITARIAS	0	1571	0602010020	202402	1	1	3	6	13	52	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
eb133f4e-a13f-4203-a8c1-941a5519d3cf	2165	COLOCACAO DE BALAO INTRA-AORTICO	0	1571	0406010129	202402	1	1	2	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.269000+00:00	2021-05-25T19:39:57.269000+00:00
44dc27e2-a608-46c8-bc38-24f67afa1c5b	2363	COLOCACAO PERCUTANEA DE FILTRO DE VEIA CAVA (NA TROMBOSE VENOSA PERIFERICA E EMBOLIA PULMONAR)	0	1571	0406040141	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
0db12690-2e71-4fd8-b423-4e696045ff92	2441	COLORRAFIA POR VIA ABDOMINAL	0	1571	0407020098	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
fca9ea85-57c9-4666-9618-6d504b506367	2442	COLOSTOMIA	0	1571	0407020101	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
85e14456-d792-47e8-921b-4e5aa4a22ebb	2489	COLOCACAO DE PROTESE BILIAR	0	1571	0407030085	202402	1	1	3	4	38	128	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