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

IRS Report Corrected and replacement on 1095 c

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed

      Description

      As per the current transmittal status.Need to process the corrections and maintain the data with RowID.

      Need to pick up the latest run of the selected transmittal and process all the employees which are error-ed out for this run. if the current run is rejected the pick the previous run which is accept with error for the same.
      if the current run is rejected and all previous run status are not accepted with error then run the 1095 c for complete list of employee.

      Please find the analysis document for the same on main WT-1640 JIRA. Let me know if you need any specific document or algorithm

        Attachments

          Issue Links

            Activity

            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Please share the Task end date and start date in the JIRA.

            Edit -> Estimates section for development

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Please share the Task end date and start date in the JIRA. Edit -> Estimates section for development
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Nandkumar Prabhakar Karlekar

            Please verify below points related to this task.

            Pre-requisite:
            1. There will be a drop down with listing of all submissions/transmission which have status as accepted/accepted with error.
            2. User will select Form status and transmission.
            3. Error related data and related data will be saved in a table in database.

            Tasks:
            1. Check the table if error data related to that report is present or not.
            2. Do not consider rejected status while checking the error data related to that report.
            3. Process only those employees which erred out of that report.
            a. Check for employees in table for that report. Select latest run of the report present in the table.

            • Pick up the latest run of the selected transmittal and process all the employees which are error-ed out for this run.
            • If the latest run is rejected,then pick the previous run which is accepted with error for the same.
            • If the latest run is rejected and all previous run status are not accepted with error then Re-run 1095C for all employees for that report.
              b. Remove all other employees from ACA Employee Filter.
              c. Add only these employees in filter and processing will continue as before.

            In case of accepted status and if user wants to again run the reports,additional criteria of eligibility rule will be modified to accommodate such employees.

            Please add any point if missed.
            I will start with implementation from 4/13/16. I have given tentative estimate as 34 Hrs. Please refer below comment for task breakdown estimate. Total days is 4.5

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Nandkumar Prabhakar Karlekar Please verify below points related to this task. Pre-requisite: 1. There will be a drop down with listing of all submissions/transmission which have status as accepted/accepted with error. 2. User will select Form status and transmission. 3. Error related data and related data will be saved in a table in database. Tasks: 1. Check the table if error data related to that report is present or not. 2. Do not consider rejected status while checking the error data related to that report. 3. Process only those employees which erred out of that report. a. Check for employees in table for that report. Select latest run of the report present in the table. Pick up the latest run of the selected transmittal and process all the employees which are error-ed out for this run. If the latest run is rejected,then pick the previous run which is accepted with error for the same. If the latest run is rejected and all previous run status are not accepted with error then Re-run 1095C for all employees for that report. b. Remove all other employees from ACA Employee Filter. c. Add only these employees in filter and processing will continue as before. In case of accepted status and if user wants to again run the reports,additional criteria of eligibility rule will be modified to accommodate such employees. Please add any point if missed. I will start with implementation from 4/13/16. I have given tentative estimate as 34 Hrs. Please refer below comment for task breakdown estimate. Total days is 4.5
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            1. Check the table if error data related to that report is present or not.

            • create dummy data -2hrs
            • implementing checking functionality- 4hrs
              2. Process only those employees which erred out of that report. -14hrs
              3. Unit Testing: 6hrs
              4. Buffer: 8hrs

            This estimate may change if there are any other priority tasks or there is any other change in the implementation run time.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - 1. Check the table if error data related to that report is present or not. create dummy data -2hrs implementing checking functionality- 4hrs 2. Process only those employees which erred out of that report. -14hrs 3. Unit Testing: 6hrs 4. Buffer: 8hrs This estimate may change if there are any other priority tasks or there is any other change in the implementation run time.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

            You understanding is correct and Estimate also aliened.
            Please go ahead with task progress.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited You understanding is correct and Estimate also aliened. Please go ahead with task progress.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            ---- Adding Nandkumar's response to my changes in 1095C mail
            --------------------------------------------------------------------------
            Hi Ramya,

            Here, we are processing the complete error out employees irrespective of this 1095 c report,

            If there are two Submissions like this and both has been error out against same receipt ID then currently we are processing all 30 for each report. But actually, we need to process 10 records against A/P and 20 Against B/Q separately. So receipt is not an unique Identifier for report but it is for Transmittal only.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited ---- Adding Nandkumar's response to my changes in 1095C mail -------------------------------------------------------------------------- Hi Ramya, Here, we are processing the complete error out employees irrespective of this 1095 c report, If there are two Submissions like this and both has been error out against same receipt ID then currently we are processing all 30 for each report. But actually, we need to process 10 records against A/P and 20 Against B/Q separately. So receipt is not an unique Identifier for report but it is for Transmittal only.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Nandkumar Prabhakar Karlekar,

            Yes. I was working on basic scenario of one 1094C-> one 1095C.
            Thanks for pointing out this scenario.
            Will start working on the same.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Nandkumar Prabhakar Karlekar , Yes. I was working on basic scenario of one 1094C-> one 1095C. Thanks for pointing out this scenario. Will start working on the same.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Nandkumar Prabhakar Karlekar

            please find my estimate in attached excel.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Nandkumar Prabhakar Karlekar please find my estimate in attached excel.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Hi Nandkumar Prabhakar Karlekar,

            I have a query related to one of the scenario's of Partially accepted.

            Please go through below points of retrieving acknowledgement

            • Processing (the IRS has not completed processing the transmission)
            • Accepted (no XML file or MTOM encoded attachment is included)
            • Accepted with errors (an XML file or MTOM encoded attachment is included)
            • Partially Accepted (an XML file or MTOM encoded attachment may or may not be included)
            • Rejected (an XML file or MTOM encoded attachment may or may not be included)
            • Not Found (The Receipt ID in the request was not found)

            In case of Accepted with errors, XML file will be provided so no issue to process erred out employees.
            But in case of partially accepted, XML file may or may not be provided.
            If it is provided and if the error is in 1095C,then those erred out employees will be processed.
            If it is not provided,then how we will know which employees to process.

            Should we process all employees falling in that generic eligibility rule?

            Actually my scenario is like below:
            My original transmission's status was Accepted with errors.
            Next transmission status is rejected.No error file uploaded in this case. For 1095C processing previous run i.e the one with accepted with error will be considered.
            Next transmission is Partially accepted. No error file uploaded in this case.
            Refer screenshot :

            As I am considering both Accepted with errors and Partially accepted status in my code, If no file is provided for latest run whose status is Partially accepted,all employees which fall under generic eligibility rule will be processed.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Hi Nandkumar Prabhakar Karlekar , I have a query related to one of the scenario's of Partially accepted. Please go through below points of retrieving acknowledgement Processing (the IRS has not completed processing the transmission) Accepted (no XML file or MTOM encoded attachment is included) Accepted with errors (an XML file or MTOM encoded attachment is included) Partially Accepted (an XML file or MTOM encoded attachment may or may not be included) Rejected (an XML file or MTOM encoded attachment may or may not be included) Not Found (The Receipt ID in the request was not found) In case of Accepted with errors, XML file will be provided so no issue to process erred out employees. But in case of partially accepted, XML file may or may not be provided. If it is provided and if the error is in 1095C,then those erred out employees will be processed. If it is not provided,then how we will know which employees to process. Should we process all employees falling in that generic eligibility rule? Actually my scenario is like below: My original transmission's status was Accepted with errors. Next transmission status is rejected.No error file uploaded in this case. For 1095C processing previous run i.e the one with accepted with error will be considered. Next transmission is Partially accepted. No error file uploaded in this case. Refer screenshot : As I am considering both Accepted with errors and Partially accepted status in my code, If no file is provided for latest run whose status is Partially accepted,all employees which fall under generic eligibility rule will be processed.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Nandkumar Prabhakar Karlekar

            I have mailed a txt file of correction code.
            Please review the code and let me know if any changes are required.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Nandkumar Prabhakar Karlekar I have mailed a txt file of correction code. Please review the code and let me know if any changes are required.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Ramya Tantry

            Please add the 1095 B also because these scenario applicable for 1095 B also.

            Thanks

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Ramya Tantry Please add the 1095 B also because these scenario applicable for 1095 B also. Thanks
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Sachin Hingole,Smita Pawar,

            Can you please provide me with test cases for this enhancement.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Sachin Hingole , Smita Pawar , Can you please provide me with test cases for this enhancement.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Ramya Tantry, Nandkumar Prabhakar Karlekar,Sachin Hingole

            Please refer WT-1877.
            Once test case writing will complete, we will link this ticket to WT-1877

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Ramya Tantry , Nandkumar Prabhakar Karlekar , Sachin Hingole Please refer WT-1877 . Once test case writing will complete, we will link this ticket to WT-1877
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected

            App/BusinessLogic/InvoiceManagement/IRS1095B.cs
            App/BusinessLogic/InvoiceManagement/IRS1095C.cs
            Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095BData.StoredProcedure.sql
            Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected App/BusinessLogic/InvoiceManagement/IRS1095B.cs App/BusinessLogic/InvoiceManagement/IRS1095C.cs Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095BData.StoredProcedure.sql Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Please verify the enhancment

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Please verify the enhancment
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We will start testing of this Jira once we will complete with testing of Wt-1776

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We will start testing of this Jira once we will complete with testing of Wt-1776
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Efforts = 1hr and will get completed by 24th Jun.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Efforts = 1hr and will get completed by 24th Jun.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            All related issues for this enhancement are closed. Hence closing main ticket of enhancement.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - All related issues for this enhancement are closed. Hence closing main ticket of enhancement.

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: