Example: Create EIB for Course Section Fees
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 course section fees. 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 course section fees.
To update course section fees, you:
- Generate the EIB template.
- Add course fee information from integration reference IDs.
- Attach the spreadsheet to the integration system to update the records.
- Ensure that these settings are enabled for theImport Student Course Section Feesweb 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 Student Course Section Fees EIBInboundSelected
- On theGeneral Settingspage, clickNextto display theGet Datapage.
- In theData Formatsection, enterImport Student Course Section Fees (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.
- Modify the EIB template:
- From the related actions menu of theImport Student Course Section Fees EIB, select .
- In the left pane, select .
- In the right pane, clickEdit Template Model Area.
- In theCalculationrow, complete these fields:FieldValue or OptionSeparate Type ColumnSelectedReference ID TypeConditional Calculation ID
- ClickOK, thenDone.
- In the left pane, select .
- In the right pane, clickEdit Template Model Area.
- In theCalculationrow, complete these fields:FieldValue or OptionSeparate Type ColumnSelectedReference ID TypeConditional Calculation ID
- ClickOK, thenDone. TheView Integration Systempage displays.
- Generate the EIB template:
- From the related actions menu of theImport Student Course Section Fees 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_Student_Course_Section_Feeshyperlink to download the Excel file.
- Open the Excel file. If necessary, clickEnable Editingfor editing access.
- Populate the EIB:
- In your tenant, access theFind Course Section Definitionsreport.
- Find your desired course by searching or using the filters in the left pane to refine the results.
- From the related actions menu of the course section for which you want to update fees, select .
- On theIntegration IDspage, select and copy the ID value of theStudent_Course_Section_IDrow.
- In your Excel file, select theCourse Section Fees HVtab and paste the ID value in theCourse Sectioncolumn.
- In theHeader Key,Line Key, andRow IDcolumns, enter1in the row for the first course. Increment this number in the next row for each course you add.
- In your tenant, access theAll Calculationsreport to find the calculation you want to place on the course.
- On the report pop-up, enter these values and click OK.FieldValueCategoryStudent FinancialsOwnerCustomerIfCustomerisn’t an option:
- SelectCreate Calculation Owner.
- EnterCustomerin theNamefield.
- ClickOK.
- ClickOKto run the report.
- In theAll Calculationsgrid, select theCalculation Typecolumn, enterConditional Calculationin theValuefield, and clickFilterto refine the results by the calculation type you specified when modifying the EIB template.
- From the related actions menu of the calculation for which you want to update fees, select .
- On theIntegration IDspage, select and copy the value of theTypecolumn.
- In theCourse Section Fees HVtab of your Excel file, paste the type value in theID Typecolumn.
- On theIntegration IDspage in your tenant, select and copy the value of theIDcolumn.
- In your Excel file, paste the ID value in theID Valuecolumn.
- In your tenant, access theFind Student Charge Itemsreport and clickOKon the report pop-up.
- From the related actions menu of the charge item for which you want to update, select .
- On theIntegration IDspage, select and copy the ID value of theStudent_Charge_Item_IDrow.
- In your Excel file, paste the ID value in theCourse Fee Charge Itemcolumn.
- Select theImport Course Section Feetab and enter aHeader Keyof1.
- Repeat this process until you’re done adding course section fees.
- Save and close your Excel file.
- Launch the EIB:
- Access theLaunch / Schedule Integrationtask.
- On the task pop-up, enter these values and clickOK.FieldValueIntegrationImport Student Course Section FeesRun FrequencyRun Now
- In the(Attachment) Import Student Course Section Fees (WS Background Process)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.
Workday updates the fees for the specified course sections.