FQL is a query language that allows you to retrieve, filter and project data from any data source containing FHIR Resources. It brings the power of three existing languages together: SQL, JSON and FhirPath. It allows you to create tables and is useful for gaining insight and perform quality control.
Mapping from http://hl7.org/fhir/ValueSet/v2-0487 to http://snomed.info/id?fhir_vs
| Source Concept | Equivalence | Destination Concept | Comment | |||
| Code [http://hl7.org/fhir/v2/0487] | Code [http://snomed.info/sct] | TypeModifier [http://snomed.info/sct] | http://snomed.info/id/246380002 [http://snomed.info/sct] | http://snomed.info/id/3006873018 [http://snomed.info/sct] | ||
| ACNE | :(Equivalent) | 309068002 | ||||
| ACNFLD | :(Equivalent) | 119323008 | 47002008 | HL7 term is a historical term. mapped to Pus | ||
| AIRS | :(Equivalent) | 446302006 | ||||
| ALL | :(Equivalent) | 119376003 | 7970006 | |||
| AMP | :(Equivalent) | 408654003 | 81723002 | |||
| ANGI | :(Equivalent) | 119312009 | TBD in detail | |||
| ARTC | :(Equivalent) | 119312009 | TBD in detail | |||
| ASERU | :Unmatched | pending | ||||
| ASP | :(Equivalent) | 119295008 | 14766002 | |||
| ATTE | :Unmatched | TBD | ||||
| AUTOC | :Unmatched | TBD | ||||
| AUTP | :Unmatched | This really is not a specimen per se - it is the state of the subject from whom the specimen is collected, so it should be used as a specimen type modifier ONLY!. Often this is indicated with a special medical record number or other notation on the patient. needs to have specimen type (e.g. SPM-4) and source site (SPM.8) and spatial orientation (SPM.9) | ||||
| BBL | :(Equivalent) | 119304001 | ||||
| BCYST | :Unmatched | 32361000 | submitted (PLR155) with parent of 167874004^knee joint synovial fluid (specimen), with specimen source topography 32361000^Popliteal fossa structure (body structure) | |||
| BITE | :Unmatched | Submit for new term with parent 119365002 | ||||
| BLEB | :(Equivalent) | 309049000 | 339008 | |||
| BLIST | :(Equivalent) | 309049000 | 339008 | |||
| BOIL | :(Equivalent) | 119295008 | 59843005 | 14766002 | ||
| BON | :(Equivalent) | 430268003 | ||||
| BOWL | :Unmatched | Don't use this term for human samples - use Stool instead. animal would use small intestinal contents, large intestinal contents | ||||
| BPU | :(Equivalent) | 119300005 | ||||
| BRN | :(Equivalent) | 119367005 | ||||
| BRSH | :(Equivalent) | 258415003 | 439336003 | |||
| BRTH | :(Equivalent) | 119336008 | ||||
| BRUS | :(Equivalent) | 309176002 | 80657008 | |||
| BUB | :(Equivalent) | 302795002 | 11585000 | 14766002 | ||
| BULLA | :(Equivalent) | 258482009 | 339008 | |||
| BX | :(Equivalent) | 258415003 | 86273004 | |||
| CALC | :(Equivalent) | 119350003 | ||||
| CARBU | :(Equivalent) | 309051001 | 41570003 | |||
| CAT | :(Equivalent) | 119311002 | ||||
| CBITE | :Unmatched | Submit for new term with parent 119365002 | ||||
| CLIPP | :(Equivalent) | 119327009 | Be more specific use either: 119326000^hair specimen or 119327009^nail specimen | |||
| CNJT | :(Equivalent) | 119401005 | ||||
| CNJT | :(Equivalent) | 128160006 | ||||
| CNJT | :(Equivalent) | 258498002 | ||||
| COL | :(Equivalent) | 119329007 | ||||
| CONE | :(Equivalent) | 399713008 | 54535009 | 71252005 | ||
| CSCR | :Unmatched | submit for new term with parent 119365002^Specimen from wound (specimen) | ||||
| CSERU | :Unmatched | pending | ||||
| CSITE | :(Equivalent) | 258507003 | 386144009 | 285570007 | Prefer to have aspirate of the pus oozing out from cleaned insertion site - if swab is all that can be obtained, then swab after cleaning, otherwise you may get a contaminated specimen and a falsely identified infected central line. Do not just swab the reddened area - that will just collect skin flora | |
| CSMY | :(Equivalent) | 309051001 | ||||
| CST | :(Equivalent) | 258453008 | ||||
| CSVR | :Unmatched | TBD - may use blood and SPM-6 | ||||
| CTP | :(Equivalent) | 119312009 | TBD in detail | |||
| CVPS | :(Equivalent) | 258507003 | ||||
| CVPT | :(Equivalent) | 119312009 | 445085009 | TBD in detail | ||
| CYN | :(Equivalent) | 119368000 | 27925004 | |||
| CYST | :(Equivalent) | 119368000 | ||||
| DBITE | :Unmatched | Submit for new term with parent 119365002 | ||||
| DCS | :(Equivalent) | 119335007 | ||||
| DEC | :(Equivalent) | 258505006 | ||||
| DEION | :Unmatched | TBD | ||||
| DIA | :(Equivalent) | 119360007 | ||||
| DISCHG | :(Equivalent) | 258439008 | ||||
| DIV | :(Equivalent) | 119376003 | 31113003 | |||
| DRN | :(Equivalent) | 119306004 | ||||
| DRNG | :(Equivalent) | 258455001 | 122462000 | Historical term - consider what is being drained and indicate that in SPM-4 instead: not an acceptable specimen for micro - not specific enough term | ||
| DRNGP | :(Equivalent) | 309051001 | 122462000 | Historical term - consider what is being drained and indicate that in SPM-4 instead | ||
| EARW | :(Equivalent) | 122580007 | ||||
| EBRUSH | :(Equivalent) | 309210009 | 36213007 | 32849002 | ||
| EEYE | :Unmatched | TBD | ||||
| EFF | :Unmatched | TBD | ||||
| EFFUS | :(Equivalent) | 258440005 | ||||
| EFOD | :(Equivalent) | 119320006 | ||||
| EISO | :(Equivalent) | 258536003 | ||||
| ELT | :(Equivalent) | 119314005 | ||||
| ENVIR | :(Equivalent) | 119324002 | ||||
| EOTH | :Unmatched | TBD | ||||
| ESOI | :Unmatched | TBD | ||||
| ESOS | :Unmatched | TBD | ||||
| ETA | :(Equivalent) | 119307008 | 14766002 | 321667001 | ||
| ETTP | :(Equivalent) | 119312009 | TBD in detail | |||
| ETTUB | :(Equivalent) | 119307008 | 14766002 | 321667001 | ||
| EWHI | :Unmatched | TBD | ||||
| EXG | :(Equivalent) | 119336008 | ||||
| EXS | :Unmatched | TBD | ||||
| EXUDTE | :(Equivalent) | 258441009 | ||||
| FAW | :Unmatched | TBD | ||||
| FBLOOD | :(Equivalent) | 119297000 | 303112003 | |||
| FGA | :(Equivalent) | 168139001 | 83670000 | |||
| FIST | :(Equivalent) | 119370009 | ||||
| FLD | :(Equivalent) | 309051001 | ||||
| FLT | :Unmatched | TBD | ||||
| FLU | :(Equivalent) | 309051001 | ||||
| FLUID | :(Equivalent) | 258442002 | ||||
| FOLEY | :(Equivalent) | 119312009 | TBD in detail | |||
| FRS | :(Equivalent) | 258442002 | 272626006 | this term is not specific enough, choose from terms that more accurately describe the specimen | ||
| FSCLP | :(Equivalent) | 309502007 | 41695006 | |||
| FUR | :(Equivalent) | 119295008 | 59843005 | Further describe the sample as tissue or pus. or by the collection method. The term boil is not specifc to a body site - need to indicate source site (spm.8). preferred term is Aspirate_Boil | ||
| GAS | :(Equivalent) | 119317003 | ||||
| GASA | :(Equivalent) | 168137004 | 14766002 | 69695003 | ||
| GASAN | :(Equivalent) | 119379005 | 66051006 | |||
| GASBR | :(Equivalent) | 309213006 | 235157009 | 69695003 | ||
| GASD | :(Equivalent) | 258459007 | 122462000 | 69695003 | Historical term - consider what is being drained and indicate that in SPM-4 instead | |
| GAST | :(Equivalent) | 258459007 | ||||
| GENV | :(Equivalent) | 119394009 | ||||
| GRAFT | :(Equivalent) | 440493002 | ||||
| GRANU | :(Equivalent) | 119376003 | 45647009 | |||
| GROSH | :(Equivalent) | 119311002 | TBD in detail | |||
| GSOL | :Unmatched | TBD | ||||
| GSPEC | :(Equivalent) | 309211008 | 79121003 | 69695003 | ||
| GT | :Unmatched | TBD | ||||
| GTUBE | :(Equivalent) | 258459007 | 127490009 | 122462000 | 69695003 | Historical term - consider what is being drained and indicate that in SPM-4 instead |
| HBITE | :Unmatched | Submit for new term with parent 119365002 | ||||
| HBLUD | :(Equivalent) | 119297000 | 303113008 | |||
| HEMAQ | :(Equivalent) | 119312009 | TBD in detail | |||
| HEMO | :(Equivalent) | 119312009 | TBD in detail | |||
| HERNI | :(Equivalent) | 119376003 | ||||
| HEV | :(Equivalent) | 119306004 | ||||
| HIC | :(Equivalent) | 119312009 | 445085009 | TBD in detail | ||
| HYDC | :(Equivalent) | 309051001 | 55434001 | |||
| IBITE | :Unmatched | Submit for new term with parent 119365002 | ||||
| ICYST | :(Equivalent) | 309075001 | ||||
| IDC | :(Equivalent) | 119312009 | TBD in detail | |||
| IHG | :(Equivalent) | 119337004 | ||||
| ILEO | :(Equivalent) | 258455001 | 419954003 | Historical term - consider what is being drained and indicate that in SPM-4 instead: stool is what is expected, should use stool sample | ||
| ILLEG | :Unmatched | TBD | ||||
| IMP | :(Equivalent) | 439961009 | ||||
| INCI | :(Equivalent) | 438660002 | ||||
| INFIL | :Unmatched | This describes a morphologic abnormality, not a sample | ||||
| INS | :(Equivalent) | 258614005 | ||||
| INTRD | :(Equivalent) | 119312009 | TBD in detail | |||
| IT | :(Equivalent) | 119307008 | ||||
| IUD | :Unmatched | pending | ||||
| IVCAT | :(Equivalent) | 119312009 | 255560000 | TBD in detail | ||
| IVFLD | :(Equivalent) | 258649003 | ||||
| IVTIP | :(Equivalent) | 119312009 | ||||
| JEJU | :(Equivalent) | 258463000 | 122462000 | 21306003 | Historical term - consider what is being drained and indicate that in SPM-4 instead: stool is what is expected, should use stool sample | |
| JNTFLD | :(Equivalent) | 119332005 | ||||
| JP | :(Equivalent) | 309051001 | 122462000 | Historical term - consider what is being drained and indicate that in SPM-4 instead | ||
| KELOI | :(Equivalent) | 440674008 | 67889009 | |||
| KIDFLD | :(Equivalent) | 309051001 | 64033007 | |||
| LAVG | :(Equivalent) | 258607008 | 397394009 | |||
| LAVGG | :(Equivalent) | 168138009 | 173830003 | 69695003 | ||
| LAVGP | :(Equivalent) | 440137008 | ||||
| LAVPG | :(Equivalent) | 440674008 | 67889009 | 44567001 | ||
| LENS1 | :(Equivalent) | 440473005 | ||||
| LENS2 | :Unmatched | TBD | ||||
| LESN | :(Equivalent) | 309049000 | should be more specific what kind of lesion is observed - be more specific is it a wound, abscess, mass - specify! Ask SNOMED CT to mark it as a grouper term only (309049000) | |||
| LIQ | :(Equivalent) | 258442002 | ||||
| LIQO | :Unmatched | TBD | ||||
| LSAC | :(Equivalent) | 258450006 | 303949008 | The HL7 term is a historical term Mapped to CSF obtained by lumbar puncture | ||
| MAHUR | :(Equivalent) | 119312009 | TBD in detail | |||
| MASS | :(Equivalent) | 420548004 | 4147007 | |||
| MBLD | :(Equivalent) | 119345009 | ||||
| MUCOS | :(Equivalent) | 119376003 | 414781009 | |||
| MUCUS | :(Equivalent) | 258483004 | ||||
| NASDR | :(Equivalent) | 258474009 | 122462000 | 2095001 | Historical term - consider what is being drained and indicate that in SPM-4 instead | |
| NEDL | :Unmatched | TBD | ||||
| NEPH | :(Equivalent) | 438660002 | ||||
| NGASP | :(Equivalent) | 302794003 | 6853008 | 69695003 | ||
| NGAST | :(Equivalent) | 258459007 | 127492001 | 122462000 | 69695003 | Historical term - consider what is being drained and indicate that in SPM-4 instead |
| NGS | :(Equivalent) | 438660002 | ||||
| NODUL | :Unmatched | pending | ||||
| NSECR | :(Equivalent) | 168141000 | ||||
| ORH | :(Equivalent) | 123038009 | ||||
| ORL | :Unmatched | 74262004 | be more precise use ulcer, tumor, vesicle | |||
| OTH | :(Equivalent) | 123038009 | ||||
| PACEM | :Unmatched | TBD | ||||
| PCFL | :(Equivalent) | 122571007 | ||||
| PDSIT | :(Equivalent) | 438660002 | ||||
| PDTS | :Unmatched | submitted for code | ||||
| PELVA | :(Equivalent) | 119371008 | 12921003 | |||
| PENIL | :Unmatched | 18911002 | need to know what kind of lesion, so map to: UlcerTissue_penile, VesicleFluid_penile, Wound_penile, Mass tissue_penile, Necrotic tissue_penile, AbscessAspirate_penile, Anything else? | |||
| PERIA | :(Equivalent) | 119371008 | 397158004 | |||
| PILOC | :(Equivalent) | 119368000 | ||||
| PINS | :(Equivalent) | 438660002 | ||||
| PIS | :(Equivalent) | 258507003 | ||||
| PLAN | :(Equivalent) | 119301009 | ||||
| PLAS | :(Equivalent) | 119361006 | ||||
| PLB | :(Equivalent) | 119305000 | ||||
| PLEVS | :(Equivalent) | 119364003 | 255587001 | |||
| PND | :(Equivalent) | 258439008 | 122462000 | 13648007 | Historical term -though in this case more often used for discharge | |
| POL | :(Equivalent) | 119376003 | 41329004 | |||
| POPGS | :(Equivalent) | 440493002 | 6902008 | |||
| POPLG | :(Equivalent) | 440493002 | 6902008 | |||
| POPLV | :Unmatched | TBD | ||||
| PORTA | :(Equivalent) | 119311002 | TBD in detail | |||
| PPP | :(Equivalent) | 119362004 | ||||
| PROST | :(Equivalent) | 438660002 | ||||
| PRP | :(Equivalent) | 119363009 | ||||
| PSC | :(Equivalent) | 119368000 | ||||
| PUNCT | :(Equivalent) | 119365002 | 129300006 | |||
| PUS | :(Equivalent) | 119323008 | ||||
| PUSFR | :(Equivalent) | 119323008 | 47002008 | |||
| PUST | :(Equivalent) | 119323008 | 47002008 | |||
| QC3 | :Unmatched | TBD | ||||
| RANDU | :(Equivalent) | 278020009 | ||||
| RBITE | :Unmatched | Submit for new term with parent: 119365002 | ||||
| RECT | :(Equivalent) | 119339001 | 122462000 | 34402009 | Historical term - consider what is being drained and indicate that in SPM-4 instead: stool is what is expected, should use stool sample | |
| RECTA | :(Equivalent) | 119371008 | 34402009 | |||
| RENALC | :(Equivalent) | 258420003 | 64033007 | |||
| RENC | :(Equivalent) | 258453008 | 64033007 | |||
| RES | :(Equivalent) | 258603007 | ||||
| SAL | :(Equivalent) | 119342007 | ||||
| SCAR | :(Equivalent) | 119376003 | ||||
| SCLV | :(Equivalent) | 119312009 | 9454009 | TBD in detail | ||
| SCROA | :(Equivalent) | 119371008 | 20233005 | |||
| SECRE | :(Equivalent) | 432825001 | ||||
| SER | :(Equivalent) | 119364003 | ||||
| SHU | :(Equivalent) | 119295008 | 257351008 | 14766002 | Preferred is aspiration with sterile syringe from inflamed area. Specify body location of shunt site | |
| SHUNF | :(Equivalent) | 446861007 | 446860008 | 279107003 | ||
| SHUNT | :Unmatched | TBD | ||||
| SITE | :Unmatched | TBD | ||||
| SKBP | :(Equivalent) | 309066003 | 240977001 | |||
| SKN | :(Equivalent) | 119325001 | ||||
| SMM | :(Equivalent) | 420548004 | 4147007 | |||
| SNV | :(Equivalent) | 119332005 | ||||
| SPRM | :(Equivalent) | 119349003 | ||||
| SPRP | :(Equivalent) | 119312009 | TBD in detail | |||
| SPRPB | :(Equivalent) | 119312009 | TBD in detail | |||
| SPS | :Unmatched | TBD | ||||
| SPT | :(Equivalent) | 119334006 | ||||
| SPTC | :(Equivalent) | 119335007 | ||||
| SPTT | :(Equivalent) | 258609006 | ||||
| SPUT1 | :Unmatched | TBD | ||||
| SPUTIN | :(Equivalent) | 258610001 | ||||
| SPUTSP | :(Equivalent) | 119335007 | ||||
| STER | :Unmatched | TBD | ||||
| STL | :(Equivalent) | 119339001 | ||||
| STONE | :(Equivalent) | 119350003 | 64033007 | |||
| SUBMA | :(Equivalent) | 119371008 | 5713008 | |||
| SUBMX | :(Equivalent) | 119371008 | 4335006 | |||
| SUMP | :(Equivalent) | 446562005 | 122462000 | Historical term - consider what is being drained and indicate that in SPM-4 instead | ||
| SUP | :(Equivalent) | 122575003 | 58088002 | |||
| SUTUR | :Unmatched | TBD | ||||
| SWGZ | :(Equivalent) | 119312009 | TBD in detail | |||
| TASP | :(Equivalent) | 122877000 | 129112001 | 44567001 | ||
| TISS | :(Equivalent) | 119376003 | ||||
| TISU | :(Equivalent) | 122593002 | ||||
| TLC | :(Equivalent) | 119312009 | TBD in detail | |||
| TRAC | :(Equivalent) | 438660002 | ||||
| TRANS | :(Equivalent) | 258538002 | ||||
| TSERU | :(Equivalent) | 119364003 | 255588006 | |||
| TSTES | :(Equivalent) | 119371008 | 279572002 | |||
| TTRA | :(Equivalent) | 258480001 | 129112001 | |||
| TUBES | :(Equivalent) | 119310001 | ||||
| TUMOR | :(Equivalent) | 258435002 | ||||
| TZANC | :Unmatched | This is the name of a lab test. A skin sample is examined for viral inclusions. | ||||
| UDENT | :(Equivalent) | 123038009 | ||||
| UR | :(Equivalent) | 122575003 | ||||
| URC | :(Equivalent) | 122880004 | ||||
| URINB | :(Equivalent) | 122575003 | 78533007 | |||
| URINC | :(Equivalent) | 446846006 | ||||
| URINM | :(Equivalent) | 258574006 | 225271002 | 431938005 | ||
| URINN | :(Equivalent) | 446277003 | 225109005 | 25990002 | ||
| URINP | :Unmatched | TBD | ||||
| URT | :(Equivalent) | 122565001 | ||||
| USCOP | :Unmatched | 176178006 | 89837001 | NEW specimenTERM 7 | ||
| USPEC | :(Equivalent) | 123038009 | ||||
| VASTIP | :(Equivalent) | 119312009 | TBD in detail | |||
| VENT | :(Equivalent) | 119312009 | TBD in detail | |||
| VITF | :(Equivalent) | 258438000 | ||||
| VOM | :(Equivalent) | 122572000 | ||||
| WASH | :(Equivalent) | 440674008 | ||||
| WASI | :(Equivalent) | 122609004 | ||||
| WAT | :(Equivalent) | 119318008 | ||||
| WB | :Unmatched | Bloodbanking term ONLY now map to blood and the respective preservative | ||||
| WEN | :(Equivalent) | 309075001 | ||||
| WICK | :Unmatched | TBD | ||||
| WND | :(Equivalent) | 119365002 | ||||
| WNDA | :(Equivalent) | 119366001 | ||||
| WNDD | :(Equivalent) | 122566000 | 122462000 | |||
| WNDE | :(Equivalent) | 122568004 | ||||
| WORM | :(Equivalent) | 258618008 | ||||
| WRT | :(Equivalent) | 309068002 | ||||
| WWA | :(Equivalent) | 119318008 | ||||
| WWO | :Unmatched | TBD | ||||
| WWT | :Unmatched | TBD | ||||
| CSITE | :Unmatched | 119295008 | 386144009 | 14766002 | Prefer to have aspirate of the pus oozing out from cleaned insertion site - if swab is all that can be obtained, then swab after cleaning, otherwise you may get a contaminated specimen and a falsely identified infected central line. Do not just swab the reddened area - that will just collect skin flora | |
| CLIPP | :Unmatched | 119326000 | Be more specific use either: 119326000^hair specimen, or 119327009^nail specimen | |||
| SHU | :Unmatched | 438660002 | 257351008 | assume swab from shunt site for mapping here - clean surface of skin prior to expressing the shunt site - preferred is aspiration with sterile syringe should use SPM.8 to specify body approximate match location of shunt site | ||