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	esus_id	ativo	data_criacao	data_alteracao
cbed8cbf-8234-495a-a8ff-ef88525dbaa2	4337	PARAFUSO DE TITÂNIO ASSOCIÁVEL, A HASTE TIPO PEDICULAR, POLI AXIAL	9999	9999	0702050393	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
e17c5103-24a0-407d-95ce-362801b68180	1947	PARACENTESE DO TIMPANO	0	1571	0404010253	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
23ce5d90-1049-4c3d-8d6f-671762858421	2096	PAN-FOTOCOAGULAÇÃO DE RETINA A LASER	0	1571	0405030193	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
d06eb13b-64c2-45b8-bf5e-655095c67a04	2137	PARACENTESE DE CAMARA ANTERIOR	0	1571	0405050208	202402	1	1	2	4	29	185	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
f9ff676f-2043-4063-858b-69d83d919981	3328	PANCREATECTOMIA PARCIAL EM ONCOLOGIA	0	1571	0416040110	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
8d96d821-cc38-406c-8827-b680007840cd	2500	PANCREATECTOMIA VIDEOLAPAROSCOPICA	0	1571	0407030190	202402	1	1	2	4	38	128	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
59e6f2f3-01b9-441d-83a3-5c20f5083763	2501	PANCREATO-DUODENECTOMIA	240	1571	0407030204	202402	1	1	2	4	38	128	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
a077f027-51cd-4a99-845b-8f7d3c2dc61d	2502	PANCREATO-ENTEROSTOMIA	240	1571	0407030212	202402	1	1	2	4	38	128	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
a0e0e7ff-41df-493a-aa57-40cb00ebbd7f	2524	PARACENTESE ABDOMINAL	0	1571	0407040196	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
f9fe84b8-c3e1-44bc-8376-8be839b97072	3680	PAMIDRONATO 90 MG INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604160038	202402	1	1	3	6	26	295	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
f750eef2-df61-409b-a01c-cb9ae96867a5	1794	PARATIREOIDECTOMIA	0	1571	0402010027	202402	1	1	2	4	15	28	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
e7ba450a-04ed-43d1-bc6f-81c8dc3a7b8a	3851	PANCREATINA 10.000 UI (POR CAPSULA)	0	1571	0604580010	202402	1	1	3	6	26	361	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
6675e04c-5535-4769-8264-4603881a0e6e	3852	PANCREATINA 25000 UI (POR CAPSULA)	0	1571	0604580029	202402	1	1	3	6	26	361	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
54901a1c-7f73-4d95-8e94-d3fd505c6c8f	4168	PARAFUSO CANULADO 3,5 MM	9999	9999	0702030627	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.278000+00:00
a1c3d9eb-0ad8-4410-be28-c59389f1d9ed	4169	PARAFUSO CANULADO 4,5 MM	9999	9999	0702030635	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
cf4980cf-b316-4c70-b3ca-a9ea258b25f7	4170	PARAFUSO CANULADO 7,0 MM	9999	9999	0702030643	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
1c06a7f9-9449-4d52-86c8-ea2e6fd4ff81	4335	PARAFUSO ASSOCIÁVEL A PLACA TÓRACO-LOMBO-SACRA TIPO PEDICULAR MONO-AXIAL.	9999	9999	0702050377	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
4616b8ef-5a4d-47b5-88e4-4578dea85cc7	4338	PARAFUSO DE TITÂNIO ASSOCIÁVEL A PLACA CERVICAL	9999	9999	0702050407	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
89b9a84a-98cd-42c1-b50b-461a666203eb	4339	PARAFUSOS ASSOCIÁVEIS A PLACAS TÓRACO-LOMBO-SACRAIS DE TITÂNIO	9999	9999	0702050415	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
4333daf0-b927-4614-b4de-5a149e8ddeca	3290	PAROTIDECTOMIA PARCIAL EM ONCOLOGIA	144	1571	0416030017	202402	1	1	3	4	57	143	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
a93d7fa3-6b1d-4c8b-aab7-2e752d36aea7	3854	PANCRELIPASE 12.000 UI (POR CAPSULA)	0	1571	0604580045	202402	1	1	3	6	26	361	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
34a57c65-8916-4f17-8521-34017cdb86b7	717	PAQUIMETRIA ULTRASSÔNICA	0	1571	0205020020	202402	1	1	2	2	30	98	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
9c9b258c-9f00-424b-bdca-b1679ca8e0e9	4175	PARAFUSO CORTICAL 3,5 MM	9999	9999	0702030694	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
09495f19-288f-4daf-a9e6-d1d6da126066	4237	PARAFUSO BLOQUEADO	9999	9999	0702031321	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
717beabd-1261-4942-8fdb-32d67379e42c	4178	PARAFUSO ESPONJOSO 4,0 MM	9999	9999	0702030724	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
14bed683-02b4-4679-8883-39d5182ed4b7	3303	PELVIGLOSSOMANDIBULECTOMIA EM ONCOLOGIA	228	1571	0416030190	202402	1	1	3	4	57	143	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
42240d4b-e276-43de-93c1-4882def36f01	3304	PAROTIDECTOMIA TOTAL AMPLIADA EM ONCOLOGIA	144	1571	0416030203	202402	1	1	3	4	57	143	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
403bf4c1-275b-43fb-b597-5131d7aa33a2	3513	PARTICIPACAO DE EQUIPE NEFROLOGICA EM TRANSPLANTE SIMULTANEO DE PANCREAS E RIM	0	1571	0505020033	202402	1	1	3	5	31	68	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
449812d0-e46b-41ab-aac6-c4df01bb721a	3100	PARTO CESARIANO EM GESTACAO DE ALTO RISCO	108	731	0411010026	202402	0	1	2	4	48	37	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
2f41aff0-1b15-4c19-8072-3e4a84a8c2ca	3101	PARTO CESARIANO	108	731	0411010034	202402	0	1	2	4	48	37	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
65d9932b-70f8-4ad4-b3b7-5f18a0320e60	1751	PERSUFLACAO P/ DESOBSTRUCAO TUBARIA (POR TRATAMENTO COMPLETO)	228	1571	0309030153	202402	0	1	2	3	43	123	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
c0cb8a96-3d44-40e2-bc7b-e61d689e6c97	2227	PERICARDIECTOMIA	0	1571	0406010757	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
7c8d1816-46a8-4545-8e1f-5f28dcb493df	2228	PERICARDIECTOMIA PARCIAL	0	1571	0406010765	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
5dd81afb-66be-44aa-9ef6-47fd3a124030	2229	PERICARDIOCENTESE	0	1571	0406010773	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
60e65c51-9ab7-423f-8f31-2642c63f12dc	2525	PERITONIOSTOMIA C/ TELA INORGANICA	0	1571	0407040200	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
7f4433d4-da75-49d1-b533-0336d9c33333	1762	PARTO NORMAL EM GESTACAO DE ALTO RISCO	108	731	0310010047	202402	0	1	2	3	46	26	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
5a91a5d9-0075-4fe1-9e67-dd42e2786751	299	PESQUISA DE ANTICORPOS ANTI-SS-A (RO)	0	1571	0202030350	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
4684dab3-86aa-4b01-8056-7b78cffbd35f	3847	PENICILAMINA 250 MG (POR CAPSULA)	0	1571	0604560010	202402	1	1	3	6	26	359	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
669701d0-1450-434a-b58a-69ce1ba5b132	4290	PATCH ORGANICO (50 CM2)	9999	9999	0702040479	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
f2a1d1ca-864b-442b-94da-cc438a57483a	3102	PARTO CESARIANO C/ LAQUEADURA TUBARIA	252	731	0411010042	202402	0	1	2	4	48	37	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
9aa6721a-f155-48c4-b71c-e2f478110d3a	3511	PARTICIPACAO DE EQUIPE NEFROLOGICA EM TRANSPLANTE RENAL DE DOADOR FALECIDO	0	1571	0505020017	202402	1	1	3	5	31	68	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
2b1aa4c9-6257-44ac-b3f0-d818692bfd14	3512	PARTICIPACAO DE EQUIPE NEFROLOGICA EM TRANSPLANTE RENAL DE DOADOR VIVO	0	1571	0505020025	202402	1	1	3	5	31	68	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
68f4e102-91b5-43c8-b07f-f24354a5e61c	4186	PLACA C/ PARAFUSO DESLIZANTE DE 135 OU 150 GRAUS	9999	9999	0702030813	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
05697218-0fc7-456c-889c-ffbef33bccc8	4287	PATCH INORGANICO (20 CM2)	9999	9999	0702040444	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
5ce7c45b-ae24-43e8-b656-b397b3c901fd	4288	PATCH INORGANICO (50 CM2)	9999	9999	0702040452	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
ac0febed-1e05-4f30-8f61-a230dfecadf3	4289	PATCH ORGANICO (20 CM2)	9999	9999	0702040460	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
dbd489bc-6640-489e-a41d-cbca1c6eb4c8	970	PERFIL DE PRESSAO URETRAL	0	1571	0211090069	202402	1	1	2	2	49	251	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
04a2247f-7ee9-457b-b48b-e16a70a55d38	879	PERSUFLACAO TUBARIA (DIAGNOSTICA)	108	731	0211040053	202402	0	1	2	2	49	171	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
25a2259a-1eb5-4394-940d-147e053ec019	298	PESQUISA DE ANTICORPOS ANTI-SM	0	1571	0202030342	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00
5cbf985c-e231-471e-9442-e21984cceedc	531	PEQUISA DE PNEUMOCYSTI CARINI	0	1571	0202080170	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.278000+00:00	2021-05-25T19:39:57.278000+00:00