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

Prime_Healthcare: GGH file extract

    Details

    • 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

      Description

      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.

        Attachments

        1. GGH-Enrollment 2017.zip
          664 kB
        2. GGH-OpenEnrollment 2017.xlsx
          160 kB
        3. image002.png
          image002.png
          0.7 kB
        4. image003.png
          image003.png
          0.7 kB
        5. Work Terra enrollment file header template.xlsx
          9 kB

          Issue Links

            Activity

            Hide
            samir Samir added a comment -

            Please pull out OE changes report, Verify the report thoroughly before sharing

            Show
            samir Samir added a comment - Please pull out OE changes report, Verify the report thoroughly before sharing
            Hide
            shubhankar Shubhankar Joshi (Inactive) added a comment -

            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.

            Vijay Siddha, Samir, Satya, Prasanna Karlekar

            Show
            shubhankar Shubhankar Joshi (Inactive) added a comment - 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. Vijay Siddha , Samir , Satya , Prasanna Karlekar
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            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

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - 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
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            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

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - 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
            Hide
            shubhankar Shubhankar Joshi (Inactive) added a comment -

            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

            Show
            shubhankar Shubhankar Joshi (Inactive) added a comment - 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
            Hide
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment -

            Had reopened this ticket to change its resolution from 'Unresolved' to 'Done'.

            Show
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment - Had reopened this ticket to change its resolution from 'Unresolved' to 'Done'.

              People

              Assignee:
              alov Amber Love-Jones (Inactive)
              Reporter:
              alov Amber Love-Jones (Inactive)
              Account Executive:
              Amber Love-Jones (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: