Applicable Product: Talent Mobility

Applicable Release: July 2022 & later

Summary:

Criteria for File to Update Redeployment Cohorts

[1] The file should be the original xlsx file

[2] There can only be one sheet in the workbook

[3] The list needs to start on row 15 (anything that happens before row 15 is ignored, but the list must start there)

NOTE: As for why this is necessary, the original cohorts document this was based off of had some metadata about the report in those lines prior to 15, so we assume that will be there and skip it

[4] There can be no blank rows in the list, each line must have an entry

[5] There can be no extra cells with values anywhere after the end of the list (no random cells with comments or anything, only the list values from row 15 to whatever the length of the list is)

[6] You don't have to hide rows or columns, and doing so won't have any effect on the ability to process the doc

[7] All column data is ignored except for the following (and these columns all require values, otherwise we can't update the employee, send the email, or have the correct separation date)

• Column A should contain the employee id
• Column G should contain the employee's Last Day/Separation Date
• Column R should contain the employee's personal email address
  (or wherever they will be contacted -- this will also update their email in ipaas security)