-
Type:
Support Activity
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Support Task Type:Query Resolution
-
Environment:Production
-
Reported by:Support
-
Company:Prime Healthcare
-
Module:BenAdmin - Customization
Hello,
Erika Elliott from Prime Health wants to extract the current 2017 enrollments for Garden Grove from WorkTerra. Please see Ms. Elliott's email below and confirm if this can be done:
Jenni,
Since Garden Grove OE ended on October 23rd, I would like to go into Work Terra and retrieve the enrollment files so I can load into Lawson. Can you confirm I can proceed? Can you also confirm that as long as I use the parameters of From Date (01/01/2017) and To Date (12/31/2017) that I will correctly capture all the enrollments? (see screenshot below).
This is the only time I will extract enrollment data. It is my understanding that employees are not allowed to make changes after OE closes. If there are any changes, could you please send them separately in the attached format? These are WorkTerra field headers. If I get the data in this exact format it is easier for me to load.
Please advise if Prime can extract the enrollment data. If there are any other enrollments that took place after 10/23/2016, Prime would like us to provide that data using the attached spec file.
Thank you.
- is blocked by
-
WT-5940 Prime_Healthcare: GGH. Server Error on OE Changes Report
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Samir [ samir ] | Shubhankar Joshi [ shubhankar ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Customization(10113) |
Hi Amber Love-Jones, we can get this data using the OE Changes Report (Reports>>Static Reports) in the Workterra application.
Currently however, we are seeing a server error on the report and development team is working to fix the same. JIRA WT-5940 is opened to track this issue.
Hi Shubhankar,
I have pulled out report from backend. Please find the attached excel.
As per discussion, have modified the stored procedure to included columns
for Enrollment Mode and Datetimestamp while fetching the report.
In case any updates have happened after OE by different mode, record will
come with updated mode.
Please verify few records.
–
Thanks & Regards,
Prasanna N. Karlekar
"It is so simple to be happy, but so difficult to be simple"
From: Shubhankar Joshi (JIRA) jira@workterra.atlassian.net
Sent: Wednesday, November 02, 2016 7:51 PM
To: prasanna@harbingergroup.com
Subject: [JIRA] Shubhankar Joshi mentioned you on WT-5929 (JIRA)
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=shubhankar>
Shubhankar Joshi mentioned you on
<https://workterra.atlassian.net/browse/WT-5929> Change RequestWT-5929
<https://workterra.atlassian.net/browse/WT-5929> Re: Prime_Healthcare: GGH
file extract
Hi <https://workterra.atlassian.net/secure/ViewProfile.jspa?name=alov>
Amber Love-Jones, we can get this data using the OE Changes Report
(Reports>>Static Reports) in the Workterra application.
Currently however, we are seeing a server error on the report and
development team is working to fix the same. JIRA WT-5940 is opened to track
this issue.
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=vijays> Vijay
Siddha,
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=samir> Samir,
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=satyap> Satya,
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=prasanna>
Prasanna Karlekar
<https://workterra.atlassian.net/browse/WT-5929#add-comment> Add Comment
<https://workterra.atlassian.net/browse/WT-5929#add-comment> Add Comment
This message was sent by Atlassian JIRA (v1000.482.3#100017-sha1:2ae3eee)
Atlassian logo
| Attachment | image003.png [ 31338 ] | |
| Attachment | GGH-Enrollment 2017.zip [ 31339 ] |
Password: ggh
–
Thanks & Regards,
Prasanna N. Karlekar
"It is so simple to be happy, but so difficult to be simple"
From: Prasanna Karlekar prasanna@harbingergroup.com
Sent: Friday, November 04, 2016 5:47 PM
To: Shubhankar Joshi (JIRA)
Cc: Satya Prakash; Shyam Sharma; vijays@harbingergroup.com;
samir@harbingergroup.com; Rakesh Kumar
Subject: RE: [JIRA] Shubhankar Joshi mentioned you on WT-5929 (JIRA)
Hi Shubhankar,
I have pulled out report from backend. Please find the attached excel.
As per discussion, have modified the stored procedure to included columns
for Enrollment Mode and Datetimestamp while fetching the report.
In case any updates have happened after OE by different mode, record will
come with updated mode.
Please verify few records.
–
Thanks & Regards,
Prasanna N. Karlekar
"It is so simple to be happy, but so difficult to be simple"
From: Shubhankar Joshi (JIRA) jira@workterra.atlassian.net
Sent: Wednesday, November 02, 2016 7:51 PM
To: prasanna@harbingergroup.com
Subject: [JIRA] Shubhankar Joshi mentioned you on WT-5929 (JIRA)
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=shubhankar>
Shubhankar Joshi mentioned you on
<https://workterra.atlassian.net/browse/WT-5929> Change RequestWT-5929
<https://workterra.atlassian.net/browse/WT-5929> Re: Prime_Healthcare: GGH
file extract
Hi <https://workterra.atlassian.net/secure/ViewProfile.jspa?name=alov>
Amber Love-Jones, we can get this data using the OE Changes Report
(Reports>>Static Reports) in the Workterra application.
Currently however, we are seeing a server error on the report and
development team is working to fix the same. JIRA WT-5940 is opened to track
this issue.
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=vijays> Vijay
Siddha,
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=samir> Samir,
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=satyap> Satya,
<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=prasanna>
Prasanna Karlekar
<https://workterra.atlassian.net/browse/WT-5929#add-comment> Add Comment
<https://workterra.atlassian.net/browse/WT-5929#add-comment> Add Comment
This message was sent by Atlassian JIRA (v1000.482.3#100017-sha1:2ae3eee)
Atlassian logo
| Attachment | image002.png [ 31340 ] |
| Attachment | GGH-OpenEnrollment 2017.xlsx [ 31462 ] |
| Environment | Production [ 10005 ] | |
| Issue Type | Change Request [ 10002 ] | Support Activity [ 10301 ] |
| Status | New Request [ 10029 ] | Resolved [ 5 ] |
| Support Task Type | Query Resolution [ 11205 ] | |
| Workflow | WT_Features [ 26168 ] | WT_Support [ 26417 ] |
Hi Amber Love-Jones, please find attached GGH-OpenEnrollment 2017.xlsx
report containing the 2017 OE Changes in the format as requested.
Let us know if you need more details.
Password: ggh
CC: Vijay Siddha, Samir
| Assignee | Shubhankar Joshi [ shubhankar ] | Amber Love-Jones [ alov ] |
| Environment_New | Production [ 18442 ] |
Sumeet.Kolge (Inactive)
made changes -
| Status | Resolved [ 5 ] | Reopen [ 4 ] |
Had reopened this ticket to change its resolution from 'Unresolved' to 'Done'.
Sumeet.Kolge (Inactive)
added a comment - Had reopened this ticket to change its resolution from 'Unresolved' to 'Done'. Sumeet.Kolge (Inactive)
made changes -
| Resolution | Done [ 10000 ] | |
| Status | Reopen [ 4 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
5d 7h 45m | 1 |
Sumeet.Kolge (Inactive)
made transition
-
|
416d 28m | 1 |
Sumeet.Kolge (Inactive)
made transition
-
|
8m 57s | 1 |
Please pull out OE changes report, Verify the report thoroughly before sharing