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
95929159-7032-4466-81b0-ff4fdd2fd05a	3418	FORNECIMENTO, ACONDICIONAMENTO E TRANSPORTE INTERNACIONAL DE LINFOCITOS DE DOADOR NAO APARENTADO P/ TRANSPLANTE	9999	9999	0501030034	202402	1	1	3	5	7	112	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
c7dca82d-0b33-406c-a782-3543fba257f3	3828	GABAPENTINA 300 MG (POR CAPSULA)	36	1571	0604500017	202402	1	1	3	6	26	353	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
9faf3ab5-412b-40ec-b83c-87dedb7bebc4	1170	FORTALECIMENTO DO PROTAGONISMO DE USUÁRIOS DE CENTRO DE ATENÇÃO PSICOSSOCIAL E SEUS FAMILIARES	0	1571	0301080267	202402	1	1	2	3	1	240	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
c721db76-1272-4f39-8b35-6fac7a370d80	1379	FOTOTERAPIA (POR SESSAO)	10	1571	0303080108	202402	1	1	2	3	21	233	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
70381052-7fb0-49c4-8a9f-09bcebff3f8e	330	PESQUISA DE ANTICORPOS CONTRA O VIRUS DA HEPATITE C (ANTI-HCV)	0	1571	0202030679	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	2026-06-25T18:17:34.477000+00:00
83fd0f85-921e-4af7-ad9f-0daad4eb1be4	904	FUNDOSCOPIA	0	1571	0211060100	202402	1	1	2	2	49	203	0	<span class="null">NULL</span>	1	CLINICO	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
a5aaf40c-7bb2-416f-86ee-86014cda565a	2083	FOTOCOAGULACAO A LASER	0	1571	0405030045	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
6877e09d-08df-43cf-836b-41c1bba449f5	2129	FOTOTRABECULOPLASTIA A LASER	0	1571	0405050127	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
089b1a14-08de-4091-869a-ed2289c203c1	2459	FISTULECTOMIA / FISTULOTOMIA ANAL	0	1571	0407020276	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
f60ecc6e-7b4c-47c4-9a92-b030980a92d4	3630	FORMOTEROL 12 MCG PO INALANTE (POR FRASCO DE 60 DOSES)	0	1571	0604040032	202402	1	1	3	6	26	152	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
ca426869-942b-4b07-a0f0-80eda657f675	3425	FORNECIMENTO E ACONDICIONAMENTO E TRANSPORTE NO BRASIL DE LINFOCITOS DE DOADOR NAO APARENTADO	0	851	0501030107	202402	1	1	3	5	7	112	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
52660c43-91e9-4c18-982d-8b3135fa8e0f	3629	FORMOTEROL 12 MCG (POR CAPSULA INALANTE)	0	1571	0604040024	202402	1	1	3	6	26	152	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
4fd88b89-c6fd-4cbc-b83b-10a0991097df	3631	FORMOTEROL 12 MCG + BUDESONIDA 400 MCG (POR CAPSULA INALANTE)	0	1571	0604040040	202402	1	1	3	6	26	152	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
60d1e34e-47f1-41b9-bb0f-c7cc411d0642	3810	FLUDROCORTISONA 0,1 MG (POR COMPRIMIDO)	0	1571	0604420013	202402	1	1	3	6	26	345	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
d28fa86e-eebb-4860-b905-d718d8b3e043	4780	FUMARATO DE DIMETILA 120 MG (POR COMPRIMIDO)	216	1571	0604540027	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
dafc0445-0488-4ece-8db5-98a82613bd27	4781	FUMARATO DE DIMETILA 240 MG (POR COMPRIMIDO)	216	1571	0604540035	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
7407ebd3-9eaf-4e5f-a724-40f38ff37bfe	3938	ÓRTESE RÍGIDA PARA LUXAÇÃO CONGÊNITA DO QUADRIL	9999	9999	0701020202	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.277000+00:00	2021-05-25T19:39:57.277000+00:00
9ac042fd-f2ef-4543-9874-9152949fbb52	3939	ÓRTESE SUROPODÁLICA ARTICULADA EM POLIPROPILENO INFANTIL	0	155	0701020210	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>	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
573cde76-2227-4787-97fd-a47f0252877d	4107	FIXADOR DINÂMICO PARA MANDÍBULA	9999	9999	0702020214	202402	1	1	0	7	12	74	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
bb242658-602f-4200-aea7-afc0759d61cc	4139	FIO TIPO STEINMAN ROSQUEADO	9999	9999	0702030333	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
c38860b4-b277-4b6e-ba42-9689d6834c46	4140	FITA PARA RECONSTRUCAO LIGAMENTAR	9999	9999	0702030341	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
1f53b58a-448a-4614-beab-ef833176e208	4142	FIXADOR EXTERNO C/ SISTEMA DE CORRECAO ANGULAR E/OU ROTACIONAL	9999	9999	0702030368	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
35dc251d-920b-42ab-bebc-a0639c3c3b9d	4358	FIO TIPO STEINMAN LISO	9999	9999	0702050792	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
08ad7e14-7d5e-4106-813c-3a7f21e9c761	4145	FIXADOR EXTERNO HIBRIDO	9999	9999	0702030392	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
6fd65b21-eaca-4be6-9c98-8b0f56272d8d	3777	FLUVASTATINA 20 MG (POR CAPSULA)	0	1571	0604360053	202402	1	1	3	6	26	339	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
6766d91b-735f-4257-ac04-d30b3b0212fa	3778	FLUVASTATINA 40 MG (POR CAPSULA)	0	1571	0604360061	202402	1	1	3	6	26	339	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
d74f9a5e-3d77-45e2-a968-6950e1bf8bee	3829	GABAPENTINA 400 MG (POR CAPSULA)	36	1571	0604500025	202402	1	1	3	6	26	353	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
8b187cd4-e196-4362-984f-bc8e897e0d7f	3417	FORNECIMENTO, ACONDICIONAMENTO E TRANSPORTE INTERNACIONAL DE CELULAS-TRONCO HEMATOPOETICAS DE CORDAO UMBILICAL P/ TRANSPLANTE	9999	9999	0501030026	202402	1	1	3	5	7	112	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
498a8754-0e9b-4d66-9f5b-c492d29be2ca	321	PESQUISA DE ANTICORPOS ANTIMUSCULO LISO	0	1571	0202030580	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
1b2c7df7-7275-48e0-bc29-3bc6fd350d9b	323	PESQUISA DE ANTICORPOS ANTIPARIETAIS	0	1571	0202030601	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
6e515786-6270-4ce6-92ed-065e4dd7e7cb	324	PESQUISA DE ANTICORPOS ANTIPLASMODIOS	0	1571	0202030610	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
1a8a3844-0a7d-49a8-8c4e-ea4558729934	4555	FOCALIZAÇÃO ISOELÉTRICA DA TRANSFERRINA	0	1571	0202100057	202402	1	1	2	2	9	266	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
999ddf62-d5fc-409b-8fca-ddcae2361cd1	4559	FISH EM METÁFASE OU NÚCLEO INTERFÁSICO, POR DOENÇA	0	1571	0202100090	202402	1	1	2	2	9	266	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
0f94e050-c869-4e9a-a82b-123c246faea1	680	FISTULOGRAFIA	0	1571	0204050057	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
e2547f1d-54a5-441e-9666-6e2e19a7e75f	851	FLEBOGRAFIA DE MEMBRO	0	1571	0210010177	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
6c2c1e14-6066-4005-bef7-c9acc3be968f	852	FLEBOGRAFIA DE CAVA INFERIOR E/OU SUPERIOR	0	1571	0210010185	202402	1	1	3	2	47	12	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
df7ad5c3-176e-473e-8922-ebad75fa7fcd	1771	FRENECTOMIA	0	1571	0401010082	202402	1	1	1	4	8	27	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
526ce65e-de19-4f23-8629-01ae34e3db48	4554	GENOTIPAGEM DO HIV	0	1571	0202031241	202402	1	1	3	2	9	134	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
becbaee2-7f5f-41ad-989e-e7343a412b01	3656	GOSSERRELINA 10,80 MG INJETAVEL (POR SERINGA PREENCHIDA)	0	1571	0604110022	202402	1	1	3	6	26	272	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
d02d1ee2-f216-4031-aa1f-5da736d63d62	3236	GENGIVECTOMIA (POR SEXTANTE)	24	1571	0414020154	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
1bc9c50e-e4a8-4cf7-ba34-4fa971bc1256	1989	GLOSSECTOMIA PARCIAL	0	1571	0404020143	202402	1	1	2	4	24	84	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
48a24f6a-4175-4dbb-ab9b-b40bcac08990	3794	GOLIMUMABE 50 MG INJETÁVEL (POR SERINGA PREENCHIDA	216	1571	0604380089	202402	1	1	3	6	26	341	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
9f78ffe3-f587-454f-9502-562db8139409	3294	GLOSSECTOMIA PARCIAL EM ONCOLOGIA	144	1571	0416030068	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
4a4dcb52-f62e-42dd-8975-24ec388c2b44	3295	GLOSSECTOMIA TOTAL EM ONCOLOGIA	228	1571	0416030076	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
4a4df10a-dd70-49a5-a3cc-96d254112ee1	3664	GALANTAMINA 8 MG (POR CAPSULA DE LIBERAÇÃO PROLONGADA)	480	1571	0604130031	202402	1	1	3	6	26	287	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
9ae7bbd8-ef31-414d-b52a-58806efc0ef1	3665	GALANTAMINA 16 MG (POR CAPSULA DE LIBERAÇÃO PROLONGADA)	480	1571	0604130040	202402	1	1	3	6	26	287	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
d4d96c07-1463-4cb0-b3a2-20a8dca47428	4323	GANCHO PEDICULAR	9999	9999	0702050253	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
5c64033b-0d45-4b4c-90a3-0eabce028910	1726	GASTROSTOMIA ENDOSCOPICA PERCUTANEA (INCLUI MATERIAL E SEDACAO ANESTESICA)	0	1571	0309010039	202402	1	1	3	3	43	25	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
fd1380f5-e904-4247-b9a5-b9ba52a0075b	3326	GASTRECTOMIA TOTAL EM ONCOLOGIA	144	1571	0416040071	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.274000+00:00	2021-05-25T19:39:57.274000+00:00
6e662e29-693f-4085-8413-c9f4393b754a	2407	GASTRECTOMIA C/ OU S/ DESVIO DUODENAL	192	1571	0407010122	202402	1	1	3	4	38	33	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.274000+00:00	2021-05-25T19:39:57.274000+00:00