{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"61dc17286d8f99bf18eaef68","instance_id":"6e2c3fc4-1c08-43b5-9ce1-e761f1e4ddee","instance_version":14,"link_map":{"link266":{"src_view_id":"output0","dst_view_id":"input0","src_id":"376675d7-6e99-47f9-9feb-56c65d9ce13f","dst_id":"5edfeb70-4fde-40b6-823d-05180efbcfec","isGoto":false},"link265":{"src_view_id":"output0","dst_view_id":"input0","src_id":"5edfeb70-4fde-40b6-823d-05180efbcfec","dst_id":"ff795a9b-6135-406e-894f-8785ec61877f","isGoto":false},"link242":{"src_view_id":"output0","dst_view_id":"input0","src_id":"fe9edafa-f525-461e-b540-29aa7935baa1","dst_id":"2a2e0407-8541-487a-a758-436a56dca398","isGoto":false},"link263":{"src_view_id":"output0","dst_view_id":"input0","src_id":"ff795a9b-6135-406e-894f-8785ec61877f","dst_id":"5bbc26c3-a9dc-4d68-a622-830f2c211f97","isGoto":false},"link271":{"src_view_id":"output0","dst_view_id":"input0","src_id":"dc1dac17-8adb-4f72-9cf3-32a1cb7b4c60","dst_id":"376675d7-6e99-47f9-9feb-56c65d9ce13f","isGoto":true},"link256":{"src_view_id":"output1","dst_view_id":"input0","src_id":"26e7978b-d311-4d61-83b7-5f54433e7a8c","dst_id":"3b66816f-b1b0-449f-997b-b1b665fd560b","isGoto":false},"link257":{"src_view_id":"output0","dst_view_id":"input1","src_id":"f540839e-aa84-4390-80a6-3d36d57c62bb","dst_id":"376675d7-6e99-47f9-9feb-56c65d9ce13f","isGoto":false},"link254":{"src_view_id":"output0","dst_view_id":"input0","src_id":"4e21d270-357a-4954-bcd4-15a13f2badf5","dst_id":"f540839e-aa84-4390-80a6-3d36d57c62bb","isGoto":false},"link255":{"src_view_id":"output0","dst_view_id":"input0","src_id":"3b66816f-b1b0-449f-997b-b1b665fd560b","dst_id":"4e21d270-357a-4954-bcd4-15a13f2badf5","isGoto":false},"link235":{"src_view_id":"output0","dst_view_id":"input103","src_id":"2a2e0407-8541-487a-a758-436a56dca398","dst_id":"97fdfa74-247c-48e4-8319-cdf177f09c61","isGoto":false},"link253":{"src_view_id":"output0","dst_view_id":"input0","src_id":"97fdfa74-247c-48e4-8319-cdf177f09c61","dst_id":"26e7978b-d311-4d61-83b7-5f54433e7a8c","isGoto":false},"link270":{"src_view_id":"output0","dst_view_id":"input0","src_id":"26e7978b-d311-4d61-83b7-5f54433e7a8c","dst_id":"dc1dac17-8adb-4f72-9cf3-32a1cb7b4c60","isGoto":false}},"link_serial":279,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Use Case - Booked Hours Notifications - Check Hours"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"jianan.chen@rojoconsultancy.com"}},"input":{"fe9edafa-f525-461e-b540-29aa7935baa1_input101":{"view_type":{"value":"document"},"label":{"value":"Get EmploymentId - input0"}}},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"param_table":{"value":[{"capture":{"value":true},"description":{"value":null},"data_type":{"value":"string"},"required":{"value":false},"value":{"value":"3022249"},"key":{"value":"Division"}}]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{"5bbc26c3-a9dc-4d68-a622-830f2c211f97_output0":{"view_type":{"value":"document"},"label":{"value":"Restructure - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5dde47585cdcb06dd1623574","scale_ratio":1,"detail_map":{"fe9edafa-f525-461e-b540-29aa7935baa1":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"4e21d270-357a-4954-bcd4-15a13f2badf5":{"grid_x_int":7,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":2,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"5edfeb70-4fde-40b6-823d-05180efbcfec":{"grid_x_int":10,"index":null,"recommendation_id":null,"output":{},"source":"","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"3b66816f-b1b0-449f-997b-b1b665fd560b":{"grid_x_int":6,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":2,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"dc1dac17-8adb-4f72-9cf3-32a1cb7b4c60":{"grid_x_int":6,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"26e7978b-d311-4d61-83b7-5f54433e7a8c":{"grid_x_int":5,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"97fdfa74-247c-48e4-8319-cdf177f09c61":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"376675d7-6e99-47f9-9feb-56c65d9ce13f":{"grid_x_int":9,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{"input1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"2a2e0407-8541-487a-a758-436a56dca398":{"grid_x_int":3,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"5bbc26c3-a9dc-4d68-a622-830f2c211f97":{"grid_x_int":12,"index":null,"recommendation_id":null,"output":{},"source":"","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"f540839e-aa84-4390-80a6-3d36d57c62bb":{"grid_x_int":8,"index":null,"recommendation_id":null,"output":{},"source":"","grid_y_int":2,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"ff795a9b-6135-406e-894f-8785ec61877f":{"grid_x_int":11,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"fe9edafa-f525-461e-b540-29aa7935baa1":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"fe9edafa-f525-461e-b540-29aa7935baa1_8","instance_id":"fe9edafa-f525-461e-b540-29aa7935baa1","instance_version":8,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get EmploymentId"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"00c90b4c-d1ed-46b4-981e-fcd58bf4962f"},"ref_class_id":{"value":"com-rojoconsultancy-snaps-exactonline-exactoauth2account"},"label":{"expression":false,"value":"Exact Online Account 001","label":"Exact Online Account 001"}}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"Retry request interval":{"value":1},"Version":{"expression":false,"value":"v1"},"Connection details":{"value":{"Connection timeout":{"expression":false,"value":300},"Maximum retry attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Filter Records":{"value":[{"Operation":{"value":"Equals"},"Field Value":{"expression":true,"value":"$groupBy.EmployeeHID"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"EmployeeHID"}}]},"Function parameter":{"value":[]},"Division":{"expression":true,"value":"_Division"},"Pass through":{"value":true},"Inline count":{"value":false},"Connection timeout":{"value":300},"Output Field Selection":{"value":[{"Element":{"expression":false,"value":"ID"}},{"Element":{"expression":false,"value":"StartDate"}}]},"Output fields advanced options":{"value":{"Output entry limit":{"expression":false,"value":null},"Allow empty result":{"expression":false,"value":false},"Output entry offset":{"expression":false,"value":null},"Inline count":{"expression":false,"value":false},"Automatic pagination":{"expression":false,"value":false}}},"Maximum request attempts":{"value":3},"API Object":{"expression":false,"value":"Payroll"},"Connection Details":{"value":{"Connection Timeout":{"expression":false,"value":300},"Maximum Retry Attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Order by":{"value":[]},"Endpoint":{"expression":false,"value":"Employments"},"Output Fields Advanced Options":{"value":{"Output Entry Limit":{"expression":false,"value":null},"Allow Empty Result":{"expression":false,"value":true},"Output Entry Offset":{"expression":false,"value":null},"Inline Count":{"expression":false,"value":false},"Automatic Pagination":{"expression":false,"value":true}}},"API object":{"expression":false,"value":"Payroll"},"Advanced options":{"value":{"Output field limit":{"expression":false,"value":null},"Output field offset":{"expression":false,"value":null}}},"Order By":{"value":[]},"passThroughProp":{"value":false},"Process the empty result":{"value":true},"Automatic pagination":{"value":false},"Output field selection":{"value":[{"Element":{"expression":false,"value":"ID"}},{"Element":{"expression":false,"value":"StartDate"}}]},"Filter records":{"value":[{"Value":{"expression":true,"value":"$groupBy.Employee"},"Field name":{"expression":false,"value":"EmployeeHID"},"Field":{"expression":false,"value":"Employee"},"Field value":{"expression":true,"value":"$groupBy.EmployeeHID"},"Operation":{"value":"Equals"},"Condition":{"value":"Or"}}]},"arrayElementsAsDocuments":{"value":true},"Function Parameter":{"value":[]}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"25"},"4e21d270-357a-4954-bcd4-15a13f2badf5":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"4e21d270-357a-4954-bcd4-15a13f2badf5_1","instance_id":"4e21d270-357a-4954-bcd4-15a13f2badf5","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Determine Hours"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$original.group"},"expression":{"expression":true,"value":"$original.group"}},{"targetPath":{"value":"$original.groupBy"},"expression":{"expression":true,"value":"$original.groupBy"}},{"targetPath":{"value":"$ContractHoursPerDay"},"expression":{"expression":true,"value":"$ContractHours/5"}},{"targetPath":{"value":"$ContractHours"},"expression":{"expression":true,"value":"$ContractHours"}},{"targetPath":{"value":"$DaysInService"},"expression":{"expression":true,"value":"(Math.floor(($Today-$original.StartDate) / 86400000)) - ((Math.floor(($Today-$original.StartDate) / 86400000)/7)*2)"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"5edfeb70-4fde-40b6-823d-05180efbcfec":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"5edfeb70-4fde-40b6-823d-05180efbcfec_1","instance_id":"5edfeb70-4fde-40b6-823d-05180efbcfec","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Map HourTypes"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$EmployeeDetails"},"targetPath":{"value":"$EmployeeDetails"}},{"expression":{"expression":true,"value":"$EmployeeHours.find(x => ('HoursBooked' in x))"},"targetPath":{"value":"$HoursBooked"}},{"expression":{"expression":true,"value":"$EmployeeHours.find(x => ('HoursRejected' in x))"},"targetPath":{"value":"$HoursRejected"}},{"expression":{"expression":true,"value":"$EmployeeHours.find(x => ('HoursDrafted' in x))"},"targetPath":{"value":"$HoursDrafted"}},{"expression":{"expression":true,"value":"$AverageHours.toFixed()"},"targetPath":{"value":"$AverageHours"}},{"expression":{"expression":true,"value":"'ContractHours'in $ ? ($ContractHours*5) : null"},"targetPath":{"value":"$ContractHours"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"3b66816f-b1b0-449f-997b-b1b665fd560b":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"3b66816f-b1b0-449f-997b-b1b665fd560b_1","instance_id":"3b66816f-b1b0-449f-997b-b1b665fd560b","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Add Dates"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$ContractHours"},"expression":{"expression":true,"value":"$AverageHours"}},{"targetPath":{"value":"$original.group"},"expression":{"expression":true,"value":"$original.group"}},{"targetPath":{"value":"$original.StartDate"},"expression":{"expression":true,"value":"($original.StartDate.replace(\"/Date(\",\"\").replace(\")/\",\"\"))"}},{"targetPath":{"value":"$original.groupBy"},"expression":{"expression":true,"value":"$original.groupBy"}},{"targetPath":{"value":"$Today"},"expression":{"expression":true,"value":"Date.now().getTime()"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"dc1dac17-8adb-4f72-9cf3-32a1cb7b4c60":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"dc1dac17-8adb-4f72-9cf3-32a1cb7b4c60_1","instance_id":"dc1dac17-8adb-4f72-9cf3-32a1cb7b4c60","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper7"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$AverageHours*5"},"targetPath":{"value":"$AverageHours"}},{"expression":{"expression":true,"value":"$original.groupBy"},"targetPath":{"value":"$EmployeeDetails"}},{"expression":{"expression":true,"value":"$original.group"},"targetPath":{"value":"$EmployeeHours"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"26e7978b-d311-4d61-83b7-5f54433e7a8c":{"class_fqid":"com-snaplogic-snaps-flow-router_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-router","class_version":2,"instance_fqid":"26e7978b-d311-4d61-83b7-5f54433e7a8c_1","instance_id":"26e7978b-d311-4d61-83b7-5f54433e7a8c","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Router"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"routes":{"value":[{"expression":{"expression":true,"value":"$original.StartDate.replace(\"/Date(\",\"\").replace(\")/\",\"\") < (Date.now().minusDays(35).getTime())"},"outputViewName":{"value":"output0"}},{"expression":{"expression":true,"value":"!($original.StartDate.replace(\"/Date(\",\"\").replace(\")/\",\"\") < (Date.now().minusDays(35).getTime()))"},"outputViewName":{"value":"output1"}}]},"execution_mode":{"value":"Validate & Execute"},"firstMatch":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}},"output1":{"view_type":{"value":"document"},"label":{"value":"output1"}}}},"class_build_tag":"snapsmrc528"},"97fdfa74-247c-48e4-8319-cdf177f09c61":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"97fdfa74-247c-48e4-8319-cdf177f09c61_5","instance_id":"97fdfa74-247c-48e4-8319-cdf177f09c61","instance_version":5,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get Contract Hours"}},"view_serial":103,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"00c90b4c-d1ed-46b4-981e-fcd58bf4962f"},"ref_class_id":{"value":"com-rojoconsultancy-snaps-exactonline-exactoauth2account"},"label":{"expression":false,"value":"Exact Online Account 001","label":"Exact Online Account 001"}}}},"input":{"input103":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"Retry request interval":{"value":1},"Version":{"expression":false,"value":"v1"},"Connection details":{"value":{"Connection timeout":{"expression":false,"value":300},"Maximum retry attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Filter Records":{"value":[{"Operation":{"value":"Equals"},"Field Value":{"expression":true,"value":"$groupBy.EmploymentId"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"Employment"}}]},"Function parameter":{"value":[]},"Division":{"expression":true,"value":"_Division"},"Pass through":{"value":true},"Inline count":{"value":false},"Connection timeout":{"value":300},"Output Field Selection":{"value":[{"Element":{"expression":false,"value":"AverageHours"}}]},"Output fields advanced options":{"value":{"Output entry limit":{"expression":false,"value":1},"Allow empty result":{"expression":false,"value":false},"Output entry offset":{"expression":false,"value":null},"Inline count":{"expression":false,"value":false},"Automatic pagination":{"expression":false,"value":false}}},"Maximum request attempts":{"value":3},"API Object":{"expression":false,"value":"HRM"},"Connection Details":{"value":{"Connection Timeout":{"expression":false,"value":300},"Maximum Retry Attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Order by":{"value":[]},"Endpoint":{"expression":false,"value":"Schedules"},"Output Fields Advanced Options":{"value":{"Output Entry Limit":{"expression":false,"value":null},"Allow Empty Result":{"expression":false,"value":true},"Output Entry Offset":{"expression":false,"value":null},"Inline Count":{"expression":false,"value":false},"Automatic Pagination":{"expression":false,"value":true}}},"API object":{"expression":false,"value":"HRM"},"Advanced options":{"value":{"Output field limit":{"expression":false,"value":null},"Output field offset":{"expression":false,"value":null}}},"Order By":{"value":[]},"Process the empty result":{"value":true},"Automatic pagination":{"value":false},"Output field selection":{"value":[{"Element":{"expression":false,"value":"AverageHours"}}]},"Filter records":{"value":[{"Operation":{"value":"Equals"},"Field value":{"expression":true,"value":"$groupBy.EmploymentId"},"Condition":{"value":"And"},"Field name":{"expression":false,"value":"Employment"}}]},"Function Parameter":{"value":[]}},"error":{"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"25"},"376675d7-6e99-47f9-9feb-56c65d9ce13f":{"class_fqid":"com-snaplogic-snaps-transform-multijoin_1-snapsmrc528","class_id":"com-snaplogic-snaps-transform-multijoin","class_version":1,"instance_fqid":"376675d7-6e99-47f9-9feb-56c65d9ce13f_1","instance_id":"376675d7-6e99-47f9-9feb-56c65d9ce13f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Join"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}},"input1":{"view_type":{"value":"document"},"label":{"value":"input1"}}},"settings":{"joinType":{"value":"Merge"},"execution_mode":{"value":"Validate & Execute"},"nullSafeAccess":{"value":false},"noMatchData":{"value":false},"joinPaths":{"value":[{"rightPath":{"expression":true,"value":null},"rightInputView":{"value":"input1"},"leftPath":{"expression":true,"value":null}}]},"nullGreater":{"value":false},"sortedStreams":{"value":"Ascending"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"2a2e0407-8541-487a-a758-436a56dca398":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"2a2e0407-8541-487a-a758-436a56dca398_1","instance_id":"2a2e0407-8541-487a-a758-436a56dca398","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$original.group"},"targetPath":{"value":"$group"}},{"expression":{"expression":true,"value":"($StartDate.replace(\"/Date(\",\"\").replace(\")/\",\"\"))"},"targetPath":{"value":"$StartDate"}},{"expression":{"expression":true,"value":"$original.groupBy"},"targetPath":{"value":"$groupBy"}},{"expression":{"expression":true,"value":"$ID"},"targetPath":{"value":"$groupBy.EmploymentId"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"5bbc26c3-a9dc-4d68-a622-830f2c211f97":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"5bbc26c3-a9dc-4d68-a622-830f2c211f97_1","instance_id":"5bbc26c3-a9dc-4d68-a622-830f2c211f97","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Restructure"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$EmployeeId"},"expression":{"expression":true,"value":"$EmployeeDetails.Employee"}},{"targetPath":{"value":"$HoursBooked"},"expression":{"expression":true,"value":"match $HoursBooked {null => \"0\",_=>$HoursBooked.HoursBooked}"}},{"targetPath":{"value":"$HoursDrafted"},"expression":{"expression":true,"value":"match $HoursDrafted {null => \"0\",_=>$HoursDrafted.HoursDrafted}"}},{"targetPath":{"value":"$HoursRejected"},"expression":{"expression":true,"value":"match $HoursRejected {null => \"0\",_=>$HoursRejected.HoursRejected}"}},{"targetPath":{"value":"$AverageHours"},"expression":{"expression":true,"value":"$AverageHours"}},{"targetPath":{"value":"$ContractHours"},"expression":{"expression":true,"value":"$ContractHours"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"f540839e-aa84-4390-80a6-3d36d57c62bb":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"f540839e-aa84-4390-80a6-3d36d57c62bb_1","instance_id":"f540839e-aa84-4390-80a6-3d36d57c62bb","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Average Hours"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$original.group"},"targetPath":{"value":"$EmployeeHours"}},{"expression":{"expression":true,"value":"$original.groupBy"},"targetPath":{"value":"$EmployeeDetails"}},{"expression":{"expression":true,"value":"$ContractHoursPerDay * $DaysInService"},"targetPath":{"value":"$AverageHours"}},{"expression":{"expression":true,"value":"$ContractHours"},"targetPath":{"value":"$ContractHours"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"ff795a9b-6135-406e-894f-8785ec61877f":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"ff795a9b-6135-406e-894f-8785ec61877f_1","instance_id":"ff795a9b-6135-406e-894f-8785ec61877f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Filter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"filterExpression":{"expression":true,"value":"$HoursBooked.HoursBooked < $AverageHours"},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"}},"path_id":"/RojoConsultancy1_Dev/Software Development Docs/ExactOnline_1.0.0","path_snode":"602153b02280db50f3db24dd","target_runtime":"standard"}