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
619a1d67-5506-4cff-86e2-6eb9c51b35f2	2337	ANGIOPLASTIA CORONARIANA	0	1571	0406030014	202402	1	1	3	4	34	127	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
45cfe242-0d84-4436-9424-5150fb5dad87	2339	ANGIOPLASTIA CORONARIANA C/ IMPLANTE DE STENT	216	1571	0406030030	202402	1	1	3	4	34	127	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
eb94a551-c59f-492d-b9dd-2c8f3eda1da6	2622	ARTRODESE CERVICAL / CERVICO-TORÁCICA POSTERIOR SEIS NÍVEIS	0	1571	0408030046	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
e7d59de8-311d-4058-94f2-c25b65e54be8	515	ANTIBIOGRAMA	0	1571	0202080013	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
c74bcf5d-2298-451c-b8d4-4ab67af20da5	517	ANTIBIOGRAMA P/ MICOBACTERIAS	0	1571	0202080030	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
57ce7478-c1e7-4274-8a0b-2a13a6b27fa6	3691	AMANTADINA 100 MG (POR COMPRIMIDO)	0	1571	0604200013	202402	1	1	3	6	26	307	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.264000+00:00	2021-05-25T19:39:57.264000+00:00
d4cc5fb9-5da5-4e27-94c5-53cf4d886eb9	516	ANTIBIOGRAMA C/ CONCENTRACAO INIBITORIA MINIMA	0	1571	0202080021	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
598dd320-7cce-4c16-b319-30cd1c508ad7	838	AORTOGRAFIA ABDOMINAL	0	1571	0210010045	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
948f933d-d6eb-46ca-b9ec-ad87a3d742ed	839	AORTOGRAFIA TORACICA	0	1571	0210010053	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
770babf1-ac19-4cff-9eac-d20c5337c400	1122	ANTIBIOTICOTERAPIA PARENTERAL	0	1571	0301050082	202402	1	1	1	3	1	194	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
5ea9899c-1e64-45d6-82cb-9b076448f6ac	4111	ARRUELAS DE TITANIO PARA CIRURGIA DA COLUNA	9999	9999	0702030058	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
d3c200ba-c9f5-494c-9680-1d2d36c92f2e	4477	APLICAÇÃO DE SELANTE (POR DENTE)	0	1571	ABPO004	202402	1	1	1	1	4	93	0	10	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
6b1fd8a0-95ed-48e2-a4b4-7ef74e06723a	4045	APARELHO ORTOPÉDICO FIXO	9999	9999	0701070161	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	0	OPME	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
6a727cc4-c7e5-4cd8-811d-e93236ebe0d2	9	APLICAÇÃO DE CARIOSTÁTICO (POR DENTE)	0	1571	0101020058	202402	1	1	1	1	4	93	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
24d68b48-28a2-4060-b624-c9e94d5b7399	1177	APOIO À SERVIÇO RESIDENCIAL DE CARÁTER TRANSITÓRIO POR CENTRO DE ATENÇÃO PSICOSSOCIAL	0	1571	0301080330	202402	1	1	2	3	1	240	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
e2455874-8527-4ac1-b923-3e65a6c3554e	1381	ARTROCENTESE DE GRANDES ARTICULACOES	0	1571	0303090014	202402	1	1	2	3	21	247	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
2b856f9a-6301-4e88-9e9d-7ebade98571c	1670	APLICACAO DE FATOR IX DE COAGULACAO	0	1571	0306020025	202402	1	1	2	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
fb0a8a80-e21f-4144-841c-d5aefc6a8ce4	1671	APLICACAO DE FATOR VIII DE COAGULACAO	0	1571	0306020033	202402	1	1	2	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
ba9ad668-7745-4356-96e0-b846940a7546	16	APLICAÇÃO DE SUPLEMENTOS DE MICRONUTRIENTES	0	599	0101040016	202402	1	1	1	1	4	166	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
7b4aab2d-2b27-41da-b912-22c2c7400150	1965	ARITENOIDECTOMIA COM LARINGOFISSURA	0	1571	0404010431	202402	1	1	3	4	24	30	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
5db85973-57b4-4e1e-9cc7-cb5335f9f654	2080	APLICACAO DE PLACA RADIOATIVA EPISCLERAL	0	1571	0405030010	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
26043484-7423-4188-b3e2-4984004ca024	2435	APENDICECTOMIA	24	1571	0407020039	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
68761fea-0927-47de-a420-11d8fd7e65d4	2436	APENDICECTOMIA VIDEOLAPAROSCOPICA	0	1571	0407020047	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
cea8e94d-a383-4da8-9460-7f2726d68b2b	2560	ARTROPLASTIA DE PUNHO	240	1031	0408020067	202402	1	1	3	4	41	88	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
2113508e-33d6-48f7-8571-90647c835ed3	2621	ARTRODESE CERVICAL / CERVICO-TORÁCICA POSTERIOR DOIS NÍVEIS	0	1571	0408030038	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.266000+00:00	2021-05-25T19:39:57.266000+00:00
c904f83a-800b-433c-b767-b32bf7616ab0	4030	APARELHO FIXO BILATERAL PARA FECHAMENTO DE DIASTEMA	96	1571	0701070013	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
10ea50ca-49ec-48b2-a96a-5d5f7bb89768	4031	APARELHO ORTOPÉDICO E ORTODÔNTICO REMOVÍVEL	60	1571	0701070021	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
27a5795f-736c-47fa-a238-530e6e9481ee	3915	APOIOS LATERAIS DE QUADRIL PARA CADEIRA DE RODAS	9999	9999	0701010304	202402	1	1	0	7	5	55	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
78cb670e-8fe2-45d6-894f-49f07db8a6b2	3916	APOIO PARA ESTABILIZAÇÃO DA CABEÇA NA CADEIRA DE RODAS	9999	9999	0701010312	202402	1	1	0	7	5	55	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
aa9ed0f2-c603-4dc0-b379-c451f7973d67	4109	ARRUELA DENTEADA	9999	9999	0702030031	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
d3ccd9ae-6694-4397-984b-3a1a2d2bd104	4110	ARRUELA LISA	9999	9999	0702030040	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
ce2e3246-fcbe-46d2-b629-45c5ca0d7abf	3914	APOIOS LATERAIS DO TRONCO EM 3 OU 4 PONTOS	9999	9999	0701010290	202402	1	1	0	7	5	55	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
9d2e71d9-6692-49cd-91ff-7d8edd786499	843	ARTERIOGRAFIA P/ INVESTIGACAO DE DOENCA ARTERIOSCLEROTICA AORTO-ILIACA E DISTAL	0	1571	0210010096	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
b32609a7-c227-416b-b703-08fd5112b66a	844	ARTERIOGRAFIA P/ INVESTIGACAO DE HEMORRAGIA CEREBRAL	0	1571	0210010100	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
6aa250fc-257c-41b6-b7ba-e63185fd0ff8	847	ARTERIOGRAFIA SELETIVA DE CAROTIDA	0	1571	0210010134	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
c71ecce5-799e-4b85-9b2f-bd75133ba95f	4476	APLICAÇÃO DE CARIOSTÁTICO (POR DENTE)	0	1571	ABPO003	202402	1	1	1	1	4	93	0	9	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
ee52a683-aa07-4efa-9bd5-6b650a33d97b	4478	APLICAÇÃO TÓPICA DE FLÚOR (INDIVIDUAL POR SESSÃO)	0	1571	ABPO005	202402	1	1	1	1	4	93	0	11	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
6343ac62-1bdb-454f-9ac6-f4e6749cf9a2	10	APLICAÇÃO DE SELANTE (POR DENTE)	0	1571	0101020066	202402	1	1	1	1	4	93	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
85db7a70-7bf9-43a7-b75c-e5c00dec80bf	11	APLICAÇÃO TÓPICA DE FLÚOR (INDIVIDUAL POR SESSÃO)	0	1571	0101020074	202402	1	1	1	1	4	93	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
6e50cd78-a8aa-4185-b24c-574b016c4d27	840	ARTERIOGRAFIA CERVICO-TORACICA	0	1571	0210010061	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
dd47a9a9-a09f-4bab-bc33-09168593e4ba	841	ARTERIOGRAFIA DE MEMBRO	0	1571	0210010070	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
456767c8-ff77-498a-bc01-608d5b7bfa27	842	ARTERIOGRAFIA DIGITAL (POR VIA VENOSA)	0	1571	0210010088	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
338f7f35-5ecc-43fa-85ca-e1834cc207cb	846	ARTERIOGRAFIA PELVICA	0	1571	0210010126	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
a01dea28-b5dd-4597-9b79-857614a22eee	849	ARTERIOGRAFIA SELETIVA VERTEBRAL	0	1571	0210010150	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.266000+00:00	2021-05-25T19:39:57.266000+00:00
aa3c7ed6-b607-4df6-9f57-0d2da537e150	3225	APICECTOMIA COM OU SEM OBTURAÇÃO RETRÓGRADA	60	1571	0414020022	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
5f5f507a-469d-4cad-afb1-0816b9c3e5b1	3226	APROFUNDAMENTO DE VESTÍBULO ORAL (POR SEXTANTE)	120	1571	0414020030	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.265000+00:00	2021-05-25T19:39:57.265000+00:00
93e99f84-cc84-4ee1-8935-e523a7d115d2	4032	APARELHO P/ BLOQUEIO MAXILO-MANDIBULAR	72	1571	0701070030	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
94bc86fa-307a-4ac7-989a-e0c7b5882b83	4046	APARELHO ORTODÔNTICO FIXO	9999	9999	0701070170	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	0	OPME	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
8c9e699d-69bf-4fbe-9635-835b2a4350f6	972	APLICACAO DE TESTE P/ PSICODIAGNOSTICO	0	1571	0211100013	202402	1	1	2	2	49	260	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
c552c7a1-3b1a-47bf-96f5-7d7672ce30c3	155	DOSAGEM DE CAROTENO	0	1571	0202010236	202402	1	1	2	2	9	4	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