Creating automatic splits from the Injury Diagram for Side, Aspect, Body Area , Medical Code and Diagnosis

You can now split an OSICS Injury  and Medical field so that you can use the data for injury reporting purposes. You can see here that Side, Aspect, Body Area, Medical Code and Diagnosis have been pulled from the injury record automatically

You can now split an OSICS Injury  and Medical field so that you can use the data for injury reporting purposes. You can see here that Side, Aspect, Body Area, Medical Code and Diagnosis have been pulled from the injury record automatically

The example here shows that for the primary injury entered on the injury diagram field called "Injury", splits for Body Area, Side, Aspect, Medical Code and Diagnosis have been generated

To add in a split for Body Area you need to add an "Option Calculation" field called Body Area. The options are listed in the text here and the calculation is shown in the step below

To add in a split for Body Area you need to add an "Option Calculation" field called Body Area. The options are listed in the text here and the calculation is shown in the step below

The Options need to be listed as those options here:

Lumbar Spine

Lumbar

Upper Arm

Side

Neck

Thoracic Spine

Buttock and Pelvis

Foot

Ankle

Lower Leg

Knee

Thigh

Hip and Groin

Abdomen

Chest

Hand

Wrist

Forearm

Elbow

Upper Arm

Shoulder

Head

Medical Illness

The calculation for Body Area is as shown below:

The calculation for Body Area is as shown below:

Add this calculation to the option calculation area. Remember that you are referencing the Injury Diagram called "Injury", so update your equation accordingly if you OSICS diagram field is named differently:

replaceall(split(Injury, "|", 0), " ", "Left","Right","Anterior","Posterior")

To calculate "Side" add in another Option Calculation with options Left and Right

To calculate "Side" add in another Option Calculation with options Left and Right

Set up the Options as:

Left

Right

The Calculation for "Side" is shown here:

The Calculation for "Side" is shown here:

If (Body Area Interim = "Medical Illness", " ",

If (Body Area Interim = "Lumbar Spine", " ",

replaceall(split(Injury, " ", 0 ), " " )))

To generate "Aspect" add in an Option Calculation with options Posterior and Anterior

To generate "Aspect" add in an Option Calculation with options Posterior and Anterior

Set up the options as:

Posterior

Anterior

The Calculation for "Aspect" is

The Calculation for "Aspect" is

The Calculation for Aspect:

If (Body Area = "Medical Illness", " ",

If (Body Area = "Abdomen", " ",

If (Body Area = "Lumbar Spine", " ",

If (Body Area = "Lumbar", " ",

If (Body Area = "Knee", " ",

If (Body Area = "Neck", " ",

If (Body Area = "Spine", " ",

If (Body Area = "Thoracic Spine", " ",

,replaceall(split(Injury or Illness, " ", 1 ), " " )))))))))

To generate "Diagnosis" you need to add in a Text Calculation field

To generate "Diagnosis" you need to add in a Text Calculation field

The calculation for the field Diagnosis is as shown below:

splitlast(Injury or Illness, "|")

To calculate "Medical Code" add in another Option Calculation field with options as listed below. There are a lot of options, remember to update the options when you paste them in!

To calculate "Medical Code" add in another Option Calculation field with options as listed below. There are a lot of options, remember to update the options when you paste them in!

Add in these options for the Medical Code Options:

HXXX

HHXX

HHOX

HHOO

HHOC

HHSX

HHNX

HHNE

HHNS

HHMX

HHEX

HHEC

HHJX

HHZX

HKXX

HKXQ

HKXS

HKXN

HKHX

HKHS

HKHN

HKBX

HKBS

HKBN

HKLX

HKLS

HKLN

HKCX

HKCS

HKCN

HKNX

HKNS

HKNN

HKMX

HLMS

HLMN

HKKX

HKKS

HKKN

HKTX

HKTS

HKTN

HKPX

HKPS

HKJX

HKJS

HKJN

HKEX

HKES

HKEN

HKSX

HKSS

HKSN

HKZX

HKZS

HKZN

HMXX

HMYX

HJXX

HJJX

HDXX

HDJX

HFXX

HFEX

HFEF

HFEM

HFEZ

HFZX

HFNX

