-
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
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'
- relates to
-
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Attachment | Class1MgtandOthers.xlsx [ 61523 ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Swapnil Pandhare [ swapnil.pandhare ] |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Venkatesh Pujari [ venkatesh.pujari ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
CC: Prasad Pise
Kunal Kedari (Inactive)
added a comment - CC: Prasad Pise | Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
-
- Time Spent:
- 2h
-
Testing on Stage
Hi Swapnil Pandhare,
I have verified this on Stage Nexion company for a fresh EE and an existing one also. The triggers are working fine as per the expectation. Employee Type and Location field value getting updated correctly depending upon Class1 value and State selection.
Thanks,
Venkatesh
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Remaining Estimate | 4h [ 14400 ] | 3h [ 10800 ] |
| Time Spent | 1h [ 3600 ] | |
| Worklog Id | 78998 [ 78998 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
-
- 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
| Remaining Estimate | 3h [ 10800 ] | 0h [ 0 ] |
| Time Spent | 1h [ 3600 ] | 7h [ 25200 ] |
| Worklog Id | 79066 [ 79066 ] |
Swapnil Pandhare, This changes has been done and checked-in on LB, UI Refresh, Stage and Production.
Cc: Satya
| Time Spent | 7h [ 25200 ] | 8h [ 28800 ] |
| Worklog Id | 78998 [ 78998 ] |
-
- Time Spent:
- 7h
-
Trigger creation
Review
Migration on stage and production
Celerix call
Eligibility checking on stage and production
| Time Spent | 8h [ 28800 ] | 15h [ 54000 ] |
| Worklog Id | 79096 [ 79096 ] |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Production Complete(10222)Level 1 values: Closed(10223) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Time Spent | 15h [ 54000 ] | 18h [ 64800 ] |
| Worklog Id | 79312 [ 79312 ] |
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
| Code Reviewed By | Swapnil Pandhare [ 11900 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
16h 39m | 1 |
|
2s | 1 |
|
18s | 1 |
|
2h 5m | 1 |
|
2s | 1 |
|
2s | 1 |
|
2s | 1 |
|
2d 19h 58m | 1 |
|
4s | 1 |
|
5s | 1 |
|
8s | 1 |
|
7s | 1 |
Hi Swapnil Pandhare,
This is on highest priority tomorrow. We are in middle for selerix plan set up. We need this trigger for eligibility of their plans.
CC: Samir;SatyaGaurav SodaniDebbie KullingSantosh Balid