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
ae40ae6c-a7d1-4d9c-9e94-7c88b5420ec4	282	DOSAGEM DE IMUNOGLOBULINA M (IGM)	0	1571	0202030180	202402	1	1	2	2	9	134	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
f4548e3e-ff69-4fe0-9bdd-e97cc58e6c30	283	DOSAGEM DE INIBIDOR DE C1-ESTERASE	0	1571	0202030199	202402	1	1	2	2	9	134	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
eaaaf417-1d1f-4399-809b-ed9d8728cd7f	175	DOSAGEM DE FOSFORO	0	1571	0202010430	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
d564bef0-7729-4894-b5d7-7c3f9e8496cc	176	DOSAGEM DE FRACAO PROSTATICA DA FOSFATASE ACIDA	0	1571	0202010449	202402	1	0	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
8922196f-358d-4e27-992c-561b30188c2a	177	DOSAGEM DE GALACTOSE	0	1571	0202010457	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
185a7c0a-02d9-4041-ac37-e37b2e3dd6a4	178	DOSAGEM DE GAMA-GLUTAMIL-TRANSFERASE (GAMA GT)	0	1571	0202010465	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
9a8f6ec1-d6dc-4dc1-87b8-ba71a9236f7d	180	DOSAGEM DE GLICOSE-6-FOSFATO DESIDROGENASE	0	1571	0202010481	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
72cffd1d-2f8b-4449-9488-f31d707cff8f	385	DOSAGEM DE GORDURA FECAL	0	1571	0202040020	202402	1	1	2	2	9	167	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
740871ae-919f-4f88-91b9-79366ad9a707	409	DOSAGEM DE MICROALBUMINA NA URINA	0	1571	0202050092	202402	1	1	2	2	9	190	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
ee7cc52e-160c-4127-8bc5-e017679dbb75	410	DOSAGEM DE OXALATO	0	1571	0202050106	202402	1	1	2	2	9	190	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
2e501eea-b980-4e7c-9b90-d866acb17ea5	451	DOSAGEM DE GASTRINA	0	1571	0202060195	202402	1	1	2	2	9	210	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
0633f9b2-afda-4cbc-b2f1-8db10d6160f6	452	DOSAGEM DE GLOBULINA TRANSPORTADORA DE TIROXINA	0	1571	0202060209	202402	1	1	2	2	9	210	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
e112d306-6de2-4c95-a011-9daca7685e94	453	DOSAGEM DE GONADOTROFINA CORIONICA HUMANA (HCG, BETA HCG)	0	1571	0202060217	202402	1	1	2	2	9	210	0	<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
0299a121-2d65-4a7f-b307-fa6777e410fa	454	DOSAGEM DE HORMONIO DE CRESCIMENTO (HGH)	0	1571	0202060225	202402	1	1	2	2	9	210	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
26cf6238-17e8-47f5-920e-a8a5eb605c6a	455	DOSAGEM DE HORMONIO FOLICULO-ESTIMULANTE (FSH)	0	1571	0202060233	202402	1	1	2	2	9	210	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
cfccc72e-909a-47a7-b066-a59a05c497ea	456	DOSAGEM DE HORMONIO LUTEINIZANTE (LH)	0	1571	0202060241	202402	1	1	2	2	9	210	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
ce96b3eb-d5d1-4e12-8fee-557ad6f41725	457	DOSAGEM DE HORMONIO TIREOESTIMULANTE (TSH)	0	1571	0202060250	202402	1	1	2	2	9	210	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
a0755db9-b41b-403c-94f0-f1a12d485d77	458	DOSAGEM DE INSULINA	0	1571	0202060268	202402	1	1	2	2	9	210	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
28ff62fd-6c38-47c5-bd06-c18e776511ce	459	DOSAGEM DE PARATORMONIO	0	1571	0202060276	202402	1	1	2	2	9	210	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
a4892dad-7325-4b0e-850f-36c480fb7b00	460	DOSAGEM DE PEPTIDEO C	0	1571	0202060284	202402	1	1	2	2	9	210	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
722e95f0-a444-448a-bcd4-1056cfa9b69d	508	DOSAGEM DE METOTREXATO	0	1571	0202070298	202402	1	1	2	2	9	227	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
379f6c60-39c3-4c2a-a3ba-cdd451170aa0	549	DOSAGEM DE FRUTOSE NO ESPERMA	120	1571	0202090116	202402	1	0	2	2	9	248	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
7cdf9e6c-8a5a-42a1-8fbb-cf1bb9b673d6	509	DOSAGEM DE QUINIDINA	0	1571	0202070301	202402	1	1	2	2	9	227	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
edc1b11f-6635-4da4-91d8-1037a1622363	3458	DOSAGEM DE SIROLIMO (EM PACIENTE TRANSPLANTADO)	0	1571	0501080040	202402	1	1	2	5	7	241	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
19a61806-a71d-4c18-8f02-de9a7a61577b	3459	DOSAGEM DE TACROLIMO (EM PACIENTE TRANSPLANTADO)	0	1571	0501080058	202402	1	1	2	5	7	241	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.272000+00:00	2021-05-25T19:39:57.272000+00:00
3ff69a34-3f94-4db0-ad31-edc76c311fe1	552	DOSAGEM DE SODIO E CLORO NO SUOR (C/ COLETA)	0	1571	0202090140	202402	1	1	2	2	9	248	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
e982173d-635e-4a40-bb8c-e6469e1fda7d	3860	ACITRETINA 25 MG (POR CAPSULA)	0	1571	0604600020	202402	1	1	3	6	26	363	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.264000+00:00	2021-05-25T19:39:57.264000+00:00
5eb82ef8-ebde-406b-9ff4-0c5c628f2659	584	DOSAGEM DE TSH E T4 LIVRE (CONTROLE / DIAGNOSTICO TARDIO)	0	1571	0202110087	202402	1	1	2	2	9	270	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
156c74ca-9ffd-4891-9e72-c5a9a0df12f6	195	DOSAGEM DE SODIO	0	1571	0202010635	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
2b5ca863-5dda-4137-ade7-f7ff38817c8b	551	DOSAGEM DE PROTEINAS NO LIQUIDO SINOVIAL E DERRAMES	0	1571	0202090132	202402	1	1	2	2	9	248	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
e301f517-2b45-43e6-82be-c2c87d8ab6e7	468	DOSAGEM DE TIREOGLOBULINA	0	1571	0202060365	202402	1	1	2	2	9	210	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
88bebe54-7c5d-4704-83f8-1fc045ac59af	514	DOSAGEM DE ZINCO	0	1571	0202070352	202402	1	1	2	2	9	227	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
82f77b83-7c4f-4c92-8f52-c39ecc7e1f58	284	DOSAGEM DE PROTEINA C REATIVA	0	1571	0202030202	202402	1	1	2	2	9	134	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
4dca2259-db5f-483d-92dd-b2494e3589c1	192	DOSAGEM DE POTASSIO	0	1571	0202010600	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
1dd9636d-4d72-40fb-881e-8e2928211212	191	DOSAGEM DE PORFIRINAS	0	1571	0202010597	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
8ad37ec6-2fce-49d7-987c-4e163f8c32f6	194	DOSAGEM DE PROTEINAS TOTAIS E FRACOES	0	1571	0202010627	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
e591120b-6d46-4c8d-8cf7-f70b813c555e	196	DOSAGEM DE TRANSAMINASE GLUTAMICO-OXALACETICA (TGO)	0	1571	0202010643	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
cdc71f3d-4db2-4df1-a400-d96fbda9bc73	197	DOSAGEM DE TRANSAMINASE GLUTAMICO-PIRUVICA (TGP)	0	1571	0202010651	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
a0fbc25c-9a48-4b44-bbdd-bf816f66d962	383	DOSAGEM DO ANTÍGENO CA 125	228	1571	0202031217	202402	1	1	2	2	9	134	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
c1ebcf8e-d2cf-45f2-ad4b-7cf4ef15d104	382	DOSAGEM DE TROPONINA	0	1571	0202031209	202402	1	1	2	2	9	134	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
c67fb2b2-d148-428b-86b0-d543867db337	411	DOSAGEM DE PROTEINAS (URINA DE 24 HORAS)	0	1571	0202050114	202402	1	1	2	2	9	190	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
30b5595e-8d0d-42c8-b527-31f1af5cf94e	412	DOSAGEM E/OU FRACIONAMENTO DE ACIDOS ORGANICOS	0	1571	0202050122	202402	1	1	2	2	9	190	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
5124d705-041d-4c0d-8d5b-c79b96814d80	461	DOSAGEM DE PROGESTERONA	0	1571	0202060292	202402	1	1	2	2	9	210	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
9842e49d-fb93-4727-8446-818bd9d798af	462	DOSAGEM DE PROLACTINA	0	1571	0202060306	202402	1	1	2	2	9	210	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
81ec59cd-b52a-4cae-a2d6-fdec2a637400	463	DOSAGEM DE RENINA	0	1571	0202060314	202402	1	1	2	2	9	210	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
0fb32b15-b0a1-4084-9a3f-2d552c342ced	464	DOSAGEM DE SOMATOMEDINA C (IGF1)	0	1571	0202060322	202402	1	1	2	2	9	210	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
af004fed-c300-4fa8-b369-dcd644db6c83	465	DOSAGEM DE SULFATO DE HIDROEPIANDROSTERONA (DHEAS)	0	1571	0202060330	202402	1	1	2	2	9	210	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
69562350-38ec-4502-870a-3e9a662da8f2	466	DOSAGEM DE TESTOSTERONA	0	1571	0202060349	202402	1	1	2	2	9	210	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
c690db3d-af56-4b5a-afaf-2424cccf911a	467	DOSAGEM DE TESTOSTERONA LIVRE	0	1571	0202060357	202402	1	1	2	2	9	210	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
6dcb6cc4-a9ec-49b7-ba76-690b64f45d4b	469	DOSAGEM DE TIROXINA (T4)	0	1571	0202060373	202402	1	1	2	2	9	210	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