HFUX

HFMX

HFMC

HFSX

HFSF

HNXX

HNCX

HNCA

HNCO

HNCC

HNVX

HNNX

HOXX

HOOX

HOOC

HOOJ

HOOP

HOOZ

HOOH

HOOU

HOOL

HOOR

HOOM

HOEX

HOED

HODX

HODF

HODD

HODL

HZXX

HZEX

HZEM

HZNX

HZNM

HZZX

NXXX

NHXX

NKXX

NKXQ

NKXS

NKXN

NWXX

NMXX

NMSX

NMYX

NJXX

NJLX

NJUX

NJPX

NCXX

NCLX

NCLP

NFXX

NFCX

NFCS

NFCU

NFCA

NFLX

NOXX

NOLX

NOLF

NNXX

NNNX

NNSX

NNSC

NAXX

NAFX

NACX

NADX

NZXX

SXXX

SHXX

SHMX

SHMD

SHMT

SHMR

SHAX

SHZX

SKXX

SKXQ

SKXS

SKXN

SMXX

SMDX

SMPX

SMLX

SMRX

SMYX

SMZX

STXX

STSX

STST

STSC

STSP

STSR

STSZ

STIX

STIR

STIZ

STCX

STCR

STCZ

STBX

STBT

STBR

STBZ

STPX

STPR

STPZ

STMX

STMT

STMS

STZX

SJXX

SJSX

SJSA

SJSL

SJSP

SJSQ

SJAX

SJAS

SJAT

SJAD

SJAR

SJAF

SCXX

SDXX

SDAX

SDAL

SDAS

SDAH

SDAG

SDAA

SDAN

SDIX

SDPX

SDPL

SUXX

SUAX

SUAL

SUAI

SUPX

SUBX

SUCX

SGXX

SGSX

SGSA

SGSI

SGSP

SGSC

SGIX

SGIA

SGIP

SGIC

SGCX

SGAX

SFXX

SFCX

SFCO

SFCM

SFCI

SFCR

SFSX

SFSB

SFHX

SFHN

SFHT

SFHH

SSXX

SSFX

SSFS

SSAX

SSAO

SSZX

SNXX

SNTX

SNBX

SNAX

SNSX

SNVX

SNVS

SAXX

SAGX

SAAX

SZXX

UXXX

UHXX

UHMX

UHMB

UHMT

UHMO

UHZX

UKXX

UKXQ

UKXS

UKXN

UMXX

UMBX

UMTX

UMYX

UMYD

UMYT

UTXX

UFXX

UFHX

UFHM

USXX

USFX

USFH

UYXX

UYTX

UNXX

UNMX

UNRX

UNUX

UNSX

UZXX

EXXX

EHXX

EKXX

EKXQ

EKSX

EKDX

EMXX

ETXX

ETEX

ETET

ETES

ETFX

ETFT

ETFS

ETBX

ETBT

ETBS

ETBR

ETTX

ETTT

ETTS

ETTR

EJXX

EJMX

EJMR

EJMC

EJHX

EJZX

ECXX

ECLX

EDXX

EDAX

EDPX

EDRX

EUXX

EUMX

EUPX

EGXX

EGPX

EGBX

EFXX

EFXA

EFHX

EFHS

EFHC

EFHA

EFUX

EFUO

EFUA

EFRX

EFRH

EFRA

ESXX

ENXX

ENUX

EAXX

EZXX

RXXX

RHXX

RKXX

RKXQ

RMXX

RMEX

RMFX

RMYX

RTXX

RTEX

RTET

RTES

RTEI

RTFX

RFXX

RFBX

RFRX

RFRG

RFUX

RFUM

RSXX

RSFX

RYXX

RYPX

RYCX

RNXX

RZXX

WXXX

WHXX

WHWX

WHHX

WHPX

WHPU

WHFX

WHFU

WKXX

WKXQ

WKWX

WKWD

WWV

WKHX

WKHD

WKHV

WKPX

WKPU

WKFX

WKFU

WKBX

WKCX

WMXX

WTXX

WTTX

WTTT

WTTZ

WTTE

WTTF

WTTG

WTDX

WTDT

WTDR

WTEX

WTET

