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
12e52ed0-612a-4f52-9dab-79e978ae5178	4801	RADIOGRAFIA INTERPROXIMAL (BITE WING)	0	1571	0204010217	202402	1	1	<span class="null">NULL</span>	2	25	6	<span class="null">NULL</span>	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:40.155173+00:00	2024-09-18T00:29:40.155173+00:00
2d82cadf-c2a8-4e78-9b65-ba450f355b61	4963	PROVAS CRUZADAS EM DOADORES DE ÓRGÃOS E DE MEDULA ÓSSEA (APARENTADO NÃO IDÊNTICO)	216	1091	0501040102	202402	1	1	<span class="null">NULL</span>	5	7	147	<span class="null">NULL</span>	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2024-09-18T00:29:40.155173+00:00	2024-09-18T00:29:40.155173+00:00
2bb3d5a4-b7c8-4e70-8ca6-7b278fd4b821	3445	SOROLOGIA DE POSSIVEL DOADOR DE ORGAO OU TECIDO EXCETO CORNEA	0	1091	0501070028	202402	1	1	2	5	7	220	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
faa73fab-2c7a-44d6-88fc-75890ab0bcb9	4516	SOROLOGIA PARA HIV	0	1571	ABEX018	202402	1	1	2	2	9	134	1	294	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
cc4f60a1-9d6c-40a0-8fa2-7160e3cc5e5c	3616	SULFASSALAZINA 500 MG (POR COMPRIMIDO)	0	1571	0604010095	202402	1	1	3	6	26	54	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
e41c5472-0675-44fe-ac31-c13ab4deccde	4663	SUBSTITUIÇÃO/TROCA DO IMÃ DA ANTENA DA PRÓTESE DE IMPLANTE COCLEAR	9999	9999	0701090189	202402	1	1	0	7	5	255	1	<span class="null">NULL</span>	0	<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.284000+00:00	2021-05-25T19:39:57.284000+00:00
7a21b146-38c3-4f75-adcb-f701e7b30211	1201	SONDAGEM GASTRICA	0	1571	0301100179	202402	1	1	1	3	1	263	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
f9cacde9-6bfb-4ced-ba5a-e0285dc82c79	3577	TENECTEPLASE - TNK 40 MG INJETÁVEL (POR FRASCO AMPOLA)	0	1571	0603050085	202402	1	1	2	6	19	178	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
41a82615-caff-491d-9b1b-9907451a5ef4	4635	TENECTEPLASE 40 MG INJETÁVEL (POR FRASCO AMPOLA) DE USO NAS URGÊNCIAS PRÉ-HOSPITALARES	0	1571	0603050115	202402	1	1	2	6	19	178	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
aac1b50a-75a8-4c53-8d88-ccbb523d8a73	3604	TACROLIMO 0,5 MG P/TRANSPLANTE (FRASCO-AMPOLA)	0	1571	0603080197	202402	1	1	3	6	19	243	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
edb5093b-1aaa-4940-9b96-41a0de3bee73	4782	TERIFLUNOMIDA 14 MG (POR COMPRIMIDO)	216	1571	0604540043	202402	1	1	3	6	26	357	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
fc4d441e-df0d-4fc7-a188-e5f2e0f0ac25	3869	TELAPREVIR 375 MG (POR COMPRIMIDO)	216	1571	0604640021	202402	1	1	3	6	26	367	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
813ea5b6-81de-4ece-994a-01ca1ab9ba42	1956	TAMPONAMENTO NASAL ANTERIOR E/OU POSTERIOR	0	1571	0404010342	202402	1	1	2	4	24	30	0	<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.284000+00:00	2021-05-25T19:39:57.284000+00:00
e2bf02fb-e60c-4a70-8101-696ce325302e	2074	SUTURA DE PALPEBRAS	0	1571	0405010176	202402	1	1	2	4	29	31	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
c06847ba-af9d-4592-94a5-8da755167849	2095	TERMOTERAPIA TRANSPUPILAR	0	1571	0405030185	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
9dbde998-125c-40cc-a29f-4e3048e2c56d	2881	TENOMIOTOMIA / DESINSERÇÃO	0	1571	0408060468	202402	1	1	2	4	41	214	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
c52e16e6-4b2f-4d52-8033-6b6a7237dc23	2882	TENOPLASTIA OU ENXERTO DE TENDÃO UNICO	0	1571	0408060476	202402	1	1	2	4	41	214	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
f1d91cfd-18a8-402c-bb69-c476db7794b6	2883	TENORRAFIA ÚNICA EM TÚNEL OSTEO-FIBROSO	0	1571	0408060484	202402	1	1	2	4	41	214	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
2e8d0826-bbfb-4540-8e0c-3e32642cdcb3	2421	TAMPONAMENTO DE LESOES HEMORRAGICAS DO APARELHO DIGESTIVO	0	1571	0407010262	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
5040a35b-57c8-4e22-8d26-3df9ab1d4b4d	2584	TENOSINOVECTOMIA EM MEMBRO SUPERIOR	0	1571	0408020300	202402	1	1	2	4	41	88	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
a44a415d-6dab-47d6-9d5f-93da86282b0d	2780	TENOSINOVECTOMIA EM MEMBRO INFERIOR	0	1571	0408050373	202402	1	1	2	4	41	187	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
ab5a4c33-7008-4066-a75e-30da05c8c6e4	1113	TERAPIA EM Grupo	9999	9999	0301040036	202402	1	1	2	3	1	172	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
7865d38e-f3c6-4e3f-b0fc-86646ee7c8b0	3768	TACROLIMO 1 MG (POR CAPSULA)	0	1571	0604340060	202402	1	1	3	6	26	335	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
fc7e7c8b-f683-4eb6-8e83-f72c6afb34df	2878	TENODESE	0	1571	0408060433	202402	1	1	2	4	41	214	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
aa24a150-aef4-4cea-b582-b12b31030184	3769	TACROLIMO 5 MG (POR CAPSULA)	0	1571	0604340079	202402	1	1	3	6	26	335	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
e78eeaab-010c-4a9c-836e-7ca7e634285d	2880	TENOMIORRAFIA	0	1571	0408060450	202402	1	1	2	4	41	214	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
f0d93566-cb65-4263-8e0b-1d3885e84c70	3578	TENECTEPLASE-TNK 50 MG INJETÁVEL ( POR FRASCO AMPOLA)	0	1571	0603050093	202402	1	1	2	6	19	178	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
6392a6c9-2fec-404d-ad53-2d1d8d89536b	4636	TENECTEPLASE 50 MG INJETÁVEL (POR FRASCO AMPOLA) DE USO NAS URGÊNCIAS PRÉ-HOSPITALARES	0	1571	0603050123	202402	1	1	2	6	19	178	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
d753c41a-4a66-45d6-be60-798af8a5551e	4649	TÁBUA (PRANCHA) PARA TRANSFERÊNCIA	144	1571	0701020601	202402	1	1	0	7	5	73	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
c7f00ac3-7f55-47b5-988d-ba6c5726a866	4233	TELA DE RECONSTRUCAO ACETABULAR	9999	9999	0702031283	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
c6af68ff-2ed0-45ee-a9a2-f3fa4925d273	4234	TELA DE RECONSTRUCAO FEMORAL	9999	9999	0702031291	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
d87cfb0f-4705-48a9-824b-4746b5c4dc5b	4352	TELA INORGANICA DE POLIPROPILENO C/ SISTEMA DUPLO	9999	9999	0702050547	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
d635c9f6-17d5-4ba9-8581-20c6427e665d	4353	TELA INORGANICA DE POLIPROPILENO GRANDE (ACIMA DE 401 CM2)	9999	9999	0702050555	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
b2d477a8-bd7a-43ff-8b38-91827f3994d1	4354	TELA INORGANICA DE POLIPROPILENO MEDIA (101 A 400 CM2)	9999	9999	0702050563	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
f5a037f7-cda6-4575-a41e-15e1ecb09ee0	4355	TELA INORGANICA DE POLIPROPILENO PEQUENA (ATE 100 CM2)	9999	9999	0702050571	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
cf4f6e48-6bcf-4b88-981b-e9a9aab3b8e1	4604	TERAPIA HORMONAL NO PROCESSO TRANSEXUALIZADOR	216	911	0303030097	202402	1	1	2	3	21	111	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
54d5b494-3d2f-4fe8-88e8-21562710a5a3	632	TELERADIOGRAFIA COM TRACADOS E SEM TRACADOS	0	1571	0204010209	202402	1	1	2	2	25	6	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
74932470-be2a-4eb5-910a-98d3a1271e0f	4676	TERAPIA COMUNITÁRIA	0	1571	0101050020	202402	1	1	1	1	4	382	1	<span class="null">NULL</span>	1	GRUPO	0	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
bf888e52-2c12-4b29-9670-836782ba8432	4453	SUTURA SIMPLES	0	1571	ABPG019	202402	1	1	1	4	8	27	1	1769	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
398301ea-1a26-4399-8ce4-a14d74cf2dc0	4455	TAMPONAMENTO DE EPISTAXE	0	1571	ABPG021	202402	1	1	2	4	24	30	1	1956	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
f9da985a-bc19-4692-b36e-4c0ac9dcf909	1114	TERAPIA INDIVIDUAL	0	1571	0301040044	202402	1	1	2	3	1	172	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
a628a314-95bd-4272-b204-044415bb196f	1126	TERAPIA DE REIDRATAÇÃO PARENTERAL	0	1571	0301050120	202402	1	1	1	3	1	194	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
d898c0fe-adea-4c64-a2f5-f9510c3a7d5c	1149	TERAPIA FONOAUDIOLÓGICA INDIVIDUAL	0	1571	0301070113	202402	1	1	2	3	1	224	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	0	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
e4ebc014-670b-4d6f-990c-1620ddf21df9	1202	TERAPIA DE REIDRATACAO ORAL	0	1571	0301100187	202402	1	1	1	3	1	263	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
7f810bb1-6b3b-48c4-947a-a07829681db3	3576	TENECTEPLASE- TNK 30 MG INJETÁVEL ( POR FRASCO AMPOLA)	0	1571	0603050077	202402	1	1	2	6	19	178	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
c2c2f0d3-28ca-4ba8-9f3a-2842cdf7862e	3818	TENOFOVIR 300 MG (POR COMPRIMIDO)	156	1571	0604460058	202402	1	1	3	6	26	349	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.284000+00:00	2021-05-25T19:39:57.284000+00:00
7acc46a5-8e0e-4542-9410-e67cd68e461d	1054	TESTE DOT-ELISA P/ IDENTIFICACAO DA PASTEURELLA PESTIS (PESTE BUBONICA)	0	1571	0213010712	202402	1	1	2	2	52	15	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.285000+00:00	2021-05-25T19:39:57.285000+00:00
ef848bc9-f49b-474f-b811-1ef09a6a1981	1041	TESTE DE ELISA IGG P/ IDENTIFICACAO DO VIRUS DO SARAMPO	0	1571	0213010585	202402	1	1	2	2	52	15	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
223f06e0-292f-476e-a75a-d324f0c2802f	4521	TESTE DE GRAVIDEZ	0	1571	ABEX023	202402	1	1	2	2	9	210	1	453	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00
d9b92279-4f56-473e-b287-114608ec713f	894	TESTE DE WADA	0	1571	0211050148	202402	1	1	3	2	49	193	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.284000+00:00	2021-05-25T19:39:57.284000+00:00