WORKTERRAProject Type: software

WORKTERRA

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

ACA 2018: IRS External Business rules V1.1 changes

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
    • Environment:
      Production
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Severity:
      Simple

      Description

      IRS External Business rules V1.1 changes.

      Some of the business rules have been added.Added a script for the same.

      New Implementation : Implemented Business rule changes of ACA AIR IRS Submission that were declared on 6th Oct 2017.

      CC: Kumar Chhajed,Smita Pawar

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-11239 ACA 2018 : Changes to XSLT files for IRS Submission

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            ramya.tantry Ramya Tantry (Inactive) created issue -
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Field Original Value New Value
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            Database Objects/MasterCompanyDB/07_Data/538_WT-11817_WTB_ACA_NewData_ACA_IRSExternalBusinessRules.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: Database Objects/MasterCompanyDB/07_Data/538_ WT-11817 _WTB_ACA_NewData_ACA_IRSExternalBusinessRules.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Code Review Date 26/Oct/2017
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Newly added business rules are as follows:

            Rule Number Rule Text
            1094C-095 If Form 1094Cï¾  'CorrectedInd' has a choice of "Yes" indicated, then 'AuthoritativeInd' must have a choice of "Yes" indicated.
            1095B-062-01 If Form 1095B 'CorrectedInd' has a choice of "Yes" indicated, then 'CorrectedUniqueRecordId' must have a value.
            1095B-063-01 If Form 1095B 'CorrectedInd' has a choice of "No" indicated, then 'CorrectedUniqueRecordId' must not have a value.
            1095B-077-02 If Form 1095B 'CorrectedUniqueRecordId' ('ReceiptId' - 'SubmissionId' - 'RecordId') has a value, then the Unique Submission ID portion ('ReceiptId' - 'SubmissionId') must match a Unique Submission ID from a Submission that was previously accepted by IRS.
            1095B-090 Form 1095B 'ResponsibleIndividualName' and 'BirthDt' within 'ResponsibleIndividualGrp' must match the IRS database.
            1095B-091 Form 1095B 'ResponsibleBusinessName' and 'TIN' within 'ResponsibleIndividualGrp' must match the IRS database.
            1095C-055-01 If Form 1095C 'CorrectedInd' has a choice of "Yes" indicated, then 'CorrectedUniqueRecordId' must have a value.
            1095C-056-01 If Form 1095C 'CorrectedInd' has a choice of "No" indicated, then 'CorrectedUniqueRecordId' must not have a value.
            1095C-064-02 If Form 1095C 'CorrectedUniqueRecordId' ('ReceiptId' - 'SubmissionId' - 'RecordId') has a value, then the Unique Submission ID portion ('ReceiptId' - 'SubmissionId') must match a Unique Submission ID from a Submission that was previously accepted by IRS.
            1095C-070 If Form 1095C 'CorrectedUniqueRecordId' is present, then 'TaxYr' must be equal to the 'TaxYr' of the submission that contains the original return.
            MANIFEST-013-01 The value in Manifest 'TotalPayeeRecordCnt' must equal the number of 1095s within the transmission.
            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Newly added business rules are as follows: Rule Number Rule Text 1094C-095 If Form 1094Cï¾  'CorrectedInd' has a choice of "Yes" indicated, then 'AuthoritativeInd' must have a choice of "Yes" indicated. 1095B-062-01 If Form 1095B 'CorrectedInd' has a choice of "Yes" indicated, then 'CorrectedUniqueRecordId' must have a value. 1095B-063-01 If Form 1095B 'CorrectedInd' has a choice of "No" indicated, then 'CorrectedUniqueRecordId' must not have a value. 1095B-077-02 If Form 1095B 'CorrectedUniqueRecordId' ('ReceiptId' - 'SubmissionId' - 'RecordId') has a value, then the Unique Submission ID portion ('ReceiptId' - 'SubmissionId') must match a Unique Submission ID from a Submission that was previously accepted by IRS. 1095B-090 Form 1095B 'ResponsibleIndividualName' and 'BirthDt' within 'ResponsibleIndividualGrp' must match the IRS database. 1095B-091 Form 1095B 'ResponsibleBusinessName' and 'TIN' within 'ResponsibleIndividualGrp' must match the IRS database. 1095C-055-01 If Form 1095C 'CorrectedInd' has a choice of "Yes" indicated, then 'CorrectedUniqueRecordId' must have a value. 1095C-056-01 If Form 1095C 'CorrectedInd' has a choice of "No" indicated, then 'CorrectedUniqueRecordId' must not have a value. 1095C-064-02 If Form 1095C 'CorrectedUniqueRecordId' ('ReceiptId' - 'SubmissionId' - 'RecordId') has a value, then the Unique Submission ID portion ('ReceiptId' - 'SubmissionId') must match a Unique Submission ID from a Submission that was previously accepted by IRS. 1095C-070 If Form 1095C 'CorrectedUniqueRecordId' is present, then 'TaxYr' must be equal to the 'TaxYr' of the submission that contains the original return. MANIFEST-013-01 The value in Manifest 'TotalPayeeRecordCnt' must equal the number of 1095s within the transmission.
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Hi Smita Pawar,

            Please verify this on LB.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Hi Smita Pawar , Please verify this on LB.
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 26/Oct/17 12:42 PM
            • Time Spent:
              4h
               

              Script creation
              Testing
              Code review
              LB and Trunk checkin

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 86736 [ 86736 ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 26/Oct/17 01:02 PM
            • Time Spent:
              0.5h
               

              Code review

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 4h [ 14400 ] 4.5h [ 16200 ]
            Worklog Id 86764 [ 86764 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue relates to WT-11239 [ WT-11239 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified same with sampling testing. Please refer Jira WT-11239 for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified same with sampling testing. Please refer Jira WT-11239 for additional information.
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (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)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Description IRS External Business rules V1.1 changes.

            Some of the business rules have been added.Added a script for the same.


            CC: [~kumar.chhajed],[~smita.pawar]             		IRS External Business rules V1.1 changes.

            Some of the business rules have been added.Added a script for the same.

            ACA 2018 Compliance Changes.These are the changes done for ACA forms (1094 B/C and 1095 B/C) of Tax year 2017 and processing year 2018.

            CC: [~kumar.chhajed],[~smita.pawar]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Description IRS External Business rules V1.1 changes.

            Some of the business rules have been added.Added a script for the same.

            ACA 2018 Compliance Changes.These are the changes done for ACA forms (1094 B/C and 1095 B/C) of Tax year 2017 and processing year 2018.

            CC: [~kumar.chhajed],[~smita.pawar]             		IRS External Business rules V1.1 changes.

            Some of the business rules have been added.Added a script for the same.

            New Implementation : Implemented Business rule changes of ACA AIR IRS Submission that were declared on 6th Oct 2017.

            CC: [~kumar.chhajed],[~smita.pawar]
            khandu.kshirsagar Khandu Kshirsagar (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)
            smita.pawar Smita Pawar (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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 17/Nov/17 01:26 PM
            • Time Spent:
              1h
               

              Stage testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 4.5h [ 16200 ] 5.5h [ 19800 ]
            Worklog Id 91446 [ 91446 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            We have verified above mentioned enhancement on stage [Caiso for Hspl] on sampling testing basis. Please refer jira
            WT-11239 for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited We have verified above mentioned enhancement on stage [Caiso for Hspl] on sampling testing basis. Please refer jira WT-11239 for additional information.
            gaurav.sodani Gaurav Sodani (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)
            Production Due Date 25/Nov/2017
            Stage Due Date 11/Nov/17 [ 2017-11-11 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for production deployment [ 18457 ]
            Epic/Theme ACA
            Labels ACA
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Attachment Re Request for Production deployment - 25 Nov 2017.msg [ 68451 ]
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching production deployment approval email for reference:
            !Re Request for Production deployment - 25 Nov 2017.msg
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching production deployment approval email for reference: !Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Environment Production [ 18442 ]
            khandu.kshirsagar Khandu Kshirsagar (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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 30/Nov/17 04:28 AM
            • Time Spent:
              0.5h
               

              Production testing

            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned enhancement on Production [Caiso for Hspl] on sampling testing basis. Please refer jira
            WT-11239 PRODUCTION TESTING for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned enhancement on Production [Caiso for Hspl] on sampling testing basis. Please refer jira WT-11239 PRODUCTION TESTING for additional information.
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 6h [ 21600 ]
            Worklog Id 93807 [ 93807 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 22/Jan/18 10:06 AM
            • Time Spent:
              0.25h
               

              Internal discussion
              Jira updates

            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 6h [ 21600 ] 6.25h [ 22500 ]
            Worklog Id 101284 [ 101284 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            New Request Pending for Approval
            		10m 38s 1
            Ramya Tantry (Inactive) made transition -
            Pending for Approval Approved for Development
            		3s 1
            Ramya Tantry (Inactive) made transition -
            Approved for Development In Development
            		3s 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            		5h 30m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		18d 21h 8m 1
            Sachin Hingole (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		2m 38s 1
            Sachin Hingole (Inactive) made transition -
            Approved for Stage Stage Testing
            		4m 56s 1
            Smita Pawar (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		15d 21h 1m 1
            Smita Pawar (Inactive) made transition -
            Pending for Production Approval Approved for production
            		2s 1
            Smita Pawar (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Smita Pawar (Inactive) made transition -
            In Production Testing Production Complete
            		53d 5h 39m 1
            Smita Pawar (Inactive) made transition -
            Production Complete Closed
            		33s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              ramya.tantry Ramya Tantry (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              QA:
              Smita Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 6.25h
                  6.25h