Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
codigo	TEXT
codigo_ab	TEXT
descricao	TEXT
procedimento_complexidade_id	TEXT
sexo_sigtap_id	TEXT
qtd_maxima_execucao	INTEGER
qtd_dias_permanencia	INTEGER
qtd_pontos	INTEGER
idade_minima	TEXT
idade_maxima	TEXT
vl_servico_hospitalar	REAL
vl_servico_ambulatorial	REAL
vl_servico_profissional	REAL
procedimento_financiamento_id	TEXT
procedimento_rubrica_id	TEXT
qtd_tempo_permanencia	TEXT
qtd_maxima_esus	TEXT
competencia_sigtap	TEXT
procedimento_sub_grupo_id	TEXT
exige_cid	INTEGER
procedimento_ficha_atendimento_odontologico	INTEGER
procedimento_ficha_atendimento_individual_exames	INTEGER
ativo	INTEGER
data_criacao	TEXT
data_alteracao	TEXT
grupo_odontologico	TEXT
exame_terceirizado	INTEGER
exame_municipal	INTEGER
procedimento_bpa	TEXT
formato_exportacao	TEXT
imprimir_solicitacao_procedimento_bpa_i	INTEGER
imprimir_solicitacao_procedimento_apac	INTEGER

id	codigo	codigo_ab	descricao	procedimento_complexidade_id	sexo_sigtap_id	qtd_maxima_execucao	qtd_dias_permanencia	idade_minima	idade_maxima	vl_servico_hospitalar	vl_servico_ambulatorial	procedimento_financiamento_id	procedimento_rubrica_id	qtd_tempo_permanencia	qtd_maxima_esus	competencia_sigtap	procedimento_sub_grupo_id	exige_cid	procedimento_ficha_atendimento_odontologico	procedimento_ficha_atendimento_individual_exames	ativo	data_criacao	data_alteracao	grupo_odontologico	exame_terceirizado	exame_municipal	procedimento_bpa	formato_exportacao
1eee4d78-b2ab-49fa-b468-1b06f1bc625b	0701020318	<span class="null">NULL</span>	ÓRTESE TLSO TIPO COLETE / JAQUETA DE RISSER	d9a73cdf-75b6-4860-a4b7-287a43b940fc	3a5fe839-ea15-48a5-b187-67a95185becf	1	9999	9999	9999	0	780	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	fce3c94e-197a-4575-b79f-88cd1a201fc6	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	INDIVIDUALIZADO
e42eafe5-a902-4520-8c1b-5e2b43eabd7d	0701020610	<span class="null">NULL</span>	CINTA PARA TRANSFERÊNCIAS	d9a73cdf-75b6-4860-a4b7-287a43b940fc	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	144	1571	0	150	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	fce3c94e-197a-4575-b79f-88cd1a201fc6	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	INDIVIDUALIZADO
0fca765e-b8d6-4b5a-9652-ef6e10542dab	0701020601	<span class="null">NULL</span>	TÁBUA (PRANCHA) PARA TRANSFERÊNCIA	d9a73cdf-75b6-4860-a4b7-287a43b940fc	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	144	1571	0	75	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	fce3c94e-197a-4575-b79f-88cd1a201fc6	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	INDIVIDUALIZADO
351f3f19-12dc-41ec-822a-5979b5e5bdb3	0701030267	<span class="null">NULL</span>	REPOSIÇÃO DE AASI EXTERNO MICRO-CANAL TIPO C	d9a73cdf-75b6-4860-a4b7-287a43b940fc	3a5fe839-ea15-48a5-b187-67a95185becf	2	9999	9999	9999	0	1100	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	fce3c94e-197a-4575-b79f-88cd1a201fc6	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
d2264f2a-9be8-45d0-890c-c248e81f9d85	0701090090	<span class="null">NULL</span>	SUBSTITUIÇÃO/TROCA DO ENCAIXE PARA PRÓTESE TRANSFEMURAL ENDOESQUELETICA / EXOESQUELETICA.	d9a73cdf-75b6-4860-a4b7-287a43b940fc	3a5fe839-ea15-48a5-b187-67a95185becf	2	9999	9999	9999	0	1098	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	fce3c94e-197a-4575-b79f-88cd1a201fc6	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	INDIVIDUALIZADO
d1a7b1f8-f780-4206-ad5e-abbc54a24176	0701090081	<span class="null">NULL</span>	SUBSTITUIÇÃO DO ENCAIXE INTERNO FLEXÍVEL PARA PRÓTESE TRANSTIBIAL EXOESQUELETICA / ENDOESQUELETICA.	d9a73cdf-75b6-4860-a4b7-287a43b940fc	3a5fe839-ea15-48a5-b187-67a95185becf	2	9999	9999	9999	0	650	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	fce3c94e-197a-4575-b79f-88cd1a201fc6	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	INDIVIDUALIZADO
65fb7921-9986-4059-861e-3f7181241aae	0702060011	<span class="null">NULL</span>	CATETER DUPLO J	d9a73cdf-75b6-4860-a4b7-287a43b940fc	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	2	9999	9999	9999	180	141.52	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	a055d785-9dbd-4177-be95-fc5111510fdd	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
352f374a-7c45-4890-aff5-108e1bf74618	0702110043	<span class="null">NULL</span>	SUBSTITUTO BIOLÓGICO DE PELE - MATRIZES DE REGENERAÇÃO DÉRMICA (POR CM2)	d9a73cdf-75b6-4860-a4b7-287a43b940fc	3a5fe839-ea15-48a5-b187-67a95185becf	250	9999	9999	9999	49.56	0	3b3961fd-d144-4a63-9e92-0ff6c75c67a2	<span class="null">NULL</span>		<span class="null">NULL</span>	9999	a055d785-9dbd-4177-be95-fc5111510fdd	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-11-21T03:27:00.661240+00:00	2021-11-21T03:27:00.661240+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
1abe12f4-a0a8-4a23-a117-c8ec43f680ce	0903010020	<span class="null">NULL</span>	OCI AVALIAÇÃO DIAGNÓSTICA EM ORTOPEDIA COM RECURSOS DE RADIOLOGIA E ULTRASSONOGRAFIA	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	1571	0	140	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	27d8f7e6-8ead-45d6-874e-5e31e559f43d	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.078605+00:00	2024-07-31T17:07:01.078605+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
8c054fa9-d33a-4431-a494-141a5fafb302	0903010038	<span class="null">NULL</span>	OCI AVALIAÇÃO DIAGNÓSTICA EM ORTOPEDIA COM RECURSOS DE RADIOLOGIA E TOMOGRAFIA COMPUTADORIZADA	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	1571	0	230	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	27d8f7e6-8ead-45d6-874e-5e31e559f43d	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.081209+00:00	2024-07-31T17:07:01.081209+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
0eafd3db-0bbc-4c96-bec1-49c74713dea8	0903010046	<span class="null">NULL</span>	OCI AVALIAÇÃO DIAGNÓSTICA EM ORTOPEDIA COM RECURSOS DE RADIOLOGIA E RESSONÂNCIA MAGNÉTICA	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	1571	0	360	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	27d8f7e6-8ead-45d6-874e-5e31e559f43d	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.083197+00:00	2024-07-31T17:07:01.083197+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
a84a6659-e808-4ff1-9aef-7f9fba8c3863	0904010015	<span class="null">NULL</span>	OCI AVALIAÇÃO INICIAL DIAGNÓSTICA DE DÉFICIT AUDITIVO	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	1571	0	100	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	7d8d4797-9847-4c6f-b10b-62f5b060c3fd	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.084903+00:00	2024-07-31T17:07:01.084903+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
05ad0fe7-c388-4567-9f67-fcc3b60a99e8	0904010023	<span class="null">NULL</span>	OCI PROGRESSÃO DA AVALIAÇÃO DIAGNÓSTICA DE DÉFICIT AUDITIVO	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	1571	0	150	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	7d8d4797-9847-4c6f-b10b-62f5b060c3fd	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.086539+00:00	2024-07-31T17:07:01.086539+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
193eba67-d6a2-4097-b02a-a78a1c0b2ec7	0904010031	<span class="null">NULL</span>	OCI AVALIAÇÃO DIAGNÓSTICA DE NASOFARINGE E DE OROFARINGE	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	1571	0	200	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	7d8d4797-9847-4c6f-b10b-62f5b060c3fd	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.088404+00:00	2024-07-31T17:07:01.088404+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>
51a9a00d-f157-4919-b3ff-3e73878aa940	0905010019	<span class="null">NULL</span>	OCI AVALIAÇÃO INICIAL EM OFTALMOLOGIA - 0 A 8 ANOS	d5af30b1-6024-42ac-89bf-bcdbaf446f4e	41022e5f-cb3d-4ff5-8ad3-e0e045b97beb	1	9999	0	107	0	200	91d6fdba-3d03-4ddf-9229-fa735ad610e3	c3319d30-ac0d-4e60-b106-5d3b543d6285	0400	<span class="null">NULL</span>	869999	e7aaba29-229d-4016-b2cc-ba22d35ed333	1	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-07-31T17:07:01.091041+00:00	2024-07-31T17:07:01.091041+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>