Advertisement
Guest User

Untitled

a guest
Dec 5th, 2016
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.39 KB | None | 0 0
  1. Please see xml example.
  2.  
  3. <?xml version="1.0" encoding="UTF-8"?>
  4. <pi:Payroll_Extract_Employees xmlns:pi="urn:com.workday/picof">
  5. <pi:PayGroup>
  6. <pi:Header>
  7. <pi:Version>24</pi:Version>
  8.  
  9. </pi:Header>
  10. <pi:Employee>
  11. <pi:Summary>
  12. <pi:Employee_ID>123</pi:Employee_ID>
  13. </pi:Summary>
  14. <pi:Personal>
  15. <pi:First_Name>test</pi:First_Name>
  16. <pi:Last_Name>last anme</pi:Last_Name>
  17.  
  18. </pi:Personal>
  19. <pi:Position>
  20. <pi:Operation>ADD</pi:Operation>
  21. <pi:Compensation_Effective_Date pi:PriorValue=""
  22. >20161212</pi:Compensation_Effective_Date>
  23.  
  24. </pi:Position>
  25. <pi:Position>
  26. <pi:Operation>REMOVE</pi:Operation>
  27. <pi:Compensation_Effective_Date>20160401</pi:Compensation_Effective_Date>
  28. </pi:Position>
  29. <pi:Time_Off>
  30. <pi:Code pi:PriorValue="">CHN_PERSONAL_PLAN</pi:Code>
  31. <pi:Time_Off_Date pi:PriorValue="">20161122</pi:Time_Off_Date>
  32. <pi:Quantity pi:PriorValue="">8</pi:Quantity>
  33. <pi:Unit_of_Time pi:PriorValue="">HOURS</pi:Unit_of_Time>
  34. </pi:Time_Off>
  35. <pi:Time_Off>
  36. <pi:Code pi:PriorValue="">CHN_PERSONAL_PLAN</pi:Code>
  37. <pi:Time_Off_Date pi:PriorValue="">20161123</pi:Time_Off_Date>
  38. <pi:Quantity pi:PriorValue="">8</pi:Quantity>
  39. <pi:Unit_of_Time pi:PriorValue="">HOURS</pi:Unit_of_Time>
  40. </pi:Time_Off>
  41. <pi:Time_Off>
  42. <pi:Code pi:PriorValue="">CHN_PERSONAL_PLAN</pi:Code>
  43. <pi:Time_Off_Date pi:PriorValue="">20161211</pi:Time_Off_Date>
  44. <pi:Quantity pi:PriorValue="">8</pi:Quantity>
  45. <pi:Unit_of_Time pi:PriorValue="">HOURS</pi:Unit_of_Time>
  46. </pi:Time_Off>
  47. <pi:Time_Off>
  48. <pi:Code pi:PriorValue="">CHN_PERSONAL_PLAN</pi:Code>
  49. <pi:Time_Off_Date pi:PriorValue="">20161212</pi:Time_Off_Date>
  50. <pi:Quantity pi:PriorValue="">8</pi:Quantity>
  51. <pi:Unit_of_Time pi:PriorValue="">HOURS</pi:Unit_of_Time>
  52. </pi:Time_Off>
  53. <pi:Time_Off>
  54. <pi:Time_Off_Type pi:PriorValue="">TOT_Personal_Leave_Hours</pi:Time_Off_Type>
  55. <pi:Time_Off_Date pi:PriorValue="">20161213</pi:Time_Off_Date>
  56. <pi:Quantity pi:PriorValue="">8</pi:Quantity>
  57. <pi:Unit_of_Time pi:PriorValue="">HOURS</pi:Unit_of_Time>
  58. </pi:Time_Off>
  59. <pi:Time_Off>
  60. <pi:Code pi:PriorValue="">CHN_PERSONAL_PLAN</pi:Code>
  61. <pi:Time_Off_Date pi:PriorValue="">20161214</pi:Time_Off_Date>
  62. <pi:Quantity pi:PriorValue="">8</pi:Quantity>
  63. <pi:Unit_of_Time pi:PriorValue="">HOURS</pi:Unit_of_Time>
  64. </pi:Time_Off>
  65. </pi:Employee>
  66. </pi:PayGroup>
  67. </pi:Payroll_Extract_Employees>`
  68.  
  69. <xsl:choose>
  70. <xsl:when test="pi:Position/pi:Total_Annual_Base_Pay[exists(@pi:PriorValue)]
  71. or pi:Position/pi:Compensation_Effective_Date[exists(@pi:PriorValue)] ">
  72. <xsl:if test="pi:Time_Off[pi:Code='CHN_PERSONAL_PLAN']/pi:Time_Off_Date < pi:Position[pi:Operation!='REMOVE']/pi:Compensation_Effective_Date ">
  73. <xsl:value-of
  74. select="sum(pi:Time_Off[pi:Code='CHN_PERSONAL_PLAN']/pi:Quantity)
  75. + sum(pi:Time_Off_Correction[pi:Code='CHN_PERSONAL_PLAN']/pi:Quantity)"
  76. />
  77. </xsl:if>
  78. </xsl:when>
  79. <!-- <xsl:otherwise>
  80. <xsl:value-of
  81. select="sum(pi:Time_Off[pi:Code='CHN_PERSONAL_PLAN']/pi:Quantity)
  82. + sum(pi:Time_Off_Correction[pi:Code='CHN_PERSONAL_PLAN']/pi:Quantity)"
  83. />
  84. </xsl:otherwise>-->
  85. </xsl:choose>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement