Example: Create EIB for Student Cohort Memberships
This example illustrates how to use an inbound EIB to generate a spreadsheet template for a put operation.
As a student financials administrator at your university, you want to update cohort membership for student athletes. Because there are many changes to make in a short amount of time, 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 cohort membership.
To update student cohort membership, you:
- Generate the EIB template.
- Add student cohort information from integration reference IDs.
- Attach the spreadsheet to the integration system to update the records.
- Ensure that these settings are enabled for thePut Student Cohort Membershipweb 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 OptionNameStudent Athlete Cohort EIBInboundSelected
- On theGeneral Settingspage, clickNextto display theGet Datapage.
- In theData Formatsection, enterPut Student Cohort Membership (Web Service)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 theStudent Athlete Cohort EIB, select .
- On theGenerate with Datatask, clickSubmit.
- On theView Background Processreport, clickRefreshto see the completion status. When a download notification displays, click thePut_Student_Cohort_Membershiphyperlink 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 student. Increment this number in the next row for each student athlete you add.
- In your tenant, access theFind Student Cohortsreport and clickOKon the report pop-up.
- From the related actions menu of the cohort that you want to place new student athletes members into, select .
- On theIntegration IDspage, select and copy the ID value of theStudent_Cohort_IDrow.
- In your Excel file, paste the ID value in the first row of theStudent Cohortcolumn.
- In your tenant, access theFind Students by Academic Recordreport.
- Find a student athlete you want to place into the cohort by searching or using the filters in the left pane to refine the results.
- From the related actions menu of the student's name, select .
- On theIntegration IDspage, select and copy the ID value of theAcademic_Person_IDrow.
- In your Excel file, enter these values:ColumnEntryStudentPaste the ID value you copied.Row IDEnter1to match the1value in theSpreadsheet Keycolumn. Increment this number in the next row for each student athlete you add.Assignment TypeADDAssignment DateEnter today’s date in MM/DD/YYYY format.
- Repeat this process until you’re done adding students.
- Save and close your Excel file.
- Launch the EIB:
- Access theLaunch / Schedule Integrationtask.
- On the task pop-up, enter these values and clickOK.FieldValueIntegrationStudent Athlete Cohort EIBRun FrequencyRun Now
- In the(Attachment) Put Student Cohort Membership (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 theExecution Summarygrid, confirm that the total number of records processed is correct.
Workday updates the cohort membership for the specified student athletes. When changes occur on or before the standard start date of the academic period, Workday reevaluates the student cohort in the EIB.
For a reaction to trigger based on a student grouping, you must use the
Maintain Student Financials Reaction Policy
task.