Xml parsing

• nikki123

  Ten Centuries

  Points: 1338

  More actions

  November 17, 2014 at 11:40 am

  #99069

  Hi

  I am very new to xml , i want to parse an xml .

  I have been trying to do this but getting the following error , Please let me know where I am going wrong .

  declare @x xml

  set @x = '<CLAIM version="native">

  <INPUT>

  <HEADER CLM_ID="130421E02595" FEE_ID="3" PROV_TYPE="PAR" BIRTH_DT="05101949" SEX="F" ZIP="283748708" LTR_D="0" COV_D="0" ICD_VER="9" GROUP="2" NPI="1518914514" BENEFICIARY_ZIP="28376" TOTAL_AMT="10.2400">

  <DIAG_CODES>

  <DX CODE="786.05" />

  </DIAG_CODES>

  </HEADER>

  <LINES>

  <LINE CLM_ID="130421E02595" LINE_NUM="01" LIDOS="04142013" HCPCS="71020" MOD_01="26" UNITS="1" CHARGES="39" POS="23" ALLOWANCE="10.24" />

  </LINES>

  </INPUT>

  <OUTPUT>

  <PRICER PROCESSED="1" PROCESS_DURATION="47">

  <HEADER LOC="North Carolina" TOO_MANY="0" PROV_TYPE="PAR" PROCESS_TIME="06/06/2013 10:06:42" OSCAR="000000">

  <WARNINGS>

  <WARNING CODE="WC-50095" TEXT="Invalid Fee ID" />

  </WARNINGS>

  <INFO>

  <ITEM KEY="Provider Type" VALUE="Physician (Medicare Participating)" />

  <ITEM KEY="Locality" VALUE="North Carolina" />

  </INFO>

  </HEADER>

  <LINES>

  <LINE RBRVS_TRVU="0.31" RBRVS_STATUS="A" RBRVS_GLOB="XXX" RBRVS_STATUS_DESC="Active code" RBRVS_ASSTSURG="0" RBRVS_ASSTSURG_PERCENT="0.16" RBRVS_BILAT="0" RBRVS_DIFI="99" RBRVS_ENDO_FAMILY_GROUP="0" RBRVS_INTRAOP="0" RBRVS_MPR_RATE="10.24" RBRVS_MULT="0" RBRVS_PC0="10.24" RBRVS_PE="0.07416" RBRVS_PREOP="0" BRS_CB_DESC="RBRVS" POS_TYPE="F" PAY_LIMIT_CHRG="0" HCPCS_DESCRIPTION="Chest x-ray" HCPCS_NARRATIVE="n/a" RBRVS_PC="10.24" RBRVS_TC="18.84" BRS_CB="1" BETOS="I1A" RBRVS_CF="34.023" RBRVS_TC0="18.84" ASC_SERVICE="0" EDIT_CODING_FLAG="0" EDIT_CODING_MODIFIER="0" PHY_BONUS_TOTAL="0" BRS_HCPCS_MATCH="333" CMS_ALLOW_PRE_CAP="10.24">

  <REMARKS>

  <REMARK CODE="RL-50088" TEXT="Allowance available" />

  </REMARKS>

  </LINE>

  </LINES>

  </PRICER>

  </OUTPUT>

  </CLAIM>

  '

  SELECT

  x.HEADER.value('@clm_id[1]', 'NVARCHAR(max)') AS CODE

  FROM @x.nodes('//INPUT/HEADER') AS x(item)

  ERROR :

  Msg 207, Level 16, State 1, Line 40

  Invalid column name 'HEADER'.