Example: Create EIB for Student Charges
This example illustrates how to use an inbound EIB to generate a spreadsheet template for an import operation.
As a student financials administrator at your university, you want to update certain student charges. Because there are many changes to make, you want to complete this task with a single batch update instead of having to make separate updates throughout Workday. You also want to be able to reuse the EIB for future updates to student charges.
To update student charges, you:
- Generate the EIB template.
- Add charge information from integration reference IDs.
- Attach the spreadsheet to the integration system to update the records.
- Ensure that these settings are enabled for theImport Charges for Studentsweb service:
- Public Web Service OperationisTrue.
- Allowed for Inbound Enterprise Interface BuilderisTrue.
- Security:Integration Builddomain in the Integration functional area
- Create the EIB:
- Access theCreate EIBtask.
- On the task pop-up, complete these fields and clickOK.FieldValue or OptionNameImport Charges for Students EIBInboundSelected
- On theGeneral Settingspage, clickNextto display theGet Datapage.
- In theData Formatsection, enterImport Charges for Students (WS Background Process)in theWeb Service Operationprompt.
- ClickNextto display theTransformpage.
- ClickNextto display theDeliverpage.
- ClickNextto display theReview and Submitpage.
- ClickOKto create the EIB. TheView Integration Systempage displays.
- Generate the EIB template:
- From the related actions menu of theImport Charges for Students EIB, select .
- On theGenerate with Datatask, select theConfirmcheck box and clickSubmit.
- On theView Background Processreport, clickRefreshto see the completion status. When a download notification displays, click theImport_Charges_for_Studentshyperlink to download the Excel file.
- Open the Excel file. If necessary, clickEnable Editingfor editing access.
- Populate the EIB template:
- In theSpreadsheet Keycolumn, enter1in the row for the first charge. Keep this number the same for each row you add.
- In theIDcolumn, enter1for the first charge. Increment this number for each charge that you add as a child object under theSpreadsheet Keycolumn parent object.
- In your tenant, search for and select a student’s name to view their profile.
- Select .
- On theIntegration IDspage, select and copy the ID value for theAcademic_Person_IDrow.
- In your Excel file, and paste the ID value in theStudentcolumn.
- In your tenant’s search bar, search for and select your institution to view its academic unit page.
- From the related actions menu of the academic unit, select .
- On theIntegration IDspage, select and copy the ID value of theAcademic_Unit_IDrow.
- In your Excel file, paste the ID value in theInstitution Academic Unitcolumn.
- In theTransaction Datecolumn, enter today’s date in MM/DD/YYYY format.
- In theDue Datecolumn, enter a future date in MM/DD/YYYY format.
- In your tenant, access theFind Academic Periodsreport.
- On the report pop-up, enter the currentAcademic Yearand clickOK.
- From the related actions menu of the academic period, select .
- On theIntegration IDspage, select and copy the ID value of theAcademic_Period_IDrow.
- In your Excel file, paste the ID value in theAcademic Periodfield.
- In your tenant, access theFind Student Charge Itemsreport.
- On the report pop-up, enter a charge in theNamefield and clickOK.
- In theFind Student Charge Itemsgrid, select the charge link to display theView Student Charge Itemtask.
- From the related actions menu of the charge item, select .
- On theIntegration IDspage, select and copy the ID value of theStudent_Charge_Item_IDrow.
- In your Excel file, paste the ID value in theStudent Charge Itemfield.
- In theAmountcolumn, enter a charge amount.
- In your browser, go back to theView Student Charge Itempage.
- From the related actions menu of theCurrencyfield, select .
- On theIntegration IDspage, select and copy the ID value of theCurrency_IDrow.
- In your Excel file, paste the ID value in theCurrencyfield.A worktag is associated with each student charge item.
- Save and close your Excel file.
- Launch the EIB:
- Access theLaunch / Schedule Integrationtask.
- On the task pop-up, enter these values and clickOK.FieldValueIntegrationImport Charges for Students EIBRun FrequencyRun Now
- In the(Attachment) Import Charges for Students (Web Service)row, selectCreate Integration Attachmentunder theValuecolumn.
- On theCreate Integration Attachmenttask, add your Excel file in theAttachmentsection and clickOK.
- On theSchedule an Integrationtask, clickOKto start the integration.
- On theView Background Processpage, clickRefreshuntil thePercent Completefield is 100% or theStatusisCompleted.
- In theIntegration Processsection, verify that theResponse MessageisSUCCESS : All records loaded successfully!!
Workday updates the charges for the specified students.
Run the
Find Student Charges
report or create a custom report to verify that the expected charges loaded.