WTEA

WTEB

WTEC

WTED

WTVX

WTVT

WTVR

WTFX

WTFT

WTFA

WTFB

WTFC

WTFD

WTFP

WTFG

WTFF

WJXX

WJWX

WJWG

WJWQ

WJSX

WJSS

WJSR

WJCX

WJCV

WJDX

WJDT

WJPX

WJPC

WJPM

WJPU

WJPR

WJPI

WJPQ

WJMX

WJMQ

WJFX

WJFQ

WCXX

WDXX

WDWX

WDDX

WDCX

WDTX

WDPX

WDPC

WDPM

WDPI

WDPQ

WDMX

WDMA

WDMB

WDMC

WDMD

WDMM

WDMQ

WDFX

WDFA

WDFB

WDFC

WDFD

WDFE

WDFF

WDFG

WDFH

WDFM

WDFV

WDFW

WDFY

WDFQ

WUXX

WUWX

WUCX

WUCV

WUCD

WUDX

WUPX

WUPC

WUPM

WUPI

WUMX

WUFX

WGXX

WGWX

WGWU

WGPX

WGPC

WGPM

WGPI

WGFX

WGFM

WGFP

WGFD

WFXX

WFRX

WFRC

WFRS

WFRT

WFRQ

WFUX

WFUT

WFSX

WFSP

WFSW

WFSD

WFSN

WFHX

WFHH

WFTX

WFCX

WFCM

WFPX

WFPM

WFPB

WFPR

WFPP

WFPD

WFMX

WFMM

WFMA

WFMB

WFMC

WFMD

WFFX

WFFA

WFFB

WFFC

WFFD

WFFE

WFFF

WFFG

WFFH

WFFI

WFFJ

WFFK

WFFL

WFFM

WFFQ

WSXX

WSCX

WSHX

WSHP

WNXX

WNCX

WVXX

WVAX

WVNX

WVNS

WVNL

WAXX

WAWX

WAWS

WAPX

WAPC

WAPM

WAPI

WAFX

WAFM

WAFP

WAFD

WZXX

WZCX

WZWX

WZHX

WZPX

WZFX

WZZX

CXXX

CHXX

CHRX

CHSX

CKXX

CKXQ

CMXX

CMTX

CMYX

CJXX

CJSX

CJSA

CJSP

CJCX

CJVX

CDXX

CDSX

CDSP

CDCX

CUXX

CUSX

CUCX

CUVX

CGXX

CGSX

CGCX

GCVX

CGZX

CFXX

CFRX

CFRA

CFRB

CFRC

CFRM

CFRQ

CFSX

CRCX

CSXX

COXX

COPX

COPP

COPH

CZXX

CZZX

OXXX

OHXX

OKXX

OKXQ

OKXS

OKXN

OMXX

OMMX

OMMO

OMMT

OMMR

OMYX

OMYR

OMWX

OMCX

OTXX

OTRX

OTRT

OTRD

OTUX

OGXX

OGCX

OOXX

OOSX

OOIX

OOLX

OOPX

OOKX

OOMX

OOZX

OPXX

OPBX

OZXX

OZZX

DXXX

DHXX

DKXX

DKXQ

DMXX

DMEX

DMYX

DJXX

DJFX

DJPX

DCXX

DFXX

DFVX

DFPX

DGXX

DAXX

DAFX

DZXX

DZZX

LXXX

LHXX

LKXX

LKXQ

LMXX

LMYX

LJXX

LJFX

LJLX

LJLI

LCXX

LCAX

LCPX

LCPA

LCPB

LCPC

LCPD

LCPE

LUXX

LUSX

LUSA

LUSB

LUSC

LUSD

LURX

LUPX

LGXX

LFXX

LFVX

LFTX

LFTA

LFTB

LFTC

LFTD

LFTE

LFTM

LFSX

LFPX

LFDX

LFMX

LFZX

LFQX

LSXX

LSRX

LSPX

LSPA

LSPD

LSPE

LSPM

LSDX

LSLX

LNXX

LNFX

LNFC

LNDX

LNDS

LNDR

LNDA

LNDD

LNDE

LNDF

LNDM

LNAX

LNAA

LNAD

