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
1d5ff613-3521-415a-a0c7-a57b82ecdadf	3016	PLASTICA DE FREIO BALANO-PREPUCIAL	0	1571	0409050067	202402	1	0	2	4	42	188	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
8700f1e7-93a9-4fc3-9155-e51fd4f07522	3147	PLUMBAGEM EXTRAFASCIAL	0	1571	0412040069	202402	1	1	2	4	50	165	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
0d8eb8ae-1fd6-4da8-a87f-441003b5583e	2230	PLASTICA / TROCA DE VALVULA TRICUSPIDE (ANOMALIA DE EBSTEIN)	0	47	0406010781	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
8fb6301d-2170-4984-bf12-21d5723a1d37	2231	PLASTICA DE LOJA DE GERADOR DE SISTEMA DE ESTIMULACAO CARDIACA ARTIFICIAL	216	1571	0406010790	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
dace5bed-e2ab-417b-bc87-5acaf2c335c3	2232	PLASTICA VALVAR	0	1571	0406010803	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
684217fc-4711-4399-a264-a47daf91ab4f	2233	PLASTICA VALVAR C/ REVASCULARIZACAO MIOCARDICA	216	1571	0406010811	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
771c628e-777e-424e-adcd-32d91e919ed6	2304	PLASTIA ARTERIAL C/ REMENDO (QUALQUER TECNICA)	0	1571	0406020302	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
a3e1a3c2-b351-403e-904a-4a23e9808d03	2464	PLASTICA ANAL EXTERNA / ESFINCTEROPLASTIA ANAL	0	1571	0407020322	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
1c4f0657-ac16-4742-818f-61c177fe89e5	1506	PLANEJAMENTO TRIDIMENSIONAL (POR TRATAMENTO).	0	1571	0304010316	202402	1	1	3	3	27	20	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
1495cc5c-e8c3-4d4a-9e6d-b780da01b6b3	3003	PLASTICA DA BOLSA ESCROTAL	0	1571	0409040177	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
9da34e62-cd9b-47e7-8d35-fd2f4dd2f2dc	3017	PLASTICA TOTAL DO PENIS	0	1571	0409050075	202402	1	0	2	4	42	188	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
aa3f25b5-6dec-4081-b7a3-8f8eb70d805d	4630	PLASTICA MAMARIA RECONSTRUTIVA BILATERAL INCLUINDO PROTESE MAMARIA DE SILICONE BILATERAL NO PROCESSO TRANSEXUALIZADOR	252	911	0410010200	202402	1	0	2	4	45	36	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
45c2d83b-6722-44fe-bc09-286df84c7f79	3134	PLEURECTOMIA	0	1571	0412030055	202402	1	1	3	4	50	131	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
a239bf1e-ba9f-4fc8-9fb4-f94d2bd96e84	3135	PLEUROTOMIA	0	1571	0412030063	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
117e1b87-0c05-46da-9cfe-2e5de53f6e4b	3138	PLEUROSTOMIA	0	1571	0412030098	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
423217f5-2624-4b4d-9f99-006407e8437b	4214	PLACA SEMITUBULAR 4,5 MM (INCLUI PARAFUSOS)	9999	9999	0702031097	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
a5efa837-353a-4cbc-b7d7-e3d0668546d9	4347	PLACAS TORACO-LOMBO-SACRAL ASSOCIADAS A PARAFUSOS PEDICULARES DE TITANIO	9999	9999	0702050490	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.279000+00:00	2021-05-25T19:39:57.279000+00:00
9ec1b373-4123-46bb-b5e8-348832817138	4382	PLACA TERMOMOLDAVEL CERVICAL	9999	9999	0702110019	202402	1	1	0	7	12	271	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
b9ab2221-37f8-4ecd-b2d1-818d0202a8d5	4383	PLACA TERMOMOLDAVEL DE MEMBRO INFERIOR	9999	9999	0702110027	202402	1	1	0	7	12	271	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
3ac0947f-6776-4a35-bb2e-e8e8947a2592	4384	PLACA TERMOMOLDAVEL DE MEMBRO SUPERIOR	9999	9999	0702110035	202402	1	1	0	7	12	271	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
7ded8011-184b-4828-89a8-a83aa8d81db4	614	PLANIGRAFIA DE LARINGE	0	1571	0204010020	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
696658fd-167e-4374-86ba-fd567913fd27	634	PLANIGRAFIA DE COLUNA VERTEBRAL	0	1571	0204020026	202402	1	1	2	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
66025bcd-2af2-4954-9624-6788c9f4c9ef	698	PLANIGRAFIA DE OSSO EM 2 PLANOS	0	1571	0204060052	202402	1	1	2	2	25	207	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
0d0d28ef-d828-44c7-b360-56e798f635e6	697	PLANIGRAFIA DE OSSO - SUBSIDIARIA A OUTROS EXAMES (POR PLANO)	0	1571	0204060044	202402	1	1	2	2	25	207	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
a07af48e-0a69-41a1-a1b1-2a66369fdef7	2142	RETIRADA DE CORPO ESTRANHO DA CORNEA	0	1571	0405050259	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.283000+00:00	2026-07-24T13:49:52.598000+00:00
d3619faa-8aeb-46e3-adad-eb6edbbb4737	4215	PLACAS TÓRACO-LOMBO-SACRAL ASSOCIADA A PARAFUSOS INTRA-SOMÁTICOS DE TITÂNIO	9999	9999	0702031100	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
d06b4ccd-d1ea-4534-9e60-616bebc527eb	684	PLANIGRAFIA DE RIM C/ CONTRASTE	0	1571	0204050090	202402	1	1	2	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
7b8c6b58-291d-49ba-bf3b-d059cf23d851	685	PLANIGRAFIA DE RIM S/ CONTRASTE	0	1571	0204050103	202402	1	1	2	2	25	191	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
513ed7ab-01fd-4e3a-b588-9cafec160398	4037	PLANO INCLINADO	48	1571	0701070080	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.279000+00:00	2021-05-25T19:39:57.279000+00:00
6953de4d-d230-4b43-bf95-060bc2d0a1e0	1085	PRIMEIRA CONSULTA DE PEDIATRIA AO RECEM-NASCIDO	9999	9999	0301010145	202402	1	1	2	3	1	17	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
c909260c-4a8e-4953-92cf-3abff1fc20d9	3626	PRAMIPEXOL 0,25 MG (POR COMPRIMIDO)	0	1571	0604030053	202402	1	1	3	6	26	117	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
05565e5e-ec6a-432b-a9b7-2b08f0076391	3018	POSTECTOMIA	0	1571	0409050083	202402	1	0	2	4	42	188	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
100e673b-0340-4527-974a-917b090cb5ec	3186	PREENCHIMENTO FACIAL COM POLIMETILMETACRILATO EM PACIENTE C/ LIPOATROFIA FACIAL CAUSADOS PELA REDUÇÃO DOS COXIS GORDUROSOS DAS REGIÕES MALAR, TEMPORAL E PRÉ-AURICULAR	144	911	0413030040	202402	1	1	3	4	53	132	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
32e6899b-9704-47e9-8ec6-14b2c95be6c3	3187	PREENCHIMENTO FACIAL C/ TECIDO GORDUROSO EM PACIENTE C/ LIPOATROFIA DE FACE DECORRENTE DO USO DE ANTI-RETROVIRAIS	144	911	0413030059	202402	1	1	3	4	53	132	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
993aa15f-d128-4291-b1db-f5ff038b8d92	3199	PREPARO DE RETALHO	0	1571	0413040097	202402	1	1	2	4	53	144	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
56e63cc6-6e8a-4d37-95a0-6c71b524e3d4	3200	PREPARO DE TUBO PEDICULADO	0	1571	0413040100	202402	1	1	2	4	53	144	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
5f7663be-8147-41f1-a379-9cb9dfee1f1f	3625	PRAMIPEXOL 0,125 MG (POR COMPRIMIDO)	0	1571	0604030045	202402	1	1	3	6	26	117	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
3f37aca7-578d-48eb-98fb-36cd483fbdbd	3627	PRAMIPEXOL 1 MG (POR COMPRIMIDO)	0	1571	0604030061	202402	1	1	3	6	26	117	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
a9742d92-7357-4a11-967f-19eba66369c0	891	POTENCIAL EVOCADO AUDITIVO	0	1571	0211050113	202402	1	1	2	2	49	193	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
787803f2-5ae0-43a6-b37b-56788593f36b	1587	POLIQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO EM ESTÁDIO III (PRÉVIA)	228	1571	0304040185	202402	1	1	3	3	27	155	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
f86302b7-a76f-4e0a-9e79-ce642a9d4e97	1604	POLIQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO EM ESTÁDIO I (ADJUVANTE)	228	1571	0304050261	202402	1	1	3	3	27	182	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
f1b13fc5-7be5-49ee-9b6f-0c08e0a05f5b	1605	POLIQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO EM ESTÁDIO II (ADJUVANTE)	228	1571	0304050270	202402	1	1	3	3	27	182	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
025b3a4f-8938-4e31-a88e-db3407b6de91	1606	POLIQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO EM ESTÁDIO III (ADJUVANTE)	228	1571	0304050288	202402	1	1	3	3	27	182	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
9ad57ce5-dfbf-4631-b603-dc3d8eacb2aa	4216	PORCAS DE TITÂNIO P/ CIRURGIA DE COLUNA	9999	9999	0702031119	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
4449a9e4-ad97-44dc-b7e6-aa227ae4dd4e	2305	PONTE AXILO-BIFEMURAL	0	1571	0406020310	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
a3968ece-298f-475f-9557-085eafdfc82d	2307	PONTE DE RAMOS DOS TRONCOS SUPRA-AORTICOS	0	1571	0406020337	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
ba75d5e9-b555-4722-b16a-81e5f268ce58	2308	PONTE FEMORO-FEMURAL CRUZADA	0	1571	0406020345	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
46c10d97-bb6f-4f87-bb65-9fe6d643a786	2309	PONTE-TROMBOENDARTERECTOMIA AORTO-FEMURAL	0	1571	0406020353	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
533e7e78-cb6e-4317-a617-6d878fc4aed1	2310	PONTE-TROMBOENDARTERECTOMIA AORTO-ILIACA	0	1571	0406020361	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
19f48dfe-139e-4e79-9101-5899de740939	2311	PONTE-TROMBOENDARTERECTOMIA DE CAROTIDA	0	1571	0406020370	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00