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
6439caff-74d8-4130-b659-6b6e374f36bf	920	TRIAGEM OFTALMOLÓGICA	48	1571	0211060275	202402	1	1	1	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
45c19c26-cd24-425e-920d-e1d9676cdb9a	4785	TROCA DO PROCESSADOR DE FALA P/ IMPLANTE COCLEAR MULTICANAL	9999	9999	0701030348	202402	1	1	0	7	5	118	1	<span class="null">NULL</span>	0	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
0ffee95a-3787-407d-976a-8cb39d0c28ba	184	DOSAGEM DE ISOMERASE-FOSFOHEXOSE	0	1571	0202010520	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
f2dd17b2-d741-4fd2-830f-8b1d2f3bee68	185	DOSAGEM DE LACTATO	0	1571	0202010538	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
b379f45e-dd3e-4c58-877c-cf74eba42bce	1659	TREINAMENTO DE PACIENTE SUBMETIDO A DIALISE PERITONEAL - DPAC-DPA (9 DIAS)	0	1571	0305010182	202402	1	1	3	3	28	21	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
3c4ff204-5845-4872-ac83-5ad0a9fbdc6f	1963	TURBINECTOMIA	144	1571	0404010415	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
02cf1a1b-3ed6-4dac-9421-1d2d8a032495	1152	TREINO DE ORIENTAÇÃO E MOBILIDADE	0	1571	0301070148	202402	1	1	2	3	1	224	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
fc7e90ad-7e7b-4b3d-b0b1-461f15ee66b4	1668	TRIAGEM CLINICA DE DOADOR (A) DE SANGUE	192	839	0306010038	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
6936da1a-eaa3-45e7-abfd-a90e1853d40a	1833	TREPANACAO CRANIANA PARA PROPEDEUTICA NEUROCIRURGICA / IMPLANTE PARA MONITORIZACAO PIC	0	1571	0403010349	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
715167ce-249c-4643-95e9-267dabef53ae	1834	TREPANACAO CRANIANA PARA PROPEDEUTICA OU TERAPEUTICA NEUROCIRURGICA (COM TECNICA COMPLEMENTAR)	0	1571	0403010357	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
d6f03db2-b56a-4ced-ab63-e1e9ddd6ada9	1835	TREPANACAO CRANIANA PARA PROPEDEUTICA OU TERAPEUTICA NEUROCIRURGICA	0	1571	0403010365	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
5caf3257-8fcc-415e-a8cb-fb29860202dd	1922	TROCA DE GERADOR DE PULSOS PARA ESTIMULAÇÃO CEREBRAL	228	1571	0403080100	202402	1	1	3	4	20	232	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
45f0b62b-6072-49ec-9cc2-52ce97864b1b	2269	TROCA DE GERADOR E DE ELETRODOS DE MARCAPASSO DE CAMARA DUPLA	0	1571	0406011184	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
2a04a598-660a-4dd3-9f3d-2ebeb8e4af43	2251	TROCA DE ARCO AORTICO	216	1571	0406010994	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
1f635b15-76d8-4643-8b19-6422a5adb35c	2252	TROCA DE CONJUNTO DO SEIO CORONARIO NO MARCAPASSO MULTI-SITIO	0	1571	0406011001	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
ac4697fe-a4d8-4382-aabe-2868400538b0	2255	TROCA DE ELETRODOS DE MARCAPASSO DE CAMARA DUPLA	0	1571	0406011036	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
44d5543a-25d6-4dae-9379-d8f37aca5072	2256	TROCA DE ELETRODOS DE MARCAPASSO DE CAMARA UNICA	0	1571	0406011044	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
1c42f69e-f9d3-4563-bee7-6ad2b1fe6702	2258	TROCA DE ELETRODOS DE MARCAPASSO NO CARDIO-DESFIBRILADOR MULTI-SITIO	0	1571	0406011079	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
39468fb9-51e2-4ea8-a197-46f959211938	2259	TROCA DE ELETRODOS DE MARCAPASSO NO MARCAPASSO MULTI-SITIO	0	1571	0406011087	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
5f628496-7946-4f32-b641-80120689fd94	2260	TROCA DE ELETRODOS DE SEIO CORONARIO NO CARDIOVERSOR DESFIBRILADOR MULTI-SITIO	0	1571	0406011095	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
ff31afd6-f631-4d2a-86e3-a6cbb699d6fe	2261	TROCA DE GERADOR DE CARDIO-DESFIBRILADOR DE CAMARA UNICA / DUPLA	0	1571	0406011109	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
a4a17738-353a-4d8d-a2d1-dcab63cea5aa	2262	TROCA DE GERADOR DE CARDIO-DESFIBRILADOR MULTI-SITIO	0	1571	0406011117	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
e64022f5-dcd1-4a97-94b3-1c119405e152	2332	TROCA DE AORTA DESCENDENTE (INCLUI ABDOMINAL)	0	1571	0406020582	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
feff6fde-dc5f-4ad6-be72-95ce2dc67391	2333	TROMBECTOMIA DO SISTEMA VENOSO	0	1571	0406020590	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
4876b3e1-2f27-44a2-b85d-3e720c384b9d	2428	TRATAMETO CIRURGICO DE MEGAESOFAGO SEM RESSECCAO / CONSERVADOR	96	1571	0407010335	202402	1	1	2	4	38	33	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
9f395d35-0e77-44c4-abca-d8c580f8451f	4454	TRIAGEM OFTALMOLÓGICA	48	1571	ABPG020	202402	1	1	1	2	49	203	0	920	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
31cd9492-acfb-4cfe-9c02-d9c64ace840f	186	DOSAGEM DE LEUCINO-AMINOPEPTIDASE	0	1571	0202010546	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
9a52d23f-30f5-4be4-8ef3-eceec7733980	187	DOSAGEM DE LIPASE	0	1571	0202010554	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
ee85a90e-6e0a-4867-8ee4-af0d3efc645c	190	DOSAGEM DE PIRUVATO	0	1571	0202010589	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
17ee9e54-0de4-4585-a7b6-3fb93d284c96	198	DOSAGEM DE TRANSFERRINA	0	1571	0202010660	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
dec46371-0fa1-4af7-953a-88c640a6c6b3	199	DOSAGEM DE TRIGLICERIDEOS	0	1571	0202010678	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
c3c9cd19-dc94-49d4-bc75-aa7f788d94d2	200	DOSAGEM DE TRIPTOFANO	0	1571	0202010686	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
45ac1fc4-5e53-49a5-9189-e81861f28e0d	201	DOSAGEM DE UREIA	0	1571	0202010694	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
4919337e-9611-447c-9d9a-b8673abc1be5	202	DOSAGEM DE VITAMINA B12	0	1571	0202010708	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
225e124f-f18b-4cca-a90a-d65640e74726	732	ULTRASSONOGRAFIA TRANSFONTANELA	0	59	0205020178	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
ad9bf5ec-0025-4271-90cf-d8c007685cf9	4522	ULTRASSONOGRAFIA OBSTÉTRICA	96	731	ABEX024	202402	0	1	2	2	30	98	0	729	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
ef6516e0-0c89-4dbf-9f34-3af9d588a684	735	ULTRASSONOGRAFIA DE MAMA UNILATERAL PARA AVALIAÇÃO DE POSSÍVEIS COMPLICAÇÕES DE IMPLANTE DE PRÓTESE	192	1571	0205020208	202402	1	1	2	2	30	98	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
c84960b1-c487-4b75-b57b-c427374485e8	733	ULTRASSONOGRAFIA TRANSVAGINAL	108	1571	0205020186	202402	0	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
5fa3fea0-8fc6-4cb8-838e-91cb5ed77d71	1660	ULTRAFILTRACAO	0	1571	0305010190	202402	1	1	2	3	28	21	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
9f9e9bcf-2797-4c03-8f81-ece8c14cf5f6	721	ULTRASSONOGRAFIA DE ARTICULACAO	0	1571	0205020062	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
bdfb3f9a-63de-4ce2-9c25-1348c44fe89f	726	ULTRASSONOGRAFIA DE PROSTATA (VIA TRANSRETAL)	120	1571	0205020119	202402	1	0	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
d0cba98c-51bd-4079-aec9-fb40d91824b1	727	ULTRASSONOGRAFIA DE TIREOIDE	0	1571	0205020127	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
cfedbd08-a933-486d-aff0-b23c39078e0c	2273	UNIFOCALIZACAO DE RAMOS DA ARTERIA PULMONAR S/ CIRCULACAO EXTRACORPOREA	0	227	0406011222	202402	1	1	3	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
2a0953fb-567f-4e04-9e0f-25693b0728e8	729	ULTRASSONOGRAFIA OBSTETRICA	96	731	0205020143	202402	0	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
6b7b7d7e-f7a6-43f3-b553-b79560f34553	2961	URETEROENTEROSTOMIA	0	1571	0409010553	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
339245b0-9398-455f-9776-a06dd7881d85	714	ULTRASSONOGRAFIA DOPPLER COLORIDO DE VASOS	0	1571	0205010040	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
731a80a1-6ca0-4d50-a89c-82003c1512a3	719	ULTRASSONOGRAFIA DE ABDOMEN TOTAL	0	1571	0205020046	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
ab844471-fcfc-4e83-b344-ab8f8b8136ca	2964	URETEROSTOMIA CUTANEA	0	1571	0409010588	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
bbe0e685-0766-4060-b576-ddee6f79d225	2958	URETERECTOMIA	0	1571	0409010529	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
13495f2e-2350-4ee7-882b-0c465503df6e	2959	URETEROCISTONEOSTOMIA	0	1571	0409010537	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.289000+00:00	2021-05-25T19:39:57.289000+00:00