LNAE

LNAF

LNSX

LNTX

LNZX

LAXX

LAFX

LACX

LACD

LACE

LACM

LZXX

LZHX

LZZX

BXXX

BHXX

BHSX

BHBX

BHIX

BHZX

BKXX

BKXQ

BMXX

BMGX

BMGA

BMGB

BMGP

BMYX

BMYA

BMYB

BMYP

BMYM

BMYZ

BTXX

BTGX

BTGT

BTGB

BTGR

BTAX

BTAT

BTPX

BTPT

BTHX

BTHT

BTHB

BTHR

BJXX

BJSX

BJCX

BUXX

BGXX

BGSX

BGTX

BFXX

BFLX

BFSX

BFCX

BFIX

BFMX

BSXX

BSLX

BSSX

BSCX

BSIX

SFMX

BFZX

BNXX

BNPX

BZXX

BZZX

GXXX

GHXX

GHSX

GHLX

GHZX

GKXX

GKXQ

GMXX

GMFX

GMFP

GMFI

GMYX

GMYP

GMYS

GSNS

GTXX

GTFX

GTFT

GTFB

GTFS

GTFR

GTRX

GTRT

GTRS

GTRR

GTSX

GTST

GTSS

GTSR

GTDX

GTDT

GTDS

GTDR

GTLX

GTLT

GTLS

GTLR

GTMX

GTMT

GTMS

GTMR

GTAX

GTAT

GTAS

GTAR

GTHX

GTHS

GTHD

GTHI

GTHF

GJXX

GJLX

GCXX

GCCX

GDXX

GUXX

GUPX

GGXX

GGSX

GGCX

GFXX

GFFX

GFFN

GFAX

GFPX

GFPS

GFPI

GSXX

GSFX

GSFS

GSFI

GSFB

GSPX

GSPS

GSPI

GYXX

GYOX

GYMX

GNXX

GNEX

GNEG

GNEI

GNEO

GNVX

GNVA

GOXX

GOSX

GOSR

GOPX

GOPR

GAXX

GAHX

GZXX

GZZX

TXXX

THXX

THMX

THMA

THMH

THMQ

THMI

THMB

THOX

THZX

TKXX

TKXQ

TMXX

TMHX

TMHB

TMHS

TMHR

TMQX

TMQS

TMQR

TMQV

TMQW

TMAX

TMAL

TMAM

TMAR

TMLX

TMLH

TMCX

TMCH

TMCQ

TMCA

TMYX

TMYH

TMYQ

TMYA

TMGX

TMGQ

TTXX

TFXX

TFFX

TSXX

TSFX

TYXX

TYCX

TYPX

TNXX

TNEX

TNEL

TZXX

TZZX

KXXX

KHXX

KHQX

KHMX

KHBX

KHBP

KHBI

KHZX

KKXX

KKXQ

KKSX

KKDX

KMXX

KMPX

KTXX

KTQX

KTQT

KTQS

KTQR

KTPX

KTPT

KTPS

KTPR

KTPI

KTHX

KTHM

KTHL

KTHS

KTHR

KTHB

KTHC

KTGX

KTGM

KTGL

KTTX

KJXX

KJAX

KJAP

KJAR

KJAC

KJAG

KJCX

KJCP

KJCR

KJCC

KJMX

KJMA

KJMB

KJMR

KJMC

KJMQ

KJLX

KJLL

KJLP

KJLC

KJPX

KJBX

KJBC

KJSX

KCXX

KCCX

KCCM

KCCL

KCCT

KCCP

KCCB

KCLX

KCMX

KCMM

KCML

KCMC

KCMB

KCMD

KCBX

KDXX

KDPX

KDPF

KDKX

KDKQ

KDSX

KUXX

KUPX

KUAX

KUCX

KUMX

KUZX

KGXX

KGPX

KGPT

KGPL

KGPH

KGPB

KGIX

KGSX

KGSP

KGBX

KGBR

KFXX

KFPX

KFFX

KFFI

KFTX

KFTI

KSXX

KSPX

KSFX

KSTX

KAXX

KAPX

KAMX

KALX

KABX

KZXX

KZZX

KZHX

QXXX

QHXX

QHTX

