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

Needed trigger on Nexion to update UDF

    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

      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

            Transition Time In Source Status Execution Times
            Swapnil Pandhare (Inactive) made transition -
            New Request Pending for Approval
            16h 39m 1
            Swapnil Pandhare (Inactive) made transition -
            Pending for Approval Approved for Development
            2s 1
            Swapnil Pandhare (Inactive) made transition -
            Approved for Development In Development
            18s 1
            Swapnil Pandhare (Inactive) made transition -
            In Development In LB Testing
            2h 5m 1
            Swapnil Pandhare (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            2s 1
            Swapnil Pandhare (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            2s 1
            Swapnil Pandhare (Inactive) made transition -
            Approved for Stage Stage Testing
            2s 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing Pending for Production Approval
            2d 19h 58m 1
            Venkatesh Pujari (Inactive) made transition -
            Pending for Production Approval Approved for production
            4s 1
            Venkatesh Pujari (Inactive) made transition -
            Approved for production In Production Testing
            5s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            8s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            7s 1

              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