Configuring prerequisites for the Exclude Location Hierarchy check box

MVS customers must perform these prerequisite steps before they can use the Exclude Location Hierarchy check box in the Employee Shift Pattern form.
  1. From the homepage, select Scheduling > Schedule Optimization > Setup > Employee Shift Pattern.
  2. Click the Gear icon to enable configuration mode.
  3. To update the Team DBlookup query, click the diamond icon for SOSP_TEAM.
  4. In the Field UI Configuration window, update the Field Parameters field to:
    multiChoice=true sourceType=SQL source='SELECT WBT_ID, WBT_LOC_NAME, WBT_LOC_DESC FROM VL_WORKBRAIN_TEAM WHERE WBT_ID IN (SELECT DISTINCT wbt_id FROM SEC_WORKBRAIN_TEAM wbt WHERE wbt.wbu_id = ? AND date_trunc(\'day\', CURRENT_TIMESTAMP) BETWEEN wbt.wbut_start_date AND wbt.wbut_end_date)' sourceParams='INTEGER==#page.property.userId#' labelFieldStatus=edit title=LOOKUP_TEAM
  5. Click Save to save the changes.
  6. Click X to close the window.
  7. Specify the Team and Start Date fields, then click Load.
  8. To update the Activity DBlookup query, click the diamond icon for SOSP_ACTIVITY.
  9. In the Field UI Configuration window, update the Field Parameters field to:
    resolveType=SQL resolve='SELECT A.ACT_ID, A.ACT_LOC_NAME FROM VL_SO_ACTIVITY A' sourceDisplayFields=ACT_LOC_NAME masterDataFields=[emp_id] title=LOOKUP_ACTIVITY width=20 slaveInputFields=activity sourceType=SQL source="select distinct ACT.ACT_ID, ACT.ACT_LOC_NAME, EMP_ID from VL_SO_ACTIVITY ACT, EMPLOYEE_TEAM, SEC_WB_TEAM_CHILD_PARENT TCP where EMPT_HOME_TEAM = 'Y' and EMPT_START_DATE <= CURRENT_TIMESTAMP and EMPT_END_DATE >= CURRENT_TIMESTAMP" masterInputFields=[sospEmployeeId]
  10. Click Save.
  11. Click X to close the window.
  12. To hide the Department column, click the diamond icon for SOSP_DEPARTMENT.
  13. In the Field UI Configuration window, update the Field UI to HiddenUI.
  14. Click Save.
  15. Click X to close the window.
  16. Turn off configuration mode.