QHMX

QHMA

QHMP

QHML

QHZX

QKXX

QKXI

QKXQ

QKAX

QKPX

QMXX

QMAX

QMLX

QMGX

QMGM

QMGL

QMSX

QMSA

QMYX

QMYD

QMYG

QMYM

QMYL

QMYS

QMYP

QMCX

QTXX

QFXX

QFTX

QFTT

QFTF

QFTC

QFTQ

QFFX

QFFP

QFFM

QFFD

QFFS

QFFN

QSXX

QSTX

QSTA

QSTP

QSFX

QYXX

QYMX

QYMA

QYMP

QYMD

QYML

QYMM

QYBX

QYBA

QYBP

QNXX

QNPX

QVXX

QVAX

QVZX

QVVX

QVVP

QZXX

QZZX

AXXX

AHXX

AHHX

AKXX

AKXQ

AKBX

AKSX

AKDX

ATXX

ATAX

ATAT

ATAP

ATAE

ATAB

ATAS

ATAR

ATAM

ATAI

ATEX

ATEA

ATTX

ATTT

ATTS

ATTR

ATHX

ATHT

ATHI

ATHS

ATHR

ATPX

ATPT

ATPS

ATPR

ATPU

AJXX

AJSX

AJLX

AJLR

AJLC

AJLA

AJDX

AJMX

ACXX

ACTX

ACPX

ACLX

ADXX

AUXX

AUMX

AULX

AGXX

AGSX

AGSA

AGSS

AGTX

AGAX

AGAB

AGPX

AGPO

AGPS

AGPZ

AGBX

AGBC

AFXX

AFAX

AFAM

AFAL

AFAP

AFAB

AFAT

AFAS

AFTX

AFTN

AFTL

AFTD

AFTO

AFTP

AFTZ

AFCX

AFCA

ASXX

ASTX

ASTM

ASFX

ASFM

ASCX

ASCF

ASCC

ASLX

ANXX

ANCX

ANCM

AVXX

AAXX

AAAX

AASX

AZXX

AZCX

AZZX

AZZP

FXXX

FHXX

FHHX

FHHU

FHPX

FHPU

FHZX

FKXX

FKXQ

FKBX

FKCX

FKUX

FMXX

FMYX

FTXX

FTTX

FTTI

FTEX

FTET

FJXX

FJPX

FJPR

FJPD

FJSX

FJMX

FJFX

FJHX

FJHM

FJHR

FJHP

FCXX

FDXX

FDTX

FDHX

FDMX

FDPX

FGXX

FGCX

FGSX

FGMX

FFXX

FFTX

FFTB

FFTN

FFTC

FFMX

FFMA

FFMB

FFMC

FFMD

FFME

FFMV

FFMM

FFHX

FFHP

FFHD

FFPX

FFQX

FSXX

FSNX

FSNN

FSBX

FSCX

FSMX

FSMA

FSMB

FSMC

FSMD

FSME

FSMP

FSMZ

FSMR

FSSX

FSSF

FSSA

FSSS

FAXX

FAMX

FAHX

FAHR

FAHB

FAPX

FAPC

FAPH

FAPB

FNXX

FNMX

FVXX

FZXX

FZZX

FZCX

XXXX

XHXX

XHUX

XHLX

XKXX

XKUX

XKLX

XMXX

XMUX

XMLX

XMSX

XMYX

XTXX

XTTX

XTRX

XTUX

XTLX

XJXX

XJUX

XJLX

XJSX

XCXX

XDXX

XDUX

XDLX

XUXX

XUUX

XULX

XFXX

XFUX

XFLX

XSXX

XSUX

XSLX

XGXX

XGPX

XGUX

XGLX

XNXX

XNSX

XNUX

XNLX

XVXX

XVUX

XVLX

XAXX

XAUX

XALX

 

The calculation for "Medical Code" is shown here

The calculation for "Medical Code" is shown here

Add this calculation to the option calculation area:

split(Injury, "|", 1)

The same calculations can be used for an OSICS Injury Diagram or for an OSICS Injury Diagram with Medical Code

The same calculations can be used for an OSICS Injury Diagram or for an OSICS Injury Diagram with Medical Code