Table Source: Internally created in the Hospital Clinic HIS system.

Table Purpose: The lab_events_dic table aims to store specific data related to laboratory events, providing an organized structure for management and retrieval.

Links to: There are no direct links to other tables as this table focuses on independent laboratory events.

Brief Summary

The lab_events_dic table has been created to record crucial information about laboratory events in the Hospital Clinic HIS. Each entry contains a laboratory reference (lab_ref), a detailed description of the event (descr), and associated units of measurement (units).

Table Columns

Column Name	Data Type	Description
lab_ref	BIGINT	Unique laboratory reference (BIGINT).
descr	VARCHAR(255)	Detailed description of the laboratory event (VARCHAR(255)).
units	VARCHAR(255)	Units of measurement associated with the laboratory event (VARCHAR(255)).

| lab_ref| descr | units | |-------|----------------------------------------+--------------| | 100001| Ac IgM antibeta 2 glicoproteico | MPL | | 100002| Acido folico serum | ng/mL | | 100003| Acido urico plasma | mg/dL | | 100004| AFP Alfafetoproteina | ng/mL | | 100005| ALAT Alanin aminotransferasa | U/L | | 100006| Albumina | g/L | | 100007| Albumina proteina % serum | % | | 100008| Amilasa | U/L | | 100009| Anion Gap sangre venosa | mmol/L | | 100010| Anion Gap sangre arterial | mmol/L | | 100011| Anticuerpos antiDNA bicatenario | UI o UI/mL | | 100012| Anticuerpos antiperoxidasa | UI/mL | | 100013| Antigeno CA-125 | U/mL | | 100014| Antigeno CA-153 | U/mL | | 100015| Antigeno CA-19.9 | U/mL | | 100016| Antigeno CA 19.9 liquido | U/mL | | 100017| Antigeno prostatico especifico | ng/mL | | 100018| Apolipoproteina B | mg/dL | | 100019| ASA aspartat aminotransferasa | U/L | | 100020| Basofilos % analizado | % | | 100021| Basofilos % manual | % | | 100022| Basofilos absolutos analizado | 10^9/L | | 100023| Basofilos absolutos manual | 10^9/L | | 100024| bhCG Gonadotropina corionica | UI/L | | 100025| Bicarbonato actual, sangre venosa | mmol/L | | 100026| Bicarbonato actual, sangre arterial | mmol/L | | 100027| Bicarbonato estandard, sangre arterial | mmol/L | | 100028| Bicarbonato estandard, sangre venosa | mmol/L | | 100029| Bilirrubina directa | mg/dL | | 100032| Bilirrubina indirecta | mg/dL | | 100033| Bilirrubina neonatal capilar | mg/dL | | 100034| Bilirrubina adulto total | mg/dL | | 100035| BUN | mg/dL | | 100036| Cadenas ligeras Lambda libre | mg/L | | 100037| Calcio | mg/dL | | 100038| Calcio ionizado sangre venosa | mmol/L | | 100039| Calcio ionizado sangre arterial | mmol/L | | 100040| Carboxihemoglobina | % | | 100041| CCMH concentraciion corpuscal media | g/L | | 100042| CD3 linfocitos % sangre total | % | | 100043| CD3 valor absoluto sangre total | Cels/µL | | 100044| CD4 linfocitos % sangre total | % | | 100045| CD4 valor absoluto sangre total | Cels/µL | | 100046| CD8 valor absoluto sangre total | Cels/µL | | 100047| CD8 linfocitos % sangre total | % | | 100048| CEA antigeno carcinoembrionario | ng/mL | | 100049| Celulas NK | % | | 100050| Celulas NK totales | Cels/µL | | 100051| CH50 | U/mL | | 100052| CHCM concentracion hemoglobina | g/L | | 100053| CKMB creatin quinasa MB | U/L | | 100055| Cloruro, sangre | mEq/L | | 100056| CO2 determinacion | mmol/L | | 100057| CO2 total sangre arterial | mmol/L | | 100058| Cociente microalbumina/creatinina | mg/g | | 100059| Colesterol LDL | mg/dL | | 100061| Colesterol total | mg/dL | | 100062| Colesterol HDL | mg/dL | | 100063| Cortisol serum | µg/dL o µg/dL| | 100064| Creatinina sangre | mg/dL | | 100065| Creatinina orina 24h | mg/24h | | 100066| Creatinina aclaramiento | ml/min | | 100067| Creatinina orina | mg/dL | | 100068| Creatinina quinasa | U/L | | 100069| Coeficiente calcio/creatinina | mg/g | | 100070| Coeficiente proteinas/Creatinina | mg/g | | 100071| Densidad orina | g/mL | | 100072| Dimero D cuantitativo serum | ng/mL | | 100073| Enolasa neuronal especifica | ng/mL | | 100074| Eosinofilos % analizado | % | | 100075| Eosinofilos % manual | % | | 100076| Eosinofilos absolutos analizado | 10^9/L | | 100077| Eosinofilos absolutos manual | 10^9/L | | 100078| Exceso de base sangre venosa | mmol/L | | 100079| Exceso de base sangre arterial | mmol/L | | 100080| Excrecion calcio | mg/24h | | 100081| Factor C3 complemento | g/L | | 100082| Factor C4 complemento | g/L | | 100083| Factor reumatoide serum | U/mL | | 100084| Ferritina | ng/mL | | 100085| Fibrinogeno | g/L | | 100086| Filtrado glomerular calculado | ml/min/1,73m2 | | 100087| Fosfatasa alcalina | U/L | | 100088| Fosforo, plasma | mg/dL | | 100089| Fosforo orina 24h | mg/24h | | 100090| Gamma glutamil transpeptidasa | U/L | | 100091| Globulina ligado hormonas | nmol/L | | 100092| Glucosa, sangre | mg/dL | | 100093| Glucosa orina 24h | mg/24h | | 100094| Haptoglobina serum | g/L | | 100095| HCM hb corpusclar media | pg | | 100096| HDW hb distributiva media | g/L | | 100097| Hematias sedimiento | U/campo | | 100098| Hematias recuento | 10^12/L | | 100099| Hematias hipocromas % | % | | 100100| Hematocrito sangre | % | | 100101| Hemoglobina sangre | g/dl | | 100102| Hemoglobina concentracion | g/L | | 100103| Hemoglobina concentracion retic | pg | | 100104| Hemoglobina glicada sangre total | % | | 100107| Hierro | µg/dL | | 100108| Homocisteina basal | µmol/L | | 100109| IGE total serum | kU/L | | 100110| IgG antibeta 2 glicoproteina | CU o GPL | | 100111| IgG dosificacion serum | g/L | | 100112| Immunoglobulina IgA serum | g/L | | 100113| Immunoglobulina IgM serum | g/L | | 100114| Insulina IRI serum | mU/L | | 100115| KAPPA cadenas ligeras libre | mg/L | | 100116| Lactato, sangre | mg/dL | | 100117| Lactato LDH | U/L | | 100118| Leucocitos sedimiento | U/campo | | 100119| Leucocitos recuento | 10^9/L | | 100120| Linfocitos % analizado | % | | 100121| Linfocitos % manual | % | | 100122| Linfocitos absoluto analizado | 10^9/L | | 100123| Linfocitos absoluto manual | 10^9/L | | 100124| Lipasa | U/L | | 100125| LPA | mg/dL | | 100126| LUC % analizado | % | | 100127| LUC absoluto analizado | 10^9/L | | 100128| Macrocitos | % | | 100129| Microcitos | % | | 100130| Magnesio orina reciente | mg/dL | | 100131| Magnesio | mg/dL | | 100132| Metahemoglobina, sangre | % | | 100133| Microalbumina orina reciente | mg/L | | 100134| Microalbuminuria | mg/24h | | 100135| Microglobulina beta 2 | mg/L | | 100136| Monocitos % analizado | % | | 100137| Monocitos % manual | % | | 100138| Monocitos absoluto analizado | 10^9/L | | 100139| Monocitos absoluto manual | 10^9/L | | 100140| Neutrofilos % analizado | % | | 100141| Neutrofilos % manual no segmentado | % | | 100142| Neutrofilos % manual segmentado | % | | 100143| Neutrofilos absoluto analizado | 10^9/L | | 100144| Neutrofilos absoluto manual | 10^9/L | | 100145| NT-proBNP plasma | pg/mL | | 100147| NTX telopeptido N colageno | nMol/mMol | | 100148| Oncoproteina HER-2 NEU serum | ng/mL | | 100149| Osmolalidad | mOsm/kg | | 100150| Osmolalidad urinaria | mOs/kg | | 100151| Oxihemoglobina fraccion sangre | % | | 100152| pCO2 sangre venosa | mmHg | | 100153| pCO2 sangre arterial | mmHg | | 100154| pO2 sangre venosa | mmHg | | 100155| pO2 sangre arterial | mmHg | | 100156| PCR | mg/dL | | 100157| PCR ultrasensible | mg/dL | | 100158| PDW Platelet Distribut Width | % | | 100159| Plaquetas recuento | 10^9/L | | 100160| Potasio, sangre | mEq/L | | 100161| Potasio orina 24h | mEq/L | | 100162| Prealbumina serum | g/L | | 100163| PRL prolactina serum | ng/mL | | 100164| Procalcitonina serum | ng/mL | | 100165| Procalcitonina plasma | ng/mL | | 100166| Pro-gastrin releasing peptide | pg/mL | | 100167| Propeptido n colageno | ng/mL | | 100168| Proteina C funcional plasma | % | | 100169| Proteinas orina 24h | mg/24h | | 100170| Proteinas orina reciente | mg/L | | 100171| Proteinas totales | g/L | | 100172| Proteinas Alfa 1 glob % serum | % | | 100173| Proteinas Alfa 2 glob % serum | % | | 100174| Proteinas beta glob % serum | % | | 100175| Proteinas gamma glob % serum | % | | 100176| Proteina S libre plasma | % | | 100177| Proteina S100 | µg/L | | 100178| PSA libre | % | | 100179| PTH parathormona serum | pg/mL | | 100180| RDW Reed Distribut Width | % | | 100181| Receptor soluble transfe | mg/L | | 100182| Reticulocitos % alta fluor | % | | 100183| Reticulocitos % manual | % | | 100184| Reticulocitos % baja fluor | % | | 100185| Reticulocitos % media fluor | % | | 100186| Reticulocitos absoluta manual | 10^9/L | | 100187| Saturacion de oxigeno % sangre venosa | % | | 100188| Saturacion de oxigeno % sangre arterial| % | | 100189| SCC | ng/mL | | 100190| Sodio, sangre | mmol/L | | 100191| Tacròlimus FK506 | ng/mL | | 100192| TCO2 arterial | mmol/L | | 100193| TCO2 venosa | mmol/L | | 100194| Testosterona directa serum | ng/dL | | 100195| Tiempo de protombina segundos | seg | | 100196| Tiempo de protombina % | % | | 100197| Tiempo de tromboplastina parcial | seg | | 100198| Tiroglobulina serum | ng/mL | | 100199| Tirotropina serum | mUI/L | | 100200| Tiroxina libre serum | ng/dL | | 100201| Transferrina |g/L | | 100202| Saturación transferrina, serum |NA | | 100203| Trigliceridos |mg/dL | | 100204| Triodetironina serum |ng/mL | | 100205| Troponina alta sensibilidad |ng/L | | 100206| Urea |mg/dL | | 100207| VCM |fl | | 100208| Vitamina B1 |ng/mL | | 100209| Vitamina B12 |pg/mL | | 100210| Vitamina B6 |nmol/L | | 100211| Vitamina D3 1,25 hidroxi serum |pg/mL | | 100212| Vitamina D3 25 hidroxi serum |ng/mL | | 100213| Volumen minuto |ml/min | | 100214| VPM Volumen Plaquetario Medio |fl | | 100215| VSG velocidad sedimentacion golbular |mm/h | | 100216| Zinc |µg/dL |