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
33830195-a80f-4b98-836b-0f7991c5cb6d	825	LAPAROSCOPIA	0	1571	0209010045	202402	1	1	2	2	44	11	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
367deb14-45b4-453d-88fd-ff4266d5db60	2462	JEJUNOSTOMIA / ILEOSTOMIA	0	1571	0407020306	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
83b301d0-2b5d-4a74-937a-7fcae7bcae1f	2521	LAPAROTOMIA EXPLORADORA	0	1571	0407040161	202402	1	1	2	4	38	162	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
cf14577f-04e3-4cbb-98e0-6ea836d3adf3	1490	IRRADIACAO DE CORPO INTEIRO PRÉ-TRANSPLANTE DE MEDULA ÓSSEA	0	731	0304010120	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
78a7930f-3ac9-44c8-8d51-f294d8e7c003	1491	IRRADIAÇÃO DE MEIO CORPO	228	1571	0304010138	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
80b74ed8-abcd-4f65-b06b-5863eb86f0e8	3739	LANREOTIDA 120 MG INJETÁVEL (POR SERINGA PREENCHIDA)	0	1571	0604290080	202402	1	1	3	6	26	324	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
0aec5aa6-efec-4153-92c8-68ce6e643b47	857	INVESTIGACAO ULTRASSONICA (PLETISMOGRAFIA)	0	131	0211010022	202402	1	1	2	2	49	13	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
680e9b1b-e860-46e8-9077-5ef1bd0eda02	1020	ISOLAMENTO DA RICKETTSIA RICKTTSII (FEBRE MACULOSA)	0	1571	0213010372	202402	1	1	3	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
e4ad0cec-3614-4af5-a0e0-dc230b8647b3	1023	ISOLAMENTO DO VIRUS DA INFLUENZA	0	1571	0213010402	202402	1	1	3	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
2a5b8955-55d2-45d2-a8e7-ad97fd46a7ae	3816	LAMIVUDINA 10 MG/ML SOLUCAO ORAL (FRASCO DE 240 ML)	0	1571	0604460031	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
50dfb61d-8aec-42e6-8cfa-27a221500db9	3832	LAMOTRIGINA 100 MG (POR COMPRIMIDO)	24	1571	0604500050	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
d630265c-80dd-455f-8880-6a20334f3597	3857	ISOTRETINOINA 10 MG (POR CAPSULA)	0	1571	0604590016	202402	1	1	3	6	26	362	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
dc02f3b1-1611-4c76-a1e2-518ce10c9636	4128	COMPONENTE FEMORAL PRIMARIO CIMENTADO / FIXACAO BIOLOGICA	9999	9999	0702030228	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.270000+00:00	2021-05-25T19:39:57.270000+00:00
b0e05d18-a572-4018-809e-7c998def6330	980	IRRADIACAO DE SANGUE E COMPONENTES DESTINADOS A TRANSFUSAO	0	1571	0212020030	202402	1	1	2	2	51	105	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
64fd0f3d-2e72-428c-8c1e-82a01bbb1d7c	1024	ISOLAMENTO DO VIRUS DA MENINGITE VIRAL	0	1571	0213010410	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
5e2d7ecb-151a-44aa-8e36-89425e8885a3	1025	ISOLAMENTO DO VIRUS DA POLIOMIELITE	0	1571	0213010429	202402	1	1	3	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
0a7107d7-5f32-453d-a130-470b20b12c4e	1026	ISOLAMENTO DO VIRUS DA RAIVA	0	1571	0213010437	202402	1	1	3	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
ca9c7fb3-7e1b-4f7a-b66e-0b81132b59e5	1027	ISOLAMENTO DO VIRUS DO SARAMPO	0	1571	0213010445	202402	1	1	3	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
c62cefe1-e0e8-4521-a25b-277218444dbf	3738	LANREOTIDA 90 MG INJETÁVEL (POR SERINGA PREENCHIDA)	0	1571	0604290071	202402	1	1	3	6	26	324	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
c8e48f42-a29e-47cf-be10-828cf582366a	1021	ISOLAMENTO DO VIRUS DA DENGUE	0	1571	0213010380	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
9db8d6a2-b265-4a86-95dd-1e7464eecd17	3817	LAMIVUDINA 150 MG (POR COMPRIMIDO)	0	1571	0604460040	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
2107db5e-212a-4878-9c4b-c6dd868f57eb	3657	LEUPRORRELINA 3,75 MG INJETAVEL (POR FRASCO-AMPOLA)	0	1571	0604110030	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
b42b5e8c-ca09-442e-ad25-36e642cbda5e	4009	LENTE ESCLERAL PINTADA	9999	9999	0701040025	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
7bac1b3c-9128-46ed-9721-d2077da0c6ba	3281	LINFADENECTOMIA CERVICAL SUPRAOMO-HIOIDEA UNILATERAL EM ONCOLOGIA	144	1571	0416020178	202402	1	1	3	4	57	63	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
8dfdf2ba-a6a9-4b0a-8e7b-928383d4a8de	3285	LINFADENECTOMIA AXILAR UNILATERAL EM ONCOLOGIA	144	1571	0416020216	202402	1	1	3	4	57	63	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
754f9785-3682-42d4-a00c-6dfd6957e7d2	3310	LARINGECTOMIA TOTAL EM ONCOLOGIA	228	1571	0416030262	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
53288ce4-1d09-42ed-8f51-af440bfb1adc	3309	LARINGECTOMIA PARCIAL EM ONCOLOGIA	228	1571	0416030254	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
84e7de15-c8bd-4867-944f-95923e4a3617	4724	LIGADURA DE FISTULA SISTEMICO-PULMONAR (CRIANÇA E ADOLESCENTE)	0	227	0406011486	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
c7b89144-6f7e-4456-9b9b-2097ac4650de	47	LICENCIAMENTO SANITÁRIO DE SERVIÇOS HOSPITALARES DE ATENÇÃO AO PARTO E À CRIANÇA	9999	9999	0102010382	202402	1	1	0	1	10	2	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
4a757194-d7e3-4bb5-8eb6-32a84c623ea3	4507	LDL	0	1571	ABEX009	202402	1	1	2	2	9	4	1	160	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
6e26066d-2d7a-43a7-8ff6-e221075c4ce0	35	LICENCIAMENTO SANITÁRIO DE HOSPITAIS	9999	9999	0102010269	202402	1	1	0	1	10	2	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.275000+00:00	2021-05-25T19:39:57.275000+00:00
2e669491-05eb-499f-9d67-ec7af82b9d46	38	LICENCIAMENTO SANITÁRIO DE INSTITUIÇÕES DE LONGA PERMANÊNCIA PARA IDOSOS	9999	9999	0102010293	202402	1	1	0	1	10	2	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
deafa7ec-3ae6-4cca-ba94-21879401c14b	41	LICENCIAMENTO SANITÁRIO DE INDÚSTRIAS DE MEDICAMENTOS	9999	9999	0102010323	202402	1	1	0	1	10	2	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.275000+00:00	2021-05-25T19:39:57.276000+00:00
f840ea1f-c7a2-4f34-bfe4-138fdf88788b	1939	LARINGECTOMIA PARCIAL	12	1571	0404010172	202402	1	1	2	4	24	30	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
4c8d1917-0cde-40d0-8ce5-1e80102c1c8c	1940	LARINGECTOMIA TOTAL	12	1571	0404010180	202402	1	1	2	4	24	30	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
b54d485a-9795-4995-825a-1b28699c04b2	1941	LARINGECTOMIA TOTAL C/ ESVAZIAMENTO CERVICAL	12	1571	0404010199	202402	1	1	2	4	24	30	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
5483cf13-c374-4fe5-b0cf-70348983c56f	1942	LARINGORRAFIA	0	1571	0404010202	202402	1	1	2	4	24	30	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
9e9c350e-25dd-4530-9aa6-4305d5f32c35	1967	LARINGOFISSURA PARA COLOCACAO DE MOLDE NOS TRAUMATISMOS DE LARINGE	0	1571	0404010458	202402	1	1	2	4	24	30	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
58991cb7-dee5-47f7-8455-ede46fc5c32e	3040	LAQUEADURA TUBARIA	252	731	0409060186	202402	0	1	2	4	42	211	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
143d9d31-39b9-41dc-b201-b357523ad3c0	2225	LIGADURA DE FISTULA SISTEMICO-PULMONAR	228	1571	0406010730	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
cb9fe021-5c59-4fad-a897-1828dd3d788d	3317	LIGADURA DE CARÓTIDA EM ONCOLOGIA	0	1571	0416030335	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
c7c3a153-9167-4a74-ac6e-dbad9e216702	2463	LIGADURA ELASTICA DE HEMORROIDAS (SESSAO)	0	1571	0407020314	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
a3623c24-362b-4da3-a7fc-cd8d051642b8	2522	LAPAROTOMIA VIDEOLAPAROSCOPICA PARA DRENAGEM E/OU BIOPSIA	0	1571	0407040170	202402	1	1	2	4	38	162	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
96e5b2ea-52ab-4608-9d6a-4193d395f3c2	2523	LIBERACAO DE ADERENCIAS INTESTINAIS	0	1571	0407040188	202402	1	1	2	4	38	162	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
24a80f49-6afd-492b-93db-7166dbe6acf7	249	LEUCOGRAMA	0	1571	0202020398	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
a3777362-248f-4229-ba2b-0769f8ab06e7	3282	LINFADENECTOMIA CERVICAL RECORRENCIAL UNILATERAL EM ONCOLOGIA	0	1571	0416020186	202402	1	1	3	4	57	63	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
4ab3f8cf-99b7-4216-b233-3494e16fc711	2969	LIGADURA / SECCAO DE VASOS ABERRANTES	0	1571	0409020052	202402	1	1	2	4	42	89	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
765e8b8a-e21e-4943-9355-45301f3aaae4	3287	LINFADENECTOMIA INGUINAL UNILATERAL EM ONCOLOGIA	144	1571	0416020232	202402	1	1	3	4	57	63	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
310bea38-11ad-4fce-bacd-5fa55aac1328	3015	LIBERACAO / PLASTIA DE PREPUCIO	0	1571	0409050059	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
8034144c-8631-43e0-830e-14be32491d2c	3145	LIGADURA DO DUCTO TORACICO (QUALQUER METODO)	0	1571	0412040042	202402	1	1	3	4	50	165	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.276000+00:00	2021-05-25T19:39:57.276000+00:00