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
a4e67896-6c7c-49bb-8d10-5c4f7dc7fe08	470	DOSAGEM DE TIROXINA LIVRE (T4 LIVRE)	0	1571	0202060381	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
9485529d-abf2-4358-ba90-6219b17f54e1	679	DUODENOGRAFIA HIPOTONICA	0	1571	0204050049	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
07329b2e-93c0-4467-bedd-904199590819	2965	DRENAGEM DE COLECAO PERI-URETRAL	0	1571	0409020010	202402	1	1	2	4	42	89	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
470e6d0e-edf4-4809-afce-c485f2d8ea43	2966	DRENAGEM DE FLEIMAO URINOSO	0	1571	0409020028	202402	1	1	2	4	42	89	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
bb6ae062-da91-453b-a444-523e0f9c74a3	2919	DRENAGEM DE ABSCESSO RENAL / PERI-RENAL	0	1571	0409010138	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
3cf8956f-535a-4c2a-bd76-c3013b87cb35	3062	DRENAGEM DE GLANDULA DE BARTHOLIN / SKENE	120	1571	0409070122	202402	0	1	2	4	42	228	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
9a733ca8-1d5a-4590-a3e5-6a766740944a	3081	DRENAGEM DE ABSCESSO DE MAMA	0	1571	0410010014	202402	1	1	2	4	45	36	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
04c1ead2-af8c-4274-beb7-46e06d5d3bfc	3139	DRENAGEM TUBULAR PLEURAL ABERTA (PLEUROSTOMIA)	0	1571	0412030101	202402	1	1	2	4	50	131	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
1768c675-0c66-4777-a219-e3cb95a1d91e	3441	ECO DOPPLER COLORIDO CEREBRAL P/ DIAGNOSTICO DE MORTE ENCEFALICA	0	1091	0501060030	202402	1	1	3	5	7	205	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
c41db747-1c2e-4ad8-b616-4f019c4ba0ca	3863	ALFACALCIDOL 0,25 MCG (POR CAPSULA)	0	1571	0604620012	202402	1	1	3	6	26	365	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
50ff0625-214c-49f2-a1ba-90aedf7d0d6f	901	ELETRO-OCULOGRAFIA	0	1571	0211060070	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
d55f7249-42a7-41f4-9931-13fdb0c7fc8e	1767	ELETROCOAGULACAO DE LESAO CUTANEA	0	1571	0401010040	202402	1	1	2	4	8	27	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
27aa3534-bb72-4b09-af69-80f2d42a72d1	1927	DRENAGEM DE ABSCESSO FARINGEO	0	1571	0404010059	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
00e9c991-d52b-4933-81a1-f2af757a3b73	2062	DRENAGEM DE ABSCESSO DE PALPEBRA	0	1571	0405010044	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
b965d7c1-ca41-4efc-a3cd-f78f815e56d0	2097	DRENAGEM DE HEMORRAGIA DE COROIDE	2	1571	0405030207	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
51993949-d915-4a49-ac13-b2a97d65611d	2286	DRENAGEM DE GANGLIO LINFATICO	0	1571	0406020116	202402	1	1	2	4	34	86	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
1199e265-3011-46e8-bad9-094c28e1f0d7	2445	DRENAGEM DE ABSCESSO ANU-RETAL	0	1571	0407020136	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
af3a12e2-8a18-4942-a358-465456266a6e	2446	DRENAGEM DE ABSCESSO ISQUIORRETAL	0	1571	0407020144	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
fa2ad077-93d4-4478-b7b6-391b1964edd3	2447	DRENAGEM DE HEMATOMA / ABSCESSO RETRO-RETAL	0	1571	0407020152	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
116219ee-b42a-469b-b93a-28f08d888faf	2448	ELETROCAUTERIZACAO DE LESAO TRANSPARIETAL DE ANUS	0	1571	0407020160	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
1795648e-964f-421b-8a16-a917d07576a8	2492	DRENAGEM BILIAR PERCUTANEA INTERNA	0	1571	0407030115	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
538dac2b-6f5e-4b7c-a6a7-c6b57eeecf18	2665	DRENAGEM CIRÚRGICA DO ILIOPSOAS	0	1571	0408030470	202402	1	1	2	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
1427aae9-1cce-4bef-8fbe-ee5505406138	647	DUCTOGRAFIA (POR MAMA)	192	1571	0204030021	202402	1	1	2	2	25	135	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
361be428-8b02-4e83-bc19-26193da7a9f1	1981	DRENAGEM DE ABSCESSO DA BOCA E ANEXOS	0	1571	0404020054	202402	1	1	2	4	24	84	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
4674e25c-50b4-40a5-ab83-3787f51955c5	4502	ELETROCARDIOGRAMA	0	1571	ABEX004	202402	1	1	2	2	49	104	0	862	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
cc7b67a3-4d71-4acf-b9e6-f350eab5e4ae	862	ELETROCARDIOGRAMA	0	1571	0211020036	202402	1	1	2	2	49	104	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
5c1c315b-fbfe-48f5-af5d-36eddfbdeb48	3329	DUODENOPANCREATECTOMIA EM ONCOLOGIA	0	1571	0416040128	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
b6f75d5b-f7ed-4b78-bbea-0b8664f0572b	3261	DRENAGEM DE COLECOES VISCERAIS / CAVITARIAS POR CATETERISMO	0	1571	0415040051	202402	1	1	3	4	56	174	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
6ff8d5a1-8041-48e8-a0d9-dadb340cce04	2983	DRENAGEM DE ABSCESSO PROSTATICO	240	1571	0409030015	202402	1	0	2	4	42	130	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
7e030ec5-ee05-4cc0-a54a-32a3f9500e5a	2987	DRENAGEM DE ABSCESSO DA BOLSA ESCROTAL	0	1571	0409040010	202402	1	0	2	4	42	164	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
470f9928-f93c-4931-8d27-12086176df70	2988	DRENAGEM DE ABSCESSO DO EPIDIDIMO E/OU CANAL DEFERENTE	0	1571	0409040029	202402	1	0	2	4	42	164	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
22500f13-339f-4c33-bbbf-b8eeb72149dd	3864	ALFACALCIDOL 1,0 MCG (POR CAPSULA)	0	1571	0604620020	202402	1	1	3	6	26	365	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
23d77681-ad46-4733-a9ca-eef1fa19842f	3866	CALCITRIOL 1,0 MCG INJETAVEL (POR AMPOLA)	0	1571	0604620047	202402	1	1	3	6	26	365	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
3cf4c14b-0eec-41ea-8846-3b3cadbaa274	3870	BIMATOPROSTA 0,3 MG/ML SOLUÇÃO OFTÁLMICA (POR FRASCO DE 3 ML)	0	1571	0604650019	202402	1	1	3	6	26	368	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.267000+00:00	2021-05-25T19:39:57.267000+00:00
29981840-d0e3-4b55-bcaf-91afaa40dbcc	4525	EAS / EQU	0	1571	ABEX027	202402	1	1	2	2	9	190	1	401	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
594b7855-a6d3-4e8a-80bc-f57c172de301	1836	DRENAGEM LIQUÓRICA LOMBAR EXTERNA	0	1571	0403010390	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
ee4c9880-3ee6-4184-bf8d-312c49eb40d5	711	ECOCARDIOGRAFIA DE ESTRESSE	0	1571	0205010016	202402	1	1	3	2	30	7	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
fcb5a56c-939e-401b-be79-ef254f10ba63	713	ECOCARDIOGRAFIA TRANSTORACICA	0	1571	0205010032	202402	1	1	2	2	30	7	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
ad4b4569-492c-40f6-bc46-5533b656aad1	716	ECODOPPLER TRANSCRANIANO	0	1571	0205020011	202402	1	1	2	2	30	98	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
070a5cb1-7310-4587-83d4-51ca569c0ad7	4443	DRENAGEM DE ABSCESSO	0	1571	ABPG008	202402	1	1	1	4	8	27	0	1766	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
24f632b5-22dc-4c4b-8266-07807fc91ce2	712	ECOCARDIOGRAFIA TRANSESOFAGICA	0	1571	0205010024	202402	1	1	3	2	30	7	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
701879f4-ecf8-42c2-b5d9-a1a252aad857	1766	DRENAGEM DE ABSCESSO	0	1571	0401010031	202402	1	1	1	4	8	27	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
156ef69d-6d57-4255-a310-c568f991d465	3442	ELETROENCEFALOGRAMA P/ DIAGNOSTICO DE MORTE ENCEFALICA	0	1091	0501060049	202402	1	1	2	5	7	205	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
4f17171a-d12b-4097-9297-3580c2ad2df2	4528	ELETROFORESE DE HEMOGLOBINA	0	1571	ABEX030	202402	1	1	2	2	9	95	0	245	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
e77caca3-2015-4a28-9e3c-f0a36040f2e4	934	EMISSOES OTOACUSTICAS EVOCADAS P/ TRIAGEM AUDITIVA (TESTE DA ORELHINHA)	0	23	0211070149	202402	1	1	2	2	49	225	0	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
8775ce75-16cb-4c70-8d8a-18ac1e95ebb1	3108	EMBRIOTOMIA	108	731	0411020021	202402	0	1	2	4	48	90	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
9ecca59d-f9f8-4dba-a245-99bef86b49f3	3873	BRINZOLAMIDA 10 MG/ML SUSPENSÃO OFTÁLMICA (POR FRASCO DE 5 ML)	0	1571	0604660014	202402	1	1	3	6	26	369	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
0eddbb6f-b160-4790-a9cb-aec0fbe789be	3875	ACETAZOLAMIDA 250 MG (POR COMPRIMIDO)	0	1571	0604660030	202402	1	1	3	6	26	369	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.263000+00:00	2021-05-25T19:39:57.263000+00:00
19a61f3f-0293-491b-a962-e441ea661cc2	3876	BRIMONIDINA 2,0 MG/ML SOLUÇÃO OFTÁLMICA (POR FRASCO DE 5 ML)	0	1571	0604670010	202402	1	1	3	6	26	370	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
f1a22c34-fdc6-4a44-8979-36839e43b31c	3877	RITUXIMABE 500 MG INJETÁVEL (POR FRASCO-AMPOLA DE 50 ML)	216	1571	0604680023	202402	1	1	3	6	26	371	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.283000+00:00	2021-05-25T19:39:57.283000+00:00