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

EDI Bulk utility tasks - New plan selection / update post OE

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Production QA
    • Issue Importance:
      Must have Additional
    • Sprint:
      WT Sprint 11

      Description

      EDI Bulk ultility tasks - New plan selection / update post OE

        Attachments

          Issue Links

            Activity

            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to ST-125 [ ST-125 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Issue Importance Can Wait [ 11801 ] Good To Have [ 11802 ]
            samir Samir made changes -
            Component/s EDI Bulk Utility [ 10401 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Component/s BenAdmin [ 10100 ]
            Component/s EDI Bulk Utility [ 10401 ]
            Key ST-159 WT-3095
            Project Project Simple [ 10400 ] WORKTERRA [ 10000 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Issue Importance Good To Have [ 11802 ] Must have Additional [ 12201 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint Must have Enhancements-Add [ 15 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked lower
            shyam.sharma shyam sharma (Inactive) made changes -
            Code Reviewed By Rohan Khandave [ 11903 ]
            Dev Estimates 40
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint Must have Enhancements-Add [ 15 ] WT - Sprint 10 [ 24 ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Samir [ samir ] Rohan Khandave [ rohan.khandave ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: On Hold(10207)
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            As per Dave/Amit email this task is dropped from sprint 10 as team needs to work on followings in the current sprint 10
            • (ST-193) Prime Split - Alvarado Hospital Medical Center
            • (ST-195) Prime Split - Harlingen Medical Center
            • (ST-196) Prime Split - Monroe Hospital
            • (ST-197) Prime Split - Pampa Regional Medical Center
            • (ST-198) Prime Split - Hospitality
            Now We will pick up WT-3095 in sprint 11

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - As per Dave/Amit email this task is dropped from sprint 10 as team needs to work on followings in the current sprint 10 • ( ST-193 ) Prime Split - Alvarado Hospital Medical Center • ( ST-195 ) Prime Split - Harlingen Medical Center • ( ST-196 ) Prime Split - Monroe Hospital • ( ST-197 ) Prime Split - Pampa Regional Medical Center • ( ST-198 ) Prime Split - Hospitality Now We will pick up WT-3095 in sprint 11
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint WT - Sprint 10 [ 24 ] WT - Sprint 11 [ 25 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Rohan Khandave [ rohan.khandave ] Ganesh Sadawarte [ ganesh.sadawarte ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Summary EDI Bulk ultility tasks - New plan selection / update post OE EDI Bulk utility tasks - New plan selection / update post OE
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            shyam.sharma shyam sharma (Inactive) made changes -
            Dev Due Date 07/Sep/2016
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Due to below task changing dev due date

            1) WT-4500: Wheaton - Deduction File
            2) Production build

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Due to below task changing dev due date 1) WT-4500 : Wheaton - Deduction File 2) Production build
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Dev Due Date 07/Sep/2016 09/Sep/2016
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

            Affected Files:

            1)Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_Export_SaveEDIToolAction.sql
            2)DatabaseObjects/MasterCompanyDB/04_StoredProcedures/
            dbo.OES_SP_Export_GetTemplateListForEDITool.sql
            3)Database Objects/MasterCompanyDB/07_Data/108_WT-3095_WTB_Export_NewData_ExportEDIToolActions.sql
            4)Database Objects/OnlineEnrollment/04_Stored Procedures/dbo.OES_Export_SaveEDIToolAction.sql
            5)Database Objects/OnlineEnrollment/04_StoredProcedures/dbo.OES_SP_Export_GetTemplateListForEDITool.sql
            6)Database Objects/OnlineEnrollment/07_Data/68_WT-3095_WTB_Export_NewData_ExportEDIToolActions.sql
            7)Database Objects/OnlineEnrollment/07_Data/70_WT-3095_WTB_Export_NewData_PageLevelAccess.sql

            8)Shared Library/SharedFunction/SharedFunction/WORKTERRASharedFunction.cs
            9)Shared Library/WORKTERRALocalization/WORKTERRALocalization

            10)App/BusinessLogic/ImportExportDTS/EDITool.vb
            11)App/ControllerAppTier/ControllerAppTier/WORKTERRAControllerAppTier.cs

            12)Web/Web Projects/WORKTERRA/Areas/Customization/Controllers/EDI/EDIToolController.cs
            13)Web/Web Projects/WORKTERRA/Areas/Customization/Models/EDI/PVEDIToolModel.cs

            15)Web/Web Projects/WORKTERRA/Areas/Customization/Views/Customization/EDI/_PVEDITool.cshtml
            16)Web/Web Projects/WORKTERRA/Areas/Customization/Views/Customization/EDI/EDITool.cshtml

            17)Web/Web Projects/WORKTERRA/Scripts/ImportExportTemplateManagement_MVC.js
            18)Web/Web Projects/WORKTERRA/Scripts/WORKTERRAShared.js

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Affected Files: 1)Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_Export_SaveEDIToolAction.sql 2)DatabaseObjects/MasterCompanyDB/04_StoredProcedures/ dbo.OES_SP_Export_GetTemplateListForEDITool.sql 3)Database Objects/MasterCompanyDB/07_Data/108_ WT-3095 _WTB_Export_NewData_ExportEDIToolActions.sql 4)Database Objects/OnlineEnrollment/04_Stored Procedures/dbo.OES_Export_SaveEDIToolAction.sql 5)Database Objects/OnlineEnrollment/04_StoredProcedures/dbo.OES_SP_Export_GetTemplateListForEDITool.sql 6)Database Objects/OnlineEnrollment/07_Data/68_ WT-3095 _WTB_Export_NewData_ExportEDIToolActions.sql 7)Database Objects/OnlineEnrollment/07_Data/70_ WT-3095 _WTB_Export_NewData_PageLevelAccess.sql 8)Shared Library/SharedFunction/SharedFunction/WORKTERRASharedFunction.cs 9)Shared Library/WORKTERRALocalization/WORKTERRALocalization 10)App/BusinessLogic/ImportExportDTS/EDITool.vb 11)App/ControllerAppTier/ControllerAppTier/WORKTERRAControllerAppTier.cs 12)Web/Web Projects/WORKTERRA/Areas/Customization/Controllers/EDI/EDIToolController.cs 13)Web/Web Projects/WORKTERRA/Areas/Customization/Models/EDI/PVEDIToolModel.cs 15)Web/Web Projects/WORKTERRA/Areas/Customization/Views/Customization/EDI/_PVEDITool.cshtml 16)Web/Web Projects/WORKTERRA/Areas/Customization/Views/Customization/EDI/EDITool.cshtml 17)Web/Web Projects/WORKTERRA/Scripts/ImportExportTemplateManagement_MVC.js 18)Web/Web Projects/WORKTERRA/Scripts/WORKTERRAShared.js
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Aniruddha Dev [ aniruddha.dev ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Code Review Date 12/Sep/2016
            Code Reviewed By Rohan Khandave [ 11903 ] Vinalyak Kulkarni [ 12100 ]
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Ganesh Sadawarte : please sync the status of this ticket I mean Item state : LB QA - LB Deployed and Main status
            Rohan J Khandave

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Ganesh Sadawarte : please sync the status of this ticket I mean Item state : LB QA - LB Deployed and Main status Rohan J Khandave
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Hi shyam sharma,

            LB Deployed was update by deployment engineer and main status of local testing will we update by QA.
            We are just assigning JIRA to the respective QA after patch deployment.

            Rohan J Khandave,Satya

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi shyam sharma , LB Deployed was update by deployment engineer and main status of local testing will we update by QA. We are just assigning JIRA to the respective QA after patch deployment. Rohan J Khandave , Satya Thanks, Ganesh
            shyam.sharma shyam sharma (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Aniruddha Dev : This task is deployed on LB please start testing.

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Aniruddha Dev : This task is deployed on LB please start testing.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - - edited

            Getting server error on EDI utility -> select Company -> Select new Plan selection .

            error log :
            ErrorID : 0
            ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData
            ErrorMessage: Object reference not set to an instance of an object.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - - edited Getting server error on EDI utility -> select Company -> Select new Plan selection . error log : ErrorID : 0 ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData ErrorMessage: Object reference not set to an instance of an object.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Ganesh Sadawarte [ ganesh.sadawarte ]
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            LB patch deployment was going on when you are verifying this change due to this its error occurred. Please check now it working properly.

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Hrishikesh Deshpande , LB patch deployment was going on when you are verifying this change due to this its error occurred. Please check now it working properly. Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Priya Dhamande [ priya.dhamande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Priya Dhamande [ priya.dhamande ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment TestCasesScenarios_EDIUtility_NewPlanSelection.xls [ 27127 ]
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

            The Test Cases and Scenario document is attached with the jira. Please find the attachment for the same.

            The enhancement is tested for basic scenarios and Test cases. The tested scenarios and Test cases worked as expected. Testing is in progress for further scenarios.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited The Test Cases and Scenario document is attached with the jira. Please find the attachment for the same. The enhancement is tested for basic scenarios and Test cases. The tested scenarios and Test cases worked as expected. Testing is in progress for further scenarios.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment TestCasesScenarios_EDIUtility_NewPlanSelection.xls [ 27127 ]
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            The enhancement of EDI Utility - New Plan Selection is tested on JambaJuice on LB. The scenarios covered during testing are:

            1. All Template having same Benefit Type mapped should appear in list
            2. Template having new Plan already selected should not appear
            3. All templates checked marked should have new plan selected.
            4. Class Status Eligibility of Plan should be in sync with Template
            5. The Template listed should have same benfit provider as selected on template else Template should not be listed.

            As all the scenarios worked as expected, moving the jira on Stage.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - The enhancement of EDI Utility - New Plan Selection is tested on JambaJuice on LB. The scenarios covered during testing are: 1. All Template having same Benefit Type mapped should appear in list 2. Template having new Plan already selected should not appear 3. All templates checked marked should have new plan selected. 4. Class Status Eligibility of Plan should be in sync with Template 5. The Template listed should have same benfit provider as selected on template else Template should not be listed. As all the scenarios worked as expected, moving the jira on Stage.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Ganesh Sadawarte [ ganesh.sadawarte ]
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            The enhancement of EDI Utility - New Plan Selection is tested on LHP for HSPL.
            Scenarios covered during testing are:

            1. Checked for Benefit Type
            2. Checked if Plan already selected
            3. Checked for Class Status Eligibility of Plan in sync with Template
            4. Checked for same Benefit Type and different Benefit Provider and Vice versa

            As all the scenarios worked as expected, moving the jira on Production.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - The enhancement of EDI Utility - New Plan Selection is tested on LHP for HSPL. Scenarios covered during testing are: 1. Checked for Benefit Type 2. Checked if Plan already selected 3. Checked for Class Status Eligibility of Plan in sync with Template 4. Checked for same Benefit Type and different Benefit Provider and Vice versa As all the scenarios worked as expected, moving the jira on Production.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            ashwin.wankhede Ashwin Wankhede (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)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            The enhancement of EDI Utility - New Plan Selection is tested on Wheaton Franciscan Healthcareon company on Production.

            Scenarios covered during testing are:
            1. All Template having same Benefit Type mapped should appear in list
            2. Template having new Plan already selected should not appear
            3. All templates checked marked should have new plan selected.
            4. Class Status Eligibility of Plan should be in sync with Template
            5. The Template listed should have same benfit provider as selected on template else Template should not be listed.

            As all the scenarios worked as expected, so closing the jira on Production.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - The enhancement of EDI Utility - New Plan Selection is tested on Wheaton Franciscan Healthcareon company on Production. Scenarios covered during testing are: 1. All Template having same Benefit Type mapped should appear in list 2. Template having new Plan already selected should not appear 3. All templates checked marked should have new plan selected. 4. Class Status Eligibility of Plan should be in sync with Template 5. The Template listed should have same benfit provider as selected on template else Template should not be listed. As all the scenarios worked as expected, so closing the jira on Production.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ganesh Sadawarte (Inactive) made transition -
            New Request Pending for Approval
            107d 20h 29m 1
            Ganesh Sadawarte (Inactive) made transition -
            Pending for Approval Approved for Development
            6s 1
            Ganesh Sadawarte (Inactive) made transition -
            Approved for Development In Development
            4s 1
            Hrishikesh Deshpande (Inactive) made transition -
            In LB Testing Reopen in Local
            1d 1h 15m 1
            Ganesh Sadawarte (Inactive) made transition -
            Reopen in Local In Development
            2h 18m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            14d 5h 34m 2
            Priya Dhamande (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            6d 15h 19m 1
            Priya Dhamande (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            2d 3h 11m 1
            Priya Dhamande (Inactive) made transition -
            Approved for Stage Stage Testing
            8s 1
            Priya Dhamande (Inactive) made transition -
            Stage Testing Pending for Production Approval
            3s 1
            Priya Dhamande (Inactive) made transition -
            Pending for Production Approval Approved for production
            4s 1
            Priya Dhamande (Inactive) made transition -
            Approved for production In Production Testing
            6d 2h 18m 1
            Priya Dhamande (Inactive) made transition -
            In Production Testing Production Complete
            12s 1
            Priya Dhamande (Inactive) made transition -
            Production Complete Closed
            3s 1

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Developer:
              Ganesh Sadawarte (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date: