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
ea29bacb-3dd3-405c-b210-b739b0cdfe87	588	DETECÇÃO MOLECULAR DE MUTAÇÃO EM HIPERPLASIA ADRENAL CONGÊNITA	0	1571	0202110125	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
01ca24fe-5d0c-4b7c-9069-143d9af2d557	589	DETECÇÃO MOLECULAR DE MUTAÇÃO EM DEFICIÊNCIA DE BIOTINIDASE	0	1571	0202110133	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
a51e5f18-e9ed-4751-9783-c75211f67eab	209	DETERMINAÇÃO DE CREMATÓCRITO NO LEITE HUMANO ORDENHADO	9999	9999	0202010775	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	0	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
2645e70b-1a0f-4398-a0d3-9db007a4cffa	215	DETERMINACAO DE ENZIMAS ERITROCITARIAS (CADA)	0	1571	0202020053	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
a1fe4b36-a416-4059-b7a5-f54323d0d7bb	362	DETECÇÃO DE CLAMÍDIA E GONOCOCO POR BIOLOGIA MOLECULAR	0	1571	0202030997	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
e6e913ae-3315-49e3-b874-57f6f33f18c4	406	DETERMINACAO DE OSMOLALIDADE	0	1571	0202050068	202402	1	1	2	2	9	190	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
d61c9295-d266-4bb0-baab-455caadf05ab	545	DETERMINACAO DE FOSFOLIPIDIOS RELACAO LECITINA - ESFINGOMIELINA NO LIQUIDO AMNIOTICO	0	1571	0202090078	202402	1	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
10b1e0b4-6317-46c1-ae7e-a1c3058e7357	591	DETERMINACAO DE ANTICORPOS ANTIPLAQUETARIOS	0	1571	0202120015	202402	1	1	2	2	9	280	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f1628396-ddd8-4b3f-b5a5-55537ef79428	573	DETERMINACAO DE CARIOTIPO EM CULTURA DE LONGA DURACAO (C/ TECNICA DE BANDAS)	0	1571	0202100014	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
b9fdab46-076e-4980-b72e-9663af1686f7	574	DETERMINACAO DE CARIOTIPO EM MEDULA OSSEA E VILOSIDADES CORIONICAS (C/ TECNICA DE BANDAS)	0	1571	0202100022	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
52120834-fb26-40d2-9130-dd7771b19468	776	DETERMINACAO DE FLUXO SANGUINEO REGIONAL	0	1571	0208010092	202402	1	1	3	2	39	10	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
adedb7b7-0696-4f6f-8d94-f1b380be8956	801	DETERMINACAO DE FILTRACAO GLOMERULAR	0	1571	0208040080	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
9d9280d1-e385-4e04-bb44-98bcdec59165	802	DETERMINACAO DE FLUXO PLASMATICO RENAL	0	1571	0208040099	202402	1	1	3	2	39	169	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
78afb0c3-96f6-4e58-ac5f-bf7dcacd53f8	817	DETERMINACAO DE SOBREVIDA DE HEMACIAS (C/ RADIOSOTOPOS)	0	1571	0208080031	202402	1	1	3	2	39	239	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
b917dc62-3a06-4bfa-b783-4a07e83d0d63	214	DETERMINACAO DE CURVA DE RESISTENCIA GLOBULAR	0	1571	0202020045	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
5d0fd848-465f-442e-92d4-0c6cf25f8022	216	DETERMINACAO DE SULFO-HEMOGLOBINA	0	1571	0202020061	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
f16be6a2-a2b5-4708-8021-03822de02e03	217	DETERMINACAO DE TEMPO DE COAGULACAO	0	1571	0202020070	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
760aeddd-fcb7-4f98-b337-ca52a3d6d48a	268	DETECCAO DE ÁCIDOS NUCLEICOS DO HIV-1 (QUALITATIVO)	24	1571	0202030040	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
91d3fd98-6645-4ee7-be13-f6a85475cabf	269	DETECCAO DE RNA DO VIRUS DA HEPATITE C (QUALITATIVO)	0	1571	0202030059	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
20d7717b-7f9a-4bf0-a44d-57f4b0df03fd	270	DETERMINACAO DE COMPLEMENTO (CH50)	0	1571	0202030067	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
08a68a3f-c331-49fd-b1f3-594811d4f2e7	271	DETERMINACAO DE FATOR REUMATOIDE	0	1571	0202030075	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
3947a0d6-4ba5-4264-974e-6cf3720362bc	1135	DIAGNOSTICO E/OU ATENDIMENTO DE URGENCIA EM CLINICA CIRURGICA	0	1571	0301060070	202402	1	1	2	3	1	213	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
6a564e90-6af0-4b55-884d-0530765eb47e	4418	DIÁRIA DE SAUDE MENTAL COM PERMANENCIA ENTRE 08 A 15 DIAS	48	1571	0802010261	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
edcfd753-e227-4be9-b223-6696e190ae22	4419	DIÁRIA DE SAUDE MENTAL COM PERMENENCIA SUPERIOR A 15 DIAS	48	1571	0802010270	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
1e96f8f9-0cdf-4c58-b3de-b2b9e8b4170b	4417	DIARIA DE SAÚDE MENTAL COM PERMANENCIA DE ATÉ SETE DIAS	48	1571	0802010253	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
bc784ddf-9e9e-412c-86cd-10bf626df2e3	1136	DIAGNOSTICO E/OU ATENDIMENTO DE URGENCIA EM CLINICA MEDICA	228	1571	0301060088	202402	1	1	2	3	1	213	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
b7cda275-e565-4e04-be72-861f53495f87	1646	DIALISE PERITONEAL INTERMITENTE DPI (1 SESSAO POR SEMANA -EXCEPCIONALIDADE)	0	1571	0305010018	202402	1	1	3	3	28	21	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
77c1cb49-a297-4a6c-b14c-dc039c2881f3	1647	DIALISE PERITONEAL INTERMITENTE DPI (MAXIMO 2 SESSOES POR SEMANA)	0	1571	0305010026	202402	1	1	3	3	28	21	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
87ec6f96-a037-426f-bb68-13caa38529ed	222	DETERMINACAO DE TEMPO DE TROMBINA	0	1571	0202020126	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
31066ecb-7439-4aef-abae-8ca421b7e3c2	1129	DIAGNOSTICO E/OU ATENDIMENTO DE URGENCIA EM CLINICA PEDIATRICA	0	239	0301060010	202402	1	1	2	3	1	213	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
7b605f07-b98f-4720-a1e4-ce67e83fc0f7	3483	DIARIA DE UNIDADE DE TERAPIA INTENSIVA DE PROVÁVEL DOADOR DE ÓRGÃOS	0	1091	0503040045	202402	1	1	0	5	22	148	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
0f9d3d30-df77-473f-9da1-5d335fe832a7	3646	MORFINA DE LIBERACAO CONTROLADA 60 MG (POR CAPSULA)	0	1571	0604050100	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
5010535b-7abd-482c-b88d-f56c9dab1e94	3647	MORFINA DE LIBERACAO CONTROLADA 100 MG (POR CAPSULA)	0	1571	0604050119	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
511669b2-eabf-430c-9eab-78e100364fa0	4396	DIARIA DE ACOMPANHANTE ADULTO (COM PERNOITE)	216	719	0802010016	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
daac816c-5976-4b19-91f6-f50d20376dee	4412	DIÁRIA DE PERMANÊNCIA A MAIOR	9999	9999	0802010199	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
fa48dae9-a959-4f4e-ad4b-3f8b7c14c6bc	592	DETERMINACAO DIRETA E REVERSA DE Grupo ABO	0	1571	0202120023	202402	1	1	2	2	9	280	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
a1c11ecb-0e48-4a08-9055-ffd2d3dbabcb	4409	DIARIA DE UNIDADE DE TERAPIA INTENSIVA EM PEDIATRIA (UTI I)	0	239	0802010148	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
412bff74-fa50-4e1b-904e-c9f974dbefb1	4410	DIARIA DE UNIDADE DE TERAPIA INTENSIVA EM PEDIATRIA (UTI II)	0	239	0802010156	202402	1	1	0	8	11	58	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
1eec1cae-4869-4284-99de-953eb6e967ae	221	DETERMINACAO DE TEMPO DE SOBREVIDA DE HEMACIAS	0	1571	0202020118	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
ecaac435-e111-4a5e-a4a5-7f8f7a0f25d5	218	DETERMINACAO DE TEMPO DE LISE DA EUGLOBULINA	0	1571	0202020088	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
2916acd0-e680-45aa-aaa1-39bd73c1e5a8	219	DETERMINACAO DE TEMPO DE SANGRAMENTO -DUKE	0	1571	0202020096	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
16b160f0-0a32-4432-b23f-e8179624cdb2	220	DETERMINACAO DE TEMPO DE SANGRAMENTO DE IVY	0	1571	0202020100	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
887232b8-45d4-4d3e-960d-1270e8c0fd0e	223	DETERMINACAO DE TEMPO DE TROMBOPLASTINA PARCIAL ATIVADA (TTP ATIVADA)	0	1571	0202020134	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
9777bf3a-bc38-45c9-86ce-dd2a692a6e96	224	DETERMINACAO DE TEMPO E ATIVIDADE DA PROTROMBINA (TAP)	0	1571	0202020142	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
5068fde5-1ffd-4e91-bff4-b5da6cba7570	225	DETERMINACAO DE VELOCIDADE DE HEMOSSEDIMENTACAO (VHS)	0	1571	0202020150	202402	1	1	2	2	9	95	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
2bdb842b-8810-4060-8a20-98aa0288700d	272	DETERMINACAO QUANTITATIVA DE PROTEINA C REATIVA	0	1571	0202030083	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.271000+00:00	2021-05-25T19:39:57.271000+00:00
f0bb1d74-f97a-40b1-9056-1a1ebcbcdad3	585	DOSAGEM DE 17 HIDROXI PROGESTERONA EM PAPEL DE FILTRO (COMPONENTE DO TESTE DO PEZINHO)	0	1	0202110095	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
b1235c5e-a4e0-4e38-acf5-895693737d3c	586	DOSAGEM DA ATIVIDADE DA BIOTINIDASE EM AMOSTRAS DE SANGUE EM PAPEL DE FILTRO (COMPONENTE DO TESTE DO PEZINHO)	0	1	0202110109	202402	1	1	2	2	9	270	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
c7e774e9-29bc-4d63-9e3c-c9397314cc17	141	DOSAGEM DE 5-NUCLEOTIDASE	0	1571	0202010090	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00
2d886472-e51c-4d72-8922-85ace83bd89c	142	DOSAGEM DE ACETONA	0	1571	0202010104	202402	1	1	2	2	9	4	1	<span class="null">NULL</span>	1	CLINICO	0	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.271000+00:00	2021-05-25T19:39:57.271000+00:00