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

Correction and replacement XML Creation [correction]

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Critical
    • 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

      Sub task of WT-1640.

      Correction and replacement XML Creation, 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
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar,

            For replacement, your matrix says correctedInd is required.Just please confirm is it required? I gone through the correction and replacement document but I did not find the statement that it is required.

            My Observations:
            1. Rejection Type : Transmission
            TransmissionTypeCd='R' .... In Manifest File.
            OriginalReceiptId='<Previous rejected transmission receiptid>' ... In Manifest File .
            OriginalUniqueSubmissionId=Must blank. ... In Form Data File.

            2. Rejection Type : Submission
            TransmissionTypeCd='R' ....In Manifest File.
            OriginalReceiptId=Must blank ... In Manifest File.
            OriginalUniqueSubmissionId='<Previous rejected Submission ID>' ...In Form Data File.

            Kindly confirm.

            Note: There are some uncleared points ,we need to clear by discussing with you in tomorrows call & after that we will update the ETA for replacement.

            Thanks & regards,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , For replacement, your matrix says correctedInd is required.Just please confirm is it required? I gone through the correction and replacement document but I did not find the statement that it is required. My Observations: 1. Rejection Type : Transmission TransmissionTypeCd='R' .... In Manifest File. OriginalReceiptId='<Previous rejected transmission receiptid>' ... In Manifest File . OriginalUniqueSubmissionId=Must blank. ... In Form Data File. 2. Rejection Type : Submission TransmissionTypeCd='R' ....In Manifest File. OriginalReceiptId=Must blank ... In Manifest File. OriginalUniqueSubmissionId='<Previous rejected Submission ID>' ...In Form Data File. Kindly confirm. Note: There are some uncleared points ,we need to clear by discussing with you in tomorrows call & after that we will update the ETA for replacement. Thanks & regards, Revan
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Draft you all the queries in the same JIRA.
            I will provide the answers for the same ASAP.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Draft you all the queries in the same JIRA. I will provide the answers for the same ASAP.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Yes, the correctedInd is not required at the time of Replacement.

            Reference:
            https://www.irs.gov/pub/irs-pdf/p5165.pdf
            Page 48

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Yes, the correctedInd is not required at the time of Replacement. Reference: https://www.irs.gov/pub/irs-pdf/p5165.pdf Page 48
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar,

            Is providing replacement flag when report runs to know that the run is made for replacement purpose like provided the form status Corrected/Void? If not how should I know that the runs run against replacement?

            Thanks

            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , Is providing replacement flag when report runs to know that the run is made for replacement purpose like provided the form status Corrected/Void? If not how should I know that the runs run against replacement? Thanks Revan
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            You can get this input from the Transmittal because at the time of replacement, we are running 1095 report for all Employee and not for selected employee.

            In this scenario no need to change the customization of 1095 c, only just need to re run same as original run if needed in some cases there is no need to run the 1095 c report.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - You can get this input from the Transmittal because at the time of replacement, we are running 1095 report for all Employee and not for selected employee. In this scenario no need to change the customization of 1095 c, only just need to re run same as original run if needed in some cases there is no need to run the 1095 c report.
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Kumar Chhajed,

            Please create a function which will return correction Identification for 1094,1095 by sending parameter as 1094ReportId.

            Pseudocode which you need to use in function.

            1.Get 1094report id
            2.Get FormStatus for report id (get in step 1)
            3.Get 1095reportsId attached to 1094
            4.Get Formstatus is equal to 1 for 1095reportid
            5.
            If 1094_Correction_Status=1 And 1095_Correction_Status=0 Then (using step 2 & 4)
            CorrectionIn=1
            if 1094_Correction_Status=0 And 1095_Correction_Status=1 Then (using step 2 & 4)
            CorrectionIn=2
            if 1094_Correction_Status=1 And 1095_Correction_Status=1 Then (using step 2 & 4)
            CorrectionIn=3
            (Note: 1=Only 1094,2=Only 1095,3=1094+1095)
            6. Return CorrectionIn.

            Reference table : ReportDetailsStatic

            Note : This function will be usable further in [OES_SP_Get_AIR_SUBMISSION_FORM_DATA]

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Kumar Chhajed , Please create a function which will return correction Identification for 1094,1095 by sending parameter as 1094ReportId. Pseudocode which you need to use in function. 1.Get 1094report id 2.Get FormStatus for report id (get in step 1) 3.Get 1095reportsId attached to 1094 4.Get Formstatus is equal to 1 for 1095reportid 5. If 1094_Correction_Status=1 And 1095_Correction_Status=0 Then (using step 2 & 4) CorrectionIn=1 if 1094_Correction_Status=0 And 1095_Correction_Status=1 Then (using step 2 & 4) CorrectionIn=2 if 1094_Correction_Status=1 And 1095_Correction_Status=1 Then (using step 2 & 4) CorrectionIn=3 (Note: 1=Only 1094,2=Only 1095,3=1094+1095) 6. Return CorrectionIn. Reference table : ReportDetailsStatic Note : This function will be usable further in [OES_SP_Get_AIR_SUBMISSION_FORM_DATA]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Kumar Chhajed,

            Steps Of Replacement:
            Type-1: Transmission Replacement

            Pre-requisite -Acknowledgement Status is Rejected Against Original Submission

            Psedu steps:
            1.Do correct as per suggested changes in Error Analysis Report.
            2.Select option of 'Replacement' from DropDown
            3.Verify Submission Data
            ReplacementType Parameter Value="T-R" i.e. Transmission Replacement Process( will generate file as per T.R. Rule spec of C&R Doc)

            Type-2: Submission Replacement
            Pre-requisite -Acknowledgement Status is Partially Accepted Against Original Submission

            Psedu steps:
            1.Do correct as per suggested changes in Error Analysis Report.
            2.Select option of 'Replacement' from DropDown
            3.Verify Submission Data
            ReplacementType Parameter Value="S-R" i.e. Submission Level Replacement Process( will generate file as per S.R. Rule spec of C&R Doc)

            You need to send the value to sp as above mentioned for ReplacementType Parameter.

            Thanks & Regards,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Kumar Chhajed , Steps Of Replacement: Type-1: Transmission Replacement Pre-requisite -Acknowledgement Status is Rejected Against Original Submission Psedu steps: 1.Do correct as per suggested changes in Error Analysis Report. 2.Select option of 'Replacement' from DropDown 3.Verify Submission Data ReplacementType Parameter Value="T-R" i.e. Transmission Replacement Process( will generate file as per T.R. Rule spec of C&R Doc) Type-2: Submission Replacement Pre-requisite -Acknowledgement Status is Partially Accepted Against Original Submission Psedu steps: 1.Do correct as per suggested changes in Error Analysis Report. 2.Select option of 'Replacement' from DropDown 3.Verify Submission Data ReplacementType Parameter Value="S-R" i.e. Submission Level Replacement Process( will generate file as per S.R. Rule spec of C&R Doc) You need to send the value to sp as above mentioned for ReplacementType Parameter. Thanks & Regards, Revan
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Kumar Chhajed, Ramya Tantry,Yogesh Chaudhari,Abhijeet Khandagale,Nandkumar Prabhakar Karlekar,Sachin Hingole
            Hi All,

            As we discussed for below scenario & cleared with Nandkumar,

            Under a Transmission
            Status: Partially Accepted Scenario for replacement

            Submission-1: Accepted
            Submission-2:Rejected
            Submission-3:Accepted
            Submission-4:Rejected

            When replacing above rejection..steps:->

            1.User will select only rejected submissions in the customization & other will deselect & finalize it by necessary corrective actions.
            2.On UI Submission -> Select Option of Replacement as TransmissionType ->Verify Submission

            FYI.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Kumar Chhajed , Ramya Tantry , Yogesh Chaudhari , Abhijeet Khandagale , Nandkumar Prabhakar Karlekar , Sachin Hingole Hi All, As we discussed for below scenario & cleared with Nandkumar, Under a Transmission Status: Partially Accepted Scenario for replacement Submission-1: Accepted Submission-2:Rejected Submission-3:Accepted Submission-4:Rejected When replacing above rejection..steps:-> 1.User will select only rejected submissions in the customization & other will deselect & finalize it by necessary corrective actions. 2.On UI Submission -> Select Option of Replacement as TransmissionType ->Verify Submission FYI. Thanks, Revan
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Task Break :

            Data retrieval by reading error file (1094,1095,1094+1095) : 30 hrs
            Business logic +xml+xslt : 32 hrs
            Unit Testing : 16 hrs
            Buffer Period : 12 hrs
            =========================================================================
            Total : 90 hrs
            Days : Approx 12 Days (8 hrs/Day)
            Start Date : 6.04.2016
            End Date : 22.04.2016
            Leave/Holiday : 8.04 Holiday.
            +
            Accepted,Partially Accepted,Rejected.
            Business logic +xml+xslt+sp : 24 hrs
            Unit testing : 8 hours
            End date : 28.04.2015

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Task Break : Data retrieval by reading error file (1094,1095,1094+1095) : 30 hrs Business logic +xml+xslt : 32 hrs Unit Testing : 16 hrs Buffer Period : 12 hrs ========================================================================= Total : 90 hrs Days : Approx 12 Days (8 hrs/Day) Start Date : 6.04.2016 End Date : 22.04.2016 Leave/Holiday : 8.04 Holiday. + Accepted,Partially Accepted,Rejected. Business logic +xml+xslt+sp : 24 hrs Unit testing : 8 hours End date : 28.04.2015
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Kumar Chhajed, Ramya Tantry, Abhijeet Khandagale, Yogesh Chaudhari

            New Properties Introduced in values objects.
            1. TransmissionTypeCd : Possible Values- C(Correction), R(Replacement),O (Original).
            2. Correcting_ACA_IRSSubmissionHistoryID- Correcting Irs Submission History Id .

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Kumar Chhajed , Ramya Tantry , Abhijeet Khandagale , Yogesh Chaudhari New Properties Introduced in values objects. 1. TransmissionTypeCd : Possible Values- C(Correction), R(Replacement),O (Original). 2. Correcting_ACA_IRSSubmissionHistoryID- Correcting Irs Submission History Id .
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Nandkumar Prabhakar Karlekar Kumar Chhajed Yogesh Chaudhari Ramya Tantry Abhijeet Khandagale

            Hi Nandkumar,

            While creating manual correction file we came to below additional observations and accordingly we are going to implement the same which was not covered in the correction and replacement document of IRS.

            if only correction in 1094 B/C
            Then
            <Form1095CAttachedCnt>#Must be zero#</Form1095CAttachedCnt> (FORM-C)
            if only correction 1095 c
            <Form1095CAttachedCnt>#Must be corrected attached 1095 elements count#</Form1095CAttachedCnt> (FORM-C)

            FYI.

            Thanks & regards,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Nandkumar Prabhakar Karlekar Kumar Chhajed Yogesh Chaudhari Ramya Tantry Abhijeet Khandagale Hi Nandkumar, While creating manual correction file we came to below additional observations and accordingly we are going to implement the same which was not covered in the correction and replacement document of IRS. if only correction in 1094 B/C Then <Form1095CAttachedCnt> #Must be zero# </Form1095CAttachedCnt> (FORM-C) if only correction 1095 c <Form1095CAttachedCnt> #Must be corrected attached 1095 elements count# </Form1095CAttachedCnt> (FORM-C) FYI. Thanks & regards, Revan
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Please find the attachment for Task Estimate. Task Estimation.xls

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Please find the attachment for Task Estimate. Task Estimation.xls
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - - edited

            Hi Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur

            Please find attached Test case for Correction and Error Code. Please review the same and let us know any suggestion.

            Attached excel has two tab 1. Correction_UI_Submission
            2. Error_Code_For_Correction

            Note - 1. Correction - In depth scenario like - Accepted transmission then Accepted with error
            then Rejected etc. for same Transmission
            2. Error Code scenario for 1095 C is in progress

            Thanks,
            Mahendra

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - - edited Hi Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Please find attached Test case for Correction and Error Code. Please review the same and let us know any suggestion. Attached excel has two tab 1. Correction_UI_Submission 2. Error_Code_For_Correction Note - 1. Correction - In depth scenario like - Accepted transmission then Accepted with error then Rejected etc. for same Transmission 2. Error Code scenario for 1095 C is in progress Thanks, Mahendra
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Revansiddha Gaur

            Can we display the transmission file summary in the following format for every run.

            Transmission summary Popup per run.

            Sr.no 1094 name 1095 name Count of 1095 record.
            1 x p 190
            2 y q 157
            3 z r 1584

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Revansiddha Gaur Can we display the transmission file summary in the following format for every run. Transmission summary Popup per run. Sr.no 1094 name 1095 name Count of 1095 record. 1 x p 190 2 y q 157 3 z r 1584
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Sachin Hingole,Revansiddha Gaur,Revansiddha Gaur

            I have reviewed the test cases , I think we need to discussed the test case scope and execution planning.
            We need to add the more test cases..
            Also need to be share the Estimate and schedule ASAP .

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Sachin Hingole , Revansiddha Gaur , Revansiddha Gaur I have reviewed the test cases , I think we need to discussed the test case scope and execution planning. We need to add the more test cases.. Also need to be share the Estimate and schedule ASAP .
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Revansiddha Gaur

            Can we display the transmission file summary in the following format for every run.
            Transmission summary Popup per run.
            Sr.no 1094 name 1095 name Count of 1095 record.
            1 x p 190
            2 y q 157
            3 z r 1584

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Revansiddha Gaur Can we display the transmission file summary in the following format for every run. Transmission summary Popup per run. Sr.no 1094 name 1095 name Count of 1095 record. 1 x p 190 2 y q 157 3 z r 1584
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited
            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Nandkumar Prabhakar Karlekar , Yes we can . Jira Item created for this https://workterra.atlassian.net/browse/WT-2082

              People

              Assignee:
              mahendra.mungase Mahendra Mungase (Inactive)
              Reporter:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date: