Skip to content

Instantly share code, notes, and snippets.

@K23Nikhil

K23Nikhil/Expected Output

Created February 12, 2018 10:54
Show Gist options
  • Save K23Nikhil/c4771befdd0594f17bc5f83a935bdcb4 to your computer and use it in GitHub Desktop.
Save K23Nikhil/c4771befdd0594f17bc5f83a935bdcb4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Expected Output
<Employees>
<UpdateEmployee>
<EmployeeNumber>189</EmployeeNumber>
<Schedules>
<DeleteSchedules>LAST</DeleteSchedules>
<DeleteSchedules>THIS</DeleteSchedules>
<DeleteSchedules>NEXT</DeleteSchedules>
<ScheduleRecord>
<Week>THIS</Week>
<InDay>01/17/2018</InDay>
<InTime>9:00</InTime>
<OutDay>01/18/2018</OutDay>
<OutTime>16:45</OutTime>
<JobNumber>9</JobNumber>
</ScheduleRecord>
<ScheduleRecord>
<Week>THIS</Week>
<InDay>01/19/2018</InDay>
<InTime>7:00</InTime>
<OutDay>01/19/2017</OutDay>
<OutTime>13:30</OutTime>
<JobNumber>8</JobNumber>
</ScheduleRecord>
<ScheduleRecord>
<Week>NEXT</Week>
<InDay>01/25/2018</InDay>
<InTime>8:00</InTime>
<OutDay>01/25/2018</OutDay>
<OutTime>11:45</OutTime>
<JobNumber>8</JobNumber>
</ScheduleRecord>
<ScheduleRecord>
<Week>NEXT</Week>
<InDay>01/26/2018</InDay>
<InTime>8:00</InTime>
<OutDay>01/26/2018</OutDay>
<OutTime>13:00</OutTime>
<JobNumber>8</JobNumber>
</ScheduleRecord>
</Schedules>
</UpdateEmployee>
</Employees> 
Raw
Raw file
<?xml version="1.0" encoding="UTF-8"?>
<Poll concept="outback.tbird" location="000610" date="20180205" search="ERS_LABORSCHED" key="oracle.ers.outback.tbird" created="2018-02-07T12:00:33" cb-s="U">
<Labor>
<SCH0 type="WEEKLY">
<SCH1 ib="N" in="2018-02-08 10:30:00" out="2018-02-08 15:45:00" b="N" dt="20180208" wkh="5.25" e="8926" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:30:00" out="2018-02-10 20:30:00" b="N" dt="20180210" wkh="4" e="8926" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 15:00:00" out="2018-02-09 22:00:00" b="N" dt="20180209" wkh="7" e="8926" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 21:00:00" b="N" dt="20180206" wkh="4" e="8926" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 10:30:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="5.25" e="8941" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:00:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="4" e="8941" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 21:00:00" b="N" dt="20180205" wkh="4" e="8941" j="400" pj="K" s="1"/>
<SCH1 ib="N" in="2018-02-05 09:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="6.25" e="8941" j="400" pj="K" s="2"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 22:45:00" b="N" dt="20180209" wkh="6.75" e="8941" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:15:00" out="2018-02-06 20:15:00" b="N" dt="20180206" wkh="3" e="8941" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 20:30:00" b="N" dt="20180208" wkh="3.5" e="8948" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 10:30:00" out="2018-02-08 15:45:00" b="N" dt="20180208" wkh="5.25" e="8948" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-07 10:30:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="5.25" e="8948" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 20:00:00" b="N" dt="20180205" wkh="3" e="8948" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-10 10:30:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="5.25" e="8948" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-11 10:30:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="5.25" e="8972" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:30:00" out="2018-02-11 20:15:00" b="N" dt="20180211" wkh="3.75" e="8972" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-10 11:30:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="4.25" e="8972" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 10:30:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="5.25" e="9010" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:30:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="3.5" e="9010" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 22:45:00" b="N" dt="20180205" wkh="5.75" e="9010" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-10 12:15:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="3.5" e="9010" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 11:45:00" out="2018-02-09 15:45:00" b="N" dt="20180209" wkh="4" e="9010" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 22:45:00" b="N" dt="20180207" wkh="5.75" e="8928" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:00:00" out="2018-02-11 22:00:00" b="N" dt="20180211" wkh="5" e="8928" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-05 10:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="5.25" e="8928" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:15:00" out="2018-02-05 21:45:00" b="N" dt="20180205" wkh="4.5" e="8928" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-08 15:00:00" out="2018-02-08 22:30:00" b="N" dt="20180208" wkh="7.5" e="8982" j="200" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-10 10:30:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="5.25" e="8982" j="200" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:45:00" out="2018-02-10 21:00:00" b="N" dt="20180210" wkh="4.25" e="8982" j="200" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-08 16:45:00" out="2018-02-08 20:45:00" b="N" dt="20180208" wkh="4" e="8991" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:00:00" out="2018-02-07 20:00:00" b="N" dt="20180207" wkh="4" e="8991" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 11:30:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="4.25" e="8991" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 10:30:00" out="2018-02-09 15:45:00" b="N" dt="20180209" wkh="5.25" e="8991" j="200" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:00:00" out="2018-02-06 19:00:00" b="N" dt="20180206" wkh="3" e="8991" j="200" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-06 10:30:00" out="2018-02-06 15:45:00" b="N" dt="20180206" wkh="5.25" e="8991" j="200" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-05 16:15:00" out="2018-02-05 20:15:00" b="N" dt="20180205" wkh="4" e="8985" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 10:30:00" out="2018-02-09 15:45:00" b="N" dt="20180209" wkh="5.25" e="8985" j="400" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 20:00:00" b="N" dt="20180209" wkh="4" e="8985" j="400" pj="DT" s="2"/>
<SCH1 ib="N" in="2018-02-07 16:00:00" out="2018-02-07 19:00:00" b="N" dt="20180207" wkh="3" e="10394" j="200" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-07 10:30:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="5.25" e="10394" j="200" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-05 16:00:00" out="2018-02-05 19:00:00" b="N" dt="20180205" wkh="3" e="10394" j="200" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-05 10:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="5.25" e="10394" j="200" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 22:00:00" b="N" dt="20180209" wkh="6" e="10394" j="200" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-09 10:30:00" out="2018-02-09 15:45:00" b="N" dt="20180209" wkh="5.25" e="10394" j="200" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-06 10:30:00" out="2018-02-06 15:45:00" b="N" dt="20180206" wkh="5.25" e="10394" j="200" pj="OF" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:30:00" out="2018-02-08 20:30:00" b="N" dt="20180208" wkh="4" e="11193" j="840" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-05 10:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="5.25" e="11193" j="840" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-06 10:30:00" out="2018-02-06 15:45:00" b="N" dt="20180206" wkh="5.25" e="11193" j="840" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-08 10:30:00" out="2018-02-08 15:45:00" b="N" dt="20180208" wkh="5.25" e="11766" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-11 12:00:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="8" e="11766" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-05 10:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="5.25" e="11766" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:45:00" out="2018-02-10 20:00:00" b="N" dt="20180210" wkh="3.25" e="11766" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:30:00" out="2018-02-09 20:45:00" b="N" dt="20180209" wkh="4.25" e="11766" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:00:00" out="2018-02-08 19:45:00" b="N" dt="20180208" wkh="3.75" e="8997" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:00:00" out="2018-02-07 19:45:00" b="N" dt="20180207" wkh="3.75" e="8997" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:30:00" out="2018-02-09 21:00:00" b="N" dt="20180209" wkh="3.5" e="8997" j="475" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 22:15:00" b="N" dt="20180208" wkh="5.25" e="9006" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 22:15:00" b="N" dt="20180207" wkh="5.25" e="9006" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-05 16:00:00" out="2018-02-05 20:00:00" b="N" dt="20180205" wkh="4" e="9006" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 22:30:00" b="N" dt="20180209" wkh="5.5" e="9006" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:00:00" out="2018-02-08 19:00:00" b="N" dt="20180208" wkh="3" e="11674" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-07 10:30:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="5.25" e="11674" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:00:00" out="2018-02-11 19:00:00" b="N" dt="20180211" wkh="3" e="11674" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:30:00" out="2018-02-10 22:30:00" b="N" dt="20180210" wkh="5" e="11674" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:00:00" out="2018-02-06 19:00:00" b="N" dt="20180206" wkh="3" e="11674" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:30:00" out="2018-02-07 20:30:00" b="N" dt="20180207" wkh="4" e="11556" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-07 18:00:00" out="2018-02-07 23:00:00" b="N" dt="20180207" wkh="5" e="11398" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:30:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="3.5" e="11398" j="620" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 23:00:00" b="N" dt="20180205" wkh="6" e="11398" j="620" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:15:00" out="2018-02-11 20:15:00" b="N" dt="20180211" wkh="4" e="11029" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:00:00" out="2018-02-10 22:45:00" b="N" dt="20180210" wkh="5.75" e="11029" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-09 10:30:00" out="2018-02-09 15:45:00" b="N" dt="20180209" wkh="5.25" e="11029" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:00:00" out="2018-02-06 20:00:00" b="N" dt="20180206" wkh="4" e="11029" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-11 10:30:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="5.25" e="8933" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:00:00" out="2018-02-11 21:15:00" b="N" dt="20180211" wkh="4.25" e="8929" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-10 10:30:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="5.25" e="8929" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 20:00:00" b="N" dt="20180209" wkh="4" e="8929" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 22:15:00" b="N" dt="20180205" wkh="5.25" e="8954" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:30:00" out="2018-02-06 19:30:00" b="N" dt="20180206" wkh="3" e="8954" j="475" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-05 16:30:00" out="2018-02-05 19:00:00" b="N" dt="20180205" wkh="2.5" e="8995" j="400" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:30:00" out="2018-02-10 20:30:00" b="N" dt="20180210" wkh="4" e="8995" j="400" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:15:00" out="2018-02-10 20:00:00" b="N" dt="20180210" wkh="3.75" e="11034" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:45:00" out="2018-02-09 20:45:00" b="N" dt="20180209" wkh="4" e="11034" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 22:15:00" b="N" dt="20180206" wkh="5.25" e="11034" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 20:00:00" b="N" dt="20180207" wkh="3" e="11037" j="575" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:30:00" out="2018-02-11 20:30:00" b="N" dt="20180211" wkh="3" e="11037" j="575" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:15:00" out="2018-02-09 20:45:00" b="N" dt="20180209" wkh="4.5" e="11037" j="575" pj="DS" s="1"/>
<SCH1 ib="N" in="2018-02-08 09:00:00" out="2018-02-08 15:00:00" b="N" dt="20180208" wkh="6" e="8951" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-07 09:00:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="6.75" e="8951" j="60" pj="DK" s="1"/>
<SCH1 ib="N" in="2018-02-11 07:00:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="8.75" e="8951" j="60" pj="DK" s="1"/>
<SCH1 ib="N" in="2018-02-05 15:00:00" out="2018-02-05 23:00:00" b="N" dt="20180205" wkh="8" e="8951" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-10 09:00:00" out="2018-02-10 15:00:00" b="N" dt="20180210" wkh="6" e="8951" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:00:00" out="2018-02-08 20:00:00" b="N" dt="20180208" wkh="4" e="8944" j="400" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-08 10:30:00" out="2018-02-08 15:45:00" b="N" dt="20180208" wkh="5.25" e="8944" j="400" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-10 16:15:00" out="2018-02-10 20:45:00" b="N" dt="20180210" wkh="4.5" e="8944" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 23:15:00" b="N" dt="20180209" wkh="6.25" e="8944" j="400" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:00:00" out="2018-02-06 22:45:00" b="N" dt="20180206" wkh="6.75" e="8944" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:00:00" out="2018-02-11 19:00:00" b="N" dt="20180211" wkh="3" e="8975" j="200" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-11 10:30:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="5.25" e="8975" j="200" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-05 17:30:00" out="2018-02-05 22:45:00" b="N" dt="20180205" wkh="5.25" e="8975" j="200" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:45:00" out="2018-02-10 21:00:00" b="N" dt="20180210" wkh="4.25" e="8975" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 20:30:00" b="N" dt="20180209" wkh="3.5" e="8975" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 21:00:00" b="N" dt="20180210" wkh="5" e="8939" j="200" pj="DR" s="1"/>
<SCH1 ib="N" in="2018-02-10 10:30:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="5.25" e="8939" j="200" pj="OA" s="2"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 20:15:00" b="N" dt="20180209" wkh="4.25" e="8939" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 22:00:00" b="N" dt="20180208" wkh="5" e="8962" j="600" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 22:00:00" b="N" dt="20180207" wkh="5" e="8962" j="600" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-10 10:00:00" out="2018-02-10 20:00:00" b="N" dt="20180210" wkh="10" e="8962" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 23:00:00" b="N" dt="20180209" wkh="7" e="8962" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-08 18:00:00" out="2018-02-08 23:00:00" b="N" dt="20180208" wkh="5" e="11660" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:00:00" out="2018-02-11 23:00:00" b="N" dt="20180211" wkh="7" e="11660" j="600" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 23:00:00" b="N" dt="20180210" wkh="7" e="11660" j="600" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 23:00:00" b="N" dt="20180209" wkh="7" e="11660" j="600" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:30:00" out="2018-02-08 23:00:00" b="N" dt="20180208" wkh="6.5" e="11072" j="600" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:30:00" out="2018-02-07 23:00:00" b="N" dt="20180207" wkh="6.5" e="11072" j="600" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-05 16:30:00" out="2018-02-05 23:00:00" b="N" dt="20180205" wkh="6.5" e="11072" j="600" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:00:00" out="2018-02-10 23:00:00" b="N" dt="20180210" wkh="6" e="11072" j="600" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 23:00:00" b="N" dt="20180209" wkh="7" e="11072" j="600" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 23:00:00" b="N" dt="20180206" wkh="6" e="11072" j="600" pj="DB" s="1"/>
<SCH1 ib="N" in="2018-02-08 18:00:00" out="2018-02-08 23:00:00" b="N" dt="20180208" wkh="5" e="11511" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:00:00" out="2018-02-11 23:00:00" b="N" dt="20180211" wkh="6" e="11511" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-06 18:00:00" out="2018-02-06 23:00:00" b="N" dt="20180206" wkh="5" e="11511" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-11 13:00:00" out="2018-02-11 23:00:00" b="N" dt="20180211" wkh="10" e="11513" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-10 14:00:00" out="2018-02-10 23:00:00" b="N" dt="20180210" wkh="9" e="11513" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-09 18:00:00" out="2018-02-09 23:00:00" b="N" dt="20180209" wkh="5" e="11513" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 23:00:00" b="N" dt="20180206" wkh="6" e="11513" j="620" pj="DD" s="1"/>
<SCH1 ib="N" in="2018-02-08 10:00:00" out="2018-02-08 15:30:00" b="N" dt="20180208" wkh="5.5" e="8957" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-07 10:00:00" out="2018-02-07 15:30:00" b="N" dt="20180207" wkh="5.5" e="8957" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-11 10:00:00" out="2018-02-11 15:30:00" b="N" dt="20180211" wkh="5.5" e="8957" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-05 10:00:00" out="2018-02-05 15:30:00" b="N" dt="20180205" wkh="5.5" e="8957" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-09 10:00:00" out="2018-02-09 15:30:00" b="N" dt="20180209" wkh="5.5" e="8957" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-06 10:00:00" out="2018-02-06 15:30:00" b="N" dt="20180206" wkh="5.5" e="8957" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-08 15:30:00" out="2018-02-08 21:45:00" b="N" dt="20180208" wkh="6.25" e="11067" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-07 15:30:00" out="2018-02-07 21:00:00" b="N" dt="20180207" wkh="5.5" e="11067" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-05 15:30:00" out="2018-02-05 20:00:00" b="N" dt="20180205" wkh="4.5" e="11067" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-10 07:00:00" out="2018-02-10 14:00:00" b="N" dt="20180210" wkh="7" e="11067" j="600" pj="OB" s="1"/>
<SCH1 ib="N" in="2018-02-09 07:00:00" out="2018-02-09 14:00:00" b="N" dt="20180209" wkh="7" e="11067" j="600" pj="OB" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 21:00:00" b="N" dt="20180206" wkh="4" e="11067" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 21:00:00" b="N" dt="20180208" wkh="4" e="9001" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-07 15:00:00" out="2018-02-07 23:00:00" b="N" dt="20180207" wkh="8" e="9001" j="600" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-11 15:30:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="4.5" e="9001" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-11 12:00:00" out="2018-02-11 15:00:00" b="N" dt="20180211" wkh="3" e="9001" j="600" pj="DU" s="2"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 21:00:00" b="N" dt="20180210" wkh="5" e="9001" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-09 15:30:00" out="2018-02-09 21:30:00" b="N" dt="20180209" wkh="6" e="9001" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-08 15:00:00" out="2018-02-08 22:00:00" b="N" dt="20180208" wkh="7" e="9004" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-05 15:00:00" out="2018-02-05 23:00:00" b="N" dt="20180205" wkh="8" e="9004" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-10 15:30:00" out="2018-02-10 21:30:00" b="N" dt="20180210" wkh="6" e="9004" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-06 15:00:00" out="2018-02-06 23:00:00" b="N" dt="20180206" wkh="8" e="9004" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 21:00:00" b="N" dt="20180207" wkh="4" e="11068" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:00:00" out="2018-02-11 23:00:00" b="N" dt="20180211" wkh="7" e="11068" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 21:00:00" b="N" dt="20180205" wkh="4" e="11068" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 21:00:00" b="N" dt="20180210" wkh="5" e="11068" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:30:00" out="2018-02-09 21:00:00" b="N" dt="20180209" wkh="4.5" e="11068" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-06 15:30:00" out="2018-02-06 21:00:00" b="N" dt="20180206" wkh="5.5" e="11068" j="600" pj="DF" s="1"/>
<SCH1 ib="N" in="2018-02-08 15:00:00" out="2018-02-08 23:00:00" b="N" dt="20180208" wkh="8" e="10107" j="600" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-11 15:00:00" out="2018-02-11 23:00:00" b="N" dt="20180211" wkh="8" e="10107" j="600" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-10 15:00:00" out="2018-02-10 23:00:00" b="N" dt="20180210" wkh="8" e="10107" j="600" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-09 15:00:00" out="2018-02-09 23:00:00" b="N" dt="20180209" wkh="8" e="10107" j="600" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-06 15:00:00" out="2018-02-06 23:00:00" b="N" dt="20180206" wkh="8" e="10107" j="600" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-07 09:00:00" out="2018-02-07 15:00:00" b="N" dt="20180207" wkh="6" e="8961" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-11 09:00:00" out="2018-02-11 15:00:00" b="N" dt="20180211" wkh="6" e="8961" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-05 09:00:00" out="2018-02-05 15:00:00" b="N" dt="20180205" wkh="6" e="8961" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-09 09:00:00" out="2018-02-09 15:00:00" b="N" dt="20180209" wkh="6" e="8961" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-06 09:00:00" out="2018-02-06 15:00:00" b="N" dt="20180206" wkh="6" e="8961" j="60" pj="DG" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 23:00:00" b="N" dt="20180208" wkh="6" e="11073" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 23:00:00" b="N" dt="20180207" wkh="6" e="11073" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-11 15:00:00" out="2018-02-11 21:00:00" b="N" dt="20180211" wkh="6" e="11073" j="600" pj="DM" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 23:00:00" b="N" dt="20180209" wkh="6" e="11073" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 23:00:00" b="N" dt="20180206" wkh="6" e="11073" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 20:30:00" b="N" dt="20180208" wkh="3.5" e="9007" j="475" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:00:00" out="2018-02-10 20:30:00" b="N" dt="20180210" wkh="3.5" e="9007" j="475" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:00:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="3" e="8949" j="475" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:30:00" out="2018-02-10 21:00:00" b="N" dt="20180210" wkh="3.5" e="8949" j="475" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 20:30:00" b="N" dt="20180209" wkh="3.5" e="8949" j="475" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 20:00:00" b="N" dt="20180205" wkh="3" e="8940" j="575" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 20:00:00" b="N" dt="20180206" wkh="3" e="8940" j="575" pj="DP" s="1"/>
<SCH1 ib="N" in="2018-02-07 15:00:00" out="2018-02-07 22:00:00" b="N" dt="20180207" wkh="7" e="8973" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-11 15:00:00" out="2018-02-11 21:45:00" b="N" dt="20180211" wkh="6.75" e="8973" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 22:00:00" b="N" dt="20180205" wkh="5" e="8973" j="600" pj="D" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 22:45:00" b="N" dt="20180210" wkh="6.75" e="8973" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-09 15:00:00" out="2018-02-09 22:30:00" b="N" dt="20180209" wkh="7.5" e="8973" j="600" pj="DU" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:30:00" out="2018-02-08 21:30:00" b="N" dt="20180208" wkh="5" e="8976" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:30:00" out="2018-02-07 21:30:00" b="N" dt="20180207" wkh="5" e="8976" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:30:00" out="2018-02-10 21:30:00" b="N" dt="20180210" wkh="5" e="8976" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:30:00" out="2018-02-09 21:30:00" b="N" dt="20180209" wkh="5" e="8976" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:15:00" out="2018-02-08 21:00:00" b="N" dt="20180208" wkh="3.75" e="8979" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 15:00:00" out="2018-02-07 22:45:00" b="N" dt="20180207" wkh="7.75" e="8979" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 20:30:00" b="N" dt="20180210" wkh="4.5" e="8979" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 22:45:00" b="N" dt="20180209" wkh="5.75" e="8979" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:00:00" out="2018-02-08 20:00:00" b="N" dt="20180208" wkh="4" e="8993" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:00:00" out="2018-02-11 22:00:00" b="N" dt="20180211" wkh="6" e="8993" j="200" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:00:00" out="2018-02-10 23:15:00" b="N" dt="20180210" wkh="6.25" e="8993" j="200" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-08 11:45:00" out="2018-02-08 15:45:00" b="N" dt="20180208" wkh="4" e="8923" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 11:45:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="4" e="8923" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:30:00" out="2018-02-08 21:00:00" b="N" dt="20180208" wkh="3.5" e="8953" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-05 16:30:00" out="2018-02-05 20:30:00" b="N" dt="20180205" wkh="4" e="8953" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:45:00" out="2018-02-09 20:45:00" b="N" dt="20180209" wkh="4" e="8953" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-06 15:00:00" out="2018-02-06 22:45:00" b="N" dt="20180206" wkh="7.75" e="8953" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:45:00" out="2018-02-07 21:00:00" b="N" dt="20180207" wkh="4.25" e="8971" j="200" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-05 15:00:00" out="2018-02-05 22:45:00" b="N" dt="20180205" wkh="7.75" e="8971" j="200" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 22:45:00" b="N" dt="20180210" wkh="6.75" e="8971" j="200" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 22:30:00" b="N" dt="20180208" wkh="5.5" e="9009" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 21:00:00" b="N" dt="20180207" wkh="4" e="9009" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 11:15:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="4.5" e="9009" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:45:00" out="2018-02-11 20:15:00" b="N" dt="20180211" wkh="3.5" e="9009" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-05 16:00:00" out="2018-02-05 22:45:00" b="N" dt="20180205" wkh="6.75" e="9009" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 21:00:00" b="N" dt="20180209" wkh="4" e="9009" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:30:00" out="2018-02-06 20:30:00" b="N" dt="20180206" wkh="4" e="9009" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:30:00" out="2018-02-07 21:30:00" b="N" dt="20180207" wkh="4" e="8970" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:15:00" out="2018-02-07 21:00:00" b="N" dt="20180207" wkh="3.75" e="11675" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:15:00" out="2018-02-11 20:00:00" b="N" dt="20180211" wkh="3.75" e="11675" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-05 11:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="4.25" e="11675" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:00:00" out="2018-02-06 20:00:00" b="N" dt="20180206" wkh="4" e="11675" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 16:00:00" out="2018-02-08 22:45:00" b="N" dt="20180208" wkh="6.75" e="8930" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:45:00" out="2018-02-11 21:00:00" b="N" dt="20180211" wkh="4.25" e="8930" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-10 17:00:00" out="2018-02-10 23:00:00" b="N" dt="20180210" wkh="6" e="8930" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:45:00" out="2018-02-09 21:00:00" b="N" dt="20180209" wkh="4.25" e="8930" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-11 16:15:00" out="2018-02-11 19:45:00" b="N" dt="20180211" wkh="3.5" e="8967" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-05 10:30:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="5.25" e="8967" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-05 16:45:00" out="2018-02-05 20:15:00" b="N" dt="20180205" wkh="3.5" e="8967" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-10 15:00:00" out="2018-02-10 22:45:00" b="N" dt="20180210" wkh="7.75" e="8967" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:00:00" out="2018-02-09 21:00:00" b="N" dt="20180209" wkh="5" e="8967" j="400" pj="K" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:15:00" out="2018-02-06 20:00:00" b="N" dt="20180206" wkh="2.75" e="8967" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-06 10:30:00" out="2018-02-06 15:45:00" b="N" dt="20180206" wkh="5.25" e="8967" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-07 16:00:00" out="2018-02-07 22:45:00" b="N" dt="20180207" wkh="6.75" e="8952" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-11 15:00:00" out="2018-02-11 22:00:00" b="N" dt="20180211" wkh="7" e="8952" j="400" pj="CF" s="1"/>
<SCH1 ib="N" in="2018-02-05 16:00:00" out="2018-02-05 20:00:00" b="N" dt="20180205" wkh="4" e="8952" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-06 16:45:00" out="2018-02-06 20:45:00" b="N" dt="20180206" wkh="4" e="8952" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-06 11:30:00" out="2018-02-06 15:45:00" b="N" dt="20180206" wkh="4.25" e="8952" j="400" pj="DV" s="2"/>
<SCH1 ib="N" in="2018-02-10 16:15:00" out="2018-02-10 20:00:00" b="N" dt="20180210" wkh="3.75" e="8992" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-09 16:15:00" out="2018-02-09 20:15:00" b="N" dt="20180209" wkh="4" e="8992" j="400" pj="DV" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:00:00" out="2018-02-08 22:00:00" b="N" dt="20180208" wkh="5" e="8998" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-08 12:00:00" out="2018-02-08 15:45:00" b="N" dt="20180208" wkh="3.75" e="8960" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-07 16:00:00" out="2018-02-07 19:00:00" b="N" dt="20180207" wkh="3" e="8960" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-07 12:00:00" out="2018-02-07 15:45:00" b="N" dt="20180207" wkh="3.75" e="8960" j="575" pj="DT" s="2"/>
<SCH1 ib="N" in="2018-02-05 16:00:00" out="2018-02-05 20:00:00" b="N" dt="20180205" wkh="4" e="8960" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-05 12:00:00" out="2018-02-05 15:45:00" b="N" dt="20180205" wkh="3.75" e="8960" j="575" pj="DT" s="2"/>
<SCH1 ib="N" in="2018-02-06 12:00:00" out="2018-02-06 15:45:00" b="N" dt="20180206" wkh="3.75" e="8960" j="575" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:00:00" out="2018-02-07 22:00:00" b="N" dt="20180207" wkh="5" e="8966" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-05 17:00:00" out="2018-02-05 22:00:00" b="N" dt="20180205" wkh="5" e="8966" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-10 12:00:00" out="2018-02-10 15:45:00" b="N" dt="20180210" wkh="3.75" e="8966" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-09 12:00:00" out="2018-02-09 15:45:00" b="N" dt="20180209" wkh="3.75" e="8966" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 22:00:00" b="N" dt="20180206" wkh="5" e="8966" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-11 12:00:00" out="2018-02-11 15:45:00" b="N" dt="20180211" wkh="3.75" e="8932" j="430" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:00:00" out="2018-02-11 21:00:00" b="N" dt="20180211" wkh="4" e="8937" j="400" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-10 16:00:00" out="2018-02-10 20:00:00" b="N" dt="20180210" wkh="4" e="8937" j="400" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-09 17:00:00" out="2018-02-09 22:30:00" b="N" dt="20180209" wkh="5.5" e="8937" j="400" pj="DT" s="1"/>
<SCH1 ib="N" in="2018-02-08 09:00:00" out="2018-02-08 15:00:00" b="N" dt="20180208" wkh="6" e="8965" j="600" pj="PP" s="1"/>
<SCH1 ib="N" in="2018-02-07 09:00:00" out="2018-02-07 15:00:00" b="N" dt="20180207" wkh="6" e="8965" j="600" pj="PP" s="1"/>
<SCH1 ib="N" in="2018-02-11 07:00:00" out="2018-02-11 14:00:00" b="N" dt="20180211" wkh="7" e="8965" j="600" pj="PP" s="1"/>
<SCH1 ib="N" in="2018-02-05 09:00:00" out="2018-02-05 14:00:00" b="N" dt="20180205" wkh="5" e="8965" j="600" pj="PP" s="1"/>
<SCH1 ib="N" in="2018-02-10 07:00:00" out="2018-02-10 14:45:00" b="N" dt="20180210" wkh="7.75" e="8965" j="600" pj="PP" s="1"/>
<SCH1 ib="N" in="2018-02-09 07:00:00" out="2018-02-09 14:45:00" b="N" dt="20180209" wkh="7.75" e="8965" j="600" pj="PP" s="1"/>
<SCH1 ib="N" in="2018-02-08 17:30:00" out="2018-02-08 22:45:00" b="N" dt="20180208" wkh="5.25" e="8943" j="200" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-07 17:30:00" out="2018-02-07 22:45:00" b="N" dt="20180207" wkh="5.25" e="8943" j="200" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-11 17:00:00" out="2018-02-11 21:45:00" b="N" dt="20180211" wkh="4.75" e="8943" j="200" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:30:00" out="2018-02-06 22:45:00" b="N" dt="20180206" wkh="5.25" e="8943" j="200" pj="CA" s="1"/>
<SCH1 ib="N" in="2018-02-06 17:00:00" out="2018-02-06 22:45:00" b="N" dt="20180206" wkh="5.75" e="8974" j="400" pj="CF" s="1"/>
</SCH0>
</Labor>
</Poll>
Raw
xslt
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:variable name="SCH1" select="/Poll/Labor/SCH0/SCH1"/>
<xsl:key name="KEYSCHEDULEEMPLOYEE" use="@e" match="/Poll/Labor/SCH0/SCH1"/>
<xsl:template match="/">
<Employees>
<UpdateEmployee>
<xsl:for-each select="/Poll/Labor/SCH0/SCH1[generate-id()=generate-id(key('KEYSCHEDULEEMPLOYEE',@e))]">
<xsl:element name="EmployeeNumber">
<xsl:value-of select="@e"/>
</xsl:element>
<xsl:variable name="scedule" select="$SCH1/@e"
<Schedules>
<xsl:element name="DELETESCHEDULE">LAST</xsl:element>
<xsl:element name="DELETESCHEDULE">THIS</xsl:element>
<xsl:element name="DELETESCHEDULE">NEXT</xsl:element>
<ScheduleRecord>
<xsl:element name="Week">THIS</xsl:element>
<xsl:element name="InDay">
<xsl:value-of select="@dt"/>
</xsl:element>
<xsl:element name="InTime">
<xsl:value-of select="@dt"/>
</xsl:element>
<xsl:element name="OutDay">
<xsl:value-of select="@dt"/>
</xsl:element>
<xsl:element name="OutTime">
<xsl:value-of select="@dt"/>
</xsl:element>
<xsl:element name="JobNumber">
<xsl:value-of select="@j"/>
</xsl:element>
</ScheduleRecord>
</Schedules>
</xsl:for-each>
</UpdateEmployee>
</Employees>
</xsl:template>
</xsl:stylesheet>
@K23Nikhil
Copy link
Author

my xslt showing the wrong output. I want employee wise shift under the employee.
suppose employee has multiple shift then it would come in the employee with new Schedule Record. Please help

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment