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
47a922f8-6215-419d-af8a-da4e8a9dfc3c	1716	TRATAMENTO DE TRAUMATISMOS C/ LESAO DE ORGAO INTRA-TORACICO E INTRA-ABDOMINAL	0	1571	0308010035	202402	1	1	2	3	40	24	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
e1322e88-2648-40be-97e3-25747742eb64	1717	TRATAMENTO DE TRAUMATISMOS ENVOLVENDO MULTIPLAS REGIOES DO CORPO	0	1571	0308010043	202402	1	1	2	3	40	24	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
59ce7723-25c5-4602-9d52-540a1f2a1367	1723	TRATAMENTO DE QUEIMADURAS CORROSOES E GELADURAS	0	1571	0308030036	202402	1	1	2	3	40	122	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
afdeee58-2771-43f9-bcb7-70ab6194d61f	3111	TRATAMENTO DE OUTROS TRANSTORNOS MATERNOS RELACIONADOS PREDOMINANTEMENTE A GRAVIDEZ	108	731	0411020056	202402	0	1	2	4	48	90	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
7cb84f87-89ab-4b4d-8984-5a6e068afee1	1792	TRATAMENTO EM ESTAGIOS SUBSEQUENTES DE ENXERTIA	0	1571	0401020169	202402	1	1	2	4	8	81	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
bdee92fa-67b2-4f23-b516-134f4fd90a1a	2116	TRATAMENTO DE PTOSE PALPEBRAL	0	1571	0405040202	202402	1	1	2	4	29	160	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
01121b85-bd8b-4c13-83cb-9ad30fdee4d6	4792	TRATAMENTO RESTAURADOR ATRAUMÁTICO (TRA/ART)	12	1571	0307010074	202402	1	1	1	3	36	23	1	<span class="null">NULL</span>	1	GRUPO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
cb2af8b8-5c92-4245-bed9-e0745950f397	3249	TRATAMENTO ODONTOLOGICO PARA PACIENTES COM NECESSIDADES ESPECIAIS	0	1571	0414020413	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	ADMINISTRATIVO	0	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2021-05-25T19:39:57.288000+00:00
db3d2581-ebb8-44e0-8fe4-9a24e5d0dd92	4768	TRATAMENTO HOMEOPÁTICO	0	1571	0309050197	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2021-05-25T19:39:57.288000+00:00
1f879595-cffb-40ef-8e74-cb5306290375	4603	TRATAMENTO HORMONAL PREPARATÓRIO PARA CIRURGIA DE REDESIGNAÇÃO SEXUAL NO PROCESSO TRANSEXUALIZADOR	216	911	0303030089	202402	1	0	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
f2f75b1e-4097-4d28-9f35-8e74ceae0e62	4482	EVIDENCIAÇÃO DE PLACA BACTERIANA	0	1571	ABPO010	202402	1	1	1	1	4	93	0	12	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.273000+00:00	2021-05-25T19:39:57.273000+00:00
b8b8eb8b-c977-41ed-8a9b-0213a7ddf4c2	4774	EVEROLIMO 0,5 MG PARA TRANSPLANTE (POR COMPRIMIDO)	0	1571	0603080278	202402	1	1	3	6	19	243	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
b4d3fb94-6125-486b-a881-913d4956c33e	4775	EVEROLIMO 0,75 MG PARA TRANSPLANTE (POR COMPRIMIDO)	0	1571	0603080286	202402	1	1	3	6	19	243	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
8c0313e9-ff05-4d2e-98ef-977bd0d9d484	4776	EVEROLIMO 1 MG PARA TRANSPLANTE (POR COMPRIMIDO)	0	1571	0603080294	202402	1	1	3	6	19	243	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.273000+00:00	2021-05-25T19:39:57.273000+00:00
6e2beb65-85db-4014-b653-908f6d26adf8	4777	LARONIDASE 0,58 MG SOLUÇÃO INJETÁVEL (FRASCO DE 5 ML)	0	1571	0604240066	202402	1	1	3	6	26	315	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
8c654c83-39b0-4bb3-88c0-b0b0cecf845e	4778	IDURSULFASE ALFA 2 MG/ML SOLUÇÃO INJETÁVEL (FRASCO DE 3 ML)	0	1571	0604240074	202402	1	1	3	6	26	315	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
2674cce7-21d4-4de3-ad3e-94f4a63a7669	4514	SOROLOGIA PARA DENGUE	0	1571	ABEX016	202402	1	1	2	2	9	134	1	353	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
3fb65510-9d9f-4068-a973-4e0b5293b73c	12	EVIDENCIAÇÃO DE PLACA BACTERIANA	0	1571	0101020082	202402	1	1	1	1	4	93	1	<span class="null">NULL</span>	1	GRUPO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.273000+00:00	2021-05-25T19:39:57.273000+00:00
d631ef06-008b-4ba2-9f8d-aadb97be240d	167	DOSAGEM DE DESIDROGENASE GLUTAMICA	0	1571	0202010350	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
a2658157-341c-401d-b767-02e4d57120c6	169	DOSAGEM DE DESIDROGENASE LATICA (ISOENZIMAS FRACIONADAS)	0	1571	0202010376	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
de16e0e0-c166-4e75-b0a4-d12a53fcb93d	170	DOSAGEM DE FERRITINA	0	1571	0202010384	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
337a55ef-e862-4706-9a24-cf5fe03a1459	171	DOSAGEM DE FERRO SERICO	0	1571	0202010392	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
40c919a8-3f46-4566-9603-03e906fd0fff	172	DOSAGEM DE FOLATO	0	1571	0202010406	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
aa2749c9-4fd0-4e81-aac7-99bf82385f8a	1307	TRATAMENTO OFTALMOLÒGICO DE PACIENTE C/ GLAUCOMA BINOCULAR (1ª LINHA )	0	1571	0303050039	202402	1	1	2	3	21	196	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
8051e683-5037-438e-b999-89d6ba5ccde4	1308	TRATAMENTO OFTALMOLÓGICO DE PACIENTE C/ GLAUCOMA BINOCULAR (2ª LINHA)	0	1571	0303050047	202402	1	1	2	3	21	196	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
7047579e-0eed-4694-9988-ae5ff71d016d	4699	TRATAMENTO ESCLEROSANTE NÃO ESTÉTICO DE VARIZES DOS MEMBROS INFERIORES (UNILATERAL)	144	1571	0309070015	202402	1	1	2	3	43	383	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
c923fe2f-ba0f-4b78-9d0c-c7d5e881cc90	4700	TRATAMENTO ESCLEROSANTE NÃO ESTÉTICO DE VARIZES DOS MEMBROS INFERIORES (BILATERAL)	144	1571	0309070023	202402	1	1	2	3	43	383	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
b2acae96-9141-4cdd-b20f-992c098caea4	1849	TRATAMENTO MICROCIRURGICO DE TUMOR DE NERVO PERIFERICO / NEUROMA	0	1571	0403020131	202402	1	1	3	4	20	83	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
18a4817d-09b9-4a52-b519-b6d82986b3d5	1891	TRATAMENTO POR ESTERETAXIA DE LESÃO DE ESTRUTURA PROFUNDA DE SNC PARA TRATATAMENTO DE MOVIMENTOS ANORMAIS OU CONTROLE DA DOR	156	1571	0403050162	202402	1	1	3	4	20	184	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
8b3b47f5-f473-4e46-841e-855bf36c444b	2381	TRATAMENTO ENDOVASCULAR DE FISTULAS ARTERIOVENOSAS	0	1571	0406040320	202402	1	1	3	4	34	161	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
fe0542f2-fcca-4ad5-a56a-8e43c7d1f1e4	2382	TRATAMENTO ENDOVASCULAR DO PSEUDOANEURISMA	0	1571	0406040338	202402	1	1	3	4	34	161	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
b0286c2c-c2f8-46dc-a15a-4cf3204c27c9	2426	TRATAMENTO ESCLEROSANTE / LIGADURA ELASTICA DE LESAO HEMORRAGICA DO APARELHO DIGESTIVO	0	1571	0407010319	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
fac608ed-1bfe-48a5-a1b7-1dae4012aca0	2427	TRATAMENTO ESCLEROSANTE DE LESOES NAO HEMORRAGICAS DO APARELHO DIGESTIVO INCLUINDO LIGADURA ELASTICA	0	1571	0407010327	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.288000+00:00	2021-05-25T19:39:57.288000+00:00
45153c99-35dd-433b-88d7-bf84edf1194e	2481	TRATAMENTO ESCLEROSANTE DE HEMORROIDAS (POR SESSAO)	0	1571	0407020497	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2021-05-25T19:39:57.288000+00:00
922bda52-3e0a-41a6-8c4a-9de13aa1a972	4690	TRATAMENTO NATUROPÁTICO	0	1571	0309050073	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2021-05-25T19:39:57.288000+00:00
045e9ec2-9b0e-46cf-97f4-5b09bf086d1b	4691	TRATAMENTO OSTEOPÁTICO	0	1571	0309050081	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
186e293c-7646-412c-bce0-784c5894a6a1	4692	TRATAMENTO QUIROPRÁTICO	0	1571	0309050090	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
8e54f6bb-9122-40eb-9403-95d2268ce1d1	173	DOSAGEM DE FOSFATASE ACIDA TOTAL	0	1571	0202010414	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
4c93879f-2df7-40f9-99a4-27e7b597e76a	174	DOSAGEM DE FOSFATASE ALCALINA	0	1571	0202010422	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
1cc35247-ad1d-4482-add0-481ab1498cb3	181	DOSAGEM DE HAPTOGLOBINA	0	1571	0202010490	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.272000+00:00	2021-05-25T19:39:57.272000+00:00
6d994963-f61f-4793-a3e8-a0d7b87f4d75	4689	TRATAMENTO TERMAL/CRENOTERÁPICO	0	1571	0309050065	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
4bef0b63-e941-4834-833e-075ccbd8278c	4769	TRATAMENTO FITOTERÁPICO	0	1571	0309050200	202402	1	1	1	3	43	183	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2021-05-25T19:39:57.288000+00:00
44607aa7-fd2d-4442-8b6e-4661187edf2e	4755	TRATAMENTO MEDICAMENTOSO DA DOENÇA DA RETINA	216	1571	0303050233	202402	1	1	2	3	21	196	1	<span class="null">NULL</span>	1	CLINICO	0	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.288000+00:00	2021-05-25T19:39:57.288000+00:00
d70a9239-982a-47e0-866d-ff1751fa1787	3650	TRIEXIFENIDIL 5 MG (POR COMPRIMIDO)	0	1571	0604070012	202402	1	1	3	6	26	217	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
c8e53e3c-927a-4854-aba6-ed97beba1a44	3659	TRIPTORRELINA 3,75 MG INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604110057	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
e4ebd0c0-68b8-448c-bd49-a34886a5a32b	3171	TROMBOENDARTERECTOMIA PULMONAR	0	1571	0412050153	202402	1	1	3	4	50	189	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
bffa6287-82b8-4142-93ac-3bceb5f02b98	3660	TRIPTORRELINA 11,25 MG INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604110065	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00
c5512f97-c3f8-4c4e-8fbf-c28b6fd1076a	3872	TRAVOPROSTA 0,04 MG/ML SOLUÇÃO OFTÁLMICA (POR FRASCO DE 2,5 ML)	0	1571	0604650035	202402	1	1	3	6	26	368	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
32e19f43-7bcb-4830-a291-99e31af181e6	4365	TUBO DE DRENAGEM PARA GLAUCOMA	9999	9999	0702070050	202402	1	1	0	7	12	222	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.289000+00:00	2021-05-25T19:39:57.289000+00:00
65bd003c-6488-4f33-abc8-3e926df00b0e	956	TRIAGEM AUDITIVA DE ESCOLARES	48	155	0211070360	202402	1	1	2	2	49	225	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.289000+00:00	2021-05-25T19:39:57.289000+00:00