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
07c5feb6-e29d-439e-9c80-e2ef01c79d37	1086	PRIMEIRA CONSULTA ODONTOLOGICA PROGRAMÁTICA	0	1571	0301010153	202402	1	1	1	3	1	17	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
a889d497-aa62-4a39-8601-2f0398545e30	4059	PRÓTESE LABIAL IMPLANTO SUPORTADA	9999	9999	0701080167	202402	1	1	0	7	5	234	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
30a08243-e4f3-4236-8c31-0e9247bfc6a5	4348	PROTESE P/ ESOFAGO	9999	9999	0702050504	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
15430ced-3da2-460f-b9c7-bdd7675e4387	4057	PRÓTESE EXTENSA DA FACE (2/3 DA FACE)	9999	9999	0701080140	202402	1	1	0	7	5	234	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
9f6e80c9-b7fe-4d66-b164-3ef7f28467db	4054	PRÓTESE MANDIBULAR	12	1571	0701080116	202402	1	1	0	7	5	234	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
726149d4-1a8d-4322-8b32-7fe60f14cad5	3957	PROTESE EXOESQUELETICA PASSIVA PARA DESARTICULACAO DO PUNHO OU AMPUTACAO TRANSRADIAL	9999	9999	0701020393	202402	1	1	0	7	5	73	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
f3a3a1c8-ab01-4d7f-860e-f92e5b728891	3961	PROTESE FUNCIONAL ENDOESQUELETICA P/ AMPUTACAO TRANSUMERAL	9999	9999	0701020431	202402	1	1	0	7	5	73	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
5a35a867-d121-49b1-b04f-2a46d9f4c322	3963	PROTESE FUNCIONAL EXOESQUELETICA P/ DESARTICULACAO DE COTOVELO (PUNHO UNIVERSO).	9999	9999	0701020458	202402	1	1	0	7	5	73	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
619139ee-ee7f-4aa6-9384-a10192d9471a	3965	PRÓTESE FUNCIONAL EXOESQUELÉTICA TRANSRADIAL COM GANCHO DE DUPLA FORÇA.	9999	9999	0701020474	202402	1	1	0	7	5	73	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
752106ab-ef71-40af-bb50-b78da94ed22d	3966	PRÓTESE FUNCIONAL EXOESQUELÉTICA TRANSRADIAL COTO CURTO.	9999	9999	0701020482	202402	1	1	0	7	5	73	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
0240c3f9-491e-4c22-9075-a2c355e87780	4013	PRÓTESE OCULAR	9999	9999	0701040068	202402	1	1	0	7	5	153	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
96e6d62a-ccd2-4701-a267-0b7e11fbc9b8	4048	PRÓTESE FIXA EM PACIENTE COM ANOMALIA CRÂNIO E BUCOMAXILOFACIAL	180	1571	0701080043	202402	1	1	0	7	5	234	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
faa7c441-807e-46c4-b0eb-0f1f2ad4ab16	4049	PRÓTESE PARA GRANDE PERDA MAXILAR	9999	9999	0701080051	202402	1	1	0	7	5	234	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
7aba7ce9-11ec-4cc7-8955-9e976650a7ca	4050	PRÓTESE LABIAL	9999	9999	0701080060	202402	1	1	0	7	5	234	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
04403bc7-e434-470d-8f86-571de9d8a1fd	4051	PRÓTESE NASAL	9999	9999	0701080078	202402	1	1	0	7	5	234	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
d61073cd-0001-42c8-b897-ed320813a874	4052	PRÓTESE ÓCULO-PALPEBRAL	9999	9999	0701080086	202402	1	1	0	7	5	234	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
e0279d24-9fb6-4bab-8953-5d0a0a21f443	4055	PRÓTESE PARA GRANDES PERDAS MAXILARES	12	1571	0701080124	202402	1	1	0	7	5	234	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
dccb040b-f4fd-4fa8-b2bb-4218897ece4e	4058	PRÓTESE PARA GRANDE PERDA MAXILAR IMPLANTO SUPORTADA	9999	9999	0701080159	202402	1	1	0	7	5	234	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
819ce6e6-c954-4cba-9901-23fcdd2fdc4f	4218	PROTESE INTERFALANGEANA	9999	9999	0702031135	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
f50caa4c-4e88-4629-b8ff-0e02a15613c7	4221	PROTESE NAO CONVENCIONAL ARTICULADA DISTAL DE MEMBRO SUPERIOR	9999	9999	0702031160	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
a592ae28-b37f-4063-a585-b8920db04345	4222	PROTESE NAO CONVENCIONAL ARTICULADA PROXIMAL DE MEMBRO INFERIOR	9999	9999	0702031178	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
e49b9924-3211-478d-9e6a-79de6f0cb2ee	4223	PROTESE NAO CONVENCIONAL ARTICULADA PROXIMAL DE MEMBRO SUPERIOR	9999	9999	0702031186	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
cec417df-bb38-4e18-8379-694eb967a757	4225	PROTESE NAO CONVENCIONAL DIAFISARIA	9999	9999	0702031208	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
befaad47-997c-4ccd-91c3-2004a46cae53	4226	PROTESE NAO CONVENCIONAL EXTENSIVEL	9999	9999	0702031216	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
785edc4e-7fcd-4f6c-ba47-dfa7bb1fe0a0	4367	PROTESE GLUTEA DE SILICONE (PAR)	9999	9999	0702080020	202402	1	1	0	7	12	245	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
2cd1c910-763a-4999-8b5d-6ef94e5349a6	4368	PROTESE MAMARIA DE SILICONE	9999	9999	0702080039	202402	0	1	0	7	12	245	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
90294a30-ec36-4fe1-b869-c33a6d3f5408	4370	PRÓTESE P/ IMPLANTE COCLEAR MULTICANAL	9999	9999	0702090034	202402	1	1	0	7	12	252	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
a13a5745-08e7-4a35-bb6b-e45c9b0f06f8	4224	PROTESE NAO CONVENCIONAL BI-ARTICULADA TOTAL	9999	9999	0702031194	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
a4dc1fe1-a92f-408c-9361-215c29f6a3c2	4227	PROTESE PARCIAL DE QUADRIL CIMENTADA MONOBLOCO (TIPO THOMPSON)	9999	9999	0702031224	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
6a53470e-2787-4773-9399-ddbcb6d1e21c	3959	PRÓTESE EXOESQUELÉTICA TRANSTIBIAL COM COXAL OU MANGUITO DE COXA	9999	9999	0701020415	202402	1	1	0	7	5	73	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
de8f32a1-bbdc-4a56-b085-e39c95ee3a9c	3960	PRÓTESE EXOESQUELÉTICA TRANSTIBIAL TIPO PTB-PTS-KBM	9999	9999	0701020423	202402	1	1	0	7	5	73	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
6a6ed115-7136-4252-acf0-3b505d077f01	3962	PRÓTESE FUNCIONAL EXOESQUELÉTICA PARA DESARTICULAÇÃO DE COTOVELO (PUNHO DE ROSCA)	9999	9999	0701020440	202402	1	1	0	7	5	73	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
942ea7da-a368-4fb1-8b87-aa8514ef4e84	4220	PROTESE NAO CONVENCIONAL ARTICULADA DISTAL DE MEMBRO INFERIOR	9999	9999	0702031151	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
1b1e5e30-8834-4143-ab04-245f99e9659d	4219	PROTESE METACARPO-FALANGEANA	9999	9999	0702031143	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
2e122642-2733-4291-a22c-5a51ca0b946f	4674	PRÓTESE PARA IMPLANTE COCLEAR MULTICANAL	9999	9999	0702090093	202402	1	1	0	7	12	252	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
29684da6-4342-4ada-a4db-5471b5a90df1	4039	PROTESE PARCIAL MAXILAR REMOVIVEL	180	1571	0701070102	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
30f1100d-6ea4-486f-843e-024dcdba3de2	4038	PROTESE PARCIAL MANDIBULAR REMOVIVEL	180	1571	0701070099	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
980dfc0c-aaf2-45a3-bcfc-61ae0225e44a	432	PROVA DE DILUICAO (URINA)	0	1571	0202050327	202402	1	1	2	2	9	190	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
b10650b4-485c-4446-bb4a-6c50257e51d1	1032	PROVA DE TOXIGENICIDADE P/ BACILO DIFTERICO (IN VITRO)	0	1571	0213010496	202402	1	1	2	2	52	15	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
25dc39dc-b55c-469c-a452-7c3e58a0004e	369	PROVAS IMUNO-ALERGICAS BACTERIANAS	0	1571	0202031063	202402	1	1	2	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
8f1dec07-13fc-4703-9a8c-a670176b4112	1695	PULPOTOMIA DENTÁRIA	0	1571	0307020070	202402	1	1	1	3	36	78	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
0476b369-50a4-4d93-8ffc-1d7484f99fb5	1260	PULSOTERAPIA I (POR APLICACAO)	0	1571	0303020016	202402	1	1	2	3	21	61	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
3fd716a9-38b6-4fab-bd0a-4bb68c753e72	567	PROVA DO LATEX P/ PESQUISA DO FATOR REUMATOIDE	0	1571	0202090302	202402	1	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
ec9726ee-c6c5-424c-bfe2-5019fd6fcebc	963	PROVA FARMACODINAMICA	0	1571	0211080071	202402	1	1	2	2	49	235	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.281000+00:00	2021-05-25T19:39:57.281000+00:00
25b0a300-9fd3-4c85-ba56-385c1e1cc09f	4043	PROTESES CORONARIAS / INTRA-RADICULARES FIXAS / ADESIVAS (POR ELEMENTO)	9999	9999	0701070145	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	0	OPME	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
a42e26a4-0369-462c-9487-e82e7657fced	962	PROVA DE FUNCAO PULMONAR SIMPLES	0	1571	0211080063	202402	1	1	2	2	49	235	1	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.280000+00:00	2021-05-25T19:39:57.280000+00:00
6d2b60be-8362-4034-9454-86b3d0edd78f	4040	PROTESE TEMPORARIA	144	1571	0701070110	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.280000+00:00	2021-05-25T19:39:57.280000+00:00
65e69a54-1d82-4d7f-996d-9832fdf94381	3433	PROVAS CRUZADAS EM DOADOR FALECIDO (CROSS MATCH)	0	1571	0501040064	202402	1	1	3	5	7	147	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.281000+00:00	2021-05-25T19:39:57.281000+00:00
f1673875-0009-4a9a-9c70-0640c057e37b	3971	PRÓTESE PASSIVA ENDOESQUELÉTICA PARA DESARTICULAÇÃO DE OMBRO E ESCAPULECTOMIA PARCIAL OU TOTAL	9999	9999	0701020539	202402	1	1	0	7	5	73	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
e261e8e7-9a22-4ecb-9624-f45860a3eb7a	3972	PROTESE PASSIVA ENDOESQUELETICA TRANSUMERAL	9999	9999	0701020547	202402	1	1	0	7	5	73	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