Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11111

Needed trigger on Nexion to update UDF

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - EDS
    • Reported by:
      Support
    • Company:
      Nexion
    • Item State:
      LB QA - LB Deployed
    • Severity:
      Simple
    • Code Reviewed By:
      Swapnil Pandhare

      Description

      We have created a field 'Employee Type and Location' on stage Nexion company. we need to have a trigger to add / update value of this field. This drives the eligibility of employee for selerix plans.

      Logic for deciding values is as follows,
      Attached herewith is excel sheet Class1MgtandOthers.xls. This file is having 2 lists one is class 1 for management and other is class 1 for others. These are class 1 values. Class 1 is having job titles that categorized in two types Management and others. We want to divide these class 1 values in another 8 groups based employee state.
      1. All employees having class 1 values from 'class 1 for others' list and state as Colorado will have having value 'Colorado (EMP)' for 'Employee Type and Location'
      2. All employees having class 1 values from 'class 1 for management' list and state as Colorado will have having value 'Colorado (MGMT)' for 'Employee Type and Location'
      3. All employees having class 1 values from 'class 1 for others' list and state as Louisiana will have having value 'Louisiana (EMP)' for 'Employee Type and Location'
      4. All employees having class 1 values from 'class 1 for management' list and state as Louisiana will have having value 'Louisiana (MGMT)' for 'Employee Type and Location'
      5. All employees having class 1 values from 'class 1 for others' list and state as Maryland will have having value 'Maryland (EMP)' for 'Employee Type and Location'
      6. All employees having class 1 values from 'class 1 for management' list and state as Maryland will have having value 'Maryland (MGMT)' for 'Employee Type and Location'
      7. All employees having class 1 values from 'class 1 for others' list and state as Texas will have having value 'Texas (EMP)' for 'Employee Type and Location'
      8. All employees having class 1 values from 'class 1 for management' list and state as Texas will have having value 'Texas (MGMT)' for 'Employee Type and Location'
      9. For all other the default value of 'Employee Type and Location' will be 'None'

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Developer:
              Swapnil Pandhare (Inactive)
              QA:
              Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 18h
                  18h