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
9eee8b3d-6a8e-45f6-b5a3-742f59ada91c	4508	MAMOGRAFIA BILATERAL	420	1571	ABEX010	202402	0	1	2	2	25	135	0	663	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
da7366f1-81ae-4e81-965e-082cebabefe3	3314	MANDIBULECTOMIA PARCIAL EM ONCOLOGIA	144	1571	0416030300	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
a86a28ca-3755-4c2f-8f5c-c66ced69094b	734	MARCACAO DE LESAO PRE-CIRURGICA DE LESAO NAO PALPAVEL DE MAMA ASSOCIADA A ULTRASSONOGRAFIA	228	1571	0205020194	202402	0	1	2	2	30	98	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
fa714e9e-c5dd-4d7e-a02a-221a1063cfc0	1657	MANUTENCAO E ACOMPANHAMENTO DOMICILIAR DE PACIENTE SUBMETIDO A DPA /DPAC	0	1571	0305010166	202402	1	1	3	3	28	21	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
07fe7fb2-e648-4530-bc91-35b7303b3ed5	4509	MAMOGRAFIA UNILATERAL	120	1571	ABEX011	202402	1	1	2	2	25	135	0	648	1	CLINICO	1	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
b89d5e78-93dc-48a9-aee5-9ac180caf65a	2226	MANUTENCAO DE ASSISTENCIA CIRCULATORIA	0	1571	0406010749	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
98748706-69ef-4703-ba3a-f62ae103cfcc	3315	MANDIBULECTOMIA TOTAL EM ONCOLOGIA	144	1571	0416030319	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
4e5cea13-c4eb-49be-94a0-ee958de63843	1493	MÁSCARA / IMOBILIZAÇÃO PERSONALIZADA (POR TRATAMENTO)	0	1571	0304010154	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
f798e4f5-fc28-477a-92b3-fdde8c620dd2	648	MAMOGRAFIA	120	1571	0204030030	202402	1	1	2	2	25	135	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
532cf61a-1988-4362-b1a0-b9b6ac0a3b58	1709	MANUTENÇÃO/CONSERTO DE APARELHO ORTODÔNTICO/ORTOPÉDICO	0	1571	0307040127	202402	1	1	3	3	36	156	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
bfcb7a8a-4a47-4240-8440-7e0707cf9a3c	1704	MANUTENCAO PERIODICA DE PROTESE BUCO-MAXILO-FACIAL	180	1571	0307040062	202402	1	1	2	3	36	156	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
08879f09-b594-4e1b-a4d6-bafb7bf7e768	4510	MARCAÇÃO PRÉ-CIRURGIA	192	1571	ABEX012	202402	1	1	2	2	25	135	0	<span class="null">NULL</span>	1	CLINICO	0	1	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
5ed9ecf5-c9c2-4627-b7f1-c99de97dff11	2850	MANIPULAÇÃO ARTICULAR	0	1571	0408060158	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
7bab39ad-561c-479c-a61f-cb21e1eba115	3069	MARSUPIALIZACAO DE GLANDULA DE BARTOLIN	144	1571	0409070190	202402	0	1	2	4	42	228	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
6d2272eb-dea0-40d2-8c28-68313c0ee6cc	3198	MAMOPLASTIA PÓS-CIRURGIA BARIÁTRICA	216	1571	0413040089	202402	1	1	3	4	53	144	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
1ffe59bf-5cae-459d-aa27-f649a15636ea	3470	MANUTENCAO HEMODINAMICA DE POSSIVEL DOADOR E TAXA DE SALA P/ RETIRADA DE ORGAOS	0	1091	0503030015	202402	1	1	3	5	22	113	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
765bd378-9d67-4a09-813f-f2b5a544fe52	3904	MANUTENÇÃO DE OPM AUXILIARES DE LOCOMOÇÃO	0	1571	0701010193	202402	1	1	0	7	5	55	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
da793407-621f-446c-a72d-c4b55d960947	4011	LUPA MANUAL COM OU SEM ILUMINAÇÃO	36	1571	0701040041	202402	1	1	0	7	5	153	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
f62ef082-1fb8-4738-94dd-358a80f0d765	4006	MANUTENÇÃO/ ADAPTAÇÃO DE OPM AUDITIVA	0	1571	0701030305	202402	1	1	0	7	5	118	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
36dd38b2-8ba8-4401-8f85-a537135d1ef8	4022	MANUTENÇÃO DE OPM OFTALMOLÓGICA	0	1571	0701040157	202402	1	1	0	7	5	153	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
7a01c3fb-4cc2-4c7f-874d-4107233f85fc	4073	MALHA COMPRESSIVA P/ TRATAMENTO SEQUENCIAL DE QUEIMADOS (MEIA ATE VIRILHA OU JOELHO)	9999	9999	0701100028	202402	1	1	0	7	5	258	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
48264737-d7fc-4156-966a-62cd88648eb3	4079	MALHA COMPRESSIVA P/ TRATAMENTO SEQUENCIAL DE QUEIMADOS - TORAX C/ MANGAS (PECA)	9999	9999	0701100087	202402	1	1	0	7	5	258	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
ed28ef48-c7b1-40c7-ab0b-cc7b4d6ace28	4284	MARCAPASSO CARDIACO MULTIPROGRAMAVEL DE CAMARA DUPLA	9999	9999	0702040410	202402	1	1	0	7	12	154	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
d513e8cd-62f2-4927-9d42-795ccae0dd9b	4285	MARCAPASSO CARDIACO MULTIPROGRAMAVEL DE CAMARA UNICA	9999	9999	0702040428	202402	1	1	0	7	12	154	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
12a57f5c-1e9b-4f64-8a38-40f767f6cce2	4286	MARCAPASSO MULTI-SITIO	9999	9999	0702040436	202402	1	1	0	7	12	154	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
f06611bb-4522-4025-b132-9202c93fcc56	3976	MANUTENÇÃO DE OPM ORTOPÉDICA	0	1571	0701020580	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
9ff6630a-b95f-4360-8477-4972e4ed962a	649	MARCACAO PRE-CIRURGICA DE LESAO NAO PALPAVEL DE MAMA ASSOCIADA A MAMOGRAFIA	192	1571	0204030048	202402	1	1	2	2	25	135	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
dcc9dd88-daec-42b9-9b7e-77e017621df4	1223	ATENDIMENTO FISIOTERAPÊUTICO EM PACIENTE COM TRANSTORNO RESPIRATÓRIO COM COMPLICAÇÕES SISTÊMICAS	0	1571	0302040013	202402	1	1	2	3	16	173	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.266000+00:00	2026-07-31T13:09:46.246000+00:00
ff50dabf-4011-44d4-aa21-4cf9b8162074	4081	MALHA COMPRESSIVA P/ TRATAMENTO SEQUENCIAL DE QUEIMADOS PARA CABECA E PESCOCO	9999	9999	0701100109	202402	1	1	0	7	5	258	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
8e2507ac-05b1-40e1-a067-2caacd43ecbc	3239	MARSUPIALIZAÇÃO DE CISTOS E PSEUDOCISTOS	0	1571	0414020200	202402	1	1	2	4	54	109	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
9ee9ea22-79c2-4078-a3cd-480c420c624f	4035	MANTENEDOR DE ESPAÇO	24	1571	0701070064	202402	1	1	0	7	5	216	1	<span class="null">NULL</span>	1	OPME	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
6f0749a8-bf27-474f-a48a-13f91ff96b7c	3554	METILPREDNISOLONA 500 MG INJENTAVEL (POR AMPOLA)	0	1571	0603010016	202402	1	1	2	6	19	53	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
4a0ba64c-1f53-4bea-b09b-255079c55aa4	3383	MASTECTOMIA SIMPLES EM ONCOLOGIA	144	1571	0416120032	202402	1	1	3	4	57	281	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
70432889-529b-42b3-8eaa-1210a28843ff	3611	MESALAZINA 250 MG (POR SUPOSITORIO)	0	1571	0604010044	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
fd714db7-6aa7-451d-a340-14c30ec55522	3085	MASTECTOMIA RADICAL C/ LINFADENECTOMIA	192	1571	0410010057	202402	1	1	2	4	45	36	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
de2030c4-dd86-4d94-8881-016dc37dae0e	907	MEDIDA DE OFUSCAMENTO E CONTRASTE	0	1571	0211060135	202402	1	1	2	2	49	203	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
3891e2f3-75a2-47c1-ad84-44da26d4d8bc	1174	MATRICIAMENTO DE EQUIPES DA ATENÇÃO BÁSICA	0	1571	0301080305	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
3a01732e-b01c-47b0-9a38-ecb9a20a7020	3843	METOTREXATO 25 MG/ML INJETAVEL (POR AMPOLA DE 20 ML)	0	1571	0604530048	202402	1	1	3	6	26	356	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
a207b9b2-cb65-4182-bd08-f23417b904ae	1943	MASTOIDECTOMIA RADICAL	0	1571	0404010210	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
aad5f38f-65b9-49db-8a77-565260f52e53	1944	MASTOIDECTOMIA SUBTOTAL	0	1571	0404010229	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
65708e42-8e8e-477a-8c94-71e8e32a3d16	1990	MAXILECTOMIA PARCIAL	0	1571	0404020178	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
241788ca-4f34-4ba2-a142-d14a825b9c31	3808	METADONA 10 MG (POR COMPRIMIDO)	0	1571	0604410026	202402	1	1	3	6	26	344	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
c793eb4e-2b47-4827-a9b5-259806554baa	3302	MAXILECTOMIA TOTAL EM ONCOLOGIA	144	1571	0416030181	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
5373ec8d-b671-4bef-a9d6-7158b1b83fea	3336	METASTASECTOMIA HEPÁTICA EM ONCOLOGIA	0	1571	0416040225	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>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
79e32e52-0633-445b-8f4d-dee2c8945c30	2971	MEATOTOMIA SIMPLES	0	1571	0409020079	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
e9dbdee0-8df6-4d23-9dd9-e210ed23ccdb	3807	METADONA 5 MG (POR COMPRIMIDO)	0	1571	0604410018	202402	1	1	3	6	26	344	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
d5a7f2e4-07bc-4721-b426-a1e5c086fed6	4472	MEDIÇÃO DE ALTURA	0	1571	ABPG038	202402	1	1	1	1	4	166	0	<span class="null">NULL</span>	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
06783560-8fcc-418d-8e30-ed7ab9d66404	4473	MEDIÇÃO DE PESO	0	1571	ABPG039	202402	1	1	1	1	4	166	0	<span class="null">NULL</span>	1	CLINICO	1	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
73a52c05-2c1b-409d-821f-16f9a8cfd457	3382	MASTECTOMIA RADICAL C/ LINFADENECTOMIA AXILAR EM ONCOLOGIA	144	1571	0416120024	202402	1	1	3	4	57	281	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
b6a66504-070d-4850-9f98-91fc52d9c2a3	2970	MEATOTOMIA ENDOSCOPICA	0	1571	0409020060	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