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

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 15/Sep/17 12:04 PM - edited
            • Time Spent:
              2h
               

              Testing on Stage

            niteen.surwase Niteen Surwase (Inactive) logged work - 15/Sep/17 01:01 PM
            • Time Spent:
              6h
               

              Analysis and Technical Discussion with Swapnil
              Writing DB trigger and Data Migration script
              Unit Testing on Local and Stage.
              Check-ins on Stage and Production

            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 15/Sep/17 02:02 PM
            • Time Spent:
              7h
               

              Trigger creation
              Review
              Migration on stage and production
              Celerix call
              Eligibility checking on stage and production

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 18/Sep/17 01:19 PM
            • Time Spent:
              3h
               
              <No comment>

              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