Business Case: Using the Submit Payroll Input Web Service, you will generate a spreadsheet with data loaded from ongoing payroll input.

TASK 1: RUN REPORT TO LOCATE PAYROLL INPUT ID 

1.       Search for and run Ongoing Payroll Input with Reference ID report. Use 01/01/2013 as Start date 

2.       Note the Payroll Input ID for United Way Annual Pledge Pay Component._________________

 TASK 2:  CREATE EIB 

1.       Use the ‘Create EIB’ task to create an inbound integration system Called WICT EIB Submit Payroll with the Template from Web Service Operation data source set to Submit Payroll

Input (Web Service)

TASK 3: GENERATE SPREADSHEET WITH DATA 

1.       From the related action, navigate to Template Model > View. 

2.       Scroll down to locate the Data tab; click the button to Edit 

Template with Data Options 

a.       In the ID field, enter the payroll input ID captured in step 2 of Task 1

b.    Click OK and Done

c.       Scroll Down to click button to Generate Spreadsheet Template with Data 

d.      Check the confirmation check box and click Submit and Done.

        3.       Click the link in your Notifications or on the W: drive to save Submit_Payroll_Input.xml to your local hard drive. Be sure to maintain XML Spreadsheet 2003 format.

 TASK 3: POPULATE SPREADSHEET 

1.    Enter the following values into the spreadsheet

2.    Save your file locally. 

TASK 4: LAUNCH AND MONITOR INTEGRATION 

1.       Scroll down and click the Usage tab. Use the related action of the WICT EIB Submit Payroll integration system, launch it to Run Now. 

2.       Attach the updated spreadsheet 

3.       Run it in Validate Only mode, and then in live execution mode. 

4.       When complete, re-run the Ongoing Payroll Input with Reference ID report and note the changes loaded with your EIB.

2.    Save your file locally.

TASK 4: LAUNCH AND MONITOR INTEGRATION 

1.       Scroll down and click the Usage tab. Use the related action of the WICT EIB Submit Payroll integration system, launch it to Run Now. 

2.       Attach the updated spreadsheet 

3.       Run it in Validate Only mode, and then in live execution mode. 

4.       When complete, re-run the Ongoing Payroll Input with Reference ID report and note the changes loaded with your